procedure

The procedure table is related to the Procedure resource that is available via the FHIR API.

The procedure table combines all procedure and service data from all data sources (clinical and claims) for a HIEBus person (recordgroup) into a consolidated structure.

Source Concepts

HIEBus procedures (encounter)
HIEBus claimprocedures (claim)
HIEBus claimservices (claim)

Table Schema

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.
procedureid	VARCHAR(38) GUID	Internal identifier of the HIEBus source row.
code	VARCHAR	Mapped by Rosetta. The primary mapped terminology code determined to represent the procedure. This is the preferred mapped concept determined by the Rosetta Terminology Service.
display	VARCHAR	Mapped by Rosetta. The primary mapped terminology description determined to represent the procedure. This is the preferred mapped concept determined by the Rosetta Terminology Service.
codesystem	VARCHAR	Mapped by Rosetta. The terminology namespace of the code field.
termid	INTEGER	A reference to the original primary term that can be used to show the original code or relate to alternative mappings.
alternatetermids	VARCHAR	A comma delimited list of termids that provide supplemental terms (usually in alternate coding systems) to represent the procedure.
performed	VARCHAR	The date the procedure was documented.
encounterid	VARCHAR(38) GUID	Source encounter, if determined from an encounter-based data source.
claimid	VARCHAR(38) GUID	Source claim, if determined from an claim-based data source.
datasource	VARCHAR	The name of the data source. Commonly determined from the namespace of the source terminology namespace.
total	DECIMAL	Amount paid for the procedure or service.
type	VARCHAR	Mapped by Rosetta. Category or discipline. This is the preferred mapped concept determined by the Rosetta Terminology Service.
typecode	VARCHAR	Mapped by Rosetta. Coded Value. Category or discipline. This is the preferred mapped concept determined by the Rosetta Terminology Service.
typetermid	INTEGER	Reference to HIEBus terminology properties for the procedure.
revenue	VARCHAR	Mapped by Rosetta. Description of the revenue code associated with the procedure. This is the preferred mapped concept determined by the Rosetta Terminology Service.
revenuecode	VARCHAR	Mapped by Rosetta. Coded Value. The revenue code associated with the procedure. This is the preferred mapped concept determined by the Rosetta Terminology Service.
revenuetermid	INTEGER	Reference to HIEBus terminology properties for the procedure.
location	VARCHAR	Mapped by Rosetta. Place of service for the procedure. This is the preferred mapped concept determined by the Rosetta Terminology Service.
locationcode	VARCHAR	Mapped by Rosetta. Coded Value. Place of service for the procedure. This is the preferred mapped concept determined by the Rosetta Terminology Service.
locationtermid	INTEGER	Reference to HIEBus terminology properties for the procedure.
ccscategoryid	VARCHAR	Computed. The identifier of the related CCSR procedure category.
ccsdescription	VARCHAR	Computed. The description of the related CCSR procedure category.
ccsclinicaldomain	VARCHAR	Computed. The clinical domain of the related CCSR procedure category.
primarycaresetting	VARCHAR	Computed. A normalized description of the place of service in which the procedure was recorded. This may be determined from properties of the procedure, or copied from the related encounter or claim.
primarycaresettingreason	VARCHAR	Computed. For traceability, an explanation for the primarycaresetting assignment.
annotations	VARCHAR	Computed. A comma delimited set of strings that represent computed features of the procedure.
lastupdated	TIMESTAMP	System generated timestamp indicating the most recent change to this data row. Used for differential operations. Managed in UTC.

Back to Tables