ODBC Driver for SAP Fieldglass

Build 23.0.8839

Resources

Retrieve resources using the Resource Download connector.

Columns

Name Type Description
Resource ID String 14-character alphanumeric SAP Fieldglass Resource ID.
Security ID String Security ID assigned to resource. This column will only appear in the file if the Security ID field functionality is activated in SAP Fieldglass for the buyer.
Status String Status of the resource.
First Name String First name of the Worker as defined in SAP Fieldglass.
Last Name String Last name of the Worker as defined in SAP Fieldglass.
Worker Email String Worker's e-mail address.
Buyer Code String Buyer company code.
Supplier Code String Supplier company code.
Buyer Reference Tag String Buyer-designated reference.Only for buyer downloads.
Engagement Manager String Engagement manager's username.
Available Start Date Date Available start date of the resource.
Available End Date Date Available end date of the resource.
Equipment String Indicates if the resource is equipment.
Auto register String Indicates if the resource is auto registered.
Associated Rate Lookup String The Associated Rate Lookup on the corresponding Resource ID. For Resources of Assignment Category, this field contains the rate lookup information. For Resources of Statement of Work Category, this field is blank.
[seg] User selected segment name String Each user selected segment displays as separate columns with a prefix of [seg] next to it and displays the values selected on the Resource ID. The Data Set company configuration must be enabled to view this field. Valid values of the user selectable segments are picked up from the corresponding Resource.
Time Template String Time template associated to the resource.For Resources of Assignment Category, this field contains the time template name.For Resources of Statement of Work Category, this field is blank.
Work Schedule String Work Schedule associated to the resource.For Resources of Assignment Category, this field contains the work schedule information.For Resources of Statement of Work Category, this field is blank.
Work Schedule Effective Date Date Date on which the work schedule for the resource is effective.For Resources of Assignment Category, this field contains the work schedule effective date.For Resources of Statement of Work Category, this field is blank.
Site String Site of the resource.Site codes are defined in the SAP Fieldglass application.
Job Codes String Job codes of the resource.One job code per row will be downloaded.Job codes are defined in the SAP Fieldglass application.
Legal Entity Code String Legal entity code of resource. Users must configure their output to include this field. For Resources of Assignment Category, this field contains the legal entity code. For Resources of Statement of Work Category, this field is blank.
Business Unit Code String Business unit code of resource. Users must configure their output to include this field. For Resources of Assignment Category, this field contains the business unit code. For Resources of Statement of Work Category, this field is blank.
Site Code String Site code of resource. Users must configure their output to include this field. For Resources of Assignment Category, this field contains the site code. For Resources of Statement of Work Category, this field is blank.
Location Code String Location code of resource. Users must configure their output to include this field. For Resources of Assignment Category, this field contains the location code. For Resources of Statement of Work Category, this field is blank.
Allow Rates on the Resource? String Indicates whether rates are allowed on the resouce. The Category field on the resource must be set to 'Assignment'.
Rate Category/UOM String Rate category code.The Category field on the resource must be set to 'Assignment'.
Pay Rate Decimal The rate value for the Rate Category.The Category field on the resource must be set to 'Assignment'.
Bill Rate Decimal The Rate value for the Rate Category.The Category field on the resource must be set to 'Assignment'.
Markup Percentage Decimal This field reflects the numerical value of the markup percentage for the rate. All values entered are in percentage. For example, 1.25% should be entered as 1.25, not .0125.

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