E9.2 Competency Summary File


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?


Jonathan Theriot