GP_PKGRPT1_TMP (SQL Table)	Index Back
Rule Pkg Compare Rpt Temp Tbl This temporary table stores the record name, field name and source and target date values for Formula elements on source and target. It is used to update source and / or target date fields GP_PKGRPT_TMP for fomulae. The reason we need to do this is that currently there is an issue when comparing formulae such that sequence numbers between source and target can be different even though the formulae are essentially one and the same on source and target.

GP_PKGRPT1_TMP

(SQL Table)

Rule Pkg Compare Rpt Temp Tbl

This temporary table stores the record name, field name and source and target date values for Formula elements on source and target. It is used to update source and / or target date fields GP_PKGRPT_TMP for fomulae. The reason we need to do this is that currently there is an issue when comparing formulae such that sequence numbers between source and target can be different even though the formulae are essentially one and the same on source and target.

# 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 GP_PKG_PIN_NUM Number(8,0) INTEGER NOT NULL The pin number on a Rule Package element after the Compare process has run but before the Upgrade process has run

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 PKGSRC_DATE_FLD Date(10) DATE Stores the value of a field from the source database where that field has changed between source and target.

8 PKGTGT_DATE_FLD Date(10) DATE Stores the value of a field from the target database where that field has changed between source and target.

9 PKGTGT_CHAR_FLD Character(254) VARCHAR2(254) NOT NULL Stores the value of a field from the target database where that field has changed between source and target.

10 PKGSRC_CHAR_FLD Character(254) VARCHAR2(254) NOT NULL Stores the value of a field from the source database where that field has changed between source and target.

#	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	GP_PKG_PIN_NUM	Number(8,0)	INTEGER NOT NULL	The pin number on a Rule Package element after the Compare process has run but before the Upgrade process has run
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	PKGSRC_DATE_FLD	Date(10)	DATE	Stores the value of a field from the source database where that field has changed between source and target.
8	PKGTGT_DATE_FLD	Date(10)	DATE	Stores the value of a field from the target database where that field has changed between source and target.
9	PKGTGT_CHAR_FLD	Character(254)	VARCHAR2(254) NOT NULL	Stores the value of a field from the target database where that field has changed between source and target.
10	PKGSRC_CHAR_FLD	Character(254)	VARCHAR2(254) NOT NULL	Stores the value of a field from the source database where that field has changed between source and target.