TimeSheets
Retrieve contingent worker time sheets that are in Draft (with time entries), Rejected, and/or Pending Approval status, depending on a provided parameter using the Time Sheet Download connector.
View Specific Information
The connector will use the SAP Fieldglass API to process WHERE clause conditions built with the following columns and operators. The remaining filter criteria is executed client-side within the connector.
- Time Sheet Status supports the '=' operator. This parameter specifies the status of the time sheets. Available values are: All, Draft, Rejected, Pending Approval, and Revoked. By default, all time sheets are retrieved.
For example, the following queries are processed server-side:
SELECT * FROM TimeSheets WHERE [Time Sheet Status] = 'Draft' SELECT * FROM TimeSheets WHERE [Time Sheet Status] = 'Rejected'
Columns
| Name | Type | Description |
| Time Sheet ID | String | Fieldglass Time Sheet ID |
| Time Sheet Status | String | This parameter specifies the status of the time sheets. Available values are All, Draft, Rejected, Pending Approval, and Revoked. Defaults to All. |
| Time Sheet Start Date | Date | Start Date of Time Sheet |
| Time Sheet End Date | Date | End Date of Time Sheet |
| Time Sheet Submit Date/Time | Datetime | Date and Time when Time Sheet was Submitted by the Worker |
| Time Sheet Approved Date | Date | Date the Time Sheet was fully approved. Blank if Time Sheet is yet to be approved. |
| Time Entry Date | Date | Date for which time is being recorded. |
| Buyer Name | String | Fieldglass Buyer Name |
| Buyer Code | String | Fieldglass Buyer Code |
| Supplier Name | String | Fieldglass Supplier Name |
| Supplier Code | String | Fieldglass Supplier Code |
| Account Name | String | Name of the Account, such as geographical area covered. See Glossary |
| Account Code | String | The unique system identifier for the account. See Glossary |
| Remit To Address Code | String | Supplier's Remit To Address Code |
| Job Posting Owner | String | Fieldglass Job Posting Owner in 'First,Last' format. |
| Work Order ID | String | Fieldglass Work Order ID |
| Worker ID | String | Fieldglass Worker ID |
| Job Seeker ID | String | Fieldglass Job Seeker ID |
| Worker Last Name | String | Worker's Last Name |
| Worker First Name | String | Worker's First Name |
| Site Code | String | Fieldglass Site Code associated to the Worker. |
| Site Name | String | Fieldglass Site Name associated to Site Code above. |
| Business Unit Code | String | Fieldglass Business Unit Code associated to worker. |
| Business Unit Name | String | Fieldglass Business Unit Name related to Business Unit Code above. |
| Final Approver First Name | String | First Name of the Time Sheet's Final Approver. Only appears if the Time Sheet has last approver ID populated. |
| Final Approver Last Name | String | Last Name of the Time Sheet's Final Approver. Only appears if the Time Sheet has last approver ID populated. |
| Final Approver Employee ID | String | Final Approver's Employee ID as stored on their SAP Fieldglass User Profile. |
| Cost Center Code | String | Cost Center Code against which time is being recorded. |
| Cost Center Name | String | Cost Center Name related to the Cost Center Code above. |
| Task Code | String | Task Code against which time is being recorded. |
| Task Name | String | Task Name associated to the Task Code above. |
| General Ledger Account Code | String | General Ledger Account associated to the Task against which time is being recorded. Will be downloaded only when the company is GL enabled. This field is mutually exclusive with Segmented Object Detail. |
| Segmented Object Detail | String | Segmented Object Detail string. Segments will be separated by delimiter on the Segmented Object. Valid delimiters are colon (:), semi-colon (;), pipe (|), and dash (-) Required if 'Enable Segmented Object Detail' configuration set. This field is mutually exclusive with GL Account fields. Note - More than one string can appear for a cost center. |
| Billable Per Diem | Decimal | Amount of any Billable Per Diem to be paid for the Time Entry Date |
| Billable Hours | Decimal | Number of Billable Hours recorded for the Time Entry Date |
| Non-billable Hours | Decimal | Number Non-Billable Hours recorded for the Time Entry Date |
| Total Hours | Decimal | Sum Total of Billable and Non-Billable Hours recorded for the Time Entry Date. |
| Billable Amount | Decimal | Total Amount to be billed for the Time Entry Date |
| Currency | String | Currency in which Billable Amount is to be paid. |
| Rate Category / UOM | String | Rate Category and Unit of Measure for time recorded. |
| Bill Rate Buyer | Decimal | The Bill Rate that the Buyer will pay for each billable hour recorded. |
| Bill Rate Supplier | Decimal | The Bill Rate that the Supplier will receive for each billable hour recorded. |
| Pay Rate | Decimal | The Worker's pay rate. |
| Location Code | String | The location code of the hours against the Rate/Rate Category for that day.Company configuration 'Allow Multiple Locations' must be enabled. Row will be repeated with the exact same information in all columns except the location columns. There will be as many duplicated rows as there are number of locations on the time sheet.The 'Location Code' column does not display on any of the above mentioned downloads until the client has configured the download to do so via the Enabled Fields tab's '+Add Native Fields' hyperlink |
| Work Location Name | String | The location name of the hours against the Rate/Rate Category for that day.Company configuration 'Allow Multiple Locations' must be enabled. Row will be repeated with the exact same information in all columns except the location columns. There will be as many duplicated rows as there are number of locations on the time sheet.The 'Work Location Name' column does not display on any of the above mentioned downloads until the client has configured the download to do so via the Enabled Fields tab's '+Add Native Fields' hyperlink |