Table Detail Report

BR_DATAMART_REPORT_DEFAULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: BR_DATAMART_REPORT_DEFAULT
Definition: Stores default data at the report level for the setup of mpages in the bedrock wizard
Table Type: REFERENCE





Column Detail - BR_DATAMART_REPORT_DEFAULT


Column Name Type Null? Definition
BR_DATAMART_REPORT_DEFAULT_ID DOUBLE N Unique id for the row
BR_DATAMART_REPORT_ID DOUBLE N Id from br_datamart_report table
MPAGE_PARAM_MEAN VARCHAR(25) N Unique meaning for an Mpage setup parameter
MPAGE_PARAM_VALUE VARCHAR(255) N Default value for an Mpage setup parameter
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_DEFAULT


Child Column in BR_DATAMART_REPORT_DEFAULT(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_REPORT_ID BR_DATAMART_REPORT BR_DATAMART_REPORT_ID


BR_DATAMART_REPORT_FILTER_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Report Filter R
Definition: Relationships between datamart reports and filters.
Table Type: REFERENCE





Column Detail - BR_DATAMART_REPORT_FILTER_R


Column Name Type Null? Definition
BR_DATAMART_FILTER_ID DOUBLE N ID from BR_DATAMART_FILTER table
BR_DATAMART_REPORT_FILTER_R_ID DOUBLE N Unique ID for each row of the table
BR_DATAMART_REPORT_ID DOUBLE N Value from the BR_datamart_report table
DENOMINATOR_IND DOUBLE N Indicates the type of filter
NUMERATOR_IND DOUBLE N Indicates the type of filter
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_FILTER_R


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


BR_DATAMART_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Text
Definition: table to store text for categories/reports/filter
Table Type: REFERENCE





Column Detail - BR_DATAMART_TEXT


Column Name Type Null? Definition
BR_DATAMART_CATEGORY_ID DOUBLE N id from br_datamart_category
BR_DATAMART_FILTER_ID DOUBLE N Id from br_datamart_filter_id
BR_DATAMART_REPORT_ID DOUBLE N Report ID from BR_datamart_report table
BR_DATAMART_TEXT_ID DOUBLE N unique id for text
TEXT_SEQ DOUBLE Y sequence to display text for categories,reports, and filters
TEXT_TYPE_MEAN VARCHAR(30) N unique string for type of text
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_TEXT


Child Column in BR_DATAMART_TEXT(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_CATEGORY_ID BR_DATAMART_CATEGORY BR_DATAMART_CATEGORY_ID
BR_DATAMART_FILTER_ID BR_DATAMART_FILTER BR_DATAMART_FILTER_ID


BR_DATAMART_VALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Value
Definition: table to store results for report
Table Type: REFERENCE





Column Detail - BR_DATAMART_VALUE


Column Name Type Null? Definition
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.
BR_DATAMART_CATEGORY_ID DOUBLE N Value from br_datamart_category table.
BR_DATAMART_FILTER_ID DOUBLE N ID from br_datamart_filter
BR_DATAMART_FLEX_ID DOUBLE N Indicates how this entity was flexed.
BR_DATAMART_VALUE_ID DOUBLE N Unique id for each value
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.
FREETEXT_DESC VARCHAR(255) N string for free textresults
GROUP_SEQ DOUBLE Y Link results at a parent level
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MAP_DATA_TYPE_CD DOUBLE N The type of mapping that was used to make the match between a Millennium value and a value set item.
MPAGE_PARAM_MEAN VARCHAR(25) Y Unique meaning for an Mpage setup parameter
MPAGE_PARAM_VALUE VARCHAR(255) Y Default value for an Mpage setup parameter
PARENT_ENTITY_ID DOUBLE N Unique id of the result
PARENT_ENTITY_ID2 DOUBLE N Unique id of the result
PARENT_ENTITY_NAME VARCHAR(50) N string to indicate type of result
PARENT_ENTITY_NAME2 VARCHAR(50) N string to indicate type of result
QUALIFIER_FLAG DOUBLE Y flag for using results (equal to, not equal to, greater than)
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.
VALUE_DT_TM DATETIME N date/time for a date result
VALUE_SEQ DOUBLE Y Sequence for values
VALUE_TYPE_FLAG DOUBLE Y flag for type of result (numeric,free-text,alpha)



Relationship Detail - BR_DATAMART_VALUE


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


BR_DATAM_MAPPING_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Datamart Mapping Type
Definition: Records types of items that will be mapped from a predefined set of codified terms to a selected Millennium term. All entries apply only to a filter category mean of MAP. Creating this association is required for Millennium data types that are not captured with an automatic association to a standard vocabulary term. These codified terms are used for e-measure submission.
Table Type: REFERENCE





Column Detail - BR_DATAM_MAPPING_TYPE


Column Name Type Null? Definition
BR_DATAMART_CATEGORY_ID DOUBLE N The topic that is being mapped. The corresponding value id from the BR_DATAMART_CATEGORY table. Along with the filter category id, this is used to retrieve the available mapping types.
BR_DATAMART_FILTER_CATEGORY_ID DOUBLE N The category group that is being mapped. The corresponding value id from the BR_DATAMART_FILTER_CATEGORY table. Along with the category id, this is used to retrieve the available mapping types.
BR_DATAM_MAPPING_TYPE_ID DOUBLE N Unique, generated number that identifies a single row on the BR_DATAM_MAPPING_TYPE table.
DISPLAY_SEQ DOUBLE N The sequence that map data types will be displayed. This sequence is applicable per category and filter category.
MAP_DATA_TYPE_CD DOUBLE N This will be the type of mapping to Millennium values. For example, ORDER, CODE SET, EVENT.
MAP_DATA_TYPE_DISPLAY VARCHAR(100) N The display used for the type of mapping.
MAP_DATA_TYPE_VALUE DOUBLE N The value that further defines the mapping type. For example, a codeset number when codeset is the map type.
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_DATAM_MAPPING_TYPE


Child Column in BR_DATAM_MAPPING_TYPE(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_CATEGORY_ID BR_DATAMART_CATEGORY BR_DATAMART_CATEGORY_ID
BR_DATAMART_FILTER_CATEGORY_ID BR_DATAMART_FILTER_CATEGORY BR_DATAMART_FILTER_CATEGORY_ID