INSTRUCTORS

Base table of instructors (faculty members)

Column Name	Comments	Datatype	Null?
INSTRUCTOR_SSN	The instructor's ID number	VARCHAR2(9)	NOT NULL
ACADEMIC_DEPARTMENT	The department in which instructor teaches	VARCHAR2(2)	NOT NULL
APPROVAL_BEG_QTR	The quarter the instructor approval begins	VARCHAR2(2)
APPROVAL_BEG_YEAR	The year the instructor approval begins	VARCHAR2(4)
APPROVAL_END_QTR	The last quarter in which the instuctor is approved to teach	VARCHAR2(2)
APPROVAL_END_YEAR	The last year in which the instructor is approved to teach	VARCHAR2(4)
CIP_CODE	The instructor's teaching CIP Code	VARCHAR2(6)
PART_TIME_RATE	The rate at which instructor is compensated per course	NUMBER(4,0)
ADJUNCT	Flag indicating that the instructor is adjunct - Y/N	VARCHAR2(1)	NOT NULL
TENURE	The code for the tenure status of the instructor	VARCHAR2(1)	NOT NULL
TENURE_MONTH	The month the faculty member received tenure	VARCHAR2(2)
TENURE_YEAR	The year the faculty member received tenure	VARCHAR2(4)
PROBATIONARY_CREDIT	Any probationary credit towards tenure	VARCHAR2(1)
ACCRUAL_BEGIN_MONTH	The month accrual towards tenure began	VARCHAR2(2)
ACCRUAL_BEGIN_YEAR	The year accrual towards tenure began	VARCHAR2(4)
REVIEW_MONTH	The month of tenure review	VARCHAR2(2)
REVIEW_YEAR	The year of tenure review	VARCHAR2(4)
RANK	The instructor's present rank	VARCHAR2(1)
RANK_MONTH	The month the faculty member received rank	VARCHAR2(2)
RANK_YEAR	The year the faculty member received rank	VARCHAR2(4)
STATE_OF_ORIGIN	The faculty member's state of origin	VARCHAR2(2)
TEACHING_EXPERIENCE	Years of teaching experience for the faculty member	NUMBER(2,0)
FACULTY_EMPLOYMENT_DATE	The date the instructor was employed	DATE
FACULTY_TERMINATION_DATE	The date the instructor was terminated	DATE
FACULTY_TERMINATION_REASON	The reason the instructor's employment terminated	VARCHAR2(2)