Table Detail Report

RR_ACCESSION_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Round Robin Accession Relation
Definition: Stores information about the round robin accessions generated
Table Type: ACTIVITY





Column Detail - RR_ACCESSION_R


Column Name Type Null? Definition
ACCESSION_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific accession number associated with a round robin template. Creates a relationship to the accession table.
ROUND_ROBIN_REF_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific round robin template.
RR_GROUP_ID DOUBLE N A unique, internal, system-assigned number that identifies a grouping of a set of accessions that were created at the same time. Creates a relationship to the round robin group 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 - RR_ACCESSION_R


Child Column in RR_ACCESSION_R(FK) Parent Table Name Parent Column Name
Parents: ACCESSION_ID ACCESSION ACCESSION_ID
ROUND_ROBIN_REF_ID ROUND_ROBIN_REF ROUND_ROBIN_REF_ID
RR_GROUP_ID RR_GROUP RR_GROUP_ID




Parent Column in RR_ACCESSION_R (PK) Child Table Name Child Column Name
Children: ACCESSION_ID ROUND_ROBIN_COMMENT ACCESSION_ID
ROUND_ROBIN_REF_ID ROUND_ROBIN_COMMENT ROUND_ROBIN_REF_ID
ACCESSION_ID RR_RESULT ACCESSION_ID
ROUND_ROBIN_REF_ID RR_RESULT ROUND_ROBIN_REF_ID


RR_ASSAY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Round Robin Assay Relation
Definition: Stores the assay(s) defined for a round robin template
Table Type: REFERENCE





Column Detail - RR_ASSAY_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.
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.
DISPLAY_SEQUENCE DOUBLE Y Defines the discrete task assay display sequence order as defined in the Round Robin Build application.
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.
OUTLIER DOUBLE Y Defines the value defined in Round Robin Build to designate the outlier value.
OUTLIER_IND DOUBLE Y Indicates whether the outlier for the discrete task assay is the difference from the mean outlier or SDI outlier. A value of 0 indicates the difference is from the SDI outlier. A value of 1 indicates the difference is from the mean.
ROUND_ROBIN_REF_ID DOUBLE N A unique, internal, system-assigned number that identifies the round robin template associated with the discrete task assay. Creates a relationship to the round robin reference table.
SERVICE_RESOURCE_CD DOUBLE N A unique code value that identifies the specific service resource (i.e. instrument, bench, etc.) that is associated with the round robin template.
TASK_ASSAY_CD DOUBLE N A unique code value that identifies a specific discrete task assay associated with the round robin template.
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 - RR_ASSAY_R


Child Column in RR_ASSAY_R(FK) Parent Table Name Parent Column Name
Parents: ROUND_ROBIN_REF_ID ROUND_ROBIN_REF ROUND_ROBIN_REF_ID


RR_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Round Robin Group
Definition: Table to group round robin accessions together with a creation_dt_tm.
Table Type: ACTIVITY





Column Detail - RR_GROUP


Column Name Type Null? Definition
CREATED_DT_TM DATETIME N Defines the date and time when this set of round robin accessions were generated.
RR_GROUP_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific grouping of round robin accessions.
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 - RR_GROUP




Parent Column in RR_GROUP (PK) Child Table Name Child Column Name
Children: RR_GROUP_ID RR_ACCESSION_R RR_GROUP_ID


RR_PERFORM_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Round Robin Perform Result
Definition: Stores result values and corresponding information relating to the result. If a result is performed multiple times a new entry into the table is added.
Table Type: ACTIVITY





Column Detail - RR_PERFORM_RESULT


Column Name Type Null? Definition
NUMERIC_RESULT_VALUE DOUBLE N Stores the actual result value entered for a given discrete task assay.
PERFORM_DT_TM DATETIME Y Stores the date and time when this result was performed.
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.
REPEAT_NBR DOUBLE Y Stores the number used to indicate when the result is repeated.
RESULT_STATUS_CD DOUBLE N A unique code value that identifies the status of the result.
RR_PERFORM_RESULT_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific stage of a performed result.
RR_RESULT_ID DOUBLE N A unique, internal, system-assigned number that identifies the specific result associated with a given discrete task assay. Creates a relationship to the round robin result 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 - RR_PERFORM_RESULT


Child Column in RR_PERFORM_RESULT(FK) Parent Table Name Parent Column Name
Parents: PERFORM_PERSONNEL_ID PRSNL PERSON_ID
RR_RESULT_ID RR_RESULT RR_RESULT_ID




Parent Column in RR_PERFORM_RESULT (PK) Child Table Name Child Column Name
Children: RR_PERFORM_RESULT_ID RR_RESULT_EVENT RR_PERFORM_RESULT_ID


RR_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Round Robin Result
Definition: Each row represents one task assay of a round robin instrument/procedure combo.
Table Type: ACTIVITY





Column Detail - RR_RESULT


Column Name Type Null? Definition
ACCESSION_ID DOUBLE N A unique, internal, system-assigned number that identifies the specific round robin accession associated with the discrete task assay result. Creates a relationship to the accession table.
EXCLUDE_IND DOUBLE Y Indicates whether this result is included or excluded from the calculation of the Mean and Standard Deviation. A value of 0 indicates the result should be included in the calculation. A value of 1 indicates the result should be excluded from the calculation.
MEANDIFF DOUBLE Y Stores the difference from the mean value that is calculated in the Round Robin Inquiry application.
RESULT_STATUS_CD DOUBLE N A unique code value that identifies the current status (such as performed, verified, or corrected) of the round robin result.
ROUND_ROBIN_REF_ID DOUBLE N A unique, internal, system-assigned number that identifies the specific round robin template associated with the result. Creates a relationship to the round robin reference table.
RR_RESULT_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific round robin result.
SAVED_IND DOUBLE Y Indicates whether the statistics for this result have been saved. Statistics must be saved before viewing the QC Round Robin Graphs. A value of 0 indicates the statistics have not been saved. A value of 1 indicates the statistics have been saved.
SDI DOUBLE Y Stores the standard deviation interval value calculated in Round Robin Inquiry.
SERVICE_RESOURCE_CD DOUBLE N A unique code value that identifies the specific service resource where the result was performed.
TASK_ASSAY_CD DOUBLE N A unique code value that identifies the specific discrete task assay associated with the round robin 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 - RR_RESULT


Child Column in RR_RESULT(FK) Parent Table Name Parent Column Name
Parents: ACCESSION_ID RR_ACCESSION_R ACCESSION_ID
ROUND_ROBIN_REF_ID RR_ACCESSION_R ROUND_ROBIN_REF_ID




Parent Column in RR_RESULT (PK) Child Table Name Child Column Name
Children: RR_RESULT_ID RR_PERFORM_RESULT RR_RESULT_ID
RR_RESULT_EVENT RR_RESULT_ID