Patient Procedures
The Patient Procedures table includes columns related to the procedures performed on patients in Oracle Health Immunization Management.
Details
Module: Oracle Health Immunization
Management
Key Columns
Id
Table 3-21 Patient Procedures Columns
| Name | Description |
|---|---|
| Id | Identification number of the procedure |
| Dose Number | First or second dose administered to the registrant |
| Dose ML | Number of milliliters in the dose |
| Manufacturer Name | Name of product manufacturer |
| Product Name | Name of the product |
| Administered On | Date product administered to the patient |
| Administered By | Name of healthcare worker who administered the product |
| Procedure Outcome | Outcome of the procedure |
| Constitution Date | Date product constituted |
| Lot Number | Lot number of the product |
| Lot Expiry Date | Lot expiration date |
| CVX | CVX code |
| MVX | MVX code |
| Disease Name | Name of the disease product used for |
| Ext Administered Date | Date procedure externally administered |
| Vaccine Info Sheet Provided Yes/No | A Yes or No flag that indicates if the registrant received a vaccination information sheet |
| Notes | Notes healthcare worker made about the visit with the patient |
| Waste ML | Amount of product wasted in milliliters |
| Waste Reason | Reason for the waste |
| Administered Route Code | List of value codes for the route used to administer the product |
| Administered Route Type | List of value types for route used to administer the product |
| Injection Site Code | List of value codes for the site where the product was administered |
| Injection Site Type | List of value types for site where the product was administered |
| Not Administered Code | List of value codes for not administered |
| Not Administered Type | List of value types for not administered |
| Procedure Outcome Code | List of value codes for procedure outcome |
| Procedure Outcome Type | List of value types for procedure outcome |
| Procedure Source | Name of the source of the procedure data |
| Product Category Code | List of value codes for product category |
| Product Category Type | List of value types for product category |
| Product Id | Identification number of the product |
| Created By | Identification number of the user who created the record |
| Created On | Date record created |
| Updated By | Identification number of user who last updated the record |
| Updated On | Date record last updated |
| Slot Id | Identification number of the procedure slot |
| Patient Id | Identification number of the patient |
| Days Since Administered | Number of days since this procedure has been administered |
| Dose | First or second dose administered to the patient (Example: Dose 1) |
| Procedure Source Code | Code of the source of the procedure data |
Parent topic: Tables