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 | Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: PA_BEN_PLAN_VW |
|
| 2 | 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 |