OPA DISCL COMPENSATION Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_NUMBER |
XXX |
NUMBER |
|
APPOINTMENT_PERCENT |
XXX |
NUMBER |
5,2 |
CONFLICT_DESCRIPTION |
XXX |
VARCHAR2 |
4000 |
CREATE_TIMESTAMP |
XXX |
DATE |
|
CREATE_USER |
XXX |
VARCHAR2 |
8 |
ENTITY_NAME |
XXX |
VARCHAR2 |
400 |
HAS_POTENTIAL_CONFLICT |
XXX |
VARCHAR2 |
1 |
HOME_UNIT |
The persons primary department. |
VARCHAR2 |
8 |
HR_DEPARTMENT_NAME |
Name of the department, school, center, or lab. |
VARCHAR2 |
50 |
IS_COMPENSATED |
XXX |
VARCHAR2 |
1 |
IS_FACULTY |
The indicator that the person is a member of the faculty (YES, NO). |
VARCHAR2 |
1 |
IS_FALL_SABBATICAL |
XXX |
VARCHAR2 |
1 |
IS_FULL_TIME |
XXX |
VARCHAR2 |
1 |
IS_PART_TIME |
XXX |
VARCHAR2 |
1 |
IS_SPRING_SABBATICAL |
XXX |
VARCHAR2 |
1 |
NUM_OF_DAYS_ACADEMIC |
XXX |
NUMBER |
|
NUM_OF_DAYS_IN_YEAR |
XXX |
NUMBER |
|
NUM_OF_DAYS_SUMMER |
XXX |
NUMBER |
|
OPA_CYCLE_NUMBER |
XXX |
NUMBER |
|
PAYROLL_RANK |
Rank of instructors. Eg.: Professor, Teaching Assistant, Lecturer, Assistant Professor, Associate Professor with tenure, Research Assistant, Grad Student Fellow, Associate Professor w/o tenure, Instructor, senior Lecturer, Technical Instructor, etc. |
VARCHAR2 |
40 |
PERSON_ID |
XXX |
VARCHAR2 |
9 |
PERSON_NAME |
XXX |
VARCHAR2 |
90 |
RECEIVED_SUMMER_COMP |
XXX |
VARCHAR2 |
1 |
RELATIONSHIP_DESCRIPTION |
XXX |
VARCHAR2 |
4000 |
STATUS_FLAG |
XXX |
VARCHAR2 |
1 |
SUBMISSION_TIMESTAMP |
XXX |
DATE |
|
SUMMER_COMP_MONTHS |
XXX |
NUMBER |
5,2 |
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 |