use cmsql

INSERT INTO  [ConfigTag]
           ([tag]
           ,[prompt]
           ,[length]
           ,[valkey]
           ,[browseFlag]
           ,[mandatory]
           ,[configGroup]
           ,[help]
           ,[tagorder])
     VALUES
           ('recname_NM109_40',
           'receiver name for NM109_40',
          15,  '',    0, 0, 'CONTROL',
          'will use receiver name of GS03 if you leave it blank; Availity ZMIXED',
		  43)
		  
INSERT INTO  [ConfigTag]
           ([tag]
           ,[prompt]
           ,[length]
           ,[valkey]
           ,[browseFlag]
           ,[mandatory]
           ,[configGroup]
           ,[help]
           ,[tagorder])
     VALUES
           ('sendid_isa06_ovr',
           'Receiver ISA06 if different from Submitter ID - GS02',
          15,  '',    0, 0, 'CONTROL',
          'assigned by insurance company to identify your submission for ISA06, different from GS02',
		  43)		  
		  
 if (select count(*) from cmins where ins = 'commercial') < 1
 begin
 INSERT INTO  [CmIns]
           ([Ins]
           ,[Description]
           ,[Type])
     VALUES
	 ('COMMERCIAL', 'Commercial','commercial')
end
	 
	 
insert into  validvalues 
   values ('INPFILE','COMMERCIAL.INP','COMMERCIAL.INP')
insert into  validvalues 
   values ('INSDIR','COMMERCIAL','Commercial')
insert into  validvalues 
   values ('INSPAYORID','030240928','Availity')
   
insert into configvalues values ('COMMERCIAL','default','ALLOWINSMINADJ','Y')
insert into configvalues values ('COMMERCIAL','default','BILLOVRALLOWFORLINE','Y')
insert into configvalues values ('COMMERCIAL','default','CLAIMSFILENAME','C:\claims\SEND_COMMERCIAL')
insert into configvalues values ('COMMERCIAL','default','CONTACTPHONE','Enter your Phone')
insert into configvalues values ('COMMERCIAL','default','DLINKPAY','Y')
insert into configvalues values ('COMMERCIAL','default','FACCODEQUALIF','B')
insert into configvalues values ('COMMERCIAL','default','INCCLAIMLVLPAY','N')
insert into configvalues values ('COMMERCIAL','default','INSPAYRATE','0.8')
insert into configvalues values ('COMMERCIAL','default','MUSTOVRALLOWIF0PAY','N')
insert into configvalues values ('COMMERCIAL','default','NAME','Availity')
insert into configvalues values ('COMMERCIAL','default','NOCUSTORIGREF','Y')
insert into configvalues values ('COMMERCIAL','default','NOGROUP','N')
insert into configvalues values ('COMMERCIAL','default','NOPAYOVERRIDE','N')
insert into configvalues values ('COMMERCIAL','default','PATSIGSOURCE','P')
insert into configvalues values ('COMMERCIAL','default','PRACTICE_TAX_TYPE','24')
insert into configvalues values ('COMMERCIAL','default','PRIMINSPAYONLY','Y')
insert into configvalues values ('COMMERCIAL','default','REASONSEC','47')
insert into configvalues values ('COMMERCIAL','default','RPTNAME','Demo Practice Availity')
insert into configvalues values ('COMMERCIAL','default','SENDID_ISA06','Enter Your ID')
insert into configvalues values ('COMMERCIAL','default','SQLCLAIMPAYONLY','N')
insert into configvalues values ('COMMERCIAL','default','SQLDEDUCTNOTE','N')
insert into configvalues values ('COMMERCIAL','default','SQLTRANOVR','N')
insert into configvalues values ('COMMERCIAL','default','SUBMITTER_NAME','Demo Submitter')
insert into configvalues values ('COMMERCIAL','default','USEACCEPTASSIGN','Y')
insert into configvalues values ('COMMERCIAL','default','USEPRIMPAYORID','N')


insert into insoverrides values ('COMMERCIAL','DLINKPAY','Y')
insert into insoverrides values ('COMMERCIAL','DME','N')
insert into insoverrides values ('COMMERCIAL','INS_PAYOR_NAME','COMMERCIAL.INP')
insert into insoverrides values ('COMMERCIAL','INSDIR','COMMERCIAL')
insert into insoverrides values ('COMMERCIAL','INSTYPE','COMM')
insert into insoverrides values ('COMMERCIAL','RECNAME_GS03','NCHK')
insert into insoverrides values ('COMMERCIAL','RECNAME_ISA08','030240928')
insert into insoverrides values ('COMMERCIAL','RECNAME_SHORT','AV09311993')
insert into insoverrides values ('COMMERCIAL','RECTYPE','1')
insert into insoverrides values ('COMMERCIAL','SENDTYPE_ISA05','ZZ')
insert into insoverrides values ('COMMERCIAL','SPECID','005010X222A1')
insert into insoverrides values ('COMMERCIAL','TEST','P')
insert into insoverrides values ('COMMERCIAL','USEINSPAYORID','N')
insert into insoverrides values ('COMMERCIAL','INSPAYORID','030240928')
insert into insoverrides values ('COMMERCIAL','NEWLINETBL','NEWLINETBL.CTL')
insert into insoverrides values ('COMMERCIAL','RPTCTL','PHYSICIANRPT.CTL')
insert into insoverrides values ('COMMERCIAL','SENTBYCLAIMMASTER','N')
insert into insoverrides values ('COMMERCIAL','DME','N')
insert into insoverrides values ('COMMERCIAL','ERRCTL','ERR_MEDICARE')
insert into insoverrides values ('COMMERCIAL','REF6RVALUE','<REF6R2006>')
insert into insoverrides values ('COMMERCIAL','REFEAVALUE','<BILLNO>')
insert into insoverrides values ('COMMERCIAL','CLM01VALUE','<PATCODE>')
insert into insoverrides values ('COMMERCIAL','RECNAME_NM109_40','ZMIXED')
insert into insoverrides values ('COMMERCIAL','WEBCONNECT','https://apps.availity.com/availity/web/home')
insert into insoverrides values ('COMMERCIAL','SENDID_ISA06_OVR','AV09311993')

 
