GVT_MASSCHG_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	MOC_ID	Character(5)	VARCHAR2(5) NOT NULL	Mass Organization Change ID
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
8	SELECTOR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used for Mass Org Change D=Department Selected P=Position Selected
9	DEPT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Department Flag
10	POSITION_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Position Flag N=No Y=Yes
11	OLD_DEPARTMENT	Character(10)	VARCHAR2(10) NOT NULL	Old Department
12	NEW_DEPARTMENT	Character(10)	VARCHAR2(10) NOT NULL	Used by the GVT for Mass Org Change
13	OLD_POSITION	Character(8)	VARCHAR2(8) NOT NULL	Old Position
14	NEW_POSITION	Character(8)	VARCHAR2(8) NOT NULL	used by GVT for mass org change
15	KEEP_GOING	Character(1)	VARCHAR2(1) NOT NULL	Keep Going Flag for App Engine....
16	GVT_STATUS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Status Type CAN=Cancelled COM=Completed COR=Corrected IRR=IRR Reported WIP=Work-in-progress
17	GVT_WIP_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Work-in-Progress Status
18	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
19	TEMP_FLD2	Character(1)	VARCHAR2(1) NOT NULL	For App Engine FGHR002B
20	TEMP_FLD3	Character(1)	VARCHAR2(1) NOT NULL	for app engine fghr002b
21	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
22	TAX_LOCATION_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code
23	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
24	SQL_ID	Character(30)	VARCHAR2(30) NOT NULL	TL
25	ASOFDATE	Date(10)	DATE	As of Date
26	GVT_NOA_CODE	Character(3)	VARCHAR2(3) NOT NULL	Nature of Action Code
27	GVT_LEG_AUTH_1	Character(3)	VARCHAR2(3) NOT NULL	Legal Authority (1)
28	GVT_PAR_AUTH_D1	Character(25)	VARCHAR2(25) NOT NULL	Authority 1 Descr - Part 1
29	GVT_PAR_AUTH_D1_2	Character(25)	VARCHAR2(25) NOT NULL	Authority 1 Descr - Part 2
30	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
31	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
32	GVT_OLD_VALUE	Character(10)	VARCHAR2(10) NOT NULL	USED IN MASS ORG APP ENGINE
33	NEW_EFFSEQ	Signed Number(4,0)	DECIMAL(3) NOT NULL	For app engine fghr002b
34	GVT_TRANS_NBR	Number(1,0)	SMALLINT NOT NULL	Transaction #
35	GVT_TRANS_NBR_SEQ	Number(1,0)	SMALLINT NOT NULL	Sequence
36	NULL_WORK_DATE	Date(10)	DATE	This field is used for the HRMS 8 Upgrade.
37	COMMENTS	Long Character	CLOB	Comment