dbo.SXAEDI270FacilityConfiguration 
Default Table Name  SXAEDI270FacilityConfiguration 
Definition  Stores facility configuration for 270 transaction. 

dbo.SXAEDI270FacilityConfiguration 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. 
TouchedWhen    datetime  NO  The date and time that the row was last updated and will be 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. 
CreatedWhen    datetime  NO  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. 
FacilityGUID(PK)    HVCIDdt  NO  Primary key 
ProcessInquiryOption    int  NO  An enumerated type with the following list of possible values: 1 = [ Manual Inquiry Only],2 = [Automated Inquiry For Every New Visit],3 = [Auto Inquiry For Matching New Visit], 
IsDefaultInsurance    bit  NO  Whether or not defaulting Patient/Visit level insurances for inquiry 
DefaultInsuranceNumOfDays    int  NO  Number of days after last inquiry to default patient/visit insurance for new inquiry 
DefaultServiceType    varchar(10)  YES  Stores the code of the service type to default on inquiry. 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsAutoInquiryInVisitUpdateEnabled    bit  NO  Flag indicating if auto inquiry is enabled in visit update, for example, when an insurance is added to an existing visit. 

dbo.SXAEDI270FacilityConfiguration Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAEDI270FacilityConfigurationPK  PrimaryKey  FacilityGUID