...
Assign episode details to all episodes (Reason, Unit, Type, Admin Date, etc)
Copy personnel from the most recent admission on that patient (since students are generally assigned to the same patient for the duration of JSP.)
The SQL script for this function as it was used for JSP can be found athttps://drive.google.com/file/d/112FsdEOYfdmrdKPOn8UhX3ogrw2P2WH0/view?usp=sharing
...