GPJP_RC_UC (SQL Table)	Index Back
Unemployment Cert run control Process Scheduler report parameter(s) record utilised by the Unemployment Cert feature

GPJP_RC_UC

(SQL Table)

Unemployment Cert run control

Process Scheduler report parameter(s) record utilised by the Unemployment Cert feature

# 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 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number
Prompt Table: GPJP_TAXESLA_VW

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_HR

5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

6 GPJP_START_DATE Date(10) DATE NOT NULL Appraisal Prd Start Date (14-1)

7 GPJP_END_DATE Date(10) DATE NOT NULL Appraisal Prd End Date (14-2)

8 GPJP_PAYEE_IND Character(1) VARCHAR2(1) NOT NULL Checkbox that indicates whether a list of payees has been provided for the pay slip generation.
Y/N Table Edit
Default Value: N

9 GPJP_UC_OVRWRITE Character(1) VARCHAR2(1) NOT NULL Overwrite Certificate data (in GPJP_RC_UC)
Y/N Table Edit
Default Value: N

10 GPJP_WC_PROC Character(1) VARCHAR2(1) NOT NULL Checkbox that indicates whether a payee being processed is for Wage Certificate or Unemployment Certificate.

#	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	GPJP_TAX_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Salary Payer Reference Number Prompt Table: GPJP_TAXESLA_VW
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
6	GPJP_START_DATE	Date(10)	DATE NOT NULL	Appraisal Prd Start Date (14-1)
7	GPJP_END_DATE	Date(10)	DATE NOT NULL	Appraisal Prd End Date (14-2)
8	GPJP_PAYEE_IND	Character(1)	VARCHAR2(1) NOT NULL	Checkbox that indicates whether a list of payees has been provided for the pay slip generation. Y/N Table Edit Default Value: N
9	GPJP_UC_OVRWRITE	Character(1)	VARCHAR2(1) NOT NULL	Overwrite Certificate data (in GPJP_RC_UC) Y/N Table Edit Default Value: N
10	GPJP_WC_PROC	Character(1)	VARCHAR2(1) NOT NULL	Checkbox that indicates whether a payee being processed is for Wage Certificate or Unemployment Certificate.