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 |