GVT_MOC_JOB_TMP(SQL Table) |
Index Back |
|---|---|
Temp Job for MOCThe data in this table will be loaded into GVT_JOB via the Database Agents: MOCLDJOB & MOCLDPOS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 6 | GVT_TRANS_NBR | Number(1,0) | SMALLINT NOT NULL | Transaction # |
| 7 | GVT_TRANS_NBR_SEQ | Number(1,0) | SMALLINT NOT NULL | Sequence |
| 8 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSITION_DATA |
| 9 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 10 | GVT_NOA_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Nature of Action Code
Prompt Table: GVT_NOAC_TBL |
| 11 | GVT_LEG_AUTH_1 | Character(3) | VARCHAR2(3) NOT NULL |
Legal Authority (1)
Prompt Table: GVT_AUTH_VAL_1 |
| 12 | GVT_PAR_AUTH_D1 | Character(25) | VARCHAR2(25) NOT NULL | Authority 1 Descr - Part 1 |
| 13 | GVT_PAR_AUTH_D1_2 | Character(25) | VARCHAR2(25) NOT NULL | Authority 1 Descr - Part 2 |
| 14 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
| 15 | DEPT_ENTRY_DT | Date(10) | DATE | Department Entry Date |
| 16 | POSITION_ENTRY_DT | Date(10) | DATE | Position Entry Date |
| 17 | GVT_WIP_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Work-in-Progress Status
Prompt Table: GVT_WIP_STS_VW |
| 18 | GVT_EFFDT | Date(10) | DATE | Effective Date |
| 19 | CHANGE_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Type of Change Data (DEPT/POS) |
| 20 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |