dbo.SXAEDI271Message 
Default Table Name  SXAEDI271Message 
Definition  Stores the 271 messages. 

dbo.SXAEDI271Message 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. 
MessageID(PK)    int  NO  Auto generated unique primary key value. 
Status    char(3)  NO  "REV": received valid message: "ERR": received and rejected 
Message    xml  NO  271 message xml. 
InquiryDtm    datetime  NO  Copied from SXAEDI270Message. 
EligibilityStatus    char(1)  YES  NULL if Status column is "ERR"; "Y"or "N" or "R" if Status column is "REV". "Y" means eligible; "N" means not eligible; "R" means eligibility status under review. 
PatientGUID    numeric(16, 0)  NO  Identifier to the patient in the external patient system. 
InsurancePlanCode    varchar(40)  NO  Code of the insurance plan for this inquiry. 
InquiryReceiverCode    varchar(80)  NO  Copied from SXAEDI270Message. 
InquiryInsuredLastName    varchar(60)  YES  Copied from SXAEDI270Message. 
InquiryInsuredFirstName    varchar(35)  YES  Copied from SXAEDI270Message. 
InquiryInsuredMiddleName    varchar(35)  YES  Copied from SXAEDI270Message. 
InquiryInsuredID    varchar(80)  YES  Copied from SXAEDI270Message. 
InquiryInsuredSerialNum    varchar(50)  YES  Copied from SXAEDI270Message. 
InquiryInsuredGender    char(1)  YES  Copied from SXAEDI270Message. 
InquiryInsuredDOB    varchar(8)  YES  Copied from SXAEDI270Message. 
InquiryInsuredSSN    varchar(9)  YES  Copied from SXAEDI270Message. 
InquiryServiceType    varchar(2)  YES  Copied from SXAEDI270Message. 
InquiryServiceDate    varchar(17)  YES  Copied from SXAEDI270Message. 
InquiryPatientLastName    varchar(60)  YES  Copied from SXAEDI270Message. 
InquiryPatientFirstName    varchar(35)  YES  Copied from SXAEDI270Message. 
InquiryPatientMiddleName    varchar(35)  YES  Copied from SXAEDI270Message. 
InquiryPatientDOB    varchar(8)  YES  Copied from SXAEDI270Message. 
InquiryPatientGender    char(1)  YES  Copied from SXAEDI270Message. 
InquiryPatientAddress    varchar(55)  YES  Copied from SXAEDI270Message. 
InquiryPatientCity    varchar(35)  YES  Copied from SXAEDI270Message. 
InquiryPatientState    char(2)  YES  Copied from SXAEDI270Message. 
InquiryPatientZip    varchar(15)  YES  Copied from SXAEDI270Message. 
InquiryPatientCountry    varchar(3)  YES  Copied from SXAEDI270Message. 
CarrierName    varchar(30)  YES  Name of the carrier for this inquiry (from the external patient system). 
InsurancePlanName    varchar(40)  YES  Name of the insurance plan for the inquiry (from the external patient system). 
InquiryFacility    varchar(40)  YES  Code of the facility when the inquiry is sent out (from the external patient system) 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXAEDI271Message Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAEDI271MessagePK  PrimaryKey  MessageID