SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 

RepFlags 
Definition  Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. 

Build 
Definition  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 

TouchedBy 
Definition  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

TouchedWhen 
Definition  The date and time that the row was last updated and will be based on the Enterprise time zone. 

CreatedBy 
Definition  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

CreatedWhen 
Definition  The date and time that the row was created and will be based on the Enterprise time zone. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

GUID 
Definition  Unique primary key value. 

Code 
Definition  The formatted location hierarchy. 

LevelCode 
Definition  The lowest level code within the hierarchy. 

Name 
Definition  The Display Name of the location. 

HL7Code 
Definition  The HL7 code used to describe the location. 

LocationFormatChar 
Definition  Used to format the location name. 

PrintResultsFlag 
Definition  If TRUE, indicates that results are printed at this location. 1 = True; 0 = False 

PrintOrderSummaryFlag 
Definition  If TRUE, indicates that a summary report for orders from this location is printed. 1 = True; 0 = False 

SignOrderFlag 
Definition  Indicates that this location requires that orders be signed. 1 = True; 0 = False 

AckOrderFlag 
Definition  Indicates that this location requires changed orders be checked. 1 = True; 0 = False 

ConfirmDischargeFlag 
Definition  If TRUE, indicates that discharges from this location must be confirmed. 1 = True; 0 = False 

ConfirmTransferFlag 
Definition  If TRUE, indicates that transfers from this location must be confirmed. 1 = True; 0 = False 

ConfirmCancelFlag 
Definition  If TRUE, indicates that cancels from this location must be confirmed. 1 = True; 0 = False 

UseCareVISIONFlag 
Definition  If TRUE, indicates that this location uses Sunrise Clinical Manager. 1 = True; 0 = False 

IsClientLocation 
Definition  If TRUE, indicates that clients can be admitted to this location. 1 = True; 0 = False 

IsPrintLocation 
Definition  If TRUE, indicates that reports can be sent to this location. 1 = True; 0 = False 

IsLocationGroup 
Definition  If TRUE, indicates that this location is a group (for example, Unit or Clinic). 1 = True; 0 = False 

IsFacility 
Definition  True if this location is a facility. 1 = True; 0 = False 

TypeCode 
Definition  Identifies the type of location. 

HL7TypeCode 
Definition  The type of location for HL7. 

ParentGUID 
Definition  The link to the parent location. 0 if this location is a facility 

FacilityGUID 
Definition  The link to this location's facility. 

LocnGrpGUID 
Definition  The link to this location's group. 

ClientIDType 
Definition  Indicates the client ID type that will be auto-generated for this facility. Applies only to a facility 

VisitIDType 
Definition  Indicates the visit ID type that will be auto-generated for this facility. Applies only to a facility 

IsTemporary 
Definition  Indicates if this location can be used as a temporary location. 1 = True; 0 = False 

HasTemporaryChild 
Definition  This is true if at least on child location is a temporary location. 1 = True; 0 = False 

TempLocLikeAssignedLoc 
Definition  Indicates if a certain location group attributes are obtained from a patient's temporary location or from the assigned location. 

HasClientLocChild 
Definition  Indicates whether or not the location has any children which are client locations. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

DefaultOrderSource 
Definition  This column will hold the default order source for every location. 

DefaultSessionType 
Definition  This column stores default session type for each Location. 

BedStatus 
Definition  Stores empty bed status 

UsesAllergyReview 
Definition  Does the current location uses Allergy Review feature 

Capacity 
Definition  Maximum number of persons allowed in location 

CensusTypeID 
Definition  Census type ID from SXAAMCensusType 

UseDefaultStatus 
Definition  Specifies if the default statuses AssignLocationStatusID and DischargeLocationStatusID are automatically applied to the Location. 

AssignedLocationStatusID 
Definition  The default StatusID to use when a Visit is assigned to this Location. 

DischargeLocationStatusID 
Definition  The default StatusID to use when a Visit is discharged from this location. 

IsSameGenderRequired 
Definition  Specifies if all assignments to this location must be of the same gender. 

ShortName 
Definition  Short name for the location. 

DefaultPrivacyStatusGUID 
Definition  Specifies the default privacy status for this location which is determined by combining the privacy status of the location and the patient (CV3PrivacyStatus) 

IsDisplayHealthIssue 
Definition  Indicates to display health issue summary dialog when open order entry summary dialog is accessed. 

UsingResultsAckType 
Definition  An enumerated type with the following list of possible values: 0 = [No Acknowledgement],1 = [Acknowledge All Results],2 = [Acknowledge For Discharged Only], 

IsAbleToEnterResults 
Definition  Allow the location to manually entered results 

ScanIDTypeCode 
Definition  Identifies the Client ID Type that the facility is using for their patient bar codes. Links to the CV3ClientIDType table. It is possible to have Patient ID Bar codes varying between units. For example, Pediatrics would have a Mother+Baby combination. 

DrugAgencyIdentifier 
Definition  A Facility's Drug Enforcement Agency number 

MedBillingType 
Definition  An enumerated type with the following list of possible values: 0 = [None],1 = [On Admin],2 = [On Dispense], 

UseOrderEntryFlag 
Definition  Indicates that this location is using electronic order entry. This enables all order entry functions. 

IsCloseRuleAppliedOnDC 
Definition  Indicates whether the behavior used to discontinue orders for a closed visit should be used for discharged visits. (Default value = 0) 

OrderTabDateThisChartType 
Definition  Enumerated value that indicates the default Since date for the ‘This Chart’ display type. The enumerated values come from the SinceType enumeration in the CSinceTime header file. 

ResultTabDateThisChartType 
Definition  Enumerated value that indicates the default Since date for the ‘This Chart’ display type. The enumerated values come from the SinceType enumeration in the CSinceTime header file. 

ResultTabDateAllChartsType 
Definition  Enumerated value that indicates the default Since date for the ‘This Chart’ display type. The enumerated values come from the SinceType enumeration in the CSinceTime header file. 

DocTabDateThisChartType 
Definition  Enumerated value that indicates the default Since date for the ‘This Chart’ display type. The enumerated values come from the SinceType enumeration in the CSinceTime header file. 

DocTabDateAllChartsType 
Definition  Enumerated value that indicates the default Since date for the ‘All Charts’ display type. The enumerated values come from the SinceType enumeration in the CSinceTime header file 

IsDocTabDefaultAllAvailable 
Definition  ‘This Chart’ (0) or ‘All Available’ (1). Default is 0. 

AssignTempId 
Definition  Store the assigning temporary IDs for a location in a unit. Shown on the Location dialog 

AdHocBedType 
Definition  New field to indicate if the Location is a AdHoc location and if it’s a Active AdHoc location. 

IsSurgeryOperatingRoom 
Definition  Indicates if the location is a surgery operating room 

IsPracticeLocation 
Definition  Used to identify whether location is practice location or not 

HideDateOfService 
Definition  It Will contains 3 values Null, 0, 1. NULL means clinical manager is not in use for particular location. 

HideAuthoredDateTime 
Definition  For Field HideDateOfService if value is zero then this field will be either 0 or 1 else it will be null. 

PlaceOfServiceID 
Definition  A foreign key to the PlaceOfServiceID column in the SXAAMPlaceOfService table. 

UnitGUID 
Definition  If the location is not a unit, and belongs to a unit, UnitGUID refers to the unit location GUID.
If the location is not a unit, and does not belong to a unit, UnitGUID is null.
If the location is a unit, UnitGUID refers to the location itself. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

CanUseACRRadiology 
Definition  Flag for location to Use ACR Radiology 

IsOffsite 
Definition  Indicates Location is considered Off Campus for financial purposes.