Last TARV status
from s in db.d_status.Where(w => w.id_person == p.id_person && w.domain== "TARV" && w.active == true && (w.deleted == null || !(bool)w.deleted)) //.DefaultIfEmpty()
Last SERVICE Status
from s in db.d_status.Where(w => w.id_person == p.id_person && w.domain == "SERVICE" && w.active == true && (w.deleted == null || !(bool)w.deleted)) //DefaultIfEmpty
domain = = TBSTA, FOODI, ASSIS, SERVICE, TARV, HIVST, FEED, TER_COT, TBC_PRE_TPI, TER_FLU
| SERVICE STATUS |
|---|
| ENDASS |
| NODREAM |
| MCPC |
| MCPC_C |
| CCHC |
| VCT |
| TBCARE |
| PEP |
| TRANSIT |
| |
| ASSIS STATUS |
|---|
| HOMECARE |
| DAYHOSP |
| RICOVEROHC |
| RICOVERO |
| CCHC |
| |
| TBSTA STATUS |
|---|
| TBC_PRE_COT |
| TBC_SI |
| TBC_SI_2 |
| TBC_NO |
| |
| FOODI STATUS |
|---|
| FOOD_INT_NO |
| FOOD_INT_YES |
| TARV STATUS |
|---|
| TARV_NO |
| TARV_SI |
| HIVST STATUS |
|---|
| STBY --> da correggere! |
| HIV_INSEC |
| HIV_NO |
| HIV_STBY |
| HIV_YES |
| HIV_TEST |
| FEED STATUS |
|---|
| TA_ARTIFIC |
| TA_MISTO |
| TA_ALSENO |
| HIV_STBY |
| TER_COT, TBC_PRE_TPI, TER_FLU STATUS |
|---|
| YES |
| NO |
