SSIS Components for SAP Fieldglass

Build 24.0.9060

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 component 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 component.

  • 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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060