PC_SCH_REC_TMPL (SQL Table)	Index Back
PC Sched Transaction Templates Structural template used to direct integration transaction and create XML data structure. This table equates to the input and output pieces of the dynamically generated xml file.

PC_SCH_REC_TMPL

(SQL Table)

PC Sched Transaction Templates

Structural template used to direct integration transaction and create XML data structure. This table equates to the input and output pieces of the dynamically generated 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
Default Value: OBJ

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 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	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 Default Value: OBJ
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	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description