Table Detail Report
BR_PQRS_MEAS_PROVIDER_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Bedrock Physician Quality Reporting System Measure Provider Relation |
Definition: | The selected measures for the Eligible Providers which will be submitted to CMS. |
Table Type: | REFERENCE |
Column Detail - BR_PQRS_MEAS_PROVIDER_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 has selected this measure. |
BR_PQRS_MEAS_ID | DOUBLE | N | The measure selected by this eligible provider. |
BR_PQRS_MEAS_PROVIDER_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the BR_PQRS_MEAS_PROVIDER_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. |
ORIG_BR_PQRS_MEAS_PROV_R_ID | DOUBLE | N | Used for versioning. Contains the value of the PK for a particular set of rows in BR_PQRS_MEAS_PROV_R. |
PILOT_ELIGIBLE_IND | DOUBLE | N | Indicates if this has been selected for the EHR incentive pilot. |
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_PQRS_MEAS_PROVIDER_RELTN
Child Column in BR_PQRS_MEAS_PROVIDER_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BR_ELIGIBLE_PROVIDER_ID | BR_ELIGIBLE_PROVIDER | BR_ELIGIBLE_PROVIDER_ID |
BR_PQRS_MEAS_ID | BR_PQRS_MEAS | BR_PQRS_MEAS_ID | |
ORIG_BR_PQRS_MEAS_PROV_R_ID | BR_PQRS_MEAS_PROVIDER_RELTN | BR_PQRS_MEAS_PROVIDER_RELTN_ID |
Parent Column in BR_PQRS_MEAS_PROVIDER_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BR_PQRS_MEAS_PROVIDER_RELTN_ID | BR_PQRS_MEAS_PROVIDER_RELTN | ORIG_BR_PQRS_MEAS_PROV_R_ID |
BR_PREFS
Column Section | Top of Page |
Table-level Detail
Description: | BR_PREFS |
Definition: | Reference data for preferences. |
Table Type: | REFERENCE |
Column Detail - BR_PREFS
Column Name | Type | Null? | Definition |
---|---|---|---|
BR_NAME | VARCHAR(200) | N | The name for a preference. |
BR_PREFS_ID | DOUBLE | N | The primary key for the BR_PREFS table. |
CODE_LEVEL | VARCHAR(100) | Y | The code level the preference became available. |
DEFAULT_VALUE | VARCHAR(256) | Y | Some preferences have default values to display. This column holds the default value. |
PARENT_PREFS_ID | DOUBLE | N | A group of preferences can be stored under a single preference. This column holds the parent's BR_PREFS_ID. |
PVC_NAME | VARCHAR(100) | N | The pvc_name for a preference. |
TYPE_FLAG | DOUBLE | N | The type of preference. Font size, DLL, row, column, etc. |
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. |
VIEW_NAME | VARCHAR(100) | Y | The view a preference is available for. |
BR_PROPOSED_SRVRES
Column Section | Top of Page |
Table-level Detail
Description: | BEDROCK PROPOSED SERVICE RESOURCE |
Definition: | autobuild for service resource hierarchy |
Table Type: | REFERENCE |
Column Detail - BR_PROPOSED_SRVRES
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_SUBTYPE_CD | DOUBLE | N | Activity subtype associated to the service resource |
ACTIVITY_TYPE_CD | DOUBLE | N | Activity type associated to the service resource |
AUTOMATED_IND | DOUBLE | N | Defined as 1 the automated indicated is defined. |
BR_PROPOSED_SRVRES_ID | DOUBLE | N | Unique identifier for the table |
CATALOG_TYPE_CD | DOUBLE | N | Catalog type associated to the service resource |
DESCRIPTION | VARCHAR(100) | N | Description for the service resource |
DISPLAY | VARCHAR(100) | N | Display for the service resource |
MEANING | VARCHAR(12) | Y | The meaning associated to the proposed service resource. |
PARENT_ID | DOUBLE | N | The br_proposed_srvres_id the service resource is associated to. |
PROPOSED_IND | DOUBLE | N | Defined as 1 the service resource will define in selected. |
SRVRES_LEVEL | DOUBLE | N | 1 = department, 2 = section, 3 = subsection, 4 = bench, instrument or rad exam room |
SRVRES_OPTION_NBR | DOUBLE | N | The option number for the proposed service hierarchy. |
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_PRSNL
Column Section | Top of Page |
Table-level Detail
Description: | BEDROCK PERSONNEL |
Definition: | all bedrock users |
Table Type: | REFERENCE |
Column Detail - BR_PRSNL
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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BR_PRSNL_ID | DOUBLE | N | Unique identifier for the table |
CREATE_DT_TM | DATETIME | N | date/time on which the record was added to the file |
VARCHAR(100) | Y | email address for personnel | |
NAME_FIRST | VARCHAR(200) | Y | personnel first name |
NAME_FULL_FORMATTED | VARCHAR(100) | Y | personnel formatted name |
NAME_LAST | VARCHAR(200) | Y | personnel last name |
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. |
USERNAME | VARCHAR(50) | N | personnel username |
BR_PRSNL_CCN_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Bedrock Personnel CCN Relation |
Definition: | Stores a group of personnel that are associated to a particular CCN. |
Table Type: | REFERENCE |
Column Detail - BR_PRSNL_CCN_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_CCN_ID | DOUBLE | N | The CCN that is associated to this personnel. |
BR_PRSNL_CCN_RELTN_ID | DOUBLE | N | Unique, generated number that identifies a single row on the BR_PRSNL_CCN_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. |
PRSNL_GROUP_RELTN_ID | DOUBLE | N | The Personnel Group that this personnel for this CCN is part of. |
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_PRSNL_CCN_RELTN
Child Column in BR_PRSNL_CCN_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BR_CCN_ID | BR_CCN | BR_CCN_ID |
PRSNL_GROUP_RELTN_ID | PRSNL_GROUP_RELTN | PRSNL_GROUP_RELTN_ID |