COMMCTXTSFVWLNG

(SQL View)
 Index Back

Communication Context SF View

This view shows Comm Context data for all institutions

SELECT DISTINCT a.comm_category , b.comm_context ,b.language_cd , b.descr , b.descrshort FROM ps_comm_ca_ctx_tbl a , ps_COMM_CTXT_LANG b WHERE a.institution = b.institution AND a.comm_context = b.comm_context AND b.effdt = ( SELECT MAX(c.effdt) FROM ps_COMM_CTXT_LANG c ,PS_COMM_CTXT_TBL F WHERE c.institution = b.institution AND c.comm_context =b.comm_context AND c.effdt <= %CurrentDateIn AND F.eff_status = 'A' AND C.INSTITUTION=F.INSTITUTION AND C.COMM_CONTEXT=F.COMM_CONTEXT AND C.EFFDT=F.EFFDT) AND a.effdt = ( SELECT MAX(d.effdt) FROM ps_comm_ca_ctx_tbl d WHERE d.institution = a.institution AND d.comm_context = a.comm_context AND d.comm_category = a.comm_category AND d.effdt <= %CurrentDateIn)

  • Related Language Record for COMM_CTXT_SFVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category
    2 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description