Table Detail Report
BB_QC_GRP_REAGENT_LOT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Blood Bank Quality Control Group Reagent Lot |
Definition: | This table maintains a list of reagents associated with a QC group. |
Table Type: | ACTIVITY |
Column Detail - BB_QC_GRP_REAGENT_LOT
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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CURRENT_IND | DOUBLE | N | Indicates the reagent lot that is currently available for use. |
DISPLAY_ORDER_SEQ | DOUBLE | N | This field contains the display order of the reagent lot within the group. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
GROUP_ID | DOUBLE | N | This field links the reagent to the specific quality control group. |
GROUP_REAGENT_LOT_ID | DOUBLE | N | This field uniquely identifies the reagent associated with a quality control Group |
LOT_INFORMATION_ID | DOUBLE | N | This field links the reagent lot row with the actual lot information row. (PCS_LOT_INFORMATION). |
PREV_GROUP_REAGENT_LOT_ID | DOUBLE | N | This field contains the id of the previous version of the current row. |
RELATED_REAGENT_ID | DOUBLE | N | This field contains the unique identifier of the reagent relationship associated with the reagent lot. |
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_QC_GRP_REAGENT_LOT
Child Column in BB_QC_GRP_REAGENT_LOT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | GROUP_ID | BB_QC_GROUP | GROUP_ID |
RELATED_REAGENT_ID | BB_QC_REL_REAGENT | RELATED_REAGENT_ID | |
LOT_INFORMATION_ID | PCS_LOT_INFORMATION | LOT_INFORMATION_ID |
Parent Column in BB_QC_GRP_REAGENT_LOT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | GROUP_REAGENT_LOT_ID | BB_QC_GRP_REAGENT_ACTIVITY | GROUP_REAGENT_LOT_ID |
BB_QC_REL_REAGENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Blood Bank Quality Control Related Reagent |
Definition: | This table maintains a list of reagent relationships that can be used in a quality control group. |
Table Type: | REFERENCE |
Column Detail - BB_QC_REL_REAGENT
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. |
REAGENT_CD | DOUBLE | N | This field contains the unique identifier of the reagent. |
RELATED_REAGENT_ID | DOUBLE | N | This field uniquely identifies the reagent relationship. |
RELATED_REAGENT_NAME | VARCHAR(40) | N | This field contains the name of the related reagent. |
RELATED_REAGENT_NAME_KEY | VARCHAR(40) | N | This field contains the name of the related reagent in uppercase with spaces and special characters removed. |
RELATED_REAGENT_NAME_KEY_A_NLS | VARCHAR(160) | Y | RELATED_REAGENT_NAME_KEY_A_NLS column |
RELATED_REAGENT_NAME_KEY_NLS | VARCHAR(82) | N | This field contains the corresponding non-English character set values for the _KEY column. |
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_QC_REL_REAGENT
Parent Column in BB_QC_REL_REAGENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RELATED_REAGENT_ID | BB_QC_GRP_REAGENT_LOT | RELATED_REAGENT_ID |
BB_QC_REL_REAGENT_DETAIL | RELATED_REAGENT_ID |
BB_QC_REL_REAGENT_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Blood Bank Quality Control Related Reagent |
Definition: | This table maintains a list of reagent relationships that can be used in a quality control group. |
Table Type: | REFERENCE |
Column Detail - BB_QC_REL_REAGENT_DETAIL
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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CONTROL_CD | DOUBLE | N | This field contains the unique identifier of the control reagent. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
ENHANCEMENT_CD | DOUBLE | N | This field contains the unique identifier of the enhancement reagent. |
PHASE_CD | DOUBLE | N | This field contains the unique identifier of the phase used during the QC testing. |
PREV_RELATED_REAGENT_DETAIL_ID | DOUBLE | N | This field contains the unique ID of the previous version of the current row. |
RELATED_REAGENT_DETAIL_ID | DOUBLE | N | This field uniquely identifies the reagent relationship detail. |
RELATED_REAGENT_ID | DOUBLE | N | This field contains the unique identifier of the parent reagent. |
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_QC_REL_REAGENT_DETAIL
Child Column in BB_QC_REL_REAGENT_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RELATED_REAGENT_ID | BB_QC_REL_REAGENT | RELATED_REAGENT_ID |
Parent Column in BB_QC_REL_REAGENT_DETAIL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RELATED_REAGENT_DETAIL_ID | BB_QC_EXPECTED_RESULT_R | RELATED_REAGENT_DETAIL_ID |
BB_QC_RESULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Blood Bank Quality Control Result |
Definition: | This table contains the outcomes for a specific Blood Bank QC reagent result. |
Table Type: | ACTIVITY |
Column Detail - BB_QC_RESULT
Column Name | Type | Null? | Definition |
---|---|---|---|
ABNORMAL_IND | DOUBLE | N | This field indicates if the result is abnormal or not an expected result. |
ACTION_DT_TM | DATETIME | Y | The date and time that the QC result status is changed without verifying the result. |
ACTION_PRSNL_ID | DOUBLE | N | The ID of the person that changed the QC result status without verifying the result. |
COMMENT_TEXT_ID | DOUBLE | N | This field contains the unique identifier of the comment associated with the result (LONG_TEXT) |
CONTROL_ACTIVITY_ID | DOUBLE | N | This field links the result row with a specific Group Reagent Activity |
ENHANCEMENT_ACTIVITY_ID | DOUBLE | N | This filed links the result row with a specific enhancement Group Reagent Activity |
GROUP_REAGENT_ACTIVITY_ID | DOUBLE | N | This field links the QC result with a specific reagent activity row. |
NOMENCLATURE_ID | DOUBLE | N | This field links the result row with a specific row on the nomenclature table. |
PHASE_CD | DOUBLE | N | This field contains the unique identifier of the phase used for the QC testing. |
PRIMARY_REVIEW_DT_TM | DATETIME | N | This field contains the date and time the result was reviewed by the primary user. |
PRIMARY_REVIEW_PRSNL_ID | DOUBLE | N | This field contains the identifier of the primary reviewer. |
QC_RESULT_ID | DOUBLE | N | quality control result identifier |
REASON_CD | DOUBLE | N | This field contains the unique identifier of the selected reason when a QC result is accepted, retested, or discarded. (CS:325576) |
RESULT_DT_TM | DATETIME | N | Contains the date and time the result was recorded. |
RESULT_PRSNL_ID | DOUBLE | N | This field contains the unique identifier of the personnel that recorded the result |
SECONDARY_REVIEW_DT_TM | DATETIME | N | This field contains the date and time the result was reviewed by the secondary user. |
SECONDARY_REVIEW_PRSNL_ID | DOUBLE | N | This field contains the identifier of the secondary reviewer. |
STATUS_CD | DOUBLE | N | This field contains the unique identifier of the current result status. |
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_QC_RESULT
Child Column in BB_QC_RESULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONTROL_ACTIVITY_ID | BB_QC_GRP_REAGENT_ACTIVITY | GROUP_REAGENT_ACTIVITY_ID |
ENHANCEMENT_ACTIVITY_ID | BB_QC_GRP_REAGENT_ACTIVITY | GROUP_REAGENT_ACTIVITY_ID | |
GROUP_REAGENT_ACTIVITY_ID | BB_QC_GRP_REAGENT_ACTIVITY | GROUP_REAGENT_ACTIVITY_ID | |
COMMENT_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
ACTION_PRSNL_ID | PRSNL | PERSON_ID | |
PRIMARY_REVIEW_PRSNL_ID | PRSNL | PERSON_ID | |
RESULT_PRSNL_ID | PRSNL | PERSON_ID | |
SECONDARY_REVIEW_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in BB_QC_RESULT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | QC_RESULT_ID | BB_QC_RESULT_TROUBLESHOOTING_R | QC_RESULT_ID |
BB_QC_RESULT_TROUBLESHOOTING_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Blood Bank Quality Control Result Troubleshooting |
Definition: | This table contains the selected troubleshooting steps selected when a Blood Bank QC result is abnormal |
Table Type: | ACTIVITY |
Column Detail - BB_QC_RESULT_TROUBLESHOOTING_R
Column Name | Type | Null? | Definition |
---|---|---|---|
QC_RESULT_ID | DOUBLE | N | This field links the troubleshooting step with the specific QC result. (BB_QC_RESULT) |
RESULT_TROUBLESHOOTING_ID | DOUBLE | N | This field uniquely identifies the troubleshooting row. |
TROUBLESHOOTING_ID | DOUBLE | N | This field contains the unique identifier of the selected troubleshooting step. |
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_QC_RESULT_TROUBLESHOOTING_R
Child Column in BB_QC_RESULT_TROUBLESHOOTING_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | QC_RESULT_ID | BB_QC_RESULT | QC_RESULT_ID |
TROUBLESHOOTING_ID | BB_QC_TROUBLESHOOTING | TROUBLESHOOTING_ID |