search

outcomesinsights / generalized_data_model

Outcomes Insights' Data Model for Clinical Research
MIT License
17 stars 3 forks source link

Should we add type_concept_id to facilities table? #59

Closed marc-outins closed 7 years ago

marc-outins commented 8 years ago

We currently have specialty_concept_id which may be where we add a facility type or is that for something else and we need another column? SEER-Medicare has a variable fac_type which has values:

1 = Hospital 2 = Skilled nursing facility (SNF) 3 = Home health agency (HHA) 4 = Religious Nonmedical (Hospital) (eff. 8/1/00); prior to 8/00 referenced Christian Science (CS) 5 = Religious Nonmedical (Extended Care) (eff. 8/1/00); prior to 8/00 referenced CS (discontinued effective 10/1/05) 6 = Intermediate care 7 = Clinic or hospital-based renal dialysis facility 8 = Special facility or ASC surgery 9 = Reserved

markdanese commented 7 years ago

looks like facility_type_concept_id was added at some point, so closing this issue