Table Detail Report

CR_MASK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Reporting Masks
Definition: Clinical Reporting mask entries
Table Type: REFERENCE





Column Detail - CR_MASK


Column Name Type Null? Definition
CR_MASK_ID DOUBLE N This is a number uniquely assigned to each chart request
CR_MASK_TEXT VARCHAR(255) N This is the mask for the request
DEFAULT_IND DOUBLE N This field is used to indicate whether the mask is set as default or not
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.
PUBLISH_IND DOUBLE N This field is used to indicate whether the mask is published or not
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 - CR_MASK


Child Column in CR_MASK(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in CR_MASK (PK) Child Table Name Child Column Name
Children: CR_MASK_ID CHART_REQUEST CR_MASK_ID


CR_OUTPUT_DESTINATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: CR_OUTPUT_DESTINATION
Definition: Holds output destinations for a report request
Table Type: ACTIVITY





Column Detail - CR_OUTPUT_DESTINATION


Column Name Type Null? Definition
COPIES_NBR DOUBLE N Number of copies to distribute
CR_OUTPUT_DESTINATION_ID DOUBLE N Primary key - A final location for a report request to be sent
DISK_LABEL VARCHAR(128) Y Label to be burnt to Disk
DISK_TYPE_FLAG DOUBLE N The type of disk (DVD = 2 or CD = 1)
DISTRIBUTED_STATUS_IND DOUBLE N STATUS INDICATOR for the Distributed Job 0 = ERRORED. 1 = SUCCESSFUL.
DMS_ADHOC_FAX_NUMBER_TXT VARCHAR(40) Y Ad hoc fax number
DMS_FAX_DISTRIBUTE_DT_TM DATETIME Y Date\Time to distribute fax
DMS_SERVICE_IDENT VARCHAR(110) Y Service Identifier of device
OUTPUT_DEST_CD DOUBLE N Output destination code for local printers. This is a value from the OUTPUT_DEST table (not a code set).
REPORT_REQUEST_ID DOUBLE N Foreign key - output destination for that report request
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 - CR_OUTPUT_DESTINATION


Child Column in CR_OUTPUT_DESTINATION(FK) Parent Table Name Parent Column Name
Parents: REPORT_REQUEST_ID CR_REPORT_REQUEST REPORT_REQUEST_ID
OUTPUT_DEST_CD OUTPUT_DEST OUTPUT_DEST_CD


CR_PRINTED_SECTIONS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Report Printed Sections
Definition: Stores the sections of a report that actually printed from a specific report request.
Table Type: ACTIVITY





Column Detail - CR_PRINTED_SECTIONS


Column Name Type Null? Definition
CONTENT_TYPE_CD DOUBLE N The content type of this section such as allergy, immunization, etc.
PRINTED_SECTION_ID DOUBLE N A number that uniquely identifies a row in this table
REPORT_REQUEST_ID DOUBLE N The identifier for the related report request
SECTION_ID DOUBLE N The identifier of the report section that was printed
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 - CR_PRINTED_SECTIONS


Child Column in CR_PRINTED_SECTIONS(FK) Parent Table Name Parent Column Name
Parents: REPORT_REQUEST_ID CR_REPORT_REQUEST REPORT_REQUEST_ID
SECTION_ID CR_REPORT_SECTION REPORT_SECTION_ID


CR_REPORT_LEGEND



Column Section Relationship Section Top of Page


Table-level Detail

Description: CR_REPORT_LEGEND
Definition: Table that stores the available legends that can be applied to a Clinical Reporting XR Report
Table Type: REFERENCE





Column Detail - CR_REPORT_LEGEND


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LEGEND_ID DOUBLE N Supports legend versioning (ALG2). The row where REPORT_LEGEND_ID = LEGEND_ID represents the current row.
LEGEND_NAME VARCHAR(150) N User-defined name of the legend.
LEGEND_NAME_KEY VARCHAR(150) N The user-defined name of the legend converted to key format to be used as part of unique identifier for merge.
LONG_TEXT_ID DOUBLE N ID to find the XML related to the legend (foreign key to long_text_reference table)
NAME_IDENT VARCHAR(167) N Unique identifier used for merge processes. A concatenation of the name_key and date column.
REPORT_LEGEND_ID DOUBLE N Primary Key. Unique generated number that identifies a single row onthe 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 - CR_REPORT_LEGEND


Child Column in CR_REPORT_LEGEND(FK) Parent Table Name Parent Column Name
Parents: LEGEND_ID CR_REPORT_LEGEND REPORT_LEGEND_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in CR_REPORT_LEGEND (PK) Child Table Name Child Column Name
Children: REPORT_LEGEND_ID CR_REPORT_LEGEND LEGEND_ID
CR_REPORT_TEMPLATE LAB_LEGEND_ID
CR_REPORT_TEMPLATE MICRO_LEGEND_ID
CR_REPORT_TEMPLATE PAT_CARE_LEGEND_ID


CR_REPORT_REQUEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Report Request Table
Definition: Logs all the report requests for the new XML/XSL Clinical Reporting solution. This table is equivalent to the original CHART_REQUEST table that is used for the original solution based on MS Word architecture.
Table Type: ACTIVITY





Column Detail - CR_REPORT_REQUEST


Column Name Type Null? Definition
ACCESSION_NBR VARCHAR(20) Y This is the accession number for the results that will print on the accession level chart
BEGIN_DT_TM DATETIME Y This is the date and time that is used to determine how far back the system should look when searching for data to include on the chart.
CHART_TRIGGER_ID DOUBLE N Primary for a given key from the CHART_TRIGGER table.
CONCEPT_SERVICE_NAME VARCHAR(100) Y The name of the external service requesting the report. Example: Anatomic Pathology, Radiology, Cardio
CONTACT_INFO VARCHAR(255) Y The contact information defined to be included in a fax cover page and RRD report title.
COPIES_NBR DOUBLE Y Stores the number of copies to print for this chart..
CUSTODIAL_ORG_ID DOUBLE N This is the unique identifier for the organization that owns or issues the continuity of care document (CCD) that was generated. (FK from ORGANIZATION table)
DEBUG_ZIP_ID DOUBLE N Stores the reference back to Long_Blob table where the debug ZIP file for this report request is stored.
DESTINATION_TYPE_FLAG DOUBLE N Stores the type of destination. Possible values are person, organization, or free-text.
DESTINATION_VALUE_TXT VARCHAR(255) Y The logical destination of the chart.
DEX_PAYLOAD_SIZE DOUBLE Y The size of the payload sent from Data Extraction for report generation.
DIRECT_PARENT_REQUEST_ID DOUBLE N DIRECT_PARENT_REQUEST_ID always points back to the request ID which was just resubmitted
DISK_IDENTIFIER DOUBLE N Unique number that identifies a set of requests burned to a disk
DISK_LABEL VARCHAR(128) Y label of CD/DVD that report will be burned on
DISK_TYPE_FLAG DOUBLE N The type of disk (DVD or CD)
DISTRIBUTION_ID DOUBLE N This is a number which uniquely identifies a chart distribution
DIST_RUN_DT_TM DATETIME Y This is the date and time that the distribution was started
DIST_RUN_TYPE_CD DOUBLE N This is the code from the code set 22550 which determines what type of chart will be produced (i.e. interim, cummulative)
DMS_ADHOC_FAX_NUMBER_TXT VARCHAR(40) Y The fax number that the DMS service distributes this chart to. It is for Ad Hoc fax only.
DMS_FAX_DISTRIBUTE_DT_TM DATETIME Y The date and time that the DMS service distributes this chart. It is for fax only.
DMS_SERVICE_IDENT VARCHAR(110) Y Indicates the DMS service to send this chart to. Rplaces the DMS_SERVICE_NAME field (which was only for print devices). This new field effective on Feature 136623 - 9/07.
DMS_SERVICE_NAME VARCHAR(64) Y Obsolete ** Identifies the DMS service to send this chart to. This has been replaced by the DMS_SERVICE_IDENT field (initial release on Feature 136623 9/4/07.
EMAIL_BODY_ID DOUBLE N The reference to the long_text row that defines the message for the email.
EMAIL_SUBJECT_ID DOUBLE N The reference to the long_text row that defines the subject for the email.
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 This is the date and time that marks the end of the date range of data to include on the chart.
EXTERNAL_CONTENT_IDENT VARCHAR(64) Y IDENTIFIER of the external media content to be included in the report
EXTERNAL_CONTENT_NAME VARCHAR(100) Y Name of the facesheet to be included in the report
FILE_MASK VARCHAR(255) Y Mask for File Name
FILE_NAME VARCHAR(255) Y Name of the file to be saved
MESSAGE_IDENT VARCHAR(255) Y A globally unique identifier, defined when a report request is sent as an email.
NON_CE_BEGIN_DT_TM DATETIME Y This is the date/time used to determine how far back the system should look when searching for clinical insignificant data to include on the chart.
NON_CE_END_DT_TM DATETIME Y This is the date/time that marks the end of the date range for clinical insignificant data to be included on the chart.
ORDER_ID DOUBLE N This is the value of the unique primary identifier of the orders table. It is an internal system assigned number.
OUTPUT_CONTENT_TYPE_CD DOUBLE N The output content type of this chart (such as PDF, Plain Text, ort HITSP C32, etc.) Replaces the OUTPUT_CONTENT_TYPE_STR field.
OUTPUT_CONTENT_TYPE_STR VARCHAR(255) Y ** OBSOLETE ** (this column/function will be replaced by OUTPUT_CONTENT_TYPE_CD - 2010) The output content type strings should match common content type definitions according to the MIME specification (text/plain, application/pdf, etc.).
OUTPUT_DEST_CD DOUBLE N Identifies the output destination to send this chart to. This is used for legacy output destinations.
PARENT_REQUEST_ID DOUBLE N When a report is resubmitted a new row will be added to the table. This attribute points back to the original report request.
PATIENT_CONSENT_RECEIVED_IND DOUBLE N Indicates if patient consent was received before requesting this chart.
PATIENT_REQUEST_IND DOUBLE N Indicates if the rfequest was made for a Patient
PERSONA_TXT VARCHAR(100) Y The type of user making the request. Example: Patient, Provider, etc.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROCESSING_TIME DOUBLE Y Number of seconds it took to process this request
PROVIDER_PRSNL_ID DOUBLE N The prsnl_id for whom the report is intended.
PROVIDER_RELTN_CD DOUBLE N The encounter or person level relationship the provider has with the person's chart.
PRSNL_RELTN_ID DOUBLE N Identifies the personnel relation associated to the request
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)
READER_GROUP VARCHAR(15) Y This field when defined is used to link one distribution with another
RELEASE_COMMENT VARCHAR(1000) Y Additional comments about the requesting of this chart.
RELEASE_REASON_CD DOUBLE N Reason for requesting the chart. Located on code set 14211.
REPORT_FILE_SIZE DOUBLE Y The file size of clinical report generated for the report request.
REPORT_REQUEST_ID DOUBLE N The primary identifier that uniquely identifies a row on the table.
REPORT_STATUS_CD DOUBLE N Stores the status of the report request. A different code set will be used from the original chart_status_cd code set because of different statuses and potential error codes.
REQUESTING_ROLE_PROFILE VARCHAR(255) Y Stores the role profile identifier of the requesting user so that the server can establish the proper security context.
REQUESTOR_TYPE_FLAG DOUBLE N Stores the type of requestor. Possible values are person, organization, or free-text.
REQUESTOR_VALUE_TXT VARCHAR(255) Y The logical requestor of the chart.
REQUEST_APP_NBR DOUBLE Y Stores the requesting application number of a request.
REQUEST_DT_TM DATETIME N The date and time the report request was created.
REQUEST_PRSNL_ID DOUBLE N This is the prsnl_id of the person who submitted the report request. If the report was submitted by a distribution run, this field will be populated by the SYSTEM row.
REQUEST_TYPE_FLAG DOUBLE N This identifies the type of report request that has been submitted (i.e. ad hoc, distribution, expedite, manual expedite, document service, concept service)
REQUEST_XML_ID DOUBLE N The LONG_TEXT row that represents the original HTTP request sent to generate this report.
RESUBMIT_CNT DOUBLE N This is the count of times for the report request row being resubmitted
RESULT_STATUS_FLAG DOUBLE N Flag to represent what type of results should be included on the chart based on their status. 1 = all statuses, 2 = verified and pending, 3 = verified only.
ROUTE_ID DOUBLE N Foreign key to point to the unique ID for the chart route.
ROUTE_STOP_ID DOUBLE N Foreign key to point to the unique ID for the chart_sequence_group.
RRD_HANDLE_ID DOUBLE N The unique identifier on the OUTPUTCTX table for a report faxed by RRD.
SCOPE_FLAG DOUBLE N This is the scope of the report request (i.e. accession, order, encounter)
SENDER_EMAIL VARCHAR(100) Y The email address that the email request will be sent from.
SEQUENCE_NBR DOUBLE Y The relative collation sequence within a batch of requests.
SERVER_FULL_NAME VARCHAR(250) Y The description of the server that processed the request
STATUS_TEXT_ID DOUBLE N The reference to the long_text row that defines the status of the report request.
SUMMARY_REPORT_XML_ID DOUBLE N The LONG_TEXT row that stores the summary XML document of what was printed in the report. This file is used for the Disclosure Audit Log.
TEMPLATE_ID DOUBLE N This is the number that uniquely identifies the report template used to format the report.
TEMPLATE_VERSION_DT_TM DATETIME Y The date / time of the template version used for this request.
TEMPLATE_VERSION_MODE_FLAG DOUBLE Y Indicates what version of the template should be used in the request.
TOTAL_PAGES_NBR DOUBLE Y Total pages of the report generated.
TRIGGER_ID DOUBLE N Trigger_id for ESO from the CQM_FSIESO_TR_1 table.
TRIGGER_NAME VARCHAR(100) Y Stores the trigger name that fired the report request. Triggers are created in the Expedite Tool and are not related to the ESO trigger_id and trigger_type.
TRIGGER_TYPE VARCHAR(15) Y Activity type of the event being charted
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.
USE_POSTING_DATE_IND DOUBLE N Indicates whether or not to use the clinically relevant date or the posting date in the date range selection.
XR_BITMAP DOUBLE Y This column will be a bitmap that that can use to set various details about the request that will be useful for troubleshooting.



Relationship Detail - CR_REPORT_REQUEST


Child Column in CR_REPORT_REQUEST(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID CHART_DISTRIBUTION DISTRIBUTION_ID
ROUTE_ID CHART_ROUTE CHART_ROUTE_ID
ROUTE_STOP_ID CHART_SEQUENCE_GROUP SEQUENCE_GROUP_ID
CHART_TRIGGER_ID CHART_TRIGGER CHART_TRIGGER_ID
TRIGGER_ID CQM_FSIESO_TR_1 TRIGGER_ID
TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
DEBUG_ZIP_ID LONG_BLOB LONG_BLOB_ID
EMAIL_BODY_ID LONG_TEXT LONG_TEXT_ID
EMAIL_SUBJECT_ID LONG_TEXT LONG_TEXT_ID
REQUEST_XML_ID LONG_TEXT LONG_TEXT_ID
STATUS_TEXT_ID LONG_TEXT LONG_TEXT_ID
SUMMARY_REPORT_XML_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
CUSTODIAL_ORG_ID ORGANIZATION ORGANIZATION_ID
RRD_HANDLE_ID OUTPUTCTX HANDLE_ID
OUTPUT_DEST_CD OUTPUT_DEST OUTPUT_DEST_CD
PERSON_ID PERSON PERSON_ID
PROVIDER_PRSNL_ID PRSNL PERSON_ID
REQUEST_PRSNL_ID PRSNL PERSON_ID
PRSNL_RELTN_ID PRSNL_RELTN PRSNL_RELTN_ID




Parent Column in CR_REPORT_REQUEST (PK) Child Table Name Child Column Name
Children: REPORT_REQUEST_ID CR_OUTPUT_DESTINATION REPORT_REQUEST_ID
CR_PRINTED_SECTIONS REPORT_REQUEST_ID
CR_REPORT_REQUEST_ACTIVITY REPORT_REQUEST_ID
CR_REPORT_REQUEST_ENCNTR REPORT_REQUEST_ID
CR_REPORT_REQUEST_EVENT REPORT_REQUEST_ID
CR_REPORT_REQUEST_SECTION REPORT_REQUEST_ID
ENCNTR_CARE_MGMT_COMM REPORT_REQUEST_ID
RCM_POST_ACUTE_UPLOAD REPORT_REQUEST_ID
RCM_TLC_PLACEMENT_FAC_R REPORT_REQUEST_ID
RCM_TLC_SERVICE_FAC_R REPORT_REQUEST_ID
RCM_TLC_UPLOAD REPORT_REQUEST_ID
ROI_REQUEST REPORT_REQUEST_ID