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. |