VW_Medicare_StateUSAverages

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
state varchar 500 null
c1_hlth_defs_cnt decimal 20,1 √ null
c1_fs_defs_cnt decimal 20,1 √ null
c2_hlth_defs_cnt decimal 20,1 √ null
c2_fs_defs_cnt decimal 20,1 √ null
c3_hlth_defs_cnt decimal 20,1 √ null
c3_fs_defs_cnt decimal 20,1 √ null
prev_hth_avg varchar 500 √ null
restot decimal 20,1 √ null
aidhrd decimal 20,2 √ null
vochrd decimal 20,2 √ null
rnhrd decimal 20,2 √ null
totlichrd decimal 20,2 √ null
tothrd decimal 20,2 √ null
pthrd decimal 20,2 √ null
cm_rn decimal 20,5 √ null
cm_total decimal 20,5 √ null
fine_cnt decimal 20,1 √ null
fine_tot int 4 √ null
qm401 decimal 20,6 √ null
qm402 decimal 20,6 √ null
qm404 decimal 20,6 √ null
qm405 decimal 20,6 √ null
qm406 decimal 20,6 √ null
qm407 decimal 20,6 √ null
qm408 decimal 20,6 √ null
qm409 decimal 20,6 √ null
qm410 decimal 20,6 √ null
qm415 decimal 20,6 √ null
qm419 decimal 20,6 √ null
qm424 decimal 20,6 √ null
qm425 varchar 500 √ null
qm430 decimal 20,6 √ null
qm434 decimal 20,6 √ null
qm451 decimal 20,6 √ null
qm452 decimal 20,6 √ null
qm453 decimal 20,6 √ null
qm454 decimal 20,6 √ null
qm471 decimal 20,6 √ null
qm472 decimal 20,6 √ null
qm521 decimal 20,6 √ null
qm522 decimal 20,6 √ null
qm523 varchar 500 √ null
qm551 decimal 20,6 √ null
qm552 decimal 20,6 √ null
filedate varchar 500 null
Total number of nurse staff hours per resident per day on the weekend decimal 20,5 √ null
Registered Nurse hours per resident per day on the weekend decimal 20,5 √ null
Total nursing staff turnover decimal 20,5 √ null
Registered Nurse turnover decimal 20,5 √ null
Number of administrators who have left the nursing home decimal 20,5 √ null
AVA_InsDate datetime2 16,3 null
AVA_YYYYMMKey int 4 null
AVA_FileKey varchar 100 null

View Definition

Possibly Referenced Tables/Views