The names and meaning of the data fields in the different Resource Usage export files are in the table below:
|
Field Name |
Definition |
Resource Usages Export |
Resource Usages Export Subcontractors |
Approved Usages Export |
Resource Usages for Import |
|
Purpose/Use Case |
Export of all Resource Usages. Can be used by Payroll |
Restricted export of Usage Date for Subcontractors. Can be used by Subcontractor Payroll |
Export of Approved Usages only |
Export that mirrors the import file format for creating and deleting Usages | |
|
Project |
Name of project |
✓ |
✓ |
✕ |
✕ |
|
Work Date |
Date work was recorded |
✓ |
✓ |
✓ |
✓ |
|
Resource Role |
Work Role for People, Type for Equipment and Other Resources as defined in the Resource Assignment |
✓ |
✓ |
✓ |
✕ |
|
Work Role Category |
Work Role Category for People |
✓ |
✓ |
✓ |
✕ |
|
Work Role Category Type |
Work Role Category Type for People |
✓ |
✓ |
✓ |
✕ |
|
Company |
Name of Company for the resource as defined in the Resource Assignment |
✓ |
✓ |
✓ |
✕ |
|
Company Supplier Reference |
Unique identifier the Company |
✓ |
✕ |
✕ |
✕ |
|
Resource Type |
Type of resource: People, Equipment, or Other Resource |
✓ |
✓ |
✓ |
✓ |
|
Resource Name |
Name of the resource |
✓ |
✓ |
✓ |
✓ |
|
Resource Unique Identifier |
A unique identifier of the Person resource |
✓ |
✕ |
✕ |
✕ |
|
Resource Identifier |
An identifier of the resource |
✓ |
✓ |
✕ |
✕ |
|
Resource External Reference |
An identifier of the resource |
✓ |
✓ |
✓ |
✕ |
|
Resource Supervisor |
Name of supervisor as defined in Supervision Roster |
✓ |
✓ |
✕ |
✕ |
|
Resource Tags |
Tags assigned to the resource |
✓ |
✕ |
✕ |
✕ |
|
Work Reference Type |
Activity or Event that the resource usage was recorded against |
✓ |
✓ |
✓ |
✓ |
|
Work Reference Code |
Unique identifier for Activity or Event |
✓ |
✓ |
✕ |
✓ |
|
Work Reference Name |
Name of Activity or Event |
✓ |
✓ |
✓ |
✕ |
|
Work Reference Tags |
Tags assigned to a Work Reference (Activity or Event) |
✓ |
✕ |
✕ |
✕ |
|
Event Type |
Type of the Event |
✓ |
✓ |
✓ |
✕ |
|
Related Activity Code |
When Work Reference Type = Event |
✓ |
✓ |
✓ |
✕ |
|
Discipline |
Discipline of the Activity or related Activity |
✓ |
✓ |
✓ |
✕ |
|
Location |
Location of the Activity or related Activity |
✓ |
✓ |
✓ |
✕ |
|
Work Reference Category |
Category of the Activity or related Activity |
✓ |
✓ |
✕ |
✕ |
|
Job Number |
Job Number of the Activity or Event |
✓ |
✓ |
✕ |
✕ |
|
Cost Type |
Cost Type of the Activity or Event |
✓ |
✓ |
✕ |
✕ |
|
Cost Code |
Cost Code of the Activity or Event |
✓ |
✓ |
✕ |
✕ |
|
Cost Code Ref 1 |
Cost Code Ref 1 of the Activity/Event |
✓ |
✓ |
✕ |
✕ |
|
Cost Code Ref 2 |
Cost Code Ref 2 of the Activity/Event |
✓ |
✓ |
✕ |
✕ |
|
Job Number.Cost Type.Cost Code |
Concatenation of the 3 fields |
✓ |
✕ |
✕ |
✕ |
|
Usage Approval Status |
Status: Unapproved, Submitted, Approved, and Rejected |
✓ |
✓ |
✓ |
✕ |
|
Client Usage Approval Status |
Status: Unapproved, Submitted, Approved, and Rejected |
✓ |
✕ |
✓ |
✕ |
|
Docket Status |
Status: Entered, Received, Approved, and Rejected |
✓ |
✕ |
✕ |
✕ |
|
Invoice Status |
Status: Received, Processed, and Closed |
✓ |
✕ |
✕ |
✕ |
|
Docket Reference |
Identifier for Company Docket |
✓ |
✓ |
✓ |
✓ |
|
Invoice Reference |
Identifier for Company Invoice |
✓ |
✓ |
✕ |
✕ |
|
Purchase Order Reference |
Identifier for Company Purchase Order |
✓ |
✓ |
✕ |
✕ |
|
Usage Code |
Code for usage conditions (day shift, night shift, etc.) |
✓ |
✓ |
✓ |
✓ |
|
UoM |
Unit of Measure for the Usage, (typically hours, but can be loads, each, m3, etc.) |
✓ |
✓ |
✓ |
✓ |
|
Rate Code |
Code of the applicable Rate |
✓ |
✓ |
✓ |
✓ |
|
Usage Quantity |
Amount of usage in the Unit of Measure |
✓ |
✓ |
✓ |
✓ |
|
Cost Rate |
Applicable Cost Rate for the resource |
✓ |
✕ |
✕ |
✕ |
|
Cost Amount |
Usage Quantity × Cost Rate |
✓ |
✕ |
✕ |
✕ |
|
Sell Rate |
Applicable Sell Rate for the resource |
✓ |
✕ |
✕ |
✕ |
|
Sell Amount |
Usage Quantity × Sell Rate |
✓ |
✕ |
✕ |
✕ |
|
Dayworks Rate |
Applicable Dayworks Rate for the resource |
✓ |
✕ |
✕ |
✕ |
|
Dayworks Amount |
Usage Quantity × Dayworks Rate |
✓ |
✕ |
✕ |
✕ |
|
Start Time |
HH24:MI:SS |
✓ |
✓ |
✕ |
✓ |
|
End Time |
HH24:MI:SS |
✓ |
✓ |
✕ |
✓ |
|
Break Duration |
Break duration in hours |
✓ |
✓ |
✕ |
✓ |
|
SMU Start |
Standard machine units start |
✓ |
✕ |
✓ |
✕ |
|
SMU End |
Standard machine units end |
✓ |
✕ |
✓ |
✕ |
|
Resource Note |
Additional information on a resource for the work day |
✓ |
✓ |
✕ |
✓ |
|
Usage Note |
Additional information on the usage |
✓ |
✓ |
✕ |
✓ |
|
Production UoM |
Production Unit of Measure |
✓ |
✕ |
✕ |
✕ |
|
Production Capacity |
Conversion factor generating Production Quantity for each Usage Quantity |
✓ |
✕ |
✕ |
✕ |
|
Production Amount |
Production Capacity × Usage Quantity
Converts the Usage Quantity UoM (loads) into the Production Amount UoM (m3) |
✓ |
✕ |
✕ |
✕ |
|
Production Amount UoM |
Production Amount Unit of Measure |
✓ |
✕ |
✕ |
✕ |
|
Creator |
User that created the entry |
✓ |
✓ |
✓ |
✕ |
|
Created At |
Time of creation |
✓ |
✓ |
✓ |
✕ |
|
Updater |
User that last updated the entry |
✓ |
✓ |
✓ |
✕ |
|
Updated At |
Time of last update |
✓ |
✓ |
✓ |
✕ |
|
Approver |
User that approved the entry |
✓ |
✓ |
✓ |
✕ |
|
Approved At |
Time of last approval |
✓ |
✓ |
✓ |
✕ |
|
Usage Rejections |
Details of rejection: user, reason, and time |
✓ |
✕ |
✕ |
✕ |
|
Client Approver |
Client User that approved the entry |
✓ |
✕ |
✓ |
✕ |
|
Client Approved At |
Time of last client approved |
✓ |
✕ |
✓ |
✕ |
|
Client Usage Rejections |
Details of client rejection: user, reason, and time |
✓ |
✕ |
✓ |
✕ |
|
UUID |
Universally Unique Identifier for the entry |
✓ |
✓ |
✕ |
✓ |
|
Person Attendance Reference |
An identifier of the Person used for attendance matching |
✓ |
✓ |
✕ |
✕ |
|
Phase Code |
Phase Code of the Activity or related Activity |
✓ |
✓ |
✕ |
✕ |
|
Phase Subcode |
Phase Subcode of the Activity or related Activity |
✓ |
✓ |
✕ |
✕ |
|
Supervisor Code |
Code used to identify supervisors |
✓ |
✕ |
✕ |
✕ |
|
Docket First Received By |
User that first received the docket |
✓ |
✕ |
✕ |
✕ |
|
Docket Last Received By |
User that last received the docket |
✓ |
✕ |
✕ |
✕ |
|
Employment Company |
The company employing the Person |
✓ |
✕ |
✕ |
✕ |
|
Employment Agreement |
The agreement between the Person and the company |
✓ |
✕ |
✕ |
✕ |
|
Employment Area |
The area where the Person works |
✓ |
✕ |
✕ |
✕ |
|
Employment Start Date |
The start date of the Person’s contract with the Employment Company |
✓ |
✕ |
✕ |
✕ |
|
Employment End Date |
The end date of the Person’s contract with the Employment Company |
✓ |
✕ |
✕ |
✕ |
|
Approval Type |
Approval Type: internal or external |
✕ |
✕ |
✓ |
✕ |
|
Action |
Action: delete or create |
✕ |
✕ |
✕ |
✓ |
|
Resource UUID |
Universally Unique Identifier for the resource |
✕ |
✕ |
✕ |
✓ |
|
Error Messages |
Errors occurring on import of resource usages |
✕ |
✕ |
✕ |
✓ |
|
|
|
|
|
|
|