Report to show which assignment profile rule(s) apply to a user

[JacobB]

We have some assignment profiles with many rules. There are ways for us to see/report on which users are included in an assignment profile, but sometimes it can be challenging to determine which rule(s) a user applies to.

I would really like to know if its possible to create a report through PRD that would show for an assignnment profile:

1) Which users are included in the Assignment Profile

2) Which rule(s) in the assignment profile are qualifying the user

Looking at the Data Dictionary I"m not seeing anything that would link the user to the AP rule, but was hoping someone might have some insight on any tables/attributes that might accomplish what I"m lookingn for.

This would be a huge help for us!

Thanks and appreciate your time.

[Romanin]

Hi @JacobB , hope you`re doing well

A long time there is a topic that could be help you >> Solved: Re: Assignment Profile - User List (CSV) - SAP Community
As archived post, the files shared don`t be there, so I`ll advise you to contact the person on the tread and check if they can send the ZIP file to you.

I hope this helps
Regards
Daniel Romanin

* Please consider mark this answer as solution if your question was properly answered 😅

[Romanin]

Adding more information regarding the tables for Assignment Profiles >>

ASSIGNMENT PROFILES:

PA_ASSGN_PRFL – Assignment Profile record information and job_id (PH – History table available)

To tell via DB if an AP is propagated, you need to check PA_ASSGN_PRFL to see if it has a job_id.

Any entities an AP is to assign will be in their respective tables:

•ITEM - CPNT  (PA_CPNT_AP)

•CURRICULA - QUAL –  (PA_QUAL_AP)

•CATALOG – (PA_CATALOG_AP)

•PROGRAMS (PA_PROGRAM_AP)

•ROLES (PA_ROLE_AP)

•PA_STUD_ASSGN_PRFL to show all users that were ever in an AP (PH table will show the history)

•PA_AP_ASSOC_ATTR …tables manage Rules and attributes used by APs – DOMAIN, ATTRIBUTE etc.

•PA_AP_CHANGES – AP changes

•PA_AP_ATTRIBUTE – filters like User Id, Active, Domain

•PA_AP_DOMAIN – domains associated with each AP

•PA_AP_ATTR_VAL – AP attribute values

•PA_AP_STUD_CHANGES – shows users history of Aps they have been in / removed from (ACTION col.)