galsoli.blogg.se - Shop pellucid

We store these groups in the ' measure_groups ' table and link them to specific measures through the ' measure_groups_measures' table. Many of the measures in the ' measures ' table are part of a larger group of measures such as HCAHPS or IQIs.

Footnotes are used to make note of information relevant to the record, such as " Ten or less cases reported " or " Incomplete Reporting" etc. Records in the ' entity_values' table can be linked to the ' footnotes' table through the ' footnotes_values' table. An example of an attribute could be bed count, as the amount of beds devoted to a specific unit of a hospital or entity can change regularly. As such, they are stored in their own table, and not kept as identifying/detailed information in the table with the entity itself.

The date_start and date_end are used to define over what time period the data represents.Įvery entity table is linked to it own ' attributes' table. Attributes are pieces of useful information that are stored for an entity that have the potential to change constantly.

This is used to determine what is being measured. T he ' entities ' table is further linked to specific entity tables for hospitals, calculations, geographical regions, etc.

The entity_id links the table the ' entities ' table, which is the master table for all entity types.

This is used to determine which measurement the data represents.

The measure_id links the data to the ' measures ' table, which stores all of our measures.It's key is comprised of measure_id, entity_id, date_start and date_end and must be unique This section will also contain information on the calculations used to determine ranking and statistical significance.Įvery piece of recorded data for pellucid is stored in the ' entity_values' table.

Here you will find a number of pages that elaborate on the entities, the measures reported, and the fields in the various tables. This section is designed to increase the accessibility of the pellucid2 data set.