GPNZ_RC_IR345_6 (SQL Table)	Index Back
Run Control - IR 345/6 Reports Run control Page Record for the IR 345/6 Report.

GPNZ_RC_IR345_6

(SQL Table)

Run Control - IR 345/6 Reports

Run control Page Record for the IR 345/6 Report.

# 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

7 GPNZ_IR345_6_SEL Character(3) VARCHAR2(3) NOT NULL This Field is to provide the options for the user to select among IR 345 and IR 346 reports.
00=IR 345
01=IR 346

8 GPNZ_IR_LATE_PYMT Signed Number(17,2) DECIMAL(15,2) NOT NULL This Field is used to record any late payment and penalties on the Print IR 345 Run control page.

#	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
7	GPNZ_IR345_6_SEL	Character(3)	VARCHAR2(3) NOT NULL	This Field is to provide the options for the user to select among IR 345 and IR 346 reports. 00=IR 345 01=IR 346
8	GPNZ_IR_LATE_PYMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	This Field is used to record any late payment and penalties on the Print IR 345 Run control page.