TESTING SITE
Skeleton Entity Data Set — Version 03.00
The full specification for SKL 03.00 can be found on the documentation site.
Main Content
SKL version 03.00: Rules
| Name | Class | Priority | Bulk | Message | Mark | Description | SQL |
|---|---|---|---|---|---|---|---|
| HrGenDtMissing | Missing | High | No | Missing data - GenDt $GenDt.q | HR.GenDt | Missing data - Data File Generation Date (GenDt) | select State, GenDt from HR where GenDt is null |
| StStateNameMissing | Missing | High | No | Missing data - StateName $StateName.q | ST.StateName | Missing data - State/Territory Name (StateName) | select State, StateName from ST where StateName is null |
| RegRegNameMissing | Missing | High | No | Missing data - RegName $RegName.q | REG.RegName | Missing data - Region Name (RegName) | select State, RegId, RegName from REG where RegName is null |
| OrgOrgNameMissing | Missing | High | No | Missing data - OrgName $OrgName.q | ORG.OrgName | Missing data - Organisation Name (OrgName) | select State, RegId, OrgId, OrgName from ORG where OrgName is null |
| HospSectorMissing | Missing | High | No | Missing data - Sector $Sector.q | HOSP.Sector | Missing data - Sector (Sector) | select State, RegId, OrgId, HospId, Sector from HOSP where Sector is null |
| HospHospNameMissing | Missing | High | No | Missing data - HospName $HospName.q | HOSP.HospName | Missing data - Hospital Name (HospName) | select State, RegId, OrgId, HospId, HospName from HOSP where HospName is null |
| ClusClusNameMissing | Missing | High | No | Missing data - ClusName $ClusName.q | CLUS.ClusName | Missing data - Service Unit Cluster Name (ClusName) | select State, RegId, OrgId, ClusId, ClusName from CLUS where ClusName is null |
| AdmiTargetPopMissing | Missing | High | No | Missing data - TargetPop $TargetPop.q | ADMI.TargetPop | Missing data - Target Population (TargetPop) | select State, RegId, OrgId, HospId, AdmiId, TargetPop from ADMI where TargetPop is null |
| AdmiAdmiNameMissing | Missing | High | No | Missing data - AdmiName $AdmiName.q | ADMI.AdmiName | Missing data - Admitted Patient Service Unit Name (AdmiName) | select State, RegId, OrgId, HospId, AdmiId, AdmiName from ADMI where AdmiName is null |
| AmbuTargetPopMissing | Missing | High | No | Missing data - TargetPop $TargetPop.q | AMBU.TargetPop | Missing data - Target Population (TargetPop) | select State, RegId, OrgId, ClusId, AmbuId, TargetPop from AMBU where TargetPop is null |
| AmbuSectorMissing | Missing | High | No | Missing data - Sector $Sector.q | AMBU.Sector | Missing data - Sector (Sector) | select State, RegId, OrgId, ClusId, AmbuId, Sector from AMBU where Sector is null |
| AmbuAmbuNameMissing | Missing | High | No | Missing data - AmbuName $AmbuName.q | AMBU.AmbuName | Missing data - Ambulatory Service Unit Name (AmbuName) | select State, RegId, OrgId, ClusId, AmbuId, AmbuName from AMBU where AmbuName is null |
| ResiTargetPopMissing | Missing | High | No | Missing data - TargetPop $TargetPop.q | RESI.TargetPop | Missing data - Target Population (TargetPop) | select State, RegId, OrgId, ClusId, ResiId, TargetPop from RESI where TargetPop is null |
| ResiSectorMissing | Missing | High | No | Missing data - Sector $Sector.q | RESI.Sector | Missing data - Sector (Sector) | select State, RegId, OrgId, ClusId, ResiId, Sector from RESI where Sector is null |
| ResiResiNameMissing | Missing | High | No | Missing data - ResiName $ResiName.q | RESI.ResiName | Missing data - Residential Service Unit Name (ResiName) | select State, RegId, OrgId, ClusId, ResiId, ResiName from RESI where ResiName is null |
| OrgBarren | Barren | High | No | ORG has no CLUS or HOSP records | ORG | Barren Organisation - has no associated Hospitals or Service Unit Clusters | select State, RegId, OrgId from OrgHospCount join OrgClusCount using(State, RegId, OrgId) where OrgHospCount.Count = 0 and OrgClusCount.Count = 0 |
| ClusBarren | Barren | High | No | CLUS has no AMBU or RESI records | CLUS | Barren Cluster - has no associated Residential or Ambulatory service units | select State, RegId, OrgId, ClusId from ClusAmbuCount join ClusResiCount using(State, RegId, OrgId, ClusId) where ClusAmbuCount.Count = 0 and ClusResiCount.Count = 0 |
| RegRenamed | Historical | High | No | Reg renamed from $hist_name.qt to $RegName.qt | REG.RegName | Region Renamed - Region Name differs between historical and current data | select State, RegId, REG.RegName, hist_entity.RegName as hist_name from REG join hist.REG as hist_entity using(State, RegId) where not sloppy_match(REG.RegName, hist_entity.RegName) |
| OrgRenamed | Historical | High | No | Org renamed from $hist_name.qt to $OrgName.qt | ORG.OrgName | Organisation Renamed - Organisation Name differs between historical and current data | select State, RegId, OrgId, ORG.OrgName, hist_entity.OrgName as hist_name from ORG join hist.ORG as hist_entity using(State, RegId, OrgId) where not sloppy_match(ORG.OrgName, hist_entity.OrgName) |
| HospRenamed | Historical | High | No | Hosp renamed from $hist_name.qt to $HospName.qt | HOSP.HospName | Hospital Renamed - Hospital Name differs between historical and current data | select State, RegId, OrgId, HospId, HOSP.HospName, hist_entity.HospName as hist_name from HOSP join hist.HOSP as hist_entity using(State, RegId, OrgId, HospId) where not sloppy_match(HOSP.HospName, hist_entity.HospName) |
| ClusRenamed | Historical | High | No | Clus renamed from $hist_name.qt to $ClusName.qt | CLUS.ClusName | Service Unit Cluster Renamed - Service Unit Cluster Name differs between historical and current data | select State, RegId, OrgId, ClusId, CLUS.ClusName, hist_entity.ClusName as hist_name from CLUS join hist.CLUS as hist_entity using(State, RegId, OrgId, ClusId) where not sloppy_match(CLUS.ClusName, hist_entity.ClusName) |
| AdmiRenamed | Historical | High | No | Admi renamed from $hist_name.qt to $AdmiName.qt | ADMI.AdmiName | Admitted Patient Service Unit Renamed - Admitted Patient Service Unit Name differs between historical and current data | select State, RegId, OrgId, HospId, AdmiId, ADMI.AdmiName, hist_entity.AdmiName as hist_name from ADMI join hist.ADMI as hist_entity using(State, RegId, OrgId, HospId, AdmiId) where not sloppy_match(ADMI.AdmiName, hist_entity.AdmiName) |
| ResiRenamed | Historical | High | No | Resi renamed from $hist_name.qt to $ResiName.qt | RESI.ResiName | Residential Service Unit Renamed - Residential Service Unit Name differs between historical and current data | select State, RegId, OrgId, ClusId, ResiId, RESI.ResiName, hist_entity.ResiName as hist_name from RESI join hist.RESI as hist_entity using(State, RegId, OrgId, ClusId, ResiId) where not sloppy_match(RESI.ResiName, hist_entity.ResiName) |
| AmbuRenamed | Historical | High | No | Ambu renamed from $hist_name.qt to $AmbuName.qt | AMBU.AmbuName | Ambulatory Service Unit Renamed - Ambulatory Service Unit Name differs between historical and current data | select State, RegId, OrgId, ClusId, AmbuId, AMBU.AmbuName, hist_entity.AmbuName as hist_name from AMBU join hist.AMBU as hist_entity using(State, RegId, OrgId, ClusId, AmbuId) where not sloppy_match(AMBU.AmbuName, hist_entity.AmbuName) |
| HospSectorChanged | Historical | High | No | Hospital Sector changed from $hist_Sector to $Sector | HOSP.Sector | Sector Changed - Sector value for Hospital differs between historical and current data | select State, RegId, OrgId, HospId, HOSP.Sector, hist_HOSP.Sector as hist_Sector from HOSP join hist.HOSP as hist_HOSP using(State, RegId, OrgId, HospId) where HOSP.Sector != hist_HOSP.Sector |
| AdmiTargetPopChanged | Historical | High | No | Admitted Patient Service Unit TargetPop changed from $hist_TargetPop to $TargetPop | ADMI.TargetPop | Target Population Changed - Target Population value for Admitted Patient Service Unit differs between historical and current data | select State, RegId, OrgId, HospId, AdmiId, ADMI.TargetPop, hist_ADMI.TargetPop as hist_TargetPop from ADMI join hist.ADMI as hist_ADMI using(State, RegId, OrgId, HospId, AdmiId) where ADMI.TargetPop != hist_ADMI.TargetPop |
| ResiTargetPopChanged | Historical | High | No | Residential Service Unit TargetPop changed from $hist_TargetPop to $TargetPop | RESI.TargetPop | Target Population Changed - Target Population value for Residential Service Unit differs between historical and current data | select State, RegId, OrgId, ClusId, ResiId, RESI.TargetPop, hist_RESI.TargetPop as hist_TargetPop from RESI join hist.RESI as hist_RESI using(State, RegId, OrgId, ClusId, ResiId) where RESI.TargetPop != hist_RESI.TargetPop |
| ResiSectorChanged | Historical | High | No | Residential Service Unit Sector changed from $hist_Sector to $Sector | RESI.Sector | Sector Changed - Sector value for Residential Service Unit differs between historical and current data | select State, RegId, OrgId, ClusId, ResiId, RESI.Sector, hist_RESI.Sector as hist_Sector from RESI join hist.RESI as hist_RESI using(State, RegId, OrgId, ClusId, ResiId) where RESI.Sector != hist_RESI.Sector |
| AmbuTargetPopChanged | Historical | High | No | Ambulatory Service Unit TargetPop changed from $hist_TargetPop to $TargetPop | AMBU.TargetPop | Target Population Changed - Target Population value for Ambulatory Service Unit differs between historical and current data | select State, RegId, OrgId, ClusId, AmbuId, AMBU.TargetPop, hist_AMBU.TargetPop as hist_TargetPop from AMBU join hist.AMBU as hist_AMBU using(State, RegId, OrgId, ClusId, AmbuId) where AMBU.TargetPop != hist_AMBU.TargetPop |
| AmbuSectorChanged | Historical | High | No | Ambulatory Service Unit Sector changed from $hist_Sector to $Sector | AMBU.Sector | Sector Changed - Sector value for Ambulatory Service Unit differs between historical and current data | select State, RegId, OrgId, ClusId, AmbuId, AMBU.Sector, hist_AMBU.Sector as hist_Sector from AMBU join hist.AMBU as hist_AMBU using(State, RegId, OrgId, ClusId, AmbuId) where AMBU.Sector != hist_AMBU.Sector |
| RegOpened | Skeleton | High | No | Reg opened, $name (Id: $entityId) not in historical data | Region Opened - A matching Region was not found in the historical data | ||
| RegClosed | Skeleton | High | No | Reg closed, historical $hist_name (Id: $entityId) no longer exists | Region Closed - A matching historical Region was not found in the current data | ||
| OrgOpened | Skeleton | High | No | Org opened, $name (Id: $entityId) not in historical data | Organisation Opened - A matching Organisation was not found in the historical data | ||
| OrgClosed | Skeleton | High | No | Org closed, historical $hist_name (Id: $entityId) no longer exists | Organisation Closed - A matching historical Organisation was not found in the current data | ||
| HospOpened | Skeleton | High | No | Hosp opened, $name (Id: $entityId) not in historical data | Hospital Opened - A matching Hospital was not found in the historical data | ||
| HospClosed | Skeleton | High | No | Hosp closed, historical $hist_name (Id: $entityId) no longer exists | Hospital Closed - A matching historical Hospital was not found in the current data | ||
| ClusOpened | Skeleton | High | No | Clus opened, $name (Id: $entityId) not in historical data | Service Unit Cluster Opened - A matching Service Unit Cluster was not found in the historical data | ||
| ClusClosed | Skeleton | High | No | Clus closed, historical $hist_name (Id: $entityId) no longer exists | Service Unit Cluster Closed - A matching historical Service Unit Cluster was not found in the current data | ||
| AdmiOpened | Skeleton | High | No | Admi opened, $name (Id: $entityId) not in historical data | Admitted Patient Service Unit Opened - A matching Admitted Patient Service Unit was not found in the historical data | ||
| AdmiClosed | Skeleton | High | No | Admi closed, historical $hist_name (Id: $entityId) no longer exists | Admitted Patient Service Unit Closed - A matching historical Admitted Patient Service Unit was not found in the current data | ||
| ResiOpened | Skeleton | High | No | Resi opened, $name (Id: $entityId) not in historical data | Residential Service Unit Opened - A matching Residential Service Unit was not found in the historical data | ||
| ResiClosed | Skeleton | High | No | Resi closed, historical $hist_name (Id: $entityId) no longer exists | Residential Service Unit Closed - A matching historical Residential Service Unit was not found in the current data | ||
| AmbuOpened | Skeleton | High | No | Ambu opened, $name (Id: $entityId) not in historical data | Ambulatory Service Unit Opened - A matching Ambulatory Service Unit was not found in the historical data | ||
| AmbuClosed | Skeleton | High | No | Ambu closed, historical $hist_name (Id: $entityId) no longer exists | Ambulatory Service Unit Closed - A matching historical Ambulatory Service Unit was not found in the current data |