procedures.csv
This file contains information on the procedures referenced in the FHIR bundle.
Columns
resource_id
string
The unique resource identifier from the FHIR bundle field procedure.id.
performed_date
date
The date of the procedure, as specified by the FHIR bundle.
encounter_date
date
The admit date of the encounter during which the procedure was documented, as specified by the FHIR bundle.
status_code, status_display, and status_code_system
string
The code, display, and code system of the procedure status as provided by the source.
source_code, source_display, source_code_system, and source_code_text
string
The code, display, code system, and text of the procedure, as provided by the source.
hcpcscode[N] and hcpcsdisplay[N]
string
The code and display of any HCPCS or CPT codes that Orchestrate derived from the source code and uplift. Each pair will be numbered sequentially, e.g., hcpcscode1 and hcpcsdisplay1, hcpcscode2 and hcpcsdisplay2, etc.
snomedcode[N] and snomeddisplay[N]
string
The code and display of any SNOMED codes that Orchestrate derived from the source code and uplift. Each pair will be numbered sequentially, e.g., snomedcode1 and snomeddisplay1, snomedcode2 and snomeddisplay2, etc.
icd10code[N] and icd10display[N]
string
The code and display of any ICD10 codes that Orchestrate derived from the source code and uplift. Each pair will be numbered sequentially, e.g., icd10code1 and icd10display1, icd10code2 and icd10display2, etc.
loinccode[N] and loincdisplay[N]
string
The code and display of any NDC codes that Orchestrate derived from the source code and uplift. Each pair will be numbered sequentially, e.g., loinccode1 and loincdisplay1, loinccode2 and loincdisplay2, etc.
patient_id
string
The patient identifier of the patient for whom the procedure was documented. Uniquely identifies a row in patients.csv.
encounter_id
string
The encounter on which the procedure was documented. Uniquely identifies a row in encounters.csv.
metadata_id
string
Reflects the origin of the data. Uniquely identifies a row in metadata.csv.