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 |