COMM_CATEGRY_VW

(SQL View)
 Index Back

Communication Category View

COMM_CATEGRY_VW is used as an edittable for DERIVED_CM.COMM_CATEGORY and is assigned in RowInit.

SELECT DISTINCT a.common_id , a.institution , a.comm_category , b.effdt , b.eff_status , b.descr FROM ps_communication a , PS_COMM_CATG_TBL b WHERE a.institution = b.institution AND a.comm_category = b.comm_category

  • Related Language Record: CM_CATGRY_VW_LN

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

    Prompt Table: PEOPLE_SRCH

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category

    Prompt Table: COMM_CATG_TBL

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description