15. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 3/8/2018 10:11:22 AM Eastern Standard Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.

15.1 Files compared

# Location File Last Modified
1 PRE_PPS-N_v3.0.1.zip\PS_PPS_DataMgmt\src\main\resources\PPSN2.0\Data 33495_batchjob_epl_national_setting.sql Fri Jan 12 15:42:22 2018 UTC
2 PRE_PPS-N_v3.0.1.zip\PS_PPS_DataMgmt\src\main\resources\PPSN2.0\Data 33495_batchjob_epl_national_setting.sql Tue Mar 6 20:21:31 2018 UTC

15.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 3 132
Changed 2 4
Inserted 0 0
Removed 0 0

15.3 Comparison options

Whitespace
Character case Differences in character case are significant
Line endings Differences in line endings (CR and LF characters) are ignored
CR/LF characters Not shown in the comparison detail

15.4 Active regular expressions

No regular expressions were active.

15.5 Comparison detail

  1  
  2   Insert int o PPSNEPL. EPL_NATION AL_SETTING S
  3      (ID, KE Y_NAME, ST RING_VALUE , CREATED_ BY, CREATE D_DTM, 
  4       LAST_M ODIFIED_BY , LAST_MOD IFIED_DTM)
  5    Values
  6      (35, 'N DF_UPDATE_ RUN_STATE' , 'COMPLET ED', 'DEVE LOPER', SY SDATE, 'Nd fUpdatePro cess', SYS DATE);
  7   Insert int o PPSNEPL. EPL_NATION AL_SETTING S
  8      (ID, KE Y_NAME, DA TE_VALUE,  CREATED_BY , CREATED_ DTM, 
  9       LAST_M ODIFIED_BY , LAST_MOD IFIED_DTM)
  10    Values
  11      (36, 'N DF_UPDATE_ LAST_RUN',  NULL, 'DE VELOPER',  TO_TIMESTA MP('1/31/2 014 12:00: 00.000000  AM','fmMMf m/fmDDfm/Y YYY fmHH12 fm:MI:SS.F F AM'), 
  12       'NdfUp dateProces s', SYSDAT E);
  13   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 37,'NDF_OU TGOING_FIL E_TEXT','u nmatched f rom the Na tional Dru g File (ND F).  The V A Product  |name and  CMOP ID co rrespondin g to the u nmatched l ocal drug  file |name  are liste d on the i ndented li ne beneath  each entr y.  An |In activation  Date may  be listed  for entrie s when thi s reason | applies.   Until you  rematch th ese entrie s to NDF,  they will  not |trans mit to CMO P and drug -drug inte raction ch ecks will  not check  |for these  products.   It is cr itical tha t you rema tch these  |products  immediatel y.  You ma y also nee d to match  a new |or derable it em.  Any p ossible do sages and  local poss ible |dosa ges for th ese unmatc hed produc ts have be en deleted . |Therefo re, the do sages for  each unmat ched produ ct should  |be review ed after t he rematch  or recrea ted if the  product | can not be  rematched  to a VA P roduct thr ough the N DF |',null ,null,null ,null,'DEV ELOPER',to _timestamp ('21-MAY-1 4 12.00.00 .000000000  AM','DD-M ON-RR HH.M I.SS.FF AM '),'DEVELO PER',to_ti mestamp('2 1-MAY-14 1 2.00.00.00 0000000 AM ','DD-MON- RR HH.MI.S S.FF AM')) ;
  14   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 38,'NDF_OU TPUT_FILE_ DIRECTORY' ,'./tmp/', null,null, null,null, 'DEVELOPER ',to_times tamp('21-M AY-14 12.0 0.00.00000 0000 AM',' DD-MON-RR  HH.MI.SS.F F AM'),'DE VELOPER',t o_timestam p('21-MAY- 14 12.00.0 0.00000000 0 AM','DD- MON-RR HH. MI.SS.FF A M'));
  15   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 39,'NDF_OU TPUT_TST_P ROTOCOL',' FTP',null, null,null, null,'DEVE LOPER',to_ timestamp( '21-MAY-14  12.00.00. 000000000  AM','DD-MO N-RR HH.MI .SS.FF AM' ),'DEVELOP ER',to_tim estamp('21 -MAY-14 12 .00.00.000 000000 AM' ,'DD-MON-R R HH.MI.SS .FF AM'));
  16   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 40,'NDF_OU TPUT_TST_H OSTNAME',' IP         ',null,nul l,null,nul l,'DEVELOP ER',to_tim estamp('21 -MAY-14 12 .00.00.000 000000 AM' ,'DD-MON-R R HH.MI.SS .FF AM'),' DEVELOPER' ,to_timest amp('21-MA Y-14 12.00 .00.000000 000 AM','D D-MON-RR H H.MI.SS.FF  AM'));
  17   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 41,'NDF_OU TPUT_TST_P ORT','21', null,null, null,null, 'DEVELOPER ',to_times tamp('21-M AY-14 12.0 0.00.00000 0000 AM',' DD-MON-RR  HH.MI.SS.F F AM'),'DE VELOPER',t o_timestam p('21-MAY- 14 12.00.0 0.00000000 0 AM','DD- MON-RR HH. MI.SS.FF A M'));
  18   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 42,'NDF_OU TPUT_TST_U SERNAME',' USRVISTA', null,null, null,null, 'DEVELOPER ',to_times tamp('21-M AY-14 12.0 0.00.00000 0000 AM',' DD-MON-RR  HH.MI.SS.F F AM'),'DE VELOPER',t o_timestam p('21-MAY- 14 12.00.0 0.00000000 0 AM','DD- MON-RR HH. MI.SS.FF A M'));
  19   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 43,'NDF_OU TPUT_TST_P ASSWORD','  ',null,nu ll,null,nu ll,'DEVELO PER',to_ti mestamp('2 1-MAY-14 1 2.00.00.00 0000000 AM ','DD-MON- RR HH.MI.S S.FF AM'), 'DEVELOPER ',to_times tamp('21-M AY-14 12.0 0.00.00000 0000 AM',' DD-MON-RR  HH.MI.SS.F F AM'));
  20   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 45,'NDF_OU TPUT_TST_D IRECTORY', '$1$DGA55: [PMIS.MARK ]',null,nu ll,null,nu ll,'DEVELO PER',to_ti mestamp('2 1-MAY-14 1 2.00.00.00 0000000 AM ','DD-MON- RR HH.MI.S S.FF AM'), 'DEVELOPER ',to_times tamp('21-M AY-14 12.0 0.00.00000 0000 AM',' DD-MON-RR  HH.MI.SS.F F AM'));
  21   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 46,'NDF_OU TPUT_PROD_ PROTOCOL', 'FTP',null ,null,null ,null,'DEV ELOPER',to _timestamp ('21-MAY-1 4 12.00.00 .000000000  AM','DD-M ON-RR HH.M I.SS.FF AM '),'DEVELO PER',to_ti mestamp('2 1-MAY-14 1 2.00.00.00 0000000 AM ','DD-MON- RR HH.MI.S S.FF AM')) ;
  22   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 47,'NDF_OU TPUT_PROD_ HOSTNAME', ' IP         ',null,nul l,null,nul l,'DEVELOP ER',to_tim estamp('21 -MAY-14 12 .00.00.000 000000 AM' ,'DD-MON-R R HH.MI.SS .FF AM'),' DEVELOPER' ,to_timest amp('21-MA Y-14 12.00 .00.000000 000 AM','D D-MON-RR H H.MI.SS.FF  AM'));
  23   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 48,'NDF_OU TPUT_PROD_ PORT','21' ,null,null ,null,null ,'DEVELOPE R',to_time stamp('21- MAY-14 12. 00.00.0000 00000 AM', 'DD-MON-RR  HH.MI.SS. FF AM'),'D EVELOPER', to_timesta mp('21-MAY -14 12.00. 00.0000000 00 AM','DD -MON-RR HH .MI.SS.FF  AM'));
  24   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 49,'NDF_OU TPUT_PROD_ USERNAME', 'USRVISTA' ,null,null ,null,null ,'DEVELOPE R',to_time stamp('21- MAY-14 12. 00.00.0000 00000 AM', 'DD-MON-RR  HH.MI.SS. FF AM'),'D EVELOPER', to_timesta mp('21-MAY -14 12.00. 00.0000000 00 AM','DD -MON-RR HH .MI.SS.FF  AM'));
  25   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 50,'NDF_OU TPUT_PROD_ PASSWORD', ' ',null,n ull,null,n ull,'DEVEL OPER',to_t imestamp(' 21-MAY-14  12.00.00.0 00000000 A M','DD-MON -RR HH.MI. SS.FF AM') ,'DEVELOPE R',to_time stamp('21- MAY-14 12. 00.00.0000 00000 AM', 'DD-MON-RR  HH.MI.SS. FF AM'));
  26   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 51,'NDF_OU TPUT_PROD_ DIRECTORY' ,'$1$DGA55 :[PMIS.MAR K]',null,n ull,null,n ull,'DEVEL OPER',to_t imestamp(' 21-MAY-14  12.00.00.0 00000000 A M','DD-MON -RR HH.MI. SS.FF AM') ,'DEVELOPE R',to_time stamp('21- MAY-14 12. 00.00.0000 00000 AM', 'DD-MON-RR  HH.MI.SS. FF AM'));
  27   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 52,'NDF_OU TPUT_FTP_O N',null,nu ll,null,0, null,'DEVE LOPER',to_ timestamp( '21-MAY-14  12.00.00. 000000000  AM','DD-MO N-RR HH.MI .SS.FF AM' ),'DEVELOP ER',to_tim estamp('21 -MAY-14 12 .00.00.000 000000 AM' ,'DD-MON-R R HH.MI.SS .FF AM'));
  28   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 53,'MESSAG E_STRENGTH _TEXT','Th e followin g Strength (s) have b een edited  or added.  Any produ ct matched  to|these  products w ill be unm atched. If  site want s to conti nue to use  the|produ ct the sit e must rem atch to lo cal file # 50 entries  to the li sted VA|pr oducts.',n ull,null,n ull,null,' DEVELOPER' ,sysdate,' DEVELOPER' ,sysdate);
  29   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 54,'MESSAG E_OVERRIDE DOSECHECK_ TEXT','The  override  dose form  checks fie ld has cha nged for t he followi ng product s.|',null, null,null, null,'DEVE LOPER',sys date,'DEVE LOPER',sys date);
  30   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 55,'MESSAG E_NATIONAL FORMULARY_ TEXT','The  National  Formulary  Indicator  has change d for the  following| VA Product s. The Nat ional Form ulary Indi cator will  automatic ally|be ch anged in y our local  DRUG file  (#50). Ple ase review  the|VISN  and Local  Formulary  designatio ns of thes e products  and|make  appropriat e changes. ',null,nul l,null,nul l,'DEVELOP ER',sysdat e,'DEVELOP ER',sysdat e);
  31   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 56,'MESSAG E_INACTIVA TEDCMOP_TE XT','The f ollowing a ctive VA P roducts ar e no longe r marked f or CMOP.|A ll local d rug file e ntries mat ched to th ese VA Pro ducts will |be UNMARK ED for CMO P. In orde r to have  these entr ies dispen sed|by CMO P any loca l DRUG fil e (#50) en tries matc hed to the se|product s must be  re-matched  to anothe r VA produ ct that is  actively| marked for  CMOP disp ensing.',n ull,null,n ull,null,' DEVELOPER' ,sysdate,' DEVELOPER' ,sysdate);
  32   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 57,'MESSAG E_ADDEDPRO DUCT_TEXT' ,'The foll owing VA P roducts ha ve been ad ded to the  National| Drug File.  You may w ish to rev iew, then  match or u nmatch|loc al drug fi le entries  based on  this updat ed informa tion.',nul l,null,nul l,null,'DE VELOPER',s ysdate,'DE VELOPER',s ysdate);
  33   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 58,'MESSAG E_SCHEDULE CHANGE_TEX T','The CS  Federal S chedule fo r the foll owing VA P roducts ha s|been add ed or chan ged. You m ay wish to  review th e DRUG|fil e (#50) an d make app ropriate c hanges to  the DEA, S PECIAL|HDL G field (# 3).',null, null,null, null,'DEVE LOPER',sys date,'DEVE LOPER',sys date);
  34   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 59,'MESSAG E_POSSIBLE DOSAGE_TEX T','The Au to-Create  Possible D osages set tings have  been edit ed for the |following  VA Produc ts. Please  review yo ur local d osages for  products| matched to  these ent ries. Edit s to your  site''s po ssible dos ages or|lo cal possib le dosages  may be ne eded.',nul l,null,nul l,null,'DE VELOPER',s ysdate,'DE VELOPER',s ysdate);
  35   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 60,'MESSAG E_PRINTNAM ECHANGE_TE XT','The f ollowing V A Print Na me(s) have  been edit ed or adde d. Any pro duct match ed|to thes e products  will be u nmatched.  If site wa nts to con tinue to u se the|pro duct the s ite must r ematch to  local file  #50 entri es to the  listed VA  product.', null,null, null,null, 'DEVELOPER ',sysdate, 'DEVELOPER ',sysdate) ;
  36   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 61,'MESSAG E_DRUGUNIT CHANGE_TEX T','The fo llowing Un it(s) have  been edit ed or adde d. Any pro duct match ed to thes e|products  will be u nmatched.  If site wa nts to con tinue to u se the pro duct the|s ite must r ematch to  local file  #50 entri es to the  listed VA  Product.', null,null, null,null, 'DEVELOPER ',sysdate, 'DEVELOPER ',sysdate) ;
  37   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 62,'MESSAG E_DISPENSE UNITCHANGE _TEXT','Th e followin g VA Dispe nse Units( s) have be en edited  or added.  Any produc t|matched  to these p roducts wi ll be unma tched. If  site wants  to contin ue to use| the produc t the site  must rema tch to loc al file #5 0 entries  to the lis ted VA|pro duct.',nul l,null,nul l,null,'DE VELOPER',s ysdate,'DE VELOPER',s ysdate);
  38   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 63,'MESSAG E_VACLASSC HANGE_TEXT ','The fol lowing VA  Drug Class (es) have  been edite d or added . The VA C lass|for t his produc t will be  automatica lly update d in file  #50.',null ,null,null ,null,'DEV ELOPER',sy sdate,'DEV ELOPER',sy sdate);
  39   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 64,'MESSAG E_CMOPCHAN GE_TEXT',' The follow ing VA Pro duct Ident ifier(s) h ave been e dited or a dded. Any  product|ma tched to t hese produ cts will b e unmatche d. If site  wants to  continue t o use|the  product th e site mus t rematch  to local f ile #50 en tries to t he listed  VA|product .',null,nu ll,null,nu ll,'DEVELO PER',sysda te,'DEVELO PER',sysda te);
  40   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 65,'MESSAG E_FUTUREIN ACTIVE_TEX T','The fo llowing pr oducts WIL L be inact ivated on  the date l isted. No  alternativ e|products  have been  found.',n ull,null,n ull,null,' DEVELOPER' ,sysdate,' DEVELOPER' ,sysdate);
  41   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 66,'MESSAG E_SCHEDULE CHANGEALL_ TEXT','The  following  CS Federa l Schedule (s) have b een edited  or added.  Please re view|the l ocal DEA s pecial han dling fiel d and make  edits are  required. ',null,nul l,null,nul l,'DEVELOP ER',sysdat e,'DEVELOP ER',sysdat e);
  42   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 67,'MESSAG E_GENERICN AMECHANGE_ TEXT','The  following  VA Generi c Name(s)  have been  edited or  added. Any  product|m atched to  these prod ucts will  be unmatch ed. If sit e wants to  continue  to use|the  product t he site mu st rematch  to local  file #50 e ntries to  the listed  VA|produc t.',null,n ull,null,n ull,'DEVEL OPER',sysd ate,'DEVEL OPER',sysd ate);
  43   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 68,'MESSAG E_DOSAGEFO RMCHANGE_T EXT','The  following  VA Dosage  Form(s) ha ve been ed ited. Any  product ma tched to|t hese produ cts will b e unmatche d. If site  wants to  continue t o use the| product th e site mus t rematch  to local f ile #50 en tries to t he listed  VA|product .',null,nu ll,null,nu ll,'DEVELO PER',sysda te,'DEVELO PER',sysda te);
  44   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 69,'MESSAG E_INACTIVA TEDPRODUCT _TEXT','Th e followin g product( s) have be en inactiv ated. No a lternative  products  have|been  found.',nu ll,null,nu ll,null,'D EVELOPER', sysdate,'D EVELOPER', sysdate);
  45   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 70,'MESSAG E_REACTIVA TEDPRODUCT _TEXT','Th e followin g VA Produ ct(s) have  been reac tivated.|' ,null,null ,null,null ,'DEVELOPE R',sysdate ,'DEVELOPE R',sysdate );
  46   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 71,'MESSAG E2_MEDGUID E_TEXT','T he FDA Med  Guide for  the follo wing produ cts has be en changed |',null,nu ll,null,nu ll,'DEVELO PER',sysda te,'DEVELO PER',sysda te);
  47   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 72,'MESSAG E2_EXCLUED EDDDI_TEXT ','The fol lowing pro ducts have  been flag ged for ex clusion fr om drug-dr ug|interac tion check s.',null,n ull,null,n ull,'DEVEL OPER',sysd ate,'DEVEL OPER',sysd ate);
  48   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 73,'MESSAG E2_PREVEXC LUEDEDDDI_ TEXT','The  following  products,  previousl y flagged  for exclus ion from d rug-drug|i nteraction  checks, h ave been c hanged to  be include d|in drug- drug inter action che cks where  appropriat e.',null,n ull,null,n ull,'DEVEL OPER',sysd ate,'DEVEL OPER',sysd ate);
  49   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 74,'MESSAG E2_DDI_TEX T','The fo llowing in teractions  in Nation al Drug Fi le (NDF) h ave been a dded,|edit ed or inac tivated. T hese chang es are the  result of  review an d|recommen dations fr om the NDF  support g roup.',nul l,null,nul l,null,'DE VELOPER',s ysdate,'DE VELOPER',s ysdate);
  50   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 76,'MESSAG E_INACTIVA TEDWSUGG_T EXT','The  following  product(s)  have been  inactivat ed. Any fi le #50 ent ries match ed|to thes e products  will be u nmatched.  To continu e to use t he product , the site |must rema tch the lo cal file # 50 entries  to the li sted VA Pr oduct.',nu ll,null,nu ll,null,'D EVELOPER', sysdate,'D EVELOPER', sysdate);
  51   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 77,'MESSAG E_PROPOSED INACTIVATE DWSUGG_TEX T','The fo llowing pr oduct(s) W ILL be ina ctivated i n on the d ate listed . Any file |#50 entri es matched  to these  products w ill be unm atched onc e the prod uct is|ina ctivated.  If a site  wants to c ontinue to  use the p roduct, th e site mus t|rematch  the local  file #50 e ntries to  the listed  VA Produc t.',null,n ull,null,n ull,'DEVEL OPER',sysd ate,'DEVEL OPER',sysd ate);
  52   COMMIT;
  53   --rework s print
  54   insert int o "PPSNEPL "."EPL_NAT IONAL_SETT INGS" ("ID ", "KEY_NA ME", "STRI NG_VALUE",  "INTEGER_ VALUE", "D ECIMAL_VAL UE", "BOOL EAN_VALUE" , "DATE_VA LUE", "CRE ATED_BY",  "CREATED_D TM", "LAST _MODIFIED_ BY", "LAST _MODIFIED_ DTM") valu es(75, 'NA TIONAL_SIT E_NUMBER',  null, 521 , null, nu ll, null,  'DEVELOPER ', sysdate , 'DEVELOP ER', sysda te)
  55   commit;
  56  
  57   --sprint 1 0 6/10/14
  58   insert int o "PPSNEPL "."EPL_NAT IONAL_SETT INGS" ("ID ", "KEY_NA ME", "STRI NG_VALUE",  "INTEGER_ VALUE", "D ECIMAL_VAL UE", "BOOL EAN_VALUE" , "DATE_VA LUE", "CRE ATED_BY",  "CREATED_D TM", "LAST _MODIFIED_ BY", "LAST _MODIFIED_ DTM") valu es(78, 'RE PORT_DATA_ UPDATE_STA RT', null,  null, nul l, null, n ull, 'DEVE LOPER', sy sdate, 'DE VELOPER',  sysdate)
  59   insert int o "PPSNEPL "."EPL_NAT IONAL_SETT INGS" ("ID ", "KEY_NA ME", "STRI NG_VALUE",  "INTEGER_ VALUE", "D ECIMAL_VAL UE", "BOOL EAN_VALUE" , "DATE_VA LUE", "CRE ATED_BY",  "CREATED_D TM", "LAST _MODIFIED_ BY", "LAST _MODIFIED_ DTM") valu es(79, 'RE PORT_DATA_ UPDATE_COM PLETE', nu ll, null,  null, null , null, 'D EVELOPER',  sysdate,  'DEVELOPER ', sysdate )
  60  
  61   commit;
  62  
  63   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 80,'MESSAG E_INACTIVA TEDREMATCH ED_TEXT',' The follow ing produc t(s) have  been inact ivated. An y file|#50  entries m atched to  these prod ucts will  be unmatch ed and rem atched to  the|local  file #50 e ntries lis ted.',null ,null,null ,null,'DEV ELOPER',sy sdate,'DEV ELOPER',sy sdate);
  64   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 81,'MESSAG E_OTHERREM ATCHED_TEX T','The fo llowing pr oduct(s) h ave been u nmatched.  Any file|# 50 entries  matched t o these pr oducts wil l be unmat ched and r ematched t o the|loca l file #50  entries l isted.',nu ll,null,nu ll,null,'D EVELOPER', sysdate,'D EVELOPER', sysdate);
  65   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 82,'MESSAG E_OTHERREM ATCHSUGG_T EXT','The  following  product(s)  have been  edited An y file|#50  entries m atched to  these prod ucts will  be unmatch ed. To con tinue to u se|the pro duct, the  site must  rematch th e local fi le #50 ent ries to th e listed V A Product. ',null,nul l,null,nul l,'DEVELOP ER',sysdat e,'DEVELOP ER',sysdat e);
  66   Insert int o EPL_NATI ONAL_SETTI NGS (ID,KE Y_NAME,STR ING_VALUE, INTEGER_VA LUE,DECIMA L_VALUE,BO OLEAN_VALU E,DATE_VAL UE,CREATED _BY,CREATE D_DTM,LAST _MODIFIED_ BY,LAST_MO DIFIED_DTM ) values ( 83,'MESSAG E_OTHERNOR EMATCH_TEX T','The fo llowing pr oduct(s) h ave been u nmatched.  No alterna tive produ cts|have b een found. ',null,nul l,null,nul l,'DEVELOP ER',sysdat e,'DEVELOP ER',sysdat e);
  67  
  68   commit;