GP_PKG_UPG_SUP2

(SQL View)
Index Back

Package Upgrade

Global Payroll Package Upgrade Record

SELECT A.GP_PKG_ID, A.EFFDT, A.PIN_NUM, A.PIN_MBR_NUM, A.RECNAME, A.FIELDNAME_KEY1, A.FIELDNAME_KEY2, B.PIN_NUM_TGT, C.PIN_NUM_TGT FROM PS_GP_PKG_PINMAP A, PS_GP_PKG_ELEMENTS B, PS_GP_PKG_ELEMENTS C WHERE A.GP_PKG_ID = B.GP_PKG_ID AND A.GP_PKG_ID = C.GP_PKG_ID AND A.PIN_NUM = B.PIN_NUM AND A.PIN_MBR_NUM = C.PIN_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(8) VARCHAR2(8) NOT NULL Field used for element packaging
2 EFFDT Date(10) DATE Effective Date
3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
4 PIN_MBR_NUM Number(8,0) INTEGER NOT NULL Element number field
5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
6 FIELDNAME_KEY1 Character(18) VARCHAR2(18) NOT NULL Field created for use with element packager
7 FIELDNAME_KEY2 Character(18) VARCHAR2(18) NOT NULL Field created for use with element packager
8 PIN_NUM_TGT Number(8,0) INTEGER NOT NULL Element number [PIN] field
9 PIN_MBR_NUM_TGT Number(9,0) DECIMAL(9) NOT NULL Element number [PIN] field