S_STU_PHONE_C
This is a child table of Students table that stores student's phones.
Column Name | Version | Data Type | Description |
---|---|---|---|
ID | 22.7.1 | Number(10,0) | Primary Key |
STUDENTSDCID | 22.7.1 | Number(10,0) | DCID of the Students table. |
EFFECTIVEDATE | 22.7.1 | DATE | The date the phone number is in effect |
EXPIRYDATE | 22.7.1 | DATE | The date the phone number expires |
EXTENSION | 22.7.1 | VARCHAR2(7 CHAR) | The phone number extension |
ISLISTABLE | 22.7.1 | VARCHAR2(1 CHAR) | True if the phone number is listed in public phone directories |
PHONENUMBER | 22.7.1 | VARCHAR2(20 CHAR) | The phone number |
PHONETYPE | 22.7.1 | VARCHAR2(10 CHAR) | The type of phone number |
ORGCODE | 22.7.1 | NUMBER(11) | The organization code used in caller info of PASI submission |
REFID | 22.7.1 | NUMBER(11,0) | The unique identifier for the phone record |
EXPIRED | 22.7.1 | NUMBER(1) | Expired flag |
PREFERRED | 22.7.1 | PREFERRED | Preferred flag |
WhoCreated | 22.7.1 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
WhenCreated | 22.7.1 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhoModified | 22.7.1 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
WhenModified | 22.7.1 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |