Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Period | varchar | 150 | √ | null |
|
|
||
| EpisodeInitiator_CCN | varchar | 100 | √ | null |
|
|
||
| EpisodeInitiator_Name | varchar | 150 | √ | null |
|
|
||
| EI_City | varchar | 100 | √ | null |
|
|
||
| EI_State | varchar | 10 | √ | null |
|
|
||
| EI_MSA | varchar | 100 | √ | null |
|
|
||
| FirstPAC_Setting | varchar | 50 | √ | null |
|
|
||
| FirstPac_CCN | varchar | 100 | √ | null |
|
|
||
| FirstPAC_Name | varchar | 150 | √ | null |
|
|
||
| NumberEpisodes_Total | varchar | 100 | √ | null |
|
|
||
| NumberEpisodes_30DayReadmit | varchar | 100 | √ | null |
|
|
||
| NumberEpisodes_90DayReadmit | varchar | 100 | √ | null |
|
|
||
| NumberDied_DuringEpisode | varchar | 100 | √ | null |
|
|
||
| NumberReceived_Hospice | varchar | 100 | √ | null |
|
|
||
| NumberDeath_WithHospice | varchar | 100 | √ | null |
|
|
||
| Number_Readmits | varchar | 100 | √ | null |
|
|
||
| Total_90Day_Episode_Spending | varchar | 100 | √ | null |
|
|
||
| Total_AnchorPeriod_Spending | varchar | 100 | √ | null |
|
|
||
| Total_PostDischargePeriod_Spending | varchar | 100 | √ | null |
|
|
||
| Total_AnchorHospital_Spending | varchar | 100 | √ | null |
|
|
||
| Total_IRF_Sending | varchar | 100 | √ | null |
|
|
||
| Total_LTCH_Spending | varchar | 100 | √ | null |
|
|
||
| Total_SNF_Spending | varchar | 100 | √ | null |
|
|
||
| Total_HHA_Spending | varchar | 100 | √ | null |
|
|
||
| Total_HospitalOutpat_Spending | varchar | 100 | √ | null |
|
|
||
| Total_Physician_Spending | varchar | 100 | √ | null |
|
|
||
| Total_DME_Spending | varchar | 100 | √ | null |
|
|
||
| Total_Readmit_Spending | varchar | 100 | √ | null |
|
|
||
| Total_Other_Spending | varchar | 100 | √ | null |
|
|
||
| AnchorHospitalStay | varchar | 100 | √ | null |
|
|
||
| PatientsusingServices_Episode_IRF | varchar | 100 | √ | null |
|
|
||
| PatientsusingServices_Episode_LTCH | varchar | 100 | √ | null |
|
|
||
| PatientsusingServices_Episode_SNF | varchar | 100 | √ | null |
|
|
||
| PatientsusingServices_Episode_HHA | varchar | 100 | √ | null |
|
|
||
| PatientsusingServices_Episode_HospitalOutpat | varchar | 100 | √ | null |
|
|
||
| PatientsusingServices_Episode_Readmits | varchar | 100 | √ | null |
|
|
||
| PatientsusingServices_Episode_Other | varchar | 100 | √ | null |
|
|
||
| UtilizationEpisode_HospitalDays_Anchor_Stay | varchar | 100 | √ | null |
|
|
||
| UtilizationEpisode_OtherHospitalDays_Total | varchar | 100 | √ | null |
|
|
||
| UtilizationEpisode_IRFDays_Total | varchar | 100 | √ | null |
|
|
||
| UtilizationEpisode_LTCHDays_Total | varchar | 100 | √ | null |
|
|
||
| UtilizationEpisode_SNFDays_Total | varchar | 100 | √ | null |
|
|
||
| UtilizationEpisode_HHAVisits_Total | varchar | 100 | √ | null |
|
|
||
| FileName | varchar | 255 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors