Skip to main content
Skip table of contents


This is a child table of Students table that stores student's phones.

Column Name


Data Type


ID22.7.1Number(10,0)Primary Key




DCID of the Students table.
EFFECTIVEDATE22.7.1DATEThe date the phone number is in effect
EXPIRYDATE22.7.1DATEThe date the phone number expires
EXTENSION22.7.1VARCHAR2(7 CHAR)The phone number extension
ISLISTABLE22.7.1VARCHAR2(1 CHAR)True if the phone number is listed in public phone directories

The phone number

PHONETYPE22.7.1VARCHAR2(10 CHAR)The type of phone number
ORGCODE22.7.1NUMBER(11)The organization code used in caller info of PASI submission
REFID22.7.1NUMBER(11,0)The unique identifier for the phone record
EXPIRED22.7.1NUMBER(1)Expired flag
PREFERRED22.7.1PREFERREDPreferred flag
WhoCreated22.7.1Varchar2(100)The name of the person who created the record. Defaults to the user.
WhenCreated22.7.1Timestamp(6)The date and time the record was created. Defaults to system date.
WhoModified22.7.1Varchar2(100)The name of the person who modified the record. Defaults to the user.
WhenModified22.7.1Timestamp(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.