| Data element |
Definition |
ACADEMIC_CATEGORY
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
A higher-level grouping of faculty classes used for aggregating faculty into groups such as Standing Faculty, Standing Faculty C-E (Clinician-Educator), Associated Faculty, Academic Support Staff, and Emeritus. |
ACADEMIC_RANK_DESC
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The descriptive name of the academic rank for the appointment. |
ACADEMIC_RANK_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The system ID of the academic rank for the appointment. |
ACADEMIC_TRACK_DESC
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The broader categorization of the track type for the appointment (e.g., Standing Faculty, Associated Faculty, Other Academic, Retired). |
ACADEMIC_TRACK_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The system ID of the broader categorization of the track type for the appointment (e.g., Standing Faculty, Associated Faculty, Other Academic, Retired). |
ACADEMIC_TRACK_TYPE_DESC
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The descriptive name of the track type for the appointment. The appointment track is defined based on the type and behavior of the appointment. It yields eligibility information (e.g. tenure, promotion, and sabbatical) and specific ranks are tied to a track type. Track types include Tenure, Clinician-Educator, Research, etc. |
ACADEMIC_TRACK_TYPE_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The system ID of the track type for the appointment. The appointment track is defined based on the type and behavior of the appointment. It yields eligibility information (e.g. tenure, promotion, and sabbatical) and specific ranks are tied to a track type. Track types include Tenure, Clinician-Educator, Research, etc. |
FACULTY_CLASS
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
For faculty jobs, the 3-character code that indicates the faculty classification. Non-faculty will have null values for this column. Derived as follows:
TEN: Workday Job Family ID = Tenure
CLE: Workday Job Family ID = Clinician_Educator
ACN: Workday Job Family ID = Academic_Clinician
RES: Workday Job Family ID = Research_Academic
CLN: Workday Job Family ID = Clinical
ADJ: Workday Job Family ID = Adjunct
VIS: Workday Job Family ID = Visiting and Job Profile ID NOT in (246030,246040)
PRF: Workday Job Family ID = Practice
ART: Workday Job Profile ID = 216027
SUP: Workday Job Family ID = Academic_Support_Staff
EMF: Workday Job Family ID = Emeritus
POS: Workday Job Family ID = Postdoctoral
GRP: Workday Job Family ID = Graduate_Student |
LAST_EXTRACT_DATE
Format DATE
Indexed? No
May be Null? No |
|
STANDING_FACULTY_RANK
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
For standing faculty jobs (all faculty members including Clinician-Educators), the 4-character code that indicates the professorial rank for the Job_Profile. Derived as follows:
FULL: Professor (216000) or Clinician_Educator_Professor (226000)
ASST: Assistant_Professor (216020) or Clinician_Educator_Assistant_Professor (226020)
ASSO: Associate_Professor (216010) or Clinician_Educator_Associate_Professor (226010) |
