OPA OTHER PERSON INVL Table
View exposing other-person involvement in outside professional activities including person type, person name, type of work, related entity, relationship descriptions, number of days, and audit fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ENTITY_NAME |
Entity name associated with the record. |
VARCHAR2 |
400 |
NUM_OF_DAYS |
Num of days associated with the record. |
NUMBER |
5,2 |
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 |
PERSON_NAME |
Person name associated with the record. |
VARCHAR2 |
90 |
PERSON_NUMBER |
Person number associated with the record. |
NUMBER |
|
PERSON_TYPE |
Person type associated with the record. |
VARCHAR2 |
1 |
PER_RELATIONSHIP_DESCRIPTION |
Per relationship description associated with the record. |
VARCHAR2 |
4000 |
RELATIONSHIP_DESCRIPTION |
Relationship description associated with the record. |
VARCHAR2 |
4000 |
TYPE_OF_WORK |
Type of work associated with the record. |
VARCHAR2 |
4000 |
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
8 |