GPJP_RC_SC01 (SQL Table)	Index Back
Runctl for Mthly Remun Reports Runcontrol record for Monthly Standard Remuneration Calculation Reports (Revised and Regular)

GPJP_RC_SC01

(SQL Table)

Runctl for Mthly Remun Reports

Runcontrol record for Monthly Standard Remuneration Calculation Reports (Revised and Regular)

# 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 DATE_YEAR_VAL Number(4,0) SMALLINT NOT NULL Date Year Value

4 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
Prompt Table: GPJP_MONTH_VW

5 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number
Prompt Table: GPJP_TAXESSC_VW

6 GPJP_PAYEE_ID_TYPE Character(1) VARCHAR2(1) NOT NULL Payee ID Type
1=Health Insurance Card Number
2=Pension Insurance Code
Default Value: 1

#	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	DATE_YEAR_VAL	Number(4,0)	SMALLINT NOT NULL	Date Year Value
4	MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December Prompt Table: GPJP_MONTH_VW
5	GPJP_TAX_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Salary Payer Reference Number Prompt Table: GPJP_TAXESSC_VW
6	GPJP_PAYEE_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payee ID Type 1=Health Insurance Card Number 2=Pension Insurance Code Default Value: 1