VC_AWARD_VW(SQL View) |
Index Back |
|---|---|
Variable Comp Award ViewVariable Comp Award View - by Plan |
| SELECT A.VC_PLAN_ID , A.VC_PAYOUT_PRD_ID , A.GB_GROUP_ID , A.EMPLID , A.EMPL_RCD , 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.GROSSUP , A.SEPCHK_FLAG FROM PS_VC_AWARD A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL |
VC Plan ID
Prompt Table: VC_PLAN_TBL |
| 2 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Payout Period ID
Prompt Table: VC_PAYPRD_TBL |
| 3 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Default Value: NOGROUP Prompt Table: GB_GROUP_TBL |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 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 |
| 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 | GROSSUP | Character(1) | VARCHAR2(1) NOT NULL |
Gross-Up
Default Value: N |
| 24 | SEPCHK_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Separate check flag.
Default Value: N |