SCC_CG_CP_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CG_SORT_ORDER	Number(5,0)	INTEGER NOT NULL	Sort Order
3	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value
4	SEQ_3C	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	CG_SEQ	Number(5,0)	INTEGER NOT NULL	CommGen Sequence
6	RELATIONSHIP_NBR	Number(2,0)	SMALLINT NOT NULL	Relationship Nbr
7	SCC_LETTER_CD	Character(3)	VARCHAR2(3) NOT NULL	Letter Code
8	ENCL_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
9	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person
10	RECIPIENT_COMM	Character(1)	VARCHAR2(1) NOT NULL	Recipient Communication
11	EMPLID_RELATED	Character(11)	VARCHAR2(11) NOT NULL	Related People ID
12	REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	Report Name (see PSXPRPTDEFN).
13	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN).
14	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
15	PT_FORMAT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Format Type HTM=HTML PDF=PDF RTF=RTF TXT=TXT XLS=XLS
16	SCC_CG_DS_ID	Number(5,0)	INTEGER NOT NULL	CommGen Sequence Number as high level key of CommGen Data Source definition.
17	SCC_COMM_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Method Used B=Publication D=Document E=E-Mail F=Fax L=Letter P=Personal Contact T=Telephone Call W=Web
18	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
19	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
20	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
21	ORG_RECIPIENT	Character(50)	VARCHAR2(50) NOT NULL	Org Communication Recipient
22	NAME_RESULT_O_CNTC	Character(120)	VARCHAR2(120) NOT NULL	Name Result
23	NAME_RESULT_P_ADDR	Character(120)	VARCHAR2(120) NOT NULL	Name Result
24	NAME_RESULT_P_EXTR	Character(120)	VARCHAR2(120) NOT NULL	Name Result
25	NAME_RESULT_P_SAL	Character(120)	VARCHAR2(120) NOT NULL	Name Result
26	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
27	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
28	ORG_CONTACT	Number(4,0)	SMALLINT NOT NULL	Contact Nbr
29	ORG_DEPARTMENT	Number(3,0)	SMALLINT NOT NULL	Department Nbr
30	ORG_LOCATION	Number(3,0)	SMALLINT NOT NULL	Location Nbr
31	CG_LTRCD_ORDER	Number(5,0)	INTEGER NOT NULL	Letter Code Order
32	SCC_EMAIL_SND_ERR	Character(1)	VARCHAR2(1) NOT NULL	Email Send Error
33	SCC_CGCP_XMLDSPATH	Character(254)	VARCHAR2(254) NOT NULL	CommPart XML Datasource Path
34	PROCESSED	Character(1)	VARCHAR2(1) NOT NULL	Processed? I=In Process N=Not Processed Y=Processed