Table Detail Report

CR_REPORT_SECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Report Section
Definition: This table stores Report Section information
Table Type: REFERENCE





Column Detail - CR_REPORT_SECTION


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 Y 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.
LONG_TEXT_ID DOUBLE N ID to find XML related to the section
NAME_IDENT VARCHAR(167) N Unique Identifier used for merge processes. A concatenation of the name_key and date column.
REPORT_SECTION_ID DOUBLE N Primary key of the table
SECTION_ID DOUBLE N Supports section versioning. The row where REPORT_SECTION_ID = SECTION_ID represents the 'original' row.
SECTION_NAME VARCHAR(150) N User defined name for the section
SECTION_NAME_KEY VARCHAR(150) Y Section Name Key. Converted to key format. To be used as part of unique identifier for merge.
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_SECTION


Child Column in CR_REPORT_SECTION(FK) Parent Table Name Parent Column Name
Parents: SECTION_ID CR_REPORT_SECTION REPORT_SECTION_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in CR_REPORT_SECTION (PK) Child Table Name Child Column Name
Children: REPORT_SECTION_ID CR_PRINTED_SECTIONS SECTION_ID
CR_REPORT_REQUEST_SECTION SECTION_ID
CR_REPORT_SECTION SECTION_ID
CR_TEMPLATE_SNAPSHOT SECTION_ID


CR_REPORT_STATIC_REGION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Report Static Region
Definition: Stores the library of template border configurations. This includes the header, footer, left margin and right margin.
Table Type: REFERENCE





Column Detail - CR_REPORT_STATIC_REGION


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 Y 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.
LONG_TEXT_ID DOUBLE N ID to find XML related to the region FK from LONG_TEXT_REFERENCE table
NAME_IDENT VARCHAR(167) N Unique Identifier used for merge processes. A concatenation of the name_key and date column.
REGION_NAME VARCHAR(150) N User defined name for the region
REGION_NAME_KEY VARCHAR(150) Y Region Name in key format. To be used as part of unique identifier for merge.
REPORT_STATIC_REGION_ID DOUBLE N Primary key of the table
STATIC_REGION_ID DOUBLE N Supports static region versioning. The row where STATIC_REGION_ID = RPT_STATIC_REGION_ID represents the 'original' row.
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_STATIC_REGION


Child Column in CR_REPORT_STATIC_REGION(FK) Parent Table Name Parent Column Name
Parents: STATIC_REGION_ID CR_REPORT_STATIC_REGION REPORT_STATIC_REGION_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in CR_REPORT_STATIC_REGION (PK) Child Table Name Child Column Name
Children: REPORT_STATIC_REGION_ID CR_REPORT_STATIC_REGION STATIC_REGION_ID
CR_STATIC_REGION_LOC_RELTN STATIC_REGION_ID
CR_STATIC_REGION_ORG_RELTN STATIC_REGION_ID
CR_STATIC_REGION_SR_RELTN STATIC_REGION_ID
CR_TEMPLATE_SNAPSHOT STATIC_REGION_ID


CR_REPORT_STYLE_PROFILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CR Report Style Profile
Definition: This table stores the Report Style Profile. The style profile can be associated with a report template to flex the styling of reports generated with that template.
Table Type: REFERENCE





Column Detail - CR_REPORT_STYLE_PROFILE


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.
LONG_TEXT_ID DOUBLE N ID to find XML related to the style profile (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_STYLE_PROFILE_ID DOUBLE N Primary Key Of The Table
STYLE_PROFILE_ID DOUBLE N Supports style profile versioning. The row where REPORT_STYLE_PROFILE_ID = STYLE_PROFILE_ID represents the current row.
STYLE_PROFILE_NAME VARCHAR(150) N User-defined name of the style profile.
STYLE_PROFILE_NAME_KEY VARCHAR(150) N The user-defined name of the style profile converted to key format to be used as part of unique identifier for merge.
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_STYLE_PROFILE


Child Column in CR_REPORT_STYLE_PROFILE(FK) Parent Table Name Parent Column Name
Parents: STYLE_PROFILE_ID CR_REPORT_STYLE_PROFILE REPORT_STYLE_PROFILE_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in CR_REPORT_STYLE_PROFILE (PK) Child Table Name Child Column Name
Children: REPORT_STYLE_PROFILE_ID CR_REPORT_STYLE_PROFILE STYLE_PROFILE_ID
CR_REPORT_TEMPLATE REPORT_STYLE_PROFILE_ID


CR_REPORT_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Report Template
Definition: This table stores all the templates defined by the client.
Table Type: REFERENCE





Column Detail - CR_REPORT_TEMPLATE


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 Y 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.
FACESHEET_ID DOUBLE N Unique identifier of the Facesheet defined for the report template. Foreign Key value from the PM_POST_DOC_REF table.
LAB_LEGEND_ID DOUBLE N ID to find the cr_report_legend associated to this report_template for lab measurement sections
LANDSCAPE_WATERMARK_ID DOUBLE N Unique identifier of the watermark image to be used for landscape pages
LONG_TEXT_ID DOUBLE N ID to find XML related to the template FK from LONG_TEXT_REFERENCE table
MICRO_LEGEND_ID DOUBLE N ID to find the cr_report_legend associated to this report_template for microbiology sections
NAME_IDENT VARCHAR(167) N Unique Identifier used for merge processes. A concatenation of the name key and date column.
PAT_CARE_LEGEND_ID DOUBLE N ID to find the cr_report_legend associated to this report_template for patient care sections
PORTRAIT_WATERMARK_ID DOUBLE N Unique identifier of the watermark image to be used for portrait pages
REPORT_STYLE_PROFILE_ID DOUBLE N Identifies the style profile associated with the report template
REPORT_TEMPLATE_ID DOUBLE N Primary key of the table
SUMMARY_TYPE_CD DOUBLE N Type of Summary Care Record to be generated
TEMPLATE_ID DOUBLE N Supports template versioning. The row where TEMPLATE_ID = REPORT_TEMPLATE_ID represents the 'original' row.
TEMPLATE_NAME VARCHAR(150) N User defined name of the template
TEMPLATE_NAME_KEY VARCHAR(150) Y Template Name in key format. To be used as part of unique identifier for merge process.
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_TEMPLATE


Child Column in CR_REPORT_TEMPLATE(FK) Parent Table Name Parent Column Name
Parents: LAB_LEGEND_ID CR_REPORT_LEGEND REPORT_LEGEND_ID
MICRO_LEGEND_ID CR_REPORT_LEGEND REPORT_LEGEND_ID
PAT_CARE_LEGEND_ID CR_REPORT_LEGEND REPORT_LEGEND_ID
REPORT_STYLE_PROFILE_ID CR_REPORT_STYLE_PROFILE REPORT_STYLE_PROFILE_ID
TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID
LANDSCAPE_WATERMARK_ID CR_REPORT_WATERMARK REPORT_WATERMARK_ID
PORTRAIT_WATERMARK_ID CR_REPORT_WATERMARK REPORT_WATERMARK_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
FACESHEET_ID PM_POST_DOC_REF PM_POST_DOC_REF_ID




Parent Column in CR_REPORT_TEMPLATE (PK) Child Table Name Child Column Name
Children: REPORT_TEMPLATE_ID CHART_TRIGGER REPORT_TEMPLATE_ID
CR_REPORT_REQUEST TEMPLATE_ID
CR_REPORT_TEMPLATE TEMPLATE_ID
CR_TEMPLATE_POSITION_RELTN TEMPLATE_ID
CR_TEMPLATE_PUBLISH TEMPLATE_ID
CR_TEMPLATE_SNAPSHOT TEMPLATE_ID
DEVICE_OUTPUT_RELTN TEMPLATE_ID
EXPEDITE_FORMAT TEMPLATE_ID
EXPEDITE_MANUAL TEMPLATE_ID
EXPEDITE_PARAMS TEMPLATE_ID
EXT_DOC_TEMPLATE_CONFIG TEMPLATE_ID
RCM_DIRECT_COMM TEMPLATE_ID
RCM_POST_ACUTE_UPLOAD TEMPLATE_ID
RCM_TLC_UPLOAD TEMPLATE_ID
RCM_TMPLT_EVENT_SET_RELTN TEMPLATE_ID
SI_DOCUMENT_INFO REPORT_TEMPLATE_ID
SI_ENTITY_TEMPLATE_GROUP_R REPORT_TEMPLATE_ID


CR_REPORT_WATERMARK



Column Section Relationship Section Top of Page


Table-level Detail

Description: CR REPORT WATERMARK
Definition: Table that stores the available watermark images that can be applied to a Clinical Reporting XR Report
Table Type: REFERENCE





Column Detail - CR_REPORT_WATERMARK


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.
FILE_NAME VARCHAR(100) N filename for a watermark image
LONG_BLOB_ID DOUBLE N unique identifier to the long_blob_reference table where the image is stored.
ORIENTATION_FLAG DOUBLE N Indication as to what type of page orientation this image should be applied to. 0= Portrait and 1 = Landscape
REPORT_WATERMARK_ID DOUBLE N Unique generated number that identifies a single row on the CR_REPORT_WATERMARK 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_WATERMARK


Child Column in CR_REPORT_WATERMARK(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID




Parent Column in CR_REPORT_WATERMARK (PK) Child Table Name Child Column Name
Children: REPORT_WATERMARK_ID CR_REPORT_TEMPLATE LANDSCAPE_WATERMARK_ID
CR_REPORT_TEMPLATE PORTRAIT_WATERMARK_ID