BB_GROUP_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Group Component
Definition: A child table of the bb_test_group table, this table defines the components of the group defined onthe bb_test_group table. These components consist of orderable procedures.
Table Type: REFERENCE





Column Detail - BB_GROUP_COMPONENT


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BB_GROUP_COMPONENT_ID DOUBLE N An internal system-assigned number that ensures the uniqueness of each row.
BB_TEST_GROUP_ID DOUBLE N Identifies the test group for which these orderables are associated. This column is the primary key on the bb_test_group table.
CATALOG_CD DOUBLE N The code value for this orderable. An item in the order catalog.
SEQUENCE DOUBLE N The sequence number associated with this orderable within the test group. This sequence number is used by during result entry to display the orderables in the user-defined sequence desired.
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 - BB_GROUP_COMPONENT


Child Column in BB_GROUP_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: BB_TEST_GROUP_ID BB_TEST_GROUP BB_TEST_GROUP_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD


BB_ORDER_CELL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Order Cell
Definition: Control cells that have been associated with a certain order on a patient in result entry.
Table Type: ACTIVITY





Column Detail - BB_ORDER_CELL


Column Name Type Null? Definition
BB_RESULT_ID DOUBLE N An internal system-assigned number. This ID is assigned for every row in the spreadsheet of the Result Entry application that involves entering cells under the accession.
CELL_CD DOUBLE N The cell entered in the Result Entry application for this order, ex. "Cell I", "Cell II", etc.
ORDER_CELL_ID DOUBLE N The primary key for this table. An internal system-assigned number that makes each row unique.
ORDER_ID DOUBLE N The primary key to the ORDERS table. An internal system-assigned number. On this table, it corresponds to the order for which the cell was entered in the Result Entry application.
PHASE_GROUP_CD DOUBLE N The phase group entered in the Result Entry application for this order, ex. "Warm PhasesI", etc.
PRODUCT_ID DOUBLE N The primary key to the PRODUCT table. An internal system-assigned number. On this table, it corresponds to the product entered in the Result Entry application for this order. This column is optional.
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 - BB_ORDER_CELL


Child Column in BB_ORDER_CELL(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
PRODUCT_ID PRODUCT PRODUCT_ID


BB_ORDER_PHASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Order Phase
Definition: Phases of a testing procedure that have been selected by the user as associated with a certain order on a patient, in result entry.
Table Type: ACTIVITY





Column Detail - BB_ORDER_PHASE


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.
ORDER_ID DOUBLE N The primary key to the ORDERS table. An internal system-assigned number. On this table, it corresponds to the order for which the cell was entered in the Result Entry application.
ORDER_PHASE_ID DOUBLE N The primary key for this table. An internal system-assigned number that makes each row unique.
PHASE_GRP_CD DOUBLE N The phase group entered in the Result Entry application for this order, ex. "Warm PhasesI", etc.
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.



Relationship Detail - BB_ORDER_PHASE


Child Column in BB_ORDER_PHASE(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID


BB_TEST_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: The groups of orderables defined for which results will be entered.
Definition: The groups of orderables defined for which results will be entered. These groups are used to limitthe types of procedures to be resulted.
Table Type: REFERENCE





Column Detail - BB_TEST_GROUP


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BB_TEST_GROUP_ID DOUBLE N The primary key of this table. An internal system-assigned number that ensures the uniqueness of each row.
TEST_GROUP_DESCRIPTION VARCHAR(50) Y A description of the group of orderables to be resulted.
TEST_GROUP_DISPLAY CHAR(15) N The short description of the group of orderables that should be displayed at the time the results are being entered.
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 - BB_TEST_GROUP




Parent Column in BB_TEST_GROUP (PK) Child Table Name Child Column Name
Children: BB_TEST_GROUP_ID BB_GROUP_COMPONENT BB_TEST_GROUP_ID
BB_WORKLIST TEST_GROUP_ID


BB_WORKLIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Worklist
Definition: Stores the high-level Blood Bank worklist information. Worklists are created as a means of quickly saving and loading groups of Blood Bank orders.
Table Type: ACTIVITY





Column Detail - BB_WORKLIST


Column Name Type Null? Definition
CREATE_DT_TM DATETIME N Contains the date and time the worklist was created.
CREATE_PRSNL_ID DOUBLE N Contains the internal identification code of the personnel that created the worklist.
DOWNLOAD_IND DOUBLE N Indicates whether or not the worklist has been downloaded to the instrument queue.
LAST_DOWNLOAD_DT_TM DATETIME Y Contains the date and time the worklist was last downloaded.
QC_GROUP_ID DOUBLE N Contains the internal identification code of the Quality Control Group associated with the worklist.
TEST_GROUP_ID DOUBLE N Contains the internal identification code of the Test Group associated with the worklist.
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.
WORKLIST_ID DOUBLE N Contains the internal identification code that uniquely identifies the worklist.
WORKLIST_NAME VARCHAR(40) N Contains the display name for the worklist.
WORKLIST_NAME_KEY VARCHAR(40) N Contains the display key of the worklist.
WORKLIST_NAME_KEY_A_NLS VARCHAR(160) Y WORKLIST_NAME_KEY_A_NLS column
WORKLIST_NAME_KEY_NLS VARCHAR(82) N This field contains the same data as the worklist_name_key only stored in the corresponding non-English character set values for _key.



Relationship Detail - BB_WORKLIST


Child Column in BB_WORKLIST(FK) Parent Table Name Parent Column Name
Parents: QC_GROUP_ID BB_QC_GROUP GROUP_ID
TEST_GROUP_ID BB_TEST_GROUP BB_TEST_GROUP_ID
CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in BB_WORKLIST (PK) Child Table Name Child Column Name
Children: WORKLIST_ID BB_WORKLIST_DETAIL WORKLIST_ID