dbo.SXARCMEDITransactionControl 
Default Table Name  SXARCMEDITransactionControl 
Definition  Stores configuration for electronic claims 

dbo.SXARCMEDITransactionControl 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. 
EDITransactionControlID(PK)    int  NO  Auto generated unique primary key value. 
EDITransactionControlName    nvarchar(100)  NO  It is Name of EDITransactionControl , unique index on this field 
EDITransactionControlDescription    nvarchar(300)  YES  Description of Transaction Control. 
ClaimFormatID(FK)    int  NO  A foreign key to the ClaimFormatID column in the SXARCMClaimFormat table. 
EDITransactionControlAbbreviation    nvarchar(15)  YES  It is a unique key and can be null also. 
DataElementSeparator    char(1)  NO  Default *(Accept special character only) 
ComponentElementSeparator    char(1)  NO  Default :(Accept special character only) 
SegmentTerminator    char(1)  NO  Default ~(Accept special character only) 
EDIFileName    varchar(100)  NO  Enter a unique name for the file 
IsFinancialEntityAbbreviationUsed    bit  NO  DE-CB. Check to attach the Financial Entity Abbreviation to the end of the Prefix. 
IsLineFeedSupressed    bit  NO  DE-CB , flag to check for line feed suppressed or not 
MaxClaimOnFile    int  YES  DE-NU. Enter a 1- to 4-digit number for the maximum number of claims to be placed on a file 
EDICharacterSetId(FK)    int  NO  A foreign key to the EDICharacterSetID column in the SXARCMEDICharacterSet table. 
CharacterToReplaceWithSpaces    varchar(50)  YES  List any Character 
ISA02AuthorizationInformation    char(10)  YES  Authorization information from EDI Dictionary for ISA02 element of EDI message 
ISA04SecurityInformation    char(10)  YES  Security information for ISA04 element of EDI message 
ISA06InterchangeSender    char(15)  NO  Interchange sender for ISA06 element of EDI message 
ISA08InterchangeReceiver    char(15)  NO  Interchange receiver for ISA08 element of EDI message 
GS02ApplicationSendersCode    varchar(15)  NO  ApplicationSendersCode for GS02 element of EDI message 
GS03ApplicationReceiversCode    varchar(15)  NO  Application receiver Code for GS03 element of EDI message 
NM103SubmitterLastNameOrOrganizationName    varchar(60)  NO  PHI: Submitter Last Name Or OrganizationName for NM103 element of EDI message 
NM10SubmitterNameFirst    varchar(35)  YES  PHI: SubmitterNameFirst for NM10 element of EDI message 
NM105SubmitterNameMiddle    varchar(25)  YES  PHI: SubmitterName Middle for NM105 element of EDI message 
NM109SubmitterIdentification    varchar(80)  NO  PHI: SubmitterIdentification for NM109 element of EDI message 
PER02ContactName    varchar(80)  YES  PHI: ContactName for PER02 element of EDI message 
PER04CommunicationNumber    varchar(256)  NO  PHI: CommunicationNumber for PER04 element of EDI message 
PER06CommunicationNumber    varchar(80)  YES  PHI: CommunicationNumber for PER06 element of EDI message 
PER08CommunicationNumber    varchar(80)  YES  PHI: CommunicationNumber for PER08 element of EDI message 
NM103ReceiverName    varchar(60)  YES  PHI: ReceiverName for NM103 element of EDI message 
NM109ReceiverIdentification    varchar(80)  NO  PHI: ReceiverIdentification for NM109 element of EDI message 
TargetURI    varchar(512)  YES  EDI Transaction Control target URI information like Payer Path 
ISA01AuthorizationInformationQualifierValue    char(2)  NO  XA Dictionary Name:Authorization Information Qualifier 
ISA03SecurityInformationQualifierValue    char(2)  NO  XA Dictionary Name:Security Information Qualifier 
ISA05InterchangeQualifierValue    char(2)  NO  XA Dictionary Name:Interchange ID Qualifier 
ISA07InterchangeIDQualifierValue    char(2)  NO  XA Dictionary Name:Interchange ID Qualifier 
ISA12InterchangeControlVersionValue    char(5)  NO  XA Dictionary Name: Interchange Control Version 
ISA14AcknowledgementRequestedValue    char(1)  NO  XA Dictionary Name:Acknowledgement Requested 
ISA15UsageIndicatorValue    char(1)  NO  Suggest Dictionary Name :SXARCMUsageIndicator 
GS01FunctionalIdentifierCodeValue    char(2)  NO  Suggest Dictionary Name:SXARCMFunctionalIdentifierCode 
GS08VersionReleaseIndustryIdentifierCodeValue    char(12)  NO  New System Dictionary Name:Version/Release/Industry Identifier Code 
BHT01HierarchicalStructureCodeValue    char(4)  NO  XA Dictionary Name:Hierarchical Structure Code 
BHT02TransactionSetPurposeCodeValue    char(2)  NO  XA Dictionary Name:Transaction Set Purpose Code 
BHT06TransactionTypeCodeValue    char(2)  NO  XA Dictionary Name:Transaction Type Code 
NM101SubmitterEntityIdentifierCodeValue    char(2)  NO  XA Dictionary Name:Entity Identifier Code 
NM102SubmitterEntityTypeQualifierValue    char(1)  NO  XA Dictionary Name:Entity Type Qualifier 
PER03CommunicationNumberQualifierValue    char(2)  NO  PHI: XA Dictionary Name:Contact Function Code 
PER05CommunicationNumberQualifierValue    char(2)  YES  PHI: XA Dictionary Name:Contact Function Code 
PER07CommunicationNumberQualifierValue    char(2)  YES  PHI: XA Dictionary Name:Contact Function Code 
NM101ReceiverEntityIdentifierCodeValue    char(2)  NO  XA Dictionary Name:Entity Identifier Code 
NM102ReceiverEntityTypeQualifierValue    char(1)  NO  XA Dictionary Name:Entity Type Qualifier 
NM108ReceiverIdentificationCodeQualifierValue    char(2)  NO  PHI: XA Dictionary Name:Identification Code Qualifier 
ST03ImplementationConvRef    varchar(35)  YES  ST03 Field Name 
NM108IdentificationCodeQualifierValue    char(2)  NO  XA Dictionary Name:Identification Code Qualifier 
PER01ContactFunctionCodeValue    char(2)  NO  Per01 Contact code value 
ISA16ElementSeparator    char(1)  NO  Flag to idetify ISA16 Element Separator 
ISA11RepetitionSeparatorValue    char(1)  NO  Repetition serperator value 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsISA08InterchangeReceiverID276Usage    bit  NO  Use override value for ISA08InterchangeReceiverID in 276 requests 
ISA08InterchangeReceiverID276Value    nvarchar(50)  YES  Value to use for ISA08InterchangeReceiverID in 276 requests 
IsGS01FunctionalIdentifierCode276Usage    bit  NO  Use override value for GS01FunctionalIdentifierCode in 276 requests 
GS01FunctionalIdentifierCode276Value    nvarchar(50)  NO  Value to use for GS01FunctionalIdentifierCode in 276 requests 
IsGS03ApplicationReceiversCode276Usage    bit  NO  Use override value for GS03ApplicationReceiversCode in 276 requests 
GS03ApplicationReceiversCode276Value    nvarchar(50)  YES  Value to use for GS03ApplicationReceiversCode in 276 requests 
IsGS08VersionReleaseIndustryIdentifierCode276Usage    bit  NO  Use override value for GS08VersionReleaseIndustryIdentifierCode in 276 requests 
GS08VersionReleaseIndustryIdentifierCode276Value    nvarchar(50)  NO  Value to use for GS08VersionReleaseIndustryIdentifierCode in 276 requests 
IsST01TransactionSetIdentifierCode276Usage    bit  NO  Use override value for ST01TransactionSetIdentifierCode in 276 requests 
ST01TransactionSetIdentifierCode276Value    nvarchar(50)  NO  Value to use for ST01TransactionSetIdentifierCode in 276 requests 
IsST03ImplementationConventionReference276Usage    bit  NO  Use override value for ST03ImplementationConventionReference in 276 requests 
ST03ImplementationConventionReference276Value    nvarchar(50)  NO  Value to use for ST03ImplementationConventionReference in 276 requests 
IsAlwaysSendPatientLoop276Value    bit  NO  Whether or not to Always Send Patient Loop in 276 requests 

dbo.SXARCMEDITransactionControl Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMEDITransactionControlPK  PrimaryKey  EDITransactionControlID