HCM_ACAD_APPOINTMENT_DETAIL Table - Data Element Index   Tables and Data Elements   Human Capital Management Home   Data Warehouse Home

HCM_ACAD_APPOINTMENT_DETAIL Table

Explanation
This table provides an audit of changes made to an academic appointment track for Workers and Academic Affiliates managed in Workday as of July 1, 2019 or thereafter.  Each row on the table corresponds to the successful completion of a Workday business process like ‘Add Academic Appointment’, ‘Update Academic Appointment’ or ‘End Academic Appointment’.

Common Uses
To review changes to a faculty member's appointment record.

HCM_ACAD_APPOINTMENT (DWHCM)
HCM_ACADEMIC_UNIT (DWHCM)
HCM_JOB_FAMILY (DWHCM)
HCM_PARENT_ACADEMIC_UNIT (DWHCM)
HCM_PARENT_SUPERVISORY_ORG (DWHCM)
HCM_PERSON (DWHCM)
HCM_PERSON_ADDRESS (DWHCM)
HCM_PERSON_CITIZENSHIP_COUNTRY (DWHCM)
HCM_PERSON_CITIZENSHIP_STATUS (DWHCM)
HCM_PERSON_EDUCATION (DWHCM)
HCM_PERSON_LEAVE_OF_ABSENCE (DWHCM)
HCM_PERSON_RACE_ETHNICITY (DWHCM)
HCM_PERSON_VISA (DWHCM)
HCM_POSITION (DWHCM)
HCM_POSITION_COMPENSATION (DWHCM)
HCM_POSITION_COSTING (DWHCM)
HCM_SUPERVISORY_ORG (DWHCM)
HCM_WORKER_ENCUMBRANCE (DWHCM)
HCM_WORKER_PAYMENT (DWHCM)
LKUP_HCM_ACAD_RANK_MAP (DWHCM)

• The HCM_ACAD_APPOINTMENT_DETAIL table contains records about changes to academic (and academic administrative) appointments managed in Workday, which came into use on July 1, 2019.
• Many columns are represented with the suffix “_CURR” or “_PRO”, to indicate the Current or P:roposed data of the appointment record. Current is the value that was present at the time of the appointment event, and Proposed is the new value that it changed to.
• For faculty workers, appointment records are generally, but not always, related to a position (available in HCM_POSITION). In cases where the appointment is not related to a position, the Position_ID values will be null.
• Current records may exist for individuals who are terminated workers with a current academic appointment, including retired Standing or Clinician-Educator faculty with Emeritus appointment.
• Penn_ID should be used to uniquely identify records in HCM_ACAD_APPOINTMENT_DETAIL, and to join HCM_ACAD_APPOINTMENT_DETAIL to other tables in the Warehouse. Workday ID is an 8 digit field for workers and affiliates unique to Workday.  It is distinct from the Penn ID, which has the same format, but is maintained by Penn Community and is the unique identifier for individuals across Penn’s systems.
• Keep in mind that this is the latest information about an individual's appointment records can be found in the HCM_ACAD_APPOINTMENT table, which does not keep longitudinal history. Historical snapshots of this information are available in the HCM_ACAD_APPO_SNAP table, beginning with the JUL-19 period.
• You can access an HCM_ACAD_APPOINTMENT_DETAIL row only if you are authorized to access data for the individual's Pri_Penn_AU_Cost_Center, Pri_Penn_Cost_Center or the Academic_Unit_Penn_Cost_Center for a particular appointment.
• The HCM_ACAD_APPOINTMENT_DETAIL table can be found in the DWHCM schema.

Source

Workday, in use at Penn since July 2019.

HCM_ACAD_APPOINTMENT_DETAIL Table - Data Element Index  Tables and Data Elements   Human Capital Management Home   Data Warehouse Home