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 |