DobsonData

429232 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TableID int identity 4 √ null
Period varchar 50 √ null
EpisodeInitiator_CCN varchar 50 √ null
EpisodeInitiator_Name varchar 150 √ null
EI_City varchar 100 √ null
EI_State varchar 10 √ null
EI_MSA varchar 20 √ null
FirstPAC_Setting varchar 50 √ null
FirstPac_CCN varchar 20 √ null
FirstPAC_Name varchar 150 √ null
NumberEpisodes_Total int 4 √ null
NumberEpisodes_30DayReadmit int 4 √ null
NumberEpisodes_90DayReadmit int 4 √ null
NumberDied_DuringEpisode int 4 √ null
NumberReceived_Hospice int 4 √ null
NumberDeath_WithHospice int 4 √ null
Number_Readmits int 4 √ null
Total_90Day_Episode_Spending money 21,4 √ null
Total_AnchorPeriod_Spending money 21,4 √ null
Total_PostDischargePeriod_Spending money 21,4 √ null
Total_AnchorHospital_Spending money 21,4 √ null
Total_IRF_Sending money 21,4 √ null
Total_LTCH_Spending money 21,4 √ null
Total_SNF_Spending money 21,4 √ null
Total_HHA_Spending money 21,4 √ null
Total_HospitalOutpat_Spending money 21,4 √ null
Total_Physician_Spending money 21,4 √ null
Total_DME_Spending money 21,4 √ null
Total_Readmit_Spending money 21,4 √ null
Total_Other_Spending money 21,4 √ null
AnchorHospitalStay int 4 √ null
PatientsusingServices_Episode_IRF int 4 √ null
PatientsusingServices_Episode_LTCH int 4 √ null
PatientsusingServices_Episode_SNF int 4 √ null
PatientsusingServices_Episode_HHA int 4 √ null
PatientsusingServices_Episode_HospitalOutpat int 4 √ null
PatientsusingServices_Episode_Readmits int 4 √ null
PatientsusingServices_Episode_Other int 4 √ null
UtilizationEpisode_HospitalDays_Anchor_Stay int 4 √ null
UtilizationEpisode_OtherHospitalDays_Total int 4 √ null
UtilizationEpisode_IRFDays_Total int 4 √ null
UtilizationEpisode_LTCHDays_Total int 4 √ null
UtilizationEpisode_SNFDays_Total int 4 √ null
UtilizationEpisode_HHAVisits_Total int 4 √ null
FileName varchar 255 √ null
RecordCreateDate datetime 16,3 √ (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK__DobsonDa__7D5F018E9573EC27 Primary key Asc TableID

Diagram producer might be missing

No diagrams were produced please see application output for any errors