Table Detail Report

QC_RESULT_RULE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Quality Control Result Rule Resolution
Definition: Maintains a relationship for the rules applied with those that failed or were not checked.
Table Type: ACTIVITY





Column Detail - QC_RESULT_RULE_R


Column Name Type Null? Definition
QC_RESULT_ID DOUBLE N A unique, internal, system-assigned number that identifies the specific quality control result associated with a rule that failed or was checked. Creates a relationship to the quality control result table.
RULE_ID DOUBLE N A unique, internal, system-assigned number that identifies the rule that was applied to the quality control result. Creates a relationship to the quality control rule type table.
SEQUENCE DOUBLE N Stores the sequence number from the QC rule table.
STATUS_FLAG DOUBLE Y Defines the status of the rule that was checked for the QC result.
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_RULE_R


Child Column in QC_RESULT_RULE_R(FK) Parent Table Name Parent Column Name
Parents: QC_RESULT_ID QC_RESULT QC_RESULT_ID
RULE_ID QC_RULE RULE_ID
SEQUENCE QC_RULE SEQUENCE


QC_RESULT_TROUBLE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Quality Control Result Trouble Shooting Step Resolution
Definition: Defines a relationship between the QC result and the trouble steps that were used for correcting the problem found with the result.
Table Type: ACTIVITY





Column Detail - QC_RESULT_TROUBLE_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
QC_RESULT_ID DOUBLE N A unique, internal, system-assigned number that identifies the quality control result to which trouble steps were applied to correct an out of control result. Creates a relationship to the quality control result table.
TROUBLE_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific quality control trouble step. Creates a relationship to the quality control trouble step table.
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_TROUBLE_R


Child Column in QC_RESULT_TROUBLE_R(FK) Parent Table Name Parent Column Name
Parents: QC_RESULT_ID QC_RESULT QC_RESULT_ID
TROUBLE_ID QC_TROUBLE_STEP TROUBLE_ID


QC_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Quality Control Rule
Definition: Stores the definitions for quality control rules that are used by the system
Table Type: REFERENCE





Column Detail - QC_RULE


Column Name Type Null? Definition
ACROSS_CONTROL_IND DOUBLE Y Indicates whether the quality control rule is defined for across control checking. A value of 0 indicates the rule is defined for within control checking. A value of 1 indicates the rule is defined for across control checking.
ACROSS_RUN_IND DOUBLE Y Indicates whether the quality control rule is defined to check across runs. A value of 0 indicates the rule is defined to check within runs. A value of 1 indicates the rule is defined to check across runs.
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
ERROR_FLAG DOUBLE Y Defines the type of error encountered if a rule has failed.
MAX_REQ_RESULTS DOUBLE Y Defines the maximum number of results required to perform rule evaluation. Used internally.
REQ_COMMENT_IND DOUBLE N Indicator to require comment entered if this rule fails.
REQ_TROUBLE_STEP_IND DOUBLE N Indicator to require trouble shooting step selected if this rule fails.
RULE_DEFINITION VARCHAR(60) Y Character description of the rule being defined.
RULE_FORM_FLAG DOUBLE Y Defines the type of rule that is being defined, such as a-bs.
RULE_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific quality control rule. Creates a relationship to the quality control rule type table.
SEQUENCE DOUBLE N Defines the display sequence of the quality control rules.
TRIG_IND DOUBLE Y Indicates whether the quality control rule is a trigger rule. A value of 0 indicates this is not a trigger rule. A value of 1 indicates that this is a trigger rule - meaning if this rule fails, continue checking the rest of the rules defined.
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_RULE


Child Column in QC_RULE(FK) Parent Table Name Parent Column Name
Parents: RULE_ID QC_RULE_TYPE RULE_ID




Parent Column in QC_RULE (PK) Child Table Name Child Column Name
Children: RULE_ID QC_RESULT_RULE_R RULE_ID
SEQUENCE QC_RESULT_RULE_R SEQUENCE


QC_RULE_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Quality Control Rule Type
Definition: Defines a specific single QC rule
Table Type: REFERENCE





Column Detail - QC_RULE_TYPE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
DESCRIPTION VARCHAR(60) Y Character description of the quality control rule.
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.
RULE_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific quality control rule.
SHORT_DESCRIPTION VARCHAR(20) Y Character description for the rule.
SHORT_DESC_KEY VARCHAR(20) Y Defines the short character description in uppercase with no spaces or special characters.
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_RULE_TYPE




Parent Column in QC_RULE_TYPE (PK) Child Table Name Child Column Name
Children: RULE_ID QC_RESULT RULE_ID
QC_RULE RULE_ID


QC_SCHD_STEP_CTRL_ASSAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Quality Control Schedule Step Control Assay
Definition: Contains information about a given schedule step in relationship to the control and its related assay.
Table Type: ACTIVITY





Column Detail - QC_SCHD_STEP_CTRL_ASSAY


Column Name Type Null? Definition
CONTROL_ID DOUBLE N This column relates this control to the qc_schdule_ctrl table.
ERROR_STEP_IND DOUBLE N This value is not used today but is needed to provide the foreign key back to the qc_schedule_ctrl table.
QC_SCHD_STEP_CTRL_ASSAY_ID DOUBLE N Uniquely identifies a given schedule step control assay.
QC_SCHEDULE_ID DOUBLE N Relates this record to a specific control schedule.
STEP_NBR DOUBLE N This is the quality control schedule step number to which the assay is related.
TASK_ASSAY_CD DOUBLE N This is the procedure that is associated to the control under the current 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 - QC_SCHD_STEP_CTRL_ASSAY


Child Column in QC_SCHD_STEP_CTRL_ASSAY(FK) Parent Table Name Parent Column Name
Parents: CONTROL_ID QC_SCHEDULE_CTRL CONTROL_ID
ERROR_STEP_IND QC_SCHEDULE_CTRL ERROR_STEP_IND
QC_SCHEDULE_ID QC_SCHEDULE_CTRL QC_SCHEDULE_ID
STEP_NBR QC_SCHEDULE_CTRL STEP_NBR