AB_STU_EXTERN_CREDNTL
This table stores student external credential data – for future use.
Column Name | Version | Data Type | Description |
---|---|---|---|
AB_Stu_Extern_CredntlID | 16.5.0 | NUMBER | Primary Key |
AB_Student_Trans_DtlID | 16.5.0 | NUMBER | The AB_STUDENT_TRANS_DTLID from the AB_STUDENT_TRANS_DTL table. |
Awarded_Date | 16.5.0 | DATE | Date this external credential is awarded. |
Effective_UTC | 16.5.0 | DATE | Date this record is valid. |
Extern_Credntl_Code | 16.5.0 | Varchar2(80) | Indicates the external credential's code. |
Deleted | 16.5.0 | NUMBER(38,0) | Indicates if the external credential is deleted. |
PASI_CoreVersion | 16.5.0 | NUMBER | Unique number allowing easy identification of when an entity has changed. |
State_Province_ID | 16.5.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 | 16.5.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. |
WhenCreated | 16.5.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
WhoModified | 16.5.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |
WhenModified | 16.5.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date |