For concepts with numeric data type Obs table stores value in “value_numeric”. For concepts with coded data type Obs tables stores value in value_coded and value_coded_name_id. But for Patient File concept id all value_* fields are NULL. So how to get the value of Patient File just by looking at Obs table?
For a patient file, the value is captured under “value_text” and the file itself can be found at /home/bahmni/document_images. Hope this helps.