How can I use the Additional tables for Federal Agencies application to support GSA Standard Forms?

[Katie Sorrells]

What are the leading practices for leveraging the Additional tables for Federal Agencies application to support HR Services that require Standard Forms? 

[Pamela Graulich · Accepted solution]

The Federal tables delivered with HRSD is a simple plug in.  The data elements we include in that plugin came directly from FedScope and contain the most popular data elements from OPMs Enterprise Human Resources Integration-Statistical Data Mart.  The intent is to give our Federal customers additional data elements that are frequently used/required in Federal forms to more easily build out Federal HR services.  Best Practices are to install the plugin and leverage it for building out any Federal forms needed for customers.  

[Andre Jones]

Hello @Pamela Graulich , I've installed the Additional Federal agencies plugin. What is the name of the table called?

[Daniel Wilborn]

Hi @Andre Jones !

I've recently installed this myself, and had a bit of trouble getting it to work.  Initially I was receiving the "number of rows restricted by security:20" message.  I had to repair the plugin before the tables would show.  There are 70 tables in total (confirmed in my demo environment and customer environment that this number matches).  Please see attached for the list of tables included.

[CLARENCEBAKER]

Thank you for this!