GP_PKGRPT_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_PKGRPT_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 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 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

8 PIN_NUM_REF_FLAG Character(1) VARCHAR2(1) NOT NULL This flag will indicate if the fieldname that it is related to is a Pin Number Reference field.
Y/N Table Edit
Default Value: N

9 KEY_FIELD_IND Character(1) VARCHAR2(1) NOT NULL Key Field Indicator
Default Value: N

10 PKGSRC_NUM_FLD Number(32,6) DECIMAL(31,6) NOT NULL Stores the value of a field from the source database where that field has changed between source and target.

11 PKGTGT_NUM_FLD Number(32,6) DECIMAL(31,6) NOT NULL Stores the value of a field from the target database where that field has changed between source and target.

12 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.

13 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.

14 PKGSRC_DTTM_FLD DateTime(26) TIMESTAMP Stores the value of a field from the source database where that field has changed between source and target.

15 PKGTGT_DTTM_FLD DateTime(26) TIMESTAMP Stores the value of a field from the target database where that field has changed between source and target.

16 PKGSRC_TIME_FLD Time(15) TIMESTAMP Stores the value of a field from the source database where that field has changed between source and target.

17 PKGTGT_TIME_FLD Time(15) TIMESTAMP Stores the value of a field from the target database where that field has changed between source and target.

18 PKGSRC_SNUM_FLD Signed Number(33,6) DECIMAL(31,6) NOT NULL Stores the value of a field from the source database where that field has changed between source and target.

19 PKGTGT_SNUM_FLD Signed Number(33,6) DECIMAL(31,6) NOT NULL Stores the value of a field from the target database where that field has changed between source and target.

20 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.

21 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.

#	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	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
8	PIN_NUM_REF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This flag will indicate if the fieldname that it is related to is a Pin Number Reference field. Y/N Table Edit Default Value: N
9	KEY_FIELD_IND	Character(1)	VARCHAR2(1) NOT NULL	Key Field Indicator Default Value: N
10	PKGSRC_NUM_FLD	Number(32,6)	DECIMAL(31,6) NOT NULL	Stores the value of a field from the source database where that field has changed between source and target.
11	PKGTGT_NUM_FLD	Number(32,6)	DECIMAL(31,6) NOT NULL	Stores the value of a field from the target database where that field has changed between source and target.
12	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.
13	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.
14	PKGSRC_DTTM_FLD	DateTime(26)	TIMESTAMP	Stores the value of a field from the source database where that field has changed between source and target.
15	PKGTGT_DTTM_FLD	DateTime(26)	TIMESTAMP	Stores the value of a field from the target database where that field has changed between source and target.
16	PKGSRC_TIME_FLD	Time(15)	TIMESTAMP	Stores the value of a field from the source database where that field has changed between source and target.
17	PKGTGT_TIME_FLD	Time(15)	TIMESTAMP	Stores the value of a field from the target database where that field has changed between source and target.
18	PKGSRC_SNUM_FLD	Signed Number(33,6)	DECIMAL(31,6) NOT NULL	Stores the value of a field from the source database where that field has changed between source and target.
19	PKGTGT_SNUM_FLD	Signed Number(33,6)	DECIMAL(31,6) NOT NULL	Stores the value of a field from the target database where that field has changed between source and target.
20	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.
21	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.