PC_SCH_RECS (SQL Table)	Index Back
PC Sched Transaction Records List of records within each transaction in the dynamically generated xml file used to integrate data with third party scheduling products. This table equates to the classes called from each transaction in the xml file.

PC_SCH_RECS

(SQL Table)

PC Sched Transaction Records

List of records within each transaction in the dynamically generated xml file used to integrate data with third party scheduling products. This table equates to the classes called from each transaction in the xml file.

# 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 PC_CLASSIFICATION Character(4) VARCHAR2(4) NOT NULL XML Classification used to determine whether object is a CLASS object or a MEMBER object
NOBJ=Non Object
OBJ=Object

4 PC_TRANS_IO Character(4) VARCHAR2(4) NOT NULL Transaction Inupt/Output designation. Used to determine whether the field is a input or output member for the XML transaction
INPU=Input Transaction
OUTP=Output Transaction

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

6 PC_SCH_RECNAME Character(30) VARCHAR2(30) NOT NULL Record (Table) Name
Prompt Table: PC_SCH_REC_VW

7 ORDERBYNUM Number(3,0) SMALLINT NOT NULL Order-By Number

#	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	PC_CLASSIFICATION	Character(4)	VARCHAR2(4) NOT NULL	XML Classification used to determine whether object is a CLASS object or a MEMBER object NOBJ=Non Object OBJ=Object
4	PC_TRANS_IO	Character(4)	VARCHAR2(4) NOT NULL	Transaction Inupt/Output designation. Used to determine whether the field is a input or output member for the XML transaction INPU=Input Transaction OUTP=Output Transaction
5	PC_SCH_PROD_VAL	Character(4)	VARCHAR2(4) NOT NULL	Scheduling Product 3P=Third Party Scheduling Product PS=PeopleSoft Projects SIGN=Signon
6	PC_SCH_RECNAME	Character(30)	VARCHAR2(30) NOT NULL	Record (Table) Name Prompt Table: PC_SCH_REC_VW
7	ORDERBYNUM	Number(3,0)	SMALLINT NOT NULL	Order-By Number