PSSIS_Person_Phone_Type (ver12.0.1)
This view may be used for querying the student contact schema. It returns only the highest priority phone Numberby type among a person's associated phone numbers.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
PersonDCID | 12.0.1 | Number(16,0) | [From Person] The person's internal DCID in the Person table. Indexed. |
PersonID | 12.0.1 | Number(16,0) | [From Person] The person's internal ID in the Person table. Indexed. |
PersonPhoneNumberAssocID | 12.0.1 | Number(16,0) | [From PersonPhoneNumberAssoc] The primary key for a person phone Numberassociation. Indexed. |
PhoneTypeCodeSetID | 12.0.1 | Number(16,0) | [From CodeSet] The internal ID for the phone type code in the CodeSet table. Indexed. |
PhoneType | 12.0.1 | Varchar2(40) | [From CodeSet] The phone type code. |
PhoneTypeDesc | 12.0.1 | Varchar2(2000) | [From CodeSet] The phone type code description. |
PhoneTypeDisp | 12.0.1 | Varchar2(100) | [From CodeSet] The phone type code display value. |
PhoneNumberPriorityOrder | 12.0.1 | Number(10,0) | [From PersonPhoneNumberAssoc] The original priority (sort) order of the person's phone number. |
FilteredPriorityOrder | 12.0.1 | Number(10,0) | The filtered priority (sort) order of the person's phone Numberfor the given constraints of the view. Guaranteed to start with 1 and be consecutive. |
IsPreferred | 12.0.1 | Number(1,0) | [From PersonPhoneNumberAssoc] Indicates whether this is a preferred phone number. |
PhoneNumberAsEntered | 12.0.1 | Varchar2(50) | [From PhoneNumber] The phone Numberas entered. |
PhoneNumber | 12.0.1 | Varchar2(50) | [From PhoneNumber] The phone number. |
PhoneNumberExt | 12.0.1 | Varchar2(10) | [From PhoneNumber] The phone Numberextension (if specified). |
IsSMS | 12.0.1 | Number(1,0) | [From PhoneNumber] Indicates whether this phone is capable of receiving SMS messages. |