VW_Medicare_ProviderInfo

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
provnum varchar 500 null
provname varchar 500 √ null
address varchar 500 √ null
city varchar 500 √ null
state varchar 500 √ null
zip varchar 500 √ null
phone varchar 500 √ null
county_ssa varchar 500 √ null
county_name varchar 500 √ null
ownership varchar 500 √ null
bedcert varchar 500 √ null
restot varchar 500 √ null
certification varchar 500 √ null
inhosp varchar 500 √ null
lbn varchar 500 √ null
participation_date date 6 √ null
ccrc_facil varchar 500 √ null
sff varchar 500 √ null
oldsurvey varchar 500 √ null
chow_last_12mos varchar 500 √ null
resfamcouncil varchar 500 √ null
sprinkler_status varchar 500 √ null
overall_rating decimal 20,5 √ null
overall_rating_fn varchar 500 √ null
survey_rating decimal 20,5 √ null
survey_rating_fn varchar 500 √ null
quality_rating decimal 20,5 √ null
quality_rating_fn varchar 500 √ null
ls_quality_rating decimal 20,5 √ null
ls_quality_rating_fn varchar 500 √ null
ss_quality_rating decimal 20,5 √ null
ss_quality_rating_fn varchar 500 √ null
staffing_rating decimal 20,5 √ null
staffing_rating_fn varchar 500 √ null
rn_staffing_rating decimal 20,5 √ null
rn_staffing_rating_fn varchar 500 √ null
staffing_flag varchar 500 √ null
pt_staffing_flag varchar 500 √ null
aidhrd decimal 20,5 √ null
vochrd decimal 20,5 √ null
rnhrd decimal 20,5 √ null
totlichrd decimal 20,5 √ null
tothrd decimal 20,5 √ null
pthrd decimal 20,5 √ null
cm_aide varchar 500 √ null
cm_lpn varchar 500 √ null
cm_rn varchar 500 √ null
cm_total varchar 500 √ null
adj_aide decimal 20,5 √ null
adj_lpn decimal 20,5 √ null
adj_rn decimal 20,5 √ null
adj_total decimal 20,5 √ null
cycle_1_defs varchar 500 √ null
cycle_1_nfromdefs varchar 500 √ null
cycle_1_nfromcomp varchar 500 √ null
cycle_1_defs_score varchar 500 √ null
cycle_1_survey_date date 6 √ null
cycle_1_numrevis varchar 500 √ null
cycle_1_revisit_score varchar 500 √ null
cycle_1_total_score varchar 500 √ null
cycle_2_defs varchar 500 √ null
cycle_2_nfromdefs varchar 500 √ null
cycle_2_nfromcomp varchar 500 √ null
cycle_2_defs_score varchar 500 √ null
cycle_2_survey_date date 6 √ null
cycle_2_numrevis varchar 500 √ null
cycle_2_revisit_score varchar 500 √ null
cycle_2_total_score varchar 500 √ null
cycle_3_defs varchar 500 √ null
cycle_3_nfromdefs varchar 500 √ null
cycle_3_nfromcomp varchar 500 √ null
cycle_3_defs_score varchar 500 √ null
cycle_3_survey_date date 6 √ null
cycle_3_numrevis varchar 500 √ null
cycle_3_revisit_score varchar 500 √ null
cycle_3_total_score varchar 500 √ null
weighted_all_cycles_score varchar 500 √ null
incident_cnt decimal 20,5 √ null
cmplnt_cnt decimal 20,5 √ null
fine_cnt decimal 20,5 √ null
fine_tot decimal 20,5 √ null
payden_cnt decimal 20,5 √ null
tot_penlty_cnt decimal 20,5 √ null
Total number of nurse staff hours per resident per day on the weekend decimal 20,5 √ null
Reported Physical Therapist Staffing Hours per Resident Per Day decimal 20,5 √ null
Total nursing staff turnover decimal 20,5 √ null
Total nursing staff turnover footnote varchar 1000 √ null
Registered Nurse turnover decimal 20,5 √ null
Registered Nurse turnover footnote varchar 1000 √ null
Number of administrators who have left the nursing home decimal 20,5 √ null
Administrator turnover footnote varchar 1000 √ null
state_avg_overall_rating decimal 20,2 √ null
state_avg_survey_rating decimal 20,2 √ null
state_avg_quality_rating decimal 20,2 √ null
state_avg_staffing_rating decimal 20,2 √ null
state_avg_rn_staffing_rating decimal 20,2 √ null
state_avg_ls_quality_rating decimal 20,2 √ null
state_avg_ss_quality_rating decimal 20,2 √ null
nat_avg_overall_rating decimal 20,2 √ null
nat_avg_survey_rating decimal 20,2 √ null
nat_avg_quality_rating decimal 20,2 √ null
nat_avg_staffing_rating decimal 20,2 √ null
nat_avg_rn_staffing_rating decimal 20,2 √ null
nat_avg_ls_quality_rating decimal 20,2 √ null
nat_avg_ss_quality_rating decimal 20,2 √ null
filedate date 6 null
AVA_InsDate datetime2 16,3 null
AVA_YYYYMMKey int 4 null
AVA_FileKey varchar 100 null

View Definition

Possibly Referenced Tables/Views