Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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