# HRIS

> Part of the NocoDB documentation (Product docs > Sync > App Sync). Index of all pages: https://nocodb.com/llms.txt. Any docs page is available as Markdown by adding `.md` to its URL.

URL: https://nocodb.com/docs/product/sync/app-sync/hris
Last updated: 2026-09-25

Bring employee data from your HR system into NocoDB with automated syncs.

HRIS Sync enables you to import employee, employment, and location information from your Human Resources Information System. It follows a predefined schema that standardizes HR data across systems, so you can build headcount reports, org views, and people dashboards on top of always-current information.

Current supported sources include:

* BambooHR

You may choose to sync **all tables** in the HRIS schema or **only specific tables**. Syncing all tables provides full context and complete relationships, while syncing selected tables helps reduce sync time and resource usage based on your workflow needs.

## Available Tables

Each table is mapped to a well-defined set of fields to maintain a unified structure. App Sync also includes relational fields that connect these tables as required. The Employee table is essential and always included, while Employment and Location tables are optional.

### **HR\_Employee**

Represents the core people directory — one record per employee.
**Key fields include:**

* **Employee Number** – Unique identifier from the source system.
* **First Name / Last Name / Preferred Name** – The employee's names.
* **Work Email / Personal Email** – Email addresses on record.
* **Mobile Phone Number** – Contact number.
* **Department / Team** – Organizational placement.
* **Manager** – The employee's reporting manager.
* **Employment Status** – Current status such as Active or Terminated.
* **Start Date / Termination Date** – Employment boundary dates.
* **Date Of Birth / Gender / Marital Status / Ethnicity** – Personal details where the source provides them.
* **Avatar** – Link to the employee's profile image.

Employees are linked to **Employment** and **Location** records where those tables are synced.

### **HR\_Employment**

Represents employment engagements — role and compensation details for an employee.
**Key fields include:**

* **Job Title** – The employee's role.
* **Employment Type** – Such as full-time, part-time, or contract.
* **Effective Date** – When this engagement took effect.
* **Pay Rate / Pay Period / Pay Frequency / Pay Currency** – Compensation details.
* **FLSA Status** – Exempt or non-exempt classification.

Each Employment record links back to its **Employee**.

### **HR\_Location**

Represents work locations referenced by employee records.
**Key fields include:**

* **Name** – Location name.
* **Location Type** – Such as office or remote.
* **Street 1 / Street 2 / City / State / Zip Code / Country** – Address details.
* **Phone Number** – Location contact number.

Locations are linked to the **Employees** based there.

## Metadata Fields

Each synced table in the HRIS category includes a set of metadata fields that track the lifecycle, state, and origin of every record. These fields provide transparency into how data flows from the external source into NocoDB and play an essential role in traceability, debugging, and audit requirements.

These metadata fields are automatically managed by App Sync and are read-only.

* **RemoteId**
  Unique identifier of the record in the external source system.

* **RemoteCreatedAt**
  Timestamp of when the record was originally created in the source.

* **RemoteUpdatedAt**
  Timestamp of the most recent update made in the source.

* **RemoteDeleted**
  Indicates whether the record has been deleted in the source platform.
  This is used especially when the delete behaviour is set to **Ignore**.

* **RemoteDeletedTime**
  Timestamp of when the record was deleted in the source, if applicable.

* **RemoteRaw**
  Stores the raw payload received from the provider for that record.
  Useful for troubleshooting, verification, or advanced integrations.

* **RemoteNamespace**
  Identifies the origin company or account in the HR system.

* **RemoteSyncedAt**
  Last timestamp when NocoDB synced this specific record.

* **SyncConfigId**
  Internal reference to the sync configuration used for this record.

* **SyncRunId**
  Identifies the specific sync execution run that last updated this record.

* **SyncProvider**
  Indicates which external service (such as BambooHR) the record originated from.

## Availability

* App Sync is available on **NocoDB Cloud** (Plus plan and above) and licensed self-hosted deployments (Business plan and above).

---

## Related pages

- [Ticketing](https://nocodb.com/docs/product/sync/app-sync/ticketing.md): Bring ticketing data from popular platforms into NocoDB with automated syncs.
- [CRM](https://nocodb.com/docs/product/sync/app-sync/crm.md): Bring customer and contact data from your CRM into NocoDB with automated syncs.
- [File Storage](https://nocodb.com/docs/product/sync/app-sync/file-storage.md): Bring file and folder metadata from cloud storage platforms into NocoDB with automated syncs.
- [Calendar](https://nocodb.com/docs/product/sync/app-sync/calendar.md): Bring your calendar events into NocoDB with automated syncs from Google Calendar, Outlook Calendar, and CalDAV.
- [Custom Sync](https://nocodb.com/docs/product/sync/app-sync/custom.md): Mirror tables from PostgreSQL, MySQL, or SQL Server databases into NocoDB as read-only synced tables.