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