GPBR_RC_CNTPI

(SQL Table)
Index Back

Run Control BATCH PI

Process Automated Earning / Deduction

# 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 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP_OPR_VW

4 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

Prompt Table: GP_PAY_CAL_VW

5 OUTPUTDIR Character(100) VARCHAR2(100) NOT NULL Output Directory
6 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
7 GPBR_PI_BATCH_ID2 Character(5) VARCHAR2(5) NOT NULL Positive Input Batch ID, used to identify a group (batch) of positive input
8 GPBR_PI_BATCH_ID Character(10) VARCHAR2(10) NOT NULL Positive Input Batch ID, used to identify a group (batch) of positive input

Prompt Table: GPBR_BAT_DESCVW

9 DELETE_DATA Character(1) VARCHAR2(1) NOT NULL Clear Data in Temp Table

Y/N Table Edit

Default Value: N

10 PI_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Action Type Positive Input
A=Add
I=Ignore
N=Do Not Process
O=Override
Z=Resolve To Zero

Default Value: O