VC_PLAN_IDPrompt Table: VC_PLAN_TBL
VC_PAYOUT_PRD_IDPrompt Table: VC_PAYPRD_TBL
GB_GROUP_IDPrompt Table: GB_GROUP_TBL
Default Value: VC_PLAN_TBL.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL
VC_GRP_ALLOC(SQL Table) |
Index Back |
|---|---|
Group Allocation tableThis record stores group allocations (or 'funding') when groups are used by a Variable Compensation plan. If a Variable Comp plan is funded, the funding can be taken one step deeper, in that each group within the Tree is funded or 'allocated' funds. This is the record that stores funding for each 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
Prompt Table: VC_PAYPRD_TBL |
| 3 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_TBL |
| 4 | VC_ORIGINAL_ALLOC | Number(19,6) | DECIMAL(18,6) NOT NULL | Original Allocation |
| 5 | VC_BALANCE_ALLOC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Balance Allocation |
| 6 | VC_RESERVE_BALANCE | Number(19,6) | DECIMAL(18,6) NOT NULL | Reserve Balance |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: VC_PLAN_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
| 8 | NUMBER_OF_EMPL | Number(6,0) | INTEGER NOT NULL | Number of Employees |