| Data element |
Definition |
| ACTUAL_END_DATE
Indexed - no
Format - date
May be null? yes |
The actual end date of the faculty member's membership in the committee. |
COMMITTEE_CHAIR
Indexed - no
Format - varchar2(1)
May be null - no |
A flag used to indicate whether the faculty member is the chairperson of the committee.
|
COMMITTEE_FACULTY_ID
Indexed - yes (primary key)
Format - number(12)
May be null? no |
A unique identifier of each faculty committee record. |
|
COMMITTEE_ID
Indexed - no
Format - number
May be null? no
|
The unique identifier of the committee. This value is assigned by the FIS system and is not visible from the application interface. It is intended solely for the internal use in the system.
|
| FASDA_ID
Indexed - no
Format - number
May be null? no
|
A unique system identifier assigned to each unique faculty member in the FIS_FACULTY table. This number is not used in other data collections, and should not be used for reporting. |
| PROPOSED_END_DATE
Indexed - no
Format - date
May be null? yes
|
The proposed end date for the faculty member's membership in the committee. |
| START_DATE
Indexed - no
Format - date
May be null? no |
The start date of the faculty member's membership in the committee.
|
