VC_PRORATE_PRD(SQL Table) |
Index Back |
|---|---|
VC Proration Period DefnThis record defines how proration will be run. This record stores proration frequency as well as the dates the Proration process will be run. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 2 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Payout Period ID
Prompt Table: VC_ELIG_PRD2_VW |
| 3 | VC_PRORATION_FREQ | Character(1) | VARCHAR2(1) NOT NULL |
Proration Frequency
D=Calendar Days K=By Workdays M=Monthly W=Weekly |
| 4 | VC_DATE_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Date Indicator
D=Day of Month E=End of Month |
| 5 | DAY_OF_MONTH | Number(2,0) | SMALLINT NOT NULL | Day of the Month |
| 6 | DAY_OF_WK | Character(1) | VARCHAR2(1) NOT NULL |
Day of the Week
1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday |
| 7 | VC_PRT_RULE_ID | Character(8) | VARCHAR2(8) NOT NULL |
Users have the ability to define proration percentages for different employee statuses in the system. A Rule ID holds the definition to be created centrally and be shared between different VC Plans instead of having to redefine the same propration percentage on each plan.
Prompt Table: VC_PRT_RULE_VW |
| 8 | VC_WRK_DY_RULE_ID | Character(8) | VARCHAR2(8) NOT NULL |
A Working Days Rule ID defines the day pattern for a week. The definition of a day is governed by the value in the VC_DAY_FACTOR field. A '0' (zero) value in the factor would mean a Non-Working day, and a '1' would be identified as a full working day.
Prompt Table: VC_WRK_DY_SCHED |