GP_NRP_TKELM_AD(SQL Table) |
Index Back |
|---|---|
Task ElementTask Element |
| # | 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 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | TASK_FLD_CD |
Character(2) | VARCHAR2(2) NOT NULL |
Identifies the type of task field (associated with time pulled from TL). Has XLATs
01=COMBO_CD 02=BUSINESS_UNIT 03=COMPANY 04=COUNTRY 05=DEPTID 06=JOBCODE 07=LOCATION 08=PRODUCT 09=RATE_VAL 10=STATE 11=TASK 12=USER_FIELD_1 13=USER_FIELD_2 14=USER_FIELD_3 15=USER_FIELD_4 16=USER_FIELD_5 |
| 4 | SETID_FLD_CD | Character(2) | VARCHAR2(2) NOT NULL |
Setid Field Code
01=SETID_DEPT 02=SETID_JOBCODE 03=SETID_LOCATION |
| 5 | PIN_SOVR_SETID_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 6 | ENTRY_TYPE_SOVR | Character(3) | VARCHAR2(3) NOT NULL | entry type sovr |
| 7 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |