Locations

The Locations table includes columns related to the locations created in Oracle Health Immunization Management.

Details

Module: Oracle Health Immunization Management

Key Columns

Id

Table 3-10 Locations Columns

Name	Description
Id	Identification number of the location
Code	Code for the location
Location Identifier Name	Identification name for the location
Location Identifier Source	Identification name for the source
Location Name	Name of the location
Phone	Phone number for the location
Auto Schedule Yes/No	A Yes or No flag to indicate the ability to automatically schedule a patient
Contact Email	Email to contact someone at the location
Contact Name	Name of the location contact person
Contact Phone	Phone number to reach the contact person at the location
Location Address1	Address line 1
Location Address2	Address line 2
Location Address3	Address line 3
Location Address4	Address line 4
Location City	Name of the city for the location
Location Country Code	Country code for the location
Location Postal Code	Postal code for the location
Location Sub Zone	Sub zone for the location
Location Zone	Zone for the location
Open Days Out	Number of days open for the location
Schedule Days Out	Number of days to schedule appointments ahead
Time Zone	Time zone of location
Active Yes/No	A Yes or No flag that indicates if the location is active or inactive.
Clinical Setting	Identifies if the location is a clinical setting (for example, hospital, Emergency Room, clinic)
Clinical Setting Code	List of value codes for the clinical setting
Clinical Setting Type	List of value types for the clinical setting
Created By	Identification number of the user who created the record
Created On	Date record created
Updated On	Date record last updated
Updated By	Identification number of user who last updated the record
Location Address Key	Address key for the location