| Data element |
Definition |
ACADEMIC_CATEGORY
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
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. |
ACTIVE_FLAG
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
Indicates whether the job profile is considered active (1) or inactive (0). |
EXEMPT_JOB_FLAG
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether the job profile is considered exempt (1) or non-exempt (0). Under Federal law, employees are either exempt or nonexempt from the Fair Labor Standards Act (FLSA) wage and hour regulations. Monthly-paid positions are exempt, and weekly-paid positions are non-exempt. |
FACULTY_CLASS
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
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 |
JOB_CLASSIFICATION_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system identifier for the classification for the job profile, often used for external reporting. |
JOB_CLASSIFICATION_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Descriptive classification for the job profile, often used for external reporting. |
JOB_FAMILY_GROUP_ID
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system identifier for the grouping of similar job families that includes the job profile. |
JOB_FAMILY_GROUP_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The system identifier for the grouping of similar job families that includes the job profile. |
JOB_FAMILY_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The system identifier for the grouping of similar job profiles that includes the job profile. |
JOB_FAMILY_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The name of the grouping of similar job profiles that includes the job profile. |
JOB_PROFILE_ID
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The system identifier for a job profile. For job profiles converted from legacy systems to Workday, this is the same number as the Job_Class code. |
JOB_PROFILE_NAME
Format VARCHAR2(200)
Indexed? Yes
May be Null? No |
The name of the job profile. |
LAST_EXTRACT_DATE
Format DATE
Indexed? No
May be Null? Yes |
The date on which the record was extracted from Workday and loaded to the Data Warehouse. |
PAY_RATE_TYPE
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Indicates whether workers with the job profile are paid a salary or on an hourly basis. |
PERSONNEL_CLASS
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
The 2-character code that identifies the kind of position associated with the Job_Profile. Derived as follows:
AP (Administrative/Professional): Workday Job Family Group = Staff and Job Profile Exempt Flag = Y
FA (Faculty): Workday Job Family Group = Academic
NE (Non-employees, courtesy appointments, etc): Workday Job Family = Postdoctoral
SS (Support Staff): Workday Job Family Group = Staff and Job Profile Exempt Flag = N
ST (Students): Workday Job Family Group = Student
TS (Temporary Staff): Workday Job Family = Temporary
US (Unionized Staff): Workday Job Family Group = Union |
STANDING_FACULTY_RANK
Format VARCHAR2(200)
Indexed? Yes
May be Null? Yes |
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) |
