OPA PERSON Table
View exposing person-level OPA eligibility and disclosure attributes including names, Kerberos username, job and organizational attributes, faculty and appointment indicators, sabbatical dates, cycle number, and exception information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_EMPLOYEE_TYPE |
Admin employee type associated with the record. |
VARCHAR2 |
40 |
ADMIN_ORG_UNIT_ID |
Business identifier for the admin org unit. |
VARCHAR2 |
8 |
ADMIN_ORG_UNIT_TITLE |
Admin org unit title associated with the record. |
VARCHAR2 |
50 |
ADMIN_POSITION_TITLE |
Admin position title associated with the record. |
VARCHAR2 |
50 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
50 |
EMPLOYMENT_PERCENT |
Employment percent associated with the record. |
NUMBER |
28,7 |
EXCEPTION_FLAG |
Indicator identifying whether exception (Y/N). |
VARCHAR2 |
1 |
EXCEPTION_JUSTIFICATION |
Exception justification associated with the record. |
VARCHAR2 |
200 |
FIRST_NAME |
First name associated with the record. |
VARCHAR2 |
50 |
FORM_OF_ADDRESS_SHORT |
Form of address short associated with the record. |
VARCHAR2 |
10 |
FULL_NAME |
Full name associated with the record. |
VARCHAR2 |
100 |
HR_DEPARTMENT_CODE_OLD |
Hr department code old associated with the record. |
VARCHAR2 |
6 |
HR_DEPARTMENT_NAME |
Hr department name associated with the record. |
VARCHAR2 |
50 |
IS_CONSULT_PRIV |
Indicator identifying whether consult priv (Y/N). |
VARCHAR2 |
1 |
IS_FACULTY |
Indicator identifying whether faculty (Y/N). |
VARCHAR2 |
1 |
IS_PAID_APPT |
Indicator identifying whether paid appt (Y/N). |
VARCHAR2 |
1 |
IS_SABBATICAL |
Indicator identifying whether sabbatical (Y/N). |
VARCHAR2 |
1 |
IS_SUMMER_SESSION_APPT |
Indicator identifying whether summer session appt (Y/N). |
VARCHAR2 |
1 |
JOB_ID |
Business identifier for the job. |
VARCHAR2 |
20 |
JOB_TITLE |
Job title associated with the record. |
VARCHAR2 |
50 |
KRB_NAME_UPPERCASE |
Krb name uppercase associated with the record. |
VARCHAR2 |
10 |
LAST_NAME |
Last name associated with the record. |
VARCHAR2 |
50 |
LAST_NOTIFICATION_DATE |
Date associated with last notification. |
DATE |
|
MIDDLE_NAME |
Middle name associated with the record. |
VARCHAR2 |
50 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
OPA_CYCLE_NUMBER |
Opa cycle number associated with the record. |
NUMBER |
|
PAYROLL_RANK |
Payroll rank associated with the record. |
VARCHAR2 |
40 |
SABBATICAL_BEGIN_DATE |
Date associated with sabbatical begin. |
DATE |
|
SABBATICAL_END_DATE |
Date associated with sabbatical end. |
DATE |
|
SCHOOL |
School associated with the record. |
VARCHAR2 |
50 |
SUMMER_SESSION_MONTHS |
Summer session months associated with the record. |
NUMBER |
28,7 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |