Data Groups and Records for the Time Repository

The time repository stores reported and calculated time at various levels of time card details. To keep the relationship among the time card data you're extracting, you configure the data group hierarchy, as modeled here.

This image displays a sample four-level data group hierarchy.

Level	Details	Description	User Entities
1	Time card header	A group of hours for a person over the time card period	HWM_EXT_CALCULATED_TIMECARD_HDR_UEHWM_EXT_REPORTED_TIMECARD_HDR_UE
2	Time card header attribute	Additional information that applies to the entire time card period, such as a comment explaining why the person submitted their time card late.	HWM_EXT_CALCULATED_TIMECARD_ATTRIBUTE_HDR_UEHWM_EXT_REPORTED_TIMECARD_ATTRIBUTE_HDR_UE
2	Time card day	A 24-hour period of the time card, such as Monday, Tuesday, or Wednesday	HWM_EXT_CALCULATED_TIMECARD_DAY_UEHWM_EXT_REPORTED_TIMECARD_DAY_UE
3	Time card day attribute	Additional information that applies to a 24-hour period of the time card, such as a comment applicable to all hours for Monday	HWM_EXT_CALCULATED_TIMECARD_ATTRIBUTE_DAY_UEHWM_EXT_REPORTED_TIMECARD_ATTRIBUTE_DAY_UE
3	Time card entry	A range of time defined by start and stop times or a time duration on the time card	HWM_EXT_CALCULATED_TIMECARD_DETAIL_UE HWM_EXT_REPORTED_TIMECARD_DETAIL_UE
4	Time card entry attribute	Additional information that applies to a time entry, such as the project name, payroll time type, and department	HWM_EXT_CALCULATED_TIMECARD_ATTRIBUTE_DETAIL_UEHWM_EXT_REPORTED_TIMECARD_ATTRIBUTE_DETAIL_UE

The time repository has other user entities that're independent of these hierarchy levels. To find all time user entity and database items, search for names that start HWM_EXT.

Extract Refinement

To create filter conditions that refine the extract contents, you can use available database items. Here are some examples:

Status values, such as time card status, approval status, or transfer status
Time consumer, such as project costing or payroll
Selected time attribute values, including custom time attributes
Calculated time, reported time, or both types of time entries
Person name or assignment
HR attributes that you can use to identify the person or assignment values, such as Department, Job, Position, and Manager. For example, all people with Job = X
Date and date ranges, for example, the effective date minus start date of the time card is less than 90 days