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 |