GVT_MOC_DATA(SQL Table) |
Index Back |
|---|---|
Mass Org Change DataMass Org Change Data Setup Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | Mass Organization Change ID | |
| 2 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
|
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | ASOFDATE | Date(10) | DATE NOT NULL |
As of Date
Default Value: %date |
| 5 | GVT_NOA_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Nature of Action Code
Prompt Table: GVT_NOAC_TBL |
| 6 | GVT_LEG_AUTH_1 | Character(3) | VARCHAR2(3) NOT NULL |
Legal Authority (1)
Prompt Table: GVT_AUTH_VAL_1 |
| 7 | GVT_PAR_AUTH_D1 | Character(25) | VARCHAR2(25) NOT NULL | Authority 1 Descr - Part 1 |
| 8 | GVT_PAR_AUTH_D1_2 | Character(25) | VARCHAR2(25) NOT NULL | Authority 1 Descr - Part 2 |
| 9 | GVT_WIP_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Work-in-Progress Status
Prompt Table: GVT_WIP_STATUS |
| 10 | NEW_DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
New Department
Prompt Table: DEPT_TBL |
| 11 | NEW_POS_NBR | Character(8) | VARCHAR2(8) NOT NULL |
New Position
Prompt Table: POSITION_DATA |
| 12 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Default Value: XFR Prompt Table: ACTION_TBL |
| 13 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
| 14 | SELECTOR | Character(1) | VARCHAR2(1) NOT NULL |
To indicate which field to chg
D=Department P=Position Default Value: D |
| 15 | DELETE_DATA | Character(1) | VARCHAR2(1) NOT NULL |
Clear Data in Temp Table
Y/N Table Edit Default Value: Y |
| 16 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL |
Reports To Position Number
Prompt Table: POSITION_DATA |