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 |