FACULTY_DEGREES

Table of degrees obtained by a faculty member

Column Name	Comments	Datatype	Null?
INSTRUCTOR_SSN	The instructor's ID number	VARCHAR2(9)	NOT NULL
DEGREE	The degree obtained by the faculty member	VARCHAR2(6)	NOT NULL
INSTITUTION	The institution at which the degree was obtained	VARCHAR2(6)	NOT NULL
CIP_CODE	The CIP code for the degree	VARCHAR2(6)	NOT NULL
DEGREE_DATE	The date the degree was received	DATE	NOT NULL
SORT_ORDER	This field is not used	NUMBER(2,0)
DEGREE_LEVEL	Not Used - join to FACULTY_DEGREE_TYPES and FACULTY_DEGREE_LEVELS	VARCHAR2(2)