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