Table Detail Report
RR_RESULT_EVENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Round Robin Result Event |
Definition: | Used to hold information about each step that the result goes through such as performed event, verified event. etc. |
Table Type: | ACTIVITY |
Column Detail - RR_RESULT_EVENT
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_DT_TM | DATETIME | Y | Defines the date and time this event took place. |
EVENT_PERSONNEL_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific person who caused the event to take place. Creates a relationship to the person table. |
EVENT_SEQUENCE | DOUBLE | N | Starts at one and is incremented by one when multiple result events are completed at the same time. For example, when the user enters and verifies a result, the actions cause the system to execute a perform event and a verify event at the same time. |
EVENT_TYPE_CD | DOUBLE | N | A unique code value that identifies the type of event that took place. |
RR_PERFORM_RESULT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific round robin perform result associated with the event. Creates a relationship to the round robin perform result table. |
RR_RESULT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific round robin result associated with the event. 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_RESULT_EVENT
Child Column in RR_RESULT_EVENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EVENT_PERSONNEL_ID | PRSNL | PERSON_ID |
RR_PERFORM_RESULT_ID | RR_PERFORM_RESULT | RR_PERFORM_RESULT_ID | |
RR_RESULT_ID | RR_RESULT | RR_RESULT_ID |
WORKLIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Worklist |
Definition: | Uniquely identifies a worklist. |
Table Type: | ACTIVITY |
Column Detail - WORKLIST
Column Name | Type | Null? | Definition |
---|---|---|---|
DOWNLOADED_IND | DOUBLE | Y | Indicates whether or not this worklist has been downloaded at least once. |
SEQ_IDENT_BEG_RANGE_NBR | DOUBLE | N | Indicates the beginning instrument range sequence number when sequence identifiers are used with a given worklist. |
SEQ_IDENT_END_RANGE_NBR | DOUBLE | N | Indicates the ending instrument range sequence number when sequence identifiers are used with a given worklist. |
SEQ_IDENT_IND | DOUBLE | N | Indicates whether sequence identifiers are used with a given worklist. |
SEQ_IDENT_START_NBR | DOUBLE | N | Indicates the starting sequence number when sequence identifiers are used with a given worklist. |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies a specific service resource (such as instrument, bench, or sub-section) associated with a worklist. |
STATUS_CD | DOUBLE | N | A unique code value that identifies the status of an automatic worklist (e.g. building, pending, etc.). |
TEMPLATE_IND | DOUBLE | Y | Indicates whether this worklist was built using the template logic or not. |
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. |
WORKLIST_ALIAS | VARCHAR(25) | Y | Free-text character description for the worklist. |
WORKLIST_DT_TM | DATETIME | Y | Indicates the date and time the worklist was created. |
WORKLIST_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific worklist. |
WORKLIST_PRSNL_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific person who created the worklist. Creates a relationship to the person table. |
WORKLIST_REF_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific worklist reference template used to create the worklist. Creates a relationship to the worklist reference table. |
WORKLIST_TYPE_FLAG | DOUBLE | N | Defines the type of worklist. |
Relationship Detail - WORKLIST
Child Column in WORKLIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | WORKLIST_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in WORKLIST (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WORKLIST_ID | HLA_XM_RES_TRAY | WORKLIST_ID |
PERFORM_RESULT | WORKLIST_ID | ||
QC_RESULT | COPY_FORWARD_WORKLIST_ID | ||
QC_RESULT | WORKLIST_ID | ||
WORKLIST_ACCESSION_R | WORKLIST_ID | ||
WORKLIST_ELEMENT | WORKLIST_ID | ||
WORKLIST_ELEMENTS | WORKLIST_ID | ||
WORKLIST_EVENT | WORKLIST_ID | ||
WORKLIST_ORDER_R | WORKLIST_ID |
WORKLIST_ACCESSION_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Worklist Accession Resolution |
Definition: | Stores the Quality Control accessions included on a worklist. |
Table Type: | ACTIVITY |
Column Detail - WORKLIST_ACCESSION_R
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific QC accession included on a worklist. Creates a relationship to the accession table. |
CREATE_DT_TM | DATETIME | Y | Defines the date and time the QC accession row was created. |
IDENTIFIER | VARCHAR(20) | Y | Stores the user identifier entered in the worklist application and used by an instrument to post results when an accession is not sent by the instrument. (Currently not implemented) |
POST_TO_FLAG | DOUBLE | Y | Defines the current status of how the identifier has been used. (Currently not implemented) |
QC_GROUP_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific set of QC results that are included on a worklist. |
SEQUENCE | DOUBLE | N | Defines the numerical order that a QC accession should display on a worklist. |
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. |
WORKLIST_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific worklist. Creates a relationship to the worklist table. |
Relationship Detail - WORKLIST_ACCESSION_R
Child Column in WORKLIST_ACCESSION_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACCESSION_ID | ACCESSION | ACCESSION_ID |
WORKLIST_ID | WORKLIST | WORKLIST_ID |
WORKLIST_ELEMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Worklist Element |
Definition: | Defines the service resource (instrument or bench), ordered procedures, and/or detail procedures that are included on the worklist. |
Table Type: | ACTIVITY |
Column Detail - WORKLIST_ELEMENT
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | A unique code value that identifies a specific order catalog procedure that was included on a worklist. |
ORDER_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific order related to this worklist element. |
TASK_ASSAY_CD | DOUBLE | N | A unique code value that identifies a specific discrete task assay that is included on a worklist. |
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. |
WORKLIST_ELEMENT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific worklist element. |
WORKLIST_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific worklist related to this worklist elelment. |
Relationship Detail - WORKLIST_ELEMENT
Child Column in WORKLIST_ELEMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | ORDERS | ORDER_ID |
WORKLIST_ID | WORKLIST | WORKLIST_ID |
WORKLIST_ELEMENTS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Worklist Elements |
Definition: | Defines the service resource (instrument or bench), ordered procedures, and/or detail procedures that are included on the worklist. |
Table Type: | ACTIVITY |
Column Detail - WORKLIST_ELEMENTS
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | A unique code value that identifies a specific order catalog procedure that was included on a worklist. |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies a specific service resource (such as instrument, bench, or sub-section) associated with a worklist. |
TASK_ASSAY_CD | DOUBLE | N | A unique code value that identifies a specific discrete task assay that is included on a worklist. |
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. |
WORKLIST_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific worklist. Creates a relationship to the worklist table. |
WORKLIST_SEQ | DOUBLE | N | Sequential number used to uniquely identify the worklist elements associated with a specific worklist. |
Relationship Detail - WORKLIST_ELEMENTS
Child Column in WORKLIST_ELEMENTS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | WORKLIST_ID | WORKLIST | WORKLIST_ID |