Table Detail Report

INSTRUMENT_ASSIGNMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Instrument Assignment
Definition: Table used to show the person ID that is currently assigned to an instrument. This is the person ID that will be posted as the perform_personnel_id when results come from an instrument.
Table Type: ACTIVITY





Column Detail - INSTRUMENT_ASSIGNMENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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 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.
PRSNL_ID DOUBLE N A unique, internal, system-assigned number that identifies the specific person who is assigned to the service resource currently. Creates a relationship to the personnel table.
SERVICE_RESOURCE_CD DOUBLE N A unique code value that identifies a specific service resource to which a person is assigned.
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 - INSTRUMENT_ASSIGNMENT


Child Column in INSTRUMENT_ASSIGNMENT(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


INSTR_ACCN_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Instrument Accession Queue
Definition: Queues accessions that are posted by an interfaced instrument.
Table Type: ACTIVITY





Column Detail - INSTR_ACCN_QUEUE


Column Name Type Null? Definition
ACCESSION VARCHAR(20) N An accession uniquely identifies a specimen.
IN_PROCESS_DT_TM DATETIME Y The date and time that the user started working on the accession in a result entry conversation. Used to lock the record from another user.
IN_PROCESS_PRSNL_ID DOUBLE N User who has started working on the accession. Used to lock the accession for result entry conversation.
PERF_DT_TM DATETIME Y Date and time the record was written to the queue for review by result entry.
QC_GROUP_ID DOUBLE N If the accession resulted is QC, this is the ID of the group of results that were sent by the instrument.
SEQUENCE DOUBLE N Preserves the order in which accessions are posted for a specific service resource.
SERVICE_RESOURCE_CD DOUBLE N The interfaced instrument that posted results for an accession.
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 - INSTR_ACCN_QUEUE


Child Column in INSTR_ACCN_QUEUE(FK) Parent Table Name Parent Column Name
Parents: IN_PROCESS_PRSNL_ID PRSNL PERSON_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


LAB_HANDLING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lab Handling
Definition: Defines lab handling information for a particular collection requirement on an orderable.
Table Type: REFERENCE





Column Detail - LAB_HANDLING


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The internal number assigned by the system to the order catalog item associated with the collection requirements.
COLL_INFO_SEQ DOUBLE N The sequence with which the collection requirements and lab handlings are associated.
LAB_HANDLING_CD DOUBLE N A code used to identify the different ways a container should be handled.
LAB_HANDLING_ID DOUBLE N Uniquely identifies lab handling information for a particular collection requirement on an orderable.
LAB_HANDLING_ORDER_SEQ DOUBLE N A user assigned numeric value that is used to sort lab handling values.
SPECIMEN_TYPE_CD DOUBLE N Uniquely identifies the related specimen type.
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 - LAB_HANDLING


Child Column in LAB_HANDLING(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD COLLECTION_INFO_QUALIFIERS CATALOG_CD
COLL_INFO_SEQ COLLECTION_INFO_QUALIFIERS SEQUENCE
SPECIMEN_TYPE_CD COLLECTION_INFO_QUALIFIERS SPECIMEN_TYPE_CD


ORDER_LABORATORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Laboratory
Definition: Allows additional information for an order that is specific to the laboratory.
Table Type: ACTIVITY





Column Detail - ORDER_LABORATORY


Column Name Type Null? Definition
COLLECTION_COMMENT VARCHAR(50) Y Used for recording a comment about the collection process.
COLLECTION_PRIORITY_CD DOUBLE N A unique code value that identifies a specific collection priority associated with the collection process taking place.
CONTINUING_ORDER DOUBLE Y Defines the order as a continuing order. (Currently not implemented)
EXPEDITE_IND DOUBLE Y Indicates whether the order should be expedited or not. (Currently not implemented)
ORDER_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific order. Creates a relationship to the orders table.
PENDING_REVIEW_IND DOUBLE Y Indicates whether a review of the order is in progress. A value of 0 indicates that no review is in progress. A value of 1 indicates that a review of the order is in progress.
PROP_RESULT_FLAG DOUBLE Y Used for orders that have prompt tests associated with them. (Currently not implemented)
REPORT_PRIORITY_CD DOUBLE N A unique code value that identifies a specific priority in which a report is to be produced.
RESOURCE_ROUTE_LEVEL_FLAG DOUBLE Y Defines how the discrete task assays associated with an order catalog item are routed to service resources.
RESULTS_PENDING DOUBLE Y (Currently not implemented)
REVIEW_REQUIRED_IND DOUBLE Y Indicates whether a review of the order is required. A value of 0 means no review is required. A value of 1 means the order will always be reviewed.
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 - ORDER_LABORATORY




Parent Column in ORDER_LABORATORY (PK) Child Table Name Child Column Name
Children: ORDER_ID PENDING_COLLECTION ORDER_ID


ORDER_PROCEDURE_EXCEPTION



Column Section Top of Page


Table-level Detail

Description: Order Procedure Exception
Definition: Defines the procedures that are to be loaded to a specific resource when a level 2 routing is required.
Table Type: ACTIVITY





Column Detail - ORDER_PROCEDURE_EXCEPTION


Column Name Type Null? Definition
EXCEPTION_TYPE_FLAG DOUBLE Y Defines how or why the exception row was written.
ORDER_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific order. Creates a relationship to the orders table.
SERVICE_RESOURCE_CD DOUBLE N A unique code value that identifies the specific service resource (i.e. instrument, bench) to which the discrete task assay is routed.
TASK_ASSAY_CD DOUBLE N A unique code value that identifies the specific discrete task assay.
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.