GP_PKG_ADSR_AET(SQL Table) |
Index Back |
|---|---|
State Record - Rules RLState Record for the Application Engine program GP_PKG_ADSRL for managing Rules Related Language data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | GP_PKG_ID | Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | PIN_CODE | Character(22) | VARCHAR2(22) NOT NULL | Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN) |
| 6 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | COMMENTS | Long Character | CLOB | Comment |
| 9 | PKG_EXPORT_DTTM | DateTime(26) | TIMESTAMP | DateTime when package was exported. This applies to both Rule and Non-Rule packager. |
| 10 | 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. |
| 11 | 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 |
| 12 | AE_TEST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Test Flag |