HRIS

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.