GP_NRP_VCAWD_AD(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 | GP_PKG_ID | Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
4 | VC_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
5 | VC_PAYOUT_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
6 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
7 | VC_TARGET_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Target Value |
8 | VC_CALC_AWARD | Number(19,6) | DECIMAL(18,6) NOT NULL | Calculated Award |
9 | VC_ADJ_AWARD | Number(19,6) | DECIMAL(18,6) NOT NULL | Adjusted Award |
10 | VC_PERF_FACTOR | Number(20,4) | DECIMAL(19,4) NOT NULL | Performance Factor |
11 | VC_MODIFIER | Number(6,2) | DECIMAL(5,2) NOT NULL | Modifier (%) |
12 | VC_ACTUAL_AWD_AMT | Number(19,6) | DECIMAL(18,6) NOT NULL | Actual Award as amount |
13 | VC_ACTUAL_AWD_UNIT | Number(15,6) | DECIMAL(14,6) NOT NULL | Actual Award |
14 | VC_AWARD_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Variable Comp Award Value |
15 | VC_ORIG_AWD_UNIT | Number(15,6) | DECIMAL(14,6) NOT NULL | Original Award (Units) |
16 | VC_ORIG_AWD_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Original Award Value |
17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
18 | VC_AWARD_DT | Date(10) | DATE | Award Date |
19 | 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 |
20 | VC_CARRYOVER_ACCUM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Accumulated Carryover |
21 | VC_CARRYOVER_BAL | Number(19,6) | DECIMAL(18,6) NOT NULL | Carryover Balance |
22 | VC_CALC_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Calculation Source
M=Manual Calculation N=System - Minimum S=System Calculated X=System - Maximum |
23 | GRANT_NBR | Character(10) | VARCHAR2(10) NOT NULL | System assigned grant number used to uniquely identify the grant record. |
24 | ST_PR_DT | Date(10) | DATE | This field is the date that a transaction was sent to payroll. |
25 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
26 | GROSSUP | Character(1) | VARCHAR2(1) NOT NULL | Gross-Up |
27 | SEPCHK_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Separate check flag. |
28 | 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 |
29 | PIN_ERN_NUM | Number(8,0) | INTEGER NOT NULL | Pin Number Earning |