AB_PREF_STUDENT_NAME
This table stores preferred student name data.
Column Name | Version | Data Type | Description |
---|---|---|---|
AB_Pref_Student_NameID | 13.0.0 | NUMBER(19,0) | Primary Key |
Effective_Date | 13.0.0 | TIMESTAMP(6) | The date and time the record is valid. Defaults to system date |
First_Name | 13.0.0 | Varchar2(50) | Student's first name. |
Is_Name_Exact | 13.0.0 | NUMBER(1,0) | Indicates whether this name is exactly as it appears on the student's documentation. Valid values: 1=Yes, 0=No. Required. |
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. |
Name_Type | 13.0.0 | Varchar2(15) | Indicates whether this name is the legal name or other name. Required. |
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 date and time the record was modified. Defaults to system date |
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 |