GP_TASK_ELEM(SQL Table) |
Index Back |
|---|---|
Task ElementTask Element |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_COUNTRY_VW |
| 2 | 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 |
| 3 | SETID_FLD_CD | Character(2) | VARCHAR2(2) NOT NULL |
Setid Field Code
01=SETID_DEPT 02=SETID_JOBCODE 03=SETID_LOCATION |
| 4 | PIN_SOVR_SETID_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 5 | ENTRY_TYPE_SOVR | Character(3) | VARCHAR2(3) NOT NULL |
entry type sovr
Prompt Table: GP_ENT_TLTSK_VW |
| 6 | PIN_NUM | Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %RECNAME_EDIT |