Skip to main content
Skip table of contents


This table stores Student Phone Number List data - includes phone numbers other than the preferred phone.

Column Name


Data Type





Primary Key

Effective_Date13.0.0TIMESTAMP(6)Date this phone number is valid.
Expiry_Date13.0.0TIMESTAMP(6)Date this phone number is invalid.
Ext13.0.0Varchar2(7)Student's extension (if applicable).
Is_Listable13.0.0Varchar2(1)Indicates whether this phone number is listable.
Phone_Number13.0.0Varchar2(16)Student's phone number.
RefID13.0.0NUMBER(19,0)Unique system identifier.
Phone_Type13.0.0Varchar2(15)Indicates the type of phone number.
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
List_Position13.0.0NUMBER(2,0)Indicates the position this record appears in the phone number list in ascending order.
JavaScript errors detected

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

If this problem persists, please contact our support.