Name: CMS_NursingHomes_B

Display Field: Loc_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: -18410439.131
YMin: 1510633.649
XMax: 16118033.7287
YMax: 10126402.4427
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[124,40,163,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

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:

Fields:

• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• USER_CMS_Certification_Number__ (type: esriFieldTypeString, alias: CMS Certification Number (CCN), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Provider_Name (type: esriFieldTypeString, alias: Provider Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Provider_Address (type: esriFieldTypeString, alias: Provider Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_City_Town (type: esriFieldTypeString, alias: City/Town, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ZIP_Code (type: esriFieldTypeInteger, alias: ZIP Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Telephone_Number (type: esriFieldTypeBigInteger, alias: Telephone Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_County_Parish (type: esriFieldTypeString, alias: County/Parish, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Ownership_Type (type: esriFieldTypeString, alias: Ownership Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Number_of_Certified_Beds (type: esriFieldTypeInteger, alias: Number of Certified Beds, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Average_Number_of_Resident (type: esriFieldTypeDouble, alias: Average Number of Residents per Day, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Provider_Type (type: esriFieldTypeString, alias: Provider Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Legal_Business_Name (type: esriFieldTypeString, alias: Legal Business Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Date_First_Approved_to_Pro (type: esriFieldTypeDateOnly, alias: Date First Approved to Provide Medicare and Medicaid Services, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Continuing_Care_Retirement (type: esriFieldTypeString, alias: Continuing Care Retirement Community, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Provider_Changed_Ownership (type: esriFieldTypeString, alias: Provider Changed Ownership in Last 12 Months, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Reported_Nurse_Aide_Staffi (type: esriFieldTypeDouble, alias: Reported Nurse Aide Staffing Hours per Resident per Day, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Reported_LPN_Staffing_Hour (type: esriFieldTypeDouble, alias: Reported LPN Staffing Hours per Resident per Day, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Reported_RN_Staffing_Hours (type: esriFieldTypeDouble, alias: Reported RN Staffing Hours per Resident per Day, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Reported_Licensed_Staffing (type: esriFieldTypeDouble, alias: Reported Licensed Staffing Hours per Resident per Day, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Reported_Total_Nurse_Staff (type: esriFieldTypeDouble, alias: Reported Total Nurse Staffing Hours per Resident per Day, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Total_number_of_nurse_staf (type: esriFieldTypeDouble, alias: Total number of nurse staff hours per resident per day on the weekend, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Registered_Nurse_hours_per (type: esriFieldTypeDouble, alias: Registered Nurse hours per resident per day on the weekend, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Reported_Physical_Therapis (type: esriFieldTypeDouble, alias: Reported Physical Therapist Staffing Hours per Resident Per Day, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Number_of_Facility_Reporte (type: esriFieldTypeInteger, alias: Number of Facility Reported Incidents, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Number_of_Substantiated_Co (type: esriFieldTypeInteger, alias: Number of Substantiated Complaints, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Number_of_Citations_from_I (type: esriFieldTypeInteger, alias: Number of Citations from Infection Control Inspections, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Number_of_Fines (type: esriFieldTypeInteger, alias: Number of Fines, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Total_Amount_of_Fines_in_D (type: esriFieldTypeDouble, alias: Total Amount of Fines in Dollars, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Total_Number_of_Penalties (type: esriFieldTypeInteger, alias: Total Number of Penalties, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: CMS_NursingHomes_B
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• USER_Geocoding_Footnote: 0
• IN_Address:
• IN_Address2:
• IN_Address3:
• IN_Neighborhood:
• IN_City:
• IN_Subregion:
• IN_Region:
• IN_Postal:
• IN_PostalExt:
• IN_CountryCode:
• USER_CMS_Certification_Number__:
• USER_Provider_Name:
• USER_Provider_Address:
• USER_City_Town:
• USER_State:
• USER_ZIP_Code: 0
• USER_Provider_SSA_County_Code: 0
• USER_County_Parish:
• USER_Ownership_Type:
• USER_Number_of_Certified_Beds: 0
• USER_Average_Number_of_Resident: 0
• USER_Average_Number_of_Reside_1: 0
• USER_Provider_Type:
• USER_Provider_Resides_in_Hospit:
• USER_Legal_Business_Name:
• USER_Affiliated_Entity_Name:
• USER_Affiliated_Entity_ID: 0
• USER_Continuing_Care_Retirement:
• USER_Special_Focus_Status:
• USER_Abuse_Icon:
• USER_Most_Recent_Health_Inspect:
• USER_Provider_Changed_Ownership:
• USER_With_a_Resident_and_Family:
• USER_Automatic_Sprinkler_System:
• USER_Overall_Rating: 0
• USER_Overall_Rating_Footnote:
• USER_Health_Inspection_Rating: 0
• USER_Health_Inspection_Rating_F:
• USER_QM_Rating: 0
• USER_QM_Rating_Footnote: 0
• USER_Long_Stay_QM_Rating: 0
• USER_Long_Stay_QM_Rating_Footno: 0
• USER_Short_Stay_QM_Rating: 0
• USER_Short_Stay_QM_Rating_Footn: 0
• USER_Staffing_Rating: 0
• USER_Staffing_Rating_Footnote: 0
• USER_Reported_Staffing_Footnote: 0
• USER_Physical_Therapist_Staffin: 0
• USER_Reported_Nurse_Aide_Staffi: 0
• USER_Reported_LPN_Staffing_Hour: 0
• USER_Reported_RN_Staffing_Hours: 0
• USER_Reported_Licensed_Staffing: 0
• USER_Reported_Total_Nurse_Staff: 0
• USER_Total_number_of_nurse_staf: 0
• USER_Registered_Nurse_hours_per: 0
• USER_Reported_Physical_Therapis: 0
• USER_Total_nursing_staff_turnov: 0
• USER_Total_nursing_staff_turn_1: 0
• USER_Registered_Nurse_turnover: 0
• USER_Registered_Nurse_turnover_: 0
• USER_Number_of_administrators_w: 0
• USER_Administrator_turnover_foo: 0
• USER_Nursing_Case_Mix_Index: 0
• USER_Nursing_Case_Mix_Index_Rat: 0
• USER_Case_Mix_Nurse_Aide_Staffi: 0
• USER_Case_Mix_LPN_Staffing_Hour: 0
• USER_Case_Mix_RN_Staffing_Hours: 0
• USER_Case_Mix_Total_Nurse_Staff: 0
• USER_Case_Mix_Weekend_Total_Nur: 0
• USER_Adjusted_Nurse_Aide_Staffi: 0
• USER_Adjusted_LPN_Staffing_Hour: 0
• USER_Adjusted_RN_Staffing_Hours: 0
• USER_Adjusted_Total_Nurse_Staff: 0
• USER_Adjusted_Weekend_Total_Nur: 0
• USER_Rating_Cycle_1_Total_Numbe:
• USER_Rating_Cycle_1_Number_of_S:
• USER_Rating_Cycle_1_Number_of_C:
• USER_Rating_Cycle_1_Health_Defi:
• USER_Rating_Cycle_1_Number_of_H:
• USER_Rating_Cycle_1_Health_Revi:
• USER_Rating_Cycle_1_Total_Healt:
• USER_Rating_Cycle_2_Total_Numbe:
• USER_Rating_Cycle_2_Number_of_S:
• USER_Rating_Cycle_2_Number_of_C:
• USER_Rating_Cycle_2_Health_Defi:
• USER_Rating_Cycle_2_Number_of_H:
• USER_Rating_Cycle_2_Health_Revi:
• USER_Rating_Cycle_2_Total_Healt:
• USER_Rating_Cycle_3_Total_Numbe:
• USER_Rating_Cycle_3_Number_of_S:
• USER_Rating_Cycle_3_Number_of_C:
• USER_Rating_Cycle_3_Health_Defi:
• USER_Rating_Cycle_3_Number_of_H:
• USER_Rating_Cycle_3_Health_Revi:
• USER_Rating_Cycle_3_Total_Healt:
• USER_Total_Weighted_Health_Surv: 0
• USER_Number_of_Facility_Reporte: 0
• USER_Number_of_Substantiated_Co: 0
• USER_Number_of_Citations_from_I: 0
• USER_Number_of_Fines: 0
• USER_Total_Amount_of_Fines_in_D: 0
• USER_Number_of_Payment_Denials: 0
• USER_Total_Number_of_Penalties: 0
• USER_Location:
• USER_Latitude: 0
• USER_Longitude: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/26/2024 4:04:45 PM

Schema Last Edit Date: 9/26/2024 4:04:45 PM

Data Last Edit Date: 9/26/2024 4:04:12 PM

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