Table Detail Report

BR_AUTO_DTA



Column Section Top of Page


Table-level Detail

Description: BEDROCK AUTO DTA
Definition: autobuild assays
Table Type: REFERENCE





Column Detail - BR_AUTO_DTA


Column Name Type Null? Definition
ACTIVITY_TYPE_CD DOUBLE N activity type
BB_RESULT_PROCESSING_CD DOUBLE N result processing type associated to the Blood Bank DTA
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DESCRIPTION VARCHAR(100) Y legacy long name
MNEMONIC VARCHAR(50) Y legacy short name
RESULT_TYPE_CD DOUBLE N result type
TASK_ASSAY_CD DOUBLE N dta id
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.


BR_AUTO_MULTUM



Column Section Top of Page


Table-level Detail

Description: Bedrock Auto Multum
Definition: Because not all the data in the Multum tables is correct, the br_auto_multum table provides corrected data for the items that need corrected data. If a Multum item exists on the the br_auto_multum table then the fields on this table will be used instead of the ones in the Multum table.
Table Type: REFERENCE





Column Detail - BR_AUTO_MULTUM


Column Name Type Null? Definition
BRAND_NAME VARCHAR(255) Y Brand name column
CONCENTRATION_PER_ML DOUBLE Y Concentration per ML field
CONCENTRATION_UNIT VARCHAR(40) Y Concentration display field
CONCENTRATION_UNIT_CKI VARCHAR(255) Y CKI field
DC_DISPLAY_DAYS DOUBLE Y Used to populate the dc_display_days field on the order_catalog table
DC_INTER_DAYS DOUBLE Y Used to populate the dc_inter_days field on the order_catalog table
DEF_FORMAT DOUBLE Y Order entry format flag
DISPENSE_QTY DOUBLE Y Dispense quantityconcetnration unit cki
DISPENSE_QTY_UNIT VARCHAR(40) Y Dispense quantity display field
DISPENSE_QTY_UNIT_CKI VARCHAR(255) Y Cki field
DIVISIBLE_IND DOUBLE Y Divisibility indicator
GENERIC_NAME VARCHAR(255) Y Generic name field
INFINITE_DIV_IND DOUBLE Y Infinite divisibility indicator
LABEL_DESCRIPTION VARCHAR(255) Y Label description field
MINIMUM_DOSE_QTY DOUBLE Y Minimum dose quantity field
MMDC VARCHAR(25) N Main Multum drug code
PRODUCT_TYPE VARCHAR(6) Y Valid values for type flag are CONC, PKGVOL, and STD
SEARCH_CONT DOUBLE Y Continuous filter indicator
SEARCH_INTERMIT DOUBLE Y Intermittent filter indicator
SEARCH_MED DOUBLE Y Medication filter indicator
STRENGTH DOUBLE Y dosage Strength
STRENGTH_UNIT VARCHAR(40) Y Strength display field
STRENGTH_UNIT_CKI VARCHAR(255) Y Cki field
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.
VOLUME DOUBLE Y Volume field
VOLUME_UNIT VARCHAR(40) Y Volume display field
VOLUME_UNIT_CKI VARCHAR(255) Y Cki field


BR_AUTO_OC_DTA



Column Section Top of Page


Table-level Detail

Description: BEDROCK AUTO ODER CATALOG DTA
Definition: autobuild dta relationships
Table Type: REFERENCE





Column Detail - BR_AUTO_OC_DTA


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CATALOG_CD DOUBLE N order catalog id
SEQUENCE DOUBLE Y Sequence
TASK_ASSAY_CD DOUBLE N dta id
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.


BR_AUTO_OC_SYNONYM



Column Section Top of Page


Table-level Detail

Description: BEDROCK AUTO ORDER CATALOG SYNONYM
Definition: autobuild orderable synonymns
Table Type: REFERENCE





Column Detail - BR_AUTO_OC_SYNONYM


Column Name Type Null? Definition
ACTIVITY_SUBTYPE_CD DOUBLE N activity sub type
ACTIVITY_TYPE_CD DOUBLE N activity type
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CATALOG_CD DOUBLE N order catalog id
CATALOG_TYPE_CD DOUBLE N order catalog type
MNEMONIC VARCHAR(100) Y legacy short name
MNEMONIC_KEY_CAP VARCHAR(100) Y legacy short name, all caps
MNEMONIC_TYPE_CD DOUBLE N The mnemonic type associated to the order catalog.
OE_FORMAT_ID DOUBLE N Order entry format associated to the synonym.
SYNONYM_ID DOUBLE N Unique identifier for the table
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.


BR_AUTO_ORDER_CATALOG



Column Section Top of Page


Table-level Detail

Description: BEDROCK AUTO ORDER CATALOG
Definition: autobuild orderables
Table Type: REFERENCE





Column Detail - BR_AUTO_ORDER_CATALOG


Column Name Type Null? Definition
ACTIVITY_SUBTYPE_CD DOUBLE N activity sub type
ACTIVITY_SUBTYPE_DISPLAY VARCHAR(40) Y If the cdf meaning doesn't exist for the subactivity type define this field with the display value
ACTIVITY_TYPE_CD DOUBLE N activity type
ACTIVITY_TYPE_DISPLAY VARCHAR(40) Y Display of the activity type
BB_PROCESSING_CD DOUBLE N procedure type associated to the Blood Bank order
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CARDIOLOGY_IND DOUBLE Y Indicates whether order can be accessed by Cardiology
CATALOG_CD DOUBLE N order catalog id
CATALOG_TYPE_CD DOUBLE N order catalog type
CATALOG_TYPE_DISPLAY VARCHAR(40) Y Display of the catalog type
CKI VARCHAR(255) Y Cerner knowledge index
CONCEPT_CKI VARCHAR(255) Y Concept CKI associated to the order catalog item.
CPT4 VARCHAR(25) Y cpt4 code
DCP_CLIN_CAT_CD DOUBLE N The clinical category associated to the order catalog item.
DEPT_NAME VARCHAR(100) Y Department name for the order catalog item.
DESCRIPTION VARCHAR(100) Y Description for the order catalog item.
LABORATORY_IND DOUBLE Y Indicates whether order can be accessed by Laboratory
LOINC VARCHAR(10) Y loinc code
OE_FORMAT_ID DOUBLE N Order entry format associated to the order catalog item.
PATIENT_CARE_IND DOUBLE Y Indicates whether order can be accessed by Patient Care
PRIMARY_MNEMONIC VARCHAR(100) N Primary mnemonic for the order catalog item
RADIOLOGY_IND DOUBLE Y Indicates whether order can be accessed by Radiology
SURGERY_IND DOUBLE Y Indicates whether order can be accessed by Surgery
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.