{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Document and Version","Welcome","Cost Centres","Manager Permissions","HR_Settings","Earnings","Deductions","Vendors","Benefits","Jobs","Time Off Codes","Holiday Tables","Accrual Policies","Accrual Setings","Pay Grades","Positions","Disability","License _Credentials","Assets","Education","Training","Recruitment","Recruitment Questions","Recruitment Workflows","Incidents","Performance Review","Imports","Sign Off","DesignStageBO","DesignStage"],"not_rendered":{"charts":0,"images":30,"macros":1,"external_links":2,"defined_names":147,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Document and Version","index":0,"n_rows":23,"n_cols":37,"rows_kept":23,"cut":false,"hidden":true,"merged":[[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,7,18,12],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,7,19,12],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,12],[17,1,17,2],[17,3,17,4],[17,5,17,6],[17,7,17,12],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,7,14,12],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,12],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,12],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,12],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,12],[2,31,2,32],[3,1,3,12],[6,1,6,12],[7,1,8,12],[10,1,10,12]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EEO",null,null,"Coverage",null,"DepBenReq",null,null,"DepAgeStopBene",null,null,"PerfDate",null,"DedFreq"]
[null,"Document and Version Control",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Every Pay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dep -Ben SSN & BD",null,null,"End of Calendar Year",null,null,"Hired Date",null,"Every Scheduled Pay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Administrative Support Workers",null,null,"Base Salaries",null,"Dep-Ben SSN",null,null,"End of Plan Year",null,null,"Started Date",null,"Every Other Scheduled Pay"]
[null,"Document Overview",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Craft Workers",null,null,"Benefit Salaries",null,"Dep-Ben BD",null,null,"Month of dependent childs birth date",null,null,"Company Fiscal Date",null,"1st & 3rd Pay Periods"]
[null,"This document is used to gather Sales to Service information as well as client goals and requirements.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Executive/Senior Level Officials and Managers",null,null,"1x Base Salaries",null,"Dep Only SSN & BD",null,null,"Other (explain-additional Note)",null,null,"Calendar Day",null,"2nd & 4th Pay Period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2x Base Salaries",null,"Dep Only SSN",null,null,null,null,null,"Seniority Date",null,"Montly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"First/Mid Level Officials and Managers",null,null,"1x Benefit Salaries",null,"Dep Only BD",null,null,null,null,null,"Rehired Date",null,"Quarterly"]
[null,"Version Control",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Laborers and Helpers",null,null,"2x Benefit Salaries",null,"Dep Only BD",null,null,null,null,null,"First Calculated Date",null,"Annual"]
[null,"Version",null,"Date",null,"Author",null,"Notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operatives",null,null,"xBase Salaries (multi elect 1x,2x,3x)",null,null,null,null,null,null,null,"Review Date"]
[null,"A",null,"2015-03-17",null,"Kathy Thurman",null,"Updated,setup recruting on separate tab, updated benefit information, made modifications to flow of build check list. Added domestic partner questions and workflow information & document types",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Professionals",null,null,"xBenefit Salaries (multi elect 1x,2x,3x)"]
[null,"B",null,"2015-07-16",null,"Steve Wolski",null,"Added the ability for users to format cells.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales Workers",null,null,"Elect from Multiple Amounts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Workers",null,null,"Flat Amount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Technicians",null,null,null,null,"DepBenBirthSSN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dep Birth/SSN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dep & Ben Birth/SSN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ben Birth/SSN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dep Birth date only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dep SSN only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ben Birth date only"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ben SSN only"]

{"sheet":"Welcome","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[10,1,20,12],[28,0,28,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"HR Escape Plus"]
[null,"Setup Document"]
[null,"Purpose\nThe purpose of this document is to detail the configuration that will be implemented in HR Escape Plus. Please read this document thoroughly as it describes the system configuration requirements gathered during your Discovery & Assessment with your PayEscape Application Consultant. The information gathered in this document will be used to build your solution.\n  \nThe main goals for this document are to:\n    • Gather and document your HR requirements\n    • Define your HR Escape Plus Solution"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please note:"]
[null,"Failure to supply the required information in a timely manner could result in delays to your implementation."]
[null,"Payescape will build all modules noted in this document as part of the implimentation fee quoted. "]
[null,"Any module building needed additional to the information in this document may result in further charges. "]

{"sheet":"Cost Centres","index":2,"n_rows":83,"n_cols":6,"rows_kept":83,"cut":false,"hidden":false,"merged":[[164,3,164,4],[164,5,164,6],[167,3,167,4],[167,5,167,6],[168,3,168,4],[168,5,168,6],[169,1,169,4],[165,3,165,4],[165,5,165,6],[166,3,166,4],[166,5,166,6],[161,3,161,4],[161,5,161,6],[162,3,162,4],[162,5,162,6],[163,3,163,4],[163,5,163,6],[158,3,158,4],[158,5,158,6],[159,3,159,4],[159,5,159,6],[160,3,160,4],[160,5,160,6],[155,3,155,4],[155,5,155,6],[156,3,156,4],[156,5,156,6],[157,3,157,4],[157,5,157,6],[152,3,152,4],[152,5,152,6],[153,3,153,4],[153,5,153,6],[154,3,154,4],[154,5,154,6],[149,3,149,4],[149,5,149,6],[150,3,150,4],[150,5,150,6],[151,3,151,4],[151,5,151,6],[146,3,146,4],[146,5,146,6],[147,3,147,4],[147,5,147,6],[148,3,148,4],[148,5,148,6],[143,3,143,4],[143,5,143,6],[144,3,144,4],[144,5,144,6],[145,3,145,4],[145,5,145,6],[140,3,140,4],[140,5,140,6],[141,3,141,4],[141,5,141,6],[142,3,142,4],[142,5,142,6],[137,3,137,4],[137,5,137,6],[138,3,138,4],[138,5,138,6],[139,3,139,4],[139,5,139,6],[134,3,134,4],[134,5,134,6],[135,3,135,4],[135,5,135,6],[136,3,136,4],[136,5,136,6],[131,3,131,4],[131,5,131,6],[132,3,132,4],[132,5,132,6],[133,3,133,4],[133,5,133,6],[128,3,128,4],[128,5,128,6],[129,3,129,4],[129,5,129,6],[130,3,130,4],[130,5,130,6],[125,3,125,4],[125,5,125,6],[126,3,126,4],[126,5,126,6],[127,3,127,4],[127,5,127,6],[122,3,122,4],[122,5,122,6],[123,3,123,4],[123,5,123,6],[124,3,124,4],[124,5,124,6],[119,3,119,4],[119,5,119,6],[120,3,120,4],[120,5,120,6],[121,3,121,4],[121,5,121,6],[116,3,116,4],[116,5,116,6],[117,3,117,4],[117,5,117,6],[118,3,118,4],[118,5,118,6],[113,3,113,4],[113,5,113,6],[114,3,114,4],[114,5,114,6],[115,3,115,4],[115,5,115,6],[110,3,110,4],[110,5,110,6],[111,3,111,4],[111,5,111,6],[112,3,112,4],[112,5,112,6],[107,3,107,4],[107,5,107,6],[108,3,108,4],[108,5,108,6],[109,3,109,4],[109,5,109,6],[104,3,104,4],[104,5,104,6],[105,3,105,4],[105,5,105,6],[106,3,106,4],[106,5,106,6],[101,3,101,4],[101,5,101,6],[102,3,102,4],[102,5,102,6],[103,3,103,4],[103,5,103,6],[98,3,98,4],[98,5,98,6],[99,3,99,4],[99,5,99,6],[100,3,100,4],[100,5,100,6],[95,3,95,4],[95,5,95,6],[96,3,96,4],[96,5,96,6],[97,3,97,4],[97,5,97,6],[92,3,92,4],[92,5,92,6],[93,3,93,4],[93,5,93,6],[94,3,94,4],[94,5,94,6],[89,3,89,4],[89,5,89,6],[90,3,90,4],[90,5,90,6],[91,3,91,4],[91,5,91,6],[86,3,86,4],[86,5,86,6],[87,3,87,4],[87,5,87,6],[88,3,88,4],[88,5,88,6],[83,3,83,4],[83,5,83,6],[84,3,84,4],[84,5,84,6],[85,3,85,4],[85,5,85,6],[78,2,78,3],[78,4,78,6],[79,2,79,3],[79,4,79,6],[82,3,82,4],[82,5,82,6],[75,2,75,3],[75,4,75,6],[76,2,76,3],[76,4,76,6],[77,2,77,3],[77,4,77,6],[67,1,67,6],[68,1,70,6],[73,2,73,3],[73,4,73,6],[74,2,74,3],[74,4,74,6],[60,1,60,2],[60,3,60,4],[60,5,60,6],[61,1,61,2],[61,3,61,4],[61,5,61,6],[58,1,58,2],[58,3,58,4],[58,5,58,6],[59,1,59,2],[59,3,59,4],[59,5,59,6],[56,1,56,2],[56,3,56,4],[56,5,56,6],[57,1,57,2],[57,3,57,4],[57,5,57,6],[54,1,54,2],[54,3,54,4],[54,5,54,6],[55,1,55,2],[55,3,55,4],[55,5,55,6],[52,1,52,2],[52,3,52,4],[52,5,52,6],[53,1,53,2],[53,3,53,4],[53,5,53,6],[50,1,50,2],[50,3,50,4],[50,5,50,6],[51,1,51,2],[51,3,51,4],[51,5,51,6],[48,1,48,2],[48,3,48,4],[48,5,48,6],[49,1,49,2],[49,3,49,4],[49,5,49,6],[42,1,42,2],[42,3,42,6],[46,1,46,2],[46,3,46,4],[46,5,46,6],[47,1,47,2],[47,3,47,4],[47,5,47,6],[39,1,39,2],[39,3,39,6],[40,1,40,2],[40,3,40,6],[41,1,41,2],[41,3,41,6],[2,1,2,5],[3,1,6,6],[9,1,12,6],[17,1,17,3],[18,1,18,5],[13,1,15,6]]}
[]
[]
[null,"Cost Centres"]
[null,"The system will allow you to track employee time down to the cost centres level. Cost centres allow you to assign time to different locations, departments, positions, etc. and filter reports within your company based on the cost centres. An example is tracking time by Location, Department, and Position. This allows managers to run reports and break down data to any of these three levels. For example, supervisors could break down how many hours were spent in a specific Position within a specific Department and at a specific Location."]
[]
[]
[]
[]
[null,"Levels and Entities"]
[null,"There are two aspects of a Cost Centre structure, the Levels and the Entities. The Levels are the titles of the Cost Centre tree and the Entities are the values under the Level. In the example below the Level is titled \"Location\" and the Entities are \"London and Manchester\". The Cost Centre tree can expand and continue with additional entities under the previous entities. So in the example below Finance is an entity of the London Location and Auditor is an entity of the Finance Department."]
[]
[]
[]
[null,"        ▪  The Entities for the Locations are London and Manchester\n        ▪  The Entities for the Departments are Finance, Marketing, Operations, Sales and Warehouse\n        ▪  The Entities for the Positions are Auditor, Controller, Manager, Consultant, Asst. Manager, Floor Manager, Line Worker, etc."]
[]
[]
[]
[null,"Cost Centre Example Layout"]
[null,"For the example above the Cost Centre layout would resemble the following structure."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Levels"]
[null,"Name",null,"Notes"]
[null,"Location",null,"Will consist of multiple business locations"]
[null,"Department",null,"Will consist of the departments at the specified locations"]
[null,"Position",null,"Will consist of the positions within the departments"]
[]
[]
[null,"Entities"]
[null,"Locations",null,"Departments",null,"Positions"]
[null,"London",null,"Finance",null,"Auditor"]
[null,"London",null,"Finance",null,"Controller"]
[null,"London",null,"Finance",null,"Manager"]
[null,"London",null,"Marketing",null,"Consultant"]
[null,"London",null,"Marketing",null,"Manager"]
[null,"Manchester",null,"Operations",null,"Asst. Manager"]
[null,"Manchester",null,"Operations",null,"Floor Manager"]
[null,"Manchester",null,"Operations",null,"Line Worker"]
[null,"Manchester",null,"Operations",null,"Office Manager"]
[null,"Manchester",null,"Operations",null,"Supervisor"]
[null,"Manchester",null,"Sales",null,"Order Entry"]
[null,"Manchester",null,"Sales",null,"Presales Consultant"]
[null,"Manchester",null,"Sales",null,"Sales Manager"]
[null,"Manchester",null,"Sales",null,"Asst. Manager"]
[null,"Manchester",null,"Sales",null,"Manager"]
[]
[]
[]
[]
[]
[null,"Notes"]
[]
[]
[]
[]
[null,"Cost Centre Levels"]
[null,"Level","Name",null,"Description"]
[null,1,"Branch ",null,"This is an example"]
[null,2,"Department ",null,"This is an example"]
[null,3,"Cost Centre",null,"This is an example"]
[null,4,null,null,"This is an example"]
[null,5,null,null,"This is an example"]
[null,6,null,null,"This is an example"]
[]
[]
[null,"Cost Centre","Cost Centre Description","Cost Centre Payroll Code",null,"Cost Centre Address Field (only for Geo-Fencing)"]

{"sheet":"Manager Permissions","index":3,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,19,15],[20,1,27,15],[15,1,15,10],[15,11,15,15],[16,1,16,10],[16,11,16,15],[2,1,2,12],[7,1,8,12],[9,1,12,15],[14,1,14,10],[14,11,14,15],[3,1,6,13]]}
[]
[]
[null,"Manager Permissions "]
[null,"Managers will have permissions to alter employee timesheets (e.g. add time, edit time, add pay code edits, etc.),editing profiles and contracts, as well as altering employee demographics and schedules. Within each of these areas are specific functions that you may want to enable/disable to prevent unnecessary edits from occuring. PayEscape has implemented thousands of systems and we have devised Best Practice settings for you. You may select to change the settings, however, it is recommended that you adhere to them in order to standardize your system and realize the most benefit."]
[]
[]
[]
[null,"Best Practice Permissions Example"]
[]
[null,"The Best Practice permissions were created based on thousands of configurations. It consists of the most highly used permission settings and recommended permissions settings based on deep knowledge of how the system operates. It is intended to give your managers the most flexibility, while also maintaining a high level of integrity and supportability. It is important to note that deviation from the Best Practice settings may cause additional time and effort in the future when troubleshooting or making modifications to your system."]
[]
[]
[]
[]
[null,"Should managers be able to view or edit base compensation?",null,null,null,null,null,null,null,null,null,"No Access to Base Compensation"]
[null,"Should managers be able to view or edit employee account information (address, contacts, etc?)",null,null,null,null,null,null,null,null,null,"View Only"]
[null,"Should managers be able to view and/or change Cost Centres on their employee timesheets?",null,null,null,null,null,null,null,null,null,"Edit (includes View)"]
[]
[]
[null,"Additional Notes"]

{"sheet":"HR_Settings","index":4,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[23,9,23,11],[22,9,22,11],[21,9,21,11],[20,9,20,11],[19,9,19,11],[19,5,19,7],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,5,23,7],[16,5,16,7],[14,9,14,11],[15,9,15,11],[16,9,16,11],[18,5,18,7],[18,9,18,11],[17,9,17,11],[17,5,17,7],[42,1,42,3],[42,4,42,5],[23,1,23,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[28,4,28,5],[41,4,41,5],[33,1,33,3],[33,4,33,5],[34,4,34,5],[35,4,35,5],[36,4,36,5],[37,4,37,5],[9,1,9,12],[10,1,11,12],[13,1,13,3],[14,1,14,3],[15,1,15,3],[13,5,13,6],[14,5,14,7],[15,5,15,7],[2,1,2,12],[3,1,3,12],[4,1,4,12],[5,1,7,6],[5,7,7,12],[41,1,41,3],[34,1,34,3],[35,1,35,3],[16,1,16,3],[17,1,17,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[26,1,26,12],[29,6,29,7],[40,4,40,5],[36,1,36,3],[30,1,30,3],[31,1,31,3],[30,4,30,5],[31,4,31,5],[40,1,40,3],[38,4,38,5],[39,4,39,5],[30,6,30,7],[31,6,31,7],[27,1,27,12],[28,1,28,3],[29,1,29,3],[28,6,28,7],[29,4,29,5]]}
[]
[]
[null,"HR Settings"]
[]
[null,"Top Level Manager"]
[null,"Please specify the manager to use for the Organisation Chart Generation: This determines the manager who is at the TOP of your organisation chart chain. "]
[]
[]
[]
[null,"Employee Profile List Views"]
[null,"The following values are used to classify and group employees in the database. Standard values for each list are provided. If you would like additional or different values, please add them below."]
[]
[]
[null,"Employee Types",null,null,null,"Account Status",null,null,null,"Pay Types"]
[null,"Temp",null,null,null,"Active",null,null,null,"Salaried"]
[null,"Apprentices",null,null,null,"Terminated",null,null,null,"Hourly"]
[null,"Perm",null,null,null,"Seasonal"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Termination Details"]
[null,"Termination Details:  These options determine what shows and is required to be entered when terminating an employee"]
[null,"Item",null,null,"Displayed",null,"Required"]
[null,"Termination Reason"]
[null,"Terminating Manager"]
[null,"Termination Notes"]
[]
[null,"Item",null,null,"Required"]
[null,"Re-Hirable"]
[null,"Notice to Employer"]
[null,"Asset Removal"]
[null,"Exit Interview"]
[null,"Benefit Termination Date"]
[null,"Deduction End Date"]
[null,"Direct Deposit End Date"]
[null,"Earnings End Date"]
[null,"Benefit Coverage End Date"]

{"sheet":"Earnings","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":true,"merged":[[3,1,3,4],[4,1,5,4]]}
[]
[]
[]
[null,"Earnings"]
[null,"Define Benefit related earnings codes "]
[]
[]
[null,"Earning Information"]
[null,"Name","Code/Abbreviation","Description","EIN"]

{"sheet":"Deductions","index":6,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":true,"merged":[[3,1,3,5],[4,1,6,5]]}
[]
[]
[]
[null,"Deductions"]
[null,"Define Benefit related deduction codes. "]
[]
[]
[null,"Deduction Information"]
[null,"Name","Code/Abbreviation","Description","EIN","Pre or Post Tax"]

{"sheet":"Vendors","index":7,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":true,"merged":[[3,1,3,4],[4,1,6,4]]}
[]
[]
[]
[null,"Vendors"]
[null,"Define your Benefit Vendors (EBN Customers)"]
[]
[]
[null,"Vendor Information"]
[null,"Vendor Information","Vendor 1","Vendor 2","Vendor 3","Vendor 4","Vendor 5","Vendor 6","Vendor 7 ","Vendor 8","Vendor 9","Vendor 10 "]
[null,"Name "]
[null,"Description"]
[null,"Code"]
[null,"FEIN"]
[null,"Used for "]
[null,"Contact First Name"]
[null,"Contact Last Name"]
[null,"Phone "]
[null,"Fax"]
[null,"Email "]
[null,"Country"]
[null,"Street"]
[null,"Zip"]
[null,"City "]
[null,"State"]

{"sheet":"Benefits","index":8,"n_rows":271,"n_cols":26,"rows_kept":271,"cut":false,"hidden":true,"merged":[[250,10,250,12],[3,1,3,12],[4,1,7,12],[17,21,17,22],[17,23,17,24],[16,23,16,24],[17,5,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[16,13,16,14],[16,15,16,16],[16,17,16,18],[16,19,16,20],[16,21,16,22],[17,17,17,18],[17,19,17,20],[17,15,17,16],[14,19,14,20],[14,21,14,22],[14,23,14,24],[15,13,15,14],[15,15,15,16],[19,21,19,22],[19,23,19,24],[18,23,18,24],[18,21,18,22],[15,19,15,20],[15,21,15,22],[15,23,15,24],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[18,13,18,14],[18,15,18,16],[18,17,18,18],[18,19,18,20],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[19,15,19,16],[19,17,19,18],[19,19,19,20],[26,19,26,20],[24,13,24,14],[26,5,26,6],[26,7,26,8],[26,11,26,12],[26,13,26,14],[26,15,26,16],[23,23,23,24],[23,13,23,14],[23,15,23,16],[23,17,23,18],[23,19,23,20],[23,21,23,22],[24,19,24,20],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,14],[25,15,25,16],[25,17,25,18],[25,19,25,20],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[22,19,22,20],[20,23,20,24],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[20,13,20,14],[20,15,20,16],[20,17,20,18],[20,19,20,20],[20,21,20,22],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[21,15,21,16],[21,17,21,18],[21,19,21,20],[65,1,66,1],[65,2,66,3],[61,2,61,3],[71,2,71,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[22,17,22,18],[26,1,26,4],[24,15,24,16],[24,17,24,18],[26,17,26,18],[24,1,24,4],[25,1,25,4],[39,1,41,4],[32,1,32,4],[35,1,35,4],[38,1,38,4],[33,1,33,4],[34,1,34,4],[49,2,49,4],[22,1,22,4],[26,9,26,10],[14,15,14,16],[14,17,14,18],[16,9,16,10],[16,11,16,12],[15,7,15,8],[15,9,15,10],[15,11,15,12],[23,1,23,4],[21,1,21,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[16,1,16,4],[17,1,17,4],[15,1,15,4],[16,5,16,6],[16,7,16,8],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[22,13,22,14],[22,15,22,16],[15,17,15,18],[162,2,162,4],[129,2,129,3],[247,1,248,1],[247,2,248,3],[110,1,111,1],[110,2,111,3],[106,2,106,3],[116,2,116,4],[14,13,14,14],[27,7,27,8],[30,9,30,10],[31,9,31,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,1,30,4],[31,1,31,4],[28,1,28,4],[29,1,29,4],[28,7,28,8],[29,7,29,8],[152,2,152,3],[83,2,83,3],[27,1,27,4],[207,2,207,4],[27,15,27,16],[27,23,27,24],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[10,5,10,6],[9,5,9,6],[11,5,11,6],[8,5,8,6],[8,7,8,12],[9,7,9,12],[10,7,10,12],[11,7,11,12],[13,1,13,12],[14,1,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[15,5,15,6],[156,1,157,1],[156,2,157,3],[32,9,32,10],[33,9,33,10],[34,9,34,10],[35,9,35,10],[38,9,38,10],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[38,5,38,6],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[38,7,38,8],[27,11,27,12],[28,11,28,12],[29,11,29,12],[27,13,27,14],[28,13,28,14],[29,13,29,14],[38,11,38,12],[38,13,38,14],[28,15,28,16],[29,15,29,16],[30,15,30,16],[30,11,30,12],[31,15,31,16],[32,15,32,16],[33,15,33,16],[34,15,34,16],[35,15,35,16],[30,13,30,14],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[31,13,31,14],[34,13,34,14],[35,13,35,14],[32,19,32,20],[33,19,33,20],[34,19,34,20],[35,19,35,20],[30,17,30,18],[31,17,31,18],[32,17,32,18],[27,17,27,18],[28,17,28,18],[29,17,29,18],[30,23,30,24],[31,23,31,24],[32,23,32,24],[33,23,33,24],[34,23,34,24],[35,23,35,24],[30,21,30,22],[31,21,31,22],[32,21,32,22],[33,21,33,22],[34,21,34,22],[35,21,35,22],[30,19,30,20],[31,19,31,20],[33,17,33,18],[34,17,34,18],[35,17,35,18],[27,19,27,20],[28,19,28,20],[29,19,29,20],[14,25,14,26],[15,25,15,26],[16,25,16,26],[17,25,17,26],[18,25,18,26],[19,25,19,26],[20,25,20,26],[21,25,21,26],[39,21,41,22],[28,23,28,24],[29,23,29,24],[27,21,27,22],[28,21,28,22],[29,21,29,22],[26,21,26,22],[26,23,26,24],[24,21,24,22],[24,23,24,24],[25,21,25,22],[25,23,25,24],[22,21,22,22],[22,23,22,24],[21,21,21,22],[21,23,21,24],[22,25,22,26],[23,25,23,26],[24,25,24,26],[25,25,25,26],[26,25,26,26],[27,25,27,26],[28,25,28,26],[29,25,29,26],[30,25,30,26],[31,25,31,26],[32,25,32,26],[33,25,33,26],[34,25,34,26],[35,25,35,26],[38,25,38,26],[39,25,41,26],[45,1,45,12],[39,5,41,6],[39,7,41,8],[39,9,41,10],[39,11,41,12],[39,13,41,14],[39,15,41,16],[39,17,41,18],[39,19,41,20],[39,23,41,24],[38,21,38,22],[38,19,38,20],[38,15,38,16],[38,17,38,18],[38,23,38,24],[32,13,32,14],[33,13,33,14],[74,6,74,7],[75,6,75,7],[76,6,76,7],[77,6,77,7],[78,6,78,7],[52,6,52,7],[53,6,53,7],[54,6,54,7],[55,6,55,7],[56,6,56,7],[57,6,57,7],[58,6,58,7],[98,6,98,7],[99,6,99,7],[100,6,100,7],[101,6,101,7],[102,6,102,7],[79,6,79,7],[80,6,80,7],[87,1,88,1],[87,2,88,3],[93,2,93,4],[96,6,96,7],[97,6,97,7],[124,6,124,7],[125,6,125,7],[133,1,134,1],[133,2,134,3],[139,2,139,4],[142,6,142,7],[143,6,143,7],[119,6,119,7],[120,6,120,7],[121,6,121,7],[122,6,122,7],[123,6,123,7],[165,6,165,7],[166,6,166,7],[167,6,167,7],[168,6,168,7],[169,6,169,7],[170,6,170,7],[144,6,144,7],[145,6,145,7],[146,6,146,7],[147,6,147,7],[148,6,148,7],[196,2,196,3],[200,1,201,1],[200,2,201,3],[171,6,171,7],[174,2,174,3],[178,1,179,1],[178,2,179,3],[184,2,184,4],[187,6,187,7],[188,6,188,7],[189,6,189,7],[210,6,210,7],[211,6,211,7],[212,6,212,7],[213,6,213,7],[214,6,214,7],[215,6,215,7],[190,6,190,7],[191,6,191,7],[192,6,192,7],[193,6,193,7],[243,2,243,3],[253,2,253,4],[216,6,216,7],[220,2,220,3],[224,1,225,1],[224,2,225,3],[230,2,230,4],[233,6,233,7],[234,6,234,7],[235,6,235,7],[256,6,256,7],[257,6,257,7],[258,6,258,7],[259,6,259,7],[260,6,260,7],[236,6,236,7],[237,6,237,7],[238,6,238,7],[239,6,239,7],[261,6,261,7],[262,6,262,7],[266,2,266,3],[270,1,271,1],[270,2,271,3],[266,10,266,12],[267,10,267,12],[268,10,268,12],[269,10,269,12],[270,10,270,12],[271,10,271,12],[272,10,272,12],[273,10,273,12],[61,10,61,12],[62,10,62,12],[63,10,63,12],[64,10,64,12],[65,10,65,12],[66,10,66,12],[67,10,67,12],[68,10,68,12],[83,10,83,12],[84,10,84,12],[85,10,85,12],[86,10,86,12],[87,10,87,12],[88,10,88,12],[89,10,89,12],[90,10,90,12],[106,10,106,12],[107,10,107,12],[108,10,108,12],[109,10,109,12],[110,10,110,12],[111,10,111,12],[162,10,162,12],[112,10,112,12],[116,10,116,12],[129,10,129,12],[130,10,130,12],[131,10,131,12],[132,10,132,12],[133,10,133,12],[134,10,134,12],[135,10,135,12],[198,10,198,12],[199,10,199,12],[200,10,200,12],[201,10,201,12],[202,10,202,12],[205,10,205,12],[206,10,206,12],[220,10,220,12],[139,10,139,12],[174,10,174,12],[175,10,175,12],[176,10,176,12],[177,10,177,12],[178,10,178,12],[179,10,179,12],[180,10,180,12],[184,10,184,12],[152,10,152,12],[153,10,153,12],[154,10,154,12],[155,10,155,12],[156,10,156,12],[157,10,157,12],[158,10,158,12],[245,10,245,12],[246,10,246,12],[247,10,247,12],[248,10,248,12],[251,10,251,12],[252,10,252,12],[113,10,113,12],[227,10,227,12],[204,10,204,12],[181,10,181,12],[159,10,159,12],[136,10,136,12],[196,10,196,12],[203,10,203,12],[221,10,221,12],[222,10,222,12],[223,10,223,12],[224,10,224,12],[225,10,225,12],[228,10,228,12],[229,10,229,12],[243,10,243,12],[244,10,244,12],[197,10,197,12],[36,1,36,4],[36,5,36,6],[37,1,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[36,7,36,8],[36,9,36,10],[36,11,36,12],[36,13,36,14],[36,15,36,16],[36,17,36,18],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,26],[37,11,37,12],[37,13,37,14],[37,15,37,16],[37,17,37,18],[37,19,37,20],[37,21,37,22],[37,23,37,24],[37,25,37,26]]}
[]
[]
[]
[null,"Benefits"]
[null,"Workforce Ready can keep track of benefit plan information such as eligibility, level of coverage and premium amounts for various employee provided benefits (health, dental, life insurance, etc.) This helps in reporting information to the benefit carriers and the ability to make changes globally for employees when premium amounts change. "]
[]
[]
[]
[null,null,null,null,null,null,null,"Comment"]
[null,"Do you offer some benefits to only select groups?"]
[null,"Do you offer benefits to domestic partner?"]
[null,"If you offer domestic partner benefits, is it post or pre taxed?"]
[]
[null,"Benefit Information"]
[null,"Plan Information",null,null,null,"Example",null,"Plan 1 ",null,"Plan 2",null,"Plan 3",null,"Plan 4",null,"Plan 5",null,"Plan 6",null,"Plan 7",null,"Plan 8",null,"Plan 9 ",null,"Plan 10"]
[null,"Plan Name",null,null,null,"Blue Cross Health Insurance"]
[null,"Plan Type",null,null,null,"Medical"]
[null,"Description",null,null,null,"Section 125 medical insurance"]
[null,"Pre Tax or Post Tax",null,null,null,"Pre Tax"]
[null,"Provider Name",null,null,null,"Blue Cross Blue Shield"]
[null,"Policy #",null,null,null,12345]
[null,"Start Date of Plan Year",null,null,null,"2014-01-01"]
[null,"Employer Only Paid Plan?",null,null,null,"No"]
[null,"Deduction Code to be used for this plan",null,null,null,"Medical "]
[null,"How often is deduction withheld?",null,null,null,"1st and 3rd Pay Periods"]
[null,"Earning Code to be used for this plan"]
[null,"How often is this earning paid?"]
[null,"Eligibility Requirements/Waiting Period",null,null,null,"1st of the month following 90 days from date of hire"]
[null,"Employee Group(s) Eligible for this plan",null,null,null,"All employee's except CA"]
[null,"Is this Benefit Plan dependent on the enrollment of another benefit plan type? ",null,null,null,"HSA "]
[null,"Does this plan have Coverage amount  or election options? ",null,null,null,"Election Options"]
[null,"Coverage amount based on? "]
[null,"Is there a cap on the coverage amount for this plan based on another benefit plan's coverage? "]
[null,"Employee Birth date Required?",null,null,null,"No"]
[null,"Are beneficiaries required?",null,null,null,"No"]
[null,"Are dependent and beneficiary birthdates and SSN required? ",null,null,null,"Dep"]
[null,"Do you currently have birthdates and SSN for above? ",null,null,null,"Dep Birth/SSN"]
[null,"If the plan is age dependent, is it based on Employee age, Spouse Age or Dependent Age? "]
[null,"Age Dependent child no longer eligible to be enrolled in plan. When do they drop from the plan?"]
[null,"Additional Information "]
[]
[]
[]
[]
[]
[null,"Coverage Levels"]
[]
[]
[]
[null,"Plan 1",{"$f":"H16","v":0}]
[]
[null,"(Medical Dental, Vision)",null,null,null,null,"Coverage Levels (Life, Supp Life, Spouse Life, GTL, Child Life LTD, STD)"]
[null,"Coverage Name \n(Election) ","Employee Monthly Amount","Employer Monthly Amount","Premium",null,"Coverage Amount",null,"Rounding","Salary as of","Premium Based on Employee or Spouse Age","Employee Premium","Employer Contribution"]
[null,"Family",150,400,{"$f":"C54+D54","v":550},null,"1X Base Salary ",null,"1x salary, round next 1,000","Begin plan year","N/A","N/A",".49 per 1,000 "]
[null,null,null,null,{"$f":"IF(C55=\"\",\"\",C55+D55)","v":""},null,"50% of EE Coverage",null,"Round to down next 1,000","Begin plan year","Spouse Age","Age rate per 1,000","N/A"]
[null,null,null,null,{"$f":"IF(C56=\"\",\"\",C56+D56)","v":""}]
[null,null,null,null,{"$f":"IF(C57=\"\",\"\",C57+D57)","v":""}]
[null,null,null,null,{"$f":"IF(C58=\"\",\"\",C58+D58)","v":""}]
[null,null,null,null,{"$f":"IF(C59=\"\",\"\",C59+D59)","v":""}]
[]
[null,"Use Units  (FSA, HSA, Life Insurance)",null,null,null,null,"Premium Rate Table (Revise columns as needed or use a separate doc)"]
[null,"Minimum $",null,null,null,null,"Age","Rate ","Monthly Employee Premium","Monthly Employer Premium","Notes"]
[null,"Maximum $"]
[null,"Label"]
[null,"Symbol","$"]
[null,"Evidence of Insurability required for value over"]
[]
[]
[]
[]
[]
[null,"Plan 2",{"$f":"J16","v":0}]
[]
[null,"(Medical Dental, Vision)",null,null,null,null,"Coverage Levels (Life, Supp Life, Spouse Life, GTL, Child Life LTD, STD)"]
[null,"Coverage Name \n(Election) ","Employee Monthly Amount","Employer Monthly Amount","Premium",null,"Coverage Amount",null,"Rounding","Salary as of","Premium Based on Employee or Spouse Age","Employee Premium","Employer Contribution"]
[null,"Family",150,400,{"$f":"C76+D76","v":550},null,"1X Base Salary ",null,"1x salary, round next 1,000","Begin plan year","N/A","N/A",".49 per 1,000 "]
[null,null,null,null,{"$f":"IF(C77=\"\",\"\",C77+D77)","v":""},null,"50% of EE Coverage",null,"Round to down next 1,000","Begin plan year","Spouse Age","Age rate per 1,000","N/A"]
[null,null,null,null,{"$f":"IF(C78=\"\",\"\",C78+D78)","v":""}]
[null,null,null,null,{"$f":"IF(C79=\"\",\"\",C79+D79)","v":""}]
[null,null,null,null,{"$f":"IF(C80=\"\",\"\",C80+D80)","v":""}]
[null,null,null,null,{"$f":"IF(C81=\"\",\"\",C81+D81)","v":""}]
[]
[null,"Use Units  (FSA, HSA, Life Insurance)",null,null,null,null,"Premium Rate Table (Revise columns as needed or use a separate doc)"]
[null,"Minimum $",null,null,null,null,"Age","Rate ","Monthly Employee Premium","Monthly Employer Premium","Notes"]
[null,"Maximum $"]
[null,"Label"]
[null,"Symbol","$"]
[null,"Evidence of Insurability required for value over"]
[]
[]
[]
[]
[]
[null,"Plan 3",{"$f":"L16","v":0}]
[]
[null,"(Medical Dental, Vision)",null,null,null,null,"Coverage Levels (Life, Supp Life, Spouse Life, GTL, Child Life LTD, STD)"]
[null,"Coverage Name \n(Election) ","Employee Monthly Amount","Employer Monthly Amount","Premium",null,"Coverage Amount",null,"Rounding","Salary as of","Premium Based on Employee or Spouse Age","Employee Premium","Employer Contribution"]
[null,"Family",150,400,{"$f":"C98+D98","v":550},null,"1X Base Salary ",null,"1x salary, round next 1,000","Begin plan year","N/A","N/A",".49 per 1,000 "]
[null,null,null,null,{"$f":"IF(C99=\"\",\"\",C99+D99)","v":""},null,"50% of EE Coverage",null,"Round to down next 1,000","Begin plan year","Spouse Age","Age rate per 1,000","N/A"]
[null,null,null,null,{"$f":"IF(C100=\"\",\"\",C100+D100)","v":""}]
[null,null,null,null,{"$f":"IF(C101=\"\",\"\",C101+D101)","v":""}]
[null,null,null,null,{"$f":"IF(C102=\"\",\"\",C102+D102)","v":""}]
[null,null,null,null,{"$f":"IF(C103=\"\",\"\",C103+D103)","v":""}]
[]
[]
[null,"Use Units  (FSA, HSA, Life Insurance)",null,null,null,null,"Premium Rate Table (Revise columns as needed or use a separate doc)"]
[null,"Minimum $",null,null,null,null,"Age","Rate ","Monthly Employee Premium","Monthly Employer Premium","Notes"]
[null,"Maximum $"]
[null,"Label"]
[null,"Symbol","$"]
[null,"Evidence of Insurability required for value over"]
[]
[]
[]
[]
[]
[null,"Plan 4",{"$f":"N16","v":0}]
[]
[null,"(Medical Dental, Vision)",null,null,null,null,"Coverage Levels (Life, Supp Life, Spouse Life, GTL, Child Life LTD, STD)"]
[null,"Coverage Name \n(Election) ","Employee Monthly Amount","Employer Monthly Amount","Premium",null,"Coverage Amount",null,"Rounding","Salary as of","Premium Based on Employee or Spouse Age","Employee Premium","Employer Contribution"]
[null,"Family",150,400,{"$f":"C121+D121","v":550},null,"1X Base Salary ",null,"1x salary, round next 1,000","Begin plan year","N/A","N/A",".49 per 1,000 "]
[null,null,null,null,{"$f":"IF(C122=\"\",\"\",C122+D122)","v":""},null,"50% of EE Coverage",null,"Round to down next 1,000","Begin plan year","Spouse Age","Age rate per 1,000","N/A"]
[null,null,null,null,{"$f":"IF(C123=\"\",\"\",C123+D123)","v":""}]
[null,null,null,null,{"$f":"IF(C124=\"\",\"\",C124+D124)","v":""}]
[null,null,null,null,{"$f":"IF(C125=\"\",\"\",C125+D125)","v":""}]
[null,null,null,null,{"$f":"IF(C126=\"\",\"\",C126+D126)","v":""}]
[]
[]
[null,"Use Units  (FSA, HSA, Life Insurance)",null,null,null,null,"Premium Rate Table (Revise columns as needed or use a separate doc)"]
[null,"Minimum $",null,null,null,null,"Age","Rate ","Monthly Employee Premium","Monthly Employer Premium","Notes"]
[null,"Maximum $"]
[null,"Label"]
[null,"Symbol","$"]
[null,"Evidence of Insurability required for value over"]
[]
[]
[]
[]
[]
[null,"Plan 5",{"$f":"P16","v":0}]
[]
[null,"(Medical Dental, Vision)",null,null,null,null,"Coverage Levels (Life, Supp Life, Spouse Life, GTL, Child Life LTD, STD)"]
[null,"Coverage Name \n(Election) ","Employee Monthly Amount","Employer Monthly Amount","Premium",null,"Coverage Amount",null,"Rounding","Salary as of","Premium Based on Employee or Spouse Age","Employee Premium","Employer Contribution"]
[null,"Family",150,400,{"$f":"C144+D144","v":550},null,"1X Base Salary ",null,"1x salary, round next 1,000","Begin plan year","N/A","N/A",".49 per 1,000 "]
[null,null,null,null,{"$f":"IF(C145=\"\",\"\",C145+D145)","v":""},null,"50% of EE Coverage",null,"Round to down next 1,000","Begin plan year","Spouse Age","Age rate per 1,000","N/A"]
[null,null,null,null,{"$f":"IF(C146=\"\",\"\",C146+D146)","v":""}]
[null,null,null,null,{"$f":"IF(C147=\"\",\"\",C147+D147)","v":""}]
[null,null,null,null,{"$f":"IF(C148=\"\",\"\",C148+D148)","v":""}]
[null,null,null,null,{"$f":"IF(C149=\"\",\"\",C149+D149)","v":""}]
[]
[]
[null,"Use Units  (FSA, HSA, Life Insurance)",null,null,null,null,"Premium Rate Table (Revise columns as needed or use a separate doc)"]
[null,"Minimum $",null,null,null,null,"Age","Rate ","Monthly Employee Premium","Monthly Employer Premium","Notes"]
[null,"Maximum $"]
[null,"Label"]
[null,"Symbol","$"]
[null,"Evidence of Insurability required for value over"]
[]
[]
[]
[]
[]
[null,"Plan 6",{"$f":"R16","v":0}]
[]
[null,"(Medical Dental, Vision)",null,null,null,null,"Coverage Levels (Life, Supp Life, Spouse Life, GTL, Child Life LTD, STD)"]
[null,"Coverage Name \n(Election) ","Employee Monthly Amount","Employer Monthly Amount","Premium",null,"Coverage Amount",null,"Rounding","Salary as of","Premium Based on Employee or Spouse Age","Employee Premium","Employer Contribution"]
[null,"Family",150,400,{"$f":"C167+D167","v":550},null,"1X Base Salary ",null,"1x salary, round next 1,000","Begin plan year","N/A","N/A",".49 per 1,000 "]
[null,null,null,null,{"$f":"IF(C168=\"\",\"\",C168+D168)","v":""},null,"50% of EE Coverage",null,"Round to down next 1,000","Begin plan year","Spouse Age","Age rate per 1,000","N/A"]
[null,null,null,null,{"$f":"IF(C169=\"\",\"\",C169+D169)","v":""}]
[null,null,null,null,{"$f":"IF(C170=\"\",\"\",C170+D170)","v":""}]
[null,null,null,null,{"$f":"IF(C171=\"\",\"\",C171+D171)","v":""}]
[null,null,null,null,{"$f":"IF(C172=\"\",\"\",C172+D172)","v":""}]
[]
[null,"Use Units  (FSA, HSA, Life Insurance)",null,null,null,null,"Premium Rate Table (Revise columns as needed or use a separate doc)"]
[null,"Minimum $",null,null,null,null,"Age","Rate ","Monthly Employee Premium","Monthly Employer Premium","Notes"]
[null,"Maximum $"]
[null,"Label"]
[null,"Symbol","$"]
[null,"Evidence of Insurability required for value over"]
[]
[]
[]
[]
[]
[null,"Plan 7",{"$f":"T16","v":0}]
[]
[null,"(Medical Dental, Vision)",null,null,null,null,"Coverage Levels (Life, Supp Life, Spouse Life, GTL, Child Life LTD, STD)"]
[null,"Coverage Name \n(Election) ","Employee Monthly Amount","Employer Monthly Amount","Premium",null,"Coverage Amount",null,"Rounding","Salary as of","Premium Based on Employee or Spouse Age","Employee Premium","Employer Contribution"]
[null,"Family",150,400,{"$f":"C189+D189","v":550},null,"1X Base Salary ",null,"1x salary, round next 1,000","Begin plan year","N/A","N/A",".49 per 1,000 "]
[null,null,null,null,{"$f":"IF(C190=\"\",\"\",C190+D190)","v":""},null,"50% of EE Coverage",null,"Round to down next 1,000","Begin plan year","Spouse Age","Age rate per 1,000","N/A"]
[null,null,null,null,{"$f":"IF(C191=\"\",\"\",C191+D191)","v":""}]
[null,null,null,null,{"$f":"IF(C192=\"\",\"\",C192+D192)","v":""}]
[null,null,null,null,{"$f":"IF(C193=\"\",\"\",C193+D193)","v":""}]
[null,null,null,null,{"$f":"IF(C194=\"\",\"\",C194+D194)","v":""}]
[]
[null,"Use Units  (FSA, HSA, Life Insurance)",null,null,null,null,"Premium Rate Table (Revise columns as needed or use a separate doc)"]
[null,"Minimum $",null,null,null,null,"Age","Rate ","Monthly Employee Premium","Monthly Employer Premium","Notes"]
[null,"Maximum $"]
[null,"Label"]
[null,"Symbol","$"]
[null,"Evidence of Insurability required for value over"]
[]
[]
[]
[]
[]
[]
[null,"Plan 8",{"$f":"V16","v":0}]
[]
[null,"(Medical Dental, Vision)",null,null,null,null,"Coverage Levels (Life, Supp Life, Spouse Life, GTL, Child Life LTD, STD)"]
[null,"Coverage Name \n(Election) ","Employee Monthly Amount","Employer Monthly Amount","Premium",null,"Coverage Amount",null,"Rounding","Salary as of","Premium Based on Employee or Spouse Age","Employee Premium","Employer Contribution"]
[null,"Family",150,400,{"$f":"C212+D212","v":550},null,"1X Base Salary ",null,"1x salary, round next 1,000","Begin plan year","N/A","N/A",".49 per 1,000 "]
[null,null,null,null,{"$f":"IF(C213=\"\",\"\",C213+D213)","v":""},null,"50% of EE Coverage",null,"Round to down next 1,000","Begin plan year","Spouse Age","Age rate per 1,000","N/A"]
[null,null,null,null,{"$f":"IF(C214=\"\",\"\",C214+D214)","v":""}]
[null,null,null,null,{"$f":"IF(C215=\"\",\"\",C215+D215)","v":""}]
[null,null,null,null,{"$f":"IF(C216=\"\",\"\",C216+D216)","v":""}]
[null,null,null,null,{"$f":"IF(C217=\"\",\"\",C217+D217)","v":""}]
[]
[]
[null,"Use Units  (FSA, HSA, Life Insurance)",null,null,null,null,"Premium Rate Table (Revise columns as needed or use a separate doc)"]
[null,"Minimum $",null,null,null,null,"Age","Rate ","Monthly Employee Premium","Monthly Employer Premium","Notes"]
[null,"Maximum $"]
[null,"Label"]
[null,"Symbol","$"]
[null,"Evidence of Insurability required for value over"]
[]
[]
[]
[]
[]
[null,"Plan 9",{"$f":"X16","v":0}]
[]
[null,"(Medical Dental, Vision)",null,null,null,null,"Coverage Levels (Life, Supp Life, Spouse Life, GTL, Child Life LTD, STD)"]
[null,"Coverage Name \n(Election) ","Employee Monthly Amount","Employer Monthly Amount","Premium",null,"Coverage Amount",null,"Rounding","Salary as of","Premium Based on Employee or Spouse Age","Employee Premium","Employer Contribution"]
[null,"Family",150,400,{"$f":"C235+D235","v":550},null,"1X Base Salary ",null,"1x salary, round next 1,000","Begin plan year","N/A","N/A",".49 per 1,000 "]
[null,null,null,null,{"$f":"IF(C236=\"\",\"\",C236+D236)","v":""},null,"50% of EE Coverage",null,"Round to down next 1,000","Begin plan year","Spouse Age","Age rate per 1,000","N/A"]
[null,null,null,null,{"$f":"IF(C237=\"\",\"\",C237+D237)","v":""}]
[null,null,null,null,{"$f":"IF(C238=\"\",\"\",C238+D238)","v":""}]
[null,null,null,null,{"$f":"IF(C239=\"\",\"\",C239+D239)","v":""}]
[null,null,null,null,{"$f":"IF(C240=\"\",\"\",C240+D240)","v":""}]
[]
[]
[null,"Use Units  (FSA, HSA, Life Insurance)",null,null,null,null,"Premium Rate Table (Revise columns as needed or use a separate doc)"]
[null,"Minimum $",null,null,null,null,"Age","Rate ","Monthly Employee Premium","Monthly Employer Premium","Notes"]
[null,"Maximum $"]
[null,"Label"]
[null,"Symbol","$"]
[null,"Evidence of Insurability required for value over"]
[]
[]
[]
[]
[]
[null,"Plan 10",{"$f":"Z16","v":0}]
[]
[null,"(Medical Dental, Vision)",null,null,null,null,"Coverage Levels (Life, Supp Life, Spouse Life, GTL, Child Life LTD, STD)"]
[null,"Coverage Name \n(Election) ","Employee Monthly Amount","Employer Monthly Amount","Premium",null,"Coverage Amount",null,"Rounding","Salary as of","Premium Based on Employee or Spouse Age","Employee Premium","Employer Contribution"]
[null,"Family",150,400,{"$f":"C258+D258","v":550},null,"1X Base Salary ",null,"1x salary, round next 1,000","Begin plan year","N/A","N/A",".49 per 1,000 "]
[null,null,null,null,{"$f":"IF(C259=\"\",\"\",C259+D259)","v":""},null,"50% of EE Coverage",null,"Round to down next 1,000","Begin plan year","Spouse Age","Age rate per 1,000","N/A"]
[null,null,null,null,{"$f":"IF(C260=\"\",\"\",C260+D260)","v":""}]
[null,null,null,null,{"$f":"IF(C261=\"\",\"\",C261+D261)","v":""}]
[null,null,null,null,{"$f":"IF(C262=\"\",\"\",C262+D262)","v":""}]
[null,null,null,null,{"$f":"IF(C263=\"\",\"\",C263+D263)","v":""}]
[]
[]
[null,"Use Units  (FSA, HSA, Life Insurance)",null,null,null,null,"Premium Rate Table (Revise columns as needed or use a separate doc)"]
[null,"Minimum $",null,null,null,null,"Age","Rate ","Monthly Employee Premium","Monthly Employer Premium","Notes"]
[null,"Maximum $"]
[null,"Label"]
[null,"Symbol","$"]
[null,"Evidence of Insurability required for value over"]

{"sheet":"Jobs","index":9,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,2,26,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[29,1,29,8],[30,1,38,8],[3,1,5,6],[2,1,2,2],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[8,1,9,7]]}
[]
[]
[null,"Jobs "]
[null,"Jobs identify the description of what an employee does in the organisation. A Job has unique assignments like, Employee Type, Pay Grade, Standard Work Day, Workers Compensation Code, Salary Survey & Competencies and is applied to all employees assigned to that job."]
[]
[]
[]
[]
[null,"Job Information - Please provide a complete list of Jobs in either an Excel or comma delimited file or by using the Jobs import template provided by your HR Escape Consultant"]
[]
[]
[null,"Job  Name","Description",null,"Display On Applicant Tracking?","Standard Work Day","Employee Type","Pay Grade","Pay Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Additional Information"]

{"sheet":"Time Off Codes","index":10,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,1,31,6],[32,1,37,6],[38,3,38,4],[39,3,39,4],[27,3,27,4],[27,5,27,6],[28,3,28,4],[28,5,28,6],[29,3,29,4],[30,3,30,4],[24,3,24,4],[24,5,24,6],[25,3,25,4],[25,5,25,6],[26,3,26,4],[26,5,26,6],[21,3,21,4],[21,5,21,6],[22,3,22,4],[22,5,22,6],[23,3,23,4],[23,5,23,6],[18,3,18,4],[18,5,18,6],[19,3,19,4],[19,5,19,6],[20,3,20,4],[20,5,20,6],[15,3,15,4],[15,5,15,6],[16,3,16,4],[16,5,16,6],[17,3,17,4],[17,5,17,6],[12,3,12,4],[12,5,12,6],[13,3,13,4],[13,5,13,6],[14,3,14,4],[14,5,14,6],[9,3,9,4],[9,5,9,6],[10,3,10,4],[10,5,10,6],[11,3,11,4],[11,5,11,6],[7,3,7,4],[7,5,7,6],[8,3,8,4],[8,5,8,6],[3,1,5,5]]}
[]
[]
[null,"Time Off Codes"]
[null,"The system will allow you to track time off for abcence and holidays. You can then use these to allocate the type of holiday or sickness such as unpaid or paid sick. You can then run reports on amounts,and types to monitor balances. Also book partial days or durations. "]
[]
[]
[]
[null,"Time Off Type","External ID","Payroll Code",null,"Duration (full day, half day, hours)"]
[null,"Sick",null,"SICK",null,"Full, Half, Days, Hours"]
[null,"Holiday",null,"HOLPH",null,"Full, Half, Days, Hours"]
[null,"Maternity",null,"MAT",null,"Full, Half, Days, Hours"]
[null,"Paternity",null,"PAT",null,"Full, Half, Days, Hours"]
[null,"Covid",null,"COV",null,"Full, Half, Days, Hours"]
[null,"Unpaid",null,"UNPI",null,"Full, Half, Days, Hours"]
[null,"Doctors Appointments",null,"DOCS",null,"Full, Half, Days, Hours"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Notes"]

{"sheet":"Holiday Tables","index":11,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,1,36,16],[37,1,42,16],[33,2,33,5],[33,6,33,8],[33,9,33,11],[33,12,33,13],[33,14,33,16],[34,2,34,5],[34,6,34,8],[34,9,34,11],[34,12,34,13],[34,14,34,16],[31,2,31,5],[31,6,31,8],[31,9,31,11],[31,12,31,13],[31,14,31,16],[32,2,32,5],[32,6,32,8],[32,9,32,11],[32,12,32,13],[32,14,32,16],[29,2,29,5],[29,6,29,8],[29,9,29,11],[29,12,29,13],[29,14,29,16],[30,2,30,5],[30,6,30,8],[30,9,30,11],[30,12,30,13],[30,14,30,16],[27,2,27,5],[27,6,27,8],[27,9,27,11],[27,12,27,13],[27,14,27,16],[28,2,28,5],[28,6,28,8],[28,9,28,11],[28,12,28,13],[28,14,28,16],[25,2,25,5],[25,6,25,8],[25,9,25,11],[25,12,25,13],[25,14,25,16],[26,2,26,5],[26,6,26,8],[26,9,26,11],[26,12,26,13],[26,14,26,16],[23,2,23,5],[23,6,23,8],[23,9,23,11],[23,12,23,13],[23,14,23,16],[24,2,24,5],[24,6,24,8],[24,9,24,11],[24,12,24,13],[24,14,24,16],[21,2,21,5],[21,6,21,8],[21,9,21,11],[21,12,21,13],[21,14,21,16],[22,2,22,5],[22,6,22,8],[22,9,22,11],[22,12,22,13],[22,14,22,16],[19,2,19,5],[19,6,19,8],[19,9,19,11],[19,12,19,13],[19,14,19,16],[20,2,20,5],[20,6,20,8],[20,9,20,11],[20,12,20,13],[20,14,20,16],[2,1,2,13],[9,1,9,13],[11,1,11,9],[11,10,11,16],[12,1,12,9],[12,10,12,16],[17,14,17,16],[18,2,18,5],[18,6,18,8],[18,9,18,11],[18,12,18,13],[18,14,18,16],[15,1,15,13],[16,1,16,13],[17,2,17,5],[17,6,17,8],[17,9,17,11],[17,12,17,13],[3,1,7,14]]}
[]
[]
[null,"Bank Holidays"]
[null,"Bank Holidays are used in the system to automatically pay employees bank holiday credits or modify the way employees are paid if they work on a bank holiday. For example, if employees automatically receive a bank holiday credit of 8 hours on New Years day then you would need to have a New Years Day bank holiday configured in the system. As another example, if employees receive double-time for working on New Years Day you would need to have a Bank Holiday configured with a date of 1/1/2021. Bank Holidays in conjunction with your pay rules will govern how employees are paid for a specific bank holiday."]
[]
[]
[]
[]
[]
[null,"Bank Holiday Observation Days"]
[]
[null,"If a holiday falls on Saturday what day do you observe it? (e.g. Friday)",null,null,null,null,null,null,null,null,"Friday"]
[null,"If a holiday falls on Sunday what day do you observe it? (e.g. Monday)",null,null,null,null,null,null,null,null,"Monday"]
[]
[]
[null,"Bank Holidays"]
[null,"Enter your holidays, the next observed dates and how many hours are granted per holiday below."]
[null,"Keep/Discard","Holiday Name",null,null,null,"Time Off Type",null,null,"Next Observed Date",null,null,"Hours Granted",null,"Notes"]
[null,"Keep","Good Friday ",null,null,null,"Holiday",null,null,"2021-04-02",null,null,"8:00"]
[null,"Keep","Easter Monday",null,null,null,"Holiday",null,null,"2021-04-05",null,null,"8:00"]
[null,"Keep","May Day",null,null,null,"Holiday",null,null,"2021-05-03",null,null,"8:00"]
[null,"Keep","Spring Bank Holiday",null,null,null,"Holiday",null,null,"2021-05-31",null,null,"8:00"]
[null,"Keep","Summer Bank Holiday ",null,null,null,"Holiday",null,null,"2021-08-30",null,null,"8:00"]
[null,"Keep","Christmas Day",null,null,null,"Holiday",null,null,"2021-12-27",null,null,"8:00"]
[null,"Keep","Boxing Day ",null,null,null,"Holiday ",null,null,"2021-12-28",null,null,"8:00"]
[null,"Keep","New Years Day",null,null,null,"Holiday",null,null,"2022-02-03",null,null,"8.00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Additional Notes"]

{"sheet":"Accrual Policies","index":12,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[[2,1,2,4],[3,1,4,8],[33,1,42,1],[45,1,54,1]]}
[]
[]
[null,"Profile 1 Accrual Policies"]
[null,"The following policies will roll up to the Accrual Profile that was defined on the Accrual Profiles tab. "]
[]
[null,"Policies"]
[null,"Policy Information for the Profile 1 Profile","Example","Policy 1","Policy 2","Policy 3","Policy 4","Policy 5","Policy 6","Policy 7","Policy 8","Policy 9","Policy 10"]
[null,"Policy Name (e.g. Vacation, Sick, Personal, PTO, etc.)","Holidays"]
[null,"System Maintained (The System Maintains Calculations) \n\nUser Maintained (If chosen, only complete Basis and Anchor Date Sections)                                                                      \n\nImported  (If chosen, only complete Basis and Anchor Date sections)","System Maintained"]
[null,"Basis"]
[null,"Tenure Based/Hours Worked","Tenured"]
[null,"If Hours Worked , please list any time off categories/pay categories that are excluded from the calculation?","N/A"]
[null,"Anchor Date"]
[null,"Anchor Date:","Calendar Date"]
[null,"If Calendar/Fiscal Date, please specify date:","2014-01-01"]
[null,"Waiting Period"]
[null,"Please specify if there is a waiting period.","0 days"]
[null,"How do employees accrue time during the waiting period?","Accrue time but cannot use it until the waiting period is over"]
[null,"Carry Over"]
[null,"Do you allow employees to carry over earned accruals?","Yes"]
[null,"What date does carry over get applied on?","2014-01-01"]
[null,"Is there a maximum carry over amount?","Yes"]
[null,"If \"Yes\" how much are they allowed to carry over?","80 hours"]
[null,"Should the carry over amount be moved to a different Time Off?","Yes"]
[null,"If \"Yes\" which Time Off category?","Holiday Carryover"]
[null,"Does the carry over amount have to be used by a certain time? ","No"]
[null,"If \"Yes\", please specify when the carry over amount has to be used by.","N/A"]
[null,"How do you handle negative balances?","Negative Balances are not allowed"]
[null,"When an employee's tenure (length of service) changes in the middle of an accrual period, when are hours credited?","The start of the next accrual period"]
[null,"Additional Notes"]
[null,"Maximums"]
[null,"Is there a Maximum Accrued Amount? (This is the maximum that can be accrued in an accrual year)","No"]
[null,"Is there a Maximum Running Balance? (This is the maximum that an employee can have at any given time)","Yes"]
[null,"Specify Rules for Maximums","Initial: 80 Hours","Initial: __","Initial: __","Initial: __","Initial: __","Initial: __","Initial: __","Initial: __","Initial: __","Initial: __","Initial: __"]
[null,null,"After 3 years: 100 hours","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __"]
[null,null,"After 5 years: 120 hours","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __"]
[null,null,"After 10 years: 140 hours","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __"]
[null,null,"After 15 years: 200 hours","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __"]
[null,null,null,"After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __"]
[null,null,null,"After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __"]
[null,null,null,"After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __"]
[null,null,null,"After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __"]
[null,null,null,"After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __","After __ years: __"]
[null,"Additional Notes on Maximums"]
[null,"Accrual Rate"]
[null,"Please enter the rate of accruing time","Initial: 2 hours per Pay Period","Initial: ","Initial:","Initial:","Initial:","Initial:","Initial:","Initial:","Initial:","Initial:","Initial:"]
[null,null,"After 3 years 2.5 hours per pay period","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours"]
[null,null,"After 5 years 3 hours per pay period","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours"]
[null,null,"After 10 years 5 hours per pay period","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours"]
[null,null,"After 15 years 7 hours per pay period","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours"]
[null,null,null,"After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours"]
[null,null,null,"After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours"]
[null,null,null,"After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours"]
[null,null,null,"After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours"]
[null,null,null,"After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours","After __ years: __ hours"]
[null,"Additional Notes on the calculations"]
[null,"Accrual Schedule"]
[null,"Accrual Schedule:","Pay Period"]

{"sheet":"Accrual Setings","index":13,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,1,12,6],[16,1,16,12],[17,1,26,12],[10,1,10,6],[10,7,10,8],[10,9,10,12],[11,1,11,6],[11,7,11,8],[11,9,11,12],[13,1,13,6],[13,9,13,12],[12,9,12,12],[2,1,2,4],[8,1,8,6],[8,7,8,8],[8,9,8,12],[9,1,9,6],[9,7,9,8],[9,9,9,12],[6,1,6,12],[7,1,7,6],[7,7,7,8],[7,9,7,12],[3,1,4,11]]}
[]
[]
[null,"Accrual Global Settings"]
[null,"The following are global values that will pertain to all aspects of your Accrual configuration. These are not policy based settings, but rather global. Please review the setting and select the value and enter notes for each section.  "]
[]
[]
[null,"Global Settings"]
[null,"Setting",null,null,null,null,null,"Values",null,"Notes/Additional Options"]
[null,"Display Accrual Values in Days"]
[null,"Number of Decimals to track for Days?"]
[null,"Changes to Accrual Balances Require a Comment?"]
[null,"Upon rehire, should an employee’s remaining balance from their previous tenure be deleted?"]
[null,"Disclaimer to show on balances:"]
[null,"Time Off Planning"]
[]
[]
[null,"Additional Notes"]

{"sheet":"Pay Grades","index":14,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[12,1,13,6],[42,1,50,6],[41,1,41,6],[2,1,2,5],[10,1,10,2],[10,3,10,5],[9,3,9,5],[9,1,9,2],[3,1,6,5]]}
[]
[]
[null,"Pay Grades "]
[null,"Pay Grades are used to define the minimum and maximum pay or salary ranges with an automated mid point calculation. Pay Grades can further break down into steps to increment pay increases and, or, tied to location factors. Pay Grades can be assigned to either the employee or jobs. Pay Grades are used and referenced in HR Action Requests, Performance Reviews and Compensation Management. "]
[]
[]
[]
[]
[null,"Pay Grade Violation"]
[null,"What message do you want to display for a Pay Grade violation?"]
[null,"Are Pay Grades tied to a locations?"]
[]
[null,"Pay Grade Information - Please provide a complete list of pay grades and applicable step in grade tables in either an Excel or comma delimited file or by using the Pay Grades import template provided by your Kronos Consultant"]
[]
[]
[null,"Code","Pay Grade","Rate By","Minimum","Maximum","Steps within this Pay Grade? (provide separate document)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Additional Information"]

{"sheet":"Positions","index":15,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[27,2,27,3],[28,2,28,3],[15,2,15,3],[16,2,16,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[23,2,23,3],[4,1,5,5],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[17,2,17,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3]]}
[]
[]
[null,"Positions"]
[]
[null,"Job Information - Please provide a complete list of Jobs in either an Excel or comma delimited file or by using the Jobs import template provided by your HR Escape Consultant"]
[]
[]
[null,"Position Name","Default Job",null,"Effective From","Description","Pay Grade"]

{"sheet":"Disability","index":16,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,1,5,4],[2,1,2,4]]}
[]
[]
[null,"Disability Types "]
[null,"Disability Types can be tracked and assigned to emloyees. Reporting is available on employee current and historic disabilities.                            Define the Disability Types- Name, Restrictions and Descriptions."]
[]
[]
[null,"Disability Type Information"]
[null,"Name","Restrictions","Descriptions","Notes"]
[null,"Back Injury","Cannot lift over 10lbs\nNo prolonged periods of standing ","Add additional information "]

{"sheet":"License _Credentials","index":17,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,1,31,1],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[13,1,13,2],[17,1,17,2],[18,1,18,2],[35,1,42,10],[34,1,34,10],[3,1,5,10],[2,1,2,6],[7,1,7,3],[22,1,23,1],[24,1,25,1],[12,1,12,2],[26,1,27,1],[28,1,29,1],[19,1,19,2],[20,1,20,2],[21,1,21,2],[14,1,14,2],[15,1,15,2],[16,1,16,2]]}
[]
[]
[null,"Licenses and Credentials"]
[null,"This feature allows you to assign employee credentials (Driver’s License, Passports, Permanent Resident Cards, etc) to their profiles. Within each credential you can input the credential’s class, issue date, expiration date, restrictions, county, country, place of birth, nationality and type. To go along with all the options already listed, 5 custom labels can be created to collect information related to the credential. Email notifications can also be set up to notify concerning parties of when the credential expires."]
[]
[]
[]
[null,"License/Credential Information"]
[null,"License/Credential Type",null,"License/Credential Type 1","License/Credential Type 2","License/Credential Type 3","License/Credential Type 4","License/Credential Type 5","License/Credential Type 6","License/Credential Type 7","License/Credential Type 8","License/Credential Type 9","License/Credential Type 10","License/Credential Type 11","License/Credential Type 12"]
[null,"Type"]
[null,"Description"]
[null,"Mask on Reports?"]
[null,"Who is notified when credential expires?"]
[null,"Issued"]
[null,"Expires"]
[null,"Class"]
[null,"Restrictions"]
[null,"County"]
[null,"Country"]
[null,"Place of Birth"]
[null,"Nationality"]
[null,"Type"]
[null,"Custom 1","Label"]
[]
[null,"Custom 2","Label"]
[]
[null,"Custom 3","Label"]
[]
[null,"Custom 4","Label"]
[]
[null,"Custom 5","Lablel"]
[]
[]
[]
[null,"Additional License & Credential Notes"]

{"sheet":"Assets","index":18,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[29,1,29,2],[18,3,18,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[26,1,26,2],[27,1,27,2],[28,1,28,2],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[3,1,3,11],[10,1,10,11],[11,1,17,11],[4,1,8,9],[42,3,42,4],[43,1,43,2],[43,3,43,4],[29,3,29,4],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[31,1,31,3],[23,3,23,4],[32,1,35,11],[24,3,24,4],[37,1,37,4],[49,1,57,5],[48,1,48,5],[44,1,44,2],[44,3,44,4],[45,1,45,2],[45,3,45,4],[46,1,46,2],[46,3,46,4],[39,1,39,2],[39,3,39,4],[40,1,40,2],[40,3,40,4],[41,1,41,2],[41,3,41,4],[42,1,42,2]]}
[]
[]
[null,"Assets"]
[null,"Asset Types"]
[null,"An Asset Type describes the data to be collected as pertains to a specific Asset.\n• Upon adding a new Asset Type the settings will allow for Multi Assets (there can be more than one of the item, it isn't unique) and also allow Child Assets (a component asset such as Software to a Laptop) \n• Using Fields, the company will be able to define which fields of data to collect / require. The Asset Type can be tied out to Cost Centre / Jobs and there are 5 custom fields that can be defined as well."]
[]
[]
[]
[]
[]
[null,"Asset (Property)"]
[null,"This feature allows you to configure the Asset List and to track the history of employee usage of the Asset. An Asset can be signed out by more than one account, and documents and notes can be attached to the Asset.\n• From the predefined Asset Types, you can designate which ones you want to establish as property.  \n• This feature allows you to track the following descriptive features of the property:  ID, Name, Category, Current Status, Description, Whether it is a multi-asset, Whether it can be assigned to more than one account, Language, License Expiration Date, License Information, Publisher, Purchase Date, Purchased Price, Serial #, Version and Year.  \n• Once set up to your specifications, you can assign the property to employee, include further detailed information about their specific item, and record when they return the Asset and if it was Lost/Destroyed.\n"]
[]
[]
[]
[]
[]
[]
[null,"Asset Type ",null,"Property",null,"Attach to specific job?"]
[null,"Electronics",null,"Tablets ",null,"Manager Jobs "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Asset (Vehicles)"]
[null,"Vehicles can be defined as personal at the Employee Information Record or Company owned and accounted for here.\n• If the vehicle is a Company Asset, the Status, Code, Year, VIN, Make, Model, Color, License State/Plate, as well as Date information for Registration/Expiration can be tracked.\n• Documents can be uploaded as well as the ability to track Insurance/Maintenance on the vehicle.\n• As with all Assets, in this screen you can see who the Vehicle is assigned to and Assign/Return form this screen as well. "]
[]
[]
[]
[]
[null,"Will you track Company Vehicles?"]
[]
[null,"Types of Vehicles",null,"Who will vehicle will be assigned to?",null,"Will you upload documents for Vehicle Asset?"]
[null,"Cars",null,"Sales Staff",null,"Yes"]
[]
[]
[]
[]
[]
[]
[]
[null,"Additional Assets Notes"]

{"sheet":"Education","index":19,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":false,"merged":[[18,4,18,7],[19,4,19,7],[20,4,20,7],[21,4,21,7],[12,4,12,7],[13,4,13,7],[14,4,14,7],[15,4,15,7],[16,4,16,7],[17,4,17,7],[13,1,13,3],[14,1,14,3],[9,1,9,3],[25,1,25,3],[12,1,12,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[15,1,15,3],[11,1,11,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[22,4,22,7],[23,4,23,7],[24,4,24,7],[33,1,33,3],[34,1,34,3],[33,4,33,7],[34,4,34,7],[25,4,25,7],[26,4,26,7],[28,1,28,11],[26,1,26,3],[32,1,32,11],[29,1,30,9],[35,1,35,3],[41,4,41,7],[38,1,38,3],[39,1,39,3],[40,1,40,3],[36,4,36,7],[37,4,37,7],[36,1,36,3],[37,1,37,3],[35,4,35,7],[41,1,41,3],[42,1,42,3],[43,1,43,3],[38,4,38,7],[39,4,39,7],[40,4,40,7],[44,1,44,3],[45,1,45,3],[46,1,46,3],[42,4,42,7],[43,4,43,7],[51,1,51,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[51,4,51,7],[47,4,47,7],[48,4,48,7],[49,4,49,7],[50,4,50,7],[56,1,56,10],[57,1,63,10],[2,1,2,6],[7,4,7,7],[8,4,8,7],[9,4,9,7],[10,4,10,7],[10,1,10,3],[6,1,6,11],[7,1,7,3],[8,1,8,3],[3,1,4,9],[44,4,44,7],[45,4,45,7],[46,4,46,7],[50,1,50,3],[52,1,52,3],[53,1,53,3],[52,4,52,7],[53,4,53,7],[54,4,54,7],[54,1,54,3]]}
[]
[]
[null,"Education "]
[null,"Education Levels: This step allows you to build out and track levels of education for an employee, such as University Graduate, College Graduate, Technical School Certification, etc. The options below are the defaults and you may add to them if needed."]
[]
[]
[null,"Education"]
[null,"Standard - Additional",null,null,"Education Level"]
[null,"Standard",null,null,"Not Specified"]
[null,"Standard",null,null,"None"]
[null,"Standard",null,null,"GCSE"]
[null,"Standard",null,null,"A-Level"]
[null,"Standard",null,null,"Technical Diploma"]
[null,"Standard",null,null,"Associates Degree"]
[null,"Standard",null,null,"Non-Degree Program"]
[null,"Standard",null,null,"Bachelor’s Degree"]
[null,"Standard",null,null,"Master’s Degree"]
[null,"Standard",null,null,"Doctorate Degree"]
[null,"Standard",null,null,"Other"]
[null,"Additional"]
[null,"Additional"]
[null,"Additional"]
[null,"Additional"]
[null,"Additional"]
[null,"Additional"]
[null,"Additional"]
[null,"Additional"]
[]
[null,"Degree Types"]
[null,"Degree Type: This list can be added to and/or edited for the purpose of identifying an employee's completed education.            The options below are the defaults and you may add to them if needed."]
[]
[]
[null,"Degree Types"]
[null,"Standard - Additional",null,null,"Education Level"]
[null,"Standard",null,null,"A.A.S. Associate of Applied Science"]
[null,"Standard",null,null,"A.A.  Associate of Arts"]
[null,"Standard",null,null,"A.S. Associate of Science"]
[null,"Standard",null,null,"B.A. Bachelor of Arts"]
[null,"Standard",null,null,"B.S. Bachelor of Science"]
[null,"Standard",null,null,"Ed.D. Doctor of Education"]
[null,"Standard",null,null,"M.D. Doctor of Medicine"]
[null,"Standard",null,null,"Ph. D. Doctor of Philosophy"]
[null,"Standard",null,null,"GED General Equivalency Diploma"]
[null,"Standard",null,null,"G.R.E. Graduate Record Exam"]
[null,"Standard",null,null,"H.S. High School"]
[null,"Standard",null,null,"J.D. Juris Doctor"]
[null,"Standard",null,null,"M.A. Master of Arts"]
[null,"Standard",null,null,"M.B.A. Master of Business Administration"]
[null,"Standard",null,null,"M.Ed. Master of Education"]
[null,"Standard",null,null,"M.S. Master of Science"]
[]
[]
[]
[]
[]
[]
[null,"Additional Education Notes"]

{"sheet":"Training","index":20,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[6,4,6,7],[7,4,7,7],[6,1,6,3],[5,1,5,6],[7,1,7,3],[45,1,45,5],[8,4,8,7],[9,4,9,7],[10,4,10,7],[22,1,22,6],[22,7,22,12],[8,1,8,3],[9,1,9,3],[10,1,10,3],[12,1,12,9],[36,1,36,5],[32,1,34,12],[2,1,2,7],[49,1,49,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[3,1,4,12],[48,1,48,5],[46,1,46,5],[47,1,47,5],[24,1,29,11],[23,1,23,11],[44,1,44,5]]}
[]
[]
[null,"Training"]
[null,"Training/Certifications: This feature allows you to configure all Courses / Sessions for Training / Certification Activity"]
[]
[null,"Training Types"]
[null,"The Training/Certificate name",null,null,"CEU’s"]
[null,"Detailed descriptions",null,null,"Deduction correlation"]
[null,"The company cost",null,null,"Vendor payment’s"]
[null,"The employee cost",null,null,"Renewal Terms"]
[null,"Whether the source is internal, external, or self study"]
[]
[null,"Course/Certification (provide separate spreadsheet/document for additional courses)"]
[null,null,"Course 1 ","Course 2","Course 3","Course 4","Course 5","Course 6","Course 7","Course 8","Course 9","Course 10","Course 11","Course 12"]
[null,"Code"]
[null,"Training/Certificatoon"]
[null,"Description"]
[null,"Source"]
[null,"Company Cost"]
[null,"Employee Cost"]
[null,"CEU's (Credits)"]
[null,"How often to Renew?"]
[]
[null,"Additional Training Notes"]
[]
[]
[]
[]
[]
[]
[]
[null,"Training Profiles"]
[null,"Training Profiles: Multiple Training Profiles can be configured to account for the varying needs of the entire workforce. A Training Profile will be assigned to the employee, and should include all Courses / Certifications that apply to that particular employee or a group of employees as pertains to their role(s) in the organisation.Training Profiles control the training requirement of the employee"]
[]
[]
[]
[null,"Training Profiles"]

{"sheet":"Recruitment","index":21,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[[35,5,35,6],[33,1,33,11],[42,2,42,4],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[39,2,39,4],[40,2,40,4],[41,2,41,4],[19,6,19,7],[20,6,20,7],[58,5,58,6],[59,5,59,6],[62,7,62,11],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[59,2,59,4],[42,5,42,6],[62,2,62,4],[62,5,62,6],[60,7,60,11],[61,7,61,11],[46,1,46,11],[47,1,52,11],[23,1,23,11],[37,2,37,4],[44,5,44,6],[34,2,34,4],[36,2,36,4],[34,5,34,6],[36,5,36,6],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[17,6,17,7],[18,6,18,7],[10,6,10,7],[12,6,12,7],[13,6,13,7],[55,1,55,11],[60,2,60,4],[60,5,60,6],[70,1,78,11],[66,2,66,4],[66,5,66,6],[67,2,67,4],[67,5,67,6],[69,1,69,11],[66,7,66,11],[67,7,67,11],[63,7,63,11],[64,7,64,11],[65,7,65,11],[63,2,63,4],[63,5,63,6],[64,2,64,4],[64,5,64,6],[65,2,65,4],[65,5,65,6],[61,2,61,4],[61,5,61,6],[57,2,57,4],[57,5,57,6],[44,2,44,4],[13,4,13,5],[14,4,14,5],[14,2,14,3],[15,2,15,3],[16,2,16,3],[16,4,16,5],[15,4,15,5],[35,2,35,4],[22,1,22,11],[14,6,14,7],[15,6,15,7],[16,6,16,7],[38,2,38,4],[20,2,20,3],[57,7,57,11],[58,7,58,11],[59,7,59,11],[58,2,58,4],[54,1,54,11],[3,1,5,10],[2,1,2,8],[43,2,43,4],[43,5,43,6],[6,1,6,11],[24,1,30,11],[32,1,32,11],[10,2,10,3],[11,4,11,5],[11,6,11,7],[11,2,11,3],[12,2,12,3],[13,2,13,3],[7,1,7,11],[8,1,8,11],[17,2,17,3],[18,2,18,3],[19,2,19,3],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[10,4,10,5],[12,4,12,5]]}
[]
[]
[null,"Applicant Tracking/ Recruitment "]
[null,"With Applicant Tracking/ Recruitment you can create and post job requisitions. Applicants can apply online and upload CV (if document storage is in use). Managers and Recruiters can utlise dashboards to provide visiblity and access to recruiting and hiring information, job requisitions, applicant pools. "]
[]
[]
[]
[null,"Job Requisitions"]
[null,"Define your current Job Requisitions by name and the associated attributes such as Manager(s). (Provide sample Job Requisitions)"]
[]
[null,"Posting Type","Job",null,"Job Title",null,"Employee Type",null,"Location","Manager",null,"Do you want an Applicant Questionaire?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Describe your Job Requisition Process"]
[null,"Job Requisition Process"]
[null,"Add Notes"]
[]
[]
[]
[]
[]
[]
[]
[null,"Hiring Stages"]
[null,"By default Applicant Tracking/ Recruitment comes with 10 Hiring stages"]
[null,"Stage","Default",null,null,"Your Hiring Stages"]
[null,1,"CV Received"]
[null,2,"Screen Candidate"]
[null,3,"Interview Candidate"]
[null,4,"Candidate not A Fit"]
[null,5,"Extend Offer"]
[null,6,"Offer Declined"]
[null,7,"Offer Accepted"]
[null,8,"Perform Background Checks"]
[null,9,"OnBoarding"]
[null,10,"Hired"]
[]
[null,"Hiring Stages Notes"]
[]
[]
[]
[]
[]
[]
[]
[null,"Communication Templates"]
[null,"Email templates used to create emails to send to applicants in the recruitment process. (provide sample emails)"]
[]
[null,"Template Name","Recipients",null,null,"Subject ",null,"Message "]
[null,"Application Received","Applicant, CC: HR Dept",null,null,"Application Received",null,"Thank you for applying for (job title). Your application is currently under review and will contact you should we need you to come in for an interview.  Thank you, HR Dept. "]
[null,"Rejection letter","Applicant, CC: HR Dept",null,null,"Thank you for Applying ",null,"Thank you for applying for (job title). This job has been filled at this time. We will keep your resume on file for 6 months should another job becomes available.  Thank you for your interest in our Company.   Sincerely,  HR Dept"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Communication Template Notes"]

{"sheet":"Recruitment Questions","index":22,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,1,15,8],[16,1,16,8],[17,1,17,8],[5,1,5,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[14,1,14,8]]}
[]
[]
[null,"General Questions "]
[null,"Please answer the following questions related related to your companies practices around recruitment."]
[]
[null,"Question",null,null,null,null,null,null,null,"Answer"]
[null,"Does your organisation have an internal application process?"]
[null,"Does your organisation have an external application process?"]
[null,"Do you have a questionnaire that an applicant needs to complete prior to submitting their job application?"]
[null,"Do you have a recruitment evalutation that can be assigned to an applicants job application to determine if they can move forward in the consideration process?"]
[null,"Will there be a separate application process for each type of employee?\nExample: Separate application process for seasonal employees vs. full- time and part-time employees"]
[null,"Do you need to have applicants e-sign a document as part of their application process?"]
[null,"Do applicants need to complete a checklist as part of their application process?"]
[null,"Do you wish to use Quick Apply feature/functionality?\nChecking this setting will allow applicants to apply for jobs via a one-page application using minimal information. Applicants will not be required to create an applicant profile."]
[null,"Do you have any templates for communications with applicants?"]
[null,"Do you have any offer letter templates?"]
[null,"Do you need Career portal?"]
[null,"Do you need Indeed integration?"]

{"sheet":"Recruitment Workflows","index":23,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[51,1,66,8],[4,1,4,2],[48,1,50,2],[25,1,25,2],[47,1,47,2],[5,1,7,2],[26,1,28,2],[8,1,21,6],[46,1,46,8],[29,1,43,8]]}
[]
[]
[null,"Recruitment Workflows"]
[]
[null,"NAME:",null,"STEP 1","STEP 2","STEP 3","STEP 4"]
[null,"Hiring Stage Change Default Workflow",null,"Start","Approve/Reject (Approved)","End"]
[null,null,null,null,"Approve/Reject (Rejected)","Approve/Reject (Modified)","Loop Back to Step 2"]
[null,null,null,null,null,"Approve/Reject (Rejected)","End"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NAME:",null,"STEP 1","STEP 2","STEP 3","STEP 4","STEP 5","STEP 6"]
[null,"Job Requisition Default Workflow",null,"Start","Generate Notification (Requested) (Head of Department)","Approve/Reject (Manager Approval) (Approved) (Head of Department)","Generate Notification (Approved)","End"]
[null,null,null,null,null,"Approve/Reject (Manager Approval) (Rejected)","Generate Notification (Rejected)","Approve/Reject (Requester Action) (Modified) - HR Admin Group","Loop Back to Step 2"]
[null,null,null,null,null,null,null,"Approve/Reject (Requester Action) (Rejected)","End"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NAME:",null,"STEP 1","STEP 2","STEP 3","STEP 4","STEP 5","STEP 6"]
[null,"Offer Letter Default Workflow",null,"Start","Generate Notification (Requested)","Approve/Reject (Manager Approval) (Approved)","Generate Notification (Approved)","End"]
[null,null,null,null,null,"Approve/Reject (Manager Approval) (Rejected)","Generate Notification (Rejected)","Approve/Reject (Requester Action) (Modified)","Loop Back to Step 2"]
[null,null,null,null,null,null,null,"Approve/Reject (Requester Action) (Rejected)","End"]

{"sheet":"Incidents","index":24,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,1,2,6],[30,1,30,9],[31,1,37,9],[3,1,5,10]]}
[]
[]
[null,"Incidents"]
[null,"This feature allows you to track anything you would consider a workplace incidient. You have the option to apply resolutions to the incident and violations based on the incident.    Incidents can be attached to a specific employee. "]
[]
[]
[null,"Incident Types"]
[null,null,"Incident Type 1 ","Incident Type 2","Incident Type 3","Incident Type 4","Incident Type 5","Incident Type 6","Incident Type 7","Incident Type 8","Incident Type 9","Incident Type 10","Incident Type 11","Incident Type 12"]
[null,"Incident Type Name"]
[null,"Description"]
[null,"Incident Visible- Who?"]
[null,"Comments Visible- Who?"]
[null,"Comments Editable- Who?"]
[null,"Comments Anonymity- Who?"]
[null,"Check the options you want this Indicdent type to be included?\n"]
[null,"Report Settings"]
[]
[null,"Resolutions"]
[null,null,"Resolution 1","Resolution 2","Resolution 3","Resolution 4","Resolution 5","Resolution 6","Resolution 7","Resolution 8","Resolution 9","Resolution 10","Resolution 11","Resolution 12"]
[null,"Name "]
[null,"Code "]
[null,"Description "]
[]
[null,"Violations"]
[null,null,"Violation 1","Violation 2","Violation 3","Violation 4","Violation 5","Violation 6","Violation 7","Violation 8","Violation 9","Violation 10","Violation 11","Violation 12"]
[null,"Name"]
[null,"Code"]
[null,"Description"]
[]
[]
[null,"Additional Incidents Notes"]

{"sheet":"Performance Review","index":25,"n_rows":88,"n_cols":7,"rows_kept":88,"cut":false,"hidden":false,"merged":[[58,2,58,3],[69,2,69,3],[57,2,57,3],[68,2,68,3],[54,2,54,3],[55,2,55,3],[65,2,65,3],[3,1,4,5],[30,1,30,5],[31,1,35,5],[59,2,59,3],[60,2,60,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[23,2,23,3],[24,2,24,3],[21,2,21,3],[25,2,25,3],[6,1,6,3],[16,1,16,3],[17,1,17,3],[26,2,26,3],[22,2,22,3],[87,1,87,5],[88,1,96,5],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[66,2,66,3],[52,2,52,3],[53,2,53,3],[61,2,61,3],[67,2,67,3],[74,2,74,3],[27,2,27,3],[28,2,28,3],[56,2,56,3]]}
[]
[]
[null,"Performance Reviews  "]
[null,"Performance Reviews allows you to create, assign and complete reviews based on defined criteria. Performance Reviews contain many components: Review Profiles, Competencies, Core Values, Goals and Ratings. "]
[]
[]
[null,"Performance Review Information"]
[null,null,"Example","Performance Review 1","Performance Review 2","Performance Review 3","Performance Review 4"]
[null,"What are your different Performance Reviews?","Annual Review "]
[null,"Frequency of Review? ","Annual"]
[null,"Date Performance Review frequency looks back to?","Started Date"]
[null,"Date Performance Review should begin?","Started Date"]
[null,"When Performance Review Ends?","3 weeks from Started Date"]
[null,"Performance Review Reason ","Annual Review "]
[]
[]
[null,"Performance Review Process"]
[null,"Define the steps in the Performance Review process"]
[null,"Step","Process"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[]
[null,"Additional Performance Review Process Notes"]
[]
[]
[]
[]
[]
[]
[null,"Competencies"]
[null,"List Company Competencies and associated skills to be assigned. Job related Compentencies should be assigned to the job itself. "]
[null,"Competency","Description ","Skills"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Core Values"]
[null,"Define Compay Core Values to be evaluated in Performance Reviews"]
[null,"Core Value","Description "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Performance Goals"]
[null,"Define employee and company goals "]
[null,"Goal ","Description"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Review Rating"]
[]
[null,"Rating","Rating 1","Rating 2","Rating 3","Rating 4","Rating 5"]
[null,"Rating Name"]
[null,"Display Order"]
[null,"Value "]
[null,"Will this rating be used for the Final Grade?"]
[null,"Will this rating be used for Competencies?"]
[null,"Will this rating be used for Core Values?"]
[null,"Will this rating be used for Goals?"]
[]
[null,"Additional Performance Review Notes"]

{"sheet":"Imports","index":26,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,12,12],[13,1,22,12],[5,1,11,12],[3,1,4,10]]}
[]
[]
[null,"Imports"]
[null,"The following information may be needed in order to complete your HR set up. Templates will be provided by your Payescape representative."]
[]
[null,"\n• Pay Grades\n• Jobs\n• Employee Demographic Data\n• Employee Termination Reason\n• Employee Contacts (Dependents/Emergency/Beneficiary)\n• Employee Benefits"]
[]
[]
[]
[]
[]
[]
[null,"Additional Notes"]
[null,"1.\tAssets\n2.\tPay Grades\n3.\tBenefit plans\n4.\tEducation\n5.\tIncidents\n6.\tPerformance review\n7.\tPositions\n8.\tTermination reasons\n9.\tTraining\n"]

{"sheet":"Sign Off","index":27,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,11],[3,1,4,9],[6,5,10,5],[15,9,17,9],[21,1,21,11],[22,1,31,11],[6,1,10,1],[6,9,12,9],[15,1,16,1],[15,5,18,5]]}
[]
[]
[null,"Module sign off"]
[null,"Below is an overview of modules within the system indicating the stages of implementation that have been completed"]
[]
[]
[null,null,"Core (2.1)",null,null,null,"Timesheets (2.2)",null,null,null,"HR (2.3)"]
[null,null,"Cost Centres",null,null,null,"Time Off Codes",null,null,null,"Pay Grades"]
[null,null,"Manager Permissions",null,null,null,"Holiday Tables",null,null,null,"Positions"]
[null,null,"HR Settings",null,null,null,"Accrual Policies",null,null,null,"Disabilty"]
[null,null,"Jobs",null,null,null,"Accrual Settings",null,null,null,"License Credentials"]
[null,null,null,null,null,null,null,null,null,null,"Assets"]
[null,null,null,null,null,null,null,null,null,null,"Education"]
[]
[]
[null,null,"Training & Certifications (2.4)",null,null,null,"Recruitment (2.5)",null,null,null,"Incidents & Performance (2.6)"]
[null,null,"Training ",null,null,null,"Recruitment",null,null,null,"Incidents"]
[null,null,null,null,null,null,"Recruitment Questions",null,null,null,"Performance Review"]
[null,null,null,null,null,null,"Recruitment Workflows"]
[]
[]
[null,"Additional Notes"]

{"sheet":"DesignStageBO","index":28,"n_rows":188,"n_cols":6,"rows_kept":188,"cut":false,"hidden":true,"merged":[[181,1,184,4],[187,2,187,3],[66,1,67,4],[65,1,65,4],[92,1,92,5],[93,1,95,5],[165,4,165,5],[166,4,166,5],[168,1,168,5],[169,1,176,5],[159,4,159,5],[160,4,160,5],[161,4,161,5],[150,1,150,4],[120,1,120,4],[121,1,122,4],[135,1,135,4],[136,1,136,5],[133,1,133,5],[134,1,134,5],[162,4,162,5],[163,4,163,5],[164,4,164,5],[151,1,152,4],[154,1,154,5],[156,4,156,5],[157,4,157,5],[158,4,158,5],[62,1,63,4],[52,1,56,1],[52,3,52,5],[53,3,53,5],[54,3,54,5],[55,3,55,5],[56,3,56,5],[57,1,57,2],[57,3,57,5],[58,1,58,2],[58,3,58,5],[61,1,61,4],[51,1,51,4],[6,1,14,6],[22,1,22,3],[23,1,28,4],[33,1,36,4],[50,1,50,5]]}
[]
[]
[]
[]
[]
[]
[null,"Kronos Workforce Ready HR Core Foundation \nSolution Design- Benefits"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Prepared for ",{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[]
[]
[]
[null,"Document Overview"]
[null,"The purpose of this document is to outline the Workforce Ready HR Core Foundation Solution Design from the basis of your business processes, information gathered, and decisions made during the Discovery Assessment meetings.  It defines key compoenents to sucessfully implement the Workforce Ready HR Core Foundation, including product processes, company goals and data exchange requirements.  Following the acceptance of the Workforce HR Core Foundation Solution Design, any requirements not detailed within this document will be subject to project change control procedures and planned in the next phase of the implemenation. It is important that you review each section and then sign and return this document to your Kronos consultant.  If you have any questions please reach out to your Kronos consultant."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Benefits Overview"]
[null,"Benefits are apart of the core foundation of Workforce Ready HR. You can track benefit plan information such as eligibility, level of coverage and premium amounts for various employee provided benefits (health, dental, life insurance, etc.) This helps in reporting information to the benefit carriers and the ability to make changes globally for employees when premium amounts change. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Customer Goals"]
[]
[null,"What are your goals for the implemenation?",1,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,null,2,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,null,3,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,null,4,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,null,5,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,"What are your expectations during the implementation?",null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,"What is the criteria that you will use to measure success for this implementation?",null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[]
[]
[null,"Solution Design Details"]
[null,"The following details your solution design per the specifications gathered during your Discovery meetings with your Kronos consultant.  Please review each section carefully and reach out to your consultant if you have any questions."]
[]
[]
[null,"Earnings"]
[null,"The following earnings will be configured to be used with your benefit plans"]
[]
[]
[null,"Earning Information"]
[]
[null,"Name","Code/Abbreviation","Description","EIN"]
[null,{"$f":"IFERROR(IF(Earnings!B10=\"\",\"\", Earnings!B10),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C10=\"\",\"\", Earnings!C10),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D10=\"\",\"\", Earnings!D10),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E10=\"\",\"\", Earnings!E10),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B11=\"\",\"\", Earnings!B11),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C11=\"\",\"\", Earnings!C11),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D11=\"\",\"\", Earnings!D11),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E11=\"\",\"\", Earnings!E11),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B12=\"\",\"\", Earnings!B12),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C12=\"\",\"\", Earnings!C12),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D12=\"\",\"\", Earnings!D12),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E12=\"\",\"\", Earnings!E12),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B13=\"\",\"\", Earnings!B13),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C13=\"\",\"\", Earnings!C13),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D13=\"\",\"\", Earnings!D13),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E13=\"\",\"\", Earnings!E13),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B14=\"\",\"\", Earnings!B14),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C14=\"\",\"\", Earnings!C14),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D14=\"\",\"\", Earnings!D14),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E14=\"\",\"\", Earnings!E14),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B15=\"\",\"\", Earnings!B15),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C15=\"\",\"\", Earnings!C15),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D15=\"\",\"\", Earnings!D15),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E15=\"\",\"\", Earnings!E15),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B16=\"\",\"\", Earnings!B16),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C16=\"\",\"\", Earnings!C16),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D16=\"\",\"\", Earnings!D16),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E16=\"\",\"\", Earnings!E16),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B17=\"\",\"\", Earnings!B17),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C17=\"\",\"\", Earnings!C17),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D17=\"\",\"\", Earnings!D17),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E17=\"\",\"\", Earnings!E17),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B18=\"\",\"\", Earnings!B18),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C18=\"\",\"\", Earnings!C18),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D18=\"\",\"\", Earnings!D18),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E18=\"\",\"\", Earnings!E18),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B19=\"\",\"\", Earnings!B19),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C19=\"\",\"\", Earnings!C19),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D19=\"\",\"\", Earnings!D19),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E19=\"\",\"\", Earnings!E19),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B20=\"\",\"\", Earnings!B20),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C20=\"\",\"\", Earnings!C20),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D20=\"\",\"\", Earnings!D20),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E20=\"\",\"\", Earnings!E20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B21=\"\",\"\", Earnings!B21),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C21=\"\",\"\", Earnings!C21),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D21=\"\",\"\", Earnings!D21),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E21=\"\",\"\", Earnings!E21),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B22=\"\",\"\", Earnings!B22),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C22=\"\",\"\", Earnings!C22),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D22=\"\",\"\", Earnings!D22),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E22=\"\",\"\", Earnings!E22),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B23=\"\",\"\", Earnings!B23),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C23=\"\",\"\", Earnings!C23),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D23=\"\",\"\", Earnings!D23),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E23=\"\",\"\", Earnings!E23),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B24=\"\",\"\", Earnings!B24),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C24=\"\",\"\", Earnings!C24),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D24=\"\",\"\", Earnings!D24),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E24=\"\",\"\", Earnings!E24),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B25=\"\",\"\", Earnings!B25),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C25=\"\",\"\", Earnings!C25),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D25=\"\",\"\", Earnings!D25),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E25=\"\",\"\", Earnings!E25),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B26=\"\",\"\", Earnings!B26),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C26=\"\",\"\", Earnings!C26),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D26=\"\",\"\", Earnings!D26),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E26=\"\",\"\", Earnings!E26),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Earnings!B27=\"\",\"\", Earnings!B27),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!C27=\"\",\"\", Earnings!C27),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!D27=\"\",\"\", Earnings!D27),\"\")","v":""},{"$f":"IFERROR(IF(Earnings!E27=\"\",\"\", Earnings!E27),\"\")","v":""}]
[]
[]
[null,"Deductions"]
[null,"The following deductions will be configured and used with your benefit plans. "]
[]
[]
[null,"Deduction Information"]
[]
[null,"Name","Code/Abbreviation","Description","EIN","Pre or Post Tax"]
[null,{"$f":"IFERROR(IF(Deductions!B10=\"\",\"\", Deductions!B10),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C10=\"\",\"\", Deductions!C10),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D10=\"\",\"\", Deductions!D10),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E10=\"\",\"\", Deductions!E10),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F10=\"\",\"\", Deductions!F10),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B11=\"\",\"\", Deductions!B11),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C11=\"\",\"\", Deductions!C11),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D11=\"\",\"\", Deductions!D11),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E11=\"\",\"\", Deductions!E11),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F11=\"\",\"\", Deductions!F11),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B12=\"\",\"\", Deductions!B12),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C12=\"\",\"\", Deductions!C12),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D12=\"\",\"\", Deductions!D12),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E12=\"\",\"\", Deductions!E12),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F12=\"\",\"\", Deductions!F12),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B13=\"\",\"\", Deductions!B13),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C13=\"\",\"\", Deductions!C13),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D13=\"\",\"\", Deductions!D13),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E13=\"\",\"\", Deductions!E13),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F13=\"\",\"\", Deductions!F13),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B14=\"\",\"\", Deductions!B14),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C14=\"\",\"\", Deductions!C14),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D14=\"\",\"\", Deductions!D14),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E14=\"\",\"\", Deductions!E14),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F14=\"\",\"\", Deductions!F14),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B15=\"\",\"\", Deductions!B15),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C15=\"\",\"\", Deductions!C15),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D15=\"\",\"\", Deductions!D15),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E15=\"\",\"\", Deductions!E15),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F15=\"\",\"\", Deductions!F15),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B16=\"\",\"\", Deductions!B16),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C16=\"\",\"\", Deductions!C16),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D16=\"\",\"\", Deductions!D16),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E16=\"\",\"\", Deductions!E16),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F16=\"\",\"\", Deductions!F16),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B17=\"\",\"\", Deductions!B17),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C17=\"\",\"\", Deductions!C17),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D17=\"\",\"\", Deductions!D17),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E17=\"\",\"\", Deductions!E17),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F17=\"\",\"\", Deductions!F17),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B18=\"\",\"\", Deductions!B18),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C18=\"\",\"\", Deductions!C18),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D18=\"\",\"\", Deductions!D18),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E18=\"\",\"\", Deductions!E18),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F18=\"\",\"\", Deductions!F18),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B19=\"\",\"\", Deductions!B19),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C19=\"\",\"\", Deductions!C19),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D19=\"\",\"\", Deductions!D19),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E19=\"\",\"\", Deductions!E19),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F19=\"\",\"\", Deductions!F19),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B20=\"\",\"\", Deductions!B20),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C20=\"\",\"\", Deductions!C20),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D20=\"\",\"\", Deductions!D20),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E20=\"\",\"\", Deductions!E20),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F20=\"\",\"\", Deductions!F20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B21=\"\",\"\", Deductions!B21),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C21=\"\",\"\", Deductions!C21),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D21=\"\",\"\", Deductions!D21),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E21=\"\",\"\", Deductions!E21),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F21=\"\",\"\", Deductions!F21),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B22=\"\",\"\", Deductions!B22),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C22=\"\",\"\", Deductions!C22),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D22=\"\",\"\", Deductions!D22),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E22=\"\",\"\", Deductions!E22),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F22=\"\",\"\", Deductions!F22),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B23=\"\",\"\", Deductions!B23),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C23=\"\",\"\", Deductions!C23),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D23=\"\",\"\", Deductions!D23),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E23=\"\",\"\", Deductions!E23),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F23=\"\",\"\", Deductions!F23),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B24=\"\",\"\", Deductions!B24),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C24=\"\",\"\", Deductions!C24),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D24=\"\",\"\", Deductions!D24),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E24=\"\",\"\", Deductions!E24),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F24=\"\",\"\", Deductions!F24),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B25=\"\",\"\", Deductions!B25),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C25=\"\",\"\", Deductions!C25),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D25=\"\",\"\", Deductions!D25),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E25=\"\",\"\", Deductions!E25),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F25=\"\",\"\", Deductions!F25),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B26=\"\",\"\", Deductions!B26),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C26=\"\",\"\", Deductions!C26),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D26=\"\",\"\", Deductions!D26),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E26=\"\",\"\", Deductions!E26),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F26=\"\",\"\", Deductions!F26),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B27=\"\",\"\", Deductions!B27),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C27=\"\",\"\", Deductions!C27),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D27=\"\",\"\", Deductions!D27),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E27=\"\",\"\", Deductions!E27),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F27=\"\",\"\", Deductions!F27),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Deductions!B28=\"\",\"\", Deductions!B28),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!C28=\"\",\"\", Deductions!C28),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!D28=\"\",\"\", Deductions!D28),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!E28=\"\",\"\", Deductions!E28),\"\")","v":""},{"$f":"IFERROR(IF(Deductions!F28=\"\",\"\", Deductions!F28),\"\")","v":""}]
[]
[]
[null,"Vendors"]
[null,"Benefit Vendors (EBN Customers)"]
[]
[null,"Vendor Information"]
[]
[null,"Vendor Information","Vendor 1","Vendor 2","Vendor 3","Vendor 4"]
[null,"Name ",{"$f":"IFERROR(IF(Vendors!C10=\"\",\"\", Vendors!C10),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!D10=\"\",\"\", Vendors!D10),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!E10=\"\",\"\", Vendors!E10),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!F10=\"\",\"\", Vendors!F10),\"\")","v":""}]
[null,"Description",{"$f":"IFERROR(IF(Vendors!C11=\"\",\"\", Vendors!C11),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!D11=\"\",\"\", Vendors!D11),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!E11=\"\",\"\", Vendors!E11),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!F11=\"\",\"\", Vendors!F11),\"\")","v":""}]
[null,"Code",{"$f":"IFERROR(IF(Vendors!C12=\"\",\"\", Vendors!C12),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!D12=\"\",\"\", Vendors!D12),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!E12=\"\",\"\", Vendors!E12),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!F12=\"\",\"\", Vendors!F12),\"\")","v":""}]
[null,"FEIN",{"$f":"IFERROR(IF(Vendors!C13=\"\",\"\", Vendors!C13),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!D13=\"\",\"\", Vendors!D13),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!E13=\"\",\"\", Vendors!E13),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!F13=\"\",\"\", Vendors!F13),\"\")","v":""}]
[null,"Used for ",{"$f":"IFERROR(IF(Vendors!C14=\"\",\"\", Vendors!C14),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!D14=\"\",\"\", Vendors!D14),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!E14=\"\",\"\", Vendors!E14),\"\")","v":""},{"$f":"IFERROR(IF(Vendors!F14=\"\",\"\", Vendors!F14),\"\")","v":""}]
[]
[]
[null,"Benefits"]
[null,"With in Workforce Ready HR you can track benefit plan information such as eligibility, level of coverage and premium amounts for various employee provided benefits (health, dental, life insurance, etc.) "]
[null,"Benefit Plans"]
[]
[null,"Benefit Plan Name","Plan Type","Pre Tax or Post Tax","Eligible Group","Provider"]
[null,{"$f":"IFERROR(IF(Benefits!H16=\"\",\"\", Benefits!H16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!H17=\"\",\"\", Benefits!H17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!H19=\"\",\"\", Benefits!H19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!H29=\"\",\"\", Benefits!H29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!H20=\"\",\"\", Benefits!H20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!J16=\"\",\"\", Benefits!J16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!J17=\"\",\"\", Benefits!J17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!J19=\"\",\"\", Benefits!J19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!J29=\"\",\"\", Benefits!J29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!J20=\"\",\"\", Benefits!J20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!L16=\"\",\"\", Benefits!L16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!L17=\"\",\"\", Benefits!L17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!L19=\"\",\"\", Benefits!L19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!L29=\"\",\"\", Benefits!L29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!L20=\"\",\"\", Benefits!L20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!N16=\"\",\"\", Benefits!N16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!N17=\"\",\"\", Benefits!N17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!N19=\"\",\"\", Benefits!N19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!N29=\"\",\"\", Benefits!N29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!N20=\"\",\"\", Benefits!N20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!P16=\"\",\"\", Benefits!P16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!P17=\"\",\"\", Benefits!P17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!P19=\"\",\"\", Benefits!P19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!P29=\"\",\"\", Benefits!P29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!P20=\"\",\"\", Benefits!P20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!R16=\"\",\"\", Benefits!R16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!R17=\"\",\"\", Benefits!R17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!R19=\"\",\"\", Benefits!R19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!R29=\"\",\"\", Benefits!R29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!R20=\"\",\"\", Benefits!R20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!T16=\"\",\"\", Benefits!T16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!T17=\"\",\"\", Benefits!T17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!T19=\"\",\"\", Benefits!T19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!R29=\"\",\"\", Benefits!R29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!R20=\"\",\"\", Benefits!R20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!V16=\"\",\"\", Benefits!V16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!V17=\"\",\"\", Benefits!V17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!V19=\"\",\"\", Benefits!V19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!V29=\"\",\"\", Benefits!V29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!V20=\"\",\"\", Benefits!V20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!X16=\"\",\"\", Benefits!X16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!X17=\"\",\"\", Benefits!X17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!X19=\"\",\"\", Benefits!X19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!X29=\"\",\"\", Benefits!X29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!X20=\"\",\"\", Benefits!X20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!Z16=\"\",\"\", Benefits!Z16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!Z17=\"\",\"\", Benefits!Z17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!Z19=\"\",\"\", Benefits!Z19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!Z29=\"\",\"\", Benefits!Z29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!Z20=\"\",\"\", Benefits!Z20),\"\")","v":""}]
[]
[]
[null,"Integration"]
[null,"Workforce Ready HR may interact with one or more of your business systems. Employee data required in Workforce Ready HR may be exported and feed into other 3rd party systems or vendors. \n\n"]
[]
[]
[null,"Interfaces"]
[]
[null,"Interface Name","Source System","Destination System","Description"]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[]
[null,"Additional Integration Notes"]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Approval"]
[null,"The approval process is used to ensure Kronos has documented your policies according to your standards and our project discussions.  Before moving forward with the configuration of your system we would like to ensure that we have collected all data accordingly and accurately.  Please review this document and speak with your Kronos representative if you have any questions.  Once you have reviewed the document please sign, date and return this document to your Kronos Project Manager"]
[]
[]
[]
[]
[]
[null,"Customer Authorized Approver",null,null,"Date"]

{"sheet":"DesignStage","index":29,"n_rows":505,"n_cols":6,"rows_kept":505,"cut":false,"hidden":true,"merged":[[273,8,273,9],[273,14,273,15],[273,11,273,12],[273,17,273,18],[478,1,494,5],[6,1,14,6],[22,1,22,3],[23,1,28,4],[33,1,36,4],[58,1,58,5],[59,1,59,4],[65,1,65,2],[65,3,65,5],[66,1,66,2],[66,3,66,5],[70,1,70,4],[71,1,72,4],[60,1,64,1],[60,3,60,5],[61,3,61,5],[62,3,62,5],[63,3,63,5],[64,3,64,5],[140,1,141,4],[153,1,153,5],[154,1,163,5],[166,1,166,5],[167,1,169,5],[177,1,177,5],[74,1,74,5],[75,1,79,4],[100,1,100,4],[101,1,103,4],[115,1,116,4],[128,1,129,4],[185,2,185,3],[186,2,186,3],[187,2,187,3],[189,1,189,5],[190,1,199,5],[202,1,202,5],[178,1,178,4],[180,2,180,3],[181,2,181,3],[182,2,182,3],[183,2,183,3],[184,2,184,3],[218,1,219,4],[260,1,260,4],[261,1,264,4],[203,1,203,5],[205,1,205,5],[206,1,214,5],[217,1,217,4],[284,3,284,4],[285,3,285,4],[286,3,286,4],[287,3,287,4],[288,3,288,4],[289,3,289,4],[278,1,278,4],[279,1,280,4],[282,1,282,4],[283,3,283,4],[304,1,304,5],[309,1,309,4],[310,1,310,5],[290,3,290,4],[291,3,291,4],[292,3,292,4],[295,1,295,5],[296,1,300,5],[303,1,303,5],[360,1,369,5],[372,1,372,2],[373,1,377,4],[379,1,379,4],[380,2,380,4],[381,2,381,4],[324,1,324,5],[325,1,327,5],[330,1,330,5],[359,1,359,5],[388,2,388,4],[389,2,389,4],[390,2,390,4],[391,2,391,4],[392,2,392,4],[393,2,393,4],[382,2,382,4],[383,2,383,4],[384,2,384,4],[385,2,385,4],[386,2,386,4],[387,2,387,4],[401,1,401,5],[402,1,402,5],[403,1,403,5],[405,1,405,5],[408,1,408,4],[411,2,411,3],[394,2,394,4],[396,1,396,5],[397,1,397,5],[398,1,398,5],[399,1,399,5],[400,1,400,5],[418,2,418,3],[419,2,419,3],[420,2,420,3],[421,2,421,3],[422,2,422,3],[425,1,425,4],[412,2,412,3],[413,2,413,3],[414,2,414,3],[415,2,415,3],[416,2,416,3],[417,2,417,3],[453,4,453,5],[454,4,454,5],[455,4,455,5],[456,4,456,5],[457,4,457,5],[458,4,458,5],[443,1,443,4],[444,1,445,4],[448,1,448,5],[451,4,451,5],[452,4,452,5],[475,1,476,5],[477,1,477,5],[499,1,502,4],[504,2,504,3],[459,4,459,5],[460,4,460,5],[461,4,461,5],[463,1,463,5],[464,1,471,5],[474,1,474,5]]}
[]
[]
[]
[]
[]
[]
[null,"Kronos Workforce Ready HR Core Foundation \nSolution Design"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Prepared for ",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"Document Overview"]
[null,"The purpose of this document is to outline the Workforce Ready HR Core Foundation Solution Design from the basis of your business processes, information gathered, and decisions made during the Discovery Assessment meetings.  It defines key compoenents to sucessfully implement the Workforce Ready HR Core Foundation, including product processes, company goals and data exchange requirements.  Following the acceptance of the Workforce HR Core Foundation Solution Design, any requirements not detailed within this document will be subject to project change control procedures and planned in the next phase of the implemenation. It is important that you review each section and then sign and return this document to your Kronos consultant.  If you have any questions please reach out to your Kronos consultant."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"HR Overview"]
[null,"The core foundation of HR will establish you for tracking employee HR records, benefit administration, onboarding and standard HR reporting. However, the Workforce Ready HR module has a lot of additional functionality such as tracking employee Training, Applicant Tracking/Recruitment, Performance Reviews, Open Enrollment and Life Events, Asset and Incident tracking.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Customer Goals"]
[]
[null,"What are your goals for the implemenation?",1,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,null,2,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,null,3,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,null,4,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,null,5,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,"What are your expectations during the implementation?",null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,"What is the criteria that you will use to measure success for this implementation?",null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[]
[]
[]
[null,"Solution Design Details"]
[null,"The following details your solution design per the specifications gathered during your Discovery meetings with your Kronos consultant.  Please review each section carefully and reach out to your consultant if you have any questions."]
[]
[]
[null,"Access Requirements"]
[null,"Since Workforce Ready is a Cloud based system your users can access it from anywhere they have an Internet connection.  Based on company security policies you may choose to allow or restrict employees and managers from accessing Workforce Ready from outside of your company's network.  Or you may allow managers to access Workforce Ready from outside of your company's network, but require employees to be logged into your company's network in order to access Workforce Ready.  All employees and managers will be able to access Workforce Ready from inside of your company's network."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Your Access Selections"]
[null,"You have choosen to allow employees, or a specific group of employees, and managers, or a specific group of managers, to access Workforce Ready from anywhere they have an Internet connection.  They will be able to acccess Workforce Ready from your office netowrk or any other remote location."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"You have choosen to not allow employees or managers to access Workforce Ready from outside of your company network.  This means that they will have to be logged onto your company network in order to acccess Workforce Ready."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"You have choosen to allow managers, or a specific group of managers, to access Workforce Ready from anywhere they have an Internet connection.  However, you have choosen to allow employees to only access Workforce Ready from within your company network."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"You have choosen to allow employees, or a specific group of employees, to access Workforce Ready from anywhere they have an Internet connection.  However, you have choosen to allow managers to only access Workforce Ready from within your company network."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Additional Access Notes"]
[null,{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Security"]
[null,"Four default Security Profiles are provided in the system: Company Administrator, Payroll Administrator,\nDepartment Manager, and Employee. The Security Profile, applied to a user account, determines the user’s access\nprivileges to system functions (what the user can see in the system). You can configure the settings associated with\nthese default Security Profiles, as well as create additional Security Profiles."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Security Profiles"]
[null,"The Security Profile determines a user’s access privileges to system functions, while Groups and Group Permissions determine a user’s access privileges to other user accounts. Security Profiles determine \"what you can see\"."]
[]
[null,"Security Profile ","Access/Permissions"]
[null,{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[]
[null,"Additional Security Profile Notes"]
[null,{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Groups"]
[null,"Groups help organize employees and mangement responsibilities. Employees are assigned groups. Managers are assigned access and permission level to the groups in which they have management responsibilities too. Groups can be created by job, cost center or other criteria. Groups determine \"who you can see\". "]
[]
[null,"Additional Groups Notes"]
[null,{"$f":"IFERROR(IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},"","","",""]
[null,"Groups help organize employees and mangement responsibilities. Employees are assigned groups. Managers are assigned access and permission level to the groups in which they have management responsibilities too. Groups can be created by job, cost center or other criteria. (Groups determine who you can see)","","","",""]
[null,"How do you group individuals in your workplace? \n(manager, department, etc)","","","",""]
[null,"","","","",""]
[null,"Additional Security Profiles/ Groups Notes","","","",""]
[null,"Add additional notes here","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[]
[]
[null,"Employee Types"]
[null,"The following employee types will be configured in your Workforce Ready system."]
[]
[]
[null,"Employee Type"]
[null,{"$f":"IFERROR(IF(HR_Settings!B15=\"\",\"\",HR_Settings!B15),\"\")","v":"Temp"}]
[null,{"$f":"IFERROR(IF(HR_Settings!B16=\"\",\"\",HR_Settings!B16),\"\")","v":"Apprentices"}]
[null,{"$f":"IFERROR(IF(HR_Settings!B17=\"\",\"\",HR_Settings!B17),\"\")","v":"Perm"}]
[null,{"$f":"IFERROR(IF(HR_Settings!B18=\"\",\"\",HR_Settings!B18),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!B19=\"\",\"\",HR_Settings!B19),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!B20=\"\",\"\",HR_Settings!B20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!B21=\"\",\"\",HR_Settings!B21),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!B22=\"\",\"\",HR_Settings!B22),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!B23=\"\",\"\",HR_Settings!B23),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!B24=\"\",\"\",HR_Settings!B24),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!B26=\"\",\"\",HR_Settings!B26),\"\")","v":""}]
[]
[null,"Account Status"]
[null,{"$f":"IFERROR(IF(HR_Settings!F15=\"\",\"\",HR_Settings!F15),\"\")","v":"Active"}]
[null,{"$f":"IFERROR(IF(HR_Settings!F16=\"\",\"\",HR_Settings!F16),\"\")","v":"Terminated"}]
[null,{"$f":"IFERROR(IF(HR_Settings!F17=\"\",\"\",HR_Settings!F17),\"\")","v":"Seasonal"}]
[null,{"$f":"IFERROR(IF(HR_Settings!F18=\"\",\"\",HR_Settings!F18),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!F19=\"\",\"\",HR_Settings!F19),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!F20=\"\",\"\",HR_Settings!F20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!F21=\"\",\"\",HR_Settings!F21),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!F22=\"\",\"\",HR_Settings!F22),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!F23=\"\",\"\",HR_Settings!F23),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!F24=\"\",\"\",HR_Settings!F24),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!F26=\"\",\"\",HR_Settings!F26),\"\")","v":""}]
[]
[null,"Pay Types"]
[null,{"$f":"IFERROR(IF(HR_Settings!J15=\"\",\"\",HR_Settings!J15),\"\")","v":"Salaried"}]
[null,{"$f":"IFERROR(IF(HR_Settings!J16=\"\",\"\",HR_Settings!J16),\"\")","v":"Hourly"}]
[null,{"$f":"IFERROR(IF(HR_Settings!J17=\"\",\"\",HR_Settings!J17),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!J18=\"\",\"\",HR_Settings!J18),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!J19=\"\",\"\",HR_Settings!J19),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!J20=\"\",\"\",HR_Settings!J20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!J21=\"\",\"\",HR_Settings!J21),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!J22=\"\",\"\",HR_Settings!J22),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!J23=\"\",\"\",HR_Settings!J23),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(HR_Settings!J24=\"\",\"\",HR_Settings!J24),\"\")","v":""}]
[]
[]
[null,"Cost Centers"]
[null,"Cost centers allow you to define different locations, departments and establish default cost center for a specific jos according to your companies policies. Using cost centers you have the ability to filter reports within your company based on the cost centers."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Your Cost Center Selections"]
[null,"You have choosen the following Cost Center structure that will meeting the needs of your organization for HR."]
[]
[]
[null,"Cost Center Levels"]
[null,"Level","Name","Description"]
[null,1,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,2,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,3,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,4,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,5,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,6,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,7,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,8,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,9,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[]
[]
[null,"Additional Cost Center Notes"]
[null,"Add additional notes here"]
[]
[]
[]
[]
[]
[]
[null,"Benefits"]
[null,"With in Workforce Ready HR you can track benefit plan information such as eligibility, level of coverage and premium amounts for various employee provided benefits (health, dental, life insurance, etc.) "]
[]
[]
[]
[]
[null,"Benefit Plans"]
[]
[null,"Benefit Plan Name","Plan Type","Pre Tax or Post Tax","Eligible Group","Provider"]
[null,{"$f":"IFERROR(IF(Benefits!H16=\"\",\"\", Benefits!H16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!H17=\"\",\"\", Benefits!H17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!H19=\"\",\"\", Benefits!H19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!H29=\"\",\"\", Benefits!H29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!H20=\"\",\"\", Benefits!H20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!J16=\"\",\"\", Benefits!J16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!J17=\"\",\"\", Benefits!J17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!J19=\"\",\"\", Benefits!J19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!J29=\"\",\"\", Benefits!J29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!J20=\"\",\"\", Benefits!J20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!L16=\"\",\"\", Benefits!L16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!L17=\"\",\"\", Benefits!L17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!L19=\"\",\"\", Benefits!L19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!L29=\"\",\"\", Benefits!L29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!L20=\"\",\"\", Benefits!L20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!N16=\"\",\"\", Benefits!N16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!N17=\"\",\"\", Benefits!N17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!N19=\"\",\"\", Benefits!N19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!N29=\"\",\"\", Benefits!N29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!N20=\"\",\"\", Benefits!N20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!P16=\"\",\"\", Benefits!P16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!P17=\"\",\"\", Benefits!P17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!P19=\"\",\"\", Benefits!P19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!P29=\"\",\"\", Benefits!P29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!P20=\"\",\"\", Benefits!P20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!R16=\"\",\"\", Benefits!R16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!R17=\"\",\"\", Benefits!R17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!R19=\"\",\"\", Benefits!R19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!R29=\"\",\"\", Benefits!R29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!R20=\"\",\"\", Benefits!R20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!T16=\"\",\"\", Benefits!T16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!T17=\"\",\"\", Benefits!T17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!T19=\"\",\"\", Benefits!T19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!R29=\"\",\"\", Benefits!R29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!R20=\"\",\"\", Benefits!R20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!V16=\"\",\"\", Benefits!V16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!V17=\"\",\"\", Benefits!V17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!V19=\"\",\"\", Benefits!V19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!V29=\"\",\"\", Benefits!V29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!V20=\"\",\"\", Benefits!V20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!X16=\"\",\"\", Benefits!X16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!X17=\"\",\"\", Benefits!X17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!X19=\"\",\"\", Benefits!X19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!X29=\"\",\"\", Benefits!X29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!X20=\"\",\"\", Benefits!X20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Benefits!Z16=\"\",\"\", Benefits!Z16),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!Z17=\"\",\"\", Benefits!Z17),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!Z19=\"\",\"\", Benefits!Z19),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!Z29=\"\",\"\", Benefits!Z29),\"\")","v":""},{"$f":"IFERROR(IF(Benefits!Z20=\"\",\"\", Benefits!Z20),\"\")","v":""}]
[]
[]
[null,"Pay Grades"]
[null,"Pay Grades are used to define the minimum and maximum pay or salary ranges with an automated mid point calculation. Pay Grades can further break down into steps to increment pay increases and, or, tied to location factors. Pay Grades can be assigned to either the employee or jobs. Pay Grades are used and referenced in HR Action Requests, Performance Reviews and Compensation Management. Customer will provide a complete list of detailed pay grade information, including any applicable step in grade tables. "]
[]
[]
[]
[null,"Pay Grade Information"]
[]
[null,"Pay Grade","Rate By","Minimum","Maximum","Steps within Pay Grade"]
[null,{"$f":"IFERROR(IF('Pay Grades'!C17=\"\",\"\", 'Pay Grades'!C17),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D17=\"\",\"\", 'Pay Grades'!D17),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E17=\"\",\"\", 'Pay Grades'!E17),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F17=\"\",\"\", 'Pay Grades'!F17),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G17=\"\",\"\", 'Pay Grades'!G17),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C18=\"\",\"\", 'Pay Grades'!C18),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D18=\"\",\"\", 'Pay Grades'!D18),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E18=\"\",\"\", 'Pay Grades'!E18),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F18=\"\",\"\", 'Pay Grades'!F18),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G18=\"\",\"\", 'Pay Grades'!G18),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C19=\"\",\"\", 'Pay Grades'!C19),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D19=\"\",\"\", 'Pay Grades'!D19),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E19=\"\",\"\", 'Pay Grades'!E19),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F19=\"\",\"\", 'Pay Grades'!F19),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G19=\"\",\"\", 'Pay Grades'!G19),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C20=\"\",\"\", 'Pay Grades'!C20),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D20=\"\",\"\", 'Pay Grades'!D20),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E20=\"\",\"\", 'Pay Grades'!E20),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F20=\"\",\"\", 'Pay Grades'!F20),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G20=\"\",\"\", 'Pay Grades'!G20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C21=\"\",\"\", 'Pay Grades'!C21),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D21=\"\",\"\", 'Pay Grades'!D21),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E21=\"\",\"\", 'Pay Grades'!E21),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F21=\"\",\"\", 'Pay Grades'!F21),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G21=\"\",\"\", 'Pay Grades'!G21),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C22=\"\",\"\", 'Pay Grades'!C22),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D22=\"\",\"\", 'Pay Grades'!D22),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E22=\"\",\"\", 'Pay Grades'!E22),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F22=\"\",\"\", 'Pay Grades'!F22),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G22=\"\",\"\", 'Pay Grades'!G22),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C23=\"\",\"\", 'Pay Grades'!C23),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D23=\"\",\"\", 'Pay Grades'!D23),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E23=\"\",\"\", 'Pay Grades'!E23),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F23=\"\",\"\", 'Pay Grades'!F23),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G23=\"\",\"\", 'Pay Grades'!G23),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C24=\"\",\"\", 'Pay Grades'!C24),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D24=\"\",\"\", 'Pay Grades'!D24),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E24=\"\",\"\", 'Pay Grades'!E24),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F24=\"\",\"\", 'Pay Grades'!F24),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G24=\"\",\"\", 'Pay Grades'!G24),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C25=\"\",\"\", 'Pay Grades'!C25),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D25=\"\",\"\", 'Pay Grades'!D25),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E25=\"\",\"\", 'Pay Grades'!E25),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F25=\"\",\"\", 'Pay Grades'!F25),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G25=\"\",\"\", 'Pay Grades'!G25),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C26=\"\",\"\", 'Pay Grades'!C26),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D26=\"\",\"\", 'Pay Grades'!D26),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E26=\"\",\"\", 'Pay Grades'!E26),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F26=\"\",\"\", 'Pay Grades'!F26),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G26=\"\",\"\", 'Pay Grades'!G26),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C27=\"\",\"\", 'Pay Grades'!C27),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D27=\"\",\"\", 'Pay Grades'!D27),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E27=\"\",\"\", 'Pay Grades'!E27),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F27=\"\",\"\", 'Pay Grades'!F27),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G27=\"\",\"\", 'Pay Grades'!G27),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C28=\"\",\"\", 'Pay Grades'!C28),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D28=\"\",\"\", 'Pay Grades'!D28),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E28=\"\",\"\", 'Pay Grades'!E28),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F28=\"\",\"\", 'Pay Grades'!F28),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G28=\"\",\"\", 'Pay Grades'!G28),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C29=\"\",\"\", 'Pay Grades'!C29),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D29=\"\",\"\", 'Pay Grades'!D29),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E29=\"\",\"\", 'Pay Grades'!E29),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F29=\"\",\"\", 'Pay Grades'!F29),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G29=\"\",\"\", 'Pay Grades'!G29),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C30=\"\",\"\", 'Pay Grades'!C30),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D30=\"\",\"\", 'Pay Grades'!D30),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E30=\"\",\"\", 'Pay Grades'!E30),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F30=\"\",\"\", 'Pay Grades'!F30),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G30=\"\",\"\", 'Pay Grades'!G30),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C31=\"\",\"\", 'Pay Grades'!C31),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D31=\"\",\"\", 'Pay Grades'!D31),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E31=\"\",\"\", 'Pay Grades'!E31),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F31=\"\",\"\", 'Pay Grades'!F31),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G31=\"\",\"\", 'Pay Grades'!G31),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C32=\"\",\"\", 'Pay Grades'!C32),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D32=\"\",\"\", 'Pay Grades'!D32),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E32=\"\",\"\", 'Pay Grades'!E32),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F32=\"\",\"\", 'Pay Grades'!F32),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G32=\"\",\"\", 'Pay Grades'!G32),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C33=\"\",\"\", 'Pay Grades'!C33),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D33=\"\",\"\", 'Pay Grades'!D33),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E33=\"\",\"\", 'Pay Grades'!E33),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F33=\"\",\"\", 'Pay Grades'!F33),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G33=\"\",\"\", 'Pay Grades'!G33),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!C34=\"\",\"\", 'Pay Grades'!C34),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!D34=\"\",\"\", 'Pay Grades'!D34),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!E34=\"\",\"\", 'Pay Grades'!E34),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!F34=\"\",\"\", 'Pay Grades'!F34),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!G34=\"\",\"\", 'Pay Grades'!G34),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""},{"$f":"IFERROR(IF('Pay Grades'!#REF!=\"\",\"\", 'Pay Grades'!#REF!),\"\")","v":""}]
[]
[null,"Additional Pay Grade Notes"]
[null,{"$f":"IFERROR(IF('Pay Grades'!B43=\"\",\"\", 'Pay Grades'!B43),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jobs"]
[null,"Jobs identify the description of what an employee does in the organization. A Job has unique assignments like, Employee Type, EEO, Union, Pay Grade, Standard Work Day, Workers Compensation Code, Salary Survey & Competencies and is applied to all employees assigned to that job. Customer will provide a detailed list of jobs. "]
[]
[]
[]
[]
[null,"Job Information"]
[]
[null,"Job Name ","Description"]
[null,{"$f":"IFERROR(IF(Jobs!B13=\"\",\"\", Jobs!B13),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!B13=\"\",\"\", Jobs!B13),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!B14=\"\",\"\", Jobs!B14),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!B14=\"\",\"\", Jobs!B14),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!B15=\"\",\"\", Jobs!B15),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!B15=\"\",\"\", Jobs!B15),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!B16=\"\",\"\", Jobs!B16),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!B16=\"\",\"\", Jobs!B16),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!B17=\"\",\"\", Jobs!B17),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!B17=\"\",\"\", Jobs!B17),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!B18=\"\",\"\", Jobs!B18),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!B18=\"\",\"\", Jobs!B18),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!B19=\"\",\"\", Jobs!B19),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!B19=\"\",\"\", Jobs!B19),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!#REF!=\"\",\"\", Jobs!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!#REF!=\"\",\"\", Jobs!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!#REF!=\"\",\"\", Jobs!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!#REF!=\"\",\"\", Jobs!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!#REF!=\"\",\"\", Jobs!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!#REF!=\"\",\"\", Jobs!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!#REF!=\"\",\"\", Jobs!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!#REF!=\"\",\"\", Jobs!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!#REF!=\"\",\"\", Jobs!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!#REF!=\"\",\"\", Jobs!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!B20=\"\",\"\", Jobs!B20),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!B20=\"\",\"\", Jobs!B20),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Jobs!B21=\"\",\"\", Jobs!B21),\"\")","v":""},{"$f":"IFERROR(IF(Jobs!B21=\"\",\"\", Jobs!B21),\"\")","v":""}]
[]
[null,"Additional Jobs Notes"]
[null,{"$f":"IFERROR(IF(Jobs!B31=\"\",\"\", Jobs!B31),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Unions"]
[]
[null,"Union Information"]
[null,"Union Name","Notes"]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[]
[]
[null,"Disability Types"]
[]
[null,"Disability Type Information"]
[null,"Name","Restrictions","Descriptions","Notes"]
[null,{"$f":"IFERROR(IF(Disability!B10=\"\",\"\", Disability!B10),\"\")","v":""},{"$f":"IFERROR(IF(Disability!C10=\"\",\"\", Disability!C10),\"\")","v":""},{"$f":"IFERROR(IF(Disability!D10=\"\",\"\", Disability!D10),\"\")","v":""},{"$f":"IFERROR(IF(Disability!E10=\"\",\"\", Disability!E10),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Disability!B11=\"\",\"\", Disability!B11),\"\")","v":""},{"$f":"IFERROR(IF(Disability!C11=\"\",\"\", Disability!C11),\"\")","v":""},{"$f":"IFERROR(IF(Disability!D11=\"\",\"\", Disability!D11),\"\")","v":""},{"$f":"IFERROR(IF(Disability!E11=\"\",\"\", Disability!E11),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Disability!B12=\"\",\"\", Disability!B12),\"\")","v":""},{"$f":"IFERROR(IF(Disability!C12=\"\",\"\", Disability!C12),\"\")","v":""},{"$f":"IFERROR(IF(Disability!D12=\"\",\"\", Disability!D12),\"\")","v":""},{"$f":"IFERROR(IF(Disability!E12=\"\",\"\", Disability!E12),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Disability!B13=\"\",\"\", Disability!B13),\"\")","v":""},{"$f":"IFERROR(IF(Disability!C13=\"\",\"\", Disability!C13),\"\")","v":""},{"$f":"IFERROR(IF(Disability!D13=\"\",\"\", Disability!D13),\"\")","v":""},{"$f":"IFERROR(IF(Disability!E13=\"\",\"\", Disability!E13),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Disability!B14=\"\",\"\", Disability!B14),\"\")","v":""},{"$f":"IFERROR(IF(Disability!C14=\"\",\"\", Disability!C14),\"\")","v":""},{"$f":"IFERROR(IF(Disability!D14=\"\",\"\", Disability!D14),\"\")","v":""},{"$f":"IFERROR(IF(Disability!E14=\"\",\"\", Disability!E14),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Disability!B15=\"\",\"\", Disability!B15),\"\")","v":""},{"$f":"IFERROR(IF(Disability!C15=\"\",\"\", Disability!C15),\"\")","v":""},{"$f":"IFERROR(IF(Disability!D15=\"\",\"\", Disability!D15),\"\")","v":""},{"$f":"IFERROR(IF(Disability!E15=\"\",\"\", Disability!E15),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Disability!B16=\"\",\"\", Disability!B16),\"\")","v":""},{"$f":"IFERROR(IF(Disability!C16=\"\",\"\", Disability!C16),\"\")","v":""},{"$f":"IFERROR(IF(Disability!D16=\"\",\"\", Disability!D16),\"\")","v":""},{"$f":"IFERROR(IF(Disability!E16=\"\",\"\", Disability!E16),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""},{"$f":"IFERROR(IF(Disability!#REF!=\"\",\"\", Disability!#REF!),\"\")","v":""}]
[]
[]
[null,"Integration"]
[null,"Workforce Ready HR may interact with one or more of your business systems. Employee data required in Workforce Ready HR may be exported and feed into other 3rd party systems or vendors. \n\n"]
[]
[]
[]
[null,"Interfaces"]
[]
[]
[null,"Interface Name","Source System","Destination System","Description"]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""},""]
[]
[null,"Additional Integration Notes"]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Additional Information"]
[null,"The following is a summary of additional information that was discussed during your Discovery calls with your Kronos consultant.  Please review and if you have any questions contact your Kronos consultant.   \n   \n   \n"]
[]
[null,"Additional Information Notes"]
[null,{"$f":"IFERROR( IF(#REF!=\"\",\"\",#REF!),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Approval"]
[null,"The approval process is used to ensure Kronos has documented your policies according to your standards and our project discussions.  Before moving forward with the configuration of your system we would like to ensure that we have collected all data accordingly and accurately.  Please review this document and speak with your Kronos representative if you have any questions.  Once you have reviewed the document please sign, date and return this document to your Kronos Project Manager"]
[]
[]
[]
[]
[null,"Customer Authorized Approver",null,null,"Date"]