GP_NRPKG_AD_DFN(SQL Table) |
Index Back |
---|---|
Non-Rule Package DefinitionThis 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. |
13 | 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 |