ORG_RECIP_ADDR

(SQL View)
 Index Back

CommGen Org Recipient Address

CommGen Org Recipient Address view is used to build the Communication Data Source with the organization recipient contact/department/location land address information.

SELECT ' ' ,0 ,0 ,0 ,0 ,0 ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,DB2_NULL_LONG FROM %Table(INSTALLATION_CC) , PS_DB2_NULL_FLDS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
2 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number
3 CG_SEQ Number(5,0) INTEGER NOT NULL CommGen Sequence
4 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr
5 ORG_DEPARTMENT Number(3,0) SMALLINT NOT NULL Department Nbr
6 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr
7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

8 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
9 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
10 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
11 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
12 CITY Character(30) VARCHAR2(30) NOT NULL City
13 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
14 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
15 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
16 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
17 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
18 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
19 COUNTY Character(30) VARCHAR2(30) NOT NULL County
20 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

21 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
22 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
23 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

24 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 1
25 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 2
26 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3
27 CITY_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character City
28 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
29 STATE_DESCR Character(30) VARCHAR2(30) NOT NULL State Description
30 COUNTRY_DESCR Character(30) VARCHAR2(30) NOT NULL Country Description
31 ADDRESSLONG Long Character CLOB Address