GPJP_EMPADR_VW1

(SQL View)
 Index Back

Employee Address View

Address taken from PS_PERSON_ADDRESS

SELECT A.EMPLID , A.COUNTRY , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.COUNTY , A.STATE , A.POSTAL , A.NUM1 , A.NUM2 , A.HOUSE_TYPE , A.ADDR_FIELD1 , A.ADDR_FIELD2 , A.ADDR_FIELD3 , A.IN_CITY_LIMIT , A.GEO_CODE , A.ADDRESS_TYPE FROM PS_PERSON_ADDRESS A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

Prompt Table: COUNTRY_TBL

3 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
4 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
5 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
6 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
7 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
8 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
9 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

Prompt Table: STATE_OTH

10 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
11 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
12 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
13 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
AB=House Boat Reference
WW=House Trailer Reference
14 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
15 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
16 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
17 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other

Y/N Table Edit

18 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
19 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type