Report tables

Each Pro report as a Power BI table, with the report’s columns in the report’s order.

Rows come in report order within each date range. Lacroo_Row_Key is unique in one refresh; it is not a record id.

Refresh in full. Leave Incremental refresh off so every change, including to older records, comes through.

Activity log data

activity_log_data_v1

Turn on Diaries & activities to read this table.

Every column, its Core type and how it differs: Activity log columns.

Combined report data

combined_report_data_v1

Turn on Dockets & costs to read this table.

Every column, its Core type and how it differs: Combined report columns.

Activities Report

report_activities_report_v1

Turn on Diaries & activities to read this table.

Money columns are blank unless the connection’s Prices switch is on.

#	Power BI name	Core column	Type
1	`Project`	`Project`	Text
2	`Supervisor`	`Supervisor`	Text
3	`Diary_Date`	`Diary Date`	Text
4	`Cost_Code`	`Cost Code`	Text
5	`Cost_Code_Description`	`Cost Code Description`	Text
6	`Sub_Code`	`Sub Code`	Text
7	`Program_Code`	`Program Code`	Text
8	`Activity_Description`	`Activity Description`	Text
9	`Target_Qty`	`Target Qty`	Decimal number
10	`Actual_Qty`	`Actual Qty`	Decimal number
11	`Qty_Variance_A_T`	`Qty Variance (A-T)`	Decimal number
12	`Target_Qty_Unit`	`Target Qty Unit`	Text
13	`Target_Cost_Rate`	`Target Cost Rate`	Decimal number
14	`Target_Cost_Rate_Unit`	`Target Cost Rate Unit`	Text
15	`Actual_Cost`	`Actual Cost`	Decimal number
16	`Cost_Rate_Variance`	`Cost Rate Variance`	Decimal number
17	`Activity_Lacroo_ID`	`Activity Lacroo ID`	Text
18	`Report_Date`	—	Date
19	`Lacroo_Project_ID`	—	Text
20	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Diary_Date", "Diary Date"},
    {"Cost_Code", "Cost Code"},
    {"Cost_Code_Description", "Cost Code Description"},
    {"Sub_Code", "Sub Code"},
    {"Program_Code", "Program Code"},
    {"Activity_Description", "Activity Description"},
    {"Target_Qty", "Target Qty"},
    {"Actual_Qty", "Actual Qty"},
    {"Qty_Variance_A_T", "Qty Variance (A-T)"},
    {"Target_Qty_Unit", "Target Qty Unit"},
    {"Target_Cost_Rate", "Target Cost Rate"},
    {"Target_Cost_Rate_Unit", "Target Cost Rate Unit"},
    {"Actual_Cost", "Actual Cost"},
    {"Cost_Rate_Variance", "Cost Rate Variance"},
    {"Activity_Lacroo_ID", "Activity Lacroo ID"}
})

Alerts Matrix

report_alerts_matrix_export_v1

Turn on Alerts to read this table.

Dated by Issued On Date. Org alerts sent to no project are not included. Service tokens cover every allowed project, even without membership.

#	Power BI name	Core column	Type
1	`Level`	`Level`	Text
2	`Alert_ID`	`Alert ID`	Text
3	`Alert_Bulletin_Type`	`Alert / Bulletin Type`	Text
4	`Issued_On_Date`	`Issued On Date`	Text
5	`Issued_By`	`Issued By`	Text
6	`Alert_Title`	`Alert Title`	Text
7	`Supervisor`	`Supervisor`	Text
8	`Prestart_Date`	`Prestart Date`	Text
9	`Prestart_ID`	`Prestart ID`	Text
10	`Project`	`Project`	Text
11	`Mandatory_Yes_No`	`Mandatory Yes/No`	Text
12	`Date_Specified_Yes_No`	`Date Specified Yes/No`	Text
13	`Date_Specified_DD_MM_YYYY`	`Date Specified DD/MM/YYYY`	Text
14	`Acknowledged_Yes_No`	`Acknowledged Yes/No`	Text
15	`Date_Time_Acknowledged`	`Date/Time Acknowledged`	Text
16	`Acknowledgement_Source`	`Acknowledgement Source`	Text
17	`Acknowledged_By`	`Acknowledged By`	Text
18	`Report_Date`	—	Date
19	`Lacroo_Project_ID`	—	Text
20	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Alert_ID", "Alert ID"},
    {"Alert_Bulletin_Type", "Alert / Bulletin Type"},
    {"Issued_On_Date", "Issued On Date"},
    {"Issued_By", "Issued By"},
    {"Alert_Title", "Alert Title"},
    {"Prestart_Date", "Prestart Date"},
    {"Prestart_ID", "Prestart ID"},
    {"Mandatory_Yes_No", "Mandatory Yes/No"},
    {"Date_Specified_Yes_No", "Date Specified Yes/No"},
    {"Date_Specified_DD_MM_YYYY", "Date Specified DD/MM/YYYY"},
    {"Acknowledged_Yes_No", "Acknowledged Yes/No"},
    {"Date_Time_Acknowledged", "Date/Time Acknowledged"},
    {"Acknowledgement_Source", "Acknowledgement Source"},
    {"Acknowledged_By", "Acknowledged By"}
})

Alerts Report

report_alerts_report_v1

Turn on Alerts to read this table.

#	Power BI name	Core column	Type
1	`Level`	`Level`	Text
2	`Alert_ID`	`Alert ID`	Text
3	`Alert_Bulletin_Type`	`Alert / Bulletin Type`	Text
4	`Issued_On_Date`	`Issued On Date`	Text
5	`Issued_By`	`Issued By`	Text
6	`Alert_Title`	`Alert Title`	Text
7	`Supervisor`	`Supervisor`	Text
8	`Project`	`Project`	Text
9	`Mandatory_Yes_No`	`Mandatory Yes/No`	Text
10	`Date_Specified_Yes_No`	`Date Specified Yes/No`	Text
11	`Date_Specified_DD_MM_YYYY`	`Date Specified DD/MM/YYYY`	Text
12	`Acknowledged_Yes_No`	`Acknowledged Yes/No`	Text
13	`Date_Time_Acknowledged`	`Date/Time Acknowledged`	Text
14	`Report_Date`	—	Date
15	`Lacroo_Project_ID`	—	Text
16	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Alert_ID", "Alert ID"},
    {"Alert_Bulletin_Type", "Alert / Bulletin Type"},
    {"Issued_On_Date", "Issued On Date"},
    {"Issued_By", "Issued By"},
    {"Alert_Title", "Alert Title"},
    {"Mandatory_Yes_No", "Mandatory Yes/No"},
    {"Date_Specified_Yes_No", "Date Specified Yes/No"},
    {"Date_Specified_DD_MM_YYYY", "Date Specified DD/MM/YYYY"},
    {"Acknowledged_Yes_No", "Acknowledged Yes/No"},
    {"Date_Time_Acknowledged", "Date/Time Acknowledged"}
})

Combined Report

report_combined_report_v1

Turn on Dockets & costs to read this table.

Money columns are blank unless the connection’s Prices switch is on.

#	Power BI name	Core column	Type
1	`Type`	`Type`	Text
2	`Project`	`Project`	Text
3	`Docket_Date`	`Docket Date`	Text
4	`Docket_Number`	`Docket Number`	Text
5	`Docket_Type`	`Docket Type`	Text
6	`Supervisor`	`Supervisor`	Text
7	`Additional_Supervisors`	`Additional Supervisors`	Text
8	`Resource_Name`	`Resource Name`	Text
9	`Rate_Source_Data`	`Rate Source Data`	Text
10	`Supplier`	`Supplier`	Text
11	`PO_Contract_Number`	`PO/Contract Number`	Text
12	`PO_Contract_Line_Number`	`PO/Contract Line Number`	Decimal number
13	`PO_Contract_Line_Description`	`PO/Contract Line Description`	Text
14	`Subcontractor_Upload_ID`	`Subcontractor Upload ID`	Text
15	`Internal_Rate_Card_Description`	`Internal Rate Card Description`	Text
16	`Billing_Unit`	`Billing Unit`	Text
17	`Billing_Rate`	`Billing Rate`	Decimal number
18	`Unit_Qty`	`Unit Qty`	Decimal number
19	`Amount`	`Amount`	Decimal number
20	`Start_Time`	`Start Time`	Text
21	`Finish_Time`	`Finish Time`	Text
22	`Break_Time`	`Break Time`	Text
23	`Break_Duration`	`Break Duration`	Text
24	`Shift_Qty`	`Shift Qty`	Text
25	`Prestart_Duration`	`Prestart Duration`	Text
26	`Prestart_PO_Contract_Number`	`Prestart PO/Contract Number`	Text
27	`Prestart_PO_Contract_Line_Number`	`Prestart PO/Contract Line Number`	Text
28	`Prestart_PO_Contract_Line_Description`	`Prestart PO/Contract Line Description`	Text
29	`Activity_Description`	`Activity Description`	Text
30	`Activity_Cost_Code`	`Activity Cost Code`	Text
31	`Activity_Sub_Code`	`Activity Sub Code`	Text
32	`Activity_Program_Code`	`Activity Program Code`	Text
33	`Tagged_Issue`	`Tagged Issue`	Text
34	`Docket_Note`	`Docket Note`	Text
35	`Submitted_By`	`Submitted By`	Text
36	`Submitted_When`	`Submitted When`	Text
37	`Approved_By`	`Approved By`	Text
38	`Approved_On`	`Approved On`	Text
39	`Checked_By`	`Checked By`	Text
40	`Checked_On`	`Checked On`	Text
41	`Upload_to_ERP`	`Upload to ERP`	Text
42	`Docket_Unique_ID`	`Docket Unique ID`	Text
43	`Report_Date`	—	Date
44	`Lacroo_Project_ID`	—	Text
45	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Docket_Date", "Docket Date"},
    {"Docket_Number", "Docket Number"},
    {"Docket_Type", "Docket Type"},
    {"Additional_Supervisors", "Additional Supervisors"},
    {"Resource_Name", "Resource Name"},
    {"Rate_Source_Data", "Rate Source Data"},
    {"PO_Contract_Number", "PO/Contract Number"},
    {"PO_Contract_Line_Number", "PO/Contract Line Number"},
    {"PO_Contract_Line_Description", "PO/Contract Line Description"},
    {"Subcontractor_Upload_ID", "Subcontractor Upload ID"},
    {"Internal_Rate_Card_Description", "Internal Rate Card Description"},
    {"Billing_Unit", "Billing Unit"},
    {"Billing_Rate", "Billing Rate"},
    {"Unit_Qty", "Unit Qty"},
    {"Start_Time", "Start Time"},
    {"Finish_Time", "Finish Time"},
    {"Break_Time", "Break Time"},
    {"Break_Duration", "Break Duration"},
    {"Shift_Qty", "Shift Qty"},
    {"Prestart_Duration", "Prestart Duration"},
    {"Prestart_PO_Contract_Number", "Prestart PO/Contract Number"},
    {"Prestart_PO_Contract_Line_Number", "Prestart PO/Contract Line Number"},
    {"Prestart_PO_Contract_Line_Description", "Prestart PO/Contract Line Description"},
    {"Activity_Description", "Activity Description"},
    {"Activity_Cost_Code", "Activity Cost Code"},
    {"Activity_Sub_Code", "Activity Sub Code"},
    {"Activity_Program_Code", "Activity Program Code"},
    {"Tagged_Issue", "Tagged Issue"},
    {"Docket_Note", "Docket Note"},
    {"Submitted_By", "Submitted By"},
    {"Submitted_When", "Submitted When"},
    {"Approved_By", "Approved By"},
    {"Approved_On", "Approved On"},
    {"Checked_By", "Checked By"},
    {"Checked_On", "Checked On"},
    {"Upload_to_ERP", "Upload to ERP"},
    {"Docket_Unique_ID", "Docket Unique ID"}
})

Cost allocation

report_cost_allocation_v1

Turn on Dockets & costs to read this table.

Refresh this table in full. Each row covers the whole date range you ask for. Each project lists suppliers with current or removed contract lines. Export whole project does not apply to this table.

Money columns are blank unless the connection’s Prices switch is on.

#	Power BI name	Core column	Type
1	`PM_Line_ID`	`PM Line ID`	Text
2	`Line_Number`	`Line Number`	Text
3	`Code`	`Code`	Text
4	`Description`	`Description`	Text
5	`Unit`	`Unit`	Text
6	`Committed_Qty`	`Committed Qty`	Text
7	`Committed_Amount`	`Committed Amount`	Text
8	`Used_Qty`	`Used Qty`	Text
9	`Used_Amount`	`Used Amount`	Text
10	`Allocated_Qty`	`Allocated Qty`	Text
11	`Allocated_Amount`	`Allocated Amount`	Text
12	`Variance`	`Variance`	Text
13	`Orphaned`	`Orphaned`	Text
14	`Contributing_Docket_IDs`	`Contributing Docket IDs`	Text
15	`Range_From`	—	Date
16	`Range_To`	—	Date
17	`Report_Date`	—	Date
18	`Lacroo_Project_ID`	—	Text
19	`Lacroo_Supplier_Org_ID`	—	Text
20	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"PM_Line_ID", "PM Line ID"},
    {"Line_Number", "Line Number"},
    {"Committed_Qty", "Committed Qty"},
    {"Committed_Amount", "Committed Amount"},
    {"Used_Qty", "Used Qty"},
    {"Used_Amount", "Used Amount"},
    {"Allocated_Qty", "Allocated Qty"},
    {"Allocated_Amount", "Allocated Amount"},
    {"Contributing_Docket_IDs", "Contributing Docket IDs"}
})

Dayworks Report Export

report_dayworks_report_v1

Turn on Dockets & costs to read this table.

Money columns are blank unless the connection’s Prices switch is on.

Docket_Photos is always empty.

#	Power BI name	Core column	Type
1	`Docket_Date`	`Docket Date`	Text
2	`Docket_Number`	`Docket Number`	Text
3	`Docket_Type`	`Docket Type`	Text
4	`Supplier`	`Supplier`	Text
5	`Resource_Name_A`	`Resource Name A`	Text
6	`Resource_Name_B`	`Resource Name B`	Text
7	`Activity_Description`	`Activity Description`	Text
8	`Activity_Cost_Code`	`Activity Cost Code`	Text
9	`Activity_Sub_Code`	`Activity Sub Code`	Text
10	`Activity_Program_Code`	`Activity Program Code`	Text
11	`Tagged_Issue`	`Tagged Issue`	Text
12	`Start_Time`	`Start Time`	Text
13	`Finish_Time`	`Finish Time`	Text
14	`Break_Time`	`Break Time`	Text
15	`Break_Duration`	`Break Duration`	Text
16	`Docket_Unit_Qty`	`Docket Unit Qty`	Text
17	`Docket_Note`	`Docket Note`	Text
18	`Docket_Photos`	`Docket Photos`	Text
19	`Day_Works_Description`	`Day Works Description`	Text
20	`Day_Works_Unit`	`Day Works Unit`	Text
21	`Day_Works_Qty`	`Day Works Qty`	Text
22	`Day_Works_Rate`	`Day Works Rate`	Text
23	`Day_Works_Amount`	`Day Works Amount`	Text
24	`Submitted_By`	`Submitted By`	Text
25	`Submitted_When`	`Submitted When`	Text
26	`Approved_By`	`Approved By`	Text
27	`Approved_On`	`Approved On`	Text
28	`Checked_By`	`Checked By`	Text
29	`Checked_On`	`Checked On`	Text
30	`Docket_Status`	`Docket Status`	Text
31	`Docket_Unique_ID`	`Docket Unique ID`	Text
32	`Report_Date`	—	Date
33	`Lacroo_Project_ID`	—	Text
34	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Docket_Date", "Docket Date"},
    {"Docket_Number", "Docket Number"},
    {"Docket_Type", "Docket Type"},
    {"Resource_Name_A", "Resource Name A"},
    {"Resource_Name_B", "Resource Name B"},
    {"Activity_Description", "Activity Description"},
    {"Activity_Cost_Code", "Activity Cost Code"},
    {"Activity_Sub_Code", "Activity Sub Code"},
    {"Activity_Program_Code", "Activity Program Code"},
    {"Tagged_Issue", "Tagged Issue"},
    {"Start_Time", "Start Time"},
    {"Finish_Time", "Finish Time"},
    {"Break_Time", "Break Time"},
    {"Break_Duration", "Break Duration"},
    {"Docket_Unit_Qty", "Docket Unit Qty"},
    {"Docket_Note", "Docket Note"},
    {"Docket_Photos", "Docket Photos"},
    {"Day_Works_Description", "Day Works Description"},
    {"Day_Works_Unit", "Day Works Unit"},
    {"Day_Works_Qty", "Day Works Qty"},
    {"Day_Works_Rate", "Day Works Rate"},
    {"Day_Works_Amount", "Day Works Amount"},
    {"Submitted_By", "Submitted By"},
    {"Submitted_When", "Submitted When"},
    {"Approved_By", "Approved By"},
    {"Approved_On", "Approved On"},
    {"Checked_By", "Checked By"},
    {"Checked_On", "Checked On"},
    {"Docket_Status", "Docket Status"},
    {"Docket_Unique_ID", "Docket Unique ID"}
})

Daily Diaries

report_diary_export_v1

Turn on Diaries & activities to read this table.

#	Power BI name	Core column	Type	Needs
1	`Project`	`Project`	Text
2	`Supervisor`	`Supervisor`	Text
3	`Diary_Date`	`Diary Date`	Text
4	`Site_Location`	`Site Location`	Text
5	`Activity_Description`	`Activity Description`	Text
6	`Visitors`	`Visitors`	Text
7	`Weather_Observations`	`Weather Observations`	Text
8	`Diary_Submitted`	`Diary Submitted`	Text
9	`Diary_Saved`	`Diary Saved`	Text
10	`Other_Fields`	—	Text	Contact details and Diversity details
11	`Report_Date`	—	Date
12	`Lacroo_Project_ID`	—	Text
13	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Diary_Date", "Diary Date"},
    {"Site_Location", "Site Location"},
    {"Activity_Description", "Activity Description"},
    {"Weather_Observations", "Weather Observations"},
    {"Diary_Submitted", "Diary Submitted"},
    {"Diary_Saved", "Diary Saved"}
})

Labour & Plant Dockets

report_dockets_export_v1

Turn on Dockets & costs to read this table.

Money columns are blank unless the connection’s Prices switch is on.

#	Power BI name	Core column	Type
1	`Type`	`Type`	Text
2	`Docket_Date`	`Docket Date`	Text
3	`Docket_Number`	`Docket Number`	Text
4	`Docket_Type`	`Docket Type`	Text
5	`Supplier`	`Supplier`	Text
6	`Resource_Name`	`Resource Name`	Text
7	`Start_Time`	`Start Time`	Text
8	`Finish_Time`	`Finish Time`	Text
9	`Break_Time`	`Break Time`	Text
10	`Break_Duration`	`Break Duration`	Text
11	`Rates_Data_Source`	`Rates Data Source`	Text
12	`PO_Line_Number`	`PO Line Number`	Decimal number
13	`PO_Contract_Number`	`PO/Contract Number`	Text
14	`Work_Description`	`Work Description`	Text
15	`Unit`	`Unit`	Text
16	`Rate`	`Rate`	Decimal number
17	`Qty`	`Qty`	Decimal number
18	`Amount`	`Amount`	Decimal number
19	`Daywork_Description`	`Daywork Description`	Text
20	`Daywork_Qty`	`Daywork Qty`	Decimal number
21	`Daywork_Unit`	`Daywork Unit`	Text
22	`Daywork_Rate`	`Daywork Rate`	Decimal number
23	`Daywork_Amount`	`Daywork Amount`	Decimal number
24	`Activity_Description`	`Activity Description`	Text
25	`Activity_Cost_Code`	`Activity Cost Code`	Text
26	`Activity_Sub_Code`	`Activity Sub Code`	Text
27	`Activity_Program_Code`	`Activity Program Code`	Text
28	`Tagged_Issue`	`Tagged Issue`	Text
29	`Docket_Note`	`Docket Note`	Text
30	`Submitted_By`	`Submitted By`	Text
31	`Additional_Supervisors`	`Additional Supervisors`	Text
32	`Submitted_When`	`Submitted When`	Text
33	`Approved_By`	`Approved By`	Text
34	`Approved_On`	`Approved On`	Text
35	`Checked_By`	`Checked By`	Text
36	`Checked_On`	`Checked On`	Text
37	`Docket_Status`	`Docket Status`	Text
38	`Docket_Unique_ID`	`Docket Unique ID`	Text
39	`GRN_Pushed`	`GRN Pushed`	Text
40	`Report_Date`	—	Date
41	`Lacroo_Project_ID`	—	Text
42	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Docket_Date", "Docket Date"},
    {"Docket_Number", "Docket Number"},
    {"Docket_Type", "Docket Type"},
    {"Resource_Name", "Resource Name"},
    {"Start_Time", "Start Time"},
    {"Finish_Time", "Finish Time"},
    {"Break_Time", "Break Time"},
    {"Break_Duration", "Break Duration"},
    {"Rates_Data_Source", "Rates Data Source"},
    {"PO_Line_Number", "PO Line Number"},
    {"PO_Contract_Number", "PO/Contract Number"},
    {"Work_Description", "Work Description"},
    {"Daywork_Description", "Daywork Description"},
    {"Daywork_Qty", "Daywork Qty"},
    {"Daywork_Unit", "Daywork Unit"},
    {"Daywork_Rate", "Daywork Rate"},
    {"Daywork_Amount", "Daywork Amount"},
    {"Activity_Description", "Activity Description"},
    {"Activity_Cost_Code", "Activity Cost Code"},
    {"Activity_Sub_Code", "Activity Sub Code"},
    {"Activity_Program_Code", "Activity Program Code"},
    {"Tagged_Issue", "Tagged Issue"},
    {"Docket_Note", "Docket Note"},
    {"Submitted_By", "Submitted By"},
    {"Additional_Supervisors", "Additional Supervisors"},
    {"Submitted_When", "Submitted When"},
    {"Approved_By", "Approved By"},
    {"Approved_On", "Approved On"},
    {"Checked_By", "Checked By"},
    {"Checked_On", "Checked On"},
    {"Docket_Status", "Docket Status"},
    {"Docket_Unique_ID", "Docket Unique ID"},
    {"GRN_Pushed", "GRN Pushed"}
})

Inductions Export (Responses Detail)

report_inductions_export_responses_v1

Turn on Workforce & sign-ons to read this table.

#	Power BI name	Core column	Type	Needs
1	`Project`	`Project`	Text
2	`Sign_On_Date`	`Sign On Date`	Text
3	`Sign_On_Time`	`Sign On Time`	Text
4	`Signee`	`Signee`	Text
5	`Role`	`Role`	Text
6	`Question`	`Question`	Text
7	`Field_Type`	`Field Type`	Text
8	`Answer`	`Answer`	Text	Contact details and Diversity details
9	`Sign_On_ID`	`Sign-On ID`	Text
10	`Report_Date`	—	Date
11	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Sign_On_Date", "Sign On Date"},
    {"Sign_On_Time", "Sign On Time"},
    {"Field_Type", "Field Type"},
    {"Sign_On_ID", "Sign-On ID"}
})

Inductions Export (Sign Ons)

report_inductions_export_v1

Turn on Workforce & sign-ons to read this table.

#	Power BI name	Core column	Type	Needs
1	`Project`	`Project`	Text
2	`Org`	`Org`	Text
3	`Sign_On_Date`	`Sign On Date`	Text
4	`Sign_On_Time`	`Sign On Time`	Text
5	`Signee`	`Signee`	Text
6	`Role`	`Role`	Text
7	`Title`	`Title`	Text
8	`_Questions`	`# Questions`	Whole number
9	`_Answered`	`# Answered`	Whole number
10	`Sign_On_ID`	`Sign-On ID`	Text
11	`Other_Fields`	—	Text	Contact details and Diversity details
12	`Report_Date`	—	Date
13	`Lacroo_Project_ID`	—	Text
14	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Sign_On_Date", "Sign On Date"},
    {"Sign_On_Time", "Sign On Time"},
    {"_Questions", "# Questions"},
    {"_Answered", "# Answered"},
    {"Sign_On_ID", "Sign-On ID"}
})

Issues Log

report_issues_export_v1

Turn on Issues & variations to read this table.

Money columns are blank unless the connection’s Prices switch is on.

#	Power BI name	Core column	Type
1	`Project`	`Project`	Text
2	`Supervisor`	`Supervisor`	Text
3	`Issue_Heading`	`Issue Heading`	Text
4	`Location`	`Location`	Text
5	`Reference_Document`	`Reference Document`	Text
6	`Cause`	`Cause`	Text
7	`Cost_Code`	`Cost Code`	Text
8	`Cost_Impact`	`Cost Impact`	Text
9	`Impact`	`Impact`	Text
10	`Program_Code`	`Program Code`	Text
11	`Time_Impact`	`Time Impact`	Text
12	`Issue_ID`	`Issue ID`	Text
13	`Issue_Type`	`Issue Type`	Text
14	`Issue_Status`	`Issue Status`	Text
15	`Raised_By`	`Raised By`	Text
16	`Identified_Date`	`Identified Date`	Text
17	`Raised_Date`	`Raised Date`	Text
18	`Raised_Value`	`Raised Value`	Text
19	`Notified_Date`	`Notified Date`	Text
20	`Notified_Value`	`Notified Value`	Text
21	`Submitted_Date`	`Submitted Date`	Text
22	`Submitted_Value`	`Submitted Value`	Text
23	`Assessed_Date`	`Assessed Date`	Text
24	`Assessed_Value`	`Assessed Value`	Text
25	`Agreed_Date`	`Agreed Date`	Text
26	`Agreed_Value`	`Agreed Value`	Text
27	`EOT_Reference`	`EOT Reference`	Text
28	`isEOT`	`isEOT`	Text
29	`Report_Date`	—	Date
30	`Lacroo_Project_ID`	—	Text
31	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Issue_Heading", "Issue Heading"},
    {"Reference_Document", "Reference Document"},
    {"Cost_Code", "Cost Code"},
    {"Cost_Impact", "Cost Impact"},
    {"Program_Code", "Program Code"},
    {"Time_Impact", "Time Impact"},
    {"Issue_ID", "Issue ID"},
    {"Issue_Type", "Issue Type"},
    {"Issue_Status", "Issue Status"},
    {"Raised_By", "Raised By"},
    {"Identified_Date", "Identified Date"},
    {"Raised_Date", "Raised Date"},
    {"Raised_Value", "Raised Value"},
    {"Notified_Date", "Notified Date"},
    {"Notified_Value", "Notified Value"},
    {"Submitted_Date", "Submitted Date"},
    {"Submitted_Value", "Submitted Value"},
    {"Assessed_Date", "Assessed Date"},
    {"Assessed_Value", "Assessed Value"},
    {"Agreed_Date", "Agreed Date"},
    {"Agreed_Value", "Agreed Value"},
    {"EOT_Reference", "EOT Reference"}
})

Issues & variations

report_issues_variations_v1

Turn on Issues & variations to read this table.

Dated by Identified Date. Issues with no identified date are not included. A field name used twice gets (2) in Other_Fields. Covers every project the token allows, even without membership. Export whole project does not apply to this table.

Money columns are blank unless the connection’s Prices switch is on.

#	Power BI name	Core column	Type	Needs
1	`Issue_ID`	`Issue ID`	Text
2	`Heading`	`Heading`	Text
3	`Client_Reference`	`Client Reference`	Text
4	`ERP_Reference`	`ERP Reference`	Text
5	`Type`	`Type`	Text
6	`Status`	`Status`	Text
7	`Stage`	`Stage`	Text
8	`Is_EOT`	`Is EOT`	Text
9	`EOT_Reference`	`EOT Reference`	Text
10	`EOT_Linked_Issue`	`EOT-Linked Issue`	Text
11	`Cause`	`Cause`	Text
12	`Impact`	`Impact`	Text
13	`Comment_Action`	`Comment/Action`	Text
14	`Location`	`Location`	Text
15	`Reference_Document`	`Reference Document`	Text
16	`Raised_By`	`Raised By`	Text
17	`Supervisor`	`Supervisor`	Text
18	`Owner_Assignee`	`Owner (Assignee)`	Text
19	`Cost_Code`	`Cost Code`	Text
20	`Cost_Code_Description`	`Cost Code Description`	Text
21	`Cost_Impact`	`Cost Impact`	Text
22	`Time_Impact_days`	`Time Impact days`	Text
23	`Identified_Date`	`Identified Date`	Text
24	`Identified_Value`	`Identified Value`	Text
25	`Identified_Days`	`Identified Days`	Text
26	`Notified_Date`	`Notified Date`	Text
27	`Notified_Value`	`Notified Value`	Text
28	`Notified_Days`	`Notified Days`	Text
29	`Submitted_Date`	`Submitted Date`	Text
30	`Submitted_Value`	`Submitted Value`	Text
31	`Submitted_Days`	`Submitted Days`	Text
32	`Assessed_Date`	`Assessed Date`	Text
33	`Assessed_Value`	`Assessed Value`	Text
34	`Assessed_Days`	`Assessed Days`	Text
35	`Agreed_Date`	`Agreed Date`	Text
36	`Agreed_Value`	`Agreed Value`	Text
37	`Agreed_Days`	`Agreed Days`	Text
38	`Notification_Deadline`	`Notification Deadline`	Text
39	`Notified_In_Time`	`Notified In Time`	Text
40	`Docket_Count`	`Docket Count`	Text
41	`Docket_Numbers`	`Docket Numbers`	Text
42	`Docket_Value`	`Docket Value`	Text
43	`Status_Change_Count`	`Status-Change Count`	Text
44	`Last_Transition`	`Last Transition`	Text
45	`Last_Changed_At`	`Last Changed At`	Text
46	`Last_Changed_By`	`Last Changed By`	Text
47	`Comment_Count`	`Comment Count`	Text
48	`File_Count`	`File Count`	Text
49	`Created_At`	`Created At`	Text
50	`Updated_At`	`Updated At`	Text
51	`Source`	`Source`	Text
52	`Other_Fields`	—	Text	Contact details and Diversity details
53	`Report_Date`	—	Date
54	`Lacroo_Project_ID`	—	Text
55	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Issue_ID", "Issue ID"},
    {"Client_Reference", "Client Reference"},
    {"ERP_Reference", "ERP Reference"},
    {"Is_EOT", "Is EOT"},
    {"EOT_Reference", "EOT Reference"},
    {"EOT_Linked_Issue", "EOT-Linked Issue"},
    {"Comment_Action", "Comment/Action"},
    {"Reference_Document", "Reference Document"},
    {"Raised_By", "Raised By"},
    {"Owner_Assignee", "Owner (Assignee)"},
    {"Cost_Code", "Cost Code"},
    {"Cost_Code_Description", "Cost Code Description"},
    {"Cost_Impact", "Cost Impact"},
    {"Time_Impact_days", "Time Impact days"},
    {"Identified_Date", "Identified Date"},
    {"Identified_Value", "Identified Value"},
    {"Identified_Days", "Identified Days"},
    {"Notified_Date", "Notified Date"},
    {"Notified_Value", "Notified Value"},
    {"Notified_Days", "Notified Days"},
    {"Submitted_Date", "Submitted Date"},
    {"Submitted_Value", "Submitted Value"},
    {"Submitted_Days", "Submitted Days"},
    {"Assessed_Date", "Assessed Date"},
    {"Assessed_Value", "Assessed Value"},
    {"Assessed_Days", "Assessed Days"},
    {"Agreed_Date", "Agreed Date"},
    {"Agreed_Value", "Agreed Value"},
    {"Agreed_Days", "Agreed Days"},
    {"Notification_Deadline", "Notification Deadline"},
    {"Notified_In_Time", "Notified In Time"},
    {"Docket_Count", "Docket Count"},
    {"Docket_Numbers", "Docket Numbers"},
    {"Docket_Value", "Docket Value"},
    {"Status_Change_Count", "Status-Change Count"},
    {"Last_Transition", "Last Transition"},
    {"Last_Changed_At", "Last Changed At"},
    {"Last_Changed_By", "Last Changed By"},
    {"Comment_Count", "Comment Count"},
    {"File_Count", "File Count"},
    {"Created_At", "Created At"},
    {"Updated_At", "Updated At"}
})

Material Dockets

report_material_dockets_export_v1

Turn on Dockets & costs to read this table.

Money columns are blank unless the connection’s Prices switch is on.

#	Power BI name	Core column	Type
1	`Project`	`Project`	Text
2	`Diary_Date`	`Diary Date`	Text
3	`Supervisor`	`Supervisor`	Text
4	`Activity`	`Activity`	Text
5	`Cost_Code`	`Cost Code`	Text
6	`PO_Line_Item_No`	`PO Line Item No.`	Text
7	`PO_Number`	`PO Number`	Text
8	`Line_Item_Description`	`Line Item Description`	Text
9	`Source_Location`	`Source Location`	Text
10	`Delivery_Location`	`Delivery Location`	Text
11	`Construction_Lot`	`Construction Lot`	Text
12	`Qty`	`Qty`	Text
13	`Unit`	`Unit`	Text
14	`Rate`	`Rate`	Text
15	`Amount`	`Amount`	Text
16	`Report_Date`	—	Date
17	`Lacroo_Project_ID`	—	Text
18	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Diary_Date", "Diary Date"},
    {"Cost_Code", "Cost Code"},
    {"PO_Line_Item_No", "PO Line Item No."},
    {"PO_Number", "PO Number"},
    {"Line_Item_Description", "Line Item Description"},
    {"Source_Location", "Source Location"},
    {"Delivery_Location", "Delivery Location"},
    {"Construction_Lot", "Construction Lot"}
})

Onsite Workers

report_onsite_workers_v1

Turn on Workforce & sign-ons to read this table.

#	Power BI name	Core column	Type
1	`supervisor`	`supervisor`	Text
2	`prestart_location`	`prestart_location`	Text
3	`prestart_date`	`prestart_date`	Text
4	`signee`	`signee`	Text
5	`supplier`	`supplier`	Text
6	`resource_type`	`resource_type`	Text
7	`sign_on_time`	`sign_on_time`	Text
8	`Report_Date`	—	Date
9	`Lacroo_Project_ID`	—	Text
10	`Lacroo_Row_Key`	—	Text

Prestart Report

report_prestart_report_v1

Turn on Workforce & sign-ons to read this table.

#	Power BI name	Core column	Type	Needs
1	`Project`	`Project`	Text
2	`Supervisor`	`Supervisor`	Text
3	`Prestart_Date`	`Prestart Date`	Text
4	`Site_Location`	`Site Location`	Text
5	`Safety_is_My_Way`	`Safety is My Way`	Text
6	`Incident_Alerts`	`Incident Alerts`	Text
7	`Details_from_Previous_Shift`	`Details from Previous Shift`	Text
8	`Activity_Description`	`Activity Description`	Text
9	`New_Hazards`	`New Hazards`	Text
10	`Work_Planned`	`Work Planned`	Text
11	`General_Business`	`General Business`	Text
12	`Published_On`	`Published On`	Text
13	`Latest_Changes_On`	`Latest Changes On`	Text
14	`Other_Fields`	—	Text	Contact details and Diversity details
15	`Report_Date`	—	Date
16	`Lacroo_Project_ID`	—	Text
17	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Prestart_Date", "Prestart Date"},
    {"Site_Location", "Site Location"},
    {"Safety_is_My_Way", "Safety is My Way"},
    {"Incident_Alerts", "Incident Alerts"},
    {"Details_from_Previous_Shift", "Details from Previous Shift"},
    {"Activity_Description", "Activity Description"},
    {"New_Hazards", "New Hazards"},
    {"Work_Planned", "Work Planned"},
    {"General_Business", "General Business"},
    {"Published_On", "Published On"},
    {"Latest_Changes_On", "Latest Changes On"}
})

Sign-ons

report_sign_ons_v1

Turn on Workforce & sign-ons to read this table.

A field name used twice gets (2) in Other_Fields. Covers every project the token allows, even without membership. Export whole project does not apply to this table.

#	Power BI name	Core column	Type	Needs
1	`Project`	`Project`	Text
2	`Sign_on_Date`	`Sign-on Date`	Text
3	`Sign_on_Time`	`Sign-on Time`	Text
4	`Worker`	`Worker`	Text
5	`Supervisor`	`Supervisor`	Text
6	`Supplier`	`Supplier`	Text
7	`Sign_on_Location`	`Sign-on Location`	Text
8	`Shift_Type`	`Shift Type`	Text
9	`Docket_Created`	`Docket Created`	Text
10	`Docket_Number`	`Docket Number`	Text
11	`Docket_Start`	`Docket Start`	Text
12	`Docket_Finish`	`Docket Finish`	Text
13	`Shift_Hours_Net`	`Shift Hours (Net)`	Text
14	`Shift_Hours_Gross`	`Shift Hours (Gross)`	Text
15	`Break_Duration_mins`	`Break Duration (mins)`	Text
16	`Break_Start_s`	`Break Start(s)`	Text
17	`Docket_Shift_Type`	`Docket Shift Type`	Text
18	`Docket_Supervisor`	`Docket Supervisor`	Text
19	`Docket_Supplier`	`Docket Supplier`	Text
20	`Prestart_Date`	`Prestart Date`	Text
21	`Prestart_Time`	`Prestart Time`	Text
22	`Prestart_Location`	`Prestart Location`	Text
23	`Other_Fields`	—	Text	Contact details and Diversity details
24	`Report_Date`	—	Date
25	`Lacroo_Project_ID`	—	Text
26	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Sign_on_Date", "Sign-on Date"},
    {"Sign_on_Time", "Sign-on Time"},
    {"Sign_on_Location", "Sign-on Location"},
    {"Shift_Type", "Shift Type"},
    {"Docket_Created", "Docket Created"},
    {"Docket_Number", "Docket Number"},
    {"Docket_Start", "Docket Start"},
    {"Docket_Finish", "Docket Finish"},
    {"Shift_Hours_Net", "Shift Hours (Net)"},
    {"Shift_Hours_Gross", "Shift Hours (Gross)"},
    {"Break_Duration_mins", "Break Duration (mins)"},
    {"Break_Start_s", "Break Start(s)"},
    {"Docket_Shift_Type", "Docket Shift Type"},
    {"Docket_Supervisor", "Docket Supervisor"},
    {"Docket_Supplier", "Docket Supplier"},
    {"Prestart_Date", "Prestart Date"},
    {"Prestart_Time", "Prestart Time"},
    {"Prestart_Location", "Prestart Location"}
})

Subcontractor Dockets

report_subcontractor_dockets_export_v1

Turn on Dockets & costs to read this table.

Money columns are blank unless the connection’s Prices switch is on.

Docket_Photos is always empty.

#	Power BI name	Core column	Type
1	`Docket_Date`	`Docket Date`	Text
2	`Docket_Number`	`Docket Number`	Text
3	`Docket_Type`	`Docket Type`	Text
4	`Supplier`	`Supplier`	Text
5	`PO_Number`	`PO Number`	Text
6	`PO_Line_Number`	`PO Line Number`	Whole number
7	`PO_Line_Description`	`PO Line Description`	Text
8	`Internal_Rate_Card_Description`	`Internal Rate Card Description`	Text
9	`Billing_Unit`	`Billing Unit`	Text
10	`Billing_Rate_per_Unit`	`Billing Rate per Unit`	Decimal number
11	`Activity_Description`	`Activity Description`	Text
12	`Activity_Cost_Code`	`Activity Cost Code`	Text
13	`Activity_Sub_Code`	`Activity Sub Code`	Text
14	`Activity_Program_Code`	`Activity Program Code`	Text
15	`Tagged_Issue`	`Tagged Issue`	Text
16	`Docket_Unit_Qty`	`Docket Unit Qty`	Decimal number
17	`Docket_Amount`	`Docket Amount`	Decimal number
18	`Docket_Note`	`Docket Note`	Text
19	`Docket_Photos`	`Docket Photos`	Text
20	`Submitted_By`	`Submitted By`	Text
21	`Submitted_When`	`Submitted When`	Text
22	`Approved_By`	`Approved By`	Text
23	`Approved_On`	`Approved On`	Text
24	`Checked_By`	`Checked By`	Text
25	`Checked_On`	`Checked On`	Text
26	`Docket_Unique_ID`	`Docket Unique ID`	Text
27	`Report_Date`	—	Date
28	`Lacroo_Project_ID`	—	Text
29	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Docket_Date", "Docket Date"},
    {"Docket_Number", "Docket Number"},
    {"Docket_Type", "Docket Type"},
    {"PO_Number", "PO Number"},
    {"PO_Line_Number", "PO Line Number"},
    {"PO_Line_Description", "PO Line Description"},
    {"Internal_Rate_Card_Description", "Internal Rate Card Description"},
    {"Billing_Unit", "Billing Unit"},
    {"Billing_Rate_per_Unit", "Billing Rate per Unit"},
    {"Activity_Description", "Activity Description"},
    {"Activity_Cost_Code", "Activity Cost Code"},
    {"Activity_Sub_Code", "Activity Sub Code"},
    {"Activity_Program_Code", "Activity Program Code"},
    {"Tagged_Issue", "Tagged Issue"},
    {"Docket_Unit_Qty", "Docket Unit Qty"},
    {"Docket_Amount", "Docket Amount"},
    {"Docket_Note", "Docket Note"},
    {"Docket_Photos", "Docket Photos"},
    {"Submitted_By", "Submitted By"},
    {"Submitted_When", "Submitted When"},
    {"Approved_By", "Approved By"},
    {"Approved_On", "Approved On"},
    {"Checked_By", "Checked By"},
    {"Checked_On", "Checked On"},
    {"Docket_Unique_ID", "Docket Unique ID"}
})

Workforce Log

report_workforce_log_v1

Turn on Workforce & sign-ons to read this table.

#	Power BI name	Core column	Type	Needs
1	`Project`	`Project`	Text
2	`Project_Code`	`Project Code`	Text
3	`Project_Company_ID`	`Project Company ID`	Text
4	`Prestart_Date`	`Prestart Date`	Text
5	`Prestart_Time`	`Prestart Time`	Text
6	`Prestart_Location`	`Prestart Location`	Text
7	`Shift_Type`	`Shift Type`	Text
8	`Supervisor`	`Supervisor`	Text
9	`Sign_On_Name`	`Sign On Name`	Text
10	`Unique_ID`	`Unique ID`	Text
11	`Sign_On_Role`	`Sign On Role`	Text
12	`Supplier`	`Supplier`	Text
13	`Phone_Number`	`Phone Number`	Text	Contact details
14	`Beakon_ID`	`Beakon ID`	Text
15	`Sign_On_Date`	`Sign On Date`	Text
16	`Sign_On_Time`	`Sign On Time`	Text
17	`Aboriginal_or_Torres_Strait_Islander`	`Aboriginal or Torres Strait Islander`	Text	Diversity details
18	`Language_Group`	`Language Group`	Text	Diversity details
19	`Apprentice`	`Apprentice`	Text
20	`Trainee`	`Trainee`	Text
21	`Year_Of_Commencement`	`Year Of Commencement`	Text
22	`Gender`	`Gender`	Text	Diversity details
23	`Date_Of_Birth`	`Date Of Birth`	Text	Diversity details
24	`Post_Code`	`Post Code`	Text	Contact details
25	`Email`	`Email`	Text	Contact details
26	`Report_Date`	—	Date
27	`Lacroo_Project_ID`	—	Text
28	`Lacroo_Row_Key`	—	Text

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step.

Renamed = Table.RenameColumns(Source, {
    {"Project_Code", "Project Code"},
    {"Project_Company_ID", "Project Company ID"},
    {"Prestart_Date", "Prestart Date"},
    {"Prestart_Time", "Prestart Time"},
    {"Prestart_Location", "Prestart Location"},
    {"Shift_Type", "Shift Type"},
    {"Sign_On_Name", "Sign On Name"},
    {"Unique_ID", "Unique ID"},
    {"Sign_On_Role", "Sign On Role"},
    {"Phone_Number", "Phone Number"},
    {"Beakon_ID", "Beakon ID"},
    {"Sign_On_Date", "Sign On Date"},
    {"Sign_On_Time", "Sign On Time"},
    {"Aboriginal_or_Torres_Strait_Islander", "Aboriginal or Torres Strait Islander"},
    {"Language_Group", "Language Group"},
    {"Year_Of_Commencement", "Year Of Commencement"},
    {"Date_Of_Birth", "Date Of Birth"},
    {"Post_Code", "Post Code"}
})

Activity log columns Safety Systems