Professional Services Automation Data Dictionary

Time_Date__c

Label: Time Date

Records hours worked on a single date within the date range of a timecard. Timecards have a master-detail relationship with time dates.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Date__c Date Pre-Spring 2018 The date for which the parent Timecard contains the specified number of hours.

Date
Day_Of_Week__c Day Of Week Pre-Spring 2018 Displays the label corresponding to the day of week for the Date field value.

Formula:
CASE(MOD((Date__c-DATE(2000,1,2)),7),0,$Label.common_label_sunday,1,$Label.common_label_monday,2,$Label.common_label_tuesday,3,$Label.common_label_wednesday,4,$Label.common_label_thursday,5,$Label.common_label_friday,$Label.common_label_saturday)
Text
Hours__c Hours Pre-Spring 2018 The number of hours that the parent Timecard contains for the specified date.

Number(4,2)
Timecard__c Timecard Pre-Spring 2018 The parent Timecard for which this Time Date record represents a single hour value for one of its seven contained dates.

Looks up to: Timecard_Header__c
MasterDetail


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.