Name: ODH_Local_Hospitals_2023

Display Field: Business_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9434993.42194462
YMin: 4642032.25689457
XMax: -8970844.91643558
YMax: 5151653.11580556
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,192,211,255],"toColor":[252,192,211,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[183,252,179,255],"toColor":[183,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,246,252,255],"toColor":[187,246,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,179,252,255],"toColor":[194,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,236,192,255],"toColor":[252,236,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,217,252,255],"toColor":[210,217,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,252,221,255],"toColor":[215,252,221,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,238,255],"toColor":[252,179,238,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,218,215,255],"toColor":[252,218,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,188,179,255],"toColor":[252,188,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[229,252,182,255],"toColor":[229,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[241,210,252,255],"toColor":[241,210,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,211,179,255],"toColor":[252,211,179,255]}]}},"type":"uniqueValue","field1":"New_Active_Facility","fieldDelimiter":",","uniqueValueInfos":[{"value":"Active","symbol":{"color":[76,230,0,255],"size":7.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":0.69750000000000012,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Active"},{"value":"Inactive","symbol":{"color":[255,0,0,255],"size":7.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":0.69750000000000012,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Inactive"}]},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: New_Active_Facility

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Match_type (type: esriFieldTypeString, alias: Match_type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Match_addr (type: esriFieldTypeString, alias: Match_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Business_Type (type: esriFieldTypeString, alias: Business Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Business_Name (type: esriFieldTypeString, alias: Business Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Address_Line_1 (type: esriFieldTypeString, alias: Location Address Line 1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Address_Line_2 (type: esriFieldTypeString, alias: Location Address Line 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_City (type: esriFieldTypeString, alias: Location City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_State (type: esriFieldTypeString, alias: Location State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Zip (type: esriFieldTypeString, alias: Location Zip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_County (type: esriFieldTypeString, alias: Location County, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VoicePhone (type: esriFieldTypeString, alias: VoicePhone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EmailAddress (type: esriFieldTypeString, alias: EmailAddress, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RPLastName (type: esriFieldTypeString, alias: RPLastName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RPFirstName (type: esriFieldTypeString, alias: RPFirstName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RPMiddleName (type: esriFieldTypeString, alias: RPMiddleName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RPSuffix (type: esriFieldTypeString, alias: RPSuffix, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RPEmail (type: esriFieldTypeString, alias: RPEmail, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Dispenses_Naloxone (type: esriFieldTypeString, alias: Dispenses Naloxone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CredentialStatus (type: esriFieldTypeString, alias: CredentialStatus, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CredentialStatusReason (type: esriFieldTypeString, alias: CredentialStatusReason, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• License_Number (type: esriFieldTypeString, alias: License Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Subcategory_Code (type: esriFieldTypeString, alias: Subcategory Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_Address_Line_3 (type: esriFieldTypeString, alias: Location Address Line 3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LocationLat (type: esriFieldTypeDouble, alias: LocationLat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocationLong (type: esriFieldTypeDouble, alias: LocationLong, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MailingAddressLine1 (type: esriFieldTypeString, alias: MailingAddressLine1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingAddressLine2 (type: esriFieldTypeString, alias: MailingAddressLine2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingAddressLine3 (type: esriFieldTypeString, alias: MailingAddressLine3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingCity (type: esriFieldTypeString, alias: MailingCity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingState (type: esriFieldTypeString, alias: MailingState, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingZip (type: esriFieldTypeString, alias: MailingZip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FaxPhone (type: esriFieldTypeString, alias: FaxPhone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• License_Prefix (type: esriFieldTypeString, alias: License Prefix, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Ohio_Drug_Category (type: esriFieldTypeString, alias: Ohio Drug Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Business_Type_1 (type: esriFieldTypeString, alias: Business Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PracticeTypeDescription (type: esriFieldTypeString, alias: PracticeTypeDescription, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DateofFirstLicensure (type: esriFieldTypeString, alias: DateofFirstLicensure, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EffectiveDate (type: esriFieldTypeString, alias: EffectiveDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ExpirationDate (type: esriFieldTypeString, alias: ExpirationDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LegalFiles (type: esriFieldTypeString, alias: LegalFiles, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RPCredentialTypePrefix (type: esriFieldTypeString, alias: RPCredentialTypePrefix, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FacilityID (type: esriFieldTypeString, alias: FacilityID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• StateID (type: esriFieldTypeString, alias: StateID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Abbreviation (type: esriFieldTypeString, alias: Abbreviation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MedicareID (type: esriFieldTypeString, alias: MedicareID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MedicaidID (type: esriFieldTypeInteger, alias: MedicaidID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClosedDate (type: esriFieldTypeDate, alias: ClosedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LicensedBedTotal (type: esriFieldTypeString, alias: LicensedBedTotal, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OpenDate (type: esriFieldTypeDate, alias: OpenDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BedEffectiveDate (type: esriFieldTypeString, alias: BedEffectiveDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CertifiedBedTotal (type: esriFieldTypeString, alias: CertifiedBedTotal, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SortOrder (type: esriFieldTypeInteger, alias: SortOrder, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HC_Name (type: esriFieldTypeString, alias: HC_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HC_Phone (type: esriFieldTypeString, alias: HC_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HC_Email (type: esriFieldTypeString, alias: HC_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MD_Name (type: esriFieldTypeString, alias: MD_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MD_Phone (type: esriFieldTypeString, alias: MD_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MD_Email (type: esriFieldTypeString, alias: MD_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AD_Name (type: esriFieldTypeString, alias: AD_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AD_Phone (type: esriFieldTypeString, alias: AD_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AD_Email (type: esriFieldTypeString, alias: AD_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EHD_Name (type: esriFieldTypeString, alias: EHD_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EHD_Phone (type: esriFieldTypeString, alias: EHD_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EHD_Email (type: esriFieldTypeString, alias: EHD_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ND_Name (type: esriFieldTypeString, alias: ND_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ND_Phone (type: esriFieldTypeString, alias: ND_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ND_Email (type: esriFieldTypeString, alias: ND_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VS_Name (type: esriFieldTypeString, alias: VS_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VS_Phone (type: esriFieldTypeString, alias: VS_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VS_Email (type: esriFieldTypeString, alias: VS_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FO_Name (type: esriFieldTypeString, alias: FO_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FO_Phone (type: esriFieldTypeString, alias: FO_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FO_Email (type: esriFieldTypeString, alias: FO_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PIO_Name (type: esriFieldTypeString, alias: PIO_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PIO_Phone (type: esriFieldTypeString, alias: PIO_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PIO_Email (type: esriFieldTypeString, alias: PIO_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EPI_Name (type: esriFieldTypeString, alias: EPI_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EPI_Phone (type: esriFieldTypeString, alias: EPI_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EPI_Email (type: esriFieldTypeString, alias: EPI_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ERC_Name (type: esriFieldTypeString, alias: ERC_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ERC_Phone (type: esriFieldTypeString, alias: ERC_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ERC_Email (type: esriFieldTypeString, alias: ERC_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AHC_Name (type: esriFieldTypeString, alias: AHC_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AHC_Phone (type: esriFieldTypeString, alias: AHC_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AHC_Email (type: esriFieldTypeString, alias: AHC_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DHC_Name (type: esriFieldTypeString, alias: DHC_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DHC_Phone (type: esriFieldTypeString, alias: DHC_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DHC_Email (type: esriFieldTypeString, alias: DHC_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DR_Name (type: esriFieldTypeString, alias: DR_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DR_Phone (type: esriFieldTypeString, alias: DR_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DR_Email (type: esriFieldTypeString, alias: DR_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AC_Name (type: esriFieldTypeString, alias: AC_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AC_Phone (type: esriFieldTypeString, alias: AC_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AC_Email (type: esriFieldTypeString, alias: AC_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HE_Name (type: esriFieldTypeString, alias: HE_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HE_Phone (type: esriFieldTypeString, alias: HE_Phone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HE_Email (type: esriFieldTypeString, alias: HE_Email, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Population (type: esriFieldTypeString, alias: Population, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LHDId (type: esriFieldTypeString, alias: LHDId, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Business_Type_Category (type: esriFieldTypeInteger, alias: Business Type Category, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hospital_Type (type: esriFieldTypeString, alias: Hospital Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NATCEP_Type (type: esriFieldTypeString, alias: NATCEP Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LHDType (type: esriFieldTypeString, alias: LHDType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LHDCountyCity (type: esriFieldTypeString, alias: LHDCountyCity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LHDStatus (type: esriFieldTypeString, alias: LHDStatus, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LHDDistrict (type: esriFieldTypeString, alias: LHDDistrict, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ContractingWith (type: esriFieldTypeString, alias: ContractingWith, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Website (type: esriFieldTypeString, alias: Website, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BusinessTypeCategoryDesc (type: esriFieldTypeString, alias: BusinessTypeCategoryDesc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HospitalTypeDesc (type: esriFieldTypeString, alias: HospitalTypeDesc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NATCEPTypeDesc (type: esriFieldTypeString, alias: NATCEPTypeDesc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Data_Source (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CombinedWith (type: esriFieldTypeString, alias: CombinedWith, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LHDIdOld (type: esriFieldTypeString, alias: LHDIdOld, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Active_Facility (type: esriFieldTypeString, alias: Active Facility 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• New_Active_Facility (type: esriFieldTypeString, alias: Active Facility, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Types:

ID: Active
Name: Active
Domains:

Templates:

Name: Active
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Active_Facility:
• LHDIdOld:
• Business_Type:
• Business_Name:
• Location_Address_Line_1:
• Location_Address_Line_2:
• Location_City:
• Location_State:
• Location_Zip:
• Location_County:
• VoicePhone:
• EmailAddress:
• RPLastName:
• RPFirstName:
• RPMiddleName:
• RPSuffix:
• RPEmail:
• Dispenses_Naloxone:
• CredentialStatus:
• CredentialStatusReason:
• License_Number:
• Subcategory_Code:
• Location_Address_Line_3:
• MailingAddressLine1:
• MailingAddressLine2:
• MailingAddressLine3:
• MailingCity:
• MailingState:
• MailingZip:
• FaxPhone:
• License_Prefix:
• Ohio_Drug_Category:
• Business_Type_1:
• PracticeTypeDescription:
• DateofFirstLicensure:
• EffectiveDate:
• ExpirationDate:
• LegalFiles:
• RPCredentialTypePrefix:
• FacilityID:
• StateID:
• Abbreviation:
• MedicareID:
• LicensedBedTotal:
• BedEffectiveDate:
• CertifiedBedTotal:
• HC_Name:
• HC_Phone:
• HC_Email:
• MD_Name:
• MD_Phone:
• MD_Email:
• AD_Name:
• AD_Phone:
• AD_Email:
• EHD_Name:
• EHD_Phone:
• EHD_Email:
• ND_Name:
• ND_Phone:
• ND_Email:
• VS_Name:
• VS_Phone:
• VS_Email:
• FO_Name:
• FO_Phone:
• FO_Email:
• PIO_Name:
• PIO_Phone:
• PIO_Email:
• EPI_Name:
• EPI_Phone:
• EPI_Email:
• ERC_Name:
• ERC_Phone:
• ERC_Email:
• AHC_Name:
• AHC_Phone:
• AHC_Email:
• DHC_Name:
• DHC_Phone:
• DHC_Email:
• DR_Name:
• DR_Phone:
• DR_Email:
• AC_Name:
• AC_Phone:
• AC_Email:
• HE_Name:
• HE_Phone:
• HE_Email:
• Population:
• LHDId:
• Hospital_Type:
• NATCEP_Type:
• LHDType:
• LHDCountyCity:
• LHDStatus:
• LHDDistrict:
• ContractingWith:
• Website:
• BusinessTypeCategoryDesc:
• HospitalTypeDesc:
• NATCEPTypeDesc:
• Data_Source:
• CombinedWith:
• New_Active_Facility: Active

---

ID: Inactive
Name: Inactive
Domains:

Templates:

Name: Inactive
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Active_Facility:
• LHDIdOld:
• Business_Type:
• Business_Name:
• Location_Address_Line_1:
• Location_Address_Line_2:
• Location_City:
• Location_State:
• Location_Zip:
• Location_County:
• VoicePhone:
• EmailAddress:
• RPLastName:
• RPFirstName:
• RPMiddleName:
• RPSuffix:
• RPEmail:
• Dispenses_Naloxone:
• CredentialStatus:
• CredentialStatusReason:
• License_Number:
• Subcategory_Code:
• Location_Address_Line_3:
• MailingAddressLine1:
• MailingAddressLine2:
• MailingAddressLine3:
• MailingCity:
• MailingState:
• MailingZip:
• FaxPhone:
• License_Prefix:
• Ohio_Drug_Category:
• Business_Type_1:
• PracticeTypeDescription:
• DateofFirstLicensure:
• EffectiveDate:
• ExpirationDate:
• LegalFiles:
• RPCredentialTypePrefix:
• FacilityID:
• StateID:
• Abbreviation:
• MedicareID:
• LicensedBedTotal:
• BedEffectiveDate:
• CertifiedBedTotal:
• HC_Name:
• HC_Phone:
• HC_Email:
• MD_Name:
• MD_Phone:
• MD_Email:
• AD_Name:
• AD_Phone:
• AD_Email:
• EHD_Name:
• EHD_Phone:
• EHD_Email:
• ND_Name:
• ND_Phone:
• ND_Email:
• VS_Name:
• VS_Phone:
• VS_Email:
• FO_Name:
• FO_Phone:
• FO_Email:
• PIO_Name:
• PIO_Phone:
• PIO_Email:
• EPI_Name:
• EPI_Phone:
• EPI_Email:
• ERC_Name:
• ERC_Phone:
• ERC_Email:
• AHC_Name:
• AHC_Phone:
• AHC_Email:
• DHC_Name:
• DHC_Phone:
• DHC_Email:
• DR_Name:
• DR_Phone:
• DR_Email:
• AC_Name:
• AC_Phone:
• AC_Email:
• HE_Name:
• HE_Phone:
• HE_Email:
• Population:
• LHDId:
• Hospital_Type:
• NATCEP_Type:
• LHDType:
• LHDCountyCity:
• LHDStatus:
• LHDDistrict:
• ContractingWith:
• Website:
• BusinessTypeCategoryDesc:
• HospitalTypeDesc:
• NATCEPTypeDesc:
• Data_Source:
• CombinedWith:
• New_Active_Facility: Inactive

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/8/2023 4:13:02 PM

Schema Last Edit Date: 8/8/2023 4:13:02 PM

Data Last Edit Date: 8/8/2023 3:41:15 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat