I am updating a query that is used in a portal. The users need to filter on the Employee Type. I am looking for that field name.
Try these lookups:
1. Lookup ID: SRM_RESOURCE_TYPE
2. Lookup ID: prResourceType
Add cmn_lookups_v to your nsql and specify the lookup_type as to one of these...get the name value from this view.
It is the srm_resources.person_type field. If you are looking to filter on this field in one of the views, it appears as the Person Type field.
If you see Administration > Objects > Resource object > Attributes, search for Person Type
Lookup - Number
Retrieving data ...