PSSIS_Person_Email_Type (ver12.0.1)
This view may be used for querying the student contact schema. It returns only the highest priority email address by type among a person's associated email addresses.
| 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. |
PersonEmailAddressAssocID | 12.0.1 | Number(16,0) | [From PersonEmailAddressAssoc] The primary key for a person email address association. Indexed. |
EmailTypeCodeSetID | 12.0.1 | Number(16,0) | [From CodeSet] The internal ID for the email type code in the CodeSet table. Indexed. |
EmailType | 12.0.1 | Varchar2(40) | [From CodeSet] The email type code. |
EmailTypeDesc | 12.0.1 | Varchar2(2000) | [From CodeSet] The email type code description. |
EmailTypeDisp | 12.0.1 | Varchar2(100) | [From CodeSet] The email type code display value. |
EmailAddressPriorityOrder | 12.0.1 | Number(10,0) | [From PersonEmailAddressAssoc] The original priority (sort) order of the person's email address. |
FilteredPriorityOrder | 12.0.1 | Number(10,0) | The filtered priority (sort) order of the person's email address for the given constraints of the view. Guaranteed to start with 1 and be consecutive. |
IsPrimaryEmailAddress | 12.0.1 | Number(1,0) | [From PersonEmailAddressAssoc] Indicates whether this is the person's primary email address. The system allows only one primary email address for a person at a time. |
EmailAddress | 12.0.1 | Varchar2(255) | [From EmailAddress] An email address for a person. |