Table Detail Report

DCP_FLEX_RTG



Column Section Top of Page


Table-level Detail

Description: Flex routing
Definition: Flex routing
Table Type: REFERENCE





Column Detail - DCP_FLEX_RTG


Column Name Type Null? Definition
DCP_FLEX_RTG_ID DOUBLE N flex routing is
DCP_OUTPUT_ROUTE_ID DOUBLE N output routing
FLEX_DEST_IND DOUBLE Y flexing destination ind
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.
VALUE1_CD DOUBLE N
VALUE2_CD DOUBLE N
VALUE3_CD DOUBLE N
VALUE4_CD DOUBLE N
VALUE5_CD DOUBLE N


DCP_OUTPUT_ROUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP OUTPUT ROUTE
Definition: DCP OUTPUT ROUTE
Table Type: REFERENCE





Column Detail - DCP_OUTPUT_ROUTE


Column Name Type Null? Definition
DCP_OUTPUT_ROUTE_ID DOUBLE N
PARAM1_CD DOUBLE N
PARAM2_CD DOUBLE N
PARAM3_CD DOUBLE N
PARAM4_CD DOUBLE N
PARAM5_CD DOUBLE N
PARAM_CNT DOUBLE Y
ROUTE_DESCRIPTION VARCHAR(100) Y
ROUTE_TYPE_FLAG DOUBLE Y
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 - DCP_OUTPUT_ROUTE




Parent Column in DCP_OUTPUT_ROUTE (PK) Child Table Name Child Column Name
Children: DCP_OUTPUT_ROUTE_ID ORDER_CATALOG CONSENT_FORM_ROUTING_CD
ORDER_CATALOG REQUISITION_ROUTING_CD


DEPT_ORD_STAT_SECURITY



Column Section Top of Page


Table-level Detail

Description: Department order status security
Definition: Used to enable/disable functionality based the dept_status of an order.
Table Type: REFERENCE





Column Detail - DEPT_ORD_STAT_SECURITY


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.
ALLOW_MODIFY_IND DOUBLE Y Determines whether the value of data identified by parent_entity_id can be modified for an order with that dept_status_cd.
DEPT_ORD_STAT_SECURITY_ID DOUBLE N Unique identifier for this table.
DEPT_STATUS_CD DOUBLE N Provides a more-detailed order status. This field is used to track the order status within a department. For example, a laboratory order may go through several different states before being completed, e.g. Collected, In-lab, Performed, Verified, etc.
PARENT_ENTITY_ID DOUBLE N The primary id of the table that this row is a child of. Will be the identifier to ORDER_ENTRY_FIELDS table.
PARENT_ENTITY_NAME VARCHAR(32) Y The name of the table that this row is a child of. Will be ORDER_ENTRY_FIELDS.
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.


DUP_CHECKING



Column Section Relationship Section Top of Page


Table-level Detail

Description: DUP CHECKING
Definition: Used to define the time range and action for order duplicate checking.
Table Type: REFERENCE





Column Detail - DUP_CHECKING


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.
CATALOG_CD DOUBLE N catalog code for the orderable
DUP_CHECK_SEQ DOUBLE N sequence number for duplicate checking
EXACT_HIT_ACTION_CD DOUBLE N Action code if the start date time are exact the same.
MIN_AHEAD DOUBLE Y number of minute ahead of the start date time of the order
MIN_AHEAD_ACTION_CD DOUBLE N Action code for minute ahead dup checking.
MIN_BEHIND DOUBLE Y number of minute behind the start date time of the order
MIN_BEHIND_ACTION_CD DOUBLE N Action code for minute behind dup checking.
OUTPAT_EXACT_HIT_ACTION_CD DOUBLE Y Dup check rule for out patient - action code if the start date time are exact the same.
OUTPAT_FLEX_IND DOUBLE Y Indicator to turn on special dup checking rules for out patient.
OUTPAT_MIN_AHEAD DOUBLE Y Dup checking rule for out patient - number of minute ahead of the start date time of the order
OUTPAT_MIN_AHEAD_ACTION_CD DOUBLE Y Dup checking rule for out patient - action code for minute ahead dup checking.
OUTPAT_MIN_BEHIND DOUBLE Y Dup checking rule for out patient - number of minute behind the start date time of the order
OUTPAT_MIN_BEHIND_ACTION_CD DOUBLE Y Dup checking rule for out patient - action code for minute behind dup checking.
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 - DUP_CHECKING


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


ECO_FLEX_SCHEDULE



Column Section Top of Page


Table-level Detail

Description: Explode Continuing Orders Flex Schedule
Definition: Stores all of the flexes that the ECO server will honor.
Table Type: REFERENCE





Column Detail - ECO_FLEX_SCHEDULE


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.
ADDITIONAL_EXPLOSION_HOURS DOUBLE Y Number of hours that the ECO server will explode child orders after the initial explosion.
CATALOG_TYPE_CD DOUBLE N Flexing option #2. What group the orderable falls into.
ECO_FLEX_SCHEDULE_ID DOUBLE N The unique identifier for this table.
INITIAL_EXPLOSION_HOURS DOUBLE Y The number of hours the eco will explode child orders at initial order time.
NEXT_EXPLOSION_TIME_FRAME DOUBLE Y Tells us how many hours prior to the last instance that is exploded, that the ECO server should explode additional instances.
PROCESSING_FLAG DOUBLE N This is a flexing parameter that can make the ECO server explode orders for different types of orders .0 - Normal Processing; 1 - Inpatient Processing; 2 - Outpatient Processing; 3 - Outpatient Scheduable Processing
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.