Definition

The Admin_UserInRole extract represents the clinical and administrative staff members associated with a healthcare organisation in EMIS Web. Each record captures a person-role pairing — the same individual can appear in multiple roles or across multiple organisations — along with their job category, contract dates, and registration number.

Information

The Admin_UserInRole extract is the reference source for all staff-level attribution across the IM1 feed. Clinical tables such as consultations, observations, and prescriptions reference userinroleguid as the key to identify the responsible or entering clinician.

Each record is uniquely identified by userinroleguid within the agreement scope.

Key Identifiers

• userinroleguid: The unique EMIS identifier for this user-in-role instance.
• organisationguid: References the practice this role is attached to.
• registrationnumber: The clinician’s professional registration number (e.g., GMC number for GPs).

Personal Details

• title, givenname, surname: Name components of the staff member.

Role and Job Category

• jobcategorycode: Coded value for the job category (e.g., GP, Practice Nurse, Admin).
• jobcategoryname: Human-readable label for the job category.

Contract Dates

• contractstartdate: The date the person started in this role at the organisation.
• contractenddate: The date the role ended, if applicable. Null indicates an active role.

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Clinician Name"]
    n2["Role & Grade"]
    n3["ODS Code & Dates"]
  end

  n17["GP Practice 1"] --> container
  n18["GP Practice 2"] --> container
  n19["GP Practice 3"] --> container

  container --> n16["Gather user-in-role data"]
  n16 --> n14["ETL"]
  n14 --> n15["Admin_UserInRole Model"]