Workforce log columns

Every column of workforce_log_v1, in the order Power BI shows them.

Turn on Workforce & sign-ons to read this table. Turn on Contact details or Diversity details only if your report uses those columns.

#	Column	Power BI name	Type	What it holds	Differs from Core	Needs
1	`_id`	`_id`	Text	The Core workforce-log id, or the Lacroo sign-on id.	Rows first recorded in Lacroo, and migrated rows without a Core log id, carry the Lacroo sign-on id.
2	`Created Date`	`Created_Date`	Date/Time/Timezone	When the sign-on was recorded.	Migrated rows carry the Core sign-on’s created time, which can differ slightly from Core’s log row.
3	`Modified Date`	`Modified_Date`	Date/Time/Timezone	The last change to the sign-on, its docket, the worker’s answers or the worker.	Lacroo’s own last-change time, not Core’s value.
4	`Created By`	`Created_By`	Text	Not recorded.	Always blank; Lacroo does not record it.
5	`Sign On`	`Sign_On`	Text	The Core sign-on id, or the Lacroo sign-on id.	Rows first recorded in Lacroo carry the Lacroo sign-on id.
6	`Signee Unique ID`	`Signee_Unique_ID`	Text	The worker’s Lacroo id.	The Lacroo worker id, not Core’s user id.
7	`Sign On Name`	`Sign_On_Name`	Text	The worker’s name.	The worker’s current name in Lacroo.
8	`Email`	`Email`	Text	The worker’s email.	The worker’s current email in Lacroo.	Contact details
9	`Phone Number`	`Phone_Number`	Text	The worker’s phone number.	Kept as entered; Core dropped leading zeros.	Contact details
10	`Sign On Role`	`Sign_On_Role`	Text	The worker’s role on the project when they signed on.	Rows recorded before this release show the worker’s role on the day of the release.
11	`Sign On Date`	`Sign_On_Date`	Date	The shift day, in the project’s time zone.	The day the sign-on counts for; Core used the day it was recorded.
12	`Sign On Time`	`Sign_On_Time`	Date/Time/Timezone	When the worker signed on, in the project’s time zone.	Power BI shows it with the site’s time-zone offset; the clock time is the same.
13	`Project`	`Project`	Text	The Core project id, or the Lacroo project id.	Projects created in Lacroo carry the Lacroo project id.
14	`Project Name`	`Project_Name`	Text	The project’s name.
15	`Project Contract No.`	`Project_Contract_No`	Text	The contract number of the docket’s stage.	On a project with several stages: the docket’s stage, else the first live stage.
16	`Project Company ID`	`Project_Company_ID`	Text	The company id of the docket’s stage.	As for Project Contract No.
17	`Prestart Date`	`Prestart_Date`	Date	The prestart’s date.	Blank when the sign-on has no prestart.
18	`Prestart Time`	`Prestart_Time`	Time	The prestart’s start time.	Blank when the sign-on has no prestart.
19	`Prestart Location`	`Prestart_Location`	Text	Where the prestart was held.
20	`Shift Type`	`Shift_Type`	Text	Day, Afternoon or Night.	Core values carried an icon before the word.
21	`Supervisor`	`Supervisor`	Text	The supervisor’s name.
22	`Supplier`	`Supplier`	Text	The company the worker came through.	Uses the docket’s supplier first, then the worker’s supplier on the project.
23	`Start Time`	`Start_Time`	Time	The docket’s start time.	Blank until a docket exists.
24	`Finish Time`	`Finish_Time`	Time	The docket’s finish time.	Blank until a docket exists.
25	`Break Start Time`	`Break_Start_Time`	Time	When the first break started.	The first break when there are several; all breaks are in Break Start Times.
26	`Break Duration`	`Break_Duration`	Whole number	Break minutes, paid and unpaid.	Paid and unpaid breaks together.
27	`Shift Hours`	`Shift_Hours`	Decimal number	Net hours on the docket.	Net hours of the linked docket.
28	`Linked Docket`	`Linked_Docket`	Text	The Core docket id, or the Lacroo docket id.	Dockets created in Lacroo carry the Lacroo docket id; the number is in Docket Number.
29	`Apprentice`	`Apprentice`	Text	The worker’s answer on this project.	Blank when the worker has not answered; Core showed “No”.
30	`Trainee`	`Trainee`	Text	The worker’s answer on this project.	As for Apprentice.
31	`Gender`	`Gender`	Text	The worker’s answer on this project.	The worker’s current answer on this project.	Diversity details
32	`Date Of Birth`	`Date_Of_Birth`	Date	The worker’s answer on this project.	Blank where the project does not ask for it.	Diversity details
33	`Post Code`	`Post_Code`	Text	The worker’s answer on this project.	Core held suburb, state and postcode; Lacroo holds what the project asks for.	Contact details
34	`Year Of Commencement`	`Year_Of_Commencement`	Text	The worker’s answer on this project.	The worker’s current answer on this project.
35	`Aboriginal or Torres Strait Islander`	`Aboriginal_or_Torres_Strait_Islander`	Text	The worker’s answer on this project.	The worker’s current answer on this project.	Diversity details
36	`Language Group`	`Language_Group`	Text	The worker’s answer on this project.	Blank where the project does not ask for it.	Diversity details
37	`Beakon ID`	`Beakon_ID`	Text	The worker’s Beakon id.	The worker’s current Beakon ID in Lacroo.
38	`Lacroo Sign On ID`	`Lacroo_Sign_On_ID`	Text	The Lacroo sign-on id.
39	`Lacroo Worker ID`	`Lacroo_Worker_ID`	Text	The Lacroo worker id.
40	`Lacroo Project ID`	`Lacroo_Project_ID`	Text	The Lacroo project id.
41	`Sign On Time UTC`	`Sign_On_Time_UTC`	Date/Time/Timezone	When the worker signed on, in UTC.
42	`Project Timezone`	`Project_Timezone`	Text	The project’s time zone.
43	`Supervisor ID`	`Supervisor_ID`	Text	The supervisor’s Lacroo id.
44	`Sign On Role Key`	`Sign_On_Role_Key`	Text	The role’s key.
45	`Shift Type Code`	`Shift_Type_Code`	Text	day, afternoon or night.
46	`Sign On Location`	`Sign_On_Location`	Text	The location scanned at sign-on.
47	`Docket Number`	`Docket_Number`	Text	The linked docket’s number.
48	`Docket Status`	`Docket_Status`	Text	The linked docket’s status.
49	`Gross Hours`	`Gross_Hours`	Decimal number	Gross hours on the docket.
50	`Break Start Times`	`Break_Start_Times`	Text	Every break’s start time, in order.
51	`Record Source`	`Record_Source`	Text	Core for records moved from Core, else Lacroo.

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step, so reports built on the Core names keep working.

Renamed = Table.RenameColumns(Source, {
    {"Created_Date", "Created Date"},
    {"Modified_Date", "Modified Date"},
    {"Created_By", "Created By"},
    {"Sign_On", "Sign On"},
    {"Signee_Unique_ID", "Signee Unique ID"},
    {"Sign_On_Name", "Sign On Name"},
    {"Phone_Number", "Phone Number"},
    {"Sign_On_Role", "Sign On Role"},
    {"Sign_On_Date", "Sign On Date"},
    {"Sign_On_Time", "Sign On Time"},
    {"Project_Name", "Project Name"},
    {"Project_Contract_No", "Project Contract No."},
    {"Project_Company_ID", "Project Company ID"},
    {"Prestart_Date", "Prestart Date"},
    {"Prestart_Time", "Prestart Time"},
    {"Prestart_Location", "Prestart Location"},
    {"Shift_Type", "Shift Type"},
    {"Start_Time", "Start Time"},
    {"Finish_Time", "Finish Time"},
    {"Break_Start_Time", "Break Start Time"},
    {"Break_Duration", "Break Duration"},
    {"Shift_Hours", "Shift Hours"},
    {"Linked_Docket", "Linked Docket"},
    {"Date_Of_Birth", "Date Of Birth"},
    {"Post_Code", "Post Code"},
    {"Year_Of_Commencement", "Year Of Commencement"},
    {"Aboriginal_or_Torres_Strait_Islander", "Aboriginal or Torres Strait Islander"},
    {"Language_Group", "Language Group"},
    {"Beakon_ID", "Beakon ID"},
    {"Lacroo_Sign_On_ID", "Lacroo Sign On ID"},
    {"Lacroo_Worker_ID", "Lacroo Worker ID"},
    {"Lacroo_Project_ID", "Lacroo Project ID"},
    {"Sign_On_Time_UTC", "Sign On Time UTC"},
    {"Project_Timezone", "Project Timezone"},
    {"Supervisor_ID", "Supervisor ID"},
    {"Sign_On_Role_Key", "Sign On Role Key"},
    {"Shift_Type_Code", "Shift Type Code"},
    {"Sign_On_Location", "Sign On Location"},
    {"Docket_Number", "Docket Number"},
    {"Docket_Status", "Docket Status"},
    {"Gross_Hours", "Gross Hours"},
    {"Break_Start_Times", "Break Start Times"},
    {"Record_Source", "Record Source"}
})

To type Sign On Time without a time zone, as Core did:

Typed = Table.TransformColumns(Renamed, {{"Sign On Time", DateTimeZone.RemoveZone, type datetime}})

Connect Power BI Combined report columns