Table Detail Report

PENDING_COLLECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pending Collection
Definition: Every PathNet order that is placed in the system as 'not collected' will get a row in this table.
Table Type: ACTIVITY





Column Detail - PENDING_COLLECTION


Column Name Type Null? Definition
BODY_SITE_CD DOUBLE N Code value identifying the default body site from which this pending collection should be drawn.
COLLECTION_METHOD_CD DOUBLE N Code value identifying the default collection method to be used in collecting this pending order.
COLLECTION_ROUTE_CD DOUBLE N Code value for the collection route to which this pending order has been scheduled. If the order was not scheduled on a collection list this field will be set to 0.
NURSE_COLLECT_IND DOUBLE Y When this field is set to 1, it indicates that a nurse will be collecting this order. A 0 generally means the lab will be collecting.
NURSE_TASK_TYPE_FLAG DOUBLE N This field contains whether the order is eligible for a nurse collection task and the recommended type. 0 - Not eligible; 1 - Order level task; 2 - Container level task
ORDER_ID DOUBLE N A system generated number that uniquely identifies an order.
PROCESSING_FLAG DOUBLE Y This field determines whether an order originated from an external system or from the Cerner system.
REEVAL_ROUTING_FLAG DOUBLE N Field which indicates whether or not routing reevaluation is needed or has already been done.
RESCHEDULE_IND DOUBLE Y This field is set to 1 to indicate that this order has been missed and rescheduled.
RESPONSIBLE_PARTY_ID DOUBLE N This field will indicate a person to whom this order is assigned. The value is taken from the person_id field of the prsnl table. This field is reserved for future functionality.
SCHEDULED_DT_TM DATETIME N This field contains the date and time at which this order is scheduled to be collected. For an immediate print order, this field contains the current date and time.
SPECIMEN_TYPE_CD DOUBLE N Code value identifying the specimen type of this pending order.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PENDING_COLLECTION


Child Column in PENDING_COLLECTION(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDER_LABORATORY ORDER_ID


PROCEDURE_SPECIMEN_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Procedure Specimen Type
Definition: Tells you what specimen types a given Lab orderable can be performed on.
Table Type: REFERENCE





Column Detail - PROCEDURE_SPECIMEN_TYPE


Column Name Type Null? Definition
ACCESSION_CLASS_CD DOUBLE N The system generated number that uniquely identifies the accession class.
CATALOG_CD DOUBLE N The system generated number that uniquely identifies the order catalog item.
DEFAULT_COLLECTION_METHOD_CD DOUBLE N The system generated number that uniquely identifies the collection method code. This represents the default collection method for the order catalog item/specimen type.
DEFAULT_IND DOUBLE Y not currently used
SPECIMEN_TYPE_CD DOUBLE N System generated number that uniquely identifies the 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 - PROCEDURE_SPECIMEN_TYPE


Child Column in PROCEDURE_SPECIMEN_TYPE(FK) Parent Table Name Parent Column Name
Parents: ACCESSION_CLASS_CD ACCESSION_CLASS ACCESSION_CLASS_CD


ROUTE_COLLECTION_PRIORITY_R



Column Section Top of Page


Table-level Detail

Description: Route Collection Priority Relation
Definition: Resolution table between collection priorities and collection routes. This table will tell you what Collection priorities schedule to a given collection route.
Table Type: REFERENCE





Column Detail - ROUTE_COLLECTION_PRIORITY_R


Column Name Type Null? Definition
COLLECTION_PRIORITY_CD DOUBLE N Determines which collection priorities will schedule to a collection route.
COLLECTION_ROUTE_CD DOUBLE N Determines which collection priorities will schedule to a collection route.
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.


ROUTE_SPECIMEN_TYPE_R



Column Section Top of Page


Table-level Detail

Description: Route Specimen Type Relation
Definition: Resolution table between specimen types and collection routes. This table will tell you what specimen types are collected on a given collection route.
Table Type: REFERENCE





Column Detail - ROUTE_SPECIMEN_TYPE_R


Column Name Type Null? Definition
COLLECTION_ROUTE_CD DOUBLE N Determines which specimen types will schedule to a collection route.
SPECIMEN_TYPE_CD DOUBLE N Determines which specimen types will schedule to a collection route.
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.


ROUTE_START_TIME



Column Section Top of Page


Table-level Detail

Description: Route Start Time
Definition: Stores the start times for collection routes.
Table Type: REFERENCE





Column Detail - ROUTE_START_TIME


Column Name Type Null? Definition
COLLECTION_ROUTE_CD DOUBLE N The collection route for the associated collection time.
CUTOFF_MINUTES_FOR_ORDERS DOUBLE Y This field will determine when a collection can no longer schedule for a collection time. When scheduling an order, the system will not schedule the order for a collection time if it is ordered after the cutoff time (collection time - cutoff minutes).
LOOK_AHEAD_MINUTES DOUBLE Y This defines the number of minutes the system will look ahead when a collection list is generated for a collection time. By default, the system will always look ahead to one minute before the next collection time. If the look ahead minutes is set to a higher value, then any orders scheduled before the look ahead time (collection time + look ahead minutes) will be printed.
NURSE_COLLECT_IND DOUBLE Y This determines if orders flagged as nurse collects can be scheduled for a collection time. It has the following values : 1 - Schedule any order for this time. 2 - Do not schedule nurse collects for this collection time. 3 - Schedule only nurse collects for this time.
PRINTER_ID DOUBLE N If this field is assigned a value, orders scheduled for this time will be printed to the given printer. It may be overridden if all orders are printed to the same printer.
PRINT_QUEUE VARCHAR(20) Y The name of the printer queue assigned to the printer_id value.
ROUTE_START_TIME DOUBLE N The collection times defined for scheduling orders. Orders with collection priority, specimen type, and nurse collect values that are assigned to the collection route will be scheduled for the appropriate collection time based on the requested collection time.
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.