Table Detail Report

CR_SERVER_CONFIGURATION



Column Section Top of Page


Table-level Detail

Description: Clinical Reporting Server Configuration
Definition: This table stores the server configuration values used in report generation.
Table Type: REFERENCE





Column Detail - CR_SERVER_CONFIGURATION


Column Name Type Null? Definition
CR_SERVER_CONFIGURATION_ID DOUBLE N PRIMARY KEY
CR_SERVER_VALUE_TXT VARCHAR(255) N This value corresponds to the particular XR server environment configuration and is defined by the TYPE_FLAG. The value will be used in the XR Report Generation Service during report processing
TYPE_FLAG DOUBLE N The value defined for the TYPE_FLAG.Uniquely identifies a server config type. 23 values,
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.


CR_STATIC_REGION_LOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Reporting Static Region To Location Relationship
Definition: This table stores the relationships between Report Static Regions (Page Masters) and locations for a given date range.
Table Type: REFERENCE





Column Detail - CR_STATIC_REGION_LOC_RELTN


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.
CR_STATIC_REGION_LOC_RELTN_ID DOUBLE N PRIMARY KEY
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.
LOCATION_CD DOUBLE N The id of the location with which this row is associated.
STATIC_REGION_ID DOUBLE N The id of the static region with which this row is associated.FK from CR_REPORT_STATIC_REGION
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_STATIC_REGION_LOC_RELTN


Child Column in CR_STATIC_REGION_LOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: STATIC_REGION_ID CR_REPORT_STATIC_REGION REPORT_STATIC_REGION_ID
LOCATION_CD LOCATION LOCATION_CD


CR_STATIC_REGION_ORG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Reporting Static Region To Organization Relationship
Definition: This table stores the relationships between Report Static Regions (Page Masters) and organizations for a given date range.
Table Type: REFERENCE





Column Detail - CR_STATIC_REGION_ORG_RELTN


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.
CR_STATIC_REGION_ORG_RELTN_ID DOUBLE N PRIMARY KEY
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.
ORGANIZATION_ID DOUBLE N The id of the organization with which this row is associated.
STATIC_REGION_ID DOUBLE N The id of the static region with which this row is associated.FK from CR_REPORT_STATIC_REGION
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_STATIC_REGION_ORG_RELTN


Child Column in CR_STATIC_REGION_ORG_RELTN(FK) Parent Table Name Parent Column Name
Parents: STATIC_REGION_ID CR_REPORT_STATIC_REGION REPORT_STATIC_REGION_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


CR_STATIC_REGION_SR_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Reporting Page Masters and Service Resources Relationship
Definition: This table stores the relationships between Report Static Regions (Page Masters) and service resources for a given date range.
Table Type: REFERENCE





Column Detail - CR_STATIC_REGION_SR_RELTN


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.
CR_STATIC_REGION_SR_RELTN_ID DOUBLE N PRIMARY KEY
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.
SERVICE_RESOURCE_CD DOUBLE N A unique internal identifier for this service resource. CODE SET:221
STATIC_REGION_ID DOUBLE N The id of the static region with which this row is associated.
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_STATIC_REGION_SR_RELTN


Child Column in CR_STATIC_REGION_SR_RELTN(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD CODE_VALUE CODE_VALUE
STATIC_REGION_ID CR_REPORT_STATIC_REGION REPORT_STATIC_REGION_ID


CR_TEMPLATE_POSITION_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: CR_TEMPLATE_POSITION_RELTN
Definition: This table stores the relationships between report template and positions for a given date range. This table defines position access security of the report template.
Table Type: REFERENCE





Column Detail - CR_TEMPLATE_POSITION_RELTN


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.
CR_TEMPLATE_POSITION_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the cr_template_position_reltn table.
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.
POSITION_CD DOUBLE N The id of the position with which this row is associated (from code value / code set = 88).
TEMPLATE_ID DOUBLE N The unique identifier of the report template with which this row is associated. FK from cr_report_template.
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_TEMPLATE_POSITION_RELTN


Child Column in CR_TEMPLATE_POSITION_RELTN(FK) Parent Table Name Parent Column Name
Parents: POSITION_CD CODE_VALUE CODE_VALUE
TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID