HRS_PSTLI_VW

(SQL View)

SELECT B.COUNTRY_2CHAR , A.EO_ADDRESS_FIELD , A.HRS_HRXML_POSTAL FROM PS_HRS_HRXML_PSTLI A , PS_COUNTRY_TBL B WHERE A.COUNTRY=B.COUNTRY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code

2 EO_ADDRESS_FIELD Character(18) VARCHAR2(18) NOT NULL Address field

3 HRS_HRXML_POSTAL Character(3) VARCHAR2(3) NOT NULL HR XML Postal
10=Postal Code
100=CountryCode
20=Region[1]
30=Region[2]
40=Region[3]
50=Municipality
60=AddressLine[1]
70=AddressLine[2]
80=AddressLine[3]
90=AddressLine[4]

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY_2CHAR	Character(2)	VARCHAR2(2) NOT NULL	2-Char Country Code
2	EO_ADDRESS_FIELD	Character(18)	VARCHAR2(18) NOT NULL	Address field
3	HRS_HRXML_POSTAL	Character(3)	VARCHAR2(3) NOT NULL	HR XML Postal 10=Postal Code 100=CountryCode 20=Region[1] 30=Region[2] 40=Region[3] 50=Municipality 60=AddressLine[1] 70=AddressLine[2] 80=AddressLine[3] 90=AddressLine[4]