We do not recommend Access.

It has limitations and problems that make it unacceptable for business solutions.  If price is an issue, we recommend the free MySQL software. This is a free, industrial strength Open Source database available at www.MySQL.com

CREATE TABLE edi_claims (

ID INT NOT NULL AUTO_INCREMENT KEY,

ClaimNo varchar (50) NOT NULL ,

HIPAAsuiteID varchar (9) NULL ,

TradingPartnerIDType char (2) NULL ,

TradingPartnerID varchar (15) NOT NULL ,

SubmitterName varchar (35) NULL ,

SubmitterID varchar (30) NULL ,

SubmitterContact varchar (60) NULL ,

SubmitterTel varchar (20) NULL ,

SubmitterTelExt varchar (10) NULL ,

SubmitterFax varchar (20) NULL ,

SubmitterEmail varchar (80) NULL ,

ReceiverName varchar (35) NULL ,

BillProvIDType char (2) NULL ,

BillProvID varchar (80) NULL ,

BillProvLast varchar (35) NULL ,

BillProvFirst varchar (25) NULL ,

BillProvMiddle varchar (25) NULL ,

BillProvSuffix varchar (10) NULL ,

BillProvSpecialty varchar (10) NULL ,

BillProvAddress varchar (55) NULL ,

BillProvAddress2 varchar (55) NULL ,

BillProvCity varchar (30) NULL ,

BillProvState char (2) NULL ,

BillProvZip varchar (15) NULL ,

BillProvContact varchar (60) NULL ,

BillProvTel varchar (80) NULL ,

BillProvTelExt varchar (80) NULL ,

BillProvFax varchar (80) NULL ,

BillProvEmail varchar (80) NULL ,

PayToProvIDType char (2) NULL ,

PaytoProvID varchar (80) NULL ,

PaytoProvLast varchar (35) NULL ,

PaytoProvFirst varchar (25) NULL ,

PayToProvMiddle varchar (25) NULL ,

PayToProvSuffix varchar (10) NULL ,

PayToProvSpecialty varchar (10) NULL ,

PaytoProvAddress varchar (55) NULL ,

PayToProvAddress2 varchar (55) NULL ,

PaytoProvCity varchar (30) NULL ,

PaytoProvState char (2) NULL ,

PaytoProvZip varchar (15) NULL ,

RendProvIDType char (2) NULL ,

RendProvID varchar (80) NULL ,

RendProvLast varchar (35) NULL ,

RendProvFirst varchar (25) NULL ,

RendProvMiddle varchar (25) NULL ,

RendProvSuffix varchar (10) NULL ,

RendProvSpecialty varchar (10) NULL ,

AttendProvLast varchar (35) NULL ,

AttendProvFirst varchar (25) NULL ,

AttendProvMiddle varchar (25) NULL ,

AttendProvSuffix varchar (10) NULL ,

AttendProvIDType char (2) NULL ,

AttendProvID varchar (80) NULL ,

AttendProvSpecialty varchar (10) NULL ,

OperatingProvLast varchar (35) NULL ,

OperatingProvFirst varchar (25) NULL ,

OperatingProvMiddle varchar (25) NULL ,

OperatingProvSuffix varchar (10) NULL ,

OperatingProvIDType char (2) NULL ,

OperatingProvID varchar (80) NULL ,

OperatingProvSpecialty varchar (10) NULL ,

OtherProvLast varchar (35) NULL ,

OtherProvFirst varchar (25) NULL ,

OtherProvMiddle varchar (25) NULL ,

OtherProvSuffix varchar (10) NULL ,

OtherProvIDType varchar (100) NULL ,

OtherProvID varchar (100) NULL ,

OtherProvSpecialty varchar (100) NULL ,

FacilityType char (2) NULL ,

FacilityIDType char (2) NULL ,

FacilityID varchar (80) NULL ,

FacilityName varchar (80) NULL ,

FacilityAddress varchar (55) NULL ,

FacilityAddress2 varchar (55) NULL ,

FacilityCity varchar (30) NULL ,

FacilitySpecialty varchar (100) NULL ,

FacilityState char (2) NULL ,

FacilityZip varchar (15) NULL ,

OutsideLab char (1) NULL ,

LabCharge varchar (10) NULL ,

SubscriberLast varchar (35) NULL ,

SubscriberFirst varchar (25) NULL ,

SubscriberMiddle varchar (25) NULL ,

SubscriberSuffix varchar (10) NULL ,

SubscriberAddress varchar (55) NULL ,

SubscriberAddress2 varchar (55) NULL ,

SubscriberCity varchar (30) NULL ,

SubscriberState char (2) NULL ,

SubscriberZip varchar (15) NULL ,

SubscriberIDType char (2) NULL ,

SubscriberID varchar (80) NULL ,

SubscriberDOB varchar (10) NULL ,

SubscriberSex char (1) NULL ,

InsuranceType char (2) NULL ,

GroupNo varchar (50) NULL ,

GroupName varchar (60) NULL ,

FilingIndicator char (2) NULL ,

PatientLast varchar (35) NULL ,

PatientFirst varchar (25) NULL ,

PatientMiddle varchar (25) NULL ,

PatientSuffix varchar (10) NULL ,

PatientAddress varchar (55) NULL ,

PatientAddress2 varchar (55) NULL ,

PatientCity varchar (30) NULL ,

PatientState char (2) NULL ,

PatientZip varchar (15) NULL ,

PatientIDType char (2) NULL ,

PatientID varchar (80) NULL ,

PatientDOB varchar (50) NULL ,

PatientSex char (1) NULL ,

PatientRelationship char (2) NULL ,

PatientPaid varchar (10) NULL ,

PregnancyIndicator char (1) NULL ,

OtherInsuredLast varchar (35) NULL ,

OtherInsuredFirst varchar (25) NULL ,

OtherInsuredMiddle varchar (25) NULL ,

OtherInsuredSuffix varchar (10) NULL ,

OtherInsuredPolicy varchar (50) NULL ,

OtherInsuredDOB varchar (10) NULL ,

OtherInsuredSex char (1) NULL ,

OtherInsuredRelationship char (2) NULL ,

OtherPayerName varchar (35) NULL ,

OtherPayerID varchar (80) NULL ,

OtherPayerPaid varchar (10) NULL ,

OtherPayerGroupName varchar (100) NULL ,

OtherPayerGroupNo varchar (100) NULL ,

PayerName varchar (35) NULL ,

PayerIDType char (2) NULL ,

PayerID varchar (80) NULL ,

PayerAddress varchar (55) NULL ,

PayerAddress2 varchar (55) NULL ,

PayerCity varchar (30) NULL ,

PayerState char (2) NULL ,

PayerZip varchar (15) NULL ,

Amount varchar (50) NULL ,

EstimatedAmountDue varchar (10) NULL ,

PlaceOfService char (2) NULL ,

SubmitReason char (1) NULL ,

ProviderSignature char (1) NULL ,

ProviderAcceptsAssignment char (1) NULL ,

BenefitAssignment char (1) NULL ,

InfoReleaseCode char (1) NULL ,

PatientSignatureCode char (1) NULL ,

RelatedCauses char (2) NULL ,

RelatedCausesState char (2) NULL ,

SpecialProgramCode char (3) NULL ,

ProviderParticipation char (1) NULL ,

ServiceDateFrom varchar (15) NULL ,

ServiceDateTo varchar (15) NULL ,

OnsetDate varchar (15) NULL ,

SimilarSymptomsDate varchar (10) NULL ,

DisabilityBegin varchar (10) NULL ,

DisabilityEnd varchar (10) NULL ,

HospitalizationBegin varchar (20) NULL ,

HospitalizationEnd varchar (10) NULL ,

AccidentDate varchar (20) NULL ,

AdmissionDate varchar (15) NULL ,

AdmissionHour varchar (10) NULL ,

AdmissionType char (1) NULL ,

AdmissionSource char (1) NULL ,

DischargeHour varchar (10) NULL ,

PatientStatus char (2) NULL ,

MedicalRecordNumber varchar (50) NULL ,

CoveredDays varchar (4) NULL ,

NonCoveredDays varchar (4) NULL ,

COBDays varchar (4) NULL ,

LifeTimeReserveDays varchar (4) NULL ,

PriorAuthorization varchar (50) NULL ,

OrigRefNo varchar (50) NULL ,

RefProvLast varchar (35) NULL ,

RefProvFirst varchar (25) NULL ,

RefProvMiddle varchar (25) NULL ,

RefProvSuffix varchar (10) NULL ,

RefProvIDType char (2) NULL ,

RefProvID varchar (80) NULL ,

RefProvSpecialty varchar (10) NULL ,

AdmitDiagnosis varchar (10) NULL ,

ECode varchar (100) NULL ,

PrincipalDiagnosis varchar (10) NULL ,

Diag2 varchar (10) NULL ,

Diag3 varchar (10) NULL ,

Diag4 varchar (10) NULL ,

Diag5 varchar (10) NULL ,

Diag6 varchar (10) NULL ,

Diag7 varchar (10) NULL ,

Diag8 varchar (10) NULL ,

Diag9 varchar (10) NULL ,

PrincipalProcedure varchar (10) NULL ,

PrincipalProcedureDate varchar (10) NULL ,

Proc2 varchar (50) NULL ,

Proc2Date varchar (10) NULL ,

Proc3 varchar (10) NULL ,

Proc3Date varchar (10) NULL ,

Proc4 varchar (10) NULL ,

Proc4Date varchar (10) NULL ,

Proc5 varchar (10) NULL ,

Proc5Date varchar (10) NULL ,

Proc6 varchar (10) NULL ,

Proc6Date varchar (10) NULL ,

DRG varchar (15) NULL ,

ValueCode1 char (3) NULL ,

ValueAmount1 varchar (10) NULL ,

ValueCode2 char (3) NULL ,

ValueAmount2 varchar (10) NULL ,

ValueCode3 char (3) NULL ,

ValueAmount3 varchar (10) NULL ,

ValueCode4 char (3) NULL ,

ValueAmount4 varchar (10) NULL ,

ValueCode5 char (3) NULL ,

ValueAmount5 varchar (10) NULL ,

ValueCode6 char (3) NULL ,

ValueAmount6 varchar (10) NULL ,

ValueCode7 varchar (10) NULL ,

ValueAmount7 varchar (10) NULL ,

ValueCode8 char (3) NULL ,

ValueAmount8 varchar (10) NULL ,

ValueCode9 char (3) NULL ,

ValueAmount9 varchar (10) NULL ,

ValueCode10 char (3) NULL ,

ValueAmount10 varchar (10) NULL ,

ValueCode11 char (3) NULL ,

ValueAmount11 varchar (10) NULL ,

ValueCode12 char (3) NULL ,

ValueAmount12 varchar (10) NULL ,

ConditionCode1 varchar (30) NULL ,

ConditionCode2 varchar (30) NULL ,

ConditionCode3 varchar (30) NULL ,

ConditionCode4 varchar (30) NULL ,

ConditionCode5 varchar (30) NULL ,

ConditionCode6 varchar (30) NULL ,

ConditionCode7 varchar (30) NULL ,

ConditionCode8 varchar (30) NULL ,

FileName varchar (100) NULL ,

OccurranceCode1 char (3) NULL ,

OccurranceDate1 varchar (10) NULL ,

OccurranceCode2 char (3) NULL ,

OccurranceDate2 varchar (10) NULL ,

OccurranceCode3 char (3) NULL ,

OccurranceDate3 varchar (10) NULL ,

OccurranceCode4 char (3) NULL ,

OccurranceDate4 varchar (10) NULL ,

OccurranceCode5 char (3) NULL ,

OccurranceDate5 varchar (10) NULL ,

OccurranceCode6 char (3) NULL ,

OccurranceDate6 varchar (10) NULL ,

OccurranceCode7 char (3) NULL ,

OccurranceDate7 varchar (10) NULL ,

OccurranceCode8 char (3) NULL ,

OccurranceDate8 varchar (10) NULL ,

OccurranceSpanCode1 char (3) NULL ,

OccurranceSpanFrom1 varchar (10) NULL ,

OccurranceSpanTo1 varchar (10) NULL ,

OccurranceSpanCode2 char (3) NULL ,

OccurranceSpanFrom2 varchar (10) NULL ,

OccurranceSpanTo2 varchar (10) NULL ,

Test_Prod char (1) NULL ,

ClaimType char (1) NULL ,

TypeofBill varchar (20) NULL ,

Remark1 varchar (90) NULL ,

Remark2 varchar (90) NULL ,

Remark3 varchar (90) NULL ,

Remark4 varchar (90) NULL ,

Claim_status char (1) NULL ,

TargetTP varchar (30) NULL ,

ClearingHouseID varchar (100) NULL,

               RepricedClaimNumber varchar (100) NULL,

               RepricingMethodology varchar (3) NULL,

               RepricedAmount varchar (15) NULL,

               SavingsAmount varchar (15) NULL,

               RepricerID varchar (30) NULL,

               RejectReason varchar (3) NULL

) ;

CREATE TABLE edi_claimdetail (

ID INT NOT NULL AUTO_INCREMENT KEY,

ClaimID varchar (50) NOT NULL ,

HIPAAsuiteID varchar (10) NULL ,

LineNumber decimal(18, 0) NOT NULL ,

LineID varchar (50) NULL ,

ServiceDateFrom varchar (50) NULL ,

ServiceDateTo varchar (50) NULL ,

FacilityCode varchar (50) NULL ,

RevenueCode varchar (50) NULL ,

ProcedureCode varchar (50) NULL ,

       Description varchar (100) NULL,

Amount varchar (50) NULL ,

Unit varchar (50) NULL ,

Quantity varchar (50) NULL ,

UnitRate varchar (50) NULL ,

NonCovered varchar (50) NULL ,

Paid varchar (50) NULL ,

PlaceOfService char (3) NULL ,

Modifier1 char (3) NULL ,

Modifier2 char (3) NULL ,

Modifier3 char (3) NULL ,

Modifier4 char (3) NULL ,

DiagPointer1 char (1) NULL ,

DiagPointer2 char (1) NULL ,

DiagPointer3 char (1) NULL ,

DiagPointer4 char (1) NULL ,

ToothNumber char (2) NULL ,

Surface varchar (10) NULL ,

EmergencyIndicator char (1) NULL,

      RepricingMethodology varchar (3) NULL,

      RepricedAmount varchar (15) NULL,

      SavingsAmount varchar (15) NULL,

      RepricerID varchar (30) NULL,

      RejectReason varchar (3) NULL

) ;