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 |