Hello Bret,
A canonical version of the query NextDSubTable1.sql is available at: https://github.com/kumc-bmi/nextd-study-support/tree/master/Oracle_impl It does have global temporary table requirements which can be instantiated by the code in "init_Oracle_temp_tables_ddl.sql" found in the same directory. The resultant data in "SubTable1_for_export" will have to exported and uploaded to REDCap. Mei will have to provide the details for that. Best regards, Alex Stoddard Programmer/Analyst Biomedical Informatics Clinical & Translational Science Institute Medical College of Wisconsin astodd...@mcw.edu (414) 805-7239 -------------------------------------------------- UL1 TR001436, TL1 TR001437, KL2 TR001438 CITE it - You can ensure our resources are available for all future research. Simply cite the NIH CTSA. _______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev