BB_QC_EXPECTED_RESULT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Quality Control Expected Result
Definition: This field maintains a list of expected results for a specific QC group relationship.
Table Type: REFERENCE





Column Detail - BB_QC_EXPECTED_RESULT_R


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.
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.
EXPECTED_RESULT_ID DOUBLE N This field uniquely identifies the expected result row.
NOMENCLATURE_ID DOUBLE N This field contains the unique identifier of the expected result (Nomenclature)
PREV_EXPECTED_RESULT_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 links the expected result with a specific group relationship row (BB_QC_REL_REAGENT_DETAIL)
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_EXPECTED_RESULT_R


Child Column in BB_QC_EXPECTED_RESULT_R(FK) Parent Table Name Parent Column Name
Parents: RELATED_REAGENT_DETAIL_ID BB_QC_REL_REAGENT_DETAIL RELATED_REAGENT_DETAIL_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


BB_QC_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Quality Control Group
Definition: This table maintains a list of Blood Bank quality control groups.
Table Type: REFERENCE





Column Detail - BB_QC_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.
GROUP_DESC VARCHAR(60) N This field contains the long description for the quality control group.
GROUP_ID DOUBLE N This field uniquely identifies the quality control group.
GROUP_NAME VARCHAR(40) N This field contains the short display name for the quality control group.
GROUP_NAME_KEY VARCHAR(40) N This field contains the same data as the group name column only it is converted to uppercase.
GROUP_NAME_KEY_A_NLS VARCHAR(160) Y GROUP_NAME_KEY_A_NLS column
GROUP_NAME_KEY_NLS VARCHAR(82) N This field contains the same data as the group_name_key only stored in the corresponding non-English character set values for _KEY.
REQUIRE_VALIDATION_IND DOUBLE N This field indicates if the user will be required to validate the lot numbers for each scheduled quality control entry.
SCHEDULE_CD DOUBLE N This field contains the unique identifier of the associated schedule code.
SERVICE_RESOURCE_CD DOUBLE N This field contains the unique identifier of the associated service resource code.
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_GROUP




Parent Column in BB_QC_GROUP (PK) Child Table Name Child Column Name
Children: GROUP_ID BB_QC_GROUP_ACTIVITY GROUP_ID
BB_QC_GROUP_ACTIVITY RELATED_GROUP_ID
BB_QC_GROUP_XREF GROUP_ID
BB_QC_GROUP_XREF RELATED_GROUP_ID
BB_QC_GRP_REAGENT_LOT GROUP_ID
BB_WORKLIST QC_GROUP_ID
RESULT BB_GROUP_ID


BB_QC_GROUP_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Quality Control Group Activity
Definition: This table contains the scheduled activity for specific Blood Bank QC Groups
Table Type: ACTIVITY





Column Detail - BB_QC_GROUP_ACTIVITY


Column Name Type Null? Definition
GROUP_ACTIVITY_ID DOUBLE N This field uniquely identifies the group activity row
GROUP_ID DOUBLE N This field links the activity row to a specific QC group (BB_QC_GROUP)
LOCK_DT_TM DATETIME Y This field contains the date and time the lock was taken.
LOCK_PRSNL_ID DOUBLE N This field contains the unique identifier of the personnel that is currently updating the QC result activity.
RELATED_GROUP_ID DOUBLE N This field links the activity row to the cross-references quality control group.
SCHEDULED_DT_TM DATETIME N This field contains the date and time the quality control group results were scheduled to be completed.
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_GROUP_ACTIVITY


Child Column in BB_QC_GROUP_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: GROUP_ID BB_QC_GROUP GROUP_ID
RELATED_GROUP_ID BB_QC_GROUP GROUP_ID
LOCK_PRSNL_ID PRSNL PERSON_ID




Parent Column in BB_QC_GROUP_ACTIVITY (PK) Child Table Name Child Column Name
Children: GROUP_ACTIVITY_ID BB_QC_GRP_REAGENT_ACTIVITY GROUP_ACTIVITY_ID


BB_QC_GROUP_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Quality Control Group Cross Reference
Definition: This table maintains a list of Blood Bank QC cross-reference groups.
Table Type: REFERENCE





Column Detail - BB_QC_GROUP_XREF


Column Name Type Null? Definition
GROUP_ID DOUBLE N This field identifies the QC group being cross-referenced from. (BB_QC_GROUP)
GROUP_XREF_ID DOUBLE N This field uniquely identifies the QC group cross-reference
RELATED_GROUP_ID DOUBLE N This field identifies the QC group being cross-referenced to. (BB_QC_GROUP)
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_GROUP_XREF


Child Column in BB_QC_GROUP_XREF(FK) Parent Table Name Parent Column Name
Parents: GROUP_ID BB_QC_GROUP GROUP_ID
RELATED_GROUP_ID BB_QC_GROUP GROUP_ID


BB_QC_GRP_REAGENT_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Quality Control Group Reagent Activity
Definition: This table contains the activity for each reagent associated with a specific Blood Bank Quality Control Group.
Table Type: ACTIVITY





Column Detail - BB_QC_GRP_REAGENT_ACTIVITY


Column Name Type Null? Definition
ACTIVITY_DT_TM DATETIME N This field contains the date and time the activity was recorded.
ACTIVITY_PRSNL_ID DOUBLE N This field contains the unique identifier of the personnel that recorded the activity.
GROUP_ACTIVITY_ID DOUBLE N This field links the reagent activity row with a specific group activity row.
GROUP_REAGENT_ACTIVITY_ID DOUBLE N This field uniquely identifies the reagent activity row.
GROUP_REAGENT_LOT_ID DOUBLE N This field links the reagent activity to a specific reagent lot.
INTERPRETATION_CD DOUBLE N This field contains the unique identifier of the reagent final interpretation.
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.
VISUAL_INSPECTION_CD DOUBLE N This field contains the unique identifier of the reagent visual inspection outcome.



Relationship Detail - BB_QC_GRP_REAGENT_ACTIVITY


Child Column in BB_QC_GRP_REAGENT_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: GROUP_ACTIVITY_ID BB_QC_GROUP_ACTIVITY GROUP_ACTIVITY_ID
GROUP_REAGENT_LOT_ID BB_QC_GRP_REAGENT_LOT GROUP_REAGENT_LOT_ID
ACTIVITY_PRSNL_ID PRSNL PERSON_ID




Parent Column in BB_QC_GRP_REAGENT_ACTIVITY (PK) Child Table Name Child Column Name
Children: GROUP_REAGENT_ACTIVITY_ID BB_QC_RESULT CONTROL_ACTIVITY_ID
BB_QC_RESULT ENHANCEMENT_ACTIVITY_ID
BB_QC_RESULT GROUP_REAGENT_ACTIVITY_ID