GB_OPRIDPNLGRPNAMEVC_PLAN_IDVC_PAYOUT_PRD_IDGB_GROUP_IDVC_PRD_GRP6_VW(SQL View) |
Index Back |
|---|---|
Tree Groups Security ViewVariable Comp: this view returns Trees/groups for a given VC Plan ID. The current plan is used (the last one processed by the eligibility process). GB_OPRID and PNLGRPNAME allow to check if the row is accessible for the current operator and panelgroup. |
| SELECT DISTINCT A.GB_OPRID ,A.PNLGRPNAME ,A.VC_PLAN_ID ,A.VC_PAYOUT_PRD_ID ,A.GB_GROUP_ID ,B.VC_THRSHLD_1 ,B.VC_THRSHLD_2 ,B.VC_THRSHLD_3 ,B.VC_TARGET ,B.VC_STRETCH_1 ,B.VC_STRETCH_2 ,B.VC_STRETCH_3 FROM PS_VC_CHK_TPGRP_VW A ,PS_VC_MTX_GOAL_DEF B WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND A.VC_PAYOUT_PRD_ID = B.VC_PAYOUT_PRD_ID AND A.GB_GROUP_ID = B.GB_GROUP_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GB_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 2 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 3 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 4 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 5 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 6 | VC_THRSHLD_1 | Number(6,2) | DECIMAL(5,2) NOT NULL | Threshold 1 |
| 7 | VC_THRSHLD_2 | Number(6,2) | DECIMAL(5,2) NOT NULL | Threshold 2 |
| 8 | VC_THRSHLD_3 | Number(6,2) | DECIMAL(5,2) NOT NULL | Threshold 3 |
| 9 | VC_TARGET | Number(6,2) | DECIMAL(5,2) NOT NULL | Target |
| 10 | VC_STRETCH_1 | Number(6,2) | DECIMAL(5,2) NOT NULL | Stretch 1 |
| 11 | VC_STRETCH_2 | Number(6,2) | DECIMAL(5,2) NOT NULL | Stretch 2 |
| 12 | VC_STRETCH_3 | Number(6,2) | DECIMAL(5,2) NOT NULL | Stretch 3 |