GM_EC_IN_ADDR_2

(SQL View)
Index Back

EDI ORG ADDR INFO


SELECT A.OPRID , A.RUN_CNTL_ID , A.SETID , A.INSTID , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.COUNTRY , A.COUNTY , A.IN_CITY_LIMIT , A.POSTAL , A.STATE , A.STATE_FORMAT , A.COUNTRY_FORMAT FROM PS_GM_EC_IN_ADDR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 INSTID Character(5) VARCHAR2(5) NOT NULL Institution ID
5 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
6 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
7 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
8 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
9 CITY Character(30) VARCHAR2(30) NOT NULL City
10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
11 COUNTY Character(30) VARCHAR2(30) NOT NULL County
12 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
13 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
14 STATE Character(6) VARCHAR2(6) NOT NULL State
15 STATE_FORMAT Character(40) VARCHAR2(40) NOT NULL STATE FORMAT
16 COUNTRY_FORMAT Character(40) VARCHAR2(40) NOT NULL COUNTRY FORMAT