SCC_CG_DTASRC (SQL Table)	Index Back
CommGen Data Source Table CommGen Data Source Table stores information that maps directly to the XML Publisher Data Source table.

SCC_CG_DTASRC

(SQL Table)

CommGen Data Source Table

CommGen Data Source Table stores information that maps directly to the XML Publisher Data Source table.

Parent Record Of SCC_CG_CUST_DTA SCC_CG_GEN_DTA

# 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 SCC_DS_MAP_ID Character(30) VARCHAR2(30) NOT NULL CommGen Data Source name that maps to XML Publisher Data Source ID.

3 ADMIN_FCN_PEOPLE Character(1) VARCHAR2(1) NOT NULL Admin Function - People
Y/N Table Edit
Default Value: N

4 ADMIN_FCN_ORG Character(1) VARCHAR2(1) NOT NULL Admin Function - Organizations
Y/N Table Edit
Default Value: N

5 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function
Prompt Table: ADM_FUNCTN_TBL

6 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	SCC_DS_MAP_ID	Character(30)	VARCHAR2(30) NOT NULL	CommGen Data Source name that maps to XML Publisher Data Source ID.
3	ADMIN_FCN_PEOPLE	Character(1)	VARCHAR2(1) NOT NULL	Admin Function - People Y/N Table Edit Default Value: N
4	ADMIN_FCN_ORG	Character(1)	VARCHAR2(1) NOT NULL	Admin Function - Organizations Y/N Table Edit Default Value: N
5	ADMIN_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Administrative Function Prompt Table: ADM_FUNCTN_TBL
6	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.