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