GP_PKGELM_VW (SQL View)	Index Back
Package Compare Element This view stores the Package ID, Element Type, 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_PKGELM_VW

(SQL View)

Package Compare Element

This view stores the Package ID, Element Type, 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 , MAP2.FIELDNAME_KEY2 FROM PS_GP_PIN_FLD_MAP2 MAP2 , PS_GP_PIN_FLD_MAP4 MAP4 WHERE MAP2.RECNAME = MAP4.RECNAME

# 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 FIELDNAME_KEY2 Character(18) VARCHAR2(18) NOT NULL Field created for use with element packager

#	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	FIELDNAME_KEY2	Character(18)	VARCHAR2(18) NOT NULL	Field created for use with element packager