GPMX_MASS_TERM

#	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: GPMX_PYGRP4_VW
2	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID Prompt Table: GPMX_CAL_PRD_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	PYMT_DT	Date(10)	DATE	Payment Date
5	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
6	SRC_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Source Calendar Run ID Prompt Table: GP_CAL_RUNU_VW
7	GP_RUN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Processing Status; initial use to reflect the status of an Off-cycle group as to whether processing has been initiated or finalized A=Calculation Successful C=Cancelled E=Calculated with Errors F=Processing finalized I=Process initiated U=Unprocessed Default Value: U
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
9	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
11	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
12	TERMINATION_DT	Date(10)	DATE	Termination Date
13	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: GPMX_TER_ACT_VW
14	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
15	GP_TX_REASON	Character(18)	VARCHAR2(18) NOT NULL	Off Cycle (Transaction) Reason Identifies a particular configuration to be applied to the presentation of off cycle request information
16	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