PC_SCH_REC_CTLG (SQL Table)	Index Back
PC Sched Transaction Catalog Structural template used to direct integration transaction and create XML data structure. This table is used to define the transaction names in the dynamically generated xml file used to transfer data in the third party scheduling product integration.

PC_SCH_REC_CTLG

(SQL Table)

PC Sched Transaction Catalog

Structural template used to direct integration transaction and create XML data structure. This table is used to define the transaction names in the dynamically generated xml file used to transfer data in the third party scheduling product integration.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PC_SCH_PRODUCT Character(3) VARCHAR2(3) NOT NULL Product code used by Projects to determine the third party scheduling product being integrated with.
Prompt Table: PC_SCH_PRODUCT

2 IONAME Character(30) VARCHAR2(30) NOT NULL Interface Object Name (see PSIODEFN).

3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

4 PC_TRANS_CAT Character(4) VARCHAR2(4) NOT NULL Transaction Category used for Schedule Integration. Specifies the nature of the transaction - Ex. Project, Activity, or Resources
ACTV=Activity Transaction
EXPN=Expense Transaction
PROJ=Project Transaction
RESR=Resource Transaction
RSHT=Resource Sheet
RSRL=Resource Role
SIGN=Signon

5 PC_TRANS_PRCS Character(4) VARCHAR2(4) NOT NULL Transaction Process used for Schedule Integration. Specifies the process of the transaction - Ex. Select Processing, Update Processing, or Create Processing
CRET=Create Processing
SELE=Select Processing
SIGN=Signon
UPDT=Update Processing

6 PC_SCH_PROD_VAL Character(4) VARCHAR2(4) NOT NULL Scheduling Product
3P=Third Party Scheduling Product
PS=PeopleSoft Projects
SIGN=Signon

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PC_SCH_PRODUCT	Character(3)	VARCHAR2(3) NOT NULL	Product code used by Projects to determine the third party scheduling product being integrated with. Prompt Table: PC_SCH_PRODUCT
2	IONAME	Character(30)	VARCHAR2(30) NOT NULL	Interface Object Name (see PSIODEFN).
3	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
4	PC_TRANS_CAT	Character(4)	VARCHAR2(4) NOT NULL	Transaction Category used for Schedule Integration. Specifies the nature of the transaction - Ex. Project, Activity, or Resources ACTV=Activity Transaction EXPN=Expense Transaction PROJ=Project Transaction RESR=Resource Transaction RSHT=Resource Sheet RSRL=Resource Role SIGN=Signon
5	PC_TRANS_PRCS	Character(4)	VARCHAR2(4) NOT NULL	Transaction Process used for Schedule Integration. Specifies the process of the transaction - Ex. Select Processing, Update Processing, or Create Processing CRET=Create Processing SELE=Select Processing SIGN=Signon UPDT=Update Processing
6	PC_SCH_PROD_VAL	Character(4)	VARCHAR2(4) NOT NULL	Scheduling Product 3P=Third Party Scheduling Product PS=PeopleSoft Projects SIGN=Signon