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 |