SSR_CMTEE_MEMB

(SQL View)
 Index Back

Committee Member Table

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

SELECT a.INSTITUTION , a.COMMITTEE_ID , a.EFFDT , b.COMMITTEE_MEMBER , b.EMPLID , b.COMMITTEE_ROLE , b.START_DT , b.END_DT , a.EFF_STATUS FROM PS_COMMITTEE a , PS_COMMITTEE_MEMBR b WHERE a.INSTITUTION=b.INSTITUTION AND a.COMMITTEE_ID=b.COMMITTEE_ID AND a.EFFDT=b.EFFDT

  • 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: SCC_PERS_SA_VW

    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
    9 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive