This column present in tables like S_CONTACT, S_ORG_EXT,S_ASSET, S_EVT_ACT,S_OPTY,etc can be used to
exclude certain contacts, accounts, activities, assets, opportunities from being considered for assignment to employees
or to prevent change of assignment.
'Y' value to this column indicates to Assignment Manager that this row should be excluded from assignment evaluation.
If previously assigned, this locks the assignment i.e. the assignment of this object cannot be changed.
Setting to 'N' indicates to Assignment Manager that this row should
be assigned (or re-assigned).
A particular use of this flag in the ePharma application is when we have to consider only contacts(doctors, nurses,
pharmacists) to be assigned to the sales reps.
Since both employee as well as external contacts information is stored in S_CONTACT table, even employees will
be considered for assignment which should not happen
To prevent this we need to set this flag to 'Y' for all records with EMP_FLG='Y'.
1 comments:
Hi Prabhu,
Nice post. I like the example you have given for exclusion.
Any more examples that you can think of ??
Regards,
Nitin Jain
Post a Comment