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 |