You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is it possible to write a query to pull back the number of EFF columns on recruiting tables?

in Recruiting, Opportunity Marketplace 2 comments

Summary: We have a need to write a query to build a report to monitor the amount of recruiting EFFs created and the number of recruiting EFFs left on tables like "PER_PEOPLE_EXTRA_INFO_F". Trying to build a way to audit what has been used and what is still available to be used for future recruiting requests.

Example: The PER_PEOPLE_EXTRA_INFO_F has room for the following number of EFFs by type.

·      30 VARCHAR Type

·      20 NUMBER Type

·      15 DATE Type

Is it possible to build a query to return the number of EFFs created on the PER_PEOPLE_EXTRA_INFO_F table, by type?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!