GP_PKGLCH_TMP (SQL Table)	Index Back
Rule Pkg Compare Rpt Temp Tbl This temporary table stores the record name, field name and before and after field values of fields in the rule package that will be compared. The fields on the record will be either from new elements, deleted elements or elements where one or more field value has changed

GP_PKGLCH_TMP

(SQL Table)

Rule Pkg Compare Rpt Temp Tbl

This temporary table stores the record name, field name and before and after field values of fields in the rule package that will be compared. The fields on the record will be either from new elements, deleted elements or elements where one or more field value has changed

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 GP_PKG_ID Character(8) VARCHAR2(8) NOT NULL Field used for element packaging

3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

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

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

6 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

8 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GP_PKG_ID	Character(8)	VARCHAR2(8) NOT NULL	Field used for element packaging
3	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
4	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
5	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
6	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
7	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
8	DESCRLONG	Long Character	CLOB	Long Description