Use cmsql

insert into CmIns 
values ('COM837I','Clinic Medicaid Commercial', 'medicaid')


insert into configvalues values ('COM837I','Default','CLAIMSFILENAME','c:\default_837I')
insert into configvalues values ('COM837I','Default','CONTACTNAME','demo contact name')
insert into configvalues values ('COM837I','Default','CONTACTPHONE','5167472362')
insert into configvalues values ('COM837I','Default','INSPAYRATE','0.8')
insert into configvalues values ('COM837I','Default','NAME','DEMO CMCAID')
insert into configvalues values ('COM837I','Default','NINETYDAY','8')
insert into configvalues values ('COM837I','Default','NINETYDAY2','7')
insert into configvalues values ('COM837I','Default','ONLYRATE','1504')
insert into configvalues values ('COM837I','Default','POS','73')
insert into configvalues values ('COM837I','Default','PRACTICE_TAX_TYPE','24')
insert into configvalues values ('COM837I','Default','REVENUECODE','0520')
insert into configvalues values ('COM837I','Default','RPTNAME','demo Clinic Medicaid via commercial')
insert into configvalues values ('COM837I','Default','SUBMITTER_NAME','demo')


insert into insOverrides values ('COM837I','CLM01VALUE','<PATCODE>')
insert into insOverrides values ('COM837I','DME','N')
insert into insOverrides values ('COM837I','ERRCTL','ERR_MEDICAID.CTL')
insert into insOverrides values ('COM837I','ETIN','ETIN')
insert into insOverrides values ('COM837I','EXTRACRLF','0')
insert into insOverrides values ('COM837I','FACCODEQUALIF','A')
insert into insOverrides values ('COM837I','INS_PAYOR_NAME','COMM837I.INP')
insert into insOverrides values ('COM837I','INSDIR','COM837I')
insert into insOverrides values ('COM837I','INSPAYORID','133052274')
insert into insOverrides values ('COM837I','INSTYPE','MCDC')
insert into insOverrides values ('COM837I','NOGROUP','Y')
insert into insOverrides values ('COM837I','RECNAME_GS03','NCHK')
insert into insOverrides values ('COM837I','RECNAME_ISA08','133052274')
insert into insOverrides values ('COM837I','RECNAME_SHORT','EMDEON')
insert into insOverrides values ('COM837I','RECTYPE','ZZ')
insert into insOverrides values ('COM837I','REF6RVALUE','<REF6R2006>')
insert into insOverrides values ('COM837I','REFEAVALUE','<BILLNO>')
insert into insOverrides values ('COM837I','RPTCTL','RPT.CTL')
insert into insOverrides values ('COM837I','SENDID_ISA06','223182777')
insert into insOverrides values ('COM837I','SENDNAME_GS02','ENTER ETIN')
insert into insOverrides values ('COM837I','SENDTYPE_ISA05','ZZ')
insert into insOverrides values ('COM837I','SENTBYCLAIMMASTER','N')
insert into insOverrides values ('COM837I','SPECID','005010X223A2')
insert into insOverrides values ('COM837I','TEST','P')
insert into insOverrides values ('COM837I','USEINSPAYORID','N')
insert into insOverrides values ('COM837I','USEPRIMPAYORID','N')


insert into ValidValues 
values ('INSDIR', 'COM837I','Clinic Medicaid by Commercial')

insert into ValidValues
values ('INSPAYORID','TESTPAYOR','Test Payor')
insert into ValidValues
values ('INSPAYORID','133052274','EMDEON')
insert into ValidValues
values ('INPFILE','COM_MEDICAID.INP','COM_MEDICAID.INP')

 