Table Detail Report
QC_TROUBLE_STEP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Quality Control Trouble Step |
Definition: | Defines the qc trouble steps to select from when defining what steps were taken to correct an out of control result. |
Table Type: | REFERENCE |
Column Detail - QC_TROUBLE_STEP
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. |
ERROR_FLAG | DOUBLE | N | Defines the type of error encountered if a rule has failed. |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies the service resource associated with the trouble step. |
STEP | VARCHAR(200) | Y | Character description of the trouble step to be taken by the user to correct the out of control result. |
STEP_NBR | DOUBLE | N | Defines the order in which the steps should display in the application. |
TASK_ASSAY_CD | DOUBLE | N | A unique code value that identifies the discrete task assay associated with the trouble step. |
TROUBLE_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific trouble 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_TROUBLE_STEP
Child Column in QC_TROUBLE_STEP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
Parent Column in QC_TROUBLE_STEP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TROUBLE_ID | QC_RESULT_TROUBLE_R | TROUBLE_ID |
REF_RANGE_NOTIFY_TRIG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Reference Range Notify Trigger |
Definition: | Contains the relationship between the reference range factor table and one to many EKM (Expert Knowledge Module) rules. |
Table Type: | REFERENCE |
Column Detail - REF_RANGE_NOTIFY_TRIG
Column Name | Type | Null? | Definition |
---|---|---|---|
REFERENCE_RANGE_FACTOR_ID | DOUBLE | N | Relates this record to a specific row in the reference_range_factor table. |
REF_RANGE_NOTIFY_TRIG_ID | DOUBLE | N | Identifies a specific relationship between the reference range factor table and one to many Expert Knowledge Module rules |
TRIGGER_NAME | VARCHAR(30) | N | The name of the Expert Knowledge System rules to execute. |
TRIGGER_SEQ_NBR | DOUBLE | N | Identifies the importance of this trigger name for a given reference range factor. |
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 - REF_RANGE_NOTIFY_TRIG
Child Column in REF_RANGE_NOTIFY_TRIG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REFERENCE_RANGE_FACTOR_ID | REFERENCE_RANGE_FACTOR | REFERENCE_RANGE_FACTOR_ID |
RESOURCE_ACCESSION_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Resource Accession Resolution |
Definition: | Creates a relationship between the service resource and the accessions available for resulting quality control at that instrument or bench. |
Table Type: | REFERENCE |
Column Detail - RESOURCE_ACCESSION_R
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific quality control accession number. Creates a relationship to the accession table. |
CONTROL_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific control material associated with the service resource and quality control accession. Creates a relationship to the control material table. |
FREQ_MIN | DOUBLE | Y | Determines how often the control should be run for the instrument or bench to which it is assigned. |
INSTR_XREF | VARCHAR(20) | Y | Used to post QC results from an instrument. Identifies a cross reference for the accession number for instruments. This field is used by instruments for posting QC results and must be filled out for posting QC results to work. |
PREACTIVE_IND | DOUBLE | Y | Indicates whether the quality control accession is pre-active. A value of 0 denotes the accession as not pre-active. A value of 1 denotes the accession as pre-active. |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies a specific service resource associated with a quality control accession. |
SYMBOLOGY | VARCHAR(2) | Y | Defines which bar code symbology for which this service resource/QC accession is set up. |
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 - RESOURCE_ACCESSION_R
Child Column in RESOURCE_ACCESSION_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACCESSION_ID | ACCESSION | ACCESSION_ID |
CONTROL_ID | CONTROL_MATERIAL | CONTROL_ID | |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
RESOURCE_ASSAY_CONTROL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Resource Assay Control |
Definition: | Defines the relationship to the resource, assay and control |
Table Type: | REFERENCE |
Column Detail - RESOURCE_ASSAY_CONTROL
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. |
CONTROL_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific control material associated with a service resource and discrete task assay. Creates a relationship to the control material table. |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies a specific service resource associated with a control material. |
TASK_ASSAY_CD | DOUBLE | N | A unique code value that identifies a specific discrete task assay associated with a control material. |
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 - RESOURCE_ASSAY_CONTROL
Child Column in RESOURCE_ASSAY_CONTROL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONTROL_ID | CONTROL_MATERIAL | CONTROL_ID |
TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD | |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
RESOURCE_LOT_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Resource Control Lot Resolution |
Definition: | Creates a relationship between the service resource and control lot for defining active times for the resource. |
Table Type: | REFERENCE |
Column Detail - RESOURCE_LOT_R
Column Name | Type | Null? | Definition |
---|---|---|---|
DEFINED_ACTIVE_DT_TM | DATETIME | Y | The date and time the control lot will become active for the service resource (i.e. instrument, bench). |
DEFINED_INACTIVE_DT_TM | DATETIME | Y | The date and time the control lot will become inactive for the service resource (i.e. instrument, bench). |
LOT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific control lot associated with a service resource. Creates a relationship to the control lot table. |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies the specific service resource associated with a control lot. |
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 - RESOURCE_LOT_R
Child Column in RESOURCE_LOT_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOT_ID | CONTROL_LOT | LOT_ID |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |