Medicare_StateAverages

702 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
state varchar 500 null
C1_HLTH_DEFS_CNT varchar 500 √ null
C1_FS_DEFS_CNT varchar 500 √ null
C2_HLTH_DEFS_CNT varchar 500 √ null
C2_FS_DEFS_CNT varchar 500 √ null
C3_HLTH_DEFS_CNT varchar 500 √ null
C3_FS_DEFS_CNT varchar 500 √ null
PREV_HTH_AVG varchar 500 √ null
restot varchar 500 √ null
aidhrd varchar 500 √ null
vochrd varchar 500 √ null
rnhrd varchar 500 √ null
totlichrd varchar 500 √ null
tothrd varchar 500 √ null
pthrd varchar 500 √ null
EXP_RN varchar 500 √ null
EXP_TOTAL varchar 500 √ null
fine_cnt varchar 500 √ null
fine_tot varchar 500 √ null
qm401 varchar 500 √ null
qm402 varchar 500 √ null
qm403 varchar 500 √ null
qm404 varchar 500 √ null
qm405 varchar 500 √ null
qm406 varchar 500 √ null
qm407 varchar 500 √ null
qm408 varchar 500 √ null
qm409 varchar 500 √ null
qm410 varchar 500 √ null
qm411 varchar 500 √ null
qm415 varchar 500 √ null
qm419 varchar 500 √ null
qm424 varchar 500 √ null
qm425 varchar 500 √ null
qm426 varchar 500 √ null
qm430 varchar 500 √ null
qm434 varchar 500 √ null
qm451 varchar 500 √ null
qm452 varchar 500 √ null
qm471 varchar 500 √ null
qm521 varchar 500 √ null
qm522 varchar 500 √ null
qm523 varchar 500 √ null
qm551 varchar 500 √ null
FILEDATE varchar 500 null
AVA_InsDate datetime2 16,3 (getdate())
AVA_YYYYMMKey int 4 null
ETL_Medicare.yyyymm_key Medicare_StateAverages_FKR
AVA_FileKey varchar 100 null
ETL_Medicare.file_key Medicare_StateAverages_FKR

Indexes

Constraint Name Type Sort Column(s)
Medicare_StateAverages_PK Primary key Asc/Asc state + FILEDATE
Medicare_StateAverages_IX1 Performance Asc/Asc AVA_YYYYMMKey + AVA_FileKey

Relationships

Close relationships within degrees of separation