Name in AssignmentPro: Assignment Resource (view)
Name in Database: vwEQ_ASSIGNMENT_RESOURCE
Description inc. recommended uses and limitations: When you need to reference data from the Resource table, such as First Name, Last Name or Email, it is recommended to use the Assignment Resource (view) the majority of the time. In certain instances, when pulling Resource fields into a user report, the report will output NULL rather than the expected value because the Assignment table is not linked to the Resource table without this view.
Tables used in the view:
ASSIGNMENT
EMPLOYEE
RESOURCE
RESOURCE_ASSIGNMENT
RESOURCE_ROLE_METADATA
Fields contained in the view:
Click here for details on how to create a user report to return all fields for a given name in the database.