PSSIS_Person_Address (ver12.0.1)
This view may be used for querying the student contact schema. It returns all of a person's associated 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. |
PersonAddressAssocID | 12.0.1 | Number(16,0) | [From PersonAddressAssoc] The primary key for a person address association. Indexed. |
AddressTypeCodeSetID | 12.0.1 | Number(16,0) | [From CodeSet] The internal ID for the address type code in the CodeSet table. Indexed. |
AddressType | 12.0.1 | Varchar2(40) | [From CodeSet] The address type code. |
AddressTypeDesc | 12.0.1 | Varchar2(2000) | [From CodeSet] The address type code description. |
AddressTypeDisp | 12.0.1 | Varchar2(100) | [From CodeSet] The address type code display value. |
AddressPriorityOrder | 12.0.1 | Number(10,0) | [From PersonAddressAssoc] The original priority (sort) order of the person's address. |
Street | 12.0.1 | Varchar2(100) | [From PersonAddress] The street component of the address. |
LineTwo | 12.0.1 | Varchar2(100) | [From PersonAddress] The second line of the street component of the address. |
Unit | 12.0.1 | Varchar2(30) | [From PersonAddress] The unit identifier component of the address. |
City | 12.0.1 | Varchar2(100) | [From PersonAddress] The city component of the address. |
StateCodeSetID | 12.0.1 | Number(16,0) | [From CodeSet] The internal ID for the state code in the CodeSet table. Indexed. |
State | 12.0.1 | Varchar2(40) | [From CodeSet] The address state code. |
StateDesc | 12.0.1 | Varchar2(2000) | [From CodeSet] The address state code description. |
StateDisp | 12.0.1 | Varchar2(100) | [From CodeSet] The address state code display value. |
PostalCode | 12.0.1 | Varchar2(10) | [From PersonAddress] The postal (zip) code. |
CountryCodeSetID | 12.0.1 | Number(16,0) | [From CodeSet] The internal ID for the country code in the CodeSet table. Indexed. |
Country | 12.0.1 | Varchar2(40) | [From CodeSet] The address country code. |
CountryDesc | 12.0.1 | Varchar2(2000) | [From CodeSet] The address country code description. |
CountryDisp | 12.0.1 | Varchar2(100) | [From CodeSet] The address country code display value. |
GeoCodeLatitude | 12.0.1 | Number(16,0) | The latitude coordinate of the address. |
GeoCodeLongitude | 12.0.1 | Number(16,0) | The longitude coordinate of the address. |
StartDate | 12.0.1 | Date | The address association (historical) start date. |
EndDate | 12.0.1 | Date | The address association (historical) end date. |