use Build_file


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'ENTEROHAEMORRHAGIC ESCHERICHIA COLI INFECTION','7800','2340','5460','1','1');

INSERT INTO [Medicare]..tbMed_MedicalCaseRates (ICDCode,Description,Status,PACKAGEID) VALUES('A04.3','ENTEROHAEMORRHAGIC ESCHERICHIA COLI INFECTION','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'CAMPYLOBACTER ENTERITIS','7800','2340','5460','1','1');

INSERT INTO [Medicare]..tbMed_MedicalCaseRates (ICDCode,Description,Status,PACKAGEID) VALUES('A04.5','CAMPYLOBACTER ENTERITIS','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'FOODBORNE BACILLUS CEREUS INTOXICATION','7800','2340','5460','1','1');

INSERT INTO [Medicare]..tbMed_MedicalCaseRates (ICDCode,Description,Status,PACKAGEID) VALUES('A05.4','FOODBORNE BACILLUS CEREUS INTOXICATION','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'CERCARIAL DERMATITIS;  SWIMMERS ITCH','5200','1560','3640','1','1');

INSERT INTO [Medicare]..tbMed_MedicalCaseRates (ICDCode,Description,Status,PACKAGEID) VALUES('B65.3','CERCARIAL DERMATITIS;  SWIMMERS ITCH','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'RADIATION TREATMENT DELIVERY (LINEAR ACCELERATOR)','3900','1040','2860','1','2');

INSERT INTO [Medicare]..tbMed_Procedures (RVSCODE ,Description,Status,PACKAGEID) VALUES('77401','RADIATION TREATMENT DELIVERY (LINEAR ACCELERATOR)','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'RADIATION TREATMENT DELIVERY (COBALT)','2600','1040','1560','1','2');

INSERT INTO [Medicare]..tbMed_Procedures (RVSCODE ,Description,Status,PACKAGEID) VALUES('77401','RADIATION TREATMENT DELIVERY (COBALT)','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'CHEMOTHERAPY ADMINISTRATION','9464','2184','7280','1','2');

INSERT INTO [Medicare]..tbMed_Procedures (RVSCODE ,Description,Status,PACKAGEID) VALUES('96408*','CHEMOTHERAPY ADMINISTRATION','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'CHEMOTHERAPY ADMINISTRATION INTO PLEURAL CAVITY, REQUIRING AND INCLUDING THORACENTESIS','7228','1638','5590','1','2');

INSERT INTO [Medicare]..tbMed_Procedures (RVSCODE ,Description,Status,PACKAGEID) VALUES('96440*','CHEMOTHERAPY ADMINISTRATION INTO PLEURAL CAVITY, REQUIRING AND INCLUDING THORACENTESIS','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'EXPANDED NEWBORN CARE PACKAGE','3835','650','3185','1','2');

INSERT INTO [Medicare]..tbMed_Procedures (RVSCODE ,Description,Status,PACKAGEID) VALUES('99460','EXPANDED NEWBORN CARE PACKAGE','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'ANTENATAL CARE PACKAGE','1950','780','1170','1','2');

INSERT INTO [Medicare]..tbMed_Procedures (RVSCODE ,Description,Status,PACKAGEID) VALUES('ANC01','ANTENATAL CARE PACKAGE','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'ANTENATAL CARE SERVICES WITH INTRAPARTUM MONITORING OR LABOR WATCH (WITHOUT DELIVERY)','2795','1118','1677','1','2');

INSERT INTO [Medicare]..tbMed_Procedures (RVSCODE ,Description,Status,PACKAGEID) VALUES('ANC02','ANTENATAL CARE SERVICES WITH INTRAPARTUM MONITORING OR LABOR WATCH (WITHOUT DELIVERY)','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'SUBDERMAL CONTRACEPTIVE IMPLANT','3900','1560','2340','1','2');

INSERT INTO [Medicare]..tbMed_Procedures (RVSCODE ,Description,Status,PACKAGEID) VALUES('FP001','SUBDERMAL CONTRACEPTIVE IMPLANT','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'ROUTINE OBSTETRIC CARE INCLUDING PRENATAL, DELIVERY AND NEWBORN SERVICES OF NON-HOSPITAL FACILITIES (MATERNITY CARE PACKAGE)','8450','3380','5070','1','2');

INSERT INTO [Medicare]..tbMed_Procedures (RVSCODE ,Description,Status,PACKAGEID) VALUES('MCP01','ROUTINE OBSTETRIC CARE INCLUDING PRENATAL, DELIVERY AND NEWBORN SERVICES OF NON-HOSPITAL FACILITIES (MATERNITY CARE PACKAGE)','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'RESUSCITATION PACKAGE','5200','1560','3640','1','2');

INSERT INTO [Medicare]..tbMed_Procedures (RVSCODE ,Description,Status,PACKAGEID) VALUES('P0000','RESUSCITATION PACKAGE','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );


INSERT INTO [Medicare].[dbo].[tbMedPackage] ([PackageID],[Package],[Amount],[PF],[MedRoomBoard],[Status],[CaseType])  VALUES((select  MAX(convert(BIGINT,packageID))+1 from  [Medicare].[dbo].[tbMedPackage]),'REFERRAL PACKAGE','5200','1560','3640','1','2');

INSERT INTO [Medicare]..tbMed_Procedures (RVSCODE ,Description,Status,PACKAGEID) VALUES('P0001','REFERRAL PACKAGE','1',(select MAX(convert(BIGINT,packageID)) from  [Medicare].[dbo].[tbMedPackage]) );