medhi01 contains only medication code and not name

[tashrifbillah]

We need to supply full medication names:

utility/nda-transform/medhi01.py

Line 86 in 5d362d9

med=get_value(f'chrpharm_med{j}_name_past',f'{event}_arm_{arm}')

[tashrifbillah]

This is the REDCap mapping:

714, acetyl-L-carnitine/ALC/carnitine_VITAMIN/SUPPLEMENT_714
712, alpha lipoic acid/lipoic acid_VITAMIN/SUPPLEMENT_712
286, alprazolam/Xanax_BENZODIAZEPINE_286
448, alprazolam/Xanax XL_BENZODIAZEPINE_448
18, amantadine/Symmetrel_OTHER_18
705, amino acids/branched-chain amino acids_VITAMIN/SUPPLEMENT_705
238, amisulpride/Solian_ANTIPSYCHOTIC_238
20, amitriptyline/Elavil/Endep_ANTIDEPRESSANT_20
110, amitriptyline perphenazine/Etrafon/Etrafon Forte/Triavil_ANTIPSYCHOTIC_110
146, amitriptyline+ chlordiazepoxide/Limbitrol*_ANTIDEPRESSANT_146
24, amobarbital/Amytal_OTHER_24
34, amoxapine/Asendin_ANTIDEPRESSANT_34
548, amoxicillin/Amoxil_ANTIBIOTIC_548
444, ANTIDEPRESSANT BUT NAME UNKNOWN_SPECIAL CODE_444
525, antihistamines: Benadryl Allergy Sinus, cetirizine/Zyrtec, Chlor-Trimeton, desloratadine/Clarinex, Dimetane, fexofenadine/Allegra, levocetirizine/Xyzal, loratadine/Claritin, Semprex-D, pseudoephedrine/Sudafed, Tavist, Tylenol Allergy Sinus, Zyytec-D_ALLERGY/COLD_525
715, antioxidant_VITAMIN/SUPPLEMENT_715
333, ANTIPSYCHOTIC BUT NAME UNKNOWN_SPECIAL CODE_333
305, aripiprazole/Abilify_ANTIPSYCHOTIC_305
725, aripiprazole/Abilify ACUTE INJECTION_ANTIPSYCHOTIC_725
547, aripiprazole LAI/Abilify Maintena_ANTIPSYCHOTIC_547
723, aripiprazole lauroxil LAI/Aristada_ANTIPSYCHOTIC_723
568, armodafanil/Nuvigil_MISC. PSYCHOTROPIC_568
530, asenapine/Saphris_ANTIPSYCHOTIC_530
729, asenapine patch/Secuado_ANTIPSYCHOTIC_729
501, Aspirin_NSAID/ANTIINFLAMMATORY_501
41, atenolol/Tenormin_OTHER_41
418, atomoxetine/Strattera_MISC. PSYCHOTROPIC_418
553, azithromycin/Zithromax/Z-Pack_ANTIBIOTIC_553
557, aztreonam/Azactam/Cayston_ANTIBIOTIC_557
601, benzphetamine/Didrex_DIET PILL_601
74, benztropine/Cogentin_OTHER_74
708, biotin/vitamin B7_VITAMIN/SUPPLEMENT_708
413, biperiden/Akineton_OTHER_413
48, birth control pills/patch_OTHER_48
456, brexanolone/Zulresso_ANTIDEPRESSANT_456
574, brexpiprazole/Rexulti_ANTIPSYCHOTIC_574
52, bupropion/Wellbutrin_ANTIDEPRESSANT_52
428, bupropion/Wellbutrin SR/Wellbutrin XL_ANTIDEPRESSANT_428
411, buspirone/Buspar_NONBENZO ANXIOLYTIC_411
56, butabarbital/Buticaps/Butisol_OTHER_56
521, calcium_VITAMIN/SUPPLEMENT_521
576, Cannabidiol_MISC. PSYCHOTROPIC_576
250, carbamazepine/Tegretol/Atretol/Carbatrol/Epitrol_MOOD STABILIZER_250
721, cariprazine/Vraylar_ANTIPSYCHOTIC_721
552, cefaclor/Ranicor_ANTIBIOTIC_552
550, cefadroxil/Duricef_ANTIBIOTIC_550
551, cefazolin/Ancef/Kefzol_ANTIBIOTIC_551
516, celecoxib/Celebrex_NSAID/ANTIINFLAMMATORY_516
66, chloral hydrate/Aquachloral/Noctec_OTHER_66
144, chlordiazepoxide/Librium/Libritabs_BENZODIAZEPINE_144
260, chlormezanone/Trancopal_OTHER_260
256, chlorpromazine/Thorazine_ANTIPSYCHOTIC_256
257, chlorpromazine/Thorazine ACUTE INJECTION_ANTIPSYCHOTIC_257
248, chlorprothixene/Taractan_ANTIPSYCHOTIC_248
303, citalopram/Celexa_ANTIDEPRESSANT_303
554, clarithromycin/Biaxin/Biaxin XL_ANTIBIOTIC_554
528, clobazam/Urbanol/Frisium_BENZODIAZEPINE_528
26, clomipramine/Anafranil_ANTIDEPRESSANT_26
68, clonazepam/Klonopin_BENZODIAZEPINE_68
62, clonidine/Catapres_MISC. PSYCHOTROPIC_62
264, clorazepate/Tranxene_BENZODIAZEPINE_264
69, clozapine/Clozaril_ANTIPSYCHOTIC_69
541, codeine_OTHER_541
606, conjugated linolenic acids/Tonalin_DIET PILL_606
524, corticosteroids: betamethasone/Celestone, Cortisone, dexamethasone/Dexamethasone Intensol/DexPak, methylprednisolone/Medrol, Depo-Medrol, Solu-Medrol, prednisolone/Orapred/Prelone, prednisone/Prednisone Intensol, triamcinolone/Aristospan Intra-articular/Aristospan Intralesional/Kenalog_STEROID_524
92, Deprol_OTHER_92
196, desipramine/Norpramin/Pertofrane_ANTIDEPRESSANT_196
543, desvenlafaxine/Pristiq_ANTIDEPRESSANT_543
434, dexmethylphenidate/Focalin_STIMULANT_434
401, dextroamphetamine/Dexedrine_STIMULANT_401
400, dextroamphetamine ++/Adderall ++_STIMULANT_400
276, diazepam/Valium_BENZODIAZEPINE_276
509, diclofenac/Voltaren_NSAID/ANTIINFLAMMATORY_509
604, diethylpropion/Tenuate_DIET PILL_604
503, diflunisal/Dolobid_OTHER_503
443, diltiazem/Cardizem/Cartia XT/Dilacor XR/Diltia XT/Tiamate/Tiazac_OTHER_443
46, diphenhydramine/Benadryl/Cope/Compoz/Nytol/Sleep Eze/Sominex/Nervine_ALLERGY/COLD_46
91, divalproex/Depakote_MOOD STABILIZER_91
446, divalproex/Depakote ER_MOOD STABILIZER_446
12, doxepin/Sinequan/Adapin_ANTIDEPRESSANT_12
563, doxycycline/Vibramycin_ANTIBIOTIC_563
403, droperidol/Inapsine_ANTIPSYCHOTIC_403
727, droperidol/Inapsine ACUTE INJECTION_ANTIPSYCHOTIC_727
539, D-serine or placebo (Blinded)_SPECIAL CODE_539
450, duloxetine/Cymbalta_ANTIDEPRESSANT_450
517, EPA_VITAMIN/SUPPLEMENT_517
518, EPA+DHA/fish oil/omega-3 fatty acids_VITAMIN/SUPPLEMENT_518
558, ertapenem/Invanz_ANTIBIOTIC_558
427, escitalopram oxalate/Lexapro_ANTIDEPRESSANT_427
457, esketamine/Spravato_ANTIDEPRESSANT_457
416, estazolam/ProSom_BENZODIAZEPINE_416
535, eszopiclone/Lunesta_BENZODIAZEPINE_535
218, ethchlorvynol/Placidyl_OTHER_218
513, etodolac/Lodine_NSAID/ANTIINFLAMMATORY_513
556, flumequine/Flubactin, telithromycin/Ketek_ANTIBIOTIC_556
566, flumequine/Flubactin_ANTIBIOTIC_566
116, fluoxetine/Prozac/Symbyax*_ANTIDEPRESSANT_116
573, fluoxetine vs aripiprazole (Blinded)_SPECIAL CODE_573
220, fluphenazine/Prolixin/Permitil_ANTIPSYCHOTIC_220
222, fluphenazine LAI/Prolixin Decanoate_ANTIPSYCHOTIC_222
80, flurazepam/Dalmane_BENZODIAZEPINE_80
404, fluvoxamine/Luvox_ANTIDEPRESSANT_404
706, folate/folic acid_VITAMIN/SUPPLEMENT_706
307, gabapentin/Neurontin_NONBENZO ANXIOLYTIC_307
570, galantamine/Razadine_MISC. PSYCHOTROPIC_570
571, galantamine ER/Razadine ER_MISC. PSYCHOTROPIC_571
102, glutethimide/Doriden_OTHER_102
519, glycine_VITAMIN/SUPPLEMENT_519
447, guanfacine/Tenex_MISC. PSYCHOTROPIC_447
567, guanfacine extended release/Intuniv_MISC. PSYCHOTROPIC_567
419, halazepam/Paxipam_BENZODIAZEPINE_419
122, haloperidol/Haldol_ANTIPSYCHOTIC_122
123, haloperidol/Haldol ACUTE INJECTION_ANTIPSYCHOTIC_123
124, haloperidol LAI/Haldol Decanoate_ANTIPSYCHOTIC_124
607, Hoodia_DIET PILL_607
280, hydrocodone+ acetaminophen/Vicodin*_OTHER_280
38, hydroxyzine/Atarax/Vistaril_ALLERGY/COLD_38
424, Hypericum perforatum/St. John's Wort/St. John's Grass/Klamath Weed_VITAMIN/SUPPLEMENT_424
504, ibuprofen/Advil/Motrin_NSAID/ANTIINFLAMMATORY_504
532, iloperidone/Fanapt_ANTIPSYCHOTIC_532
130, imipramine/Tofranil_ANTIDEPRESSANT_130
258, imipramine pamoate/Tofranil P.M._ANTIDEPRESSANT_258
510, indomethacin/Indocin_NSAID/ANTIINFLAMMATORY_510
156, isocarboxazid/Marplan_ANTIDEPRESSANT_156
526, isotretinoin/Accutane_OTHER_526
559, kanamycin/Kantrex_ANTIBIOTIC_559
505, ketoprofen/Orudis_NSAID/ANTIINFLAMMATORY_505
514, ketorolac/Toradol_NSAID/ANTIINFLAMMATORY_514
415, lamotrigine/Lamictal_MOOD STABILIZER_415
291, lemborexant/Davvigo_BENZODIAZEPINE_291
438, levetiracetam/Keppra_MISC. PSYCHOTROPIC_438
569, levomilnacipran/Fetzima_ANTIDEPRESSANT_569
422, levothyroxine sodium/Levotabs/Levothroid/Levoxyl/Synthroid/Unithyroid_OTHER_422
421, liothyronine sodium/Cytomel_OTHER_421
430, liotrix/Thyrolar_OTHER_430
537, lisdexamfetamine/Vyvanse_STIMULANT_537
106, lithium carbonate/Eskalith/Lithonate/Lithane/Lithobid_MOOD STABILIZER_106
40, lorazepam/Ativan_BENZODIAZEPINE_40
150, loxapine/Loxitane_ANTIPSYCHOTIC_150
151, loxapine/Loxitane ACUTE INJECTION_ANTIPSYCHOTIC_151
703, L-theanine/Theanine_VITAMIN/SUPPLEMENT_703
138, L-tryptophan_ANTIDEPRESSANT_138
728, lumateperone/Caplyta_ANTIPSYCHOTIC_728
540, lurasidone/Latuda_ANTIPSYCHOTIC_540
716, magnesium_VITAMIN/SUPPLEMENT_716
154, maprotiline/Ludiomil_ANTIDEPRESSANT_154
777, MEDICATION BUT NAME UNKNOWN_SPECIAL CODE_777
423, melatonin_VITAMIN/SUPPLEMENT_423
545, meloxicam/Mobic_NSAID/ANTIINFLAMMATORY_545
86, meperidine/Demerol_OTHER_86
160, meprobamate/Miltown/Equanil/Meprospan_OTHER_160
164, Meprotabs_OTHER_164
406, mesoridazine/Serentil_ANTIPSYCHOTIC_406
11, mesoridazine/Serentil ACUTE INJECTION_ANTIPSYCHOTIC_11
170, methadone/Dolophine_OTHER_170
436, methimazole/Tapazole_OTHER_436
405, methotrimeprazine/Levoprome_ANTIPSYCHOTIC_405
228, methylphenidate/Ritalin/Methylin_STIMULANT_228
453, methylphenidate patch/Daytrana_STIMULANT_453
426, methylphenidate XR/Concerta/Metadate/Biphentin_STIMULANT_426
192, methyprylon/Noludar_OTHER_192
148, metoprolol/Lopressor/Toprol_OTHER_148
718, mineral supplement_VITAMIN/SUPPLEMENT_718
562, minocycline/Minocin_ANTIBIOTIC_562
407, mirtazapine/Remeron_ANTIDEPRESSANT_407
437, modafinil/Provigil_MISC. PSYCHOTROPIC_437
178, molindone/Moban_ANTIPSYCHOTIC_178
555, MOOD STABILIZER BUT NAME UNKNOWN_SPECIAL CODE_555
180, morphine_OTHER_180
701, Multivitamin_VITAMIN/SUPPLEMENT_701
506, nabumetone/Relafen_NSAID/ANTIINFLAMMATORY_506
704, NAC/N-acetyl cysteine_VITAMIN/SUPPLEMENT_704
440, nadolol/Corgard_OTHER_440
508, naproxen/Aleve/Naprosyn_NSAID/ANTIINFLAMMATORY_508
306, nefazodone/Serzone_ANTIDEPRESSANT_306
560, neomycin/Mycifradin/Myciguent_ANTIBIOTIC_560
707, niacin/nicotinic acid/vitamin B3_VITAMIN/SUPPLEMENT_707
888, NO INFORMATION_SPECIAL CODE_888
999, NO MEDS_SPECIAL CODE_999
166, nomifensine/Merital_ANTIDEPRESSANT_166
204, nortriptyline/Aventyl/Pamelor_ANTIDEPRESSANT_204
201, olanzapine/Zyprexa/Symbyax/Lybalvi _ANTIPSYCHOTIC_201
726, olanzapine/Zyprexa ACUTE INJECTION_ANTIPSYCHOTIC_726
720, olanzapine LAI/Relprevv_ANTIPSYCHOTIC_720
542, omega-3 or placebo (Blinded)_SPECIAL CODE_542
529, opioids, opiates, or combination drugs like Percocet_OTHER_529
515, oxaprozin/Daypro_NSAID/ANTIINFLAMMATORY_515
234, oxazepam/Serax_BENZODIAZEPINE_234
414, oxcarbazepine/Trileptal_MOOD STABILIZER_414
527, oxycodone/Oxycontin_OTHER_527
531, paliperidone/Invega_ANTIPSYCHOTIC_531
546, paliperidone palmitate LAI/Invega Sustenna_ANTIPSYCHOTIC_546
722, paliperidone palmitate LAI/Invega Trinza_ANTIPSYCHOTIC_722
108, pargyline/Eutonyl_ANTIDEPRESSANT_108
207, paroxetine/Paxil_ANTIDEPRESSANT_207
445, paroxetine/Paxil CR_ANTIDEPRESSANT_445
429, pemoline/Cylert/PemADD_STIMULANT_429
549, penicillin/Pen-VK_ANTIBIOTIC_549
188, pentobarbital/Nembutal_OTHER_188
270, perphenazine/Trilafon_ANTIPSYCHOTIC_270
271, perphenazine/Trilafon ACUTE INJECTION_ANTIPSYCHOTIC_271
605, phendimetraine/Bontril_DIET PILL_605
182, phenelzine/Nardil_ANTIDEPRESSANT_182
216, phenobarbital/Bellatal/Solfoton_OTHER_216
603, phentermine/Adipex-P/Fastin_DIET PILL_603
98, phenytoin/Dilantin_OTHER_98
408, pimozide/Orap_ANTIPSYCHOTIC_408
441, pindolol/Visken_OTHER_441
507, piroxicam/Feldene_NSAID/ANTIINFLAMMATORY_507
454, pitolisant/Wakix_MISC. PSYCHOTROPIC_454
64, prazepam/Centrax_BENZODIAZEPINE_64
719, prazosin/Minipress_NONBENZO ANXIOLYTIC_719
575, pregabalin/Lyrica_NONBENZO ANXIOLYTIC_575
75, prochlorperazine/Compazine_ANTIPSYCHOTIC_75
76, prochlorperazine/Compazine ACUTE INJECTION_ANTIPSYCHOTIC_76
242, promazine/Sparine_ANTIPSYCHOTIC_242
82, propoxyphene/Darvon/Darvocet_OTHER_82
132, propranolol/Inderal_OTHER_132
435, propylthiouracil/PTU/Propylthiour_OTHER_435
284, protriptyline/Vivactil_ANTIDEPRESSANT_284
666, PSYCHOSTIMULANT BUT NAME UNKNOWN_SPECIAL CODE_666
420, quazepam/Doral_BENZODIAZEPINE_420
235, quetiapine/Seroquel_ANTIPSYCHOTIC_235
300, risperidone/Risperdal_ANTIPSYCHOTIC_300
425, risperidone LAI/Risperdal Consta_ANTIPSYCHOTIC_425
452, risperidone SC LAI/Perseris_ANTIPSYCHOTIC_452
561, rosoxacin/Eradacil_ANTIBIOTIC_561
502, salsalate/Amigesic_NSAID/ANTIINFLAMMATORY_502
232, secobarbital/Seconal/Tuinal_OTHER_232
402, selegiline/Atapryl/Carbex/Eldepryl_MISC. PSYCHOTROPIC_402
713, selenium_VITAMIN/SUPPLEMENT_713
409, sertindole/Serdolect_ANTIPSYCHOTIC_409
290, sertraline/Zoloft_ANTIDEPRESSANT_290
602, sibutramine/Meridia_DIET PILL_602
60, sodium pentobarbital/Carbrital_OTHER_60
455, solriamfetol/Sunosi_MISC. PSYCHOTROPIC_455
511, sulindac/Clinoril_NSAID/ANTIINFLAMMATORY_511
251, temazepam/Restoril_BENZODIAZEPINE_251
564, tetracycline/Sumycin_ANTIBIOTIC_564
158, thioridazine/Mellaril_ANTIPSYCHOTIC_158
184, thiothixene/Navane_ANTIPSYCHOTIC_184
431, thyroglobulin_OTHER_431
432, thyroid hormone/Armour thyroid/Thyroid strong/Thyrar/SPT_OTHER_432
449, tiagabine/Gabatril_NONBENZO ANXIOLYTIC_449
565, tigecycline/Tygacil_ANTIBIOTIC_565
442, timolol/Blocadren_OTHER_442
512, tolmetin/Tolectin_NSAID/ANTIINFLAMMATORY_512
433, topiramate/Topamax_MISC. PSYCHOTROPIC_433
206, tranylcypromine/Parnate_ANTIDEPRESSANT_206
266, trazodone/Desyrel_ANTIDEPRESSANT_266
120, triazolam/Halcion_BENZODIAZEPINE_120
244, trifluoperazine/Stelazine_ANTIPSYCHOTIC_244
245, trifluoperazine/Stelazine ACUTE INJECTION_ANTIPSYCHOTIC_245
410, triflupromazine/Vesprin_ANTIPSYCHOTIC_410
13, triflupromazine/Vesprin ACUTE INJECTION_ANTIPSYCHOTIC_13
32, trihexyphenidyl/Artane_OTHER_32
246, trimipramine/Surmontil_ANTIDEPRESSANT_246
272, tryptophan _VITAMIN/SUPPLEMENT_272
90, valproic acid/Depakene_MOOD STABILIZER_90
412, venlafaxine/Effexor_ANTIDEPRESSANT_412
439, venlafaxine/Effexor XR_ANTIDEPRESSANT_439
536, verapamil/Calan/Covera HS/Isoptin/Verelan _OTHER_536
544, vilazodone/Viibryd_ANTIDEPRESSANT_544
709, vitamin B complex_VITAMIN/SUPPLEMENT_709
711, vitamin C_VITAMIN/SUPPLEMENT_711
702, vitamin D_VITAMIN/SUPPLEMENT_702
710, vitamin E_VITAMIN/SUPPLEMENT_710
572, vortioxetine/Brintellix_ANTIDEPRESSANT_572
451, zaleplon/Sonata_BENZODIAZEPINE_451
717, zinc_VITAMIN/SUPPLEMENT_717
304, ziprasidone/Geodon_ANTIPSYCHOTIC_304
724, ziprasidone/Geodon ACUTE INJECTION_ANTIPSYCHOTIC_724
538, ziprasidone/Geodon or placebo (Blinded)_SPECIAL CODE_538
417, zolpidem/Ambien_BENZODIAZEPINE_417
533, zopiclone/Imovane_BENZODIAZEPINE_533
534, zopiclone/Zimovane_BENZODIAZEPINE_534
730, Masculinizing hormone treatment_730
731, Feminizing hormone treatment_731
732, Puberty blockers_732
577, Lybalvi*/Samidorphan_577
292, Dardiorexant/Quviviq_292