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
EMAIL 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