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 | MOC_ID | Character(5) | VARCHAR2(5) NOT NULL | Mass Organization Change ID |
2 | SETID | 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 |