procedure

GUID. An internal 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.

GUID. An internal identifier representing a unique procedure. This identifier is the id of the row in the HIEBus source tables.

Mapped by Rosetta. The prioritized mapped terminology code determined to represent the diagnosis. The default prioritization is by code system: HCPCS, ICD-10-CM, ICD-9-CM. The code sent by data source will be used if no mappings are available.

Mapped by Rosetta. The description associated with the code column.

Mapped by Rosetta. The terminology namespace of the code column.

A HIEBus terminology id. Reference to the original primary term (usually from a data source namespace) received by HIEBus that can be used to show the original code or relate to alternative mappings.

A comma delimited list of termids (usually from a data source namespace) that provides supplemental terms received from the data source to represent the diagnosis.

Mapped by Rosetta. If available, the HCPCS code mapped from the original primary term or alternate terms.

Mapped by Rosetta. If available, the HCPCS description associated with the hcpcscode column.

Mapped by Rosetta. If available, the ICD10 code mapped from the original primary term or alternate terms.

Mapped by Rosetta. If available, the ICD10 description associated with the icd10code column.

Mapped by Rosetta. If available, the ICD9 code mapped from the original primary term or alternate terms.

Mapped by Rosetta. If available, the ICD9 description associated with the icd9code column.

The date the procedure was performed.

GUID. Source encounter, if determined from an encounter-based data source.

GUID. Source claim, if determined from an claim-based data source.

The name of the data source. Commonly determined from the HIEBus record authority name of the source patient record.

The terminology namespace of the original primary term that was sent by the data source.

Amount paid for the procedure or service.

Mapped by Rosetta. Category or discipline. This is the preferred mapped concept determined by the Rosetta Terminology Service.

Mapped by Rosetta. Coded Value. Category or discipline. This is the preferred mapped concept determined by the Rosetta Terminology Service.

Reference to the HIEBus terminology id.

Mapped by Rosetta. Description of the revenue code associated with the procedure. This is the preferred mapped concept determined by the Rosetta Terminology Service.

Mapped by Rosetta. Coded value. Description of the revenue code associated with the procedure. This is the preferred mapped concept determined by the Rosetta Terminology Service.

Reference to the HIEBus terminology id.

Mapped by Rosetta. Place of service for the procedure. This is the preferred mapped concept determined by the Rosetta Terminology Service.

Mapped by Rosetta. Coded value. Place of service for the procedure. This is the preferred mapped concept determined by the Rosetta Terminology Service.

Reference to HIEBus the terminology id.

Computed. The identifier of the related CCSR procedure category.

Computed. The description of the related CCSR procedure category.

Computed. The clinical domain of the related CCSR procedure category.

Computed. A normalized description of the place of service in which the diagnoses was recorded. This property is copied from the related encounter or claim.

Computed. For traceability, an explanation for the primarycaresetting assignment.

Computed. A comma delimited set of strings that represent computed features of the procedure.

System generated timestamp indicating the most recent change to this data row. Used for differential operations. Managed in UTC.