GPMX_TERM_PYE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: GP_PYGRP
2	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID Prompt Table: GP_CAL_PRD1_VW
3	OFF_CYCLE_ID	Character(18)	VARCHAR2(18) NOT NULL	Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: GP_PG_PERS_SRCH
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: GP_PGRP_JOB_VW
6	TERMINATION_DT	Date(10)	DATE	Termination Date
7	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
8	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
9	GPMX_SOURCE_ID	Character(3)	VARCHAR2(3) NOT NULL	Source ID BAT=Batch Source USE=User Source Default Value: USE
10	GPMX_TER_PROC_STAT	Character(3)	VARCHAR2(3) NOT NULL	Payee Process Status for Mass Termination Process NEW=New OFF=Off Cycle Request UPD=Request Updated Default Value: NEW
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
12	GPMX_TIMESTAMP	DateTime(26)	TIMESTAMP	Process Time Stamp for Mass Termination