OPA DISCLOSURE Table
View exposing outside professional activities disclosure detail by cycle and person including appointment and compensation attributes, conflict indicators, institutional activity information, other-activity descriptions, and submission and audit timestamps.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_PERCENT |
Appointment percent associated with the record. |
NUMBER |
5,2 |
COMP_OTHER_INST |
Comp other inst associated with the record. |
VARCHAR2 |
1 |
CONFLICT_DESCRIPTION |
Conflict description associated with the record. |
VARCHAR2 |
4000 |
CREATE_TIMESTAMP |
Timestamp associated with create. |
DATE |
|
CREATE_USER |
Create user associated with the record. |
VARCHAR2 |
8 |
HAS_POTENTIAL_CONFLICT |
Has potential conflict associated with the record. |
VARCHAR2 |
1 |
HOME_UNIT |
Home unit associated with the record. |
VARCHAR2 |
8 |
INST_LOCATION |
Inst location associated with the record. |
VARCHAR2 |
200 |
INST_NAME |
Inst name associated with the record. |
VARCHAR2 |
200 |
INST_TIME_PERIOD |
Inst time period associated with the record. |
VARCHAR2 |
200 |
IS_COMPENSATED |
Indicator identifying whether compensated (Y/N). |
VARCHAR2 |
1 |
IS_FACULTY |
Indicator identifying whether faculty (Y/N). |
VARCHAR2 |
1 |
IS_FALL_SABBATICAL |
Indicator identifying whether fall sabbatical (Y/N). |
VARCHAR2 |
1 |
IS_FULL_TIME |
Indicator identifying whether full time (Y/N). |
VARCHAR2 |
1 |
IS_PART_TIME |
Indicator identifying whether part time (Y/N). |
VARCHAR2 |
1 |
IS_SPRING_SABBATICAL |
Indicator identifying whether spring sabbatical (Y/N). |
VARCHAR2 |
1 |
OBTAINED_APPROVAL |
Obtained approval associated with the record. |
VARCHAR2 |
1 |
OPA_CYCLE_NUMBER |
Opa cycle number associated with the record. |
NUMBER |
|
OTHER_ACTIVITY_DESCRIPTION |
Other activity description associated with the record. |
VARCHAR2 |
4000 |
OTHER_ACTIVITY_FLAG |
Indicator identifying whether other activity (Y/N). |
VARCHAR2 |
1 |
OUTSIDE_PROF_ACTIVITY_FLAG |
Indicator identifying whether outside prof activity (Y/N). |
VARCHAR2 |
1 |
PERSON_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PERSON_NAME |
Person name associated with the record. |
VARCHAR2 |
90 |
RECEIVED_SUMMER_COMP |
Received summer comp associated with the record. |
VARCHAR2 |
1 |
STATUS_FLAG |
Indicator identifying whether status (Y/N). |
VARCHAR2 |
1 |
SUBMISSION_TIMESTAMP |
Timestamp associated with submission. |
DATE |
|
SUMMER_COMP_MONTHS |
Summer comp months associated with the record. |
NUMBER |
5,2 |
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
8 |