OPA OTHER PERSON INVL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ENTITY_NAME |
XXX |
VARCHAR2 |
400 |
NUM_OF_DAYS |
XXX |
NUMBER |
5,2 |
OPA_CYCLE_NUMBER |
XXX |
NUMBER |
|
PERSON_ID |
XXX |
VARCHAR2 |
9 |
PERSON_NAME |
XXX |
VARCHAR2 |
90 |
PERSON_NUMBER |
XXX |
NUMBER |
|
PERSON_TYPE |
In the KRB_PERSON and MITID_DB_PERSON tables, PERSON_TYPE is a more specific classification of the type of person: Current employee, Non current employee, Current student, Non current student, Moira account. In the IR AWARD PERSON table, this field identifies whether the person is Faculty, Staff, MIT Alumni, Student, or MIT Corporation member. |
VARCHAR2 |
1 |
PER_RELATIONSHIP_DESCRIPTION |
XXX |
VARCHAR2 |
4000 |
RELATIONSHIP_DESCRIPTION |
XXX |
VARCHAR2 |
4000 |
TYPE_OF_WORK |
XXX |
VARCHAR2 |
4000 |
UPDATE_TIMESTAMP |
Date that a record was last updated by OSP. |
DATE |
|
UPDATE_USER |
Userid of the person who last updated this record. |
VARCHAR2 |
8 |