Table Detail Report

ORC_RESOURCE_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order catalog/service resource list
Definition: Used to store relationships between order catalog items and the service resources that perform the work for the task/assays associated to the order catalog item
Table Type: REFERENCE





Column Detail - ORC_RESOURCE_LIST


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
CATALOG_CD DOUBLE N Stores the code value for the order catalog item that is associated with the service resource
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.
PRIMARY_IND DOUBLE Y Indicates if the service resource will be the primary one for the order catalog item specified and, as such, will be the default service resource to be routed to if all other loading logic fails
SCRIPT_NAME VARCHAR(50) Y Name of script to be used for loading logic that is required by a site that is not provided for through the calendar logic
SEQUENCE DOUBLE Y Used to determine the sequence by which service resource will be tested for routing logic. Once the routing server has found a match by sequence, loading will occur and no other service resources will be tested, so the rule is to give the exceptions a lower sequence
SERVICE_RESOURCE_CD DOUBLE N Used to store the code for the service resource that is related to the order catalog item
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 - ORC_RESOURCE_LIST


Child Column in ORC_RESOURCE_LIST(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD


ORDER_CONTAINER_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Container Relationship
Definition: The resolution table between orders and containers. For a given order, this table will tell what container(s) it should be performed on. For a given container, this table will tell you what order(s) should be performed on it.
Table Type: ACTIVITY





Column Detail - ORDER_CONTAINER_R


Column Name Type Null? Definition
CATALOG_CD DOUBLE N A system generated number uniquely identifying a specific catalog code item.
COLLECTION_STATUS_FLAG DOUBLE Y Field indicating the status of this order and container combination,.0 - Order Pending; 1 - Order Collected; 2 - Order Missed and On Hold; 3 - Order Missed and to be Recollected; 4 - Order Missed and Rescheduled; 5 - Order Cancelled; 6 - Order Missed and Omitted; 7 - Order Inactive
COLL_INFO_SEQ DOUBLE N The sequence value from the collection requirements which was responsible for the container to be associated to the order.
CONTAINER_ID DOUBLE N A system generated number that uniquely identifies a container.
DEST_CONTAINER_ID DOUBLE N This field contains the container to which the order was moved.
ORDER_ID DOUBLE N A system generated number that uniquely identifies an order.
REASON_MISSED_CD DOUBLE N Code value that identifies the reason why a particular order is being missed.
REASON_MISSED_DT_TM DATETIME Y The date and time at which an order is missed.
REASON_MISSED_ID DOUBLE N The person id of the individual who missed this 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 - ORDER_CONTAINER_R


Child Column in ORDER_CONTAINER_R(FK) Parent Table Name Parent Column Name
Parents: DEST_CONTAINER_ID CONTAINER CONTAINER_ID
REASON_MISSED_ID PRSNL PERSON_ID


ORDER_SERV_RES_CONTAINER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Service Resource Container
Definition: Controls all of the PathNet features surrounding 'in-lab' processing. Also, along with the container table, drives specimen transfer lists.
Table Type: ACTIVITY





Column Detail - ORDER_SERV_RES_CONTAINER


Column Name Type Null? Definition
ALERT_DT_TM DATETIME Y The time when the order gets to an alert status when monitoring turnaround times.
AV_IND DOUBLE N Provides the ability to turn off autoverification of an accession at a given service resource.
COLL_INFO_SEQ DOUBLE N The sequence value from the collection requirements which was responsible for the container to be associated to the order.
CONTAINER_ID DOUBLE N The system identifier for the container in which the corresponding order resides.
CURRENT_LOCATION_CD DOUBLE N The current location of the container.
DISPLAY_DT_TM DATETIME Y The time when the order gets to a display status when monitoring turnaround times.
IN_LAB_DT_TM DATETIME Y The date/time at which the corresponding order was brought in lab.
LOCATION_CD DOUBLE N The specimen login location of the corresponding service resource.
ORDER_ID DOUBLE N The system identifier for an order.
SERVICE_RESOURCE_CD DOUBLE N The service resource to which the order is currently loaded.
SPEC_EXPIRE_DT_TM DATETIME Y The time when the specimen gets to a display status when monitoring specimen expiration times.
SPEC_WARNING_DT_TM DATETIME Y The time when the specimen gets to a warning status when monitoring specimen expiration times.
STATUS_FLAG DOUBLE Y Indicates the current status of the corresponding order.
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.
WARNING_DT_TM DATETIME Y The time when the order gets to a warning status when monitoring turnaround times.



Relationship Detail - ORDER_SERV_RES_CONTAINER


Child Column in ORDER_SERV_RES_CONTAINER(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID


ORD_RQSTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Requisition
Definition: Holds informatin about every assigned request ID.
Table Type: ACTIVITY





Column Detail - ORD_RQSTN


Column Name Type Null? Definition
CLIENT_ALIAS_NAME VARCHAR(6) N The client name of the requested assignment ident.
ENCNTR_ID DOUBLE N The encounter ID to which this request is associated.
ORD_RQSTN_ID DOUBLE N Unique order requisition identifier about which information is stored.
RQSTN_ASSIGNMENT_IDENT VARCHAR(16) N Request identifier which identifies a group of orders.
SEQ_NBR DOUBLE N Contains the sequence number portion of the requested assignment ident.
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 - ORD_RQSTN


Child Column in ORD_RQSTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in ORD_RQSTN (PK) Child Table Name Child Column Name
Children: ORD_RQSTN_ID ORD_RQSTN_ORD_R ORD_RQSTN_ID


ORD_RQSTN_ASSIGNMENT



Column Section Top of Page


Table-level Detail

Description: Order Requisition Assignment
Definition: Holds the next sequence values which will be used to assign request ids.
Table Type: ACTIVITY





Column Detail - ORD_RQSTN_ASSIGNMENT


Column Name Type Null? Definition
CLIENT_ALIAS_NAME VARCHAR(6) N Client name to which this sequence refers.
NEXT_SEQ_NBR DOUBLE N Contains the next sequence value to be used.
ORD_RQSTN_ASSIGNMENT_ID DOUBLE N Uniquely identifies a row which contains information about the next sequence values to be used for an assignment request id.
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.