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 |