dbo.SXARCMCV3Location 
Default Table Name  SXARCMCV3Location 
Definition  This table stores the information about Enterprise locations Details 

dbo.SXARCMCV3Location Columns 
ColumnName  Domain  Datatype  NULL  Definition 
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)  NO  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. 
TouchedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
CreatedBy    varchar(50)  NO  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. 
CreatedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is 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. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
GUID(PK)    numeric(16, 0)  NO  Unique primary key value. 
Code    varchar(160)  YES  Referred it same as CV3Location Table from SCM Database 
LevelCode    varchar(15)  YES  Referred it same as CV3Location Table from SCM Database 
Name    varchar(30)  YES  Referred it same as CV3Location Table from SCM Database 
HL7Code    varchar(65)  YES  Referred it same as CV3Location Table from SCM Database 
LocationFormatChar    char(1)  YES  Referred it same as CV3Location Table from SCM Database 
PrintResultsFlag    bit  NO  Referred it same as CV3Location Table from SCM Database 
PrintOrderSummaryFlag    bit  NO  Referred it same as CV3Location Table from SCM Database 
SignOrderFlag    bit  NO  Referred it same as CV3Location Table from SCM Database 
AckOrderFlag    bit  NO  Referred it same as CV3Location Table from SCM Database 
ConfirmDischargeFlag    bit  NO  Referred it same as CV3Location Table from SCM Database 
ConfirmTransferFlag    bit  NO  Referred it same as CV3Location Table from SCM Database 
ConfirmCancelFlag    bit  NO  Referred it same as CV3Location Table from SCM Database 
UseCareVISIONFlag    bit  NO  Referred it same as CV3Location Table from SCM Database 
IsClientLocation    bit  NO  Referred it same as CV3Location Table from SCM Database 
IsPrintLocation    bit  NO  Referred it same as CV3Location Table from SCM Database 
IsLocationGroup    bit  NO  Referred it same as CV3Location Table from SCM Database 
IsFacility    bit  NO  Referred it same as CV3Location Table from SCM Database 
TypeCode    varchar(30)  YES  Referred it same as CV3Location Table from SCM Database 
HL7TypeCode    varchar(30)  YES  Referred it same as CV3Location Table from SCM Database 
ParentGUID    numeric(16, 0)  YES  Referred it same as CV3Location Table from SCM Database 
FacilityGUID    numeric(16, 0)  YES  Referred it same as CV3Location Table from SCM Database 
LocnGrpGUID    numeric(16, 0)  YES  Referred it same as CV3Location Table from SCM Database 
ClientIDType    varchar(30)  YES  Referred it same as CV3Location Table from SCM Database 
VisitIDType    varchar(30)  YES  Referred it same as CV3Location Table from SCM Database 
IsTemporary    tinyint  YES  Referred it same as CV3Location Table from SCM Database 
HasTemporaryChild    tinyint  YES  Referred it same as CV3Location Table from SCM Database 
TempLocLikeAssignedLoc    tinyint  YES  Referred it same as CV3Location Table from SCM Database 
HasClientLocChild    tinyint  YES  Referred it same as CV3Location Table from SCM Database 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
DefaultOrderSource    varchar(30)  YES  Referred it same as CV3Location Table from SCM Database 
DefaultSessionType    varchar(30)  YES  Referred it same as CV3Location Table from SCM Database 
BedStatus    varchar(30)  YES  Referred it same as CV3Location Table from SCM Database 
UsesAllergyReview    bit  NO  Referred it same as CV3Location Table from SCM Database 
Capacity    smallint  YES  Referred it same as CV3Location Table from SCM Database 
CensusTypeID    int  YES  Referred it same as CV3Location Table from SCM Database 
UseDefaultStatus    bit  NO  Referred it same as CV3Location Table from SCM Database 
AssignedLocationStatusID    int  YES  Referred it same as CV3Location Table from SCM Database 
DischargeLocationStatusID    int  YES  Referred it same as CV3Location Table from SCM Database 
IsSameGenderRequired    bit  NO  Referred it same as CV3Location Table from SCM Database 
ShortName    varchar(10)  YES  Referred it same as CV3Location Table from SCM Database 
DefaultPrivacyStatusGUID    numeric(16, 0)  YES  Referred it same as CV3Location Table from SCM Database 
IsDisplayHealthIssue    bit  NO  Referred it same as CV3Location Table from SCM Database 
UsingResultsAckType    int  NO  Referred it same as CV3Location Table from SCM Database 
IsAbleToEnterResults    bit  NO  Referred it same as CV3Location Table from SCM Database 
ScanIDTypeCode    varchar(30)  YES  Referred it same as CV3Location Table from SCM Database 
DrugAgencyIdentifier    varchar(30)  YES  Referred it same as CV3Location Table from SCM Database 
MedBillingType    int  YES  Referred it same as CV3Location Table from SCM Database 
UseOrderEntryFlag    bit  NO  Referred it same as CV3Location Table from SCM Database 
IsCloseRuleAppliedOnDC    bit  NO  Referred it same as CV3Location Table from SCM Database 
OrderTabDateThisChartType    int  YES  Referred it same as CV3Location Table from SCM Database 
ResultTabDateThisChartType    int  YES  Referred it same as CV3Location Table from SCM Database 
ResultTabDateAllChartsType    int  YES  Referred it same as CV3Location Table from SCM Database 
DocTabDateThisChartType    int  YES  Referred it same as CV3Location Table from SCM Database 
DocTabDateAllChartsType    int  YES  Referred it same as CV3Location Table from SCM Database 
IsDocTabDefaultAllAvailable    bit  NO  Referred it same as CV3Location Table from SCM Database 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXARCMCV3Location Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMCV3LocationPK  PrimaryKey  GUID