PA_DFN_EACC_VW

(SQL View)
 Index Back

Function Result - EMPLACCTS

05/12/03 Lee : ICE510481005 - Original create.

SELECT DISTINCT A.FUNCTN_RESULT_NM , B.DESCR FROM PS_PA_FUNCTN_RESLT A , PS_PA_FNC_RSLT_TBL B WHERE A.FUNCTN_NAME = 'EMPLACCTS' AND a.functn_name = b.functn_name AND a.benefit_plan = b.benefit_plan AND a.functn_result_nm = b.functn_result_nm AND EXISTS ( SELECT C.DEFINITION_NAME FROM PS_PA_DFN_ACCOUNT C WHERE c.definition_name = a.definition_name)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description