Table Detail Report

QC_GROUP_ASSAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Quality Control Group Assay
Definition: This table stores the QC Benchmark statistical information for an assay on a given control group.
Table Type: REFERENCE





Column Detail - QC_GROUP_ASSAY


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 Y 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_GROUP_CD DOUBLE N This is the control group to which this control and service resource is related.
DEVIATION_TYPE_FLAG DOUBLE N The method used to represent the degree of deviation.Flag Values:1 = percent2 = absolute
END_EFFECTIVE_DT_TM DATETIME Y 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_ASSAY_SEQ_NBR DOUBLE N The value that keeps the same task_assay_cd unique for a given control_group_cd.
MAX_DISPERSION_VALUE DOUBLE N This is the maximum permissible impression that is measured by the standard deviation and the coefficient of variation.
MAX_MEAN_VALUE DOUBLE N This is the maximum permissible systematic error value. The difference between the calculated mean and the manufacturer's mean.
MAX_RESULT_DEVIATION_VALUE DOUBLE N This is the maximum permissible qc result deviation. It is the difference between the qc results and the manufacturer's mean.
PREV_QC_GROUP_ASSAY_ID DOUBLE N This column is used to group the modified values for a qc_group_assay_id.
QC_GROUP_ASSAY_ID DOUBLE N Contains a given control group for an assay and its QC Benchmark statistical information.
RESULT_RANGE_MAX_VALUE DOUBLE N This is the high side of the result value that defines whether this quality control benchmark criteria is used or not.
RESULT_RANGE_MIN_VALUE DOUBLE N This is the low side of the result value that defines whether this quality control benchmark criteria is used or not.
TASK_ASSAY_CD DOUBLE N This is the foreign key to the code_value table that identifies the procedure that is related to this control 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 - QC_GROUP_ASSAY




Parent Column in QC_GROUP_ASSAY (PK) Child Table Name Child Column Name
Children: QC_GROUP_ASSAY_ID QC_RESULT QC_GROUP_ASSAY_ID


QC_GROUP_CTRL_RESOURCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Quality Control Group Control Resource
Definition: Contains information about the group control resource for quality control.
Table Type: REFERENCE





Column Detail - QC_GROUP_CTRL_RESOURCE


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 Y 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_GROUP_CD DOUBLE N This is the control group to which this control and service resource is associated.
CONTROL_ID DOUBLE N This relates the control on the control_material table to the appropriate control group.
END_EFFECTIVE_DT_TM DATETIME Y 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.
PREV_QC_GROUP_CTRL_RESOURCE_ID DOUBLE N This is used to group the modified values for a given quality control group control resource.
QC_GROUP_CTRL_RESOURCE_ID DOUBLE N Uniquely identifies a specific quality control group control resource.
SERVICE_RESOURCE_CD DOUBLE N Identifies the service resource that is related to this control 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 - QC_GROUP_CTRL_RESOURCE


Child Column in QC_GROUP_CTRL_RESOURCE(FK) Parent Table Name Parent Column Name
Parents: CONTROL_ID CONTROL_MATERIAL CONTROL_ID


QC_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Quality Control Results
Definition: Stores the results entered into the system for quality control materials being used on instruments and benches.
Table Type: ACTIVITY





Column Detail - QC_RESULT


Column Name Type Null? Definition
ABS_HIGH DOUBLE Y Stores the defined absolute high value that the result was checked against when it was entered into the system.
ABS_LOW DOUBLE Y Stores the defined absolute low value that the result was checked against when it was entered into the system.
ARL_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific discrete task assay, service resource, and control lot relationship. Used to determine if the result was in control and the mean and standard deviation associated with the control lot. Creates a relationship to the assay resource lot table.
ASCII_TEXT VARCHAR(60) Y Stores the result of a free text entry into the system.
CLINICAL_STD_DEV DOUBLE Y Stores the clinical standard deviation used to evaluate the control result entered in the system.
COMMENT_IND DOUBLE Y Indicates whether quality control comments exist for the result. A value of 0 indicates there are no comments attached to the result. A value of 1 indicates there are comments attached to the result.
CONTROL_ID DOUBLE N A unique, internal, system-assigned number that identifies the specific control material that was used to generate the result. Creates a relationship to the control material table.
COPY_FORWARD_WORKLIST_ID DOUBLE N Identifies the automatic worklist that the QC result was copied forward to when the automatic worklist is of type bookend QC.
EVENT_DT_TM DATETIME Y Defines the date and time the event took place.
INTERFACE_FLAG DOUBLE Y Indicates how the result was entered into the system.
LOT_ID DOUBLE N A unique, internal, system-assigned number that identifies the specific control lot that was used to generate the result. Creates a relationship to the control lot table.
MEAN DOUBLE Y Stores the mean value to be used to evaluate the control result entered in the system.
MULTIPLEX_RESOURCE_CD DOUBLE N A unique code value that identifies the multiplexor used by an instrument to post the result to the system.
NOMENCLATURE_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific alpha response nomenclature row. Creates a relationship to the nomenclature table.
NUMERIC_RAW_VALUE DOUBLE Y Stores the result exactly as it was sent by the instrument interface.
PDM_DP_ID DOUBLE N A unique, internal, system-assigned number that identifies the specific patient data monitoring data point. Creates a relationship to the patient data monitoring data point table.
PDM_PARAM_ID DOUBLE N A unique, internal, system-assigned number that identifies the specific patient data monitoring parameters used to create the QC result. Creates a relationship to the patient data monitoring parameters table.
PDM_RANGE_ID DOUBLE N A unique, internal, system-assigned number that identifies the specific patient data monitoring range that was used to create the QC result. Creates a relationship to the patient data monitoring ranges table.
PERFORM_DT_TM DATETIME Y Stores the date and time the result was performed by the system.
PERFORM_PERSONNEL_ID DOUBLE N A unique, internal, system-assigned number that identifies the person who performed the result. Creates a relationship to the person table.
PREACTIVE_IND DOUBLE Y Indicates whether the control was in a pre-active state when the QC result was entered into the system. A value of 0 indicates the result was not entered when the control was in a pre-active state. A value of 1 indicates the result was entered when the control was in a pre-active state.
PREV_RESULT_ID DOUBLE N A unique, internal, system-assigned number that identifies the previous result value associated with this quality control result.
QC_GROUP_ASSAY_ID DOUBLE N Refers to specific statistical information about the QC Benchmark for an assay on a given control group.
QC_GROUP_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific grouping of all the QC results entered during a single conversation or transmission from an instrument. Creates a relationship to the QC group table.
QC_RESULT_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific quality control result entered in the system.
QC_RESULT_TYPE_FLAG DOUBLE N Flag that identifies the type of QC result.
RESOURCE_ERROR_CODES VARCHAR(100) Y Stores the errors transmitted by the instrument when a QC result was processed.
RESULT_CONTROL_CD DOUBLE N A unique code value that identifies whether the QC result is in control or out of control.
RESULT_PROCESS_CD DOUBLE N A unique code value that identifies whether the QC result is high, low, or abnormal.
RESULT_STATUS_CD DOUBLE N A unique code value that identifies the status of the quality control result, such as performed or verified.
RESULT_TYPE_CD DOUBLE N A unique code value that identifies the specific result type of the QC result, such as alpha or numeric.
RESULT_VALUE_ALPHA VARCHAR(25) Y Stores the character display value of the alpha response for alpha quality control results.
RESULT_VALUE_NUMERIC DOUBLE Y Stores the result value for numeric quality control results.
RULE_ID DOUBLE N A unique, internal, system-assigned number that identifies the quality control rule used to evaluate the result entered. Creates a relationship to the QC rule type table.
SERVICE_RESOURCE_CD DOUBLE N A unique code value that identifies the specific service resource where the QC result was performed.
STATISTICAL_STD_DEV DOUBLE Y Stores the standard deviation used to evaluate the control result entered in the system.
TASK_ASSAY_CD DOUBLE N A unique code value that identifies the specific discrete task assay with which the QC result is associated.
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 Identifies the automatic worklist associated with the result.
Z_SCORE DOUBLE Y Stores the calculated z-score for the quality control result.



Relationship Detail - QC_RESULT


Child Column in QC_RESULT(FK) Parent Table Name Parent Column Name
Parents: LOT_ID CONTROL_LOT LOT_ID
CONTROL_ID CONTROL_MATERIAL CONTROL_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PDM_DP_ID PDM_DATA_POINT PDM_DP_ID
PDM_PARAM_ID PDM_PARAMS PDM_PARAM_ID
PDM_RANGE_ID PDM_RANGES PDM_RANGE_ID
QC_GROUP_ASSAY_ID QC_GROUP_ASSAY QC_GROUP_ASSAY_ID
QC_GROUP_ID QC_RESULT_GRP QC_GROUP_ID
RULE_ID QC_RULE_TYPE RULE_ID
COPY_FORWARD_WORKLIST_ID WORKLIST WORKLIST_ID
WORKLIST_ID WORKLIST WORKLIST_ID




Parent Column in QC_RESULT (PK) Child Table Name Child Column Name
Children: QC_RESULT_ID QC_COMMENT QC_RESULT_ID
QC_RESULT_EVENT QC_RESULT_ID
QC_RESULT_RULE_R QC_RESULT_ID
QC_RESULT_TROUBLE_R QC_RESULT_ID


QC_RESULT_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Quality Control Result Event
Definition: Tracks the different events that can occur for a qc result entered into the system.
Table Type: ACTIVITY





Column Detail - QC_RESULT_EVENT


Column Name Type Null? Definition
EVENT_DT_TM DATETIME Y Date and time the event is recorded to have taken place.
EVENT_PERSONNEL_ID DOUBLE N A unique, internal, system-assigned number that identifies the specific person who performed the recorded event.
EVENT_REASON VARCHAR(100) Y Indicates the reason the event was initiated and recorded.
EVENT_SEQUENCE DOUBLE N Creates a unique element for the index and is the sequence in which the events took place.
EVENT_TYPE_CD DOUBLE N A unique code value that identifies the event action that took place.
QC_RESULT_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific quality control result that is associated with the event.
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 - QC_RESULT_EVENT


Child Column in QC_RESULT_EVENT(FK) Parent Table Name Parent Column Name
Parents: EVENT_PERSONNEL_ID PRSNL PERSON_ID
QC_RESULT_ID QC_RESULT QC_RESULT_ID


QC_RESULT_GRP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Quality Control Group
Definition: Creates a grouping table for all qc results performed at the same time.
Table Type: ACTIVITY





Column Detail - QC_RESULT_GRP


Column Name Type Null? Definition
ACCESSION_ID DOUBLE N A unique internal system assigned number that identifies the quality control accession number associated with the QC result grouping. Creates a relationship to the accession table.
GROUP_DT_TM DATETIME Y The date and time the group of qc results were created by the system.
QC_GROUP_ID DOUBLE N A unique internal system assigned number that identifies a specific grouping of several quality control results.
STATUS_FLAG DOUBLE Y Defines the status of the group of quality control results.
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 - QC_RESULT_GRP




Parent Column in QC_RESULT_GRP (PK) Child Table Name Child Column Name
Children: QC_GROUP_ID QC_RESULT QC_GROUP_ID