• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

E9.2 Competency Summary File

jtheriot

Member
We're doing some discovery on the Competency Module. Users seem to want a summary, basically all the tables with the exception of Goals, in 1 big searchable table so they can use a 3rd party reporting tools (ReportsNow) to create reports off it.

I've only come up with a 20 column table that'd have generic columns outside of RRTY, AN8, CMPC, and Audit Columns. One additional column would be the origin table, the other 11 would be used for unique values within the individual tables. Everything would have to be a string, so that slows down searches, but I'm out of ideas. Has anyone done something like this for this set of tables (F05100, F05111-F05116)? What was your approach?

Thanks,

Jonathan Theriot
 
Top