Table Detail Report

BR_DATAMART_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Filter
Definition: table to store filter for each category
Table Type: REFERENCE





Column Detail - BR_DATAMART_FILTER


Column Name Type Null? Definition
BR_DATAMART_CATEGORY_ID DOUBLE N id from br_datamart_category
BR_DATAMART_FILTER_ID DOUBLE N unique id for filter
EXPECTED_ACTION_VALUE_SET_ID DOUBLE N The action that is expected to happen for this measure and value set. From BR_DATAM_VAL_SET. This will be used to retrieve a list of values that are to be mapped for this filter.
FILTER_CATEGORY_MEAN VARCHAR(30) N unique string for filter category
FILTER_DISPLAY VARCHAR(100) N filter display name
FILTER_LIMIT DOUBLE N The number of results that can be selected for the filter. A zero means there is no limit.
FILTER_MEAN VARCHAR(30) N unique string for a filter
FILTER_SEQ DOUBLE N number to indicate the order to display filter
INACTION_REASON_VALUE_SET_ID DOUBLE N The reason for not performing the expected action.
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 - BR_DATAMART_FILTER


Child Column in BR_DATAMART_FILTER(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_CATEGORY_ID BR_DATAMART_CATEGORY BR_DATAMART_CATEGORY_ID
EXPECTED_ACTION_VALUE_SET_ID BR_DATAM_VAL_SET BR_DATAM_VAL_SET_ID
INACTION_REASON_VALUE_SET_ID BR_DATAM_VAL_SET BR_DATAM_VAL_SET_ID




Parent Column in BR_DATAMART_FILTER (PK) Child Table Name Child Column Name
Children: BR_DATAMART_FILTER_ID BR_DATAMART_DEFAULT BR_DATAMART_FILTER_ID
BR_DATAMART_FILTER_DETAIL BR_DATAMART_FILTER_ID
BR_DATAMART_REPORT_FILTER_R BR_DATAMART_FILTER_ID
BR_DATAMART_TEXT BR_DATAMART_FILTER_ID
BR_DATAMART_VALUE BR_DATAMART_FILTER_ID


BR_DATAMART_FILTER_CATEGORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Filter Category
Definition: table to store filter categories
Table Type: REFERENCE





Column Detail - BR_DATAMART_FILTER_CATEGORY


Column Name Type Null? Definition
BR_DATAMART_FILTER_CATEGORY_ID DOUBLE N Unique id for each filter category
CODESET DOUBLE N Code set codeset number based on filter_category_type_mean (facility=220,encounter type=71,etc..)
FILTER_CATEGORY_MEAN VARCHAR(30) N unique string for filter category
FILTER_CATEGORY_TYPE_MEAN VARCHAR(30) N unique string for each type of filter category
SCRIPT_NAME VARCHAR(30) Y The script that is called to retrieve a list of custom filter values.
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 - BR_DATAMART_FILTER_CATEGORY




Parent Column in BR_DATAMART_FILTER_CATEGORY (PK) Child Table Name Child Column Name
Children: BR_DATAMART_FILTER_CATEGORY_ID BR_DATAM_MAPPING_TYPE BR_DATAMART_FILTER_CATEGORY_ID


BR_DATAMART_FILTER_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Filter Detail
Definition: stores additional data for a filter
Table Type: REFERENCE





Column Detail - BR_DATAMART_FILTER_DETAIL


Column Name Type Null? Definition
BR_DATAMART_FILTER_DETAIL_ID DOUBLE N Unique ID for the table
BR_DATAMART_FILTER_ID DOUBLE N unique_id from br_datamart_filter table
OE_FIELD_MEANING VARCHAR(25) Y unique meaning from oe_field_meaning table
REQUIRED_IND DOUBLE Y indicates optional or required for the detail
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 - BR_DATAMART_FILTER_DETAIL


Child Column in BR_DATAMART_FILTER_DETAIL(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_FILTER_ID BR_DATAMART_FILTER BR_DATAMART_FILTER_ID


BR_DATAMART_FLEX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Flex
Definition: Stores flexing options for datamart values contained on br_datamart_values.
Table Type: REFERENCE





Column Detail - BR_DATAMART_FLEX


Column Name Type Null? Definition
BR_DATAMART_FLEX_ID DOUBLE N Unique, generated number that identifies a single row on the BR_DATAMART_FLEX table.
GROUPER_FLEX_ID DOUBLE N Used when a set of Flex rows need grouped together. The first row in the group will have a 0 in this column.
GROUPER_IND DOUBLE N Indicates if this row is part of a group.
PARENT_ENTITY_ID DOUBLE N Foreign key to a table designated by parent_entity_name
PARENT_ENTITY_NAME VARCHAR(32) N The table for the value that is being flexed.
PARENT_ENTITY_TYPE_FLAG DOUBLE N In the case where parent_entity_name is CODE_VALUE, indicates which type is really being flexed.
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 - BR_DATAMART_FLEX


Child Column in BR_DATAMART_FLEX(FK) Parent Table Name Parent Column Name
Parents: GROUPER_FLEX_ID BR_DATAMART_FLEX BR_DATAMART_FLEX_ID




Parent Column in BR_DATAMART_FLEX (PK) Child Table Name Child Column Name
Children: BR_DATAMART_FLEX_ID BR_DATAMART_FLEX GROUPER_FLEX_ID


BR_DATAMART_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Report
Definition: table to store lighthouse reports
Table Type: REFERENCE





Column Detail - BR_DATAMART_REPORT


Column Name Type Null? Definition
BASELINE_VALUE VARCHAR(20) Y Baseline Value COLUMN
BR_DATAMART_CATEGORY_ID DOUBLE N id from br_datamart_category
BR_DATAMART_REPORT_ID DOUBLE N unique id for each report
COND_REPORT_MEAN VARCHAR(30) Y Used to link 2 reports that will have some of the same settings
LIGHTHOUSE_VALUE VARCHAR(20) Y Lighthouse Value column
MPAGE_ADD_LABEL_IND DOUBLE N mPage add label indicator column
MPAGE_DATE_FORMAT_IND DOUBLE N Indicator to set up the MPage date format parameters. 1-this report should set up the date format, 0-this report does not use the date format.
MPAGE_DEFAULT_IND DOUBLE N Indicates whether the MPage components for the page, when opened for the first time, should be defaulted to ON or OFF.
MPAGE_EXP_COLLAPSE_IND DOUBLE N Indicator to setup Mpage component parameters
MPAGE_LABEL_IND DOUBLE N Indicator to setup Mpage component parameters
MPAGE_LINK_IND DOUBLE N Indicator to setup Mpage component parameters
MPAGE_LOOKBACK_IND DOUBLE N Indicator to setup Mpage component parameters
MPAGE_MAX_RESULTS_IND DOUBLE N Indicator to setup Mpage component parameters
MPAGE_NBR_LABEL_IND DOUBLE N Indicator to setup Mpage component parameters
MPAGE_POS_FLAG DOUBLE N Used to determine if an Mpage component will be left, right, center - 0=center 1=left 2=right
MPAGE_POS_SEQ DOUBLE N Used to determine the display order of Mpage components
MPAGE_SCROLL_IND DOUBLE N Indicator to setup Mpage component parameters
MPAGE_TRUNCATE_IND DOUBLE N Indicator to setup Mpage component parameters
REPORT_MEAN VARCHAR(30) N unique string for a report
REPORT_NAME VARCHAR(200) N report display name
REPORT_SEQ DOUBLE N number to indicate the order to display reports
TARGET_VALUE VARCHAR(20) Y Target Value column
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 - BR_DATAMART_REPORT


Child Column in BR_DATAMART_REPORT(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_CATEGORY_ID BR_DATAMART_CATEGORY BR_DATAMART_CATEGORY_ID




Parent Column in BR_DATAMART_REPORT (PK) Child Table Name Child Column Name
Children: BR_DATAMART_REPORT_ID BR_DATAMART_REPORT_DEFAULT BR_DATAMART_REPORT_ID
BR_DATAM_REPORT_LAYOUT BR_DATAMART_REPORT_ID
BR_SVC_ENTITY_REPORT_RELTN BR_DATAMART_REPORT_ID