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_UTC | 13.0.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date |
| Date_Of_Death | 13.0.0 | TIMESTAMP(6)(20) | Date of student's death (if applicable). |
| Effective_UTC | 13.0.0 | TIMESTAMP(6) | The date and time the record was effective. Defaults to system date |
| Deactivated | 13.0.0 | NUMBER(1,0) | Indicates whether this student is inactive in PASI. Valid values: 1=Yes, 0=No. Required. |
| Deceased | 13.0.0 | NUMBER(1,0) | Indicates whether this student is deceased. Valid values: 1=Yes, 0=No. Required. |
| PASI_Core_Version | 13.0.0 | NUMBER(19,0) | Unique number allowing easy identification of when an entity has changed. |
| Primary_State_Province_ID | 13.0.0 | Varchar2(20) | The primary provincial-assigned student number for the student. In most cases, this number should stay the same from school to school. |
| Section23_Elig | 13.0.0 | Varchar2(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_ID | 13.0.0 | Varchar2(20) | The provincial-assigned student number for the student. In most cases, this number should stay the same from school to school. |
| WhoCreated | 13.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. |
| WhenCreated | 13.0.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 13.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |
| WhenModified | 13.0.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date |