OPA DISCL ACTIVITIES Table
View exposing disclosed outside-activity detail by cycle and person including entity, relationship description, compensation indicator, time commitment, payroll rank, department, and foreign-country attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_NUMBER |
Activity number associated with the record. |
NUMBER |
|
COUNTRY_CODE |
Code identifying country. |
VARCHAR2 |
3 |
ENTITY_NAME |
Entity name associated with the record. |
VARCHAR2 |
400 |
ENTITY_NUMBER |
Entity number associated with the record. |
VARCHAR2 |
10 |
HR_DEPARTMENT_NAME |
Hr department name associated with the record. |
VARCHAR2 |
50 |
IS_COMPENSATED |
Indicator identifying whether compensated (Y/N). |
VARCHAR2 |
1 |
IS_FOREIGN |
Indicator identifying whether foreign (Y/N). |
VARCHAR2 |
1 |
NUM_OF_DAYS_ACADEMIC |
Num of days academic associated with the record. |
NUMBER |
5,2 |
NUM_OF_DAYS_IN_YEAR |
Num of days in year associated with the record. |
NUMBER |
5,2 |
NUM_OF_DAYS_SUMMER |
Num of days summer associated with the record. |
NUMBER |
5,2 |
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 |
RELATIONSHIP_DESCRIPTION |
Relationship description associated with the record. |
VARCHAR2 |
4000 |
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
8 |