Back in January I attended a full assessment for my mother, which has led to the NHS paying for her care entirely (at least for the next couple of months when another review is due to take place).
Where I am, the district nurse came from the Continuing Care Team, which I understand from reading more here is the same as CHC or just part of it. She had only met my mum for the first time, and for only 10 minutes, just before the meeting but had read reports and spoken to the care home and social services and understood the difficulties of the case.
We were told that the report would be written up and presented to the CCG, who would decide on whether or not full funding would be provided. It was imperative that the care home staff were there at the assessment, as they were the ones dealing with mum 24/7 and knew her habits and behaviour better than anyone else, even perhaps my father and I (although, I haven't lived with my parents some time and expect my father didn't let on the full extent of what happened at home, but that's another story).
By the sounds of things, we may have been quite fortunate then compared to others going through the same situation. As things stand, my mum has been moved to a nursing home and everything is being paid by the CCG / NHS, so we don't have to worry about (the already dwindling) family finances.
It's such an alien and unknown thing to have to deal with social services, CCG, CHC etc - but have to say that without it we'd be in a pretty mess I imagine.