COMM_CATG_TBL

(SQL Table)
 Index Back

Communication Category Table

COMM_CATG_TBL is where you create general categories of communication for your institution. Each category is associated with one Administrative Function. A category may be associated with one or more Inquiry Groups for access privileges.

  • Related Language Record: COMM_CATG_LANG

  • Parent Record Of COMM_CA_CTX_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: COMM_CATG_TBL.DESCR

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

    Prompt Table: ADM_FUNCTN_TBL

    8 SCC_TODO_ANY_TERM Character(1) VARCHAR2(1) NOT NULL Allow Any Term

    Y/N Table Edit

    Default Value: N