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.
# | 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 |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 3 | 132 |
Changed | 2 | 4 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
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 |
No regular expressions were active.
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; |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.