
Insert into PPSNEPL.EPL_NATIONAL_SETTINGS
   (ID, KEY_NAME, STRING_VALUE, CREATED_BY, CREATED_DTM, 
    LAST_MODIFIED_BY, LAST_MODIFIED_DTM)
 Values
   (35, 'NDF_UPDATE_RUN_STATE', 'COMPLETED', 'DEVELOPER', SYSDATE, 'NdfUpdateProcess', SYSDATE);
Insert into PPSNEPL.EPL_NATIONAL_SETTINGS
   (ID, KEY_NAME, DATE_VALUE, CREATED_BY, CREATED_DTM, 
    LAST_MODIFIED_BY, LAST_MODIFIED_DTM)
 Values
   (36, 'NDF_UPDATE_LAST_RUN', NULL, 'DEVELOPER', TO_TIMESTAMP('1/31/2014 12:00:00.000000 AM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM'), 
    'NdfUpdateProcess', SYSDATE);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (37,'NDF_OUTGOING_FILE_TEXT','unmatched from the National Drug File (NDF).  The VA Product |name and CMOP ID corresponding to the unmatched local drug file |name are listed on the indented line beneath each entry.  An |Inactivation Date may be listed for entries when this reason |applies.  Until you rematch these entries to NDF, they will not |transmit to CMOP and drug-drug interaction checks will not check |for these products.  It is critical that you rematch these |products immediately.  You may also need to match a new |orderable item.  Any possible dosages and local possible |dosages for these unmatched products have been deleted. |Therefore, the dosages for each unmatched product should |be reviewed after the rematch or recreated if the product |can not be rematched to a VA Product through the NDF |',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (38,'NDF_OUTPUT_FILE_DIRECTORY','./tmp/',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (39,'NDF_OUTPUT_TST_PROTOCOL','FTP',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (40,'NDF_OUTPUT_TST_HOSTNAME','10.1.19.9',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (41,'NDF_OUTPUT_TST_PORT','21',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (42,'NDF_OUTPUT_TST_USERNAME','USRVISTA',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (43,'NDF_OUTPUT_TST_PASSWORD',' ',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (45,'NDF_OUTPUT_TST_DIRECTORY','$1$DGA55:[PMIS.MARK]',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (46,'NDF_OUTPUT_PROD_PROTOCOL','FTP',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (47,'NDF_OUTPUT_PROD_HOSTNAME','10.1.19.9',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (48,'NDF_OUTPUT_PROD_PORT','21',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (49,'NDF_OUTPUT_PROD_USERNAME','USRVISTA',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (50,'NDF_OUTPUT_PROD_PASSWORD',' ',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (51,'NDF_OUTPUT_PROD_DIRECTORY','$1$DGA55:[PMIS.MARK]',null,null,null,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (52,'NDF_OUTPUT_FTP_ON',null,null,null,0,null,'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),'DEVELOPER',to_timestamp('21-MAY-14 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'));
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (53,'MESSAGE_STRENGTH_TEXT','The following Strength(s) have been edited or added. Any product matched to|these products will be unmatched. If site wants to continue to use the|product the site must rematch to local file #50 entries to the listed VA|products.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (54,'MESSAGE_OVERRIDEDOSECHECK_TEXT','The override dose form checks field has changed for the following products.|',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (55,'MESSAGE_NATIONALFORMULARY_TEXT','The National Formulary Indicator has changed for the following|VA Products. The National Formulary Indicator will automatically|be changed in your local DRUG file (#50). Please review the|VISN and Local Formulary designations of these products and|make appropriate changes.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (56,'MESSAGE_INACTIVATEDCMOP_TEXT','The following active VA Products are no longer marked for CMOP.|All local drug file entries matched to these VA Products will|be UNMARKED for CMOP. In order to have these entries dispensed|by CMOP any local DRUG file (#50) entries matched to these|products must be re-matched to another VA product that is actively|marked for CMOP dispensing.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (57,'MESSAGE_ADDEDPRODUCT_TEXT','The following VA Products have been added to the National|Drug File. You may wish to review, then match or unmatch|local drug file entries based on this updated information.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (58,'MESSAGE_SCHEDULECHANGE_TEXT','The CS Federal Schedule for the following VA Products has|been added or changed. You may wish to review the DRUG|file (#50) and make appropriate changes to the DEA, SPECIAL|HDLG field (#3).',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (59,'MESSAGE_POSSIBLEDOSAGE_TEXT','The Auto-Create Possible Dosages settings have been edited for the|following VA Products. Please review your local dosages for products|matched to these entries. Edits to your site''s possible dosages or|local possible dosages may be needed.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (60,'MESSAGE_PRINTNAMECHANGE_TEXT','The following VA Print Name(s) have been edited or added. Any product matched|to these products will be unmatched. If site wants to continue to use the|product the site must rematch to local file #50 entries to the listed VA product.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (61,'MESSAGE_DRUGUNITCHANGE_TEXT','The following Unit(s) have been edited or added. Any product matched to these|products will be unmatched. If site wants to continue to use the product the|site must rematch to local file #50 entries to the listed VA Product.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (62,'MESSAGE_DISPENSEUNITCHANGE_TEXT','The following VA Dispense Units(s) have been edited or added. Any product|matched to these products will be unmatched. If site wants to continue to use|the product the site must rematch to local file #50 entries to the listed VA|product.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (63,'MESSAGE_VACLASSCHANGE_TEXT','The following VA Drug Class(es) have been edited or added. The VA Class|for this product will be automatically updated in file #50.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (64,'MESSAGE_CMOPCHANGE_TEXT','The following VA Product Identifier(s) have been edited or added. Any product|matched to these products will be unmatched. If site wants to continue to use|the product the site must rematch to local file #50 entries to the listed VA|product.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (65,'MESSAGE_FUTUREINACTIVE_TEXT','The following products WILL be inactivated on the date listed. No alternative|products have been found.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (66,'MESSAGE_SCHEDULECHANGEALL_TEXT','The following CS Federal Schedule(s) have been edited or added. Please review|the local DEA special handling field and make edits are required.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (67,'MESSAGE_GENERICNAMECHANGE_TEXT','The following VA Generic Name(s) have been edited or added. Any product|matched to these products will be unmatched. If site wants to continue to use|the product the site must rematch to local file #50 entries to the listed VA|product.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (68,'MESSAGE_DOSAGEFORMCHANGE_TEXT','The following VA Dosage Form(s) have been edited. Any product matched to|these products will be unmatched. If site wants to continue to use the|product the site must rematch to local file #50 entries to the listed VA|product.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (69,'MESSAGE_INACTIVATEDPRODUCT_TEXT','The following product(s) have been inactivated. No alternative products have|been found.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (70,'MESSAGE_REACTIVATEDPRODUCT_TEXT','The following VA Product(s) have been reactivated.|',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (71,'MESSAGE2_MEDGUIDE_TEXT','The FDA Med Guide for the following products has been changed|',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (72,'MESSAGE2_EXCLUEDEDDDI_TEXT','The following products have been flagged for exclusion from drug-drug|interaction checks.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (73,'MESSAGE2_PREVEXCLUEDEDDDI_TEXT','The following products, previously flagged for exclusion from drug-drug|interaction checks, have been changed to be included|in drug-drug interaction checks where appropriate.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (74,'MESSAGE2_DDI_TEXT','The following interactions in National Drug File (NDF) have been added,|edited or inactivated. These changes are the result of review and|recommendations from the NDF support group.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (76,'MESSAGE_INACTIVATEDWSUGG_TEXT','The following product(s) have been inactivated. Any file #50 entries matched|to these products will be unmatched. To continue to use the product, the site|must rematch the local file #50 entries to the listed VA Product.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (77,'MESSAGE_PROPOSEDINACTIVATEDWSUGG_TEXT','The following product(s) WILL be inactivated in on the date listed. Any file|#50 entries matched to these products will be unmatched once the product is|inactivated. If a site wants to continue to use the product, the site must|rematch the local file #50 entries to the listed VA Product.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
COMMIT;
--rework sprint
insert into "PPSNEPL"."EPL_NATIONAL_SETTINGS" ("ID", "KEY_NAME", "STRING_VALUE", "INTEGER_VALUE", "DECIMAL_VALUE", "BOOLEAN_VALUE", "DATE_VALUE", "CREATED_BY", "CREATED_DTM", "LAST_MODIFIED_BY", "LAST_MODIFIED_DTM") values(75, 'NATIONAL_SITE_NUMBER', null, 521, null, null, null, 'DEVELOPER', sysdate, 'DEVELOPER', sysdate)
commit;

--sprint 10 6/10/14
insert into "PPSNEPL"."EPL_NATIONAL_SETTINGS" ("ID", "KEY_NAME", "STRING_VALUE", "INTEGER_VALUE", "DECIMAL_VALUE", "BOOLEAN_VALUE", "DATE_VALUE", "CREATED_BY", "CREATED_DTM", "LAST_MODIFIED_BY", "LAST_MODIFIED_DTM") values(78, 'REPORT_DATA_UPDATE_START', null, null, null, null, null, 'DEVELOPER', sysdate, 'DEVELOPER', sysdate)
insert into "PPSNEPL"."EPL_NATIONAL_SETTINGS" ("ID", "KEY_NAME", "STRING_VALUE", "INTEGER_VALUE", "DECIMAL_VALUE", "BOOLEAN_VALUE", "DATE_VALUE", "CREATED_BY", "CREATED_DTM", "LAST_MODIFIED_BY", "LAST_MODIFIED_DTM") values(79, 'REPORT_DATA_UPDATE_COMPLETE', null, null, null, null, null, 'DEVELOPER', sysdate, 'DEVELOPER', sysdate)

commit;

Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (80,'MESSAGE_INACTIVATEDREMATCHED_TEXT','The following product(s) have been inactivated. Any file|#50 entries matched to these products will be unmatched and rematched to the|local file #50 entries listed.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (81,'MESSAGE_OTHERREMATCHED_TEXT','The following product(s) have been unmatched. Any file|#50 entries matched to these products will be unmatched and rematched to the|local file #50 entries listed.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (82,'MESSAGE_OTHERREMATCHSUGG_TEXT','The following product(s) have been edited Any file|#50 entries matched to these products will be unmatched. To continue to use|the product, the site must rematch the local file #50 entries to the listed VA Product.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);
Insert into EPL_NATIONAL_SETTINGS (ID,KEY_NAME,STRING_VALUE,INTEGER_VALUE,DECIMAL_VALUE,BOOLEAN_VALUE,DATE_VALUE,CREATED_BY,CREATED_DTM,LAST_MODIFIED_BY,LAST_MODIFIED_DTM) values (83,'MESSAGE_OTHERNOREMATCH_TEXT','The following product(s) have been unmatched. No alternative products|have been found.',null,null,null,null,'DEVELOPER',sysdate,'DEVELOPER',sysdate);

commit;
