| Name |
Type
|
Description |
| personid |
VARCHAR(38) GUID |
Unique identifier representing a unique person that may include data from several sources that have been linked. This identifier is the person_id of a HIEBus recordgroup.
|
| measureid |
VARCHAR(38) GUID |
Unique identifier representing the related measure definition that specifies this data resource as a useful event to compute the measure.
|
| measurename |
VARCHAR |
Human readable name to describe the related measure definition.
|
| measurecode |
VARCHAR |
Coded value to describe the related measure definition.
|
| resourceid |
VARCHAR(38) GUID |
The id of a data resource (i.e. Condition, Observation, etc.).
|
| resource |
VARCHAR |
Name of the resource referenced in resourceid (i.e. Condition, Observation, etc.)
|
| code |
VARCHAR |
Denormalized from the data resource specified by resourceid.
|
| codesystem |
VARCHAR |
Denormalized from the data resource specified by resourceid.
|
| date |
TIMESTAMP |
Denormalized from the data resource specified by resourceid.
|
| valuesetname |
VARCHAR |
The value set used to by the measure definition that specifies this data resource.
|
| claimid |
VARCHAR(38) GUID |
Denormalized from the data resource specified by resourceid.
|
| encounterid |
VARCHAR(38) GUID |
Denormalized from the data resource specified by resourceid.
|
| value |
VARCHAR |
Denormalized from the data resource specified by resourceid.
|
| secondvalue |
VARCHAR |
Denormalized from the data resource specified by resourceid.
|
| hedisflag |
BOOLEAN |
True if this data resource meets HEDIS criteria for inclusion in the calculation.
|
| datasource |
VARCHAR |
Denormalized from the data resource specified by resourceid.
|
| caresetting |
VARCHAR |
The care setting computed for the data resource specified by resourceid.
|
| population |
VARCHAR |
The population (i.e. numerator, denominator, denominator-exclusion, initial-population) for the measure which the data resource is related.
|
| impliedduedate |
TIMESTAMP |
If the data resource is related to the numerator population, this column represents the due date for the measure that would be implied based on this event.
|
| isusedinpopulation |
BOOLEAN |
Several evaluated resources can be present in this table that meet some criteria related to the measure. This column is set to True if this particular data resource drives membership in a particular population (i.e. numerator, denominator, etc.).
|
