PA_PP_DFLTS(SQL Table) |
Index Back |
---|---|
Run Control TableThis 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 |