PA_EACCT_WDR_VW

(SQL View)
 Index Back

EE Acct Functn Result for Plan


SELECT A.EMPLID ,B.BENEFIT_PLAN ,B.FUNCTN_RESULT_NM ,B.DESCR ,B.EACCT_FR_NAME ,C.SERVICE_FR_NAME FROM PS_PERSON A , PS_PA_FNC_RSLT_TBL B , PS_PA_EA_SV_FR_TBL C WHERE B.BENEFIT_PLAN = C.BENEFIT_PLAN AND B.FUNCTN_NAME = 'EMPLACCTS' AND B.FUNCTN_RESULT_NM = C.FUNCTN_RESULT_NM AND B.EACCT_TYPE = '2' AND B.FUNCTN_RESULT_NM NOT IN ( SELECT C.FUNCTN_RESULT_NM FROM PS_PA_EACCT_ACCUM C , PS_PA_FNC_RSLT_TBL D WHERE D.FUNCTN_NAME = 'EMPLACCTS' AND D.EACCT_TYPE = '2' AND C.EMPLID = A.EMPLID AND C.FUNCTN_RESULT_NM = D.FUNCTN_RESULT_NM AND C.END_BALANCE > 0 AND C.END_DATE = ( SELECT MAX(E.END_DATE) FROM PS_PA_EACCT_ACCUM E WHERE E.EMPLID = A.EMPLID AND E.FUNCTN_RESULT_NM = D.FUNCTN_RESULT_NM))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
3 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 EACCT_FR_NAME Character(10) VARCHAR2(10) NOT NULL This field represents a Contribution Employee Account Function Result.
6 SERVICE_FR_NAME Character(10) VARCHAR2(10) NOT NULL Service Function Result.