Sarmal's image Posts 10
Thanks 5
Joined 16 Apr '11 Email user

Is it fair to assume that a LengthofStay value (in Claims_Y1.csv) is a hospital stay (of the type pi  or ai  in the ε metric ) only if the placesvc (Place of Service) is Inpatient or Outpatient Hospital?

Also, do the DaysinHospital in the DaysinHospital_Y2.csv file also refer only to Inpatient and Outpatient stays?

What is the interpretation of 2-4 weeks for LengthofStay with placesvc set at home or other?

 
Sarmal's image Posts 10
Thanks 5
Joined 16 Apr '11 Email user

There are also Inpatient and Outpatient placesvcs where where the LengthofStay is blank. Are we to assume these are 0 days or 1 day?

Or are these just extra claims from Anesthesiology, Laboratory or Imaging associated with the same episode of care?

 
Anthony Goldbloom (Kaggle)'s image
Anthony Goldbloom (Kaggle)
Competition Admin
Kaggle Admin
Posts 382
Thanks 72
Joined 20 Jan '10 Email user
From Kaggle
DaysInHospital_Y2 is derived from the claims table where a hospital stay includes an inpatient stay or an emergency visit. Note: you don't have enough information to calculate DaysInHospital_Y2 from the claims table.
 
Sarmal's image Posts 10
Thanks 5
Joined 16 Apr '11 Email user

Are you saying that the DaysInHospital_Y2 are only Inpatient and Emergency days and do not include Outpatient or Urgent Care?

Also when determining Y1 days in hospital (from the data in Claims_Y1.csv)  do we exclude the Outpatient days and use only the Inpatient and Emergency days?

Thanked by spinach , and Drew Tyre
 
hanshen's image Posts 1
Joined 17 Mar '12 Email user

In DaysInHospital_Y3.csv, we can find "66455760,0,13", meaning that the DaysInHospital of 66455760 is 13 in Y3, and there is no truncated claims. In Claims.csv, we can find that the LOS values of all the Y3 claims of the member are null, and none of them are suppressed.

Since all the claims are there and all the LOS values are 0, is it the case that DaysInHospital comes from not only the claims table, but also some other medical treatments that can not be claimed?

 
S.U.T.'s image Posts 43
Thanks 7
Joined 5 Sep '11 Email user

In Target.csv MemberID # 66455760 does have the indicator for claims-truncated. I beleive this applies to claims Y3 and the claims-truncated field in DaysInHospitalY3 applies to claims made in Y2.

Thanked by hanshen , and DaveC
 

Reply

Flag alert Flagging is a way of notifying administrators that this message contents inappropriate or abusive content. Are you sure this forum post qualifies?