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 |