OPA DISCLOSURE Table
OPA Disclosures
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_PERCENT |
XXX |
NUMBER |
22 |
COMP_OTHER_INST |
XXX |
VARCHAR2 |
1 |
CONFLICT_DESCRIPTION |
XXX |
VARCHAR2 |
4000 |
CREATE_TIMESTAMP |
XXX |
DATE |
7 |
CREATE_USER |
XXX |
VARCHAR2 |
12 |
HAS_POTENTIAL_CONFLICT |
XXX |
VARCHAR2 |
1 |
HOME_UNIT |
The persons primary department. |
VARCHAR2 |
6 |
INST_LOCATION |
XXX |
VARCHAR2 |
200 |
INST_NAME |
XXX |
VARCHAR2 |
200 |
INST_TIME_PERIOD |
XXX |
VARCHAR2 |
200 |
IS_COMPENSATED |
XXX |
VARCHAR2 |
1 |
IS_FACULTY |
The indicator that the person is a member of the faculty (YES, NO). |
VARCHAR2 |
5 |
IS_FALL_SABBATICAL |
XXX |
VARCHAR2 |
1 |
IS_FULL_TIME |
XXX |
VARCHAR2 |
1 |
IS_PART_TIME |
XXX |
VARCHAR2 |
1 |
IS_SPRING_SABBATICAL |
XXX |
VARCHAR2 |
1 |
OBTAINED_APPROVAL |
XXX |
VARCHAR2 |
1 |
OPA_CYCLE_NUMBER |
XXX |
NUMBER |
22 |
OTHER_ACTIVITY_DESCRIPTION |
XXX |
VARCHAR2 |
4000 |
OTHER_ACTIVITY_FLAG |
XXX |
VARCHAR2 |
1 |
OUTSIDE_PROF_ACTIVITY_FLAG |
XXX |
VARCHAR2 |
1 |
PERSON_ID |
XXX |
VARCHAR2 |
9 |
PERSON_NAME |
XXX |
VARCHAR2 |
90 |
RECEIVED_SUMMER_COMP |
XXX |
VARCHAR2 |
1 |
STATUS_FLAG |
XXX |
VARCHAR2 |
1 |
SUBMISSION_TIMESTAMP |
XXX |
DATE |
7 |
SUMMER_COMP_MONTHS |
XXX |
NUMBER |
22 |
UPDATE_TIMESTAMP |
Date that a record was last updated by OSP. |
DATE |
8 |
UPDATE_USER |
Userid of the person who last updated this record. |
VARCHAR2 |
8 |