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 |