GP_PKG_ADS_CRT1

(SQL Table)
Index Back

Package Criteria 1 - ADS

Global Payroll Package Criteria 1 ADS Staging Record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
3 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID
4 GP_PKG_INCL_OPTN Character(1) VARCHAR2(1) NOT NULL Field used for element packaging
F=Focus Element Only
M=Focus Element + Members
5 GP_PKG_UPG_ACTION Character(1) VARCHAR2(1) NOT NULL Field used for element packaging
D=Delete
I=Informational Only
U=Upgrade
6 PKG_LNG_OPTN Character(1) VARCHAR2(1) NOT NULL Defines options available for exporting language-data.
A=All(Base&Related)
B=Base Only
R=Related Only