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 |