OPA DISCL ACTIVITIES Table
OPA Disclosure Activities
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_NUMBER |
XXX |
NUMBER |
22 |
COUNTRY_CODE |
The 3 digit code which identifies a country (Example: USA United States of America). |
VARCHAR2 |
3 |
ENTITY_NAME |
XXX |
VARCHAR2 |
60 |
ENTITY_NUMBER |
XXX |
VARCHAR2 |
10 |
HR_DEPARTMENT_NAME |
Name of the department, school, center, or lab. |
VARCHAR2 |
75 |
IS_COMPENSATED |
XXX |
VARCHAR2 |
1 |
IS_FOREIGN |
XXX |
VARCHAR2 |
1 |
NUM_OF_DAYS_ACADEMIC |
XXX |
NUMBER |
22 |
NUM_OF_DAYS_IN_YEAR |
XXX |
NUMBER |
22 |
NUM_OF_DAYS_SUMMER |
XXX |
NUMBER |
22 |
OPA_CYCLE_NUMBER |
XXX |
NUMBER |
22 |
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 |
30 |
PERSON_ID |
XXX |
VARCHAR2 |
9 |
RELATIONSHIP_DESCRIPTION |
XXX |
VARCHAR2 |
4000 |
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 |