RB_AAFPSTPRC_VL

(SQL View)
 Index Back

AAF Related Language view

Related language view for CRM common object Search view - AAF Post Process

SELECT A.EOCF_ACTION_TYP_ID , A.EOCF_CONTEXT_ID , B.LANGUAGE_CD , B.EOCF_ACT_TYP_NAME , C.EOCF_CTX_NAME FROM PS_RB_AAF_POSTPRCS A , PS_EOCF_ACTTYP_LNG B , PS_EOCF_CTX_LANG C WHERE A.EOCF_ACTION_TYP_ID = B.EOCF_ACTION_TYP_ID AND A.EOCF_CONTEXT_ID = C.EOCF_CONTEXT_ID AND B.LANGUAGE_CD = C.LANGUAGE_CD

  • Related Language Record for RB_AAF_PSTPRC_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_ACTION_TYP_ID Number(31,0) DECIMAL(31) NOT NULL the unique identifier pointing to a discreet action type configuration

    Prompt Table: EOCF_ACTN_TYPE

    2 EOCF_CONTEXT_ID Number(31,0) DECIMAL(31) NOT NULL the ID value for a configured context

    Prompt Table: EOCF_CONTEXT

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EOCF_ACT_TYP_NAME Character(30) VARCHAR2(30) NOT NULL user-defined name to identify the characteristics of a particular action
    5 EOCF_CTX_NAME Character(50) VARCHAR2(50) NOT NULL context name