LH_CNT_CODE_MAP



Column Section Top of Page


Table-level Detail

Description: LH_CNT_CODE_MAP
Definition: This table will house the codes used by Cerner Created Content.
Table Type: REFERENCE





Column Detail - LH_CNT_CODE_MAP


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CATEGORY_MEAN VARCHAR(50) Y The Bedrock Category_Mean that this piece of content is related to.
CODE_STATUS_FLAG DOUBLE N The status of the code mapping.
CONTENT_NAME VARCHAR(255) N The name of the content.
CONTENT_TYPE VARCHAR(255) N The type of content of this row of data.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FILTER_MEAN VARCHAR(50) Y The Bedrock Filter_Mean that this piece of content is related to.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LH_CNT_CODE_MAP_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_CODE_MAP table.
PARENT_CODE_IND DOUBLE N Indicates whether the code is a parent or child. A value of 1 indicates the code is a parent code. (default 0).
SOURCE_IDENTIFIER VARCHAR(100) N This is the code, or source identifier from nomenclature, used for this row.
SOURCE_VOCABULARY_CD DOUBLE Y The Source_Vocabulary_Cd of
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.


LH_CNT_PATIENT_EXTENSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: lh_cnt_patient_extension
Definition: Store patient/encounter extension information used within the Lighthouse Content space.
Table Type: ACTIVITY





Column Detail - LH_CNT_PATIENT_EXTENSION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ENCNTR_ID DOUBLE N The encounter identifier which indicates the encounter that the extension value will apply to.
EXTENSION_TYPE_MEAN VARCHAR(12) Y Type of extension to be applied to the patient/encounter
EXTENSION_VALUE_TXT VARCHAR(255) Y The value associated with the mean
LH_CNT_PATIENT_EXTENSION_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_PATIENT_EXTENSION table.
PERSON_ID DOUBLE N The patient identifier which indicates the patient that the extension value will apply to.
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.



Relationship Detail - LH_CNT_PATIENT_EXTENSION


Child Column in LH_CNT_PATIENT_EXTENSION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


LH_CNT_QM_MEAS_STATE



Column Section Top of Page


Table-level Detail

Description: LH_CNT_QM_MEAS_STATE
Definition: This table will contain the statuses of core measures used by the Quality Measures MPage
Table Type: ACTIVITY





Column Detail - LH_CNT_QM_MEAS_STATE


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N Encounter id for specific person of this measure.
LH_CNT_QM_MEAS_STATE_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_QM_MEAS_STATE table.
MEASURE_TXT VARCHAR(100) N Textual display of the measure.
STATE_FLAG DOUBLE N Measure state of this measure.
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.


LH_CNT_READMIT_RISK



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_READMIT_RISK
Definition: This table will contain the reasons (risks) that a patient was added to the readmission worklist
Table Type: ACTIVITY





Column Detail - LH_CNT_READMIT_RISK


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LH_CNT_READMIT_RISK_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_READMIT_RISK table.
LH_CNT_READMIT_WORKLIST_ID DOUBLE N The ID of the parent row from the LH_CNT_READMIT_WORKLIST table.
RISK_FACTOR_FLAG DOUBLE N Value that represents what type of risk factor this risk is. (AMI, HF, PNEU)
RISK_FACTOR_TXT VARCHAR(255) Y Text representation of the risk factor. Needed to store it separate as the client can modify the text.
RISK_FACTOR_VALUE DOUBLE N Holds the numerical value representing the risk factor.
RISK_VERSION_IDENT DOUBLE Y Contains the Version ID for a Cloud Based risk score. This Version ID is used to tie the record back to a record in the Cloud Database.
RISK_VERSION_TXT VARCHAR(100) Y The unique value for each risk which allows the value stored to be tied back to the source.
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.



Relationship Detail - LH_CNT_READMIT_RISK


Child Column in LH_CNT_READMIT_RISK(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_READMIT_WORKLIST_ID LH_CNT_READMIT_WORKLIST LH_CNT_READMIT_WORKLIST_ID


LH_CNT_READMIT_RISK_HIST



Column Section Top of Page


Table-level Detail

Description: LH_CNT_READMIT_RISK_HIST
Definition: Holds the history of the risk associated to patients in the readmission worklist
Table Type: ACTIVITY





Column Detail - LH_CNT_READMIT_RISK_HIST


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LH_CNT_READMIT_RISK_HIST_ID DOUBLE N PRIMARY KEY
LH_CNT_READMIT_RISK_ID DOUBLE N ID original record in LH_CNT_READMIT_RISK table
LH_CNT_READMIT_WORKLIST_ID DOUBLE N ID of original row on the LH_CNT_READMIT_WORKLIST table
RISK_FACTOR_FLAG DOUBLE N The type of risk factor for the patient
RISK_FACTOR_TXT VARCHAR(255) Y The description of the risk factor
RISK_FACTOR_VALUE DOUBLE N The Risk Factor for the patient
RISK_VERSION_IDENT DOUBLE Y Contains the Version ID for a Cloud Based risk score. This Version ID is used to tie the record back to a record in the Cloud Database.
RISK_VERSION_TXT VARCHAR(100) Y The unique value for each risk which allows the value stored to be tied back to the source.
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.