GP_PKGKEY_VW (SQL View)	Index Back
Package Compare Key Fields This temporary table stores the Record name and record key field names of the records that need to be compared in order to produce the GP Rule Package Compare report.

GP_PKGKEY_VW

(SQL View)

Package Compare Key Fields

This temporary table stores the Record name and record key field names of the records that need to be compared in order to produce the GP Rule Package Compare report.

SELECT MAP4.PIN_TYPE , MAP4.RECNAME , KD.KEYPOSN , KD.FIELDNAME , DB.FIELDTYPE FROM PSKEYDEFN KD , PS_GP_PIN_FLD_MAP4 MAP4 , PSDBFIELD DB WHERE KD.RECNAME = MAP4.RECNAME AND KD.FIELDNAME = DB.FIELDNAME AND KD.INDEXID = '_'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 KEYPOSN Number(3,0) SMALLINT NOT NULL Key Position

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

5 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Element Type
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
3	KEYPOSN	Number(3,0)	SMALLINT NOT NULL	Key Position
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)