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

HCM_GRAD_GROUP_COMMITTEE Table

Explanation
Contains most current available information about Graduate Group Committees for Workers and Academic Affiliates managed in Workday as of July 1, 2019 or thereafter.

Common Uses

• Determine Graduate Group Committee memberships for Workers and Academic Affiliates, including membership types and term dates.

WORKDAY_ID
PENN_ID
COMMITTEE_MEMBERSHIP_TYPE_ID
GRAD_GROUP_COMMITTEE_CODE
GRAD_GROUP_COMMITTEE_NAME
SPONSORING_ACADEMIC_UNIT_ID
SPONSORING_ACADEMIC_UNIT_DESC
SPONSORING_AU_PENN_COST_CENTER
PRI_PENN_SCH_CTR
PRI_PENN_COST_CENTER
PRI_PENN_AU_COST_CENTER

HCM_ACADEMIC_UNIT (DWHCM)
HCM_PERSON (DWHCM)

      

• The HCM_GRAD_GROUP_COMMITTEE table contains records about graduate group committees managed in Workday, which came into use on July 1, 2019.
• Penn_ID should be used to join HCM_GRAD_GROUP_COMMITTEE 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_GRAD_GROUP_COMMITTEE table does not keep longitudinal history. Historical snapshots of this information are available in the HCM_GRAD_GROUP_COMM_SNAP table, beginning with the OCT-2020 period.
• The HCM_GRAD_GROUP_COMMITTEE table can be found in the DWHCM schema.

Source

Workday, in use at Penn since July 2019.

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