EG_COMMITTEE

(SQL Table)
Index Back

Committees

Committees

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMMITTEE_ID Character(6) VARCHAR2(6) NOT NULL Committee
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

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

Default Value: A

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 COMMITTEE_TYPE Character(10) VARCHAR2(10) NOT NULL Committee Type

Prompt Table: EG_COMMITT_TBL

6 DESCRLONG Long Character CLOB Long Description