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

HCM_ACAD_APPOINTMENT Table

Explanation
Contains most current available information about academic appointments for Workers and Academic Affiliates managed in Workday as of July 1, 2019 or thereafter. There may be more than one row per individual if the individual has multiple appointments.

Common Uses
To determine what academic appointments an faculty member holds (or has held), the track and academic unit for each, when role appointment begins, and the associated position, if one exists.

ACADEMIC_UNIT_PENN_COST_CENTER 
APPOINTMENT_ID
PENN_ID
PRI_PENN_AU_COST_CENTER
PRI_PENN_COST_CENTER
PRI_PENN_SCH_CTR
WORKDAY_AFFILIATE_ID
WORKDAY_EMPLOYEE_ID
      

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 table contains records about academic appointments managed in Workday, which came into use on July 1, 2019.
  • HCM_ACAD_APPOINTMENT includes academic administrative appointments such (e.g., Chair, Dean, Vice Provost, Provost, President).
  • For information about academic appointments managed by FIS, the Faculty Information System in use at Penn from 2009 through 2019, refer to the FIS_ACTION table.
• In Workday, when an appointment is ended via a business process, it’s possible that the appointment Track End Date will change to the effective date on which it’s ended, but the Appointment End itself won’t change. For queries that are sensitive to end dates, examine both the Acad_Appt_End_Date and the Track_End_Date on the HCM_ACADEMIC_APPOINTMENT record. If the Track_End_Date precedes the Acad_Appt_End_Date, the appointment is still considered ended.
• 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 and Job_Profile-related 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, and to join HCM_ACAD_APPOINTMENT 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 with records managed by Workday - the HCM_ACAD_APPOINTMENT table 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 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 table can be found in the DWHCM schema.

Source

Workday, in use at Penn since July 2019.

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