Skip to main content

 

 

Coupa Success Portal

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
OT 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

 

  • Was this article helpful?