GRADUATE AWARD WORK AREA Table
View exposing graduate award work-area detail including appointment sequence, work-area description, related subject, effort percentage, and supervisor attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_NUMBER |
Appointment number associated with the record. |
NUMBER |
10 |
GRADUATE_AWARD_WORK_AREA_KEY |
Surrogate key identifying the graduate award work area. |
NUMBER |
10 |
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
PERCENT_EFFORT |
Percent effort associated with the record. |
VARCHAR2 |
6 |
SUBJECT_CODE |
Code identifying subject. |
VARCHAR2 |
4 |
SUBJECT_NUMBER |
Subject number associated with the record. |
VARCHAR2 |
320 |
SUBJECT_OTHER |
Subject other associated with the record. |
VARCHAR2 |
160 |
SUPERVISOR_FIRST_NAME |
Supervisor first name associated with the person. |
VARCHAR2 |
160 |
SUPERVISOR_HOME_DEPT |
Supervisor home dept associated with the record. |
VARCHAR2 |
16 |
SUPERVISOR_LAST_NAME |
Supervisor last name associated with the person. |
VARCHAR2 |
160 |
SUPERVISOR_MIT_ID |
Business identifier for the supervisor mit. |
VARCHAR2 |
36 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_AREA |
Work area associated with the record. |
VARCHAR2 |
240 |
WORK_AREA_SEQUENCE_NUMBER |
Work area sequence number associated with the record. |
NUMBER |
3 |