Notifications
Clear all
Topic starter
Hello,
Can anyone tell me how the SITE column gets populated in the DOCUMENT table? We would love to start using this for reporting needs but our database has nothing populated in this column. Perhaps a feature we do not have enabled?
Thanks
John
Posted : March 10, 2015 7:59 am
Checked our database, Site not populated either. Data Dictionary says it is the location of the encounter.
Posted : March 10, 2015 8:11 am
What you are looking for is DOCUMENT.LOCOFCARE. You need to link DOCUMENT.LOCOFCARE to LOCREG.LOCID and all of the location information you are looking for is then in the LOCREG table. The SITE field is not used.
Posted : March 12, 2015 5:05 am
From my understanding the SITE field is left over from versions long ago and the poster above me showed how to report on the document location now - it has been this way since I've worked with GE (albeit not that long).
Posted : March 13, 2015 9:01 am
