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