VC_PAYOUT_VW(SQL View) |
Index Back |
|---|---|
Determine Alloc - payout vwThis view is used by the Determine Allocations application engine process. |
| SELECT A.VC_PLAN_ID , B.VC_PAYOUT_PRD_ID , A.GB_GROUP_ID , A.VC_MINIMUM_PAYOUT , A.VC_TARGET_PAYOUT , A.VC_MAXIMUM_PAYOUT FROM PS_VC_PLAN_PAYOUT A , PS_VC_PAYPRD_TBL B WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND A.EFFDT = ( SELECT MAX(VC2.EFFDT) FROM PS_VC_PLAN_EFFDT VC2 WHERE VC2.VC_PLAN_ID = B.VC_PLAN_ID AND VC2.EFFDT <= B.PRD_END_DT AND VC2.EFF_STATUS = 'A') |
| # | 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 | VC_MINIMUM_PAYOUT | Character(10) | VARCHAR2(10) NOT NULL | Minimum Payout |
| 5 | VC_TARGET_PAYOUT | Character(10) | VARCHAR2(10) NOT NULL | Target Payout |
| 6 | VC_MAXIMUM_PAYOUT | Character(10) | VARCHAR2(10) NOT NULL | Maximum Payout |