GP_NR_PKG_DFN

(SQL Table)
Index Back

Non-Rule Package Definition

This record is used to define non-rule 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 GPDBNAME Character(8) VARCHAR2(8) NOT NULL Database name where Package is created.
6 PKG_CREATE_DTTM DateTime(26) TIMESTAMP DateTime when package was created. This applies to both Rule and Non-Rule packager.
7 PKG_EXPORT_DTTM DateTime(26) TIMESTAMP DateTime when package was exported. This applies to both Rule and Non-Rule packager.
8 PKG_EXPORT_NR_DTTM DateTime(26) TIMESTAMP Non Rules Package Export Date Time
9 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.
10 PKG_COMPARE_DTTM DateTime(26) TIMESTAMP DateTime when package was compared. This applies to both Rule and Non-Rule packager.
11 PKG_IMPORT_NR_DTTM DateTime(26) TIMESTAMP DateTime when non-rule data was imported. This applies to the Non-Rule packager only.
12 PKG_UPGRADE_DTTM DateTime(26) TIMESTAMP DateTime when package was upgraded. This applies to both Rule and Non-Rule packager.