COMMITTEE_MEMBR

(SQL Table)
 Index Back

Committee Member Table

COMMITTEE - data table that stores the committee ID(s) (system assigned) associated with a committee type.

  • Parent record: COMMITTEE

    • # 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 COMMITTEE_ID Character(6) VARCHAR2(6) NOT NULL Committee

    Prompt Table: COMMITTEE

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 COMMITTEE_MEMBER Number(3,0) SMALLINT NOT NULL Committee Member Number
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: %EDITTABLE

    6 COMMITTEE_ROLE Character(4) VARCHAR2(4) NOT NULL Committee Role
    ACAD=Academic Member of Committee
    ADMN=Administrative Support
    CHAI=Chair of Committee
    COCH=Co-Chair of Committee
    MMBF=Member of Committee
    MMBR=Administrator of Committee
    STAF=Staff member of Committee
    STDN=Student Member of Committee
    7 START_DT Date(10) DATE NOT NULL Start Date
    8 END_DT Date(10) DATE NOT NULL end date