S_AB_STU_NAME_C
This is a child table of Students table that stores student’s names.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 23.7.3 | Number(10,0) | Primary Key |
STUDENTSDCID | 23.7.3 | Number(10,0) | DCID of the Students table. |
LASTNAME | 23.7.3 | VARCHAR2(50 CHAR) | Last name |
FIRSTNAME | 23.7.3 | VARCHAR2(50 CHAR) | First name |
MIDDLENAME | 23.7.3 | VARCHAR2(50 CHAR) | Middle name |
SUFFIX | 23.7.3 | VARCHAR2(10 CHAR) | Suffix |
ORGCODE | 23.7.3 | NUMBER(11,0) | The organization code used in caller info of PASI submission |
REFID | 23.7.3 | NUMBER(11,0) | The unique identifier for the name record |
LEGAL | 23.7.3 | NUMBER(1,0) | Legal flag |
PREFERRED | 23.7.3 | NUMBER(1,0) | Preferred flag |
SOURCE | 23.7.3 | VARCHAR2(100 CHAR) | Source of the record update |
WhoCreated | 23.7.3 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
WhenCreated | 23.7.3 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhoModified | 23.7.3 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
WhenModified | 23.7.3 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |