AB_STUDENT_IDENT_INFO
This table stores student identification information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_Student_Ident_InfoID | 13.0.0 | NUMBER(19,0) | Primary Key |
| Birth_Date | 13.0.0 | TIMESTAMP(6) | Date of birth. |
| Doc_Number | 13.0.0 | Varchar2(15) | Indicates the document number of the documentation provided by the student. |
| Doc_Type | 13.0.0 | Varchar2(50) | Indicates the type of documentation provided by the student. |
| Effective_UTC | 13.0.0 | TIMESTAMP(6) | The date and time the record was effective. Defaults to system date |
| First_Name | 13.0.0 | Varchar2(50) | Student's first name. |
| Gender | 13.0.0 | Varchar2(1) | Student's gender. |
| Is_Name_Exact | 13.0.0 | NUMBER(1,0) | Indicates whether this is exactly the same as it appears on the student's documentation. Valid values: 1=Yes, 0=No. Required. |
| Issued_Date | 13.0.0 | TIMESTAMP(6) | The date and time the student documentation was issued. Defaults to system date |
| Last_Name | 13.0.0 | Varchar2(50) | Student's last name. |
| Middle_Name | 13.0.0 | Varchar2(50) | Student's middle name. |
| RefID | 13.0.0 | NUMBER(10,0) | Unique system identifier. |
| Suffix | 13.0.0 | Varchar2(15) | Student's name suffix. |
| 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 |