AB_SECONDARY_ASN
This table stores secondary Alberta student number data.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_Secondary_ASNID | 13.0.0 | NUMBER(19,0) | Primary Key |
| 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. |
| Student_InfoID | 13.0.0 | Varchar2(20) | 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 |