| # |
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 |
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
Default Value: F
|
| 4 |
GP_PKG_UPG_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used for element packaging
D=Delete
I=Informational Only
U=Upgrade
Default Value: U
Prompt Table:
GP_PKG_UPG_VW
|
| 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
Default Value: A
|
| 6 |
PIN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Element Type
Prompt Table:
GP_PKG_PNTYP_VW
|
| 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
Prompt Table:
GP_COUNTRY_VW
|
| 10 |
PIN_CATEGORY |
Character(4) |
VARCHAR2(4) NOT NULL |
Element Category
Prompt Table:
GP_PIN_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
Default Value: D
|
| 13 |
GRP_WHERE_CLS |
Long Character(4096) |
CLOB |
Where Clause for Groups
|