Table Detail Report

LH_CNT_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_REPORT
Definition: This table will store Lighthouse Content Report data.
Table Type: ACTIVITY





Column Detail - LH_CNT_REPORT


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N The encounter id on lh_cnt_report that relates to the encounter table.
LH_CNT_REPORT_ID DOUBLE N Unique generated number that identifies a single row on the table
LONG_TEXT_ID DOUBLE N The long text id is on lh_cnt_report that relates to the long_text table.
REPORT_TYPE_FLAG DOUBLE N The report type flag is an identifier for the type of report.1 = IRF PAI Report
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VERSION_NBR DOUBLE N The version number is the number of versions for the Lighthouse Content Report Type.



Relationship Detail - LH_CNT_REPORT


Child Column in LH_CNT_REPORT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID