Table Detail Report

BR_DTA_SKIP



Column Section Top of Page


Table-level Detail

Description: BEDROCK DTA SKIP
Definition: legacy dta to skip processing
Table Type: REFERENCE





Column Detail - BR_DTA_SKIP


Column Name Type Null? Definition
TASK_ASSAY_CD DOUBLE N dta id
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 date/time on which the record was added to the file
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.


BR_DTA_WORK



Column Section Top of Page


Table-level Detail

Description: BEDROCK DTA WORK
Definition: legacy dtas
Table Type: REFERENCE





Column Detail - BR_DTA_WORK


Column Name Type Null? Definition
ACTIVITY_TYPE VARCHAR(20) Y Activity type for the assay
ALIAS VARCHAR(40) Y Alias for the assay
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DTA_ID DOUBLE N dta id
FACILITY VARCHAR(50) Y Used to identify individual facility data.
LONG_DESC VARCHAR(60) Y Long description for the assay
MATCH_DTA_CD DOUBLE N Used to match on the DTA code value.
ORG_EVENT_CODE VARCHAR(50) Y Will store event code names
RESULT_TYPE VARCHAR(30) Y Result type for the assay
SHORT_DESC VARCHAR(40) Y Short description for the assay.
STATUS_IND DOUBLE N DTA Status Indicator
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.


BR_ELIGIBLE_PROVIDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Eligible Provider
Definition: 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: REFERENCE





Column Detail - BR_ELIGIBLE_PROVIDER


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.
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 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.
ERX_SUBMISSION_IND DOUBLE N Indicates if the provider is eligible for using eRx submissions.
HEALTH_PLAN_TXT VARCHAR(20) N Indicates the health system that this provider is eligible to receive reimbursement from. Stores either "MEDICARE" or "MEDICAID".
HEALTH_PLAN_TXT_DT_TM DATETIME N Stores the date and time that the health plan text was selected.
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) N 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) N Stores the eligible providers's tax id number.
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_ELIGIBLE_PROVIDER


Child Column in BR_ELIGIBLE_PROVIDER(FK) Parent Table Name Parent Column Name
Parents: ORIG_BR_ELIGIBLE_PROVIDER_ID BR_ELIGIBLE_PROVIDER BR_ELIGIBLE_PROVIDER_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PROVIDER_ID PRSNL PERSON_ID




Parent Column in BR_ELIGIBLE_PROVIDER (PK) Child Table Name Child Column Name
Children: BR_ELIGIBLE_PROVIDER_ID BR_CPC_ELIG_PROV_RELTN BR_ELIGIBLE_PROVIDER_ID
BR_ELIGIBLE_PROVIDER ORIG_BR_ELIGIBLE_PROVIDER_ID
BR_ELIG_PROV_EXTENSION BR_ELIGIBLE_PROVIDER_ID
BR_ELIG_PROV_MEAS_RELTN BR_ELIGIBLE_PROVIDER_ID
BR_GPRO_SUB_RELTN BR_ELIGIBLE_PROVIDER_ID
BR_PQRS_MEAS_PROVIDER_RELTN BR_ELIGIBLE_PROVIDER_ID
LH_MU_METRIC_DETAILS BR_ELIGIBLE_PROVIDER_ID


BR_ELIG_PROV_EXTENSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Eligible Provider Extension
Definition: Contains attributes of an Eligible Provider that require history to be kept.
Table Type: REFERENCE





Column Detail - BR_ELIG_PROV_EXTENSION


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.
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 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.
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) N Identifies what type of program this Eligible Provider is associated to.
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_ELIG_PROV_EXTENSION


Child Column in BR_ELIG_PROV_EXTENSION(FK) Parent Table Name Parent Column Name
Parents: BR_ELIGIBLE_PROVIDER_ID BR_ELIGIBLE_PROVIDER BR_ELIGIBLE_PROVIDER_ID
ORIG_BR_ELIG_PROV_EXTENSION_ID BR_ELIG_PROV_EXTENSION BR_ELIG_PROV_EXTENSION_ID




Parent Column in BR_ELIG_PROV_EXTENSION (PK) Child Table Name Child Column Name
Children: BR_ELIG_PROV_EXTENSION_ID BR_ELIG_PROV_EXTENSION ORIG_BR_ELIG_PROV_EXTENSION_ID


BR_ELIG_PROV_MEAS_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Eligible Provider Measure Relation
Definition: Stores the quality measures associated to a chosen eligible provider.
Table Type: REFERENCE





Column Detail - BR_ELIG_PROV_MEAS_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.
BR_ELIGIBLE_PROVIDER_ID DOUBLE N The provider that is being measured.
BR_ELIG_PROV_MEAS_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the BR_ELIG_PROV_MEAS_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.
MEASURE_SEQ DOUBLE N The order in which the quality measures are evaluated when checking for meaningful use measures.
ORIG_BR_ELIG_PROV_MEAS_R_ID DOUBLE N Used for versioning. Contains the value of the PK for a particular set of rows in BR_ELIG_PROV_MEAS_RELTN.
PCA_QUALITY_MEASURE_ID DOUBLE N The Quality Measure being tracked for this provider.
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_ELIG_PROV_MEAS_RELTN


Child Column in BR_ELIG_PROV_MEAS_RELTN(FK) Parent Table Name Parent Column Name
Parents: BR_ELIGIBLE_PROVIDER_ID BR_ELIGIBLE_PROVIDER BR_ELIGIBLE_PROVIDER_ID
ORIG_BR_ELIG_PROV_MEAS_R_ID BR_ELIG_PROV_MEAS_RELTN BR_ELIG_PROV_MEAS_RELTN_ID
PCA_QUALITY_MEASURE_ID PCA_QUALITY_MEASURE PCA_QUALITY_MEASURE_ID




Parent Column in BR_ELIG_PROV_MEAS_RELTN (PK) Child Table Name Child Column Name
Children: BR_ELIG_PROV_MEAS_RELTN_ID BR_ELIG_PROV_MEAS_RELTN ORIG_BR_ELIG_PROV_MEAS_R_ID