PA_PP_DFLTS

(SQL Table)
Index Back

Run Control Table

This is a system table used to hold parameters for processes scheduled through Process Scheduler.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

Prompt Table: PA_BEN_PLAN_VW

2 PP_RC_TYPE Character(1) VARCHAR2(1) NOT NULL Periodic Process remote call type is used to indicate the reason the process is called.
E=Eligibility
P=Payments

Default Value: P

3 PERIODIC_CYCLE Character(1) VARCHAR2(1) NOT NULL Periodic Cycle
A=Annual Cycle
M=Monthly Cycle
Q=Quarterly Cycle

Default Value: M

4 ACCT_BAL_IND Character(1) VARCHAR2(1) NOT NULL Employee Account Balances

Y/N Table Edit

Default Value: N

5 CASH_BAL_IND Character(1) VARCHAR2(1) NOT NULL Cash Balances

Y/N Table Edit

Default Value: N

6 SERVICE_IND Character(1) VARCHAR2(1) NOT NULL Service

Y/N Table Edit

Default Value: N

7 PARTIC_IND Character(1) VARCHAR2(1) NOT NULL Participation

Y/N Table Edit

Default Value: N

8 PAYROLL_HIST_IND Character(1) VARCHAR2(1) NOT NULL Payroll History

Y/N Table Edit

Default Value: N

9 EXT_EMP_DATA_IND Character(1) VARCHAR2(1) NOT NULL External Employee Data

Y/N Table Edit

Default Value: N

10 CONS_HRS_IND Character(1) VARCHAR2(1) NOT NULL Consolidated Hours

Y/N Table Edit

Default Value: N

11 CONS_EARN_IND Character(1) VARCHAR2(1) NOT NULL Consolidated Earnings

Y/N Table Edit

Default Value: N

12 CONS_CONTRIB_IND Character(1) VARCHAR2(1) NOT NULL Consolidated Contributions

Y/N Table Edit

Default Value: N

13 PENSION_ST_IND Character(1) VARCHAR2(1) NOT NULL Pension Status Indicator

Y/N Table Edit

Default Value: N

14 DELETE_IND Character(1) VARCHAR2(1) NOT NULL Delete Indicator is used to indicate whether a row has been logically deleted.

Y/N Table Edit

Default Value: N

15 PROCESS_MODE Character(1) VARCHAR2(1) NOT NULL Processing Mode
C=Create New Consolidations
P=Normal Processing
R=Delete and Rebuild

Default Value: P

16 AUTO_RUN Character(1) VARCHAR2(1) NOT NULL Automatically Run.

Y/N Table Edit

Default Value: Y