Skip to main content
Skip table of contents


This table stores preferred student name data.

Column Name


Data Type





Primary Key

Effective_Date13.0.0TIMESTAMP(6)The date and time the record is valid. Defaults to system date
First_Name13.0.0Varchar2(50)Student's first name.
Is_Name_Exact13.0.0NUMBER(1,0)Indicates whether this name is exactly as it appears on the student's documentation. Valid values: 1=Yes, 0=No. Required.
Last_Name13.0.0Varchar2(50)Student's last name.
Middle_Name13.0.0Varchar2(50)Student's middle name.

Unique system identifier.

Suffix13.0.0Varchar2(15)Student's name suffix.

Indicates whether this name is the legal name or other name. Required.

Student_InfoID13.0.0NUMBER(19,0)The AB_STUDENT_INFOID from the AB_STUDENT_INFO table.
WhoCreated13.0.0Varchar2(100)The date and time the record was modified. Defaults to system date
WhenCreated13.0.0TIMESTAMP(6)The date and time the record was created. Defaults to system date.
WhoModified13.0.0Varchar2(100)The name of person who modified the record. Defaults to user.
WhenModified13.0.0TIMESTAMP(6)The date and time the record was modified. Defaults to system date
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.