Table Detail Report

WH_BR_PRSNL_ELIG_PROV_GPR_R



Column Section Top of Page


Table-level Detail

Description: WH_BR_PRSNL_ELIG_PROV_GPR_R
Definition: This table Stores a group of personnel that are associated to a particular Eligible Provider Group.
Table Type: ACTIVITY





Column Detail - WH_BR_PRSNL_ELIG_PROV_GPR_R


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_GROUP_ID DOUBLE N The group that is related to this personnel.
BR_PRSNL_ELIG_PROV_GRP_R_ID DOUBLE N Unique, generated number that identifies a single row on the BR_PRSNL_ELIG_PROV_GRP_R 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 fis related to.
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_SVC_ENT_REPORT_RELTN



Column Section Top of Page


Table-level Detail

Description: WH_BR_SVC_ENT_REPORT_RELTN
Definition: This table Stores the relationship between either a CCN or Eligible Provider to a functional measure.
Table Type: ACTIVITY





Column Detail - WH_BR_SVC_ENT_REPORT_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_DATAMART_REPORT_ID DOUBLE N The functional measure that is being related.
BR_SVC_ENTITY_REPORT_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the BR_SVC_ENTITY_REPORT_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_SVC_ENTITY_REPORT_R_ID DOUBLE N Used for versioning. Contains the value of the PK for a particular set of rows in the table
PARENT_ENTITY_ID DOUBLE N The id of the related CCN or Eligible Provider.
PARENT_ENTITY_NAME VARCHAR(32) Y Indicates if the related object is a CCN or an Eligible Provider.
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(50) 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_LH_CQM_DOMAIN



Column Section Top of Page


Table-level Detail

Description: WH_LH_CQM_DOMAIN
Definition: This table stores domain information for the measures
Table Type: ACTIVITY





Column Detail - WH_LH_CQM_DOMAIN


Column Name Type Null? Definition
DOMAIN_MEANING VARCHAR(12) Y A description of the domain
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.
LH_CQM_DOMAIN_ID DOUBLE N Unique generated number that identifies a single row on the LH_CQM_DOMAIN table.
LH_CQM_DOMAIN_NAME VARCHAR(100) Y The display string for the domain.
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_SOURCE VARCHAR(50) Y The ETL process that updated the record
UPDT_TASK VARCHAR(50) 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_LH_CQM_MEAS



Column Section Top of Page


Table-level Detail

Description: WH_LH_CQM_MEAS
Definition: This table Comtains the defined measures for the program.
Table Type: ACTIVITY





Column Detail - WH_LH_CQM_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.
EXTRACT_DT_TM DATETIME Y The date and time ETL extract was 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 id that identifies health system
HEALTH_SYSTEM_SOURCE_ID DOUBLE N The id that identifies health system source
HIGH_PRIORITY_IND DOUBLE Y The indicator for high priority column
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_CQM_DOMAIN_ID DOUBLE N Unique generated number that identifies a single row on the LH_CQM_MEAS table.
LH_CQM_MEAS_ID DOUBLE N The CQM domain that this measure pertains to.
MEASURE_SHORT_DESC VARCHAR(40) Y The short description of the measure, giving the client additional details about the measure.
MEAS_DESC VARCHAR(1000) Y The display string for the measure.
MEAS_IDENT VARCHAR(50) Y Identifier provided by Content.
OUTCOME_IND DOUBLE Y The indicator for outcome column
POPULATION_CATEGORY_TXT VARCHAR(100) Y The population that is affected by this measure.
SVC_ENTITY_TYPE_FLAG DOUBLE Y The type of service entity that this measure pertains to.
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_SOURCE VARCHAR(50) Y The ETL update user information
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_LH_CQM_MEAS_SVC_ENTITY_R



Column Section Top of Page


Table-level Detail

Description: WH_LH_CQM_MEAS_SVC_ENTITY_R
Definition: This table stores the relationship between measures and providers
Table Type: ACTIVITY





Column Detail - WH_LH_CQM_MEAS_SVC_ENTITY_R


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.
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 in which an ETL extract was 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 id that identifies health system
HEALTH_SYSTEM_SOURCE_ID DOUBLE N The id that identifies health system source
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_CQM_MEAS_ID DOUBLE N The measure that is being related to this service entity.
LH_CQM_MEAS_SVC_ENTITY_R_ID DOUBLE N Unique generated number that identifies a single row on the LH_CQM_MEAS_SVC_ENTITY_R table.
ORIG_LH_CQM_MEAS_SVCENT_R_ID DOUBLE N Used for versioning. Contains the value of the PK for a particular set of rows in LH_CQM_MEAS_SVC_ENTITY_R.
PARENT_ENTITY_ID DOUBLE N Identifies the Eligible Provider or Hospital that is being related to this measure.
PARENT_ENTITY_NAME VARCHAR(32) Y A pointer to the table that holds the service entity being related to this measure.
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_SOURCE VARCHAR(50) Y The ETL update process source
UPDT_TASK VARCHAR(50) 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.