OPA DISCL COMPENSATION Table
View exposing OPA disclosure records with compensation activity detail including entity, relationship, time-commitment measures, conflict information, and audit timestamps.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_NUMBER |
Activity number associated with the record. |
NUMBER |
|
APPOINTMENT_PERCENT |
Appointment percent associated with the record. |
NUMBER |
5,2 |
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 |
ENTITY_NAME |
Entity name associated with the record. |
VARCHAR2 |
400 |
HAS_POTENTIAL_CONFLICT |
Has potential conflict associated with the record. |
VARCHAR2 |
1 |
HOME_UNIT |
Home unit associated with the record. |
VARCHAR2 |
8 |
HR_DEPARTMENT_NAME |
Hr department name associated with the record. |
VARCHAR2 |
50 |
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 |
NUM_OF_DAYS_ACADEMIC |
Num of days academic associated with the record. |
NUMBER |
|
NUM_OF_DAYS_IN_YEAR |
Num of days in year associated with the record. |
NUMBER |
|
NUM_OF_DAYS_SUMMER |
Num of days summer associated with the record. |
NUMBER |
|
OPA_CYCLE_NUMBER |
Opa cycle number associated with the record. |
NUMBER |
|
PAYROLL_RANK |
Payroll rank associated with the record. |
VARCHAR2 |
40 |
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 |
RELATIONSHIP_DESCRIPTION |
Relationship description associated with the record. |
VARCHAR2 |
4000 |
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 |