Table Detail Report

WH_BR_DATAMART_REPORT



Column Section Top of Page


Table-level Detail

Description: WH_BR_DATAMART_REPORT
Definition: This table stores lighthouse reports
Table Type: ACTIVITY





Column Detail - WH_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 identifier for report
COND_REPORT_MEAN VARCHAR(30) Y Used to link 2 reports that will have some of the same settings
EXTRACT_DT_TM DATETIME Y The date and time for which ETL extract was run
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE N The id that identifies health system
HEALTH_SYSTEM_SOURCE_ID DOUBLE N The id that identifies health system source
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LIGHTHOUSE_VALUE VARCHAR(20) Y Lighthouse value column
MPAGE_ADD_LABEL_IND DOUBLE Y mPage add label indicator column
MPAGE_DATE_FORMAT_IND DOUBLE Y 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 Y 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 Y Indicator to setup mpage component parameters
MPAGE_LABEL_IND DOUBLE Y Indicator to setup mpage component parameters
MPAGE_LINK_IND DOUBLE Y Indicator to setup mpage component parameters
MPAGE_LOOKBACK_IND DOUBLE Y Indicator to setup mpage component parameters
MPAGE_MAX_RESULTS_IND DOUBLE Y Indicator to setup mpage component parameters
MPAGE_NBR_LABEL_IND DOUBLE Y Indicator to setup mpage component parameters
MPAGE_POS_FLAG DOUBLE Y Used to determine if a mpage component will be left, right, center - 0=center 1=left 2=right
MPAGE_POS_SEQ DOUBLE Y Used to determine the display order of mpage components
MPAGE_SCROLL_IND DOUBLE Y Indicator to setup mpage component parameters
MPAGE_TRUNCATE_IND DOUBLE Y Indicator to setup mpage component parameters
REPORT_MEAN VARCHAR(30) Y report display mean
REPORT_NAME VARCHAR(200) Y report display name
REPORT_SEQ DOUBLE Y number to indicate the order to display reports
TARGET_VALUE VARCHAR(20) Y Targe value column
UPDT_DT_TM DATETIME Y 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_TASK VARCHAR(40) Y 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.
UPDT_USER VARCHAR(40) Y The user that updated the record


WH_BR_DATAMART_VALUE



Column Section Top of Page


Table-level Detail

Description: WH_BR_DATAMART_VALUE
Definition: This table stores results for values
Table Type: ACTIVITY





Column Detail - WH_BR_DATAMART_VALUE


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME Y 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 Y 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.
EXTRACT_DT_TM DATETIME Y The date and time for which an Etl extractr wa srun
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
FREETEXT_DESC VARCHAR(255) Y string for freetext results
GROUP_SEQ DOUBLE Y Link results at a parent level
HEALTH_SYSTEM_ID DOUBLE N The id that identifies health system source
HEALTH_SYSTEM_SOURCE_ID DOUBLE N The id that identifies health system
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
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 a mpage setup parameter
MPAGE_PARAM_VALUE VARCHAR(255) Y Default value for a mpage setup parameter
PARENT_ENTITY_ID DOUBLE Y Unique id of the result
PARENT_ENTITY_ID2 DOUBLE Y Unique id of the result
PARENT_ENTITY_NAME VARCHAR(50) Y string to indicate type of result
PARENT_ENTITY_NAME2 VARCHAR(50) Y Unique meaning for a mpage setup parameter
QUALIFIER_FLAG DOUBLE Y flag for using results (equal to, not equal to, greater than)
UPDT_DT_TM DATETIME Y 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_TASK VARCHAR(40) Y 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.
UPDT_USER VARCHAR(40) Y The user that updated the record
VALUE_DT_TM DATETIME Y date/time for a date result
VALUE_SEQ DOUBLE Y Sequence for values
VALUE_TYPE_FLAG DOUBLE Y flag for type of result (numeric,freetext,alpha)


WH_BR_DELETE_HIST



Column Section Top of Page


Table-level Detail

Description: WH_BR_DELETE_HIST
Definition: This table Stores the primary keys of items that have been deleted. This is for Lighthouse Reporting.
Table Type: ACTIVITY





Column Detail - WH_BR_DELETE_HIST


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
BR_DELETE_HIST_ID DOUBLE N Unique, generated number that identifies a single row on the BR_DELETE_HIST table.
CREATE_DT_TM DATETIME Y The date that this row was created.
EXTRACT_DT_TM DATETIME Y The date and time for which extracts were run.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE N The unique identifier that identifies a client health system source id
HEALTH_SYSTEM_SOURCE_ID DOUBLE N The unique identifier that identifies a client health system id
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
PARENT_ENTITY_ID DOUBLE N The primary key that was deleted.
PARENT_ENTITY_NAME VARCHAR(32) Y The table that the primary key being deleted was from.
UPDT_CNT DOUBLE Y 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 Y 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 VARCHAR(50) Y 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.


WH_BR_ELIGIBLE_PROVIDER



Column Section Top of Page


Table-level Detail

Description: WH_BR_ELIGIBLE_PROVIDER
Definition: This table Store eligible providers, which are the subset of providers at the health system that are eligible for reimbursement from CMS (Centers for Medicare and Medicaid Services).
Table Type: ACTIVITY





Column Detail - WH_BR_ELIGIBLE_PROVIDER


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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_ELIGIBLE_PROVIDER_ID DOUBLE N Unique, generated number that identifies a single row on the BR_ELIGIBLE_PROVIDER table.
END_EFFECTIVE_DT_TM DATETIME Y 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.
ERX_SUBMISSION_IND DOUBLE Y Indicates if the provider is eligible for using eRx submissions.
EXTRACT_DT_TM DATETIME Y The date and time for which extracts were run.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_PLAN_TXT VARCHAR(50) Y Indicates the health system that this provider is eligible to receive reimbursement from. Stores either ""MEDICARE"" or ""MEDICAID"".
HEALTH_PLAN_TXT_DT_TM DATETIME Y Stores the date and time that the health plan text was selected.
HEALTH_SYSTEM_ID DOUBLE N The unique identifier that identifies a client health system id
HEALTH_SYSTEM_SOURCE_ID DOUBLE N The unique identifier that identifies a client health system source id
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
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.
NATIONAL_PROVIDER_NBR_TXT VARCHAR(200) Y Stores the eligible providers's national provider number.
ORIG_BR_ELIGIBLE_PROVIDER_ID DOUBLE N Used for versioning. Contains the value of the PK for a particular set of rows in BR_ELIGIBLE_PROVIDER.
PROVIDER_ID DOUBLE N The eligible Provider.
SPECIALTY_ID DOUBLE N Stores the ID for the eligible providers's specialty from the br_name_value table.
TAX_ID_NBR_TXT VARCHAR(50) Y Stores the eligible providers's tax id number.
UPDT_DT_TM DATETIME Y 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_TASK VARCHAR(40) Y 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.
UPDT_USER VARCHAR(40) Y The user that performs the insert or update to the record


WH_BR_ELIG_PROV_EXTENSION



Column Section Top of Page


Table-level Detail

Description: WH_BR_ELIG_PROV_EXTENSION
Definition: This table Contains attributes of an Eligible Provider that require history to be kept.
Table Type: ACTIVITY





Column Detail - WH_BR_ELIG_PROV_EXTENSION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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_ELIGIBLE_PROVIDER_ID DOUBLE N Identifies the Eligible Provider that is the main source for the data on this table.
BR_ELIG_PROV_EXTENSION_ID DOUBLE N Unique generated number that identifies a single row on the BR_ELIG_PROV_EXTENSION table.
END_EFFECTIVE_DT_TM DATETIME Y 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.
EXTRACT_DT_TM DATETIME Y The date and time for which extracts were run.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE N The unique identifier that identifies a client health system source id
HEALTH_SYSTEM_SOURCE_ID DOUBLE N The unique identifier that identifies a client health system id
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
MEDICAID_STAGE_CD DOUBLE N Stores the stage and year for the Medicaid program enrollment
MEDICARE_YEAR DOUBLE Y The effective year for the Medicare program associated to this Eligible Provider.
ORIG_BR_ELIG_PROV_EXTENSION_ID DOUBLE N The PK value of the Original (Effective) Row for this versioned set
PROGRAM_TYPE_TXT VARCHAR(50) Y Identifies what type of program this Eligible Provider is associated to.
SRC_UPDT_DT_TM DATETIME Y The date and time for which records have been updated on the source side
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 VARCHAR(40) Y 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.
UPDT_USER VARCHAR(40) Y The ETL update user