LH_BR_CPC_LOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Light House Bedrock Comprehensive Primary Care Location Relation
Definition: This table keeps track of CPC's and PCF's who have a need to map to a location already associated to another CPC or PCF.
Table Type: REFERENCE





Column Detail - LH_BR_CPC_LOC_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 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.
BR_CPC_ID DOUBLE Y The CPC group that is associated to this location.
BR_CPC_LOC_RELTN_ID DOUBLE Y Unique, generated number that identifies a single row on the BR_CPC_LOC_RELTN table.
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_BR_CPC_LOC_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the LH_BR_CPC_LOC_RELTN table.
LOCATION_CD DOUBLE Y The code for the location that needs to be associated to the CPC or PCF listed in BR_CPC_ID.
ORIG_BR_CPC_LOC_RELTN_ID DOUBLE Y The original id for the row.
UPDT_CNT DOUBLE Y 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 Y 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 Y 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_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
UPDT_TASK DOUBLE Y 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_BR_CPC_LOC_RELTN


Child Column in LH_BR_CPC_LOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: BR_CPC_ID BR_CPC BR_CPC_ID


LH_D_ANTIBIOTIC



Column Section Top of Page


Table-level Detail

Description: LH_D_ANTIBIOTIC
Definition: Dimension table to store Antibiotics Reference Data for Infection Control Reports
Table Type: REFERENCE





Column Detail - LH_D_ANTIBIOTIC


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.
ANTIBIOTIC_CD DOUBLE N CODE SET 1011
ANTIBIOTIC_DESCRIPTION VARCHAR(60) Y The description of the antibiotic
ANTIBIOTIC_DISPLAY VARCHAR(50) Y The display value for the antibiotic
ANTIBIOTIC_MEANING VARCHAR(50) Y The Cerner-identified meaning for the antibiotic
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.
D_ANTIBIOTIC_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_ANTIBIOTIC table.
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.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This filed should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data
PROCESS_DT_TM DATETIME Y The date/time the record wad first loaded into the table.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row.


LH_D_IC_ANTIBGRM_GROUP



Column Section Top of Page


Table-level Detail

Description: LH_D_IC_ANTIBGRM_GROUP
Definition: Dimension table to store content IC Antibiogram Group Data for Infection Control Reports
Table Type: REFERENCE





Column Detail - LH_D_IC_ANTIBGRM_GROUP


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 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.
D_IC_ANTIBGRM_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_IC_ANTIBGRM_GROUP table.
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.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This filed should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time.
GROUP_NAME VARCHAR(100) N Group display name
GROUP_TYPE_FLAG DOUBLE N Stores the type of groups to be setup ( 1 = organism group 2 = Encounter type group 3= Specimen group)
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data
LH_CNT_IC_ANTIBGRM_GROUP_ID DOUBLE N Unique ID for each group in LH_CNT_IC_ANTIBGRM_GROUP table
PROCESS_DT_TM DATETIME Y The date/time the record wad first loaded into the table.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row.


LH_D_IC_ANTIBGRM_GROUP_R



Column Section Top of Page


Table-level Detail

Description: LH_D_IC_ANTIBGRM_GROUP_R
Definition: Dimension table to store content IC Antibiogram Group Relation Data for Infection Control Reports
Table Type: REFERENCE





Column Detail - LH_D_IC_ANTIBGRM_GROUP_R


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 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.
D_ENCNTR_TYPE_ID DOUBLE N identifies the source configure with this encounter type group ; 0 for non-encounter type group. Unique generated number that identifies a single row on the LH_D_ENCNTR_TYPE table.
D_IC_ANTIBGRM_GROUP_R_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_IC_ANTIBGRM_GROUP_R table.
D_ORGANISM_ID DOUBLE N identifies the organism configure with this organism group; 0 for non-organism group. Unique generated number that identifies a single row on the LH_D_ORGANISM table.
D_SOURCE_ID DOUBLE N identifies the source configure with this specimen group ; 0 for non-specimen group. Unique generated number that identifies a single row on the LH_D_SOURCE table.
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.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This filed should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time.
GROUP_TYPE_FLAG DOUBLE N Stores the type of groups to be setup ( 1 = organism group 2 = Encounter type group 3= Specimen group)
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data
LH_CNT_IC_ANTIBGRM_GROUP_ID DOUBLE N Primary key from the LH_CNT_IC_ANTIBGRM_GROUP table.
LH_CNT_IC_ANTIBGRM_GROUP_R_ID DOUBLE N Primary key from the LH_CNT_IC_ANTIBGRM_GROUP_R table.
PARENT_ENTITY_ID DOUBLE N the value of parent_entity_id in LH_CNT_IC_ANTIBGRM_GROUP_R table
PARENT_ENTITY_NAME VARCHAR(50) N the value of parent_entity_name in LH_CNT_IC_ANTIBGRM_GROUP_R table
PROCESS_DT_TM DATETIME Y The date/time the record wad first loaded into the table.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row.


LH_D_IC_ANTIBGRM_ORG_DSC



Column Section Top of Page


Table-level Detail

Description: LH_D_IC_ANTIBGRM_ORG_DSC
Definition: Dimension table to store content IC Antibiogram Organism Disclaim and Suppression Reference Data for Infection Control Reports
Table Type: REFERENCE





Column Detail - LH_D_IC_ANTIBGRM_ORG_DSC


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 Y The date/time on which the record became effective; defaults to 1/01/1800.
D_ANTIBIOTIC_ID DOUBLE N identifies the antibiotic configure with this suppression/disclaimer. Unique generated number that identifies a single row on the LH_D_ANTIBIOTIC table.
D_FACILITY_ID DOUBLE N identifies the facility configure with this suppression/disclaimer. Unique generated number that identifies a single row on the LH_D_FACILITY table.
D_IC_ANTIBGRM_ORG_DSC_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_IC_ANTIBGRM_ORG_DSC table.
D_ORGANISM_ID DOUBLE N identifies the organism configure with this suppression/disclaimer. Unique generated number that identifies a single row on the LH_D_ORGANISM table.
END_EFFECTIVE_DT_TM DATETIME Y The date/time on which the record is no longer effective; defaults to 12/31/2100.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This filed should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data
LH_CNT_IC_ANTIBGRM_GROUP_ID DOUBLE N Unique ID for each group in LH_CNT_IC_ANTIBGRM_GROUP table
LH_CNT_IC_ANTIBGRM_ORG_DSC_ID DOUBLE N Unique ID for declaim-suppression of organism group or Facility in LH_CNT_IC_ANTIBGRM_ORG_DSC table
LONG_TEXT VARCHAR(1000) Y The actual long data of suppression or disclaimer.
LONG_TEXT_ID DOUBLE N The long_text_id of suppression/disclaimer on LH_CNT_IC_ANTIBGRM_ORG_DSC table. Unique generated number that identifies a single row on the LONG_TEXT_REFERENCE table.
PROCESS_DT_TM DATETIME Y The date/time the record wad first loaded into the table.
SUPPRESS_IND DOUBLE Y The actual long data for suppression /disclaimer.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row.