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 |