VC_PLAN_IDPrompt Table: VC_PLAN_TBL
VC_PAYOUT_PRD_IDGB_GROUP_IDPrompt Table: GB_GROUP_TBL
FROM_QTYPrompt Table: VC_PAYFORM_VW
VC_PAYOUT_SCHED(SQL Table) |
Index Back |
|---|---|
Variable Comp Payout ScheduleThis record is used within Variable Compensation when a performance-based plan uses a Goals Matrix to determine payout. This record stores a schedule which dictates the score ranges and applicable Payout Formula associated with each range. A group's performance is analyzed and attainments entered for each Goal ID entered into the Goals Matrix being used by the plan. The sum of all the goal attainment values is computed as a 'performance' score, which is then used with the Payout Schedule to determine the formula to use to calculate award payouts for each employee within the group. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL |
VC Plan ID
Prompt Table: VC_PLAN_TBL |
| 2 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 3 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_TBL |
| 4 | FROM_QTY |
Number(7,2) | DECIMAL(6,2) NOT NULL | From Quantity |
| 5 | TO_QTY | Number(7,2) | DECIMAL(6,2) NOT NULL | To Quantity |
| 6 | VC_PAYFORMULA_ID | Character(10) | VARCHAR2(10) NOT NULL |
Payout Formula ID
Prompt Table: VC_PAYFORM_VW |