GP_PKG_ADS_CRT2(SQL Table) |
Index Back |
|---|---|
Package Criteria 2 - ADSGlobal Payroll Package Criteria (2) 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 | GP_PKG_CRIT_SEQ |
Number(3,0) | SMALLINT NOT NULL | Field used for element packaging |
| 3 | GP_PKG_INCL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Field used for element packaging
F=Focus Element Only M=Focus Element + Members |
| 4 | GP_PKG_UPG_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Field used for element packaging
D=Delete I=Informational Only U=Upgrade |
| 5 | 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 |
| 6 | PIN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Element Type |
| 7 | PIN_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Element Owner
C=Customer Maintained M=PS Delivered/Customer Modified N=PS Delivered / Not Maintained P=PS Delivered / Maintained S=PS Delivered/Maintained/Secure |
| 8 | USED_BY | Character(1) | VARCHAR2(1) NOT NULL |
USED_BY
A=All Countries C=Specific Country |
| 9 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 10 | PIN_CATEGORY | Character(4) | VARCHAR2(4) NOT NULL | Element Category |
| 11 | PIN_CLASS | Character(2) | VARCHAR2(2) NOT NULL |
Element Class
CU=Customary NC=Not Classified SM=Sample Data ST=Statutory SY=System Data |
| 12 | WHERE_CLAUSE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Option for storing WHERE clause associated with the Packager.
C=Change WHERE Clause D=Use Default WHERE Clause |
| 13 | GRP_WHERE_CLS | Long Character(4096) | CLOB | Where Clause for Groups |