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