GPMX_RC_TERMREP

(SQL Table)
Index Back

Termination Reports Parameters

Use this record to store the Termination Reports Parameters

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

Prompt Table: GP_CAL_RUN

4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP

6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

7 GPMX_TER_LOF Character(4) VARCHAR2(4) NOT NULL Termination Layoff Use this field to identify the termination reason as (Termination or Layoff)
0010=Termination
0020=Layoff

Default Value: 0010

8 GPMX_FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID

Prompt Table: GPMX_FORMAT_VW