VC_PLAN_IDVC_PAYOUT_PRD_IDGB_GROUP_IDEMPLIDEMPL_RCDAWARD_DTL_VW(SQL View) |
Index Back |
|---|---|
VC Award ViewVC Award view for secondary panel on VC_AWD_ALLOC(_WG) panels |
| SELECT VC_AWARDS.VC_PLAN_ID ,VC_AWARDS.VC_PAYOUT_PRD_ID ,VC_AWARDS.GB_GROUP_ID ,VC_AWARDS.EMPLID ,VC_AWARDS.EMPL_RCD ,VC_AWARDS.VC_TARGET_VALUE ,VC_AWARDS.VC_TARGET_VALUE ,PAYOUT_PRD.VC_ORG_PERF_FACTOR ,GRP_AWARDS.VC_GRP_PERF_FACTOR ,VC_AWARDS.VC_PERF_FACTOR ,PLAN_MEM.PRORATE_FACTOR ,VC_AWARDS.VC_CALC_AWARD ,VC_AWARDS.VC_CALC_AWARD ,GRP_AWARDS.VC_ADJ_FACTOR ,VC_AWARDS.VC_ADJ_AWARD ,VC_AWARDS.VC_ADJ_AWARD ,VC_AWARDS.VC_ORIG_AWD_UNIT ,VC_AWARDS.VC_ORIG_AWD_VALUE , VC_PLAN.VC_ORG_PLAN_WEIGHT , VC_PLAN.VC_GRP_PLAN_WEIGHT , VC_PLAN.VC_IND_PLAN_WEIGHT , VC_AWARDS.CURRENCY_CD FROM PS_VC_AWARD_VW VC_AWARDS ,PS_VC_PAYPRD_TBL PAYOUT_PRD , PS_VC_GRP_AWARD GRP_AWARDS , PS_VC_PLAN_MEM PLAN_MEM , PS_VC_PLAN_EFFDT VC_PLAN WHERE VC_AWARDS.VC_PLAN_ID = PAYOUT_PRD.VC_PLAN_ID AND VC_AWARDS.VC_PLAN_ID = GRP_AWARDS.VC_PLAN_ID AND VC_AWARDS.VC_PLAN_ID = PLAN_MEM.VC_PLAN_ID AND VC_AWARDS.VC_PLAN_ID = VC_PLAN.VC_PLAN_ID AND VC_AWARDS.VC_PAYOUT_PRD_ID = PAYOUT_PRD.VC_PAYOUT_PRD_ID AND VC_AWARDS.VC_PAYOUT_PRD_ID = GRP_AWARDS.VC_PAYOUT_PRD_ID AND VC_AWARDS.VC_PAYOUT_PRD_ID = PLAN_MEM.VC_PAYOUT_PRD_ID AND VC_AWARDS.GB_GROUP_ID = GRP_AWARDS.GB_GROUP_ID AND VC_AWARDS.GB_GROUP_ID = PLAN_MEM.GB_GROUP_ID AND VC_AWARDS.EMPLID = PLAN_MEM.EMPLID AND VC_AWARDS.EMPL_RCD = PLAN_MEM.EMPL_RCD AND VC_PLAN.EFFDT = ( SELECT MAX(VC_PLAN2.EFFDT) FROM PS_VC_PLAN_EFFDT VC_PLAN2 WHERE VC_PLAN.VC_PLAN_ID = VC_PLAN2.VC_PLAN_ID AND VC_PLAN2.EFFDT <= PAYOUT_PRD.PRD_END_DT ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 2 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 3 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | VC_TARGET_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Target Value |
| 7 | VC_TARGET_VALUE_UN | Number(19,6) | DECIMAL(18,6) NOT NULL | Target Value |
| 8 | VC_ORG_PERF_FACTOR | Number(20,4) | DECIMAL(19,4) NOT NULL | Organizational Performance Factor field used in variable compensation. |
| 9 | VC_GRP_PERF_FACTOR | Number(20,4) | DECIMAL(19,4) NOT NULL | Group Perf Factor |
| 10 | VC_PERF_FACTOR | Number(20,4) | DECIMAL(19,4) NOT NULL | Performance Factor |
| 11 | PRORATE_FACTOR | Number(8,3) | DECIMAL(7,3) NOT NULL | Prorate Factor |
| 12 | VC_CALC_AWARD | Number(19,6) | DECIMAL(18,6) NOT NULL | Calculated Award |
| 13 | VC_CALC_AWARD_UN | Number(19,6) | DECIMAL(18,6) NOT NULL | Calculated Award |
| 14 | VC_ADJ_FACTOR | Number(19,3) | DECIMAL(18,3) NOT NULL | Adjustment Factor |
| 15 | VC_ADJ_AWARD | Number(19,6) | DECIMAL(18,6) NOT NULL | Adjusted Award |
| 16 | VC_ADJ_AWARD_UN | Number(19,6) | DECIMAL(18,6) NOT NULL | Adjusted Award |
| 17 | VC_ORIG_AWD_UNIT | Number(15,6) | DECIMAL(14,6) NOT NULL | Original Award (Units) |
| 18 | VC_ORIG_AWD_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Original Award Value |
| 19 | VC_ORG_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Org Goal Weight |
| 20 | VC_GRP_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Group Goal Weight |
| 21 | VC_IND_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Ind Goal Weight |
| 22 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |