PSSIS_Stu_Contact_Hist (ver12.0.1)
This view may be used for querying the student contact schema. It returns all (historical) association details for a student's contacts.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
StudentDCID | 12.0.1 | Number(10,0) | [From Students] The internal DCID for the student this record is associated. Indexed. |
ContactPersonID | 12.0.1 | Number(16,0) | [From Person] The contact's internal ID in the Person table. Indexed. |
ContactPersonDCID | 12.0.1 | Number(16,0) | [From Person] The contact's internal DCID in the Person table. Indexed. |
StudentContactAssocID | 12.0.1 | Number(16,0) | [From StudentContactAssoc] The primary key for a student contact association. Indexed. |
StateContactID | 12.0.1 | Varchar2(40) | [From Person] The contact's state identifier (alphanumeric). |
StateContactNumber | 12.0.1 | Number(19,0) | [From Person] The contact's state number. Indexed. |
ContactLastFirst | 12.0.1 | Varchar2(130) | The last, first and middle name of the contact, appended together. |
ContactFirstName | 12.0.1 | Varchar2(50) | [From Person] The first name of the contact. |
ContactMiddleName | 12.0.1 | Varchar2(30) | [From Person] The middle name of the contact. |
ContactLastName | 12.0.1 | Varchar2(50) | [From Person] The last name of the contact. |
PrefixCodeSetID | 12.0.1 | Number(16,0) | [From CodeSet] The internal ID for the contact name prefix code in the CodeSet table. Indexed. |
ContactNamePrefix | 12.0.1 | Varchar2(40) | [From CodeSet] The contact's name prefix code. |
ContactNamePrefixDesc | 12.0.1 | Varchar2(2000) | [From CodeSet] The contact's name prefix code description. |
ContactNamePrefixDisp | 12.0.1 | Varchar2(100) | [From CodeSet] The contact's name prefix code display value. |
SuffixCodeSetID | 12.0.1 | Number(16,0) | [From CodeSet] The internal ID for the contact name suffix code in the CodeSet table. Indexed. |
ContactNameSuffix | 12.0.1 | Varchar2(40) | [From CodeSet] The contact's name suffix code. Indexed. |
ContactNameSuffixDesc | 12.0.1 | Varchar2(2000) | [From CodeSet] The contact's name suffix code description. |
ContactNameSuffixDisp | 12.0.1 | Varchar2(100) | [From CodeSet] The contact's name suffix code display value. |
GenderCodeSetID | 12.0.1 | Number(16,0) | [From CodeSet] The internal ID for the contact gender code in the CodeSet table. Indexed. |
ContactGender | 12.0.1 | Varchar2(40) | [From CodeSet] The contact's gender code. Indexed. |
ContactGenderDesc | 12.0.1 | Varchar2(2000) | [From CodeSet] The contact's gender code description. |
ContactGenderDisp | 12.0.1 | Varchar2(100) | [From CodeSet] The contact's gender code display value. |
CurrRelationshipCodeSetID | 12.0.1 | Number(16,0) | [From CodeSet] The internal ID for the current relationship code in the CodeSet table. Indexed. |
CurrContactRelationship | 12.0.1 | Varchar2(40) | [From CodeSet] The current relationship code. Indexed. |
CurrContactRelationshipDesc | 12.0.1 | Varchar2(2000) | [From CodeSet] The current relationship code description. |
CurrContactRelationshipDisp | 12.0.1 | Varchar2(100) | [From CodeSet] The current relationship code display value. |
RelationshipCodeSetID | 12.0.1 | Number(16,0) | [From CodeSet] The internal ID for the (historical) relationship code in the CodeSet table. Indexed. |
ContactRelationship | 12.0.1 | Varchar2(40) | [From CodeSet] The (historical) relationship code. Indexed. |
ContactRelationshipDesc | 12.0.1 | Varchar2(2000) | [From CodeSet] The (historical) relationship code description. |
ContactRelationshipDisp | 12.0.1 | Varchar2(100) | [From CodeSet] The (historical) relationship code display value. |
RelationshipStartDate | 12.0.1 | Date | [From StudentContactDetail] The (historical) relationship start date. Indexed. |
RelationshipEndDate | 12.0.1 | Date | [From StudentContactDetail] The (historical) relationship end date. |
ContactPriorityOrder | 12.0.1 | Number(10,0) | [From StudentContactAssoc] The original priority (sort) order of the contact in relation to the student. |
IsActive | 12.0.1 | Number(1,0) | [From StudentContactDetail] Indicates whether this is the active historical detail record for the student contact association. There should only be one active record at a time for a given student contact association. |
IsEmergency | 12.0.1 | Number(1,0) | [From StudentContactDetail] Indicates whether the contact is an emergency contact for the student. |
IsCustodial | 12.0.1 | Number(1,0) | [From StudentContactDetail] Indicates whether the contact has custody of the student. |
LivesWithFlg | 12.0.1 | Number(1,0) | [From StudentContactDetail] Indicates whether the student lives with the contact. |
SchoolPckupFlg | 12.0.1 | Number(1,0) | [From StudentContactDetail] Indicates whether the contact is allowed to pick up the student from school. |
ReceivesMailFlg | 12.0.1 | Number(1,0) | [From StudentContactDetail] Indicates whether the contact receives mail on behalf of the student. |
Employer | 12.0.1 | Varchar2(400) | [From Person] The employer of the contact. |
ExcludeFromStateReportingFlg | 12.0.1 | Number(1,0) | [From StudentContactDetail] Indicates whether the particular (historical) detail record should be excluded from state reporting. |
ExcludeFromStateReporting | 12.0.1 | Number(1,0) | [From Person] Indicates whether the contact should be excluded from state reporting. |