EMPLIDACAD=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
EG_COMM_MBR_VW(SQL View) |
Index Back |
|---|---|
Committee Members ViewView of EG_COMMIT_MEMBR. This view shows which committees an employee is involved in. |
| SELECT EMPLID ,COMMITTEE_ID ,EFFDT ,COMMITTEE_MEMBER ,COMMITTEE_ROLE ,START_DT ,END_DT FROM PS_EG_COMMIT_MEMBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COMMITTEE_ID | Character(6) | VARCHAR2(6) NOT NULL | Committee |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | COMMITTEE_MEMBER | Number(3,0) | SMALLINT NOT NULL | Committee Member Number |
| 5 | 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 |
| 6 | START_DT | Date(10) | DATE | Start Date |
| 7 | END_DT | Date(10) | DATE | end date |