PA_CLC_SVC_VW

(SQL View)
 Index Back

Calculation Results - VW


select a.calc_name,a.emplid, a.benefit_plan, a.functn_result_nm, a.fld_val_dec_novrd, d.fld_val_dt_novrd, e.fld_val_char_novrd, z.descr, z.functn_name from ps_pa_fnc_rslt_tbl z, ps_pa_clc_val_dec a, ps_pa_fnc_rslt_dfn b, ps_pa_calculation c, PS_PA_CLC_VAL_DT d, ps_pa_clc_val_char e where a.calc_name = c.calc_name and a.functn_result_nm = b.functn_result_nm and b.benefit_plan = a.benefit_plan and b.functn_name = 'SERVICE' and b.effdt <= c.asofdate and a.calc_name = e.calc_name and a.emplid = e.emplid and a.functn_result_nm = e.functn_result_nm and a.benefit_plan = e.benefit_plan and a.calc_name = d.calc_name and a.emplid = d.emplid and a.functn_result_nm = d.functn_result_nm and a.benefit_plan = d.benefit_plan and a.functn_result_nm = z.functn_result_nm and a.benefit_plan = z.benefit_plan

# 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 SERVICE_AMOUNT Number(16,6) DECIMAL(15,6) NOT NULL Service Amount
6 DATE_ATTAINED Date(10) DATE Date Service Amount Attained
7 UNIT_VW Character(4) VARCHAR2(4) NOT NULL Units
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 FUNCTN_NAME Character(10) VARCHAR2(10) NOT NULL Function Name