VC_PLAN_IDPrompt Table: VC_PLAN_TBL
PRD_END_DTVC_PAYOUT_PRD_IDPrompt Table: VC_PAYPRD_TBL
VC_IND_G_WG_VW(SQL View) |
Index Back |
|---|---|
Ind Goal Attainment by GroupThis view is used as a search record to the Individual Goal Attainment by Group panel group. |
| SELECT DISTINCT A.VC_PLAN_ID , C.PRD_END_DT , A.VC_PAYOUT_PRD_ID FROM PS_VC_IND_GOAL A , PS_VC_PLAN_TBL B , PS_VC_PAYPRD_TBL C WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND A.VC_PLAN_ID = C.VC_PLAN_ID AND A.VC_PAYOUT_PRD_ID = C.VC_PAYOUT_PRD_ID AND B.VC_PLAN_MEM_CRIT NOT IN ('A', 'E') |
| # | 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 | PRD_END_DT |
Date(10) | DATE | Pay Period End Date |
| 3 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Payout Period ID
Prompt Table: VC_PAYPRD_TBL |