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