All

I am in the process of creating a Business Area to satisfy a series of reports all around HR. I want to ensure that the inherrant security is maintained in what I create... My question is, what views etc do I need to look at? Should I refer to the ones in the forms themselves?

Nige

Assuming you're using seeded HR security of some sort, using any of the secured views (per_people_f, per_assignments_f, etc) will maintain your security.

I avoid using the forms views as they're built for the forms and can change unexpectdly.

I've used custom views for this recently - we used base tables and secured the data in the views using seeded security functions: Hr_General.get_business_group_id to make sure we get data for the right business group and use the hr_security package view_all and show_person functions (both return 'TRUE' or 'FALSE') to make sure the data is available to the current responsibility.