SCC_CG_OGEN_VW (SQL View)	Index Back
CommGen Person Gen Data Person Generic Data view is used to prompt for the CommGen Generic data records for person context.

SCC_CG_OGEN_VW

(SQL View)

CommGen Person Gen Data

Person Generic Data view is used to prompt for the CommGen Generic data records for person context.

SELECT CG_GENDTA_TYPE , SCC_CG_GEN_DTA , DESCR50 FROM PS_SCC_CG_GEN_SYS WHERE SA_ID_TYPE = 'O'

# 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 SCC_CG_GEN_DTA Character(15) VARCHAR2(15) NOT NULL CommGen Generic Data key field.

3 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	SCC_CG_GEN_DTA	Character(15)	VARCHAR2(15) NOT NULL	CommGen Generic Data key field.
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50