Medicare_Stage_ProviderInfo

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Federal Provider Number varchar 2147483647 √ null
Provider Name varchar 2147483647 √ null
Provider Address varchar 2147483647 √ null
Provider City varchar 2147483647 √ null
Provider State varchar 2147483647 √ null
Provider Zip Code varchar 2147483647 √ null
Provider Phone Number varchar 2147483647 √ null
Provider SSA County Code varchar 2147483647 √ null
Provider County Name varchar 2147483647 √ null
Ownership Type varchar 2147483647 √ null
Number of Certified Beds varchar 2147483647 √ null
Average Number of Residents per Day varchar 2147483647 √ null
Average Number of Residents per Day Footnote varchar 2147483647 √ null
Provider Type varchar 2147483647 √ null
Provider Resides in Hospital varchar 2147483647 √ null
Legal Business Name varchar 2147483647 √ null
Date First Approved to Provide Medicare and Medicaid Services varchar 2147483647 √ null
Continuing Care Retirement Community varchar 2147483647 √ null
Special Focus Status varchar 2147483647 √ null
Abuse Icon varchar 2147483647 √ null
Most Recent Health Inspection More Than 2 Years Ago varchar 2147483647 √ null
Provider Changed Ownership in Last 12 Months varchar 2147483647 √ null
With a Resident and Family Council varchar 2147483647 √ null
Automatic Sprinkler Systems in All Required Areas varchar 2147483647 √ null
Overall Rating varchar 2147483647 √ null
Overall Rating Footnote varchar 2147483647 √ null
Health Inspection Rating varchar 2147483647 √ null
Health Inspection Rating Footnote varchar 2147483647 √ null
QM Rating varchar 2147483647 √ null
QM Rating Footnote varchar 2147483647 √ null
Long-Stay QM Rating varchar 2147483647 √ null
Long-Stay QM Rating Footnote varchar 2147483647 √ null
Short-Stay QM Rating varchar 2147483647 √ null
Short-Stay QM Rating Footnote varchar 2147483647 √ null
Staffing Rating varchar 2147483647 √ null
Staffing Rating Footnote varchar 2147483647 √ null
RN Staffing Rating varchar 2147483647 √ null
RN Staffing Rating Footnote varchar 2147483647 √ null
Reported Staffing Footnote varchar 2147483647 √ null
Physical Therapist Staffing Footnote varchar 2147483647 √ null
Reported Nurse Aide Staffing Hours per Resident per Day varchar 2147483647 √ null
Reported LPN Staffing Hours per Resident per Day varchar 2147483647 √ null
Reported RN Staffing Hours per Resident per Day varchar 2147483647 √ null
Reported Licensed Staffing Hours per Resident per Day varchar 2147483647 √ null
Reported Total Nurse Staffing Hours per Resident per Day varchar 2147483647 √ null
Total number of nurse staff hours per resident per day on the weekend varchar 2147483647 √ null
Reported Physical Therapist Staffing Hours per Resident Per Day varchar 2147483647 √ null
Registered Nurse hours per resident per day on the weekend varchar 2147483647 √ null
Total nursing staff turnover varchar 2147483647 √ null
Total nursing staff turnover footnote varchar 2147483647 √ null
Registered Nurse turnover varchar 2147483647 √ null
Registered Nurse turnover footnote varchar 2147483647 √ null
Number of administrators who have left the nursing home varchar 2147483647 √ null
Administrator turnover footnote varchar 2147483647 √ null
Case-Mix Nurse Aide Staffing Hours per Resident per Day varchar 2147483647 √ null
Case-Mix LPN Staffing Hours per Resident per Day varchar 2147483647 √ null
Case-Mix RN Staffing Hours per Resident per Day varchar 2147483647 √ null
Case-Mix Total Nurse Staffing Hours per Resident per Day varchar 2147483647 √ null
Adjusted Nurse Aide Staffing Hours per Resident per Day varchar 2147483647 √ null
Adjusted LPN Staffing Hours per Resident per Day varchar 2147483647 √ null
Adjusted RN Staffing Hours per Resident per Day varchar 2147483647 √ null
Adjusted Total Nurse Staffing Hours per Resident per Day varchar 2147483647 √ null
Rating Cycle 1 Standard Survey Health Date varchar 2147483647 √ null
Rating Cycle 1 Total Number of Health Deficiencies varchar 2147483647 √ null
Rating Cycle 1 Number of Standard Health Deficiencies varchar 2147483647 √ null
Rating Cycle 1 Number of Complaint Health Deficiencies varchar 2147483647 √ null
Rating Cycle 1 Health Deficiency Score varchar 2147483647 √ null
Rating Cycle 1 Number of Health Revisits varchar 2147483647 √ null
Rating Cycle 1 Health Revisit Score varchar 2147483647 √ null
Rating Cycle 1 Total Health Score varchar 2147483647 √ null
Rating Cycle 2 Standard Health Survey Date varchar 2147483647 √ null
Rating Cycle 2 Total Number of Health Deficiencies varchar 2147483647 √ null
Rating Cycle 2 Number of Standard Health Deficiencies varchar 2147483647 √ null
Rating Cycle 2 Number of Complaint Health Deficiencies varchar 2147483647 √ null
Rating Cycle 2 Health Deficiency Score varchar 2147483647 √ null
Rating Cycle 2 Number of Health Revisits varchar 2147483647 √ null
Rating Cycle 2 Health Revisit Score varchar 2147483647 √ null
Rating Cycle 2 Total Health Score varchar 2147483647 √ null
Rating Cycle 3 Standard Health Survey Date varchar 2147483647 √ null
Rating Cycle 3 Total Number of Health Deficiencies varchar 2147483647 √ null
Rating Cycle 3 Number of Standard Health Deficiencies varchar 2147483647 √ null
Rating Cycle 3 Number of Complaint Health Deficiencies varchar 2147483647 √ null
Rating Cycle 3 Health Deficiency Score varchar 2147483647 √ null
Rating Cycle 3 Number of Health Revisits varchar 2147483647 √ null
Rating Cycle 3 Health Revisit Score varchar 2147483647 √ null
Rating Cycle 3 Total Health Score varchar 2147483647 √ null
Total Weighted Health Survey Score varchar 2147483647 √ null
Number of Facility Reported Incidents varchar 2147483647 √ null
Number of Substantiated Complaints varchar 2147483647 √ null
Number of Citations from Infection Control Inspections varchar 2147483647 √ null
Number of Fines varchar 2147483647 √ null
Total Amount of Fines in Dollars varchar 2147483647 √ null
Number of Payment Denials varchar 2147483647 √ null
Total Number of Penalties varchar 2147483647 √ null
Location varchar 2147483647 √ null
Processing Date varchar 2147483647 √ null

Diagram producer might be missing

No diagrams were produced please see application output for any errors