PC_SCH_REC_LIST (SQL Table)	Index Back
Records for Scheduling Integ. List of records that will be used to build the templates used for integrating data with third party scheduling software. Each record will be a class in the dynamically generated xml file used in the data integration.

PC_SCH_REC_LIST

(SQL Table)

Records for Scheduling Integ.

List of records that will be used to build the templates used for integrating data with third party scheduling software. Each record will be a class in the dynamically generated xml file used in the data 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 PC_SCH_PROD_VAL Character(4) VARCHAR2(4) NOT NULL Scheduling Product
3P=Third Party Scheduling Product
PS=PeopleSoft Projects
SIGN=Signon

3 PC_SCH_RECNAME Character(30) VARCHAR2(30) NOT NULL Record (Table) Name
Prompt Table: PC_SCH_RCDFN_VW

#	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	PC_SCH_PROD_VAL	Character(4)	VARCHAR2(4) NOT NULL	Scheduling Product 3P=Third Party Scheduling Product PS=PeopleSoft Projects SIGN=Signon
3	PC_SCH_RECNAME	Character(30)	VARCHAR2(30) NOT NULL	Record (Table) Name Prompt Table: PC_SCH_RCDFN_VW