VC_AWARD

(SQL Table)
Index Back

Variable Comp Awards

This 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