Table Detail Report

BR_OC_WORK



Column Section Top of Page


Table-level Detail

Description: BEDROCK OC WORK
Definition: legacy orderables
Table Type: REFERENCE





Column Detail - BR_OC_WORK


Column Name Type Null? Definition
ACTIVITY_SUBTYPE VARCHAR(40) Y The activity subtype associated to the order catalog item
ACTIVITY_TYPE VARCHAR(40) Y The activity type associated to the order catalog item
ALIAS1 VARCHAR(50) Y Alias associated to order catalog item.
ALIAS2 VARCHAR(50) Y Alias associated to order catalog item.
ALIAS3 VARCHAR(50) Y Alias associated to order catalog item.
ALIAS4 VARCHAR(50) Y Alias associated to order catalog item.
ALIAS5 VARCHAR(50) Y Alias associated to order catalog item.
BILL_ONLY_IND DOUBLE Y Defined as 1 order catalog item is bill only.
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CARESET_IND DOUBLE Y Defined as 1 order catalog item is a careset.
CATALOG_TYPE VARCHAR(40) Y The catalog type associated to the order catalog item
COMMIT_IND DOUBLE N Commit Indicator
DEPT_NAME VARCHAR(100) Y Department name for the order catalog item.
DUP_CHECK_SEQ DOUBLE Y The duplicate check sequence
EXACT_HIT_ACTION_CD DOUBLE N The duplicate check exact action
FACILITY VARCHAR(50) Y Used to define individual facility data.
HISTORY_IND DOUBLE Y Defined as 1 the history indicator for radiology has been defined.
LOINC_CODE VARCHAR(10) Y Loinc code associated to the order catalog item
LONG_DESC VARCHAR(100) Y Long description for the order catalog item
MATCH_IND DOUBLE Y indicates if a match has been made for that orderable
MATCH_ORDERABLE_CD DOUBLE N HNAM order catalog item the legacy order catalog item was matched to
MATCH_VALUE VARCHAR(100) Y The value that triggered the automated match.
MIN_AHEAD DOUBLE Y Duplicate checking minutes ahead
MIN_AHEAD_ACTION_CD DOUBLE N Duplicate checking minutes ahead action
MIN_BEHIND DOUBLE Y Duplicate checking minutes behind action
MIN_BEHIND_ACTION_CD DOUBLE N Duplicate checking minutes behind action
OC_ID DOUBLE N Unique identifier for order catalog item
OE_FORMAT_ID DOUBLE N The order entry format associated to the order catalog item
ORG_LONG_NAME VARCHAR(100) Y This is the long form of the organization's name.
ORG_SHORT_NAME VARCHAR(100) Y This is the abbreviated form of the organization's name.
SHORT_DESC VARCHAR(100) Y Short description for the order catalog item
SKIP_MATCH_IND DOUBLE Y Defined as 1 skip the order catalog item.
STATUS_IND DOUBLE Y 0 - no match, 1 = exact match, 2 = one to one match, 3 =cpt4 , 5 = manual match
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_OF_DEPTS



Column Section Top of Page


Table-level Detail

Description: BEDROCK ORDER FOLDER DEPARTMENTS
Definition: Stores the standard order folder department choices to be displayed in the Bedrock Order Folders wizard
Table Type: REFERENCE





Column Detail - BR_OF_DEPTS


Column Name Type Null? Definition
OF_DEPT_ID DOUBLE N ID of the department
OF_DEPT_NAME VARCHAR(50) N Name of the department displayed in the Bedrock Order Folders wizard
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_OF_PARENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Order Folder Parent Relationship
Definition: When a new order folder is created, a row is added to this table to track the source from which the order folder was created.
Table Type: REFERENCE





Column Detail - BR_OF_PARENT_RELTN


Column Name Type Null? Definition
ALT_SEL_CATEGORY_ID DOUBLE N Provides a link between the br_of_parent_reltn table and the alt_sel_cat table
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
SOURCE_ID DOUBLE N If the value in the source_name field is a table name, then the value in the source_id field provides a link between the br_of_parent_reltn table and the table indicated in the source_name field. If the value in the source_name field is not a table name, then the source_id field will have a value of 0.
SOURCE_NAME VARCHAR(32) N The source_name field indicates the source of a new order folder. The source_name can be a table on which the value in the source_id field is a key or it can be free-text. If free-text, then the source_id will have a value of 0.
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.



Relationship Detail - BR_OF_PARENT_RELTN


Child Column in BR_OF_PARENT_RELTN(FK) Parent Table Name Parent Column Name
Parents: ALT_SEL_CATEGORY_ID ALT_SEL_CAT ALT_SEL_CATEGORY_ID


BR_ORDSENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Order Sentence
Definition: Stores order sentences and their display lines
Table Type: REFERENCE





Column Detail - BR_ORDSENT


Column Name Type Null? Definition
BR_ORDSENT_ID DOUBLE N Unique ID for the table
CATALOG_CKI VARCHAR(255) N CKI for the associated orderable
MMDC VARCHAR(255) N main Multum drug code
ORDSENT_COUNT DOUBLE N number of times sentences appeared in activity data
ORDSENT_DISPLAY VARCHAR(255) Y Order Sentence display column
SOURCE_FLAG DOUBLE Y where sentence was retrieved from, 1: activity data
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.



Relationship Detail - BR_ORDSENT




Parent Column in BR_ORDSENT (PK) Child Table Name Child Column Name
Children: BR_ORDSENT_ID BR_ORDSENT_DETAIL BR_ORDSENT_ID


BR_ORDSENT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Order Sentence Detail
Definition: Stores the individual fields of an order sentence
Table Type: REFERENCE





Column Detail - BR_ORDSENT_DETAIL


Column Name Type Null? Definition
BR_ORDSENT_DETAIL_ID DOUBLE N Unique ID for the table
BR_ORDSENT_ID DOUBLE N Value from the BR_ORDSENT table.
OE_FIELD_MEANING VARCHAR(255) N order entry field meaning
OE_FIELD_VALUE VARCHAR(255) N value for the order entry 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.



Relationship Detail - BR_ORDSENT_DETAIL


Child Column in BR_ORDSENT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: BR_ORDSENT_ID BR_ORDSENT BR_ORDSENT_ID