PA_CLC_CLC_VW(SQL View) |
Index Back |
|---|---|
Calculation Results - VW |
| SELECT DISTINCT A.CALC_NAME ,A.EMPLID ,A.BENEFIT_PLAN ,A.FUNCTN_RESULT_NM ,A.FLD_VAL_DEC_NOVRD ,B.FLD_VAL_DEC_NOVRD ,E.FLD_VAL_CHAR_NOVRD ,F.FLD_VAL_CHAR_NOVRD ,Z.DESCR ,Z.FUNCTN_NAME FROM PS_PA_FNC_RSLT_TBL Z ,PS_PA_CLC_VAL_DEC A ,PS_PA_CLC_VAL_DEC B ,PS_PA_CLC_VAL_CHAR E ,PS_PA_CLC_VAL_CHAR F ,PS_PA_CALCULATION C WHERE Z.FUNCTN_NAME = 'BENCALC' AND A.BENEFIT_PLAN = Z.BENEFIT_PLAN AND A.FUNCTN_RESULT_NM = Z.FUNCTN_RESULT_NM AND A.CALC_NAME = C.CALC_NAME AND A.FLD_NAME = 'BEN_AMT' AND B.CALC_NAME = A.CALC_NAME AND B.EMPLID = A.EMPLID AND B.BENEFIT_PLAN = A.BENEFIT_PLAN AND B.FUNCTN_RESULT_NM = A.FUNCTN_RESULT_NM AND B.FLD_NAME = 'AUTO_AMT' AND E.CALC_NAME = A.CALC_NAME AND E.EMPLID = A.EMPLID AND E.BENEFIT_PLAN = A.BENEFIT_PLAN AND E.FUNCTN_RESULT_NM = A.FUNCTN_RESULT_NM AND E.FLD_NAME = 'FORM_CODE' AND F.CALC_NAME = A.CALC_NAME AND F.EMPLID = A.EMPLID AND F.BENEFIT_PLAN = A.BENEFIT_PLAN AND F.FUNCTN_RESULT_NM = A.FUNCTN_RESULT_NM AND F.FLD_NAME = 'PYMT_FREQ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CALC_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Calculation Name |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 4 | FUNCTN_RESULT_NM |
Character(10) | VARCHAR2(10) NOT NULL | Function Result Name |
| 5 | BEN_AMT | Number(16,6) | DECIMAL(15,6) NOT NULL | Benefit Amount |
| 6 | AUTO_AMT | Number(16,6) | DECIMAL(15,6) NOT NULL | Auto Benefit Amount |
| 7 | FORM_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Form Code
CO=Certain Only Installment JS=Joint & Survivor Annuity LIFE=Life Annuity LIO=Level Income Option LTS=Last to Survive Annuity LUMP=Lump Sum POP=Pop Up Annuity REV=Reversionary Annuity SPJS=Spouse Demonstration JS |
| 8 | PYMT_FREQ | Character(4) | VARCHAR2(4) NOT NULL |
Payment Frequency
0=One Time Payment 1=Annual Payment 12=Monthly Payment 2=Semi-Annual 24=Semi-Monthly Payment 26=BiWeekly Payment 4=Quarterly |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | FUNCTN_NAME | Character(10) | VARCHAR2(10) NOT NULL | Function Name |