INSTRUCTOR STATUS Table
View exposing instructor-status reference data including employee and student indicators, first-year graduate indicator, and student year.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
INSTRUCTOR_STATUS_KEY |
Surrogate key identifying the instructor status. |
VARCHAR2 |
8 |
IS_EMPLOYEE |
Indicator identifying whether employee (Y/N). |
VARCHAR2 |
1 |
IS_FIRST_YEAR_GRAD |
Indicator identifying whether first year grad (Y/N). |
VARCHAR2 |
1 |
IS_PERSON_ACTIVE |
Indicator identifying whether person active (Y/N). |
VARCHAR2 |
1 |
IS_STUDENT |
Indicator identifying whether student (Y/N). |
VARCHAR2 |
1 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |