Connector name: trelica

Table name: application_role_member, application

Column to add: application_role_member.application_id, application.description, application.vendor_id (from the nested vendor.id field)

API documentation link: https://www.postman.com/trelica/1password-saas-manager/documentation/8ckliux/1password-saas-manager-api?entity=request-12223689-f8c90ae6-0a67-430c-8396-30eafe409cb6&sideView=agentMode

Reason: application_role_member currently has no way to identify which application a role assignment belongs to — the only other key on the table, application_role_index, is not globally unique (it repeats across hundreds of different applications), so this table is effectively unusable for reporting App Owner / Budget Owner / Procurement Manager / SME assignments per app. description and vendor.id are both present in the same API response the connector already calls but aren't currently mapped — vendor.id in particular would give us a stable join key instead of relying on inconsistently formatted vendor name text.

Impact: This data supports SaaS vendor renewal research, contract/spend reconciliation, and vendor ownership reporting across our procurement pipeline — without these fields we can't reliably attribute app ownership or build a stable vendor dimension for cross-system analysis.