Procedures Summary
The Procedures Summary table includes columns related to the summary information on procedures performed in Oracle Health Immunization Management.
Details
Module: Oracle Health Immunization
Management
Key Column
Patient Id
Table 3-23 Procedures Summary Columns
| Name | Description |
|---|---|
| Patient Id | Identification number of the patient |
| Number of procedures | Total number of procedures administered to the patient (COVID and non-COVID procedures) |
| First Procedure Date | First procedure date for the patient, including COVID and non-COVID procedures |
| Last Procedure Date | Last procedure date for the patient, including COVID and non-COVID procedures |
| Gap Procedures in Days | Number of days between the first and last procedures, including COVID and non-COVID procedures |
| Number of Covid Procedures | Total number of COVID procedures that this patient experienced |
| Covid Dose 1 Yes/No | A Yes or No flag that indicates if the patient received the first COVID dose |
| Covid Dose 2 Yes/No | A Yes or No flag that indicates if the patient received the second COVID dose |
| First Covid Procedure Date | Date of first COVID procedure for the patient |
| First Covid Procedure Manufacturer | First COVID procedure manufacturer name |
| First Covid Procedure Outcome | First COVID procedure outcome description |
| First Covid Procedure Outcome Code | First COVID procedure outcome code |
| First Covid Procedure Product | First COVID procedure name |
| Second Covid Procedure Date | Date of second COVID procedure for the patient |
| Second Covid Procedure Outcome | Second COVID procedure outcome description |
| Second Covid Procedure Outcome Code | Second COVID procedure outcome code |
| Last Covid Procedure Date | Date of last COVID-19 procedure for the patient |
| Number Covid Locations | Number of distinct locations where the patient went for COVID procedures |
| Gap Covid Procedures in Days | Number of days between first and last COVID procedures |
| Multiple Covid Procedures Same Day Yes/No | A Yes or No flag that indicates if the patient received multiple COVID procedures on the same day |
| Number of Dates with Covid Procedures | Count of number of distinct days that COVID procedures have been administered to the patient |
| Number of Distinct Vaccines | Number of distinct vaccines administered to the patient |
| Number Locations | Number of distinct locations where the patient had COVID and non-COVID procedures administered |
Parent topic: Tables