Tableau Connector for Workday

Build 20.0.7740

CanadianRecordofEmploymentData

ROE Data

Columns

Name Type References Description
Printing_Language String English or French depending on user preference
Issue_Type String Issue Type for this ROE, D (Draft) or S (Submit)
ROE_Data_Reference_WID String Contains a unique identifier for an instance of an object.
ROE_Data_Reference_Payroll_ROE_Data_ID String Contains a unique identifier for an instance of an object.
ROE_Serial_Number String Serial Number of ROE Amended or replaced
Employee_ID String Employer's payroll reference number
Employer_Payroll_Reference_Number String Canada Revenue Agency Business Number
Organization_Number String Organization Number for this ROE Configuration
Folder_CD String Folder CD specified for ROE Configuration
Pay_Period_Type String Pay period type
Social_Insurance_Number String Social Insurance Number of the employee for whom the ROE will be issued
ROE_Address_Line_1 String Line 1 of the address of the employee for whom the ROE will be issued - Number and street name
ROE_Address_Line_2 String Line 2 of the address of the employee for whom the ROE will be issued - Place, City and Municipality
ROE_Address_Line_3 String Line 3 of the address of the employee for whom the ROE will be issued - Province, Country and Postal Code
Postal_Code String Postal Code of the address of the employee for whole the ROE will be issued.
Legal_First_Name String First name of the employee for whom the ROE will be issued
Legal_Last_Name String Last name of the employee for whom the ROE will be issued
Legal_Middle_Name String Middle name of the employee for whom the ROE will be issued
First_Day_Worked Date First Day Worked
Last_Day_For_Which_Paid Date Last day for which paid
Final_Pay_Period_End_Date Date Final Pay Period Ending Date
Employee_Occupation String Employee Occupation
ROE_Expected_Recall_Code String Expected recall code
Expected_Date_of_Return Date Expected date of recall
Total_Insurable_Hours Decimal Total insurable hours
Total_Insurable_Earnings Decimal Total insurable earnings
ROE_Reason_Contact_Area_Code_Number String Phone area code for the ROE Issuer contact person
ROE_Reason_Code_for_ROE_Reason String Reason for issuing this ROE
ROE_Reason_Phone_Extension_Number String Phone Extension number for the contact person
ROE_Reason_Contact_First_Name String First name for the contact person
ROE_Reason_Contact_Last_Name String Last name for the contact person
ROE_Reason_Contact_Phone_Number String Phone number for the contact person
Vacation_Pay_Amount Decimal Vacation Pay amount
Comments String Comments
Preferred_User_Language String Communication Preferred In

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740