RTE_PRACTITIONER_ROLE_VIEW (Role View)

This view contains the current record for each user role

Column Description
Practitioner Role ID Primary Key (GUID)
Active Indicates whether this record is active or has been logically deleted.
First Name First name of the User
Last Name Last name of the User
GoSecure Email The user's GoSecure email address
Role Code The role code
Role Name The descriptive name for the role
Program Area The program area this user role is defined for
WOBO Practitioner Role ID FK to the practitioner role this user is working on behalf of
WOBO First Name The first name of the requestor this user is working on behalf of
WOBO Last Name The last name of the requestor this user is working on behalf of
License Info The descriptive name of practitioner type + the licence number. If the user has more than 1 license then they are seperated by the ';' character

Definition