VC_AWARD(SQL Table) |
Index Back |
---|---|
Variable Comp AwardsThis record stores all Variable Compensation awards for an employee. This is the record that serves as input to NA Payroll and Stock Administration for integration purposes, as well as the source record when VC awards are published for any 3rd-party subscriber. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
3 | VC_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL |
VC Plan ID
Prompt Table: VC_PLAN_TBL |
4 | VC_PAYOUT_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL |
Payout Period ID
Prompt Table: VC_PAYPRD_TBL |
5 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_TBL |
6 | VC_TARGET_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Target Value |
7 | VC_CALC_AWARD | Number(19,6) | DECIMAL(18,6) NOT NULL | Calculated Award |
8 | VC_ADJ_AWARD | Number(19,6) | DECIMAL(18,6) NOT NULL | Adjusted Award |
9 | VC_PERF_FACTOR | Number(20,4) | DECIMAL(19,4) NOT NULL | Performance Factor |
10 | VC_MODIFIER | Number(6,2) | DECIMAL(5,2) NOT NULL | Modifier (%) |
11 | VC_ACTUAL_AWD_AMT | Number(19,6) | DECIMAL(18,6) NOT NULL | Actual Award as amount |
12 | VC_ACTUAL_AWD_UNIT | Number(15,6) | DECIMAL(14,6) NOT NULL | Actual Award |
13 | VC_AWARD_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Variable Comp Award Value |
14 | VC_ORIG_AWD_UNIT | Number(15,6) | DECIMAL(14,6) NOT NULL | Original Award (Units) |
15 | VC_ORIG_AWD_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Original Award Value |
16 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: VC_PLAN_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
17 | VC_AWARD_DT | Date(10) | DATE | Award Date |
18 | VC_AWARD_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Award Status
A=Approved C=Cancelled D=Ready to Submit E=Error I=Initial Calculation J=Rejected P=Paid/Granted R=Recommended S=Submitted T=Accepted Default Value: I Prompt Table: %RECNAME_EDIT |
19 | VC_CARRYOVER_ACCUM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Accumulated Carryover |
20 | VC_CARRYOVER_BAL | Number(19,6) | DECIMAL(18,6) NOT NULL | Carryover Balance |
21 | VC_CALC_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Calculation Source
M=Manual Calculation N=System - Minimum S=System Calculated X=System - Maximum |
22 | GRANT_NBR | Character(10) | VARCHAR2(10) NOT NULL | System assigned grant number used to uniquely identify the grant record. |
23 | ST_PR_DT | Date(10) | DATE | This field is the date that a transaction was sent to payroll. |
24 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table: EARNINGS_TBL |
25 | GROSSUP | Character(1) | VARCHAR2(1) NOT NULL |
Gross-Up
Y/N Table Edit Default Value: N |
26 | SEPCHK_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Separate check flag.
Y/N Table Edit Default Value: N |
27 | REJECTED_REASON | Character(2) | VARCHAR2(2) NOT NULL |
This field is used to identify the reason for rejecting a PI record from Variable Compensation.
01=Invalid Earning Code 02=Invalid Employee ID & Record# 03=Invalid Currency Code 04=Problem in loading to file 05=Transaction already exists 06=Amount Exceeds Payroll Maximum 07=Reject All - Requested by User 08=Cal closed. Retro not allowed. 09=Error populating Gen PI. 10=Error populating VC Plan tbl 11=Error Updating GPVC_ACK_PUB 12=Deleted from GP PI. 13=Invalid Pin Num 14=Calendar Finalized. 15=Negative Amount 99=Expenses Sheet in Error |
28 | PIN_ERN_NUM | Number(8,0) | INTEGER NOT NULL |
Pin Number Earning
Prompt Table: GP_ERN_SRCH |