ORG_RECIP_NAME

(SQL View)
 Index Back

CommGen Org Recipient Name

CommGen Org Recipient Name view is used to build the Communication Data Source with the organization recipient contact/department/location name and description information.

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

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
9 ORG_RECIPIENT Character(50) VARCHAR2(50) NOT NULL Org Communication Recipient
10 NAME_RESULT Character(120) VARCHAR2(120) NOT NULL Name Result
11 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title
12 CNTC_TYPE_DESC Character(30) VARCHAR2(30) NOT NULL Contact Type
13 CNTC_DEPT_DESC Character(30) VARCHAR2(30) NOT NULL Contact Department
14 CNTC_DEPT_DESCSHRT Character(10) VARCHAR2(10) NOT NULL Contact Department
15 CNTC_LOC_DESC Character(30) VARCHAR2(30) NOT NULL Contact Location
16 CNTC_LOC_DESCSHRT Character(10) VARCHAR2(10) NOT NULL Contact Location
17 DEPT_TYPE_DESC Character(30) VARCHAR2(30) NOT NULL Department Type
18 DEPT_CNTC_NAME Character(50) VARCHAR2(50) NOT NULL Department Contact
19 DEPT_LOC_DESC Character(30) VARCHAR2(30) NOT NULL Department Location
20 DEPT_LOC_DESCSHRT Character(10) VARCHAR2(10) NOT NULL Department Location