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