Table Detail Report

WH_BR_HCO_LOC_RELTN



Column Section Top of Page


Table-level Detail

Description: WH_BR_HCO_LOC_RELTN
Definition: This table Stores locations associated with an HCO Number.
Table Type: ACTIVITY





Column Detail - WH_BR_HCO_LOC_RELTN


Column Name Type Null? Definition
BR_HCO_ID DOUBLE N The HCO related to this location
BR_HCO_LOC_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the BR_HCO_LOC_RELTN table.
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 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.
LOCATION_CD DOUBLE N The location associated with this Healthcare Organization.
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 user that performs the insert or update to the record


WH_BR_NAME_VALUE



Column Section Top of Page


Table-level Detail

Description: WH_BR_NAME_VALUE
Definition: This table stores reusable name/value pairs
Table Type: ACTIVITY





Column Detail - WH_BR_NAME_VALUE


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
BR_NAME VARCHAR(50) Y the NAME portion of the name/value pair
BR_NAME_VALUE_ID DOUBLE N Unique identifer for the table
BR_NV_KEY1 VARCHAR(50) Y identifies the type of name/value pair on this table
BR_VALUE VARCHAR(100) Y the VALUE portion of the name/value pair
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 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.
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_PQRS_MEAS



Column Section Top of Page


Table-level Detail

Description: WH_BR_PQRS_MEAS
Definition: This table indicates measures that eligible providers can select to submit to CMS.
Table Type: ACTIVITY





Column Detail - WH_BR_PQRS_MEAS


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_PQRS_MEAS_ID DOUBLE N Unique generated number that identifies a single row on the br_pqrs_meas table.
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 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.
MEAS_DISPLAY VARCHAR(500) Y The verbiage that is displayed for the PQRS measure.
MEAS_NUMBER_IDENT VARCHAR(50) Y Measure number (used for PQRS only).
PILOT_CORE_IND DOUBLE Y Indicates if this is a core measure for the pilot.
PILOT_ELIGIBLE_IND DOUBLE Y Indicates if this measure is eligible for the pilot.
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.


WH_BR_PQRS_MEAS_PROV_RELTN



Column Section Top of Page


Table-level Detail

Description: WH_BR_PQRS_MEAS_PROV_RELTN
Definition: This table stores the selected measures for the Eligible Providers which will be submitted to CMS.
Table Type: ACTIVITY





Column Detail - WH_BR_PQRS_MEAS_PROV_RELTN


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 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 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 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.
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 Y Indicates if this has been selected for the EHR incentive pilot.
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.


WH_BR_PRSNL_CCN_RELTN



Column Section Top of Page


Table-level Detail

Description: WH_BR_PRSNL_CCN_RELTN
Definition: This table Stores a group of personnel that are associated to a particular CCN.
Table Type: ACTIVITY





Column Detail - WH_BR_PRSNL_CCN_RELTN


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_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 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 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.
PRSNL_GROUP_RELTN_ID DOUBLE N The Personnel Group that this personnel for this CCN is part of.
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 user that performs the insert or update to the record