https://abpnit.freshdesk.com/a/tickets/4522
[3/14 4:01 PM] Jenny Vollmer
She's wanting to add a new Brain Injury Medicine training program. Official ACGME brain Injury training programs are starting to form now. 2023 was the first year that ACGME approved training program fellowships are required in order to take the BIM exam. All of our training programs roll up to a particular type. If you look at the table TrainingProgramType, we need to establish Brain Injury Medicine as a type (add a row). I had to add Neurocritical Care in 10/2023. So you can add it similarly. The column AMASPecialtyCode contains the training program # prefix that ACGME that will be the same for all BIM programs and is assigned by the ACGME. I assume based on Carms ticket that the prefix is 347. Can you confirm that with Carm? After she confirms, then you can add the row, which will allow her to add the program herself.
[3/14 4:03 PM] Jenny Vollmer
BTW - for you own knowledge, the column name AMASpecialtyCode is incorrectly named. It's really the ACGMESpecialtyCode. But, we just ignore that
[3/15 5:28 PM] Jenny Vollmer
Varden LaPanHi Varden. Just FYI that I believe this table needs an insert as well for BIM after you insert to TrainingProgramType:Ok, I'll check with her on that. I was able to track down the error in the log table and it matches up with what you've said - the error says "No matching training program type found".
select * from CertificationTrainingProgramType
[3/15 5:37 PM] Varden LaPan
Ok, thanks for letting me know. It seems that after pushing the application through several duplicate entries showed up in the Subspecialty Training section, and Carm wasn’t able to access them.[3/15 5:48 PM] Jenny Vollmer
Yes, we have a know bug in production. I have that on my radar to investigate. Here's an example for an AP application. The saved date/times are all slightly different, so some activity in the portal is causing this. I don't believe it's at al related to your helpdesk ticket.
select * from SubspecialtyTraining
where person_key = 197141