| Job Seeker ID |
Text |
16 |
Yes |
Valid SAP Fieldglass Job Seeker ID |
SAP Fieldglass Job Seeker ID. |
| Worker ID |
Text |
16 |
Yes |
Valid SAP Fieldglass Worker ID |
SAP Fieldglass Worker ID. |
| Person ID |
Text |
24 |
Yes, for Temp and SOW workers. Optional for Profile workers. |
Valid Person ID
Examples:
1002
1003
|
Unique identifier for the worker as a person. |
| Security ID |
Text |
100 |
No |
|
This column will only appear in the file if the security ID field functionality is activated in SAP Fieldglass for the buyer. If the functionality is not activated, this column will not be in the file. |
| Status |
Text |
50 |
Yes |
Valid values are:
Active
Closed
Created
Pending
Pending Approval
Approval Paused
Rejected
|
Status of the worker. |
| First Name |
Text |
100 |
Yes |
|
First name of the Worker as defined in SAP Fieldglass. |
| Last Name |
Text |
100 |
Yes |
|
Last name of the Worker as defined in SAP Fieldglass. |
| Worker Email |
Text |
100 |
Yes |
|
Worker’s e-mail address. |
| Job Posting Title |
Text |
100 |
Yes |
|
Job Posting’s Title or SOW Name for SOW Workers. |
| Work Order ID |
Text |
16 |
Yes |
Valid SAP Fieldglass Work Order ID |
Work Order ID. |
| Work Order/Work Order Revision Owner |
Text |
100 |
Yes |
|
Work Order Owner’s name. |
| Work Order/Work Order Revision Owner Employee ID |
Text |
50 |
No |
|
Work Order Owner’s Employee ID. |
| Business Unit Code |
Text |
100 |
Yes |
Valid SAP Fieldglass Business Unit Code |
Business Unit Code. |
| Business Unit Name |
Text |
100 |
Yes |
|
Business Unit Name. |
| Vendor Number |
Text |
6 |
Yes |
|
SAP Fieldglass Supplier code for buyer. |
| Vendor Name |
Text |
200 |
Yes |
|
Supplier name. |
| Buyer Code |
Text |
6 |
Yes |
|
Buyer Company Code. |
| Remit To address Code |
Text |
100 |
No |
|
Code as assigned to the Remit To Address by supplier. |
| Cost Center Name |
Text |
200 |
No |
Valid SAP Fieldglass Cost Center Code |
Cost Center Name in SAP Fieldglass. |
| Cost Center Code |
Text |
200 |
Yes |
|
Cost Center Code in SAP Fieldglass. |
| Billable Per Diem |
Decimal |
|
No |
Amount that is billable.
Example:
75.00
|
|
| Start Date |
Date |
|
Yes |
|
Work order start date. |
| End Date |
Date |
|
Yes |
|
Work order end date. |
| Currency |
Text |
100 |
Yes |
|
ISO currency designation (ex. USD). |
| Site Code |
Text |
100 |
Yes |
Valid SAP Fieldglass Site Code |
Site Code. |
| Site Name |
Text |
100 |
Yes |
|
Site Name. |
|
Rate Category/UOM
|
Text |
100 |
Yes |
|
Worker’s Rate Category/Unit Of Measure for which the corresponding rate will be displayed.
More than one Rate Category/UOM may exist for a single Worker. If this is the case a new line will appear for each associated Rate Category/UOM in this file.
|
| Bill Rate |
Decimal |
|
Yes |
|
Worker’s Bill Rate that is associated to the Rate Category/UOM listed in the previous field. |
| Pay Rate |
Decimal |
|
Yes |
|
Worker’s Pay Rate that is associated to the Rate Category/UOM listed in the previous field.
If Supplier did not enter a Pay Rate, 0.00 will be displayed.
|
| Sequence |
Number |
|
Yes |
|
Work Order Revision Number. |
|
Segmented Object Detail
|
Text |
2000 |
Conditional
|
Examples:
IS|Admin|12001
IS-Admin-12001
IS;Admin;12001
IS:Admin:12001
|
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 ‘Segmented object detail’ configuration is set.
This field is mutually exclusive with GL Account fields.
More than one string can appear for a cost center.
|
|
Worker Country of Origin
|
Text
|
3
|
Conditional
|
Valid SAP Fieldglass country codes
Examples:
GER
USA
|
Indicates worker's country of origin.
Company configurations 'Security ID format by worker country of origin' and 'Security Information' must be enabled.
|
|
Time Zone
|
Text
|
100
|
No
|
Examples:
GMT-06:00 Central Time (US & Canada)
or
GMT-05:00 Eastern Time (US & Canada)
or
GMT Greenwich Mean Time.
|
Time zone for worker.
If not entered, it is defaulted to the default setting of buyer's time zone.
|
|
Discount %
|
Decimal
|
|
No
|
Valid values are 0-100, up to 3 decimal places
|
Discount % from SOW Worker.
|
|
Primary Location
|
Text
|
100
|
No
|
|
Indicates primary location name when at least one sub-configuration for the company configuration Use multiple locations is enabled.
Client must configure the download to include this field via the Enabled Fields +Add Native Fields hyperlink.
|
|
Primary Location Code
|
Text
|
100
|
No
|
Valid SAP Fieldglass location code
|
Indicates primary location code when at least one sub-configuration for the company configuration Use multiple locations is enabled.
Client must configure the download to include this field via the Enabled Fields +Add Native Fields hyperlink.
|
|
Location Code
|
Text
|
100
|
Conditional
|
Valid SAP Fieldglass location code
|
The location code of the hours against the Rate/Rate Category for that day.
Enable at least one sub-configuration for the company configuration Use multiple locations. If the download’s parameters pull a document with multiple locations, the row is 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.
|
|
Work Location Name
|
Text
|
100
|
Conditional
|
|
The location name of the hours against the Rate/Rate Category for that day.
Enable at least one sub-configuration for the company configuration Use multiple locations. If the download’s parameters pull a document with multiple locations, the row is 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.
|
|
Original Revision Start Date
|
Date
|
|
No
|
|
This field returns the Start Date from the original work order regardless of what revision the work order is currently on.
|
| [c] Work Order Custom Fields |
Text |
4000 |
Depends on custom field configuration. |
|
Custom fields found on the work order/work order revision.
If there are many custom fields, there will be many columns. Column header format will be:
“[c] modulename_custom field name” (i.e. [c] followed by module custom text lowercase with no spaces, followed by underscore, followed by the custom field name text as defined by users in the SAP Fieldglass application.)
|
| [c] Worker Custom Fields |
Text |
4000 |
Depends on custom field configuration. |
|
Custom fields found on the worker.
If there are many custom fields, there will be many columns. Column header format will be:
"[c] modulename_custom field name" (i.e. [c] followed by module custom text lowercase with no spaces, followed by underscore, followed by the custom field name text as defined by users in the SAP Fieldglass application.)
Custom fields from the following Modules may be included in the download:
Statement of Work
SOW Revision
SOW Worker
Worker
|
| [c] Worker User Person Custom Fields |
Text |
4000 |
Depends on custom field configuration. |
|
Custom fields found on the worker user person
If there are many custom fields, there will be many columns. Column header format will be:
“[c] modulename_custom field name” (i.e. [c] followed by module custom text lowercase with no spaces, followed by underscore, followed by the custom field name text as defined by users in the SAP Fieldglass application.)
|
| [c] Buyer or Supplier custom fields |
Text |
4000 |
Depends on custom field configuration. |
|
Custom fields found on the supplier. (For supplier side download, only those fields required by buyer for supplier to be entered and viewed are downloaded.)If there are many custom fields, there will be many columns. Column header format will be:
“[c]modulename_custom field name” (i.e. [c] followed by module custom text lowercase with no spaces, followed by underscore, followed by the custom field name text as defined by users in the SAP Fieldglass application.)
|