SCC_CG_GEN_SYS (SQL Table)	Index Back
CommGen Generic System Data CommGen Generic System Data table stores the description of each Generic Data entity to be included in the XML Publisher Data Source.

SCC_CG_GEN_SYS

(SQL Table)

CommGen Generic System Data

CommGen Generic System Data table stores the description of each Generic Data entity to be included in the XML Publisher Data Source.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CG_GENDTA_TYPE Character(3) VARCHAR2(3) NOT NULL CommGen generic data type
ADR=Address
CHK=Checklist Items
EML=Email Address
ENC=Enclosures
NAD=Address Name
NEX=Extra Name
NJT=Joint Salutation Name
NLD=Netherlands Name
NSA=Salutation Name
ORA=Org Recipient Address
ORE=Org Recipient Email
ORN=Org Recipient Name
RCP=Recipient List

2 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person

3 SCC_CG_GEN_DTA Character(15) VARCHAR2(15) NOT NULL CommGen Generic Data key field.

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CG_GENDTA_TYPE	Character(3)	VARCHAR2(3) NOT NULL	CommGen generic data type ADR=Address CHK=Checklist Items EML=Email Address ENC=Enclosures NAD=Address Name NEX=Extra Name NJT=Joint Salutation Name NLD=Netherlands Name NSA=Salutation Name ORA=Org Recipient Address ORE=Org Recipient Email ORN=Org Recipient Name RCP=Recipient List
2	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person
3	SCC_CG_GEN_DTA	Character(15)	VARCHAR2(15) NOT NULL	CommGen Generic Data key field.
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50