Professional Services Automation Data Dictionary

Timecard_Header__c

Label: Timecard

Records the hours and days worked by a resource in a given week. Timecards are associated with a project and may also be logged against an assignment or milestone, or against one or more project tasks. Resources can submit multiple timecards on the Timecard Entry page, accessed by clicking either “Log a Timecard - New UI” or “Log a Timecard with Task Time” on the PSA Links sidebar (depending on whether your organization logs time against project tasks). This object is named Timecard_Header (API name pse__Timecard_Header__c) and has a master-detail relationship with timecard splits.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
Additional_Notes__c Additional Notes Pre-Spring 2018 If aggregated timecards notes on TCEntry UI for similar rows exceeds the limit of 255 chars, then the aggregated notes will be saved in it.

LongTextArea(32768)
Admin_Global_Edit__c Admin Global Edit Pre-Spring 2018 If checked, allows Admin to make 'global' changes to the Timecard, including edits to the Timecard's Project, Resource, Currency, or Date, even if Include In Financials is checked. Config requirement: Actuals Calculation Mode must be set to 'Scheduled'.

Checkbox false
Approved__c Approved Pre-Spring 2018 This checkbox should be checked when the Timecard is approved - typically by a workflow driven by the Status field.

Checkbox false
Approver__c Approver Pre-Spring 2018 Looks up to: User

Lookup false
Assignment__c Assignment Pre-Spring 2018 Looks up to: Assignment__c
Lookup false
Audit_Notes_History__c Audit Notes History Pre-Spring 2018 Stores audit notes history. When a user changes a project or assignment using the Timecard UI and the audit notes exceed 255 characters, older audit notes are moved and appended here.

LongTextArea(32768)
Audit_Notes__c Audit Notes Pre-Spring 2018 TextArea false
Bill_Rate_Defaulted_from_Milestone__c Bill Rate Defaulted from Milestone Pre-Spring 2018 Indicates that the Timecard Bill Rate was initially defaulted from a Milestone (rather than an Assignment).

Checkbox false
Bill_Rate__c Bill Rate Pre-Spring 2018 Currency(18,4) false 0.00
Billable__c Billable Pre-Spring 2018 Checkbox true
Billed__c Billed Pre-Spring 2018 Checkbox false
Cost_Rate_Amount__c Cost Rate Amount Pre-Spring 2018 Number(18,2) false 0.00
Cost_Rate_Currency_Code__c Cost Rate Currency Code Pre-Spring 2018 Text(3) false
Cost_Rate_Exchange_Rate__c Cost Rate Exchange Rate Pre-Spring 2018 Cost Rate Exchange Rate, relative to Corporate Currency, calculated on End Date of Timecard

Number(18,6) false 1.00
Cost_Rate__c Cost Rate Pre-Spring 2018 Formula:
Cost_Rate_Currency_Code__c & ' ' & TEXT(ROUND(Cost_Rate_Amount__c,2))
Text false
Daily_Bill_Rate__c Bill Rate is Daily Rate Pre-Spring 2018 Checkbox false
Daily_Cost_Rate__c Cost Rate is Daily Rate Pre-Spring 2018 Checkbox false
Dated_Bill_Rates_Apply__c Dated Bill Rates Apply Winter 2025 Reserved for future use.

Checkbox false
Days_Worked_Override__c Days Worked Override Pre-Spring 2018 Provides ability to override number of days calculation

Number(8,6) false
Disable_Approval_Auto_Submit__c Disable Approval Auto Submit Pre-Spring 2018 If checked, this should disable any PSA trigger-based automatic submit for approval for the Timecard.

Checkbox false
End_Date__c End Date Pre-Spring 2018 Date true
Errors__c Errors Summer 2024 The error details when an async job fails.

LongTextArea(32768)
Estimated_Time_To_Completion__c Estimated Time To Completion Pre-Spring 2018 Number(8,2) false
Exclude_From_Utilization__c Exclude from Utilization Fall 2020 When selected, this timecard is excluded from utilization calculations.

Checkbox false
Exclude_from_Billing__c Exclude from Billing Pre-Spring 2018 If checked, this should check the Exclude from Billing checkbox on the child Timecard Splits, which has the same effect as Billing Hold, but is intended to reflect a permanent exclusion from Billing Generation.

Checkbox false
Exclude_from_Daily_Maximum__c Exclude from Daily Maximum Pre-Spring 2018 Indicates whether the timecard is excluded from the maximum number of hours set in the max-resource-hours-per-day configuration option that can be entered per day for a resource. See "max-resource-hours-per-day".

Checkbox false
External_Resource__c External Resource Pre-Spring 2018 Checkbox false
Friday_Days__c Friday Days Spring 2023 Used in tracking time when logging time in days instead of hours.

Number(4,3) false 0.00
Friday_Hours__c Friday Hours Pre-Spring 2018 Number(4,2) false 0.00
Friday_Notes__c Friday Notes Pre-Spring 2018 Text(255) false
Hours_To_Days_Rule_Assignment__c Hours To Days Rule (Assignment) Pre-Spring 2018 Formula:
Assignment__r.Hours_to_Days_Rule__c
Text false
Hours_To_Days_Rule_Project__c Hours To Days Rule (Project) Pre-Spring 2018 Formula:
Project__r.Hours_to_Days_Rule__c
Text false
Include_In_Financials__c Include In Financials Pre-Spring 2018 Checkbox false
Invoiced__c Invoiced Pre-Spring 2018 Checkbox false
Location_Fri__c Location - Friday Pre-Spring 2018 Picklist:
ALABAMA
ALASKA
AMERICAN SAMOA
ANZAC
ARIZONA
ARKANSAS
ASIA
CALIFORNIA
CANADA
COLORADO
CONNECTICUT
DELAWARE
DISTRICT OF COLUMBIA
EMEA
FEDERATED STATES OF MICRONESIA
FLORIDA
GEORGIA
GUAM
HAWAII
IDAHO
ILLINOIS
INDIANA
IOWA
KANSAS
KENTUCKY
LATIN AMERICA
LOUISIANA
MAINE
MARSHALL ISLANDS
MARYLAND
MASSACHUSETTS
MEXICO
MICHIGAN
MINNESOTA
MISSISSIPPI
MISSOURI
MONTANA
NEBRASKA
NEVADA
NEW HAMPSHIRE
NEW JERSEY
NEW MEXICO
NEW YORK
NORTH CAROLINA
NORTH DAKOTA
NORTHERN MARIANA ISLANDS
OHIO
OKLAHOMA
OREGON
OTHER
PALAU
PENNSYLVANIA
PUERTO RICO
RHODE ISLAND
SOUTH CAROLINA
SOUTH DAKOTA
TENNESSEE
TEXAS
UTAH
VERMONT
VIRGIN ISLANDS
VIRGINIA
WASHINGTON
WEST VIRGINIA
WISCONSIN
WYOMING
false
Location_Mon__c Location - Monday Pre-Spring 2018 Picklist:
ALABAMA
ALASKA
AMERICAN SAMOA
ANZAC
ARIZONA
ARKANSAS
ASIA
CALIFORNIA
CANADA
COLORADO
CONNECTICUT
DELAWARE
DISTRICT OF COLUMBIA
EMEA
FEDERATED STATES OF MICRONESIA
FLORIDA
GEORGIA
GUAM
HAWAII
IDAHO
ILLINOIS
INDIANA
IOWA
KANSAS
KENTUCKY
LATIN AMERICA
LOUISIANA
MAINE
MARSHALL ISLANDS
MARYLAND
MASSACHUSETTS
MEXICO
MICHIGAN
MINNESOTA
MISSISSIPPI
MISSOURI
MONTANA
NEBRASKA
NEVADA
NEW HAMPSHIRE
NEW JERSEY
NEW MEXICO
NEW YORK
NORTH CAROLINA
NORTH DAKOTA
NORTHERN MARIANA ISLANDS
OHIO
OKLAHOMA
OREGON
OTHER
PALAU
PENNSYLVANIA
PUERTO RICO
RHODE ISLAND
SOUTH CAROLINA
SOUTH DAKOTA
TENNESSEE
TEXAS
UTAH
VERMONT
VIRGIN ISLANDS
VIRGINIA
WASHINGTON
WEST VIRGINIA
WISCONSIN
WYOMING
false
Location_Sat__c Location - Saturday Pre-Spring 2018 Picklist:
ALABAMA
ALASKA
AMERICAN SAMOA
ANZAC
ARIZONA
ARKANSAS
ASIA
CALIFORNIA
CANADA
COLORADO
CONNECTICUT
DELAWARE
DISTRICT OF COLUMBIA
EMEA
FEDERATED STATES OF MICRONESIA
FLORIDA
GEORGIA
GUAM
HAWAII
IDAHO
ILLINOIS
INDIANA
IOWA
KANSAS
KENTUCKY
LATIN AMERICA
LOUISIANA
MAINE
MARSHALL ISLANDS
MARYLAND
MASSACHUSETTS
MEXICO
MICHIGAN
MINNESOTA
MISSISSIPPI
MISSOURI
MONTANA
NEBRASKA
NEVADA
NEW HAMPSHIRE
NEW JERSEY
NEW MEXICO
NEW YORK
NORTH CAROLINA
NORTH DAKOTA
NORTHERN MARIANA ISLANDS
OHIO
OKLAHOMA
OREGON
OTHER
PALAU
PENNSYLVANIA
PUERTO RICO
RHODE ISLAND
SOUTH CAROLINA
SOUTH DAKOTA
TENNESSEE
TEXAS
UTAH
VERMONT
VIRGIN ISLANDS
VIRGINIA
WASHINGTON
WEST VIRGINIA
WISCONSIN
WYOMING
false
Location_Sun__c Location - Sunday Pre-Spring 2018 Picklist:
ALABAMA
ALASKA
AMERICAN SAMOA
ANZAC
ARIZONA
ARKANSAS
ASIA
CALIFORNIA
CANADA
COLORADO
CONNECTICUT
DELAWARE
DISTRICT OF COLUMBIA
EMEA
FEDERATED STATES OF MICRONESIA
FLORIDA
GEORGIA
GUAM
HAWAII
IDAHO
ILLINOIS
INDIANA
IOWA
KANSAS
KENTUCKY
LATIN AMERICA
LOUISIANA
MAINE
MARSHALL ISLANDS
MARYLAND
MASSACHUSETTS
MEXICO
MICHIGAN
MINNESOTA
MISSISSIPPI
MISSOURI
MONTANA
NEBRASKA
NEVADA
NEW HAMPSHIRE
NEW JERSEY
NEW MEXICO
NEW YORK
NORTH CAROLINA
NORTH DAKOTA
NORTHERN MARIANA ISLANDS
OHIO
OKLAHOMA
OREGON
OTHER
PALAU
PENNSYLVANIA
PUERTO RICO
RHODE ISLAND
SOUTH CAROLINA
SOUTH DAKOTA
TENNESSEE
TEXAS
UTAH
VERMONT
VIRGIN ISLANDS
VIRGINIA
WASHINGTON
WEST VIRGINIA
WISCONSIN
WYOMING
false
Location_Thu__c Location - Thursday Pre-Spring 2018 Picklist:
ALABAMA
ALASKA
AMERICAN SAMOA
ANZAC
ARIZONA
ARKANSAS
ASIA
CALIFORNIA
CANADA
COLORADO
CONNECTICUT
DELAWARE
DISTRICT OF COLUMBIA
EMEA
FEDERATED STATES OF MICRONESIA
FLORIDA
GEORGIA
GUAM
HAWAII
IDAHO
ILLINOIS
INDIANA
IOWA
KANSAS
KENTUCKY
LATIN AMERICA
LOUISIANA
MAINE
MARSHALL ISLANDS
MARYLAND
MASSACHUSETTS
MEXICO
MICHIGAN
MINNESOTA
MISSISSIPPI
MISSOURI
MONTANA
NEBRASKA
NEVADA
NEW HAMPSHIRE
NEW JERSEY
NEW MEXICO
NEW YORK
NORTH CAROLINA
NORTH DAKOTA
NORTHERN MARIANA ISLANDS
OHIO
OKLAHOMA
OREGON
OTHER
PALAU
PENNSYLVANIA
PUERTO RICO
RHODE ISLAND
SOUTH CAROLINA
SOUTH DAKOTA
TENNESSEE
TEXAS
UTAH
VERMONT
VIRGIN ISLANDS
VIRGINIA
WASHINGTON
WEST VIRGINIA
WISCONSIN
WYOMING
false
Location_Tue__c Location - Tuesday Pre-Spring 2018 Picklist:
ALABAMA
ALASKA
AMERICAN SAMOA
ANZAC
ARIZONA
ARKANSAS
ASIA
CALIFORNIA
CANADA
COLORADO
CONNECTICUT
DELAWARE
DISTRICT OF COLUMBIA
EMEA
FEDERATED STATES OF MICRONESIA
FLORIDA
GEORGIA
GUAM
HAWAII
IDAHO
ILLINOIS
INDIANA
IOWA
KANSAS
KENTUCKY
LATIN AMERICA
LOUISIANA
MAINE
MARSHALL ISLANDS
MARYLAND
MASSACHUSETTS
MEXICO
MICHIGAN
MINNESOTA
MISSISSIPPI
MISSOURI
MONTANA
NEBRASKA
NEVADA
NEW HAMPSHIRE
NEW JERSEY
NEW MEXICO
NEW YORK
NORTH CAROLINA
NORTH DAKOTA
NORTHERN MARIANA ISLANDS
OHIO
OKLAHOMA
OREGON
OTHER
PALAU
PENNSYLVANIA
PUERTO RICO
RHODE ISLAND
SOUTH CAROLINA
SOUTH DAKOTA
TENNESSEE
TEXAS
UTAH
VERMONT
VIRGIN ISLANDS
VIRGINIA
WASHINGTON
WEST VIRGINIA
WISCONSIN
WYOMING
false
Location_Wed__c Location - Wednesday Pre-Spring 2018 Picklist:
ALABAMA
ALASKA
AMERICAN SAMOA
ANZAC
ARIZONA
ARKANSAS
ASIA
CALIFORNIA
CANADA
COLORADO
CONNECTICUT
DELAWARE
DISTRICT OF COLUMBIA
EMEA
FEDERATED STATES OF MICRONESIA
FLORIDA
GEORGIA
GUAM
HAWAII
IDAHO
ILLINOIS
INDIANA
IOWA
KANSAS
KENTUCKY
LATIN AMERICA
LOUISIANA
MAINE
MARSHALL ISLANDS
MARYLAND
MASSACHUSETTS
MEXICO
MICHIGAN
MINNESOTA
MISSISSIPPI
MISSOURI
MONTANA
NEBRASKA
NEVADA
NEW HAMPSHIRE
NEW JERSEY
NEW MEXICO
NEW YORK
NORTH CAROLINA
NORTH DAKOTA
NORTHERN MARIANA ISLANDS
OHIO
OKLAHOMA
OREGON
OTHER
PALAU
PENNSYLVANIA
PUERTO RICO
RHODE ISLAND
SOUTH CAROLINA
SOUTH DAKOTA
TENNESSEE
TEXAS
UTAH
VERMONT
VIRGIN ISLANDS
VIRGINIA
WASHINGTON
WEST VIRGINIA
WISCONSIN
WYOMING
false
Milestone__c Milestone Pre-Spring 2018 Looks up to: Milestone__c
Lookup false
Monday_Days__c Monday Days Spring 2023 Used in tracking time when logging time in days instead of hours.

Number(4,3) false 0.00
Monday_Hours__c Monday Hours Pre-Spring 2018 Number(4,2) false 0.00
Monday_Notes__c Monday Notes Pre-Spring 2018 Text(255) false
Override_Cost_Group__c Override Cost Group Pre-Spring 2018 If set, it overrides the Group to which the Timecard Header 's Cost Transactions will roll up for Group Actuals, even if its Project or Resource are in a different Group. Note that either way, the Cost Transactions will continue to roll up to the same Project's Project Actuals and same Resource's Resource Actuals.

Looks up to: Grp__c
Lookup false
Override_Cost_Practice__c Override Cost Practice Pre-Spring 2018 If set, it overrides the Practice to which the Timecard Header 's Cost Transactions will roll up for Practice Actuals, even if its Project or Resource are in a different Practice. Note that either way, the Cost Transactions will continue to roll up to the same Project's Project Actuals and same Resource's Resource Actuals.

Looks up to: Practice__c
Lookup false
Override_Cost_Region__c Override Cost Region Pre-Spring 2018 If set, it overrides the Region to which the Timecard Header 's Cost Transactions will roll up for Region Actuals, even if its Project or Resource are in a different Region. Note that either way, the Cost Transactions will continue to roll up to the same Project's Project Actuals and same Resource's Resource Actuals.

Looks up to: Region__c
Lookup false
Override_Revenue_Group__c Override Revenue Group Pre-Spring 2018 If set, it overrides the Group to which the Timecard Header 's Revenue Transactions will roll up for Group Actuals, even if its Project or Resource are in a different Group. Note that either way, the Revenue Transactions will continue to roll up to the same Project's Project Actuals and same Resource's Resource Actuals.

Looks up to: Grp__c
Lookup false
Override_Revenue_Practice__c Override Revenue Practice Pre-Spring 2018 If set, it overrides the Practice to which the Timecard Header 's Revenue Transactions will roll up for Practice Actuals, even if its Project or Resource are in a different Practice. Note that either way, the Revenue Transactions will continue to roll up to the same Project's Project Actuals and same Resource's Resource Actuals.

Looks up to: Practice__c
Lookup false
Override_Revenue_Region__c Override Revenue Region Pre-Spring 2018 If set, it overrides the Region to which the Timecard Header 's Revenue Transactions will roll up for Region Actuals, even if its Project or Resource are in a different Region. Note that either way, the Revenue Transactions will continue to roll up to the same Project's Project Actuals and same Resource's Resource Actuals.

Looks up to: Region__c
Lookup false
Primary_Location__c Primary Location Pre-Spring 2018 Picklist:
ALABAMA
ALASKA
AMERICAN SAMOA
ANZAC
ARIZONA
ARKANSAS
ASIA
CALIFORNIA
CANADA
COLORADO
CONNECTICUT
DELAWARE
DISTRICT OF COLUMBIA
EMEA
FEDERATED STATES OF MICRONESIA
FLORIDA
GEORGIA
GUAM
HAWAII
IDAHO
ILLINOIS
INDIANA
IOWA
KANSAS
KENTUCKY
LATIN AMERICA
LOUISIANA
MAINE
MARSHALL ISLANDS
MARYLAND
MASSACHUSETTS
MEXICO
MICHIGAN
MINNESOTA
MISSISSIPPI
MISSOURI
MONTANA
NEBRASKA
NEVADA
NEW HAMPSHIRE
NEW JERSEY
NEW MEXICO
NEW YORK
NORTH CAROLINA
NORTH DAKOTA
NORTHERN MARIANA ISLANDS
OHIO
OKLAHOMA
OREGON
OTHER
PALAU
PENNSYLVANIA
PUERTO RICO
RHODE ISLAND
SOUTH CAROLINA
SOUTH DAKOTA
TENNESSEE
TEXAS
UTAH
VERMONT
VIRGIN ISLANDS
VIRGINIA
WASHINGTON
WEST VIRGINIA
WISCONSIN
WYOMING
false
Primary_Project_Location__c Primary Project Location Pre-Spring 2018 Looks up to: Project_Location__c
Lookup false
Project_Exchange_Rate__c Project Exchange Rate Pre-Spring 2018 Project (Bill Rate) Exchange Rate, relative to Corporate Currency, calculated on End Date of Timecard

Number(18,6) false 1.00
Project_Location_Fri__c Project Location - Friday Pre-Spring 2018 Looks up to: Project_Location__c
Lookup false
Project_Location_Mon__c Project Location - Monday Pre-Spring 2018 Looks up to: Project_Location__c
Lookup false
Project_Location_Sat__c Project Location - Saturday Pre-Spring 2018 Looks up to: Project_Location__c
Lookup false
Project_Location_Sun__c Project Location - Sunday Pre-Spring 2018 Looks up to: Project_Location__c
Lookup false
Project_Location_Thu__c Project Location - Thursday Pre-Spring 2018 Looks up to: Project_Location__c
Lookup false
Project_Location_Tue__c Project Location - Tuesday Pre-Spring 2018 Looks up to: Project_Location__c
Lookup false
Project_Location_Wed__c Project Location - Wednesday Pre-Spring 2018 Looks up to: Project_Location__c
Lookup false
Project_Methodology_Object__c Project Methodology Pre-Spring 2018 Looks up to: Project_Methodology__c
Lookup false
Project_Methodology__c Project Methodology Pre-Spring 2018 Picklist:
Methodology Step 1
Methodology Step 2
Methodology Step 3
false
Project_Phase_Object__c Project Phase Pre-Spring 2018 Looks up to: Project_Phase__c
Lookup false
Project_Phase__c Project Phase Pre-Spring 2018 Picklist:
Deployment
Design
Development
Maintenance
Planning
Requirements
Strategy
Support
Testing
Training
false
Project_Task_Hours__c Project Task Hours Pre-Spring 2018 Summary
Project__c Project Pre-Spring 2018 Looks up to: Proj__c
Lookup false
Resource__c Resource Pre-Spring 2018 Looks up to: Contact

Lookup false
Saturday_Days__c Saturday Days Spring 2023 Used in tracking time when logging time in days instead of hours.

Number(4,3) false 0.00
Saturday_Hours__c Saturday Hours Pre-Spring 2018 Number(4,2) false 0.00
Saturday_Notes__c Saturday Notes Pre-Spring 2018 Text(255) false
Start_Date__c Start Date Pre-Spring 2018 Date true
Status__c Status Pre-Spring 2018 Picklist:
Approved
Rejected
Saved
Submitted
false
Submitted__c Submitted Pre-Spring 2018 Checkbox false
Summed_Total_Billable_Amount__c Summed Total Billable Amount Winter 2025 Reserved for future use.

Summary
Sunday_Days__c Sunday Days Spring 2023 Used in tracking time when logging time in days instead of hours.

Number(4,3) false 0.00
Sunday_Hours__c Sunday Hours Pre-Spring 2018 Number(4,2) false 0.00
Sunday_Notes__c Sunday Notes Pre-Spring 2018 Text(255) false
Thursday_Days__c Thursday Days Spring 2023 Used in tracking time when logging time in days instead of hours.

Number(4,3) false 0.00
Thursday_Hours__c Thursday Hours Pre-Spring 2018 Number(4,2) false 0.00
Thursday_Notes__c Thursday Notes Pre-Spring 2018 Text(255) false
Time_Credited__c Time Credited Pre-Spring 2018 Checkbox false
Time_Excluded__c Time Excluded Pre-Spring 2018 Checkbox false
Time_Logged_In_Days__c Time Logged in Days Spring 2023 Checkbox used to determine whether time is logged using days instead of hours.

Checkbox false
Time_Logged_With_Start_And_End_Time__c Time Logged with Start And End Time Spring 2024 Flag for indicating that the timecard has been created in start and end time mode.

Checkbox false
Timecard_Notes__c Timecard Notes Pre-Spring 2018 TextArea false
Timecard_UI_Save_Submit_Needed__c Timecard UI Save/Submit Needed Pre-Spring 2018 For administrator use only. Selected if created from the Timecard UI by using Done. Not selected when using Save or Submit from the Timecard UI.

Checkbox false
Timer_Session__c Timer Session Summer 2022 Looks up to: Timer_Session__c
Lookup false
Total_Billable_Amount__c Total Billable Amount Pre-Spring 2018 Formula:
IF(Billable__c,IF(Dated_Bill_Rates_Apply__c, Summed_Total_Billable_Amount__c, IF(Daily_Bill_Rate__c,(Total_Days_Worked__c * Bill_Rate__c),(Total_Hours__c * Bill_Rate__c))), 0.00)
Currency(18,2) false
Total_Cost__c Total Cost Pre-Spring 2018 Formula:
Cost_Rate_Currency_Code__c & " " & TEXT(IF(Daily_Cost_Rate__c,(Cost_Rate_Amount__c * Total_Days_Worked__c),(Cost_Rate_Amount__c * Total_Hours__c)))
Text false
Total_Days_Worked_Advanced__c Total Days Worked Advanced Pre-Spring 2018 A rollup summary of the total days worked from the time card splits based on the hours to days conversion rules employed.

Summary
Total_Days_Worked__c Total Days Worked Pre-Spring 2018 Formula:
IF( NOT(ISNULL(Days_Worked_Override__c)), Days_Worked_Override__c, IF( NOT(ISNULL(Total_Days_Worked_Advanced__c)), Total_Days_Worked_Advanced__c, IF((Sunday_Hours__c>0),1,0) + IF((Monday_Hours__c>0),1,0) + IF((Tuesday_Hours__c>0),1,0) + IF((Wednesday_Hours__c>0),1,0) + IF((Thursday_Hours__c>0),1,0) + IF((Friday_Hours__c>0),1,0) + IF((Saturday_Hours__c>0),1,0) ) )
Number(18,6) false
Total_Hours__c Total Hours Pre-Spring 2018 Formula:
Sunday_Hours__c + Monday_Hours__c + Tuesday_Hours__c + Wednesday_Hours__c + Thursday_Hours__c + Friday_Hours__c + Saturday_Hours__c
Number(18,2) false
Travel_Fri__c Travel - Friday Pre-Spring 2018 Checkbox false
Travel_Mon__c Travel - Monday Pre-Spring 2018 Checkbox false
Travel_Sat__c Travel - Saturday Pre-Spring 2018 Checkbox false
Travel_Sun__c Travel - Sunday Pre-Spring 2018 Checkbox false
Travel_Thu__c Travel - Thursday Pre-Spring 2018 Checkbox false
Travel_Tue__c Travel - Tuesday Pre-Spring 2018 Checkbox false
Travel_Wed__c Travel - Wednesday Pre-Spring 2018 Checkbox false
Travel_Week__c Travel Week Pre-Spring 2018 Formula:
IF(OR(Travel_Sun__c,Travel_Mon__c,Travel_Tue__c,Travel_Wed__c,Travel_Thu__c,Travel_Fri__c,Travel_Sat__c),'Yes','No')
Text false
Tuesday_Days__c Tuesday Days Spring 2023 Used in tracking time when logging time in days instead of hours.

Number(4,3) false 0.00
Tuesday_Hours__c Tuesday Hours Pre-Spring 2018 Number(4,2) false 0.00
Tuesday_Notes__c Tuesday Notes Pre-Spring 2018 Text(255) false
Wednesday_Days__c Wednesday Days Spring 2023 Used in tracking time when logging time in days instead of hours.

Number(4,3) false 0.00
Wednesday_Hours__c Wednesday Hours Pre-Spring 2018 Number(4,2) false 0.00
Wednesday_Notes__c Wednesday Notes Pre-Spring 2018 Text(255) false


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