#9333: Reporting - Add missing field: Staff: Home email, External IDs, Unit PositionsΒΆ

Support Ticket(s): ION-2753

All staff (workforce) data sources in reporting tool are now have these default fields:
  • Staff ID
  • Staff Payroll ID
  • Staff External ID
  • Staff Other External ID
  • Staff Preferred Name
  • Staff First Name
  • Staff Last Name
  • Staff PrefName LastName
  • Staff FirstName LastName
  • Staff LastName,PrefName
  • Staff LastName,FirstName
  • Staff Active Status
  • Staff Email Address
  • Staff Mobile
  • Staff Home Phone
  • Staff Home Email Address
  • Staff Work Phone
  • Org Unit Code
  • Org Unit Name
  • Org Unit Abbrev
  • Org Unit Desc
  • Position Code
  • Position Name
  • Position Allocation Date


In order to keep the system consistence, all TPP (community) data sources in reporting tool are now have these default fields:
  • TPP ID
  • TPP External ID
  • TPP UHI ID
  • TPP Other External ID
  • TPP Preferred Name
  • TPP First Name
  • TPP Last Name
  • TPP PrefName LastName
  • TPP FirstName LastName
  • TPP LastName,PrefName
  • TPP LastName,FirstName
  • TPP Active Status
  • TPP Email Address
  • TPP Mobile
  • TPP Home Phone
  • TPP Work Phone
  • Type ID
  • Type Name
  • Facility Code
  • Facility Name