EMPLIDBENEFIT_PLANFUNCTN_RESULT_NMPA_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 ,B.SERVICE_FR_NAME FROM PS_PERSON A , PS_PA_FNC_RSLT_TBL B WHERE B.FUNCTN_NAME = 'EMPLACCTS' 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 | Parent Contribution Account |
| 6 | SERVICE_FR_NAME | Character(10) | VARCHAR2(10) NOT NULL | Service Function Result Name |