Skip to main content
Skip table of contents

AB_STUDENT_INFO

This table stores Student Information – includes Section 23 eligibility and deceased status.

Column Name

Version

Data Type

Description

AB_Student_InfoID

13.0.0

NUMBER(19,0)

Primary Key

Created_On_UTC13.0.0TIMESTAMP(6)The date and time the record was created. Defaults to system date
Date_Of_Death13.0.0TIMESTAMP(6)(20)Date of student's death (if applicable).
Effective_UTC13.0.0TIMESTAMP(6)The date and time the record was effective. Defaults to system date
Deactivated13.0.0NUMBER(1,0)Indicates whether this student is inactive in PASI. Valid values: 1=Yes, 0=No. Required.
Deceased13.0.0NUMBER(1,0)Indicates whether this student is deceased. Valid values: 1=Yes, 0=No. Required.
PASI_Core_Version13.0.0NUMBER(19,0)Unique number allowing easy identification of when an entity has changed.
Primary_State_Province_ID13.0.0Varchar2(20)The primary provincial-assigned student number for the student. In most cases, this number should stay the same from school to school.
Section23_Elig13.0.0Varchar2(1)Indicates whether this student is eligible for section 23. Valid Values: Y=Eligible, B=Ineligible, C=Eligibility is unknown or not provided.
State_Province_ID13.0.0Varchar2(20)The provincial-assigned student number for the student. In most cases, this number should stay the same from school to school.
WhoCreated13.0.0Varchar2(100)The name of the person who created the record. Defaults to user.
WhenCreated13.0.0TIMESTAMP(6)The date and time the record was created. Defaults to system date.
WhoModified13.0.0Varchar2(100)The name of person who modified the record. Defaults to user.
WhenModified13.0.0TIMESTAMP(6)The date and time the record was modified. Defaults to system date
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.