GP_PKG_PINMAP_V (SQL View)	Index Back
Pkg View (PIN Map Creation) This view is used in Packaging (PIN Map creation).

GP_PKG_PINMAP_V

(SQL View)

Pkg View (PIN Map Creation)

This view is used in Packaging (PIN Map creation).

SELECT A.EFFDT , A.PIN_NUM , A.PIN_MBR_NUM , B.RECNAME , B.FIELDNAME_KEY1 , B.FIELDNAME_KEY2 FROM PS_GP_PINMAP_EFFDT A , PS_GP_PIN_FLD_MAP2 B WHERE A.FLDMAP_RECNUM_KEY = B.FLDMAP_RECNUM_KEY AND A.FLDMAP_FLDNUM_KEY1 = B.FLDMAP_FLDNUM_KEY1 AND A.FLDMAP_FLDNUM_KEY2 = B.FLDMAP_FLDNUM_KEY2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EFFDT Date(10) DATE Effective Date

2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

3 PIN_MBR_NUM Number(8,0) INTEGER NOT NULL Element number field

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

5 FIELDNAME_KEY1 Character(18) VARCHAR2(18) NOT NULL Field created for use with element packager

6 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	EFFDT	Date(10)	DATE	Effective Date
2	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
3	PIN_MBR_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
4	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
5	FIELDNAME_KEY1	Character(18)	VARCHAR2(18) NOT NULL	Field created for use with element packager
6	FIELDNAME_KEY2	Character(18)	VARCHAR2(18) NOT NULL	Field created for use with element packager