Timecards Intermediate Processing Fields

After importing the input fields from the different sources and joining them together, the Time recipe filters out non-relevant or repeated records, creates calculated fields, and removes temporary fields required for calculations. You can access the recipe from the Data Manager Lightning app in your org. This enables you to view all the recipe nodes and see a preview of the data at each stage of the recipe using Salesforce's Data Prep feature. For more information about the Data Prep feature, see the Salesforce Help.

Warning: We recommend that you never modify the Time recipe. This might cause dashboards, lenses, and other recipes to stop working. In addition, any changes that you make to a recipe are lost when you upgrade or reconfigure the app.

Filters

This is the filter node from the Time recipe that relates to the dataset.

Filter Nodes Related to the Timecards Dataset

Filter Node	Description
Filter CS Timecards	Refines the data to only return rows where the timecard headers have been submitted. The submitted field must be true.

Calculated Fields

These are the fields calculated by the Time recipe.

Calculated Fields Created for the Timecards Dataset

Field API Name	Field Label	Description
MondayBranch_CreateDateFields_TRANS	Create Date Field	Takes the resources' work week start day and the start date of the record, then generates the date value by modifying the start date in respect to the work week start day.
TuesdayBranch_CreateDateFields_TRANS
WednesdayBranch_CreateDateFields_TRANS
ThursdayBranch_CreateDateFields_TRANS
FridayBranch_CreateDateFields_TRANS
SaturdayBranch_CreateDateFields_TRANS
SundayBranch_CreateDateFields_TRANS
MondayBranch_UpdateValueWorkedHoursField_TRANS	Update ValueWorkedHours field name	This field is replaced by the Worked Hours field so that each day's Worked Hours field is combined.
TuesdayBranch_UpdateValueWorkedHoursField_TRANS
WednesdayBranch_UpdateValueWorkedHoursField_TRANS
ThursdayBranch_UpdateValueWorkedHoursField_TRANS
FridayBranch_UpdateValueWorkedHoursField_TRANS
SaturdayBranch_UpdateValueWorkedHoursField_TRANS
SundayBranch_UpdateValueWorkedHoursField_TRANS
MondayBranch_CreateWeekDayField_TRANS	Create WeekDay field	Creates the day of the week that the date represents.
TuesdayBranch_CreateWeekDayField_TRANS
WednesdayBranch_CreateWeekDayField_TRANS
ThursdayBranch_CreateWeekDayField_TRANS
FridayBranch_CreateWeekDayField_TRANS
SaturdayBranch_CreateWeekDayField_TRANS
SundayBranch_CreateWeekDayField_TRANS
TimecardHeaderData_CreateLinkedObjectField_TRANS	Create LinkedObject field	Takes the object that relates to the submitted time, then generates the value with the object name.
PlaybookTaskTime_CreateLinkedObjectField_TRANS
PlaybookTime_CreateLinkedObjectField_TRANS
ObjectiveTime_CreateLinkedObjectField_TRANS
SuccessPlanTime_CreateLinkedObjectField_TRANS
MiscellaneousTime_CreateLinkedObjectField_TRANS