PA_ALIASXVW_LNG

(SQL View)
 Index Back

PA_ALIASX_VW Rel Lng tbl

Related language view for PA_ALIASX_VW; required because the PSPNLFIELD table doesn't have a related language table of its own.

SELECT A.ALIAS_NAME , DD.MENUNAME , DD.BARNAME , DD.ITEMLABEL , C.ITEMLABEL , A.PA_KEYVALUE , BB.LANGUAGE_CD , BB.LBLTEXT FROM PS_PA_ALIAS_XREF A , PSPNLFIELD B , PSPNLFIELDLANG BB , PSPNLGROUPLANG C , PSMENUITEM D , PSMENUITEMLANG DD WHERE A.PA_USEREC = B.RECNAME AND A.PA_USEFIELD = B.FIELDNAME AND C.PNLNAME= B.PNLNAME AND C.PNLGRPNAME = D.PNLGRPNAME AND DD.MENUNAME = D.MENUNAME AND DD.BARNAME = D.BARNAME AND DD.ITEMNAME = D.ITEMNAME AND BB.PNLNAME = B.PNLNAME AND BB.PNLFLDID = B.PNLFLDID AND ((A.PA_USEREC <> 'PA_CUSTOM2') OR (A.PA_USEREC = 'PA_CUSTOM2' AND (C.PNLGRPNAME = 'PLAN_ELIGIBILITY' AND 'P' = ( SELECT CUSTOM_TYPE FROM PS_PA_CUSTOM WHERE CUSTOM_STMT_NAME = A.PA_KEYVALUE)) OR (C.PNLGRPNAME = 'CUSTOM_STATMENT' AND 'C' = ( SELECT CUSTOM_TYPE FROM PS_PA_CUSTOM WHERE CUSTOM_STMT_NAME = A.PA_KEYVALUE)) OR (C.PNLGRPNAME = 'GROUP_DEFINITION' AND 'G' = ( SELECT CUSTOM_TYPE FROM PS_PA_CUSTOM WHERE CUSTOM_STMT_NAME = A.PA_KEYVALUE)) OR (C.PNLGRPNAME = 'BENEFIT_FORMULA' AND 'B' = ( SELECT CUSTOM_TYPE FROM PS_PA_CUSTOM WHERE CUSTOM_STMT_NAME = A.PA_KEYVALUE)) OR (C.PNLGRPNAME = 'STATUS_CODE_DEFINT' AND 'S' = ( SELECT CUSTOM_TYPE FROM PS_PA_CUSTOM WHERE CUSTOM_STMT_NAME = A.PA_KEYVALUE)) OR (C.PNLGRPNAME = 'SPOUSE_ELIGIBILITY' AND 'E' = ( SELECT CUSTOM_TYPE FROM PS_PA_CUSTOM WHERE CUSTOM_STMT_NAME = A.PA_KEYVALUE))))

  • Related Language Record for PA_ALIASX_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ALIAS_NAME Character(10) VARCHAR2(10) NOT NULL Alias Name
    2 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    3 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    4 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
    5 ITEMPANELNAME Character(30) VARCHAR2(30) NOT NULL Panel Name
    6 PA_KEYVALUE Character(18) VARCHAR2(18) NOT NULL Key Field Value
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text