Tableau Connector for Workday

Build 20.0.7740

AcademicAppointee_Appointment_Data

Academic Appointment Snapshot Data

Columns

Name Type References Description
AcademicAppointee_Academic_Appointee_Reference_WID String The unique identifier type. Each
Academic_Appointment_Track_Reference_WID String Contains a unique identifier for an instance of an object.
Academic_Appointment_Track_Reference_Academic_Appointment_Track_ID String Contains a unique identifier for an instance of an object.
Appointment_Track_ID String Unique identifier for academic appointment track.
Track_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Track_Type_Reference_Academic_Track_Type_ID String Contains a unique identifier for an instance of an object.
Appointment_Identifier_Reference_WID String Contains a unique identifier for an instance of an object.
Appointment_Identifier_Reference_Academic_Appointment_Identifier_ID String Contains a unique identifier for an instance of an object.
Position_Reference_WID String Contains a unique identifier for an instance of an object.
Position_Reference_Position_ID String Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_WID String Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_Academic_Unit_ID String Contains a unique identifier for an instance of an object.
Roster_Percent Decimal Percent of the academic appointee's total time on an academic appointment. Between 0.00 and 1.00. May be blank or zero for things like centers and institutes.
Appointment_Start_Date Date Date when the appointment becomes effective or takes effect.
Appointment_End_Date Date Date when the academic appointment is intended to end. To end academic appointments, you must complete an End Academic Appointment Track event.
Track_Start_Date_Override Date Override for academic appointment track start date.
Rank_Reference_WID String Contains a unique identifier for an instance of an object.
Rank_Reference_Academic_Rank_ID String Contains a unique identifier for an instance of an object.
Named_Professorship_Reference_WID String Contains a unique identifier for an instance of an object.
Named_Professorship_Reference_Named_Professorship_ID String Contains a unique identifier for an instance of an object.
Appointment_Specialty_Reference_WID String Contains a unique identifier for an instance of an object.
Appointment_Specialty_Reference_Appointment_Specialty_ID String Contains a unique identifier for an instance of an object.
Constructed_Title String Do not enter, Constructed Title will be defaulted and used if all fields pertaining to rule set for track is supplied.
Appointment_Title String Title for the academic appointment.
Adjusted_Title_Start_Date Date Date when the academic appointment title was designated.
Academic_Review_Date Date Manually maintained date that acts as a reminder to review the academic for promotion. Only applies when the Appointment's Track includes a Promotion program. On an update, the existing value will be retained if not sent.
Related_Academic_Unit_Reference_WID String Contains a unique identifier for an instance of an object.
Related_Academic_Unit_Reference_Academic_Unit_ID String Contains a unique identifier for an instance of an object.
Tenure_Home_Reference_WID String Contains a unique identifier for an instance of an object.
Tenure_Home_Reference_Academic_Unit_ID String Contains a unique identifier for an instance of an object.
Tenure_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Tenure_Status_Reference_Academic_Tenure_Status_ID String Contains a unique identifier for an instance of an object.
Probationary_End_Date Date Date when the tenure probationary period ends.
Tenure_Award_Date Date Date when the academic appointee was awarded tenure.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740