OPA OUTSIDE FIN INTERESTS Table
View exposing outside financial interest detail by cycle and person including entity, relationship type, relationship descriptions, foreign indicator, and country code.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COUNTRY_CODE |
Code identifying country. |
VARCHAR2 |
3 |
ENTITY_NAME |
Entity name associated with the record. |
VARCHAR2 |
400 |
FIN_INTEREST_NUMBER |
Fin interest number associated with the record. |
NUMBER |
|
INST_RELATIONSHIP_DESCRIPTION |
Inst relationship description associated with the record. |
VARCHAR2 |
4000 |
IS_FOREIGN |
Indicator identifying whether foreign (Y/N). |
VARCHAR2 |
1 |
OPA_CYCLE_NUMBER |
Opa cycle number associated with the record. |
NUMBER |
|
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 |
RELATIONSHIP_TYPE_CODE |
Code identifying relationship type. |
NUMBER |
|
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
8 |