Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
Period | varchar | 50 | √ | null |
|
|
||
EpisodeInitiator_CCN | varchar | 6 | √ | 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 | 6 | √ | 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 |
|
|