GP_PKGFM1_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_PKGFM1_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 EFFDT Date(10) DATE Effective Date
Default Value: %date

#	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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date