Table Detail Report

LH_CNT_IC_ANTIBGRM_GROUP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_ANTIBGRM_GROUP_R
Definition: This is a relation table which will hold the data for any Groupings. (ex. Organism Groups, Specimen Groups, etc.)
Table Type: REFERENCE





Column Detail - LH_CNT_IC_ANTIBGRM_GROUP_R


Column Name Type Null? Definition
LH_CNT_IC_ANTIBGRM_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_ANTIBGRM_GROUP table.
LH_CNT_IC_ANTIBGRM_GROUP_R_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_ANTIBGRM_GROUP_R table.
PARENT_ENTITY_ID DOUBLE N Parent_Entity_ID will be the code_value for the group type. (ex. This field will contain ORAGNISM_CD for a Organism Grouping)
PARENT_ENTITY_NAME VARCHAR(30) N Parent Rows Table Name
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - LH_CNT_IC_ANTIBGRM_GROUP_R


Child Column in LH_CNT_IC_ANTIBGRM_GROUP_R(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_IC_ANTIBGRM_GROUP_ID LH_CNT_IC_ANTIBGRM_GROUP LH_CNT_IC_ANTIBGRM_GROUP_ID


LH_CNT_IC_ANTIBGRM_ORG_DSC



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_ANTIBGRM_ORG_DSC
Definition: Holds the Disclaimer or Suppress information for Antibiogram Reporting
Table Type: REFERENCE





Column Detail - LH_CNT_IC_ANTIBGRM_ORG_DSC


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N antibiotic for this grouping
FACILITY_CD DOUBLE N Facility for this grouping
LH_CNT_IC_ANTIBGRM_GROUP_ID DOUBLE N Related row on LH_CNT_IC_BR_GROUP table
LH_CNT_IC_ANTIBGRM_ORG_DSC_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_ANTIBGRM_ORG_DSC table.
LONG_TEXT_ID DOUBLE N disclaimer text
ORGANISM_CD DOUBLE N organism for this grouping
SUPPRESS_IND DOUBLE N suppress indicator if = 1 then this grouping will not display in reporting
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_IC_ANTIBGRM_ORG_DSC


Child Column in LH_CNT_IC_ANTIBGRM_ORG_DSC(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_IC_ANTIBGRM_GROUP_ID LH_CNT_IC_ANTIBGRM_GROUP LH_CNT_IC_ANTIBGRM_GROUP_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


LH_CNT_IC_AR_ORG_MAP



Column Section Top of Page


Table-level Detail

Description: Lh_Cnt_Ic_Ar_Org_Map
Definition: Stores the records of organisms mapping to antimicrobial agents for the purpose of NHSN reporting
Table Type: REFERENCE





Column Detail - LH_CNT_IC_AR_ORG_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.
ANTIMICROBIAL_NAME VARCHAR(200) N The Antimicrobial agent which is used as an extension on codeset 1011 to identify the Antibiotics for AR reporting. This column is loaded from a csv and the client cannot update it so there is no need for the corresponding _KEY column.
BEG_EFFECTIVE_DT_TM DATETIME Y 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 Y 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_IC_AR_ORG_MAP_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_AR_ORG_MAP table.
NHSN_ORGANISM_SNOMED VARCHAR(100) N The organism snomed code to use for AR organism reporting to NHSN.
ORGANISM_NAME VARCHAR(200) N The Organism name which is used as an extension on codeset 1021 to identify the Organisms for AR reporting.
ORGANISM_NAME_KEY VARCHAR(200) N Stores corresponding string values from column ORGANISM_NAME for searching in UPPER case, less SPACES or special characters.
ORGANISM_NAME_KEY_A_NLS VARCHAR(800) N Stores the corresponding non-english ACCENTED character set values from column ORGANISM_NAME_KEY for international searches. Database triggers handle the population of these columns so scripts and applications can ignore them.
RXNORM_IDENT VARCHAR(60) N Identifier from RxNorm terminology.
SPECIMEN_NAME VARCHAR(100) N The name of the Specimen type for AR reporting.
SPECIMEN_NAME_KEY VARCHAR(100) N Stores corresponding string values from column SPECIMAN_NAME for searching in UPPER case, less SPACES or special characters.
SPECIMEN_NAME_KEY_A_NLS VARCHAR(400) N Stores the corresponding non-english ACCENTED character set values from column SPECIMEN_NAME_KEY for international searches. Database triggers handle the population of these columns so scripts and applications can ignore them.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.


LH_CNT_IC_CLUST_ANALYSIS



Column Section Top of Page


Table-level Detail

Description: lh_cnt_ic_clust_analysis
Definition: This table will contain data related to cluster analysis. A cluster analysis is determining when there are multiple instances of a client specified organism over a client defined timeframe. In other words, they may want to be alerted if they have three e-coli results in seven days.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_CLUST_ANALYSIS


Column Name Type Null? Definition
ADMIT_DT_TM DATETIME N The admit date is flexed based on the client for interfaced results. Can be the arrive_dt_tm or the reg_dt_tm from the encounter table.
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.
CLINICAL_EVENT_ID DOUBLE N Unique key from the clinical_event table. This is passed in from a Discern Rule to begin the evaluation.
COLLECT_DT_TM DATETIME N Date and time the specimen was collected used for the timeframe parameters in determining the cluster or outbreak. From the CE_SPECIMEN_COLL table.
ENCNTR_ID DOUBLE N Unique key from the Encounter table.
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.
EVENT_CD DOUBLE N Code value for the event_codes from clinical event
EVENT_ID DOUBLE N Non-unique field from the clinical_event table. Used in conjunction with valid_until_dt_tm from child tables to form unique indexes.
FIN VARCHAR(100) Y From the alias field on the encntr_alias table. Needed for reporting.
LH_CNT_IC_CLUST_ANALYSIS_ID DOUBLE N Unique generated number that identifies a single row on the lh_cnt_ic_clust_analysis table.
LOC_BED_CD DOUBLE N Identifies the bed where the encounter took place. Needed for reporting aspect.
LOC_BUILDING_CD DOUBLE N Identifies the building where the encounter took place. Needed to determine if the outbreak or cluster is applicable.
LOC_FACILITY_CD DOUBLE N Identifies the facility where the encounter took place. Needed to determine if the outbreak or cluster is applicable.
LOC_NURSE_UNIT_CD DOUBLE N Identifies the nurse_unit where the encounter took place. Needed to determine if the outbreak or cluster is applicable.
LOC_ROOM_CD DOUBLE N Identifies the room where the encounter took place. Needed for reporting aspect.
MDRO_CAT_NAME VARCHAR(100) Y Full name of the mdro category, as defined in the Bedrock MDRO wizard.
MDRO_CAT_NAME_KEY VARCHAR(100) Y Full name of the mdro category, as defined in the Bedrock MDRO wizard, spaces trimmed and all-caps.
MDRO_NAME VARCHAR(100) Y Full name of mdro as defined in Bedrock MDRO Wizard.
MDRO_NAME_KEY VARCHAR(100) Y Full name of mdro as defined in Bedrock MDRO Wizard, spaces trimmed and all-caps.
MRN VARCHAR(100) Y From the alias field on the encntr_alias table. Needed for reporting.
NOMENCLATURE_ID DOUBLE N ID to the Nomenclature table
NORMALCY_CD DOUBLE N Normalcy value for the event
ORDER_ID DOUBLE N Unique key from the orders table. This will be used to assist in determining the uniqueness of the data being considered for insert.
ORGANISM_CD DOUBLE N From code set 1021, populated from CE_MICROBIOLOGY table.
ORGANISM_OCCURRENCE_NBR DOUBLE Y From the CE_MICROBIOLOGY table, used to determine parts of an organism.
PERSON_ID DOUBLE N Unique key from the Person table.
RESULT_VAL VARCHAR(255) Y Stores the clinical_event result
SPECIMEN_SOURCE_CD DOUBLE N Populated from the source_type_cd on the CE_SPECIMEN_COLL table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.


LH_CNT_IC_LOC_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Content Infection Control Location History
Definition: patient locations based on a specific time.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_LOC_HIST


Column Name Type Null? Definition
BED_LOC_CD DOUBLE N Physical Bed Location of the patient at the location type time.
BUILD_LOC_CD DOUBLE N Physical building location of the patient at the location type time.
ENCNTR_ID DOUBLE N The encounter being reported on.
FAC_LOC_CD DOUBLE N The facility of the patient at the location type time.
LH_CNT_IC_LOC_HIST_ID DOUBLE N Unique, generated number that identifies a single row on the LH_CNT_IC_LOC_HIST table.
LOC_TYPE_FLAG DOUBLE N The location type of the encounter being reported on. (1 = Admit, 2 = Order, 3 = Collect.
NU_LOC_CD DOUBLE N The Nursing Unit of the patient at the location type time.
ROOM_LOC_CD DOUBLE N The room location of the patient at the location type time.
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_IC_LOC_HIST


Child Column in LH_CNT_IC_LOC_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
BED_LOC_CD LOCATION LOCATION_CD
BUILD_LOC_CD LOCATION LOCATION_CD
FAC_LOC_CD LOCATION LOCATION_CD
NU_LOC_CD LOCATION LOCATION_CD
ROOM_LOC_CD LOCATION LOCATION_CD