Table Detail Report

BR_MED_ORDSENT_MAP



Column Section Top of Page


Table-level Detail

Description: Bedrock Medication Order Sentence Map
Definition: Stores mapping of order entry field values from a Multum value to a Millennium value.
Table Type: REFERENCE





Column Detail - BR_MED_ORDSENT_MAP


Column Name Type Null? Definition
BR_MED_ORDSENT_MAP_ID DOUBLE N Unique ID for the table
CODESET DOUBLE N The code set the field is from
FIELD_VALUE VARCHAR(255) N oe_field_value from mltm_order_sent_detail table
PARENT_ENTITY_ID DOUBLE N ID of the value that FIELD_VALUE is mapped t
PARENT_ENTITY_NAME VARCHAR(100) Y Table that the parent_entity_id resides on
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_NAME_VALUE



Column Section Top of Page


Table-level Detail

Description: BEDROCK NAME VALUE
Definition: reusable name/value pairs
Table Type: REFERENCE





Column Detail - BR_NAME_VALUE


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N *** OBSOLETE *** Identifies which bedrock client data belongs to
BR_NAME VARCHAR(50) N the ""name"" portion of the name/value pair
BR_NAME_VALUE_ID DOUBLE N Unique identifier for the table
BR_NV_KEY1 VARCHAR(50) N identifies the type of name/value pair on this table
BR_VALUE VARCHAR(100) N the ""value"" portion of the name/value pair
DEFAULT_SELECTED_IND DOUBLE Y Defined as 1 the name value should default in as selected.
START_VERSION_NBR DOUBLE N Identifies which version of start has been loaded
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_OC_PRICING



Column Section Top of Page


Table-level Detail

Description: BEDROCK OC PRICING
Definition: legacy orderable pricing information
Table Type: REFERENCE





Column Detail - BR_OC_PRICING


Column Name Type Null? Definition
BILLCODE VARCHAR(25) Y Billcode for the order catalog item.
BILLCODE_SCHED_CD DOUBLE N Unique identifier for the billcode schedule.
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
OC_ID DOUBLE N Unique identifier for the order catalog item.
PRICE DOUBLE N Price for the order catalog item.
PRICE_SCHED_ID DOUBLE N Unique identifier for the price schedule
PRICING_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_OC_RAD_ROOM



Column Section Top of Page


Table-level Detail

Description: BEDROCK OC RADIOLOGY ROOM
Definition: radiology orderable and service resource relationship
Table Type: REFERENCE





Column Detail - BR_OC_RAD_ROOM


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CATALOG_CD DOUBLE N Unique identifier for the order catalog item.
SERVICE_RESOURCE_CD DOUBLE N The service resource associated to the order catalog item.
START_VERSION_NBR DOUBLE Y Identifies which version of start has been loaded
STATUS DOUBLE N The status of whether the data is committed to the HNAM database.
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 date/time on which the record was added to the file
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_OC_SYNONYM



Column Section Top of Page


Table-level Detail

Description: BEDROCK OC SYNONYM
Definition: legacy orderable synonyms
Table Type: REFERENCE





Column Detail - BR_OC_SYNONYM


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
FACILITY VARCHAR(50) Y Used to identify individual facility data.
HIDE_FLAG DOUBLE Y The hide indicator for the order catalog item.
MNEMONIC VARCHAR(100) Y The mnemonic for the order catalog.
MNEMONIC_TYPE_CD DOUBLE N The mnemonic type associated to the order catalog.
OC_ID DOUBLE N The order catalog item unique identifier
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.
VIRTUAL_VIEWS VARCHAR(15) Y The virtual views for the order catalog item.