CONFIG_PREFS



Column Section Top of Page


Table-level Detail

Description: CONFIGURATION PREFERENCES
Definition: This table is meant to flexibly store software configuration information
Table Type: REFERENCE





Column Detail - CONFIG_PREFS


Column Name Type Null? Definition
CONFIG_NAME VARCHAR(255) N The name portion of the name-value pair for this configuration row.
CONFIG_PREFS_ID DOUBLE N This is the primary index for this table assigned from the CareNet sequence.
CONFIG_VALUE VARCHAR(256) Y The value portion of the name-value pair for this configuration row.
FLEXED_BY VARCHAR(12) N cdf_meaning from 14282 stating how a row is being flexed
PARENT_ENTITY_ID DOUBLE N The primary index of the row from the parent table, if applicable, of how this row of configuration row is being flexed.
PARENT_ENTITY_NAME VARCHAR(30) N The parent table, if applicable, of how this row of configuration row is being flexed.
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.


ECO_ACTION_QUEUE



Column Section Top of Page


Table-level Detail

Description: Explode Continuing Orders Action Queue
Definition: A queue of actions that the ECO server must process for a given order.
Table Type: ACTIVITY





Column Detail - ECO_ACTION_QUEUE


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N The sequence of the actions that have been taken on an order. This is part of the primary key.
ACTION_TYPE_CD DOUBLE N The type of action that was taken on the order.
EFFECTIVE_DT_TM DATETIME Y The date/time the action takes effect.
NEXT_INSTANCE_DT_TM DATETIME Y The next instance that will be exploded by the eco server.
ORDER_ID DOUBLE N Points to the order that the eco needs to reference to explode the order.
ORDER_STATUS_CD DOUBLE N The status of the order after the action was taken on it.
PROCESSED_DT_TM DATETIME Y When the action was processed by the eco server.
QUEUE_MODIFIER_BIT DOUBLE Y This bitset will hold qualifiers on the actions being queued up for ECO processing. Intended use is only to manage the queue itself, rather than what will be done to the order via the order action.
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.


ECO_JOB_TRACKING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Explode Child Order Job Progress Tracking
Definition: Tracks the progress of child order management on a job by job basis.
Table Type: ACTIVITY





Column Detail - ECO_JOB_TRACKING


Column Name Type Null? Definition
BEGIN_PROCESS_DT_TM DATETIME Y The date/time (UTC) when the job began processing.
CHILD_ORDER_CANCELED_CNT DOUBLE Y The number of child orders cancelled while processing this template order.
CHILD_ORDER_CREATED_CNT DOUBLE Y The number of child orders created while processing this template order.
CREATED_DT_TM DATETIME Y The time at which the tracking row was created.
ECO_JOB_TRACKING_ID DOUBLE N Unique generated number that identifies a single row on the ECO_JOB_TRACKING table.
JOB_TYPE_FLAG DOUBLE N Job type of this job. See flag definitions for individual values.
PROCESSING_SECS DOUBLE Y The number of seconds the job took to process. If process failed or was interrupted, will represent number of seconds until failure.
SUCCESS_PROCESSING_CNT DOUBLE Y Number of template orders successfully processed.
TEMPLATES_TO_PROCESS_CNT DOUBLE Y Number of template orders initially qualified to be processed in this job.
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 - ECO_JOB_TRACKING




Parent Column in ECO_JOB_TRACKING (PK) Child Table Name Child Column Name
Children: ECO_JOB_TRACKING_ID ECO_QUEUE ECO_JOB_TRACKING_ID
ECO_TEMPLATE_TRACKING ECO_JOB_TRACKING_ID


ECO_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Explode Continuing Orders Queue
Definition: This table is the work-list for the ECO server.
Table Type: ACTIVITY





Column Detail - ECO_QUEUE


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE Y Order action sequence which write the record. Replaced by action_sequence in eco_action_queue table.
ACTION_TYPE_CD DOUBLE N The action to be done on the instances (e.g. modify, cancel). Replaced by action_type_cd in eco_action_queue table.
BILL_ONLY_IND DOUBLE Y Indicates the instances should be created as bill-only.
CONT_ORDER_METHOD_FLAG DOUBLE Y Flag to define what type of continuing order the parent is.0 - Order; 1 - Task; 2 - Pharmacy
ECO_FLEX_SCHEDULE_ID DOUBLE N This is a foreign key to the ECO_FLEX_SCHEDULE table.
ECO_JOB_TRACKING_ID DOUBLE Y The ECO job tracking row associated to the queue row. A foreign key to the ECO_JOB_TRACKING table.
EFFECTIVE_DT_TM DATETIME Y The effective date and time of the action to be done on the instances. Replaced by effective_dt_tm in eco_action_queue table.
FREQ_UPDATED_IND DOUBLE Y If frequency is modified we communicate it with the eco server using this indicator. Replaced by eco_action_queue table.
LAST_INSTANCE_DT_TM DATETIME Y The date and time the most recent instance was scheduled for this continuing order parent. This is where the ECO server will start its next explosion calculations.
NEXT_EXPLOSION_DT_TM DATETIME Y This is the next time that the order will qualify for explosion by the ECO server.
NEXT_INSTANCE_DT_TM DATETIME Y The next instance for the schedule will be at this time.
NO_CHARGE_IND DOUBLE Y Indicates that instances for this order should not be charged for.
ORDER_ID DOUBLE N The ID of the parent order and the primary key of this ECO_QUEUE table..
PROCESSING_FLAG DOUBLE Y The eco can be flexed by different types of processing. This is where we will store which processing it picks.0 - Normal Processing; 1 - Inpatient Processing; 2 - Outpatient Processing; 3 - Outpatient Schedulable 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.



Relationship Detail - ECO_QUEUE


Child Column in ECO_QUEUE(FK) Parent Table Name Parent Column Name
Parents: ECO_JOB_TRACKING_ID ECO_JOB_TRACKING ECO_JOB_TRACKING_ID


ECO_TEMPLATE_TRACKING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Explode Continuing Orders by template order tracking
Definition: Tracks the processing of child order updates at the template order level.
Table Type: ACTIVITY





Column Detail - ECO_TEMPLATE_TRACKING


Column Name Type Null? Definition
BEGIN_PROCESS_DT_TM DATETIME Y The date/time (UTC) at which this template order begins processing.
CHILD_ORDER_CANCELED_CNT DOUBLE Y The number of child orders cancelled while processing this template order.
CHILD_ORDER_CREATED_CNT DOUBLE Y The number of child orders created while processing this template order.
ECO_JOB_SEQ DOUBLE Y The position of this template in the current job processing.
ECO_JOB_TRACKING_ID DOUBLE N Uniquely identifies the related job tracking record.
ECO_TEMPLATE_TRACKING_ID DOUBLE N Unique generated number that identifies a single row on the ECO_TEMPLATE_TRACKING table.
FAILURE_DEBUG_TXT VARCHAR(1000) Y Debug text explaining why this order has failed to explode child orders.
ORDER_ID DOUBLE N The order id of the template being processed by the child orders management service.
PROCESSING_SECS DOUBLE Y Number of seconds the template took to process to either completion or failure.
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 - ECO_TEMPLATE_TRACKING


Child Column in ECO_TEMPLATE_TRACKING(FK) Parent Table Name Parent Column Name
Parents: ECO_JOB_TRACKING_ID ECO_JOB_TRACKING ECO_JOB_TRACKING_ID
ORDER_ID ORDERS ORDER_ID