Table Detail Report

EXPEDITE_MANUAL_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains a sub set of event_ids for a given expedite_manual request
Definition: expedite_manual_event
Table Type: ACTIVITY





Column Detail - EXPEDITE_MANUAL_EVENT


Column Name Type Null? Definition
EM_EVENT_ID DOUBLE N primary key for this table
EM_EVENT_SEQ DOUBLE Y sequence of event_ids
EVENT_ID DOUBLE Y Unique identifier for an event. Uniquely identifies a logical clinical event row. There may be more than one row with the same event_id, but only one of those rows will be current as indicated by the valid_until_dt_tm field
EXPEDITE_MANUAL_ID DOUBLE Y Foreign key to expedite_manual tableColumn
RESULT_STATUS_CD DOUBLE Y result_statusColumn
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 - EXPEDITE_MANUAL_EVENT


Child Column in EXPEDITE_MANUAL_EVENT(FK) Parent Table Name Parent Column Name
Parents: EXPEDITE_MANUAL_ID EXPEDITE_MANUAL EXPEDITE_MANUAL_ID


EXPEDITE_PARAMS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Expedite Parameters
Definition: The parameters used to produce an expedite once it is triggered. Contains info about the kind of expedite to produce and where to send it.
Table Type: REFERENCE





Column Detail - EXPEDITE_PARAMS


Column Name Type Null? Definition
CHART_CONTENT_FLAG DOUBLE Y Indicates whether the expedite chart should contain all results or just new results since the last expedite.
CHART_FORMAT_ID DOUBLE Y The chart format used to produce the expedite chart.
COPIES_FLAG DOUBLE Y Obsolete - This indicates who should receive additional copies of the expedite chart.
COPIES_OUTPUT_FLAG DOUBLE Y Obsolete - Indicates the method used to determine the output_dest for the additional copies.
COPY_IND DOUBLE Y Used to keep track of the provider types that should receive a copy of chart.
EXPEDITE_PARAMS_ID DOUBLE N Primary key to uniquely identify row. Internal system generated identifier.
EXP_PROV_IND DOUBLE N 0 = Both expired and non-expired provider relations. 1 = Non-expired provider relations only.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
NAME VARCHAR(100) N Description of the expedite parameters.
NAME_KEY VARCHAR(100) N Indexed and converted version of name column for searching.
ORDER_DOC_FLAG DOUBLE N This indicates which ordering provider should receive copies of the expedite chart. 0 = original ordering provider; 1 = current ordering provider; 2 = original and current ordering provider; 3 = all ordering providers
OUTPUT_DEST_CD DOUBLE Y Indicates the destination (i.e. printer) at which to produce the expedite chart.
OUTPUT_DEVICE_CD DOUBLE Y This column is only used if the outputdestination is an rrd device. It indicates the type of device (i.e. printer or fax).
OUTPUT_FLAG DOUBLE Y Specifies the method to use to find the output_dest for the chart.
PATHOLOGIST_DEFAULT_IND DOUBLE N This indicates if the expedite chart is sent to responsible pathologist by default: 1 = the default chart is sent to responsible pathologist (only used for AP reports); 0 = the default chart is sent to admitting provider.
SENDING_ORG_ID DOUBLE N Identifies the sending organization for the trigger
TEMPLATE_ID DOUBLE N The template ID of a report Template used to produce expedite reports. Foreign Key from CR_REPORT_TEMPLATE table.
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 - EXPEDITE_PARAMS


Child Column in EXPEDITE_PARAMS(FK) Parent Table Name Parent Column Name
Parents: CHART_FORMAT_ID CHART_FORMAT CHART_FORMAT_ID
TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
SENDING_ORG_ID ORGANIZATION ORGANIZATION_ID
OUTPUT_DEST_CD OUTPUT_DEST OUTPUT_DEST_CD




Parent Column in EXPEDITE_PARAMS (PK) Child Table Name Child Column Name
Children: EXPEDITE_PARAMS_ID EXPEDITE_COPY EXPEDITE_PARAMS_ID
EXPEDITE_PARAMS_R EXPEDITE_PARAMS_ID


EXPEDITE_PARAMS_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: EXPEDITE PARAMS R
Definition: Used to associate expedite parameters to triggers.
Table Type: REFERENCE





Column Detail - EXPEDITE_PARAMS_R


Column Name Type Null? Definition
EXPEDITE_PARAMS_ID DOUBLE N Foreign key to expedite_params table.
EXPEDITE_TRIGGER_ID DOUBLE N Foreign key to expedite_trigger table.
PRECEDENCE_SEQ DOUBLE Y Used to determine which row wins in the case that more one expedite qualifies per printer.
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 - EXPEDITE_PARAMS_R


Child Column in EXPEDITE_PARAMS_R(FK) Parent Table Name Parent Column Name
Parents: EXPEDITE_PARAMS_ID EXPEDITE_PARAMS EXPEDITE_PARAMS_ID
EXPEDITE_TRIGGER_ID EXPEDITE_TRIGGER EXPEDITE_TRIGGER_ID


EXPEDITE_PROCESSING



Column Section Top of Page


Table-level Detail

Description: EXPEDITE PROCESSING
Definition: Used to define the startup parameters for expedite processing.
Table Type: REFERENCE





Column Detail - EXPEDITE_PROCESSING


Column Name Type Null? Definition
EXPEDITE_PROCESSING_FLAG DOUBLE N table key
LOG_LEVEL DOUBLE Y Used to indicate the level of information that should appear in the file ccluserdir:expedites.log.
ON_IND DOUBLE Y Used to turn expediting on and off at a system level.
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.


EXPEDITE_TRIGGER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Used to determine the conditions to trigger an expedite.
Definition: Used to determine the conditions to trigger an expedite. These rows are group by name when displayed to the user building the database.
Table Type: REFERENCE





Column Detail - EXPEDITE_TRIGGER


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.
ACTIVITY_TYPE_CD DOUBLE N Used to define expedites for all procedures of a specific activity type (i.e. blood bank, micro, ...).
CATALOG_CD DOUBLE N The order catalog item that the expedite rule applies to. Zero indicates that the expedite rule applies to all procedures.
CATALOG_TYPE_CD DOUBLE N Used to define expedites for all procedures with a specific catalog_type_cd (i.e. lab, radiology, ...).
CODED_RESP_IND DOUBLE Y Indicates the trigger also includes coded responses.Column
DISCHARGED_FLAG DOUBLE Y Indicates whether the discharged/non-discharged status of a patient is used to determine if a result should be expedited.
EXPEDITE_TRIGGER_ID DOUBLE N Primary key used to uniquely identify the row. Internal system generated number.
LOCATION_CD DOUBLE N Used to specify the location that should trigger an expedite.Column
LOCATION_CONTEXT_FLAG DOUBLE Y Indicates whether the location_cd specified should be used if it is the patient's location, ordering location or temp location.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MIC_AFTER_COM_FLAG DOUBLE Y Indicates whether expedite the result when any antibiotic is verified/corrected after completion of the susceptibility method
MIC_COM_FLAG DOUBLE Y Indicate whether expedite the result upon completion of the susceptibility method
MIC_COR_FLAG DOUBLE Y Indicate whether expedite the result any antiniotic is correctedColumn
MIC_VER_FLAG DOUBLE Y Indicate whether expedite any antibiotic is verified
NAME VARCHAR(100) N Description of the expedite trigger. Used to group rows together for display purposes in the database building tool.
NAME_KEY VARCHAR(100) N Indexed and converted version of the name column used for searching purposes.Column
ORDER_COMPLETE_FLAG DOUBLE Y If set then the result should only expedite when the order is complete.Column
ORGANIZATION_ID DOUBLE N Organization that should trigger an expedite.Column
PROVIDER_ID DOUBLE N person idColumn
REFERENCE_TASK_ID DOUBLE N task that should expedite a PowerForm tirgger
REPORT_PRIORITY_CD DOUBLE N Produce an expedite for a result with this report priority (i.e. routine, stat, ...). Zero indicates that an expedite should be produced for all priorities.
REPORT_PROCESSING_CD DOUBLE N Produce expedites for these events (i.e. first report, final report, ...). Used primarily for micro and Radnet. Zero indicates that an expedite should be produced for all events.
REPORT_PROCESSING_NBR DOUBLE Y Used to indicate the number of times a specific report processing cd should trigger an expedite.
RESULT_CD DOUBLE N Used to indicate the result (i.e. positive or negative) that should trigger an expedite.
RESULT_NBR DOUBLE Y Used to indicate the number of times a particular result (pos or neg) should expedite.
RESULT_RANGE_CD DOUBLE N Used to indicate the result ranges (i.e. high, low, etc.) that should trigger an expedite.
RESULT_STATUS_CD DOUBLE N Produce an expedite for a result with this status (i.e. produce an expedite when the result is first performed or every time it is verified...). Zero indicates that an expedite should be produced for all results.
SERVICE_RESOURCE_CD DOUBLE N Produce an expedite if the result is performed at this service resource. Zero indicates that an expedite should be produced for all service resources.
SYNONYM_ID DOUBLE N order catalog synonymColumn
TASK_ASSAY_CD DOUBLE N Produce an expedite when this task_assay_cd is resulted. Zero indicates that an expedite should be produced for all task_assay_cds.
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 - EXPEDITE_TRIGGER


Child Column in EXPEDITE_TRIGGER(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
PROVIDER_ID PRSNL PERSON_ID




Parent Column in EXPEDITE_TRIGGER (PK) Child Table Name Child Column Name
Children: EXPEDITE_TRIGGER_ID EXPEDITE_CODED_RESP EXPEDITE_TRIGGER_ID
EXPEDITE_PARAMS_R EXPEDITE_TRIGGER_ID