VC_PLAN_IDVC_PAYOUT_PRD_IDGB_GROUP_IDD=Ready to Submit
E=Corrections Required
I=Initial Calculation
J=Rejected
P=Paid/Granted
S=Submitted
VC_GRP_AWARD(SQL Table) |
Index Back |
|---|---|
Variable Comp Group TotalsThis record stores values for a group used within a Variable Compensation plan. These values are used during group allocations and award allocations. The Determine Allocations process in Variable Compensation creates the initial row and populates most of the fields. The award status and sent to payroll date are updated after publishing the awards at the group level. |
| # | 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 |
| 3 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 4 | VC_TARGET_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Target Value |
| 5 | VC_GRP_PERF_FACTOR | Number(20,4) | DECIMAL(19,4) NOT NULL | Group Perf Factor |
| 6 | VC_MATRIX_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Matrix Group Value |
| 7 | VC_SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Test Score |
| 8 | VC_GRP_AWD_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Group Award Status
D=Ready to Submit E=Corrections Required I=Initial Calculation J=Rejected P=Paid/Granted S=Submitted |
| 9 | VC_ADJ_FACTOR | Number(19,3) | DECIMAL(18,3) NOT NULL | Adjustment Factor |
| 10 | ST_PR_DT | Date(10) | DATE | This field is the date that a transaction was sent to payroll. |