GP_PKGREC_TMP (SQL Table)	Index Back
Pkg Compare Report Tmp Table This temporary table stores the details of parent/child record order for Element Defintion records (apart from GP_PIN and GP_PIN_LANG). It is used when determining the print order for Element definition records on the GP Core Rules Packager Compare Report.

GP_PKGREC_TMP

(SQL Table)

Pkg Compare Report Tmp Table

This temporary table stores the details of parent/child record order for Element Defintion records (apart from GP_PIN and GP_PIN_LANG). It is used when determining the print order for Element definition records on the GP Core Rules Packager Compare Report.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PIN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Element Type
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number