Skip to main content
Skip table of contents


This table stores the preferred student address information.

Column Name


Data Type





Primary Key

City13.0.0Varchar2(60)The city element of the address.
Country13.0.0Varchar2(60)The county of residence.
Effective_Date13.0.0TIMESTAMP(6)The date and time the record was effective. Defaults to system date
Expiry_Date13.0.0TIMESTAMP(6)The date and time the record expired. Defaults to system date
PostalL_Code13.0.0Varchar2(15)The postal code element of the address.

Unique system identifier.

State_Province13.0.0Varchar2(20)The province element of the address.
Street13.0.0Varchar2(140)The street element (number and name). Usually line one of the address.
Address_Type13.0.0Varchar2(15)Indicates the address type.
Student_InfoID13.0.0NUMBER(19,0)The AB_STUDENT_INFOID from the AB_STUDENT_INFO table.
WhoCreated13.0.0Varchar2(100)The name of the person who created the record. Defaults to user.
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.