EXPEDITE_CODED_RESP



Column Section Relationship Section Top of Page


Table-level Detail

Description: EXPEDITE CODED RESP
Definition: Used to trigger an expedite chart by a coded response for a task assay.
Table Type: REFERENCE





Column Detail - EXPEDITE_CODED_RESP


Column Name Type Null? Definition
CODED_RESPONSE_CD DOUBLE N Micro code_values for coded responses. Uses code set 1021 for organisms and 1022 for the other responses.
EXPEDITE_TRIGGER_ID DOUBLE N Part of primary key
NOMENCLATURE_ID DOUBLE N coded resp
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_CODED_RESP


Child Column in EXPEDITE_CODED_RESP(FK) Parent Table Name Parent Column Name
Parents: EXPEDITE_TRIGGER_ID EXPEDITE_TRIGGER EXPEDITE_TRIGGER_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


EXPEDITE_COPY



Column Section Relationship Section Top of Page


Table-level Detail

Description: List of provider types which should receive copy of expedite chart.
Definition: List of provider types which should receive copy of expedite chart. These can be flexed for each set of expedite_params. The copy_ind on the expedite_params table indicates whether there are rows on the expedite_copy table.
Table Type: REFERENCE





Column Detail - EXPEDITE_COPY


Column Name Type Null? Definition
ENCNTR_PRSNL_R_CD DOUBLE N The type of relationship between the provider (prsnl) and the patient (encntr). For example, admitting, attending, etc.
EXPEDITE_PARAMS_ID DOUBLE N Indicates the original expedite parameter that should be copied to provider types stored on this table.
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_COPY


Child Column in EXPEDITE_COPY(FK) Parent Table Name Parent Column Name
Parents: EXPEDITE_PARAMS_ID EXPEDITE_PARAMS EXPEDITE_PARAMS_ID


EXPEDITE_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Used to store chart_formats to use for manual expedite requests.
Definition: Used to store chart_formats to use for manual expedite requests based on activity types.
Table Type: REFERENCE





Column Detail - EXPEDITE_FORMAT


Column Name Type Null? Definition
ACTIVITY_TYPE_CD DOUBLE N Indicate the charting activity type
ACTIVITY_TYPE_DISP VARCHAR(40) Y code set 21969Column
ACTIVITY_TYPE_MEAN VARCHAR(12) Y meaning from code set 21969Column
CHART_CONTENT_FLAG DOUBLE Y cum or non cumColumn
CHART_FORMAT_ID DOUBLE N chart formatColumn
EXPEDITE_FORMAT_ID DOUBLE N primary keyColumn
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.
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_FORMAT


Child Column in EXPEDITE_FORMAT(FK) Parent Table Name Parent Column Name
Parents: CHART_FORMAT_ID CHART_FORMAT CHART_FORMAT_ID
TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID


EXPEDITE_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Troubleshooting table for the Cpm Expedite Server.
Definition: This table is used by the Cpm Expedite server to log transactions so they can be reprocessed with debug logging enabled to determine how the server processed it.
Table Type: ACTIVITY





Column Detail - EXPEDITE_LOG


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y This is the accession number from the request sent to the expedite server.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EVENT_DT_TM DATETIME Y This is the event date that was passed to the expedite server
LOG_ID DOUBLE N This is a unique id for the expedite_log table.
MESSAGE LONGBLOB Y This is the serialized transaction that is being logged.
MESSAGE_SIZE DOUBLE Y This is the size of the serialized transaction being logged.
NEXT_LOG_ID DOUBLE N If the size of the serialized message being logged is to large to fit in one record, it will be split into multiple records, and this points to the next record.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.



Relationship Detail - EXPEDITE_LOG


Child Column in EXPEDITE_LOG(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID


EXPEDITE_MANUAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: EXPEDITE MANUAL
Definition: Used to store manual expedite requests to be sent out when result is processed.
Table Type: ACTIVITY





Column Detail - EXPEDITE_MANUAL


Column Name Type Null? Definition
ACCESSION VARCHAR(20) N Foreign key to accession on the accession table.Column
BEGIN_DT_TM DATETIME Y Begin date for manual expediteColumn
CHART_CONTENT_FLAG DOUBLE Y Used to indicate the amount of results to include on a chart.Column
CHART_FORMAT_ID DOUBLE N chart formatColumn
COPIES_NBR DOUBLE N Stores the number of copies to print for this chart
DATE_RANGE_IND DOUBLE Y If dates were specificedColumn
DEVICE_NAME VARCHAR(50) Y name column from the device table - used for logging and troubleshooting.Column
DMS_SERVICE_IDENTIFIER VARCHAR(110) Y Identifies the DMS Service
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_DT_TM DATETIME Y End date for manual expediteColumn
EVENT_IND DOUBLE Y Identifies whether to chart specific events that are stored in the sub table chart_request_event
EXPEDITE_MANUAL_ID DOUBLE N Primary key.
ORDER_ID DOUBLE N Foreign key to orders table.Column
OUTPUT_DEST_CD DOUBLE N Printer or fax idColumn
OUTPUT_DEST_NAME VARCHAR(20) Y name column from the output_dest table - used for logging and troubleshooting.Column
OUTPUT_DEVICE_CD DOUBLE N The device typeColumn
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROVIDER_ID DOUBLE N Foreign key to prsnl table.Column
PROVIDER_ROLE_CD DOUBLE N Type of provider such as admitting, attending, ordering, etc.Column
PRSNL_ROLE_PROFILE_UID VARCHAR(150) Y The current RoleProfile UID of the user in context when the request was submitted (only used with SMR)
RRD_DELIVER_DT_TM DATETIME Y Date of faxColumn
RRD_PHONE_SUFFIX VARCHAR(50) Y Fax numberColumn
SCOPE_FLAG DOUBLE Y defines the level of the chartColumn
SENDING_ORG_ID DOUBLE N Indicates the sending organization for the expedite 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.
USER_ROLE_PROFILE VARCHAR(255) Y User role profile to be used during the processing of the requested chart



Relationship Detail - EXPEDITE_MANUAL


Child Column in EXPEDITE_MANUAL(FK) Parent Table Name Parent Column Name
Parents: CHART_FORMAT_ID CHART_FORMAT CHART_FORMAT_ID
TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
ORDER_ID ORDERS ORDER_ID
SENDING_ORG_ID ORGANIZATION ORGANIZATION_ID
OUTPUT_DEST_CD OUTPUT_DEST OUTPUT_DEST_CD
PERSON_ID PERSON PERSON_ID
PROVIDER_ID PRSNL PERSON_ID




Parent Column in EXPEDITE_MANUAL (PK) Child Table Name Child Column Name
Children: EXPEDITE_MANUAL_ID EXPEDITE_MANUAL_EVENT EXPEDITE_MANUAL_ID