SCC_CG_CUST_DTA (SQL Table)	Index Back
CommGen Custom Data Source Tbl CommGen Custom Data Source Table stores the sequence and type of custom data to be included in the XML Publisher Data Source.

SCC_CG_CUST_DTA

(SQL Table)

CommGen Custom Data Source Tbl

CommGen Custom Data Source Table stores the sequence and type of custom data to be included in the XML Publisher Data Source.

Parent record: SCC_CG_DTASRC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_CG_DS_ID Number(5,0) INTEGER NOT NULL CommGen Sequence Number as high level key of CommGen Data Source definition.

2 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

3 SCC_CG_DS_TYPE Character(3) VARCHAR2(3) NOT NULL CommGen Data Source Type.
APP=Applicaton Class
QRY=PS Query
Default Value: QRY

4 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection

5 SCCPS_APPCLASSNAME Character(190) VARCHAR2(190) NOT NULL Used to represent an application class as a single string. Usually RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)

6 MAX_RTRV Number(4,0) SMALLINT NOT NULL Maximum Retrieval

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_CG_DS_ID	Number(5,0)	INTEGER NOT NULL	CommGen Sequence Number as high level key of CommGen Data Source definition.
2	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
3	SCC_CG_DS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	CommGen Data Source Type. APP=Applicaton Class QRY=PS Query Default Value: QRY
4	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection
5	SCCPS_APPCLASSNAME	Character(190)	VARCHAR2(190) NOT NULL	Used to represent an application class as a single string. Usually RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)
6	MAX_RTRV	Number(4,0)	SMALLINT NOT NULL	Maximum Retrieval