RTE_PRACTITIONER_ROLE (User Role)
A FlexForm User can have one or many Roles in the FlexForm application. The User Role data is stored in the PractitionerRole Resource
| Column | FHIR Source | Description |
|---|---|---|
| Practitioner_Role_ID | PractitionerRole.id | Primary Key (GUID) |
| Request Version | PractitionerRole.Meta.versionId | The Version of the Patient. Each modification to a Patient increments the version |
| Current Record | n/a | Flag that this record is latest version. 1 = Yes, 2 = No |
| Last Updated Date | PractitionerRole.Meta.lastUpdated | The date and time(EST) the request was last updated |
| Active | PractitionerRole.active | Whether this user is active, yes/no |
| Practitioner_ID | PractitionerRole.practitioner | This is a foriegn key to RTE_PRACTITIONER. This is the user that is associated with this role. |
| Role_Code | PractitionerRole.code | This is the role code. It is also a foriegn key to the RTE_CODE_TABLE_LOOKUP table, which is where the description is stored. |
| Working_On_Behalf_Of | PractitionerRole.extension:RelatedRequestorRole | This is a foriegn key to the RTE_PRACTITIONER_ROLE table. This links to the Requestor role that this role is working on behalf of. Most Health Care Professionals(HCP) have staff that will out the forms on behalf of the HCP. |