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 |