AB_STUDENT_CITIZENSHIP_INFO
This table stores student citizenship information.
Column Name | Version | Data Type | Description |
---|---|---|---|
AB_Student_Citizenship_InfoID | 13.0.0 | NUMBER(19,0) | Primary Key |
Status | 13.0.0 | Varchar2(1) | Indicates the status of the student's citizenship. Valid values: 1=Canadian Citizen, 2=Permanent Resident, 5=Temporary Resident - Student, 6=Child of a Canadian Citizen, 7=Child of a Resident, 9=Other/Unknown. |
Effective_UTC | 13.0.0 | TIMESTAMP(6) | The date and time the record is valid. Defaults to system date. |
RefID | 13.0.0 | NUMBER(10,0) | Unique system identifier. |
Expiry_Date | 13.0.0 | TIMESTAMP(6) | Date the citizenship becomes invalid. Required when Status = 5 or 9. |
Student_InfoID | 13.0.0 | NUMBER(19,0) | The AB_STUDENT_INFOID from the AB_STUDENT_INFO table. |
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 |
List_Position | 13.0.0 | NUMBER(2,0) | Indicates the position this record appears in the citizenship list in ascending order. |