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 there a SQL to get EIN/TIN for Legal Entities?

in Reporting and Analytics for HCM 10 comments

Summary:

Rather than have to navigate to individual legal entities to find the EIN/TIN assigned (which is cumbersome), I would like to run a report for my Legal Entities to see this data.

Content (please ensure you mask any confidential information):

I cannot find reference to these fields in OTBI (believe there is an idea lab for FEIN), and I've tried running SQL on different HR_ORGANIZATION tables, but I can't find what fields in which table this data is stored in so I can get a report for my Legal Entities. Is this possible?

Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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