CMNT_CATG_TBL

(SQL Table)
 Index Back

Comment Category Table

Use CMNT_CATG_TBL to maintain the general categories of comments that are made at your institution. Each Comment Category is associated with one Administrative Function. Each is also associated with one or more Inquiry Groups for viewing and access purposes.

  • Related Language Record: CMNT_CATG_LANG

    • # 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 CMNT_CATEGORY Character(6) VARCHAR2(6) NOT NULL Comment 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: CMNT_CATG_TBL.DESCR

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

    Prompt Table: ADM_FUNCTN_TBL

    8 CMNT_UPDATABLE Character(1) VARCHAR2(1) NOT NULL Comment Changes Allowed
    A=Append
    N=No
    Y=Yes

    Default Value: N

    9 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description
    10 SCC_TODO_ANY_TERM Character(1) VARCHAR2(1) NOT NULL Allow Any Term

    Y/N Table Edit

    Default Value: N