tbl file

The $HCISITE\Tables\XXX.tbl file is used to store the database lookup configuration.

For example:

# Translation database lookup
#
prologue
    who:     18269
    date:     July 1, 2013 2:45:17 PM CST
    outname:          output
    inname:            input
    bidir:     0
    type:     dbl
    version:            5.0
end_prologue
#
dflt_passthrough=0
dflt=
dflt_encoded=false
#
dbconnection=dbconnectionName 
table_name=patient_table
sqlstatement=select * from patient_table where patientid =<patientid> and date=<date> and doctorid=<doctorid>
in_column_name= patientid,date,doctorid
out_column_name= patientid,date,doctorid,patientname,doctorname,result