SAM People Data Connector

The SAM People Data Connector provides you with your SAM People data alongside your Arbor MIS data from the BI Connector. This means that you can analyse turnover, mobility, absence, and salary information in combination with your MIS data. It will appear alongside your regular BI Connector data under the ARBOR_DATA_CONNECTOR_PRODUCTION schema.

What data is included?

The Data Connector includes data on Establishments (which link to Arbor schools via an application_id), Employee, Absence, Employee Contracts, Employee Contact Allowances, and Employee Contract Salaries. See the full list of datasets attached at the bottom of this article.

How do I access this data?

If you have the BI Connector, you can access this data by contacting your account owner. The data will then be added to your account.

The data can be found here:

  • Warehouse - FEPS_BI_GENERAL
  • Database - ARBOR_DATACONNECTOR_PRODUCTION
  • Schema - SAM_PEOPLE
Was this article helpful?
0 out of 0 found this helpful
I'm still stuck!

Comments

0 comments

Please sign in to leave a comment.