Skeleton Entity Data Set — Version 04.00
The full specification for SKL 04.00 can be found on the documentation site.
Main Content
SKL version 04.00: Virtual Elements
| Name | Base | Title | SQL |
|---|---|---|---|
| OrgClusCount | ORG | CLUS Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from CLUS group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgHospCount | ORG | HOSP Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from HOSP group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| ClusAmbuCount | CLUS | AMBU Count at CLUS Level | select State, RegId, OrgId, ClusId, coalesce(Count, 0) as Count from CLUS left join ( select State, RegId, OrgId, ClusId, count(*) as Count from AMBU group by State, RegId, OrgId, ClusId ) as tmpinner using (State, RegId, OrgId, ClusId) |
| ClusResiCount | CLUS | RESI Count at CLUS Level | select State, RegId, OrgId, ClusId, coalesce(Count, 0) as Count from CLUS left join ( select State, RegId, OrgId, ClusId, count(*) as Count from RESI group by State, RegId, OrgId, ClusId ) as tmpinner using (State, RegId, OrgId, ClusId) |
| OrgAdmiCount | ORG | ADMI Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from ADMI group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgAdmiCACount | ORG | ADMI Child and adolescent Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from ADMI where TargetPop = '1' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgAdmiOldCount | ORG | ADMI Older person Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from ADMI where TargetPop = '2' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgAdmiForCount | ORG | ADMI Forensic Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from ADMI where TargetPop = '3' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgAdmiGenCount | ORG | ADMI General Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from ADMI where TargetPop = '4' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgAdmiYthCount | ORG | ADMI Youth Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from ADMI where TargetPop = '5' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgResiCount | ORG | RESI Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from RESI group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgResiCACount | ORG | RESI Child and adolescent Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from RESI where TargetPop = '1' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgResiOldCount | ORG | RESI Older person Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from RESI where TargetPop = '2' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgResiForCount | ORG | RESI Forensic Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from RESI where TargetPop = '3' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgResiGenCount | ORG | RESI General Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from RESI where TargetPop = '4' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgResiYthCount | ORG | RESI Youth Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from RESI where TargetPop = '5' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgAmbuCount | ORG | AMBU Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from AMBU group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgAmbuCACount | ORG | AMBU Child and adolescent Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from AMBU where TargetPop = '1' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgAmbuOldCount | ORG | AMBU Older person Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from AMBU where TargetPop = '2' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgAmbuForCount | ORG | AMBU Forensic Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from AMBU where TargetPop = '3' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgAmbuGenCount | ORG | AMBU General Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from AMBU where TargetPop = '4' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| OrgAmbuYthCount | ORG | AMBU Youth Count at ORG Level | select State, RegId, OrgId, coalesce(Count, 0) as Count from ORG left join ( select State, RegId, OrgId, count(*) as Count from AMBU where TargetPop = '5' group by State, RegId, OrgId ) as tmpinner using (State, RegId, OrgId) |
| RegAdmiCount | REG | ADMI Count at REG Level | select State, RegId, coalesce(Count, 0) as Count from REG left join ( select State, RegId, count(*) as Count from ADMI group by State, RegId ) as tmpinner using (State, RegId) |
| RegResiCount | REG | RESI Count at REG Level | select State, RegId, coalesce(Count, 0) as Count from REG left join ( select State, RegId, count(*) as Count from RESI group by State, RegId ) as tmpinner using (State, RegId) |
| RegAmbuCount | REG | AMBU Count at REG Level | select State, RegId, coalesce(Count, 0) as Count from REG left join ( select State, RegId, count(*) as Count from AMBU group by State, RegId ) as tmpinner using (State, RegId) |
| AdmiAdmiCount | ADMI | ADMI Count at ADMI Level | select State, RegId, OrgId, HospId, AdmiId, coalesce(Count, 0) as Count from ADMI left join ( select State, RegId, OrgId, HospId, AdmiId, count(*) as Count from ADMI group by State, RegId, OrgId, HospId, AdmiId ) as tmpinner using (State, RegId, OrgId, HospId, AdmiId) |
| ResiResiCount | RESI | RESI Count at RESI Level | select State, RegId, OrgId, ClusId, ResiId, coalesce(Count, 0) as Count from RESI left join ( select State, RegId, OrgId, ClusId, ResiId, count(*) as Count from RESI group by State, RegId, OrgId, ClusId, ResiId ) as tmpinner using (State, RegId, OrgId, ClusId, ResiId) |
| AmbuAmbuCount | AMBU | AMBU Count at AMBU Level | select State, RegId, OrgId, ClusId, AmbuId, coalesce(Count, 0) as Count from AMBU left join ( select State, RegId, OrgId, ClusId, AmbuId, count(*) as Count from AMBU group by State, RegId, OrgId, ClusId, AmbuId ) as tmpinner using (State, RegId, OrgId, ClusId, AmbuId) |
| HospAdmiCount | HOSP | ADMI Count at HOSP Level | select State, RegId, OrgId, HospId, coalesce(Count, 0) as Count from HOSP left join ( select State, RegId, OrgId, HospId, count(*) as Count from ADMI group by State, RegId, OrgId, HospId ) as tmpinner using (State, RegId, OrgId, HospId) |
| OrgHasClus | ORG | CLUS below ORG | select State, RegId, OrgId, Count from OrgClusCount where Count > 0 |
| OrgHasHosp | ORG | HOSP below ORG | select State, RegId, OrgId, Count from OrgHospCount where Count > 0 |
| ClusHasAmbu | CLUS | AMBU below CLUS | select State, RegId, OrgId, ClusId, Count from ClusAmbuCount where Count > 0 |
| ClusHasResi | CLUS | RESI below CLUS | select State, RegId, OrgId, ClusId, Count from ClusResiCount where Count > 0 |
| OrgHasAdmi | ORG | ADMI below ORG | select State, RegId, OrgId, Count from OrgAdmiCount where Count > 0 |
| OrgHasAdmiCA | ORG | ADMI Child and adolescent below ORG | select State, RegId, OrgId, Count from OrgAdmiCACount where Count > 0 |
| OrgHasAdmiOld | ORG | ADMI Older person below ORG | select State, RegId, OrgId, Count from OrgAdmiOldCount where Count > 0 |
| OrgHasAdmiFor | ORG | ADMI Forensic below ORG | select State, RegId, OrgId, Count from OrgAdmiForCount where Count > 0 |
| OrgHasAdmiGen | ORG | ADMI General below ORG | select State, RegId, OrgId, Count from OrgAdmiGenCount where Count > 0 |
| OrgHasAdmiYth | ORG | ADMI Youth below ORG | select State, RegId, OrgId, Count from OrgAdmiYthCount where Count > 0 |
| OrgHasResi | ORG | RESI below ORG | select State, RegId, OrgId, Count from OrgResiCount where Count > 0 |
| OrgHasResiCA | ORG | RESI Child and adolescent below ORG | select State, RegId, OrgId, Count from OrgResiCACount where Count > 0 |
| OrgHasResiOld | ORG | RESI Older person below ORG | select State, RegId, OrgId, Count from OrgResiOldCount where Count > 0 |
| OrgHasResiFor | ORG | RESI Forensic below ORG | select State, RegId, OrgId, Count from OrgResiForCount where Count > 0 |
| OrgHasResiGen | ORG | RESI General below ORG | select State, RegId, OrgId, Count from OrgResiGenCount where Count > 0 |
| OrgHasResiYth | ORG | RESI Youth below ORG | select State, RegId, OrgId, Count from OrgResiYthCount where Count > 0 |
| OrgHasAmbu | ORG | AMBU below ORG | select State, RegId, OrgId, Count from OrgAmbuCount where Count > 0 |
| OrgHasAmbuCA | ORG | AMBU Child and adolescent below ORG | select State, RegId, OrgId, Count from OrgAmbuCACount where Count > 0 |
| OrgHasAmbuOld | ORG | AMBU Older person below ORG | select State, RegId, OrgId, Count from OrgAmbuOldCount where Count > 0 |
| OrgHasAmbuFor | ORG | AMBU Forensic below ORG | select State, RegId, OrgId, Count from OrgAmbuForCount where Count > 0 |
| OrgHasAmbuGen | ORG | AMBU General below ORG | select State, RegId, OrgId, Count from OrgAmbuGenCount where Count > 0 |
| OrgHasAmbuYth | ORG | AMBU Youth below ORG | select State, RegId, OrgId, Count from OrgAmbuYthCount where Count > 0 |
| RegHasAdmi | REG | ADMI below REG | select State, RegId, Count from RegAdmiCount where Count > 0 |
| RegHasResi | REG | RESI below REG | select State, RegId, Count from RegResiCount where Count > 0 |
| RegHasAmbu | REG | AMBU below REG | select State, RegId, Count from RegAmbuCount where Count > 0 |
| AdmiHasAdmi | ADMI | ADMI below ADMI | select State, RegId, OrgId, HospId, AdmiId, Count from AdmiAdmiCount where Count > 0 |
| ResiHasResi | RESI | RESI below RESI | select State, RegId, OrgId, ClusId, ResiId, Count from ResiResiCount where Count > 0 |
| AmbuHasAmbu | AMBU | AMBU below AMBU | select State, RegId, OrgId, ClusId, AmbuId, Count from AmbuAmbuCount where Count > 0 |
| HospHasAdmi | HOSP | ADMI below HOSP | select State, RegId, OrgId, HospId, Count from HospAdmiCount where Count > 0 |