GP_PKG_DFN(SQL Table) |
Index Back |
---|---|
Package DefinitionThis 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. |