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. |