GPNZ_RC_EDF (SQL Table)	Index Back
Run CNTL- Process IR348 downld Run control record to create IR348 download data.

GPNZ_RC_EDF

(SQL Table)

Run CNTL- Process IR348 downld

Run control record to create IR348 download data.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID

3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
Prompt Table: GP_PYENT

4 GPNZ_YEARCD Character(4) VARCHAR2(4) NOT NULL Year code

5 GPNZ_MONTHCD Character(2) VARCHAR2(2) NOT NULL Month code
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December

6 GPNZ_IRD_HALF_SEL Character(1) VARCHAR2(1) NOT NULL This Field is used on the Run control page to let the user select if the report has to be created for First Half or Second Half or the Full Month.
1=First Half
2=Second Half
F=Full Month
Default Value: F

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: PRCSRUNCNTL.OPRID
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID Default Value: PRCSRUNCNTL.RUN_CNTL_ID
3	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_PYENT
4	GPNZ_YEARCD	Character(4)	VARCHAR2(4) NOT NULL	Year code
5	GPNZ_MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month code 01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December
6	GPNZ_IRD_HALF_SEL	Character(1)	VARCHAR2(1) NOT NULL	This Field is used on the Run control page to let the user select if the report has to be created for First Half or Second Half or the Full Month. 1=First Half 2=Second Half F=Full Month Default Value: F