Table Detail Report

BR_AUTO_RLI_ALIAS



Column Section Top of Page


Table-level Detail

Description: Bedrock Auto RLI Alias
Definition: This table contains all of the alias value mappings for a reference lab's orderable items. This is an autobuild content table used in the Bedrock reference lab interface table.
Table Type: REFERENCE





Column Detail - BR_AUTO_RLI_ALIAS


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N Flag value to indicate whether the value is aliased to an existing code_value or a newly created code_value.0
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.
ALIAS_ID DOUBLE N Unique identifier for the alias.
ALIAS_NAME VARCHAR(100) Y The alias value.
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CDF_MEANING VARCHAR(12) Y If applicable, the CDF_MEANING of the code_value to which the alias is related.
CODE_SET DOUBLE N The code_set number to which the alias is related.
CODE_VALUE DOUBLE N The code_value to which the alias is related.
DEFINITION VARCHAR(100) Y The definition of the code_value to which the alias is related.
DESCRIPTION VARCHAR(60) Y The description of the code_value to which the alias is related.
DISPLAY VARCHAR(40) Y The display of the code_value to which the alias is related.
SUPPLIER_FLAG DOUBLE N Flag value used to identify the reference lab.
UNIT_MEANING VARCHAR(12) Y The meaning for a unit of measure if the alias is related to a value on code set 54.
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_RLI_CONTAINER



Column Section Top of Page


Table-level Detail

Description: Bedrock Auto RLI container
Definition: This table lists the containers related to a reference lab orderable item. This is an autobuild content table used in the Bedrock Reference Lab Interface wizard.
Table Type: REFERENCE





Column Detail - BR_AUTO_RLI_CONTAINER


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CONTAINER VARCHAR(100) N Display value of the container related to the orderable item.
CONTAINER_ALIAS_ID DOUBLE N Unique identifier of the container alias stored in the autobuild alias table.
RLI_ORDER_ID DOUBLE N Unique identifier for the reference lab orderable item.
SUPPLIER_FLAG DOUBLE N Flag value used to identify the reference lab.
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_RLI_DTA



Column Section Top of Page


Table-level Detail

Description: Bedrock Auto RLI data
Definition: This table stored the discrete task assays from a reference lab. This is a Bedrock autobuild content table.
Table Type: REFERENCE





Column Detail - BR_AUTO_RLI_DTA


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.
ALIAS_NAME VARCHAR(100) Y Reference Lab's supplied alias value for the discrete task assay.
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DESCRIPTION VARCHAR(100) Y Long description of the discrete task assay.
MNEMONIC VARCHAR(100) Y Mnemonic for the discrete task assay.
PERFORMING_LOC VARCHAR(100) Y String defining where the order is performed.
RLI_DTA_ID DOUBLE N Unique identifier of the reference lab's discrete task assay.
SUPPLIER_FLAG DOUBLE N Flag value used to identify the reference lab.
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_RLI_ORDER



Column Section Top of Page


Table-level Detail

Description: Bedrock Auto RLI order
Definition: Contains the orderable items for a reference lab. This is a Bedrock autobuild content table used in the reference lab order wizard.
Table Type: REFERENCE





Column Detail - BR_AUTO_RLI_ORDER


Column Name Type Null? Definition
ACCESSION_CLASS VARCHAR(100) Y Description of the accession class for the orderable item.
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.
ALIAS_NAME VARCHAR(100) Y Alias value for the orderable item, supplied by the reference lab.
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
COLLECTION_CLASS VARCHAR(100) Y Description of the collection class for the orderable item.
COLLECTION_METHOD VARCHAR(100) Y Description of the collection method for the orderable item.
CONCEPT_CKI VARCHAR(100) Y stores the Cerner-assigned concept_cki value that is assigned to the orderable item
CONTAINER VARCHAR(300) Y Description of the container for the orderable item.
DEFAULT_SELECTED_IND DOUBLE Y Indicator value defining whether the orderable item is automatically selected.
DEPT_NAME VARCHAR(100) Y Department name for the orderable item.
MIN_VOL DOUBLE Y Minimum volume required for the orderable item specimen.
MIN_VOL_UNITS VARCHAR(100) Y Description of the minimum volume units for the orderable item.
MIN_VOL_VALUE DOUBLE Y value of the minimum volume
ORDER_DESC VARCHAR(100) Y Long description of the orderable item.
ORDER_MNEMONIC VARCHAR(100) Y Mnemonic of the orderable item.
PARENT_ORDER_ID DOUBLE Y stores the id of the primary parent row on the br_auto_rli_table, and signifies that this is a child row
PERFORMING_LOC VARCHAR(100) Y String defining where the order is performed.
RLI_ORDER_ID DOUBLE N Unique identifier for the reference lab orderable item.
SPECIAL_HANDLING VARCHAR(100) Y Description of the special handling instructions for the orderable item.
SPECIMEN_TYPE VARCHAR(100) Y Description of the specimen type for the orderable item.
SUPPLIER_FLAG DOUBLE N Flag value identifying the reference lab.
SUPPLIER_MNEMONIC VARCHAR(100) Y Reference lab's mnemonic for the orderable item.
TRANSFER_TEMP VARCHAR(100) Y Description of the transfer temperature for the orderable item.
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_RLI_ORDER_DTA_R



Column Section Top of Page


Table-level Detail

Description: Bedrock Auto RLI Order DTA Relationship
Definition: This table stores the relationship between a reference lab's orderable items and discrete task assays. This is an autobuild content table used in the Bedrock Reference Lab Interface Wizard.
Table Type: REFERENCE





Column Detail - BR_AUTO_RLI_ORDER_DTA_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.
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
RLI_DTA_ID DOUBLE N Unique identifier for the reference lab discrete task assay.
RLI_ORDER_ID DOUBLE N Unique identifier for the reference lab orderable item.
SUPPLIER_FLAG DOUBLE N Flag value used to identify the reference lab.
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.