Table of Contents

THE BELOW INFO IS CURRENTLY A PLACEHOLDER FOR WHAT WILL BECOME SIMILAR INFORMATION ON THE PROGRESSIONS REQUIREMENT ANALYSIS

Data Architecture

DDL

CREATE TABLE Application_Key (
    KEY_VARIABLE VARCHAR2(3) NOT NULL,
    KEY_DESCRIPTION VARCHAR2(100),
CONSTRAINT Application_Key_PK PRIMARY KEY(KEY_VARIABLE));
 
CREATE TABLE Departments(
    DEPTABREV VARCHAR2(50) NOT NULL,
    DEPARTMENT VARCHAR2(250),
CONSTRAINT Departments_PK PRIMARY KEY(DEPTABREV));
 
CREATE TABLE Faculty(
    ID1 NUMBER(3) NOT NULL,
    LASTNAME VARCHAR2(100),
    FIRSTNAME VARCHAR2(100),
    MIDINITL VARCHAR2(10),
    TITLE VARCHAR2(100),
    RANK VARCHAR2(100),
    DEPTABREV VARCHAR2(10),
    REQUESTED_MEMBERSHIP VARCHAR2(10),
    MEMBERSHIP_TERMINATED BOOLEAN,
    TERMINATION_DATE DATE,
    CURRENT_MEMBERSHIP VARCHAR2(2),
    APPLICATION_DATE DATE,
    PART_OR_FULL_TIME VARCHAR2(10),
    EDUCATION VARCHAR2(255),
    OTHER_AFFILIATIONS_POSITIONS VARCHAR2(255),
    PRIOR_GRADUATE_TEACHING BOOLEAN,
    COMPLETED_MASTER_THESES_DIRECTED_OR_CO NUMBER(2),
    COMPLETED_DISSERTATIONS_DIRECTED_OR_CO NUMBER(2),
    ACCOMPLISHMENTS VARCHAR2(255),
    ASSOC_MEMBER_YEARS VARCHAR2(2),
    DEPARTMENT_CHAIR VARCHAR2(35),
    COMPLETED_MASTER_THESES_NOT_DIRECTED NUMBER(2),
    CURRENT_MASTER_THESES_DIRECTOR NUMBER(2),
    CURRENT_MASTER_THESES_CO_DIRECTED NUMBER(2),
    CURRENT_MASTER_THESES_NO_DIRECTED NUMBER(2),
    COMPLETED_DISSERTATIONS_NOT_DIRECTED NUMBER(2),
    CURRENT_DISSERTATIONS_DIRECTED NUMBER(2),
    CURRENT_DISSERTATIONS_CO_DIRECTED NUMBER(2),
    CURRENT_DISSERTATIONS_NOT_DIRECTED NUMBER(2),
CONSTRAINT FACULTY_PK PRIMARY KEY(ID1));
 
CREATE TABLE PROGRAMS(
    FIELD1 NUMBER(3) NOT NULL,
    PROGRAM_DESC VARCHAR2(50),
    PROGRAM_CODE VARCHAR2(4),
    GPD VARCHAR2(30),
    GPD_TELEPHONE VARCHAR2(15),
    GPD_EMAIL VARCHAR2(50),
    GPD_MAIL_ADDRESS VARCHAR2(50),
    SUPPORT_STAFF VARCHAR2(40),
    STAFF_PHONE VARCHAR2(15),
    STAFF_EMAIL VARCHAR2(30),
    STAFF_MAIL_ADDRESS VARCHAR2(50),
    DEPARTMENT_CHAIR VARCHAR2(50),
    DEPARTMENT_1 VARCHAR2(50),
    DEPARTMENT_2 VARCHAR2(50),
    DEPARTMENT_3 VARCHAR2(50),
    DEPARTMENT_4 VARCHAR2(50),
    PHD BOOLEAN,
    MA BOOLEAN,
    MS BOOLEAN,
    MPS BOOLEAN,
    MFA BOOLEAN,
    CERTIFICATE BOOLEAN,
    OTHER VARCHAR2(50),
    TRACKS MEMO,
CONSTRAINT PROGRAMS_PK PRIMARY KEY(FIELD1));