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