EVNT3CGRPVWLNG

(SQL View)
 Index Back

Communication Category Vw

COMM_CATG_VW provides a view of the Communication Categories within an Administrative Function that the operator is authorize to enter.

SELECT DISTINCT C.Oprid , A.Institution , A.Admin_Function , A.EVENT_3CS_ID , A.Effdt ,D.LANGUAGE_CD , A.Descr FROM PS_EVNT_3CS_TBL A , PS_EVNT_GRP_3C_TBL B , PS_OPR_GRP_3C_TBL C ,PS_EVNT_3CS_LANG D WHERE A.INSTITUTION = B.INSTITUTION AND A.EVENT_3CS_ID = B.EVENT_3CS_ID AND A.INSTITUTION = C.INSTITUTION AND A.INSTITUTION=D.INSTITUTION AND A.EVENT_3CS_ID =D.EVENT_3CS_ID AND A.EFFDT=D.EFFDT AND B.GROUP_3C = C.GROUP_3C AND C.ENTRY_USE_IND = 'Y'

  • Related Language Record for EVNT_3C_GRP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPR_DEF_TBL_CS

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Prompt Table: ADM_FUNCTN_TBL

    4 EVENT_3CS_ID Character(10) VARCHAR2(10) NOT NULL 3Cs event ID

    Prompt Table: EVNT_3CS_TBL

    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description