Freshservice Bridge Tables

Bridge Tables

FreshserviceAgents_FreshserviceDepartments

Represents the mapping between agents and departments in Freshservice, defining which agents belong to or operate within specific organizational departments.

Name	Type	Description
AgentID	integer	Unique identifier for the agent associated with the department.
DepartmentID	integer	Unique identifier for the department linked to the agent.
ConfigID	integer	Identifier connecting this relationship record to its configuration or ingestion context.

FreshserviceAgents_FreshserviceGroups

Maps agents to their assigned groups, including membership type and approval status, enabling group-based routing and access control in Freshservice.

Name	Type	Description
ConfigID	integer	Identifier linking the agent–group relationship record to its configuration or ingestion context.
AgentID	integer	Unique identifier for the agent associated with the group.
GroupID	integer	Unique identifier for the group the agent belongs to.
MembershipType	string	Specifies the type of membership the agent holds within the group (e.g., "member", "observer").
MembershipPendingApproval	boolean	Indicates whether the agent’s group membership is awaiting approval.
BatchDate	datetime	Timestamp indicating when this relationship record was last ingested or updated.

FreshserviceAgents_FreshserviceRoles

Defines which roles are assigned to which agents, supporting access control, permissions, and role-based functionality across Freshservice.

Name	Type	Description
AgentID	integer	Unique identifier for the agent assigned to the role.
RoleID	integer	Unique identifier for the role associated with the agent.
ConfigID	integer	Identifier linking this role assignment record to its configuration or ingestion context.

FreshserviceAgents_FreshserviceWorkspaces

Represents which workspaces agents have access to, enabling scoping of tickets, assets, and operations within Freshservice.

Name	Type	Description
AgentID	integer	Unique identifier for the agent associated with a workspace.
WorkspaceID	integer	Unique identifier for the workspace the agent belongs to.
ConfigID	integer	Identifier linking this agent–workspace link to its configuration or ingestion context.

FreshserviceAnnouncements_FreshserviceDepartments

Specifies which departments receive visibility to particular announcements, controlling organizational communication scope.

Name	Type	Description
AnnouncementID	integer	Unique identifier for the announcement being targeted.
DepartmentID	integer	Unique identifier for the department the announcement is visible to.
ConfigID	integer	Identifier linking the announcement–department mapping to its configuration or ingestion context.

FreshserviceAnnouncements_FreshserviceGroups

Manages which agent groups are permitted to view specific announcements, enabling targeted updates for teams and functional units.

Name	Type	Description
AnnouncementID	integer	Unique identifier for the announcement being shared.
GroupID	integer	Unique identifier for the group allowed to view the announcement.
ConfigID	integer	Identifier linking the mapping record to its configuration or ingestion context.

FreshserviceAssets_FreshserviceChanges

Tracks which assets are impacted by or included within specific change requests, providing traceability during change management operations.

Name	Type	Description
AssetID	integer	Unique identifier for the asset participating in the change request.
ChangeID	integer	Unique identifier for the change request associated with the asset.
ConfigID	integer	Identifier linking this change–asset relationship record to its configuration or ingestion context.

FreshserviceAssets_FreshserviceContracts

Tracks which assets are governed or covered by specific contracts, enabling lifecycle and compliance alignment between hardware/software assets and vendor agreements.

Name	Type	Description
AssetID	integer	Unique identifier for the asset associated with the contract.
ContractID	integer	Unique identifier for the contract linked to the asset.
ConfigID	integer	Identifier connecting this asset–contract relationship to its configuration or ingestion context.

FreshserviceAssets_Releases

Maps assets to releases, providing traceability between deployed changes and the assets impacted or updated during release cycles.

Name	Type	Description
AssetID	integer	Unique identifier for the asset involved in the release.
ReleaseID	integer	Unique identifier for the release connected to the asset.
ConfigID	integer	Identifier linking this release–asset association to its configuration or ingestion context.

FreshserviceChanges_Releases

Represents the linkage between changes and releases, showing which releases implement, depend on, or include specific change requests.

Name	Type	Description
ChangeID	integer	Unique identifier for the change request associated with the release.
ReleaseID	integer	Unique identifier for the release tied to the change.
ConfigID	integer	Identifier linking the change–release mapping to its configuration or ingestion context.

FreshserviceDepartments_FreshserviceSLAPolicies

Defines the SLA policies assigned to different departments, ensuring service levels and deadlines reflect departmental needs.

Name	Type	Description
DepartmentID	integer	Unique identifier for the department governed by the SLA policy.
SLAPolicyID	integer	Unique identifier for the SLA policy applied to the department.
ConfigID	integer	Identifier linking this SLA–department record to its configuration or ingestion context.

FreshserviceDepartments_FreshserviceVisibleSolutionFolders

Controls which solution folders are visible to each department, enabling targeted knowledge-base access.

Name	Type	Description
DepartmentID	integer	Unique identifier for the department permitted to view the solution folder.
FolderID	integer	Unique identifier for the solution folder visible to the department.
ConfigID	integer	Identifier linking this visibility mapping to its configuration or ingestion context.

FreshserviceGroups_FreshserviceManagedSolutionFolders

Identifies which agent groups manage specific solution folders, supporting ownership and curation of help-center content.

Name	Type	Description
GroupID	integer	Unique identifier for the group managing the solution folder.
FolderID	integer	Unique identifier for the solution folder the group manages.
ConfigID	integer	Identifier linking this management assignment to its configuration or ingestion context.

FreshserviceGroups_FreshserviceSLAPolicies

Assigns SLA expectations to groups, ensuring proper service windows and response timelines for group-based workflows.

Name	Type	Description
GroupID	integer	Unique identifier for the group associated with the SLA policy.
SLAPolicyID	integer	Unique identifier for the SLA policy assigned to the group.
ConfigID	integer	Identifier linking this group-policy mapping to its configuration or ingestion context.

FreshserviceGroups_FreshserviceVisibleSolutionFolders

Determines which solution folders are visible to each group, enabling permissions-based access to knowledge content.

Name	Type	Description
GroupID	integer	Unique identifier for the group allowed to view the solution folder.
FolderID	integer	Unique identifier for the solution folder accessible to the group.
ConfigID	integer	Identifier linking this group–folder visibility mapping to its configuration or ingestion context.

FreshserviceRequesters_FreshserviceDepartments

Represents departmental membership for requesters, allowing department-based filtering, reporting, and access control.

Name	Type	Description
RequesterID	integer	Unique identifier for the requester belonging to the department.
DepartmentID	integer	Unique identifier for the department linked to the requester.
ConfigID	integer	Identifier linking this requester–department association to its configuration or ingestion context.

FreshserviceRequesters_FreshserviceRequesterGroups

Maps requesters to requester groups, used for segmentation, approval flows, and access scoping.

Name	Type	Description
RequesterID	integer	Unique identifier for the requester assigned to the group.
GroupID	integer	Unique identifier for the requester group the requester belongs to.
ConfigID	integer	Identifier linking this requester–group record to its configuration or ingestion context.

FreshserviceRequesterGroups_FreshserviceVisibleSolutionFolders

Controls which knowledge-base folders are accessible to requester groups, enabling tailored self-service experiences.

Name	Type	Description
GroupID	integer	Unique identifier for the requester group with folder visibility.
FolderID	integer	Unique identifier for the solution folder the group can view.
ConfigID	integer	Identifier linking this visibility rule to its configuration or ingestion context.

FreshserviceServiceItems_FreshserviceSLAPolicies

Defines which SLA policies apply to specific service items, ensuring consistent support timelines for catalog-based requests.

Name	Type	Description
ServiceItemID	integer	Unique identifier for the service item governed by the SLA policy.
SLAPolicyID	integer	Unique identifier for the SLA policy applied to the service item.
ConfigID	integer	Identifier linking this service-item–policy mapping to its configuration or ingestion context.