AB_PREF_STUDENT_PHONE_NUMBER
This table stores preferred student phone number data.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_Pref_Student_Phone_NumberID | 13.0.0 | NUMBER(19,0) | Primary Key |
| Effective_Date | 13.0.0 | TIMESTAMP(6) | The date and time the record is valid. Defaults to system date |
| Expiry_Date | 13.0.0 | TIMESTAMP(6) | The date and time the record becomes invalid. Defaults to system date |
| Ext | 13.0.0 | Varchar2(7) | Student's extension (if applicable). |
| Is_Listable | 13.0.0 | Varchar2(1) | Indicates whether this phone number is listable. |
| Phone_Number | 13.0.0 | Varchar2(16) | Student's phone number |
| RefID | 13.0.0 | NUMBER(10,0) | Unique system identifier. |
| PhoneE_Type | 13.0.0 | Varchar2(15) | Indicates the type of phone number. |
| Student_InfoID | 13.0.0 | NUMBER(19,0) | The AB_STUDENT_INFOID from the AB_STUDENT_INFO table. |
| WhoCreated | 13.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. |
| WhenCreated | 13.0.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 13.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |
| WhenModified | 13.0.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date |