- procedure_id
- person_id
- patient_id
- encounter_id
- practitioner_id
- location_id
| Column | Data Type | Description | Terminology |
|---|---|---|---|
| procedure_id | string | Unique identifier for the procedure | - |
| person_id | string | Unique identifier for the person | - |
| member_id | string | Unique identifier for the member | - |
| patient_id | string | Unique identifier for the patient | - |
| encounter_id | string | Unique identifier for the encounter | - |
| practitioner_id | string | Unique identifier for the practitioner | - |
| location_id | string | Unique identifier for the location | - |
| procedure_code | string | Standardized procedure code | CPT, HCPCS, ICD-9-CM, ICD-10-CM |
| procedure_code_type | string | Type of coding system used | cpt, hcpcs, icd-9-cm, icd-10-cm |
| procedure_code_system | string | Coding system identifier | - |
| procedure_code_version | string | Version of the coding system | - |
| procedure_code_display | string | Human-readable description of the procedure | - |
| procedure_date | date | Date when the procedure was performed | - |
| procedure_start_time | timestamp | Start time of the procedure | - |
| procedure_end_time | timestamp | End time of the procedure | - |
| procedure_status | string | Status of the procedure | completed, in-progress, cancelled |
| procedure_type | string | Type of procedure | surgical, diagnostic, therapeutic |
| body_site | string | Anatomical location of the procedure | - |
| laterality | string | Side of the body for the procedure | left, right, bilateral |
| quantity | integer | Quantity of procedures performed | - |
| unit | string | Unit of measurement for quantity | - |
| data_source | string | Source of the procedure data | claims, clinical, ehr |
| source_code | string | Original code from the source system | - |
| normalized_code | string | Standardized/normalized code | - |
| source_system | string | System that provided the procedure data | - |
| source_table | string | Table in the source system | - |
| source_id | string | Identifier from the source system | - |
| ingestion_date | timestamp | Date when the data was ingested | - |