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