GP_PKG_DFN

(SQL Table)
Index Back

Package Definition

This record is used to define Package definitions in the Global Payroll product.

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
4 COMMENTS Long Character CLOB Comment
5 GP_VERSION_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether version-based.
N=Regular Rule Package
Y=Version Rule Package

Y/N Table Edit

Default Value: N

6 GPDBNAME Character(8) VARCHAR2(8) NOT NULL Database name where Package is created.
7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
8 PKG_CREATE_DTTM DateTime(26) TIMESTAMP DateTime when package was created. This applies to both Rule and Non-Rule packager.
9 PKG_SCRIPTS_DTTM DateTime(26) TIMESTAMP DateTime for Package Scripts Creation.
10 PKG_EXPORT_DTTM DateTime(26) TIMESTAMP DateTime when package was exported. This applies to both Rule and Non-Rule packager.
11 PKG_IMPORT_DTTM DateTime(26) TIMESTAMP DateTime when package was imported. This applies to both Rule and Non-Rule Packager. For the Non-Rule packager, this refers to the first import which is the import of element data.
12 PKG_COMPARE_DTTM DateTime(26) TIMESTAMP DateTime when package was compared. This applies to both Rule and Non-Rule packager.
13 PKG_UPGRADE_DTTM DateTime(26) TIMESTAMP DateTime when package was upgraded. This applies to both Rule and Non-Rule packager.