VC_PLAN_IDVC_PAYOUT_PRD_IDLANGUAGE_CDEFFDTDefault Value: %date
VC_MEM_PRD_LANG(SQL View) |
Index Back |
|---|---|
Current Plan informationVariable Comp: this view returns information for the current plan. |
| SELECT E.VC_PLAN_ID , C.VC_PAYOUT_PRD_ID , E2.LANGUAGE_CD , B.EFFDT , E.DESCR50 FROM PS_VC_PLAN_EFFDT B , PS_VC_PAYPRD_TBL C , PS_VC_ELIGSTAT_TBL D , PS_VC_PLAN_TBL E , PS_VC_PLAN_LANG E2 , PS_VC_PAYPRD_TBL F WHERE D.VC_PRCS_COMPLETE = 'Y' AND D.VC_PLAN_ID = B.VC_PLAN_ID AND D.VC_PLAN_ID = E.VC_PLAN_ID AND D.VC_PAYOUT_PRD_ID = C.VC_PAYOUT_PRD_ID AND F.VC_PLAN_ID = C.VC_PLAN_ID AND F.VC_PAYOUT_PRD_ID = C.VC_PAYOUT_PRD_ID AND %EffdtCheck(VC_PLAN_EFFDT, B, F.PRD_END_DT) AND B.EFF_STATUS = 'A' AND B.VC_PLAN_ID = C.VC_PLAN_ID AND E.VC_PLAN_ID = E2.VC_PLAN_ID AND EXISTS ( SELECT 'X' FROM PS_VC_PLAN_MEM A WHERE A.VC_PLAN_ID = D.VC_PLAN_ID AND A.VC_PAYOUT_PRD_ID = D.VC_PAYOUT_PRD_ID) |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |