VC_AWDALCG_VW

(SQL View)
 Index Back

Variable Comp Awards

View on Variable Comp Awards and Personal Data. This view is used in peoplecode for scroll chunking.

SELECT A.EMPLID ,A.EMPL_RCD ,A.VC_PLAN_ID ,A.VC_PAYOUT_PRD_ID ,A.GB_GROUP_ID ,B.NAME ,A.VC_TARGET_VALUE ,A.VC_CALC_AWARD ,A.VC_ADJ_AWARD ,A.VC_PERF_FACTOR ,A.VC_MODIFIER ,A.VC_ACTUAL_AWD_AMT ,A.VC_ACTUAL_AWD_UNIT ,A.VC_AWARD_VALUE ,A.VC_ORIG_AWD_UNIT ,A.VC_ORIG_AWD_VALUE ,A.CURRENCY_CD ,A.VC_AWARD_DT ,A.VC_AWARD_STATUS ,A.VC_CARRYOVER_ACCUM ,A.VC_CARRYOVER_BAL ,A.VC_CALC_SOURCE ,A.GRANT_NBR ,A.ST_PR_DT ,A.ERNCD ,A.PIN_ERN_NUM ,A.GROSSUP ,A.SEPCHK_FLAG ,A.REJECTED_REASON FROM PS_VC_AWARD A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID

# 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 Record
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 NAME Character(50) VARCHAR2(50) NOT NULL Name
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

Default Value: VC_PLAN_TBL.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

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

Prompt Table: VC_AWDSTT_VW

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

Prompt Table: EARNINGS_TBL

26 PIN_ERN_NUM Number(8,0) INTEGER NOT NULL Pin Number Earning
27 GROSSUP Character(1) VARCHAR2(1) NOT NULL Gross-Up
28 SEPCHK_FLAG Character(1) VARCHAR2(1) NOT NULL Separate check flag.
29 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