Rippling Tables and Scopes

Scopes

The following scopes are required for this integration:

Scope
users.read
workers.read
companies.read
departments.read
teams.read
levels.read
titles.read
job-functions.read
employment-types.read
work-locations.read
supergroups.read
business-partner-groups.read
business-partners.read
entitlements.read

Tables

RipplingBusinessPartnerGroups

Stores Rippling business partner group definitions, which organize business partner relationships by domain and assign a default partner for the group.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the business partner group.
CreatedAt	string	Timestamp indicating when the business partner group was created.
UpdatedAt	string	Timestamp indicating when the business partner group was last updated.
Name	string	Display name of the business partner group.
Domain	string	Domain name associated with the business partner group, used to scope partner relationships.
DefaultBusinessPartnerID	string	Identifier of the default business partner assigned to this group.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingBusinessPartners

Records individual business partner assignments in Rippling, linking a worker to a client group within a business partner group.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the business partner record.
CreatedAt	string	Timestamp indicating when the business partner record was created.
UpdatedAt	string	Timestamp indicating when the business partner record was last updated.
BusinessPartnerGroupID	string	Identifier of the business partner group to which this business partner belongs.
WorkerID	string	Identifier of the Rippling worker assigned as the business partner.
ClientGroupID	string	Identifier of the client group associated with this business partner relationship.
ClientGroupMemberCount	integer	Number of members in the client group associated with this business partner.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingCompanies

Contains Rippling company records including legal name, DBA name, contact details, physical address, and associated legal entities.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the company.
CreatedAt	string	Timestamp indicating when the company record was created.
UpdatedAt	string	Timestamp indicating when the company record was last updated.
Name	string	Operating or display name of the company.
LegalName	string	Registered legal name of the company.
DoingBusinessAsName	string	Trade name or DBA (doing business as) name used by the company.
PrimaryEmail	string	Primary contact email address for the company.
Phone	string	Primary phone number for the company.
ParentLegalEntityID	string	Identifier of the parent legal entity if the company is a subsidiary.
PhysicalAddressType	string	Type classification of the physical address (e.g., `WORK`, `HOME`, `OTHER`).
PhysicalAddressFormatted	string	Full formatted physical address of the company as a single string.

RipplingDepartmentHierarchy

Represents parent-child relationships between Rippling departments, enabling traversal of the full department organizational structure.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ChildDepartmentID	string	Identifier of the child department in the parent-child hierarchy relationship.
ParentDepartmentID	string	Identifier of the parent department in the hierarchy relationship.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingDepartments

Stores Rippling department definitions including name, reference code, and the full serialized hierarchy path.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the department.
CreatedAt	string	Timestamp indicating when the department was created.
UpdatedAt	string	Timestamp indicating when the department record was last updated.
Name	string	Display name of the department.
ReferenceCode	string	External reference code or identifier for the department, used for integration or payroll mapping.
DepartmentHierarchyIDSerialized	string	Serialized list of parent department identifiers representing the full hierarchy path.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingEmploymentTypes

Contains Rippling employment type configurations that define classification, compensation time period, and work schedule for different worker categories.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the employment type.
CreatedAt	string	Timestamp indicating when the employment type record was created.
UpdatedAt	string	Timestamp indicating when the employment type record was last updated.
Label	string	Short display label for the employment type shown in the Rippling UI.
Name	string	Full name of the employment type.
Type	string	Classification of the employment type (e.g., `FULL_TIME`, `PART_TIME`, `CONTRACTOR`, `TEMPORARY`).
CompensationTimePeriod	string	Time period used for compensation calculations for this employment type (e.g., `HOURLY`, `SALARY`, `DAILY`).
AmountWorked	string	Amount or schedule of work associated with this employment type (e.g., `40 hours per week`).
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingEntitlements

Records available API entitlements in Rippling, describing the data scopes and permissions that can be granted to integration configurations.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the entitlement.
Description	string	Description of the entitlement and what API access or data scope it grants.
DisplayName	string	Human-readable display name of the entitlement shown in the Rippling developer portal.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingGroupMembers

Stores membership records for Rippling supergroups, including member identity, work email, worker reference, and membership type.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the group member record.
CreatedAt	string	Timestamp indicating when the group membership was created.
UpdatedAt	string	Timestamp indicating when the group membership record was last updated.
FullName	string	Full name of the group member.
WorkEmail	string	Work email address of the group member.
WorkerID	string	Identifier of the Rippling worker associated with this group member.
SuperGroupID	string	Identifier of the supergroup to which this member belongs.
MemberType	string	Type of membership within the supergroup (e.g., `INCLUSION`, `EXCLUSION`).
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingIntegrations

Integration summary table listing all Rippling integration configurations with creation, modification, and enablement metadata.

Name	Type	Description
ID	integer	Auto-incremented primary key for the Rippling integration configuration record.
CreatedDate	datetime	Timestamp indicating when the integration configuration was created.
ModifiedDate	datetime	Timestamp indicating when the integration configuration was last modified.
CreatedBy	string	Username or identifier of the user who created the integration configuration.
ModifiedBy	string	Username or identifier of the user who last modified the integration configuration.
IntegrationID	integer	Numeric identifier linking this record to the associated Rippling integration instance.
Name	string	Display name of the Rippling integration configuration.
IsEnabled	boolean	Indicates whether the integration configuration is currently active and enabled.

RipplingJobFunctions

Contains Rippling job function definitions used to classify workers by functional area within the organization.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the job function.
CreatedAt	string	Timestamp indicating when the job function was created.
UpdatedAt	string	Timestamp indicating when the job function record was last updated.
Name	string	Name of the job function (e.g., `Engineering`, `Sales`, `Finance`).
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingLevelHierarchy

Represents parent-child relationships between Rippling career levels, enabling traversal of the level track structure.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ChildLevelID	string	Identifier of the child level in the level hierarchy relationship.
ParentLevelID	string	Identifier of the parent level in the level hierarchy relationship.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingLevels

Stores Rippling career level definitions including global level, rank, description, and the associated career track.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the level.
CreatedAt	string	Timestamp indicating when the level was created.
UpdatedAt	string	Timestamp indicating when the level record was last updated.
Name	string	Display name of the level (e.g., `IC1`, `Senior Engineer`, `Director`).
GlobalLevel	integer	Numeric global level value used for cross-track seniority comparison.
Description	string	Description of the level, outlining expectations or criteria for workers at this level.
Rank	integer	Numeric rank of the level within its track, used to order levels from least to most senior.
TrackID	string	Identifier of the career track to which this level belongs.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingSuperGroups

Contains Rippling supergroup definitions used for dynamic workforce segmentation, access control provisioning, and policy assignment, including membership rules and priority settings.

Name	Type	Description
AccountID	string	AWS account ID in which the GuardDuty finding was generated.
DetectorID	string	ID of the GuardDuty detector that generated this finding.
Description	string	Human-readable description explaining the nature and context of the finding.
ARN	string	Full Amazon Resource Name of the GuardDuty finding.
ServiceUserFeedback	string	User-provided feedback on the finding (e.g., `USEFUL`, `NOT_USEFUL`).
Partition	string	AWS partition in which the finding was generated (e.g., `aws`, `aws-cn`, `aws-us-gov`).
Region	string	AWS region where the finding was generated (e.g., `us-east-1`, `eu-west-2`).
SchemaVersion	string	Version of the GuardDuty finding schema used for this record.
Title	string	Short, human-readable title summarizing the finding type.
Type	string	GuardDuty finding type identifier (e.g., `UnauthorizedAccess:EC2/SSHBruteForce`).
Confidence	float	Confidence score (0-100) representing how likely the finding indicates a threat.
Severity	float	Numeric severity score of the finding (e.g., 2.0 = LOW, 5.0 = MEDIUM, 8.0 = HIGH).

RipplingTeamHierarchy

Represents parent-child relationships between Rippling teams, enabling traversal of the team organizational structure.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ChildTeamID	string	Identifier of the child team in the parent-child hierarchy relationship.
ParentTeamID	string	Identifier of the parent team in the hierarchy relationship.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingTeams

Stores Rippling team definitions used to organize workers into functional or project-based groups.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the team.
CreatedAt	string	Timestamp indicating when the team was created.
UpdatedAt	string	Timestamp indicating when the team record was last updated.
Name	string	Display name of the team.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingTitles

Contains Rippling job title definitions representing the named positions workers hold within the organization.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the title.
CreatedAt	string	Timestamp indicating when the title record was created.
UpdatedAt	string	Timestamp indicating when the title record was last updated.
Name	string	Name of the job title (e.g., `Software Engineer`, `Product Manager`, `HR Business Partner`).
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingUsers

Stores Rippling user account records including identity, contact details, address, locale, and timezone for all company users.

Name	Type	Description
AccountID	string	AWS account ID in which the GuardDuty finding was generated.
DetectorID	string	ID of the GuardDuty detector that generated this finding.
Description	string	Human-readable description explaining the nature and context of the finding.
ARN	string	Full Amazon Resource Name of the GuardDuty finding.
ServiceUserFeedback	string	User-provided feedback on the finding (e.g., `USEFUL`, `NOT_USEFUL`).
Partition	string	AWS partition in which the finding was generated (e.g., `aws`, `aws-cn`, `aws-us-gov`).
Region	string	AWS region where the finding was generated (e.g., `us-east-1`, `eu-west-2`).
SchemaVersion	string	Version of the GuardDuty finding schema used for this record.
Title	string	Short, human-readable title summarizing the finding type.
Type	string	GuardDuty finding type identifier (e.g., `UnauthorizedAccess:EC2/SSHBruteForce`).
Confidence	float	Confidence score (0-100) representing how likely the finding indicates a threat.
Severity	float	Numeric severity score of the finding (e.g., 2.0 = LOW, 5.0 = MEDIUM, 8.0 = HIGH).

RipplingWorkerManagerHierarchy

Represents direct manager-to-worker reporting relationships in Rippling, enabling traversal of the organizational reporting structure.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
WorkerID	string	Identifier of the worker in the reporting relationship.
ManagerID	string	Identifier of the worker's direct manager.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

RipplingWorkers

Primary table of Rippling worker records containing employment details, personal information, compensation, department, title, level, location, and termination data.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the worker.
CreatedAt	string	Timestamp indicating when the worker record was created.
UpdatedAt	string	Timestamp indicating when the worker record was last updated.
UserID	string	Identifier of the Rippling user account associated with this worker.
IsManager	boolean	Indicates whether the worker has a managerial role with direct reports.
LegalEntityID	string	Identifier of the legal entity under which the worker is employed.
Country	string	ISO 3166-1 alpha-2 country code of the country where the worker is employed (e.g., `US`, `GB`, `CA`).
StartDate	string	Date when the worker's employment began.
EndDate	string	Date when the worker's employment ended, if applicable.
Number	integer	Unique employee number assigned to the worker within the company.
WorkEmail	string	Work email address of the worker.

RipplingWorkerTeams

Junction table associating Rippling workers with the teams they belong to, linking worker and team identifiers with their respective configuration IDs.

Name	Type	Description
RipplingTeamsID	string	Identifier of the Rippling team in the worker-team association.
RipplingTeamsConfigID	integer	Configuration identifier of the Rippling team record in the worker-team association.
RipplingWorkersID	string	Identifier of the Rippling worker in the worker-team association.
RipplingWorkersConfigID	integer	Configuration identifier of the Rippling worker record in the worker-team association.

RipplingWorkLocations

Stores Rippling work location records including name and full address details for each physical or designated work site.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Rippling integration configuration.
ID	string	Unique Rippling-generated identifier for the work location.
CreatedAt	string	Timestamp indicating when the work location was created.
UpdatedAt	string	Timestamp indicating when the work location record was last updated.
Name	string	Display name of the work location (e.g., `HQ - San Francisco`, `London Office`).
AddressType	string	Type classification of the work location address (e.g., `WORK`, `HOME`, `OTHER`).
AddressFormatted	string	Full formatted address of the work location as a single string.
AddressStreetAddress	string	Street address of the work location.
AddressLocality	string	City or locality of the work location address.
AddressRegion	string	State, province, or region of the work location address.
AddressPostalCode	string	Postal or ZIP code of the work location address.
AddressCountry	string	ISO 3166-1 alpha-2 country code of the work location (e.g., `US`, `CA`, `GB`).
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.