dbo.CV3Location 
Default Table Name  CV3Location 
Definition  The location within the care enterprise. May or may not be a client location. Locations may contain other locations. 

dbo.CV3Location Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  YES  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
RepFlags    tinyint  YES  Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. 
Build    int  NO  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    varchar(50)  YES  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    datetime  YES  The date and time that the row was last updated and will be based on the Enterprise time zone. 
CreatedBy    varchar(50)  YES  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    datetime  YES  The date and time that the row was created and will be based on the Enterprise time zone. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
GUID(PK)    HVCIDdt  NO  Unique primary key value. 
Code    varchar(160)  YES  The formatted location hierarchy. 
LevelCode    varchar(15)  YES  The lowest level code within the hierarchy. 
Name    varchar(30)  YES  The Display Name of the location. 
HL7Code    varchar(65)  YES  The HL7 code used to describe the location. 
LocationFormatChar    char(1)  YES  Used to format the location name. 
PrintResultsFlag    bit  NO  If TRUE, indicates that results are printed at this location. 1 = True; 0 = False 
PrintOrderSummaryFlag    bit  NO  If TRUE, indicates that a summary report for orders from this location is printed. 1 = True; 0 = False 
SignOrderFlag    bit  NO  Indicates that this location requires that orders be signed. 1 = True; 0 = False 
AckOrderFlag    bit  NO  Indicates that this location requires changed orders be checked. 1 = True; 0 = False 
ConfirmDischargeFlag    bit  NO  If TRUE, indicates that discharges from this location must be confirmed. 1 = True; 0 = False 
ConfirmTransferFlag    bit  NO  If TRUE, indicates that transfers from this location must be confirmed. 1 = True; 0 = False 
ConfirmCancelFlag    bit  NO  If TRUE, indicates that cancels from this location must be confirmed. 1 = True; 0 = False 
UseCareVISIONFlag    bit  NO  If TRUE, indicates that this location uses Sunrise Clinical Manager. 1 = True; 0 = False 
IsClientLocation    bit  NO  If TRUE, indicates that clients can be admitted to this location. 1 = True; 0 = False 
IsPrintLocation    bit  NO  If TRUE, indicates that reports can be sent to this location. 1 = True; 0 = False 
IsLocationGroup    bit  NO  If TRUE, indicates that this location is a group (for example, Unit or Clinic). 1 = True; 0 = False 
IsFacility    bit  NO  True if this location is a facility. 1 = True; 0 = False 
TypeCode    varchar(30)  YES  Identifies the type of location. 
HL7TypeCode    varchar(30)  YES  The type of location for HL7. 
ParentGUID    HVCIDdt  YES  The link to the parent location. 0 if this location is a facility 
FacilityGUID    HVCIDdt  YES  The link to this location's facility. 
LocnGrpGUID    HVCIDdt  YES  The link to this location's group. 
ClientIDType    varchar(30)  YES  Indicates the client ID type that will be auto-generated for this facility. Applies only to a facility 
VisitIDType    varchar(30)  YES  Indicates the visit ID type that will be auto-generated for this facility. Applies only to a facility 
IsTemporary    tinyint  YES  Indicates if this location can be used as a temporary location. 1 = True; 0 = False 
HasTemporaryChild    tinyint  YES  This is true if at least on child location is a temporary location. 1 = True; 0 = False 
TempLocLikeAssignedLoc    tinyint  YES  Indicates if a certain location group attributes are obtained from a patient's temporary location or from the assigned location. 
HasClientLocChild    tinyint  YES  Indicates whether or not the location has any children which are client locations. 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
DefaultOrderSource    varchar(30)  YES  This column will hold the default order source for every location. 
DefaultSessionType    varchar(30)  YES  This column stores default session type for each Location. 
BedStatus    varchar(30)  YES  Stores empty bed status 
UsesAllergyReview    bit  NO  Does the current location uses Allergy Review feature 
Capacity    smallint  YES  Maximum number of persons allowed in location 
CensusTypeID    int  YES  Census type ID from SXAAMCensusType 
UseDefaultStatus    bit  NO  Specifies if the default statuses AssignLocationStatusID and DischargeLocationStatusID are automatically applied to the Location. 
AssignedLocationStatusID    int  YES  The default StatusID to use when a Visit is assigned to this Location. 
DischargeLocationStatusID    int  YES  The default StatusID to use when a Visit is discharged from this location. 
IsSameGenderRequired    bit  NO  Specifies if all assignments to this location must be of the same gender. 
ShortName    varchar(10)  YES  Short name for the location. 
DefaultPrivacyStatusGUID    HVCIDdt  YES  Specifies the default privacy status for this location which is determined by combining the privacy status of the location and the patient (CV3PrivacyStatus) 
IsDisplayHealthIssue    bit  NO  Indicates to display health issue summary dialog when open order entry summary dialog is accessed. 
UsingResultsAckType    int  NO  An enumerated type with the following list of possible values: 0 = [No Acknowledgement],1 = [Acknowledge All Results],2 = [Acknowledge For Discharged Only], 
IsAbleToEnterResults    bit  NO  Allow the location to manually entered results 
ScanIDTypeCode    varchar(30)  YES  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    varchar(30)  YES  A Facility's Drug Enforcement Agency number 
MedBillingType    int  YES  An enumerated type with the following list of possible values: 0 = [None],1 = [On Admin],2 = [On Dispense], 
UseOrderEntryFlag    bit  NO  Indicates that this location is using electronic order entry. This enables all order entry functions. 
IsCloseRuleAppliedOnDC    bit  NO  Indicates whether the behavior used to discontinue orders for a closed visit should be used for discharged visits. (Default value = 0) 
OrderTabDateThisChartType    int  YES  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    int  YES  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    int  YES  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    int  YES  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    int  YES  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    bit  NO  ‘This Chart’ (0) or ‘All Available’ (1). Default is 0. 
AssignTempId    bit  NO  Store the assigning temporary IDs for a location in a unit. Shown on the Location dialog 
AdHocBedType    tinyint  NO  New field to indicate if the Location is a AdHoc location and if it’s a Active AdHoc location. 
IsSurgeryOperatingRoom    bit  NO  Indicates if the location is a surgery operating room 
IsPracticeLocation    bit  NO  Used to identify whether location is practice location or not 
HideDateOfService    bit  YES  It Will contains 3 values Null, 0, 1. NULL means clinical manager is not in use for particular location. 
HideAuthoredDateTime    bit  YES  For Field HideDateOfService if value is zero then this field will be either 0 or 1 else it will be null. 
PlaceOfServiceID(FK)    int  YES  A foreign key to the PlaceOfServiceID column in the SXAAMPlaceOfService table. 
UnitGUID    HVCIDdt  YES  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    uniqueidentifier  NO  Unique GUID used to support merge replication. 
CanUseACRRadiology    bit  NO  Flag for location to Use ACR Radiology 
IsOffsite    bit  NO  Indicates Location is considered Off Campus for financial purposes. 

dbo.CV3Location Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3LocationPK  PrimaryKey  GUID