STG_ADDRESS

(SQL Table)
Index Back

List Import Stage Tbl

List Import Stage Tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
2 ROW_NUMBER Number(10,0) DECIMAL(10) NOT NULL Row Number
3 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Matching Action
4 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
5 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
6 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
8 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS1_AC
9 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
10 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS2_AC
11 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
12 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS3_AC
13 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
14 ADDRESS4_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 4.
15 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
16 CITY Character(30) VARCHAR2(30) NOT NULL City
17 CITY_AC Character(30) VARCHAR2(30) NOT NULL CITY_AC
18 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID
19 CM_PURPOSE_TYPE_ID Number(6,0) INTEGER NOT NULL Relationship Contact Method Purpose ID
20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
21 COUNTY Character(30) VARCHAR2(30) NOT NULL County
22 CROSS_STREET_1 Character(50) VARCHAR2(50) NOT NULL Cross Street of a location
23 CROSS_STREET_2 Character(50) VARCHAR2(50) NOT NULL Cross Street of a location
24 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
25 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
26 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
27 LATITUDE Signed Number(32,20) DECIMAL(30,20) NOT NULL LATITUDE
28 LONGITUDE Signed Number(32,20) DECIMAL(30,20) NOT NULL LONGITUDE
29 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
30 NUM2 Character(4) VARCHAR2(4) NOT NULL Number 2
31 PHYSICAL_LOCATION Character(30) VARCHAR2(30) NOT NULL Physical Location (Free-Form)
32 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
33 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
34 RD_ADDR_INTERSECT Character(1) VARCHAR2(1) NOT NULL This field is used to determine if the associated address is at an intersection or not.
N=No
Y=Yes
35 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
36 STATE Character(6) VARCHAR2(6) NOT NULL State
37 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone