VC_PLAN_IDVC_PAYOUT_PRD_IDVC_PAYFORMULA_IDLANGUAGE_CDVC_PAYFORM_LVW(SQL View) |
Index Back |
|---|---|
Prompt view for payout formulaThis related language view is used for prompting the payout formulas on the matrix goals panels. It compares the effdt of the goal definition against the end date of the period for which it is to be used. |
| SELECT A.VC_PLAN_ID , A.VC_PAYOUT_PRD_ID , B.VC_PAYFORMULA_ID , B.LANGUAGE_CD , B.DESCR50 FROM PS_VC_PAYPRD_TBL A , PS_VC_PAYFORM_LNG B WHERE B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VC_PAYFORM_LNG C WHERE C.VC_PAYFORMULA_ID = B.VC_PAYFORMULA_ID AND C.EFFDT <= A.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 | VC_PAYFORMULA_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Formula ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |