VC_PLAN_IDPrompt Table: VC_PLAN_TBL
EFFDTGB_GROUP_IDPrompt Table: VC_CHK_ENGRP_VW
Prompt Table: VC_PAYFORM_TBL
Prompt Table: VC_PAYFORM_TBL
Prompt Table: VC_PAYFORM_TBL
VC_PLAN_PAYOUT(SQL Table) |
Index Back |
|---|---|
VC Payout Formulas"This record stores the target, minimum, and maximum payout formulas for a each group in a plan or for the entire plan." |
| # | 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 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: VC_CHK_ENGRP_VW |
| 4 | VC_TARGET_PAYOUT | Character(10) | VARCHAR2(10) NOT NULL |
Target Payout
Prompt Table: VC_PAYFORM_TBL |
| 5 | VC_MINIMUM_PAYOUT | Character(10) | VARCHAR2(10) NOT NULL |
Minimum Payout
Prompt Table: VC_PAYFORM_TBL |
| 6 | VC_MAXIMUM_PAYOUT | Character(10) | VARCHAR2(10) NOT NULL |
Maximum Payout
Prompt Table: VC_PAYFORM_TBL |