OPRIDRUN_CNTL_IDDefault Value: INSTALLATION.COMPANY
Prompt Table: COMPANY_TBL
Default Value: 51
Prompt Table: ABSV_PLAN_TBL
Y/N Table Edit
Default Value: N
0=Hire Date
1=Rehire Date
Default Value: 0
ABSV_RUNCTL(SQL Table) |
Index Back |
|---|---|
Vacation Run Control RecordVacation Run Control Record |
| # | 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 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Default Value: INSTALLATION.COMPANY Prompt Table: COMPANY_TBL |
| 4 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
Default Value: 51 |
| 5 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: ABSV_PLAN_TBL |
| 6 | ABSV_CURR_END_DT | Date(10) | DATE | Current Period End Date |
| 7 | ABSV_FUTURE_END_DT | Date(10) | DATE NOT NULL | Future Period End Date |
| 8 | ABSV_REVERSE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Move back one period
Y/N Table Edit Default Value: N |
| 9 | ABSV_HIREDT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Entitlement Based On
0=Hire Date 1=Rehire Date Default Value: 0 |