Timesheet
Overview
The following table lists the fields in the Timesheet category:
| Field Name | Description |
|---|---|
| Timesheet Number | Unique number assigned to the timesheet within the CCW system |
| Timesheet Status | Indicates the status of the timesheet; for example, Approved. |
| Timesheet Sequence Number | The sequence number of the timesheet |
| CW Number | Unique number assigned to the contingent worker within the CCW system |
| Current Version Flag | Y or N, indicates if this timesheet record is the current version or not |
| Zero Hour Flag | Y or N, indicates if the option to Assign Zero Hours was selected for the timesheet |
| Timesheet Active Flag | Y or N, indicates if the timesheet record is active or not |
| Timesheet Weekly Flag | Y = Weekly timesheet, N = Monthly timesheet |
| Hours Type Name | Name of the type of hours submitted entered on a timesheet, for example Regular Hours, Overtime, etc. |
| Rate Type Name | Name of the rate type associated with hours entered on a timesheet, for example Per Hour. |
| Time Entry Method Name | Method of entering time on the timesheet, Lump Hours or In-Out |
| Shift Name | Name of the shift associated with hours submitted to the timesheet, for example 1st Shift, 2nd Shift, etc. |
| Adjustment Flag | Y or N, indicates whether it is an Adjustment timesheet |
| Work Date | Date that work hours were submitted to a timesheet, displayed in YYYY-MM-DD24HHMMSSZ |
| Start Time | Start time entered on a timesheet for a specific work date |
| End Time | End time entered on a timesheet for a specific work date |
| Start Work Date | The starting work date on the timesheet, displayed as YYYY-MM-DD24HHMMSSZ |
| End Date | The ending work date on the timesheet, displayed as YYYY-MM-DD24HHMMSSZ |
| Period End Date | The end date of the work period associated with the timesheet, displayed as YYYY-MM-DD24HHMMSSZ |
| Pay Code Name | Pay Code associated with the timesheet, if applicable |
| Pay Code Reporting Hours Type | The type of pay code hour used for the timesheet |
| Charge Number | Charge number associated with time entered on a timesheet |
| Task Name | Name of the Task field parameter |
| Timesheet Row Index | Timesheet row index |
| Work Schedule | Work schedule associated with the timesheet |
| Phase Name | Name of the Phase field parameter |
| Regular Hours | Number of hours billed at the Regular rate entered on the timesheet |
| Overtime Hours | Number of hours billed at the Overtime rate entered on the timesheet |
| DT Hours | Number of hours billed at the Double time rate entered on the timesheet |
| Total Hours | Total number of hours entered on the timesheet |
| Metric Hours | Number of hours entered on the timesheet, in metric format. For example, 1.5 hours to represent 1 hour 30 mins. |
| Non Billable Hours | Hours entered on the timesheet that are not billed by the supplier |
| Regular Pay Rate | Hourly rate assigned to the worker on the timesheet for regular hours |
| Currency Code | Currency code used to calculate rates on the timesheet |
| OT Pay Rate | Hourly rate assigned to the worker on the timesheet for overtime hours |
| DT Pay Rate | Hourly rate assigned to the worker on the timesheet for double time hours |
| Supplier Regular Bill Rate | Hourly bill rate associated with the supplier on the timesheet |
| Supplier OT Bill Rate | Hourly Overtime bill rate associated with the supplier on the timesheet |
| Supplier DT Bill Rate | Hourly Double time bill rate associated with the supplier on the timesheet |
| Final Regular Bill Rate | Final hourly bill rate used for the timesheet |
| Final OT Bill Rate | Final hourly Overtime bill rate used for the timesheet |
| Final DT Bill Rate | Final hourly Double time bill rate used for the timesheet |
| Total Amount | Total monetary amount billed for the timesheet |
| CCW Timesheet Flag | Y or N, indicates if the cw entered in their own timesheet or not |
| Timesheet Upload File Date | Date that timesheet was entered in CCW via file upload, if applicable, displayed as YYYY-MM-DD24HHMMSSZ |
| Timesheet Upload File Name | Name of uploaded file used to enter timesheet in CCW, if applicable |
| Timesheet Upload File Approver | Name of individual who approved the uploaded timesheet file |
| Timesheet Created Date | Date timesheet was originally created, displayed as YYYY-MM-DD24HHMMSSZ |
| Timesheet Submitted for Approval Date | Date timesheet was submitted for approval, displayed as YYYY-MM-DD24HHMMSSZ |
| Timesheet Submitted User First Name | First name of CCW user who submitted the timesheet |
| Timesheet Submitted User Last Name | Last name of CCW user who submitted the timesheet |
| Timesheet Submitted User Email | Email address of CCW user who submitted the timesheet |
| Timesheet Approved Date | Date timesheet was marked as Approved, displayed as YYYY-MM-DD24HHMMSSZ |
| Timesheet Approved User Name | Name of CCW user who approved the timesheet |
| Timesheet Create User First Name | First name of CCW user who initially created the timesheet |
| Timesheet Create User Last Name | Last name of CCW user who initially created the timesheet |
| Timesheet Create User Email | Email address of CCW user who initially created the timesheet |
| Timesheet Approver User First Name | First name of CCW user who approved the timesheet |
| Timesheet Approver User Last Name | Last name of CCW user who approved the timesheet |
| Timesheet Approver User Email | Email address of CCW user who approved the timesheet |
| Timesheet Rejected Date | Date timesheet was marked as Rejected, displayed as YYYY-MM-DD24HHMMSSZ |
| Timesheet Rejected Reason Text | Reason entered when timesheet was marked as Rejected |
| Timesheet Rejected Comment | Comment entered when timesheet was marked as Rejected, if one was entered |
| Timesheet Detail Modified Date | Date that the timesheet was last modified |
| Payrolled Flag | Y or N, indicates if the worker has been paid for the period represented by the timesheet |
| Payroll Date | Date that the worker was paid for the period represented by the timesheet, if applicable |
| Sent Flag | Y or N, indicates if the timesheet has been sent or not |
| Processed Flag | Y or N, indicates if the timesheet has been processed or not |
| Timesheet Comment | Comment entered when the timesheet was submitted, if a comment was entered |
| SOW Project Number | Project number associated with the timesheet, if applicable |
| Task Order Number | Task Order number associated with the timesheet, if applicable |
| SOW Project Title | Name of Project associated with the timesheet, if applicable |
| Task Order Name | Name of Task Order associated with the timesheet, if applicable |
| TS Hours Format | Indicates if the Timesheet hours are formatted as metric or hh:mm |