{ "ReportGuid": "ff3d1366590850537619b5527fd52ec3", "ReportName": "Training Matrix", "ReportAlias": "Training Matrix", "ReportFile": "Training Matrix.mrt", "ReportAuthor": "Demo Care Admin Account", "ReportDescription": "Training Qualifications ", "ReportCreated": "/Date(1597144845000+0100)/", "ReportChanged": "/Date(1637846979000+0000)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "ReportUnit": "Centimeters", "CacheAllData": true, "PreviewSettings": 268435455, "Dictionary": { "DataSources": { "0": { "Ident": "StiDataTableSource", "Name": "employees_summary", "Alias": "employees_summary", "Columns": { "0": { "Name": "EmployeeID", "Index": -1, "NameInSource": "EmployeeID", "Alias": "EmployeeID", "Type": "System.Decimal" }, "1": { "Name": "HomeID", "Index": -1, "NameInSource": "HomeID", "Alias": "HomeID", "Type": "System.Decimal" }, "2": { "Name": "Employee Name", "Index": -1, "NameInSource": "Employee Name", "Alias": "Employee Name", "Type": "System.String" }, "3": { "Name": "Gender", "Index": -1, "NameInSource": "Gender", "Alias": "Gender", "Type": "System.String" }, "4": { "Name": "National Insurance No.", "Index": -1, "NameInSource": "National Insurance No.", "Alias": "National Insurance No.", "Type": "System.String" }, "5": { "Name": "Next of Kin", "Index": -1, "NameInSource": "Next of Kin", "Alias": "Next of Kin", "Type": "System.String" }, "6": { "Name": "Residing At Home", "Index": -1, "NameInSource": "Residing At Home", "Alias": "Residing At Home", "Type": "System.String" }, "7": { "Name": "Job Title", "Index": -1, "NameInSource": "Job Title", "Alias": "Job Title", "Type": "System.String" }, "8": { "Name": "Current Grading", "Index": -1, "NameInSource": "Current Grading", "Alias": "Current Grading", "Type": "System.String" }, "9": { "Name": "Experience(Years)", "Index": -1, "NameInSource": "Experience(Years)", "Alias": "Experience(Years)", "Type": "System.String" }, "10": { "Name": "Experience(Months)", "Index": -1, "NameInSource": "Experience(Months)", "Alias": "Experience(Months)", "Type": "System.String" }, "11": { "Name": "Contracting Hours", "Index": -1, "NameInSource": "Contracting Hours", "Alias": "Contracting Hours", "Type": "System.String" }, "12": { "Name": "On Probation", "Index": -1, "NameInSource": "On Probation", "Alias": "On Probation", "Type": "System.String" }, "13": { "Name": "Care Group Joining Date", "Index": -1, "NameInSource": "Care Group Joining Date", "Alias": "Care Group Joining Date", "Type": "System.String" }, "14": { "Name": "Care Group Leaving Date", "Index": -1, "NameInSource": "Care Group Leaving Date", "Alias": "Care Group Leaving Date", "Type": "System.String" }, "15": { "Name": "Status", "Index": -1, "NameInSource": "Status", "Alias": "Status", "Type": "System.String" } }, "NameInSource": "ClearCare Solutions.employees_summary" }, "1": { "Ident": "StiDataTableSource", "Name": "employee_qualifications", "Alias": "employee_qualifications", "Columns": { "0": { "Name": "qualification_status_id", "Index": -1, "NameInSource": "qualification_status_id", "Alias": "qualification_status_id", "Type": "System.Decimal" }, "1": { "Name": "qualification_status_target", "Index": -1, "NameInSource": "qualification_status_target", "Alias": "qualification_status_target", "Type": "System.Decimal" }, "2": { "Name": "qualification_id", "Index": -1, "NameInSource": "qualification_id", "Alias": "qualification_id", "Type": "System.Decimal" }, "3": { "Name": "EmployeeID", "Index": -1, "NameInSource": "EmployeeID", "Alias": "EmployeeID", "Type": "System.Decimal" }, "4": { "Name": "EmployeeName", "Index": -1, "NameInSource": "EmployeeName", "Alias": "EmployeeName", "Type": "System.String" }, "5": { "Name": "HomeOrSchoolName", "Index": -1, "NameInSource": "HomeOrSchoolName", "Alias": "HomeOrSchoolName", "Type": "System.String" }, "6": { "Name": "QualificationName", "Index": -1, "NameInSource": "QualificationName", "Alias": "QualificationName", "Type": "System.String" }, "7": { "Name": "QualificationType", "Index": -1, "NameInSource": "QualificationType", "Alias": "QualificationType", "Type": "System.String" }, "8": { "Name": "IssuingBody", "Index": -1, "NameInSource": "IssuingBody", "Alias": "IssuingBody", "Type": "System.String" }, "9": { "Name": "TrainingCourseAttended", "Index": -1, "NameInSource": "TrainingCourseAttended", "Alias": "TrainingCourseAttended", "Type": "System.String" }, "10": { "Name": "QualificationDate", "Index": -1, "NameInSource": "QualificationDate", "Alias": "QualificationDate", "Type": "System.String" }, "11": { "Name": "PrettyQualificationDate", "Index": -1, "NameInSource": "PrettyQualificationDate", "Alias": "PrettyQualificationDate", "Type": "System.String" }, "12": { "Name": "ExpiryDate", "Index": -1, "NameInSource": "ExpiryDate", "Alias": "ExpiryDate", "Type": "System.String" }, "13": { "Name": "PrettyExpiryDate", "Index": -1, "NameInSource": "PrettyExpiryDate", "Alias": "PrettyExpiryDate", "Type": "System.String" }, "14": { "Name": "RefresherDate", "Index": -1, "NameInSource": "RefresherDate", "Alias": "RefresherDate", "Type": "System.String" }, "15": { "Name": "PrettyRefresherDate", "Index": -1, "NameInSource": "PrettyRefresherDate", "Alias": "PrettyRefresherDate", "Type": "System.String" }, "16": { "Name": "DaysUntilExpiry", "Index": -1, "NameInSource": "DaysUntilExpiry", "Alias": "DaysUntilExpiry", "Type": "System.String" }, "17": { "Name": "DaysUntilRefresher", "Index": -1, "NameInSource": "DaysUntilRefresher", "Alias": "DaysUntilRefresher", "Type": "System.String" }, "18": { "Name": "QualificationStatus", "Index": -1, "NameInSource": "QualificationStatus", "Alias": "QualificationStatus", "Type": "System.String" }, "19": { "Name": "Status", "Index": -1, "NameInSource": "Status", "Alias": "Status", "Type": "System.String" } }, "NameInSource": "ClearCare Solutions.employee_qualifications" }, "2": { "Ident": "StiDataTableSource", "Name": "homes_summary", "Alias": "homes_summary", "Columns": { "0": { "Name": "HomeID", "Index": -1, "NameInSource": "HomeID", "Alias": "HomeID", "Type": "System.Decimal" }, "1": { "Name": "ResponsibleIndividual", "Index": -1, "NameInSource": "ResponsibleIndividual", "Alias": "ResponsibleIndividual", "Type": "System.String" }, "2": { "Name": "PersonInCharge", "Index": -1, "NameInSource": "PersonInCharge", "Alias": "PersonInCharge", "Type": "System.String" }, "3": { "Name": "HomeName", "Index": -1, "NameInSource": "HomeName", "Alias": "HomeName", "Type": "System.String" }, "4": { "Name": "NumberOfBeds", "Index": -1, "NameInSource": "NumberOfBeds", "Alias": "NumberOfBeds", "Type": "System.String" }, "5": { "Name": "MinAgeGroup", "Index": -1, "NameInSource": "MinAgeGroup", "Alias": "MinAgeGroup", "Type": "System.String" }, "6": { "Name": "MaxAgeGroup", "Index": -1, "NameInSource": "MaxAgeGroup", "Alias": "MaxAgeGroup", "Type": "System.String" }, "7": { "Name": "Address", "Index": -1, "NameInSource": "Address", "Alias": "Address", "Type": "System.String" }, "8": { "Name": "Postcode", "Index": -1, "NameInSource": "Postcode", "Alias": "Postcode", "Type": "System.String" }, "9": { "Name": "Telephone", "Index": -1, "NameInSource": "Telephone", "Alias": "Telephone", "Type": "System.String" }, "10": { "Name": "Fax", "Index": -1, "NameInSource": "Fax", "Alias": "Fax", "Type": "System.String" }, "11": { "Name": "EmailAddress", "Index": -1, "NameInSource": "EmailAddress", "Alias": "EmailAddress", "Type": "System.String" }, "12": { "Name": "PATTestDate", "Index": -1, "NameInSource": "PATTestDate", "Alias": "PATTestDate", "Type": "System.String" }, "13": { "Name": "ElectricalCertificateDate", "Index": -1, "NameInSource": "ElectricalCertificateDate", "Alias": "ElectricalCertificateDate", "Type": "System.String" }, "14": { "Name": "GasCertificateDate", "Index": -1, "NameInSource": "GasCertificateDate", "Alias": "GasCertificateDate", "Type": "System.String" }, "15": { "Name": "OfstedURN", "Index": -1, "NameInSource": "OfstedURN", "Alias": "OfstedURN", "Type": "System.String" }, "16": { "Name": "OfstedRating", "Index": -1, "NameInSource": "OfstedRating", "Alias": "OfstedRating", "Type": "System.String" }, "17": { "Name": "OfstedRatingDate", "Index": -1, "NameInSource": "OfstedRatingDate", "Alias": "OfstedRatingDate", "Type": "System.String" }, "18": { "Name": "IsSecureAccommodation", "Index": -1, "NameInSource": "IsSecureAccommodation", "Alias": "IsSecureAccommodation", "Type": "System.String" }, "19": { "Name": "IsShortTermStay", "Index": -1, "NameInSource": "IsShortTermStay", "Alias": "IsShortTermStay", "Type": "System.String" }, "20": { "Name": "Status", "Index": -1, "NameInSource": "Status", "Alias": "Status", "Type": "System.String" }, "21": { "Name": "HomeAssignedColour", "Index": -1, "NameInSource": "HomeAssignedColour", "Alias": "HomeAssignedColour", "Type": "System.String" } }, "NameInSource": "ClearCare Solutions.homes_summary" } }, "Relations": { "0": { "Name": "Employee Home", "ChildColumns": { "0": "HomeID" }, "ParentColumns": { "0": "HomeID" }, "NameInSource": "Employee Home", "Alias": "Employee Home", "Key": "b102aa5b259c8b37b47652634eb1a1b3", "ParentSource": "homes_summary", "ChildSource": "employees_summary" }, "1": { "Name": "Employees (Employee Qualifications)", "ChildColumns": { "0": "EmployeeID" }, "ParentColumns": { "0": "EmployeeID" }, "NameInSource": "Employees (Employee Qualifications)", "Alias": "Employees (Employee Qualifications)", "Key": "dba79fa618832a9180f38d5be0cb003b", "ParentSource": "employees_summary", "ChildSource": "employee_qualifications" } } }, "Pages": { "0": { "Ident": "StiDashboard", "Name": "Dashboard", "Guid": "00fe7cf94a619d5bc40a94539327e2e6", "Brush": "solid:255,255,255", "Components": { "0": { "Ident": "StiPivotTableElement", "Name": "PivotTableElement1", "Guid": "f213c3c22d6e2eb24588b0eb52765944", "ClientRectangle": "245,0,1143,600", "Border": ";;;;", "Columns": { "0": { "Ident": "PivotColumn", "Key": "1972ea024fe5d6ef9091396ca0c67bb5", "Expression": "[employees_summary.Employee Name]", "Label": "Employee Name", "HorAlignment": "Center" } }, "Rows": { "0": { "Ident": "PivotRow", "Key": "9705b5ef0598d4505413209d18213070", "Expression": "replace(employee_qualifications.QualificationType,'Level 4 Diploma in Leadership and Management for Care Service and Health and Social Care','Level 4 Dip Leadership & Management') ", "Label": "QualificationType" }, "1": { "Ident": "PivotRow", "Key": "af004506f56775b05343dee9148b7eb4", "Expression": "employee_qualifications.QualificationName", "Label": "QualificationName" } }, "Summaries": { "0": { "Ident": "PivotSummary", "Key": "6ee2049b36248fbe307c3e66cb605efa", "Expression": "First(employee_qualifications.QualificationDate)", "Label": "QualificationDate", "HorAlignment": "Center" }, "1": { "Ident": "PivotSummary", "Key": "23813e81e1ee112546c32bce9ce8a0be", "Expression": "First(employee_qualifications.ExpiryDate)", "Label": "ExpiryDate", "HorAlignment": "Center" }, "2": { "Ident": "PivotSummary", "Key": "bfab407cf17919a54c28f3342a2ae162", "Expression": "First(employee_qualifications.RefresherDate)", "Label": "RefresherDate", "HorAlignment": "Center" } }, "Title": { "Text": "Training Matrix", "Visible": false, "Font": ";16;;" }, "PivotTableConditions": { "0": { "Ident": "StiPivotTableElementCondition", "KeyValueMeter": "qualification_status_id", "Condition": "GreaterThanOrEqualTo", "DataType": "Numeric", "Value": "1", "BackColor": "168,208,141", "Permissions": "Font, FontSize, FontStyleBold, FontStyleItalic, FontStyleUnderline, FontStyleStrikeout, TextColor, BackColor", "IconAlignment": "Left", "IconColor": "0,176,80", "Icon": "ThumbsUp" }, "1": { "Ident": "StiPivotTableElementCondition", "KeyValueMeter": "qualification_status_id", "Condition": "LessThanOrEqualTo", "DataType": "Numeric", "Value": "0", "Permissions": "Font, FontSize, FontStyleBold, FontStyleItalic, FontStyleUnderline, FontStyleStrikeout, TextColor, BackColor", "IconAlignment": "Left", "IconColor": "255,0,0", "Icon": "ThumbsDown" } }, "DashboardInteraction": { "Ident": "PivotTable", "OnHover": "ShowToolTip", "OnClick": "ApplyFilter", "HyperlinkDestination": "NewTab" } }, "1": { "Ident": "StiTreeViewElement", "Name": "TreeViewElement1", "Guid": "a5f8d8ecd181b5e3e55f76c36af73e82", "ClientRectangle": "0,0,245,120", "Border": ";;;;", "ShowAllValue": true, "KeyMeters": { "0": { "Ident": "KeyTreeViewMeter", "Key": "3eaf521182d15587cff1d448bf06d649", "Expression": "homes_summary.HomeName", "Label": "HomeName" } }, "Title": { "Text": "Tree View", "Visible": false } }, "2": { "Ident": "StiTreeViewElement", "Name": "TreeViewElement2", "Guid": "e5a7f5976b73a177ce8049ee3ef05cf5", "ClientRectangle": "0,120,245,480", "Border": ";;;;", "ShowAllValue": true, "KeyMeters": { "0": { "Ident": "KeyTreeViewMeter", "Key": "4fc177a2d594f607e6ad4893083a34e5", "Expression": "replace(employee_qualifications.QualificationType,'Level 4 Diploma in Leadership and Management for Care Service and Health and Social Care','Level 4 Dip Leadership & Management') ", "Label": "QualificationType" } }, "Title": { "Text": "Tree View", "Visible": false } } }, "Width": 1500, "Border": ";;2;;;;;solid:Black", "BackColor": "255,255,255" }, "1": { "Ident": "StiDashboard", "Name": "Dashboard1", "Guid": "5a85d097253726ad59ec2108a53aa946", "Brush": "solid:", "Components": { "0": { "Ident": "StiTableElement", "Name": "TableElement1", "Guid": "d591e7f516a23f60a701fd126c13097f", "ClientRectangle": "260,0,940,600", "Border": ";;;;", "Columns": { "0": { "Ident": "DimensionColumn", "Key": "ac7bcdfed3ffe22fc44f9a77a67056d3", "Expression": "employee_qualifications.EmployeeName", "Label": "EmployeeName", "DashboardInteraction": { "Ident": "TableColumn", "OnHover": "None", "OnClick": "None", "HyperlinkDestination": "NewTab" } }, "1": { "Ident": "DimensionColumn", "Key": "5db7144801e5444e73c02cb1363facb7", "Expression": "replace(employee_qualifications.QualificationType,'Level 4 Diploma in Leadership and Management for Care Service and Health and Social Care','Level 4 Dip Leadership & Management') ", "Label": "QualificationType", "DashboardInteraction": { "Ident": "TableColumn", "OnHover": "None", "OnClick": "None", "HyperlinkDestination": "NewTab" } }, "2": { "Ident": "DimensionColumn", "Key": "b44105afab8716ada7b6e40711c193e4", "Expression": "employee_qualifications.QualificationName", "Label": "QualificationName", "DashboardInteraction": { "Ident": "TableColumn", "OnHover": "None", "OnClick": "None", "HyperlinkDestination": "NewTab" } }, "3": { "Ident": "DimensionColumn", "Key": "0a494a10f4add40485d256156533734c", "Expression": "employee_qualifications.QualificationDate", "Label": "QualificationDate", "TextFormat": { "Ident": "StiDateFormatService" }, "DashboardInteraction": { "Ident": "TableColumn", "OnHover": "None", "OnClick": "None", "HyperlinkDestination": "NewTab" } }, "4": { "Ident": "DimensionColumn", "Key": "2bd3749b083a9b10beeb54dd13ed2bca", "Expression": "employee_qualifications.ExpiryDate", "Label": "ExpiryDate", "TextFormat": { "Ident": "StiDateFormatService" }, "DashboardInteraction": { "Ident": "TableColumn", "OnHover": "None", "OnClick": "None", "HyperlinkDestination": "NewTab" } }, "5": { "Ident": "DimensionColumn", "Key": "daf8d991c2c9a185bd95e7a08e1706a5", "Expression": "employee_qualifications.RefresherDate", "Label": "RefresherDate", "TextFormat": { "Ident": "StiDateFormatService" }, "DashboardInteraction": { "Ident": "TableColumn", "OnHover": "None", "OnClick": "None", "HyperlinkDestination": "NewTab" } } }, "HeaderFont": ";10;;", "FooterFont": ";10;;", "Title": { "Text": "Table", "Visible": false }, "DashboardInteraction": { "Ident": "Table", "OnHover": "ShowToolTip", "OnClick": "ApplyFilter", "HyperlinkDestination": "NewTab" } }, "1": { "Ident": "StiTreeViewElement", "Name": "TreeViewElement3", "Guid": "16698c9dc2e60e8f112bda473ea2cabf", "ClientRectangle": "0,0,260,120", "Border": ";;;;", "ShowAllValue": true, "KeyMeters": { "0": { "Ident": "KeyTreeViewMeter", "Key": "41bf8682563e6d8272221d72d2a51366", "Expression": "homes_summary.HomeName", "Label": "HomeName" } }, "Title": { "Text": "Tree View", "Visible": false } }, "2": { "Ident": "StiTreeViewElement", "Name": "TreeViewElement4", "Guid": "1d3f45f2ae4469e71831caea97f78136", "ClientRectangle": "0,120,260,200", "Border": ";;;;", "ShowAllValue": true, "KeyMeters": { "0": { "Ident": "KeyTreeViewMeter", "Key": "9ed6d2f899719bf9f5715da3276702e9", "Expression": "employee_qualifications.EmployeeName", "Label": "EmployeeName" } }, "Title": { "Text": "Tree View", "Visible": false } }, "3": { "Ident": "StiTreeViewElement", "Name": "TreeViewElement5", "Guid": "2a2b1be49a43edcd5efa9c58aa53ff68", "ClientRectangle": "0,320,260,280", "Border": ";;;;", "ShowAllValue": true, "KeyMeters": { "0": { "Ident": "KeyTreeViewMeter", "Key": "f71508073614f6c71a646f9bfe3a1fa1", "Expression": "replace(employee_qualifications.QualificationType,'Level 4 Diploma in Leadership and Management for Care Service and Health and Social Care','Level 4 Dip Leadership & Management') ", "Label": "QualificationType" } }, "Title": { "Text": "Tree View", "Visible": false } } }, "Border": ";;2;;;;;solid:Black" } } }