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 |