Ecosystem Gaps Register

Purpose: Track external dependencies referenced by documented repositories that have not yet been documented themselves. As repos are added to the documentation effort, resolved entries are updated with links to their documentation.

Summary

Status	Count
Unresolved	30
Resolved	15

External Services

#	Referenced Component	Reference Type	Found In	Context	Status
1	Auth Service	HTTP API	`TELS.Tasks.Api/ServiceWrappers/AuthServiceWrapper.cs`, `TELS.Tasks.MQServices/Logic/Proxies/AuthServiceProxy.cs`, `appsettings.json` (AuthEndpoint)	Token retrieval (`POST /token/refresh`) for all outbound service calls. Used by both API and MQServices. [See ~/gitlab/auth/api/docs/]	Resolved
2	Assets Service	HTTP API + NuGet (`DSE.TELS.Assets.Contracts` v2.724197.0)	`TELS.Tasks.Api/ServiceWrappers/AssetsServiceWrapper.cs`, `appsettings.json` (AssetsEndpoint)	Loads asset details (`POST /v1/assets/queries/loadAssets`) when resolving task instance data. [See ~/gitlab/assets/assets/docs/]	Resolved
3	Customers Service	HTTP API + NuGet (`DSE.TELS.Customers.Contracts` v1.78.0, `TELS.Customers.Contracts` v2.25321.987)	`TELS.Tasks.MQServices/Logic/Proxies/SchedulingProxy.cs`, `appsettings.json` (CustomersEndpoint), `TELS.Auth.Api/Proxies/CustomersProxy.cs`	Customer/facility queries from MQServices via WebServiceClient. Auth Service proxies facility access (`GET v2/businessUnits/{id}/facilityAccess`) and facility search. [See ~/gitlab/customers/customers/docs/]	Resolved
4	Scheduling Service	MQ Events + NuGet (`TELS.Scheduling.Events` v1.4.3)	`TELS.Tasks.MQServices/Consumers/ScheduleCreatedConsumer.cs`, `ScheduleRemovedConsumer.cs`, `TaskUpdatedConsumer.cs`, `MassSchedulesRemovedConsumer.cs`	Publishes `IScheduleCreatedEvent`, `IScheduleRemovedEvent`, `ITaskUpdatedEvent`, `IMassSchedulesRemovedEvent` consumed by Tasks. Tasks also publishes `ScheduleCreatedEvent` and `ScheduleRemovedEvent` back to it.	Unresolved
5	Notifications Service	HTTP API + NuGet (`Unity.Notifications.Messaging` v1.10.846068)	`TELS.Tasks.Api/ServiceWrappers/NotificationsWrapper.cs`, `appsettings.json` (NotificationsEndpoint)	Email attachment uploads (`POST /Email/UploadAttachment`) and outbound email publishing (`OutboundEmailEnvelope` via BusProxy). [See ~/gitlab/Unity.Notifications/docs/]	Resolved
6	Files Service	HTTP API + NuGet (`TELS.WebServiceClients.Files`)	`appsettings.json` (FilesEndpoint: `http://localhost:7180/files`), `TELS.MQServices.Files`	File upload/download, metadata management, file groups, composite identifier references. Consumes `IBusinessUnitChangeV1` (Customers) and `ITaskInstanceDocumentCreated` (Tasks) events. Uses Unity File Handler for content storage, SQL Server (Files schema in TELS DB) for metadata. [See ~/gitlab/tels-files/tels-files/docs/]	Resolved
7	BusProxy Service	HTTP API + NuGet (`TELS.BusProxy.Client` v2.2.0-2.3.0, `TELS.BusProxy.Client.S3Fallback` v2.6.0, `TELS.BusProxy.Client.SqlFallback` v2.4.0)	`TELS.Tasks.Api/ServiceWrappers/BusProxyService.cs`, `TELS.Tasks.MQServices/Configuration/BusProxyConfiguration.cs`, `CloudAPI.Api/DependencyInjection/`	Central message publishing infrastructure. Primary delivery via HTTP, with S3 fallback (prod) or SQL fallback (local/integration). 45s timeout. Used by Tasks and CloudAPI. [See ~/gitlab/BusProxy/docs/]	Resolved
13	Work Orders Service	HTTP API + MQ Events (`DSE.TELS.WorkOrders.Contracts` v2.7.2)	`CloudAPI.Api/Startup.cs` (WorkOrdersServiceEndpoint), `TELS.MQServices.Assets/Consumers/WorkOrderUpdatedConsumer.cs`, `WorkItemUpdatedConsumer.cs`	Work order lifecycle management: 6 controllers, 10 endpoints, 4 MQ consumers (dual VHost), 7 consumed message types, 2 published events. Publishes `IWorkOrderUpdated` consumed by Assets. Consumes `INewWorkItemV1`/`IWorkItemUpdatedV1` from Work Items, `IBusinessUnitChangeV1` from Customers. DB: TELS (dbo.woTicket + WorkOrders schema, 20+ tables, 82 SPs). [See ~/gitlab/work-orders/work-orders/docs/]	Resolved
14	Platform Service	HTTP API + NuGet (`TELS.Platform.ClientSdk` v1.2.0, `TELS.Platform.Contracts` v1.2.0)	`CloudAPI.Api/Startup.cs`, `TELS.Auth.Api/appsettings.json`, `TELS.WebServices.Customers/Proxies/`, `TELS.MQServices.Customers/Consumers/ScheduledMessageConsumer.cs`	Centralized settings/configuration service using PostgreSQL JSONB. 2 controllers, 8 endpoints. Subsystem settings CRUD with audit history. No MQ — pure REST API. Publishes `ScheduledMessageEvent` contract (consumed by Customers). Client SDK with Polly retry (5 retries). [See ~/gitlab/platform/api/docs/]	Resolved
15	Databricks	ODBC Analytics	`CloudAPI.DAL/Databricks/DatabricksDataContext.cs`	Read-only analytics queries for complex priority metrics. Queries facility/chain/owner spend, win rates, market analysis.	Unresolved
16	FastAPI Service	HTTP REST ML Service	`CloudAPI.DAL/FastAPI/FastAPIDataContext.cs`	Machine learning model for propensity-to-win predictions. Endpoints: `/predict` and `/backfill_predict`.	Unresolved
18	Zendesk	External REST API	`TicketExceptions` via RestSharp	External ticketing system. TicketExceptions creates tickets, posts comments, updates status via REST API. Critical operational dependency.	Unresolved
19	Bidding/Quoting Service	MQ Events + NuGet (`TELS.Bidding.Contracts` v3.14.0)	`TicketExceptions.MQServices/Consumers/BiddingConsumer.cs`	Renamed from Bidding to Quoting. 9 projects, 6 controllers (25+ endpoints), 2 MQ consumers (7 message types), 6 published events. PostgreSQL database. AI-powered PDF-to-bid (AWS Bedrock/OpenAI), fairness scoring, pricing elasticity models. Publishes `BidModification`, `BidStatusChanged`, `BidConversationAdded` consumed by TicketExceptions. [See ~/gitlab/quoting/Quoting/docs/]	Resolved
20	Compliance Service	MQ Events + NuGet (`TELS.Compliance.Contracts`)	`TicketExceptions.MQServices/Consumers/ComplianceConsumer.cs`	Approval workflow engine: 8 projects, 7 controllers (30+ endpoints), 10 MQ consumers across 3 exchanges, 10+ published events. PostgreSQL database with JSONB rules engine. Publishes `IArticleFinishedV1` and `IArticleNotificationOutcome` consumed by TicketExceptions. [See ~/gitlab/tels-compliance/docs/]	Resolved
21	Contracted Services	MQ Events + NuGet (`TELS.ContractedServices.Contracts` v2.7.0) + HTTP API	`TicketExceptions.MQServices/Consumers/ContractedServiceDocumentationRequirementMetConsumer.cs`	Recurring service contract management: 12 projects, 9 controllers (70+ endpoints), 16 MQ consumers across 2 RabbitMQ vHosts, 4 published events. PostgreSQL 16 (Aurora Serverless v2). Complex scheduling engine (offering/program/on-demand), weather-driven automation (NWS API), service provider notifications, ETA scheduling. Publishes `ContractedServiceDocumentationRequirementMetUpdated` consumed by TicketExceptions. [See ~/gitlab/contracted-services/contracted-services/docs/]	Resolved
42	Service Provider Service	HTTP API + NuGet (`TELS.WebServiceClients.ServiceProvider.V1` 1.8.0, `TELS.ServiceProvider.Contracts` 1.25.3)	`TELS.ContractedServices.Api/Startup.cs` (ServiceProviderEndpoint)	Service provider information lookup. Used by Contracted Services for provider details in contract management.	Unresolved
43	DS TaxUtility	HTTP API + NuGet (`DS.TaxUtility.ClientLibrary`)	`TELS.Billing.Api/` (TaxController, TaxProgramCache)	Tax calculation service with API key auth. Billing uses it for tax determination by facility and line item. Cached tax programs with FlushCacheCommand invalidation.	Unresolved
44	vDist Sales Order Service	HTTP proxy (Windows/NTLM auth)	`TELS.Billing.Api/` (SalesOrderProxy)	Order submission to MDID transaction system. Billing submits contracted service and service request orders. Legacy Windows auth integration requiring gss-ntlmssp in Docker.	Unresolved
45	DSE Transaction Service	HTTP proxy (Windows/NTLM auth)	`TELS.Billing.Api/` (TransactionProxy)	Transaction state management and PO rules. Billing reads order transactions, POs, invoices, checks from MDID_TRAN database via this proxy.	Unresolved
46	vDist SecurityEditor Service	HTTP proxy (Windows/NTLM auth)	`TELS.Billing.Api/` (SecurityEditorProxy)	Security context validation for billing operations. Legacy Windows auth integration.	Unresolved
25	Microsoft Entra ID	External OAuth2/OIDC	`TELS.Auth.Api/Logic/ExternalIdentityService.cs`, `appsettings.json` (ExternalIdentityOptions)	External identity provider for SSO and OpenID Connect authentication flows. Auth Service redirects to Entra ID for SSO initiation and processes OIDC callbacks.	Unresolved
36	Unity File Handler	HTTP API	`TELS.WebServices.Files/Proxies/UnityFileHandlerProxy.cs`	External file content storage service. Files Service uploads (POST Base64) and downloads (GET stream) file content. Authenticated via DSSI Customer API tokens (ECommerce v5).	Unresolved
37	DSSI/ECommerce Customer API	HTTP API (v5)	`TELS.WebServices.Files/Proxies/DSSIAuthenticationProxy.cs`, `TELS.Billing.Api/` (DssiIntegrationController), `ECommerce.Customer.Api.v5.Generated.Client` NuGet	Internal application authentication for Unity File Handler access (Files) and DSSI supplier integration mappings (Billing). Two services now confirmed dependent.	Unresolved
38	Work Items Service	MQ Events (`TELS.WorkItems.Events` v2.0.x)	`TELS.MQServices.WorkOrders/Consumers/WorkItemConsumer.cs`, `TELS.Compliance.MQServices/`, `TELS.Quoting.MQServices/`, `TELS.ContractedServices.MQServices/Consumer/WorkItemsConsumer.cs`	Publishes `INewWorkItemV1`, `IWorkItemUpdatedV1`, `IStatusEventV1` events consumed by Work Orders, Compliance, Quoting, and Contracted Services. Work items are a broader domain — work orders are subtype (WorkRequestTypeId==1). Four services now confirmed dependent.	Unresolved
39	Configuration_Manager database	Cross-database SQL	`WorkOrders.DbUp/` (DSI-Internal connection string)	DSI-Internal configuration data accessed by Work Orders service.	Unresolved
40	URL Shortener Service	HTTP API	`TELS.Compliance.Api/Proxies/UrlShortenerServiceProxy.cs`	URL shortening for SMS notifications (`POST /shorten`).	Unresolved
41	Messaging Service	HTTP API + NuGet (`TELS.WebServices.Messaging.Contracts` v3.x)	`TELS.Compliance.Api/Proxies/MessagingServiceProxy.cs`	Push notification address lookup (`GET /v2/pushNotificationAddresses/{personId}`).	Unresolved
26	Billing Service	HTTP API + NuGet (`TELS.WebServiceClients.Billing.V1` 1.6.0)	`TELS.MQServices.Assets/Proxies/BillingServiceProxy.cs`, `TELS.ContractedServices.Api/Startup.cs`	Order creation, transaction tracking, subscription billing, tax calculation, DSSI integration. 7 projects, 13 controllers (21+ endpoints), 2 MQ consumers across 2 vHosts, 1 published event. SQL Server (TELS + MDID_TRAN dual database). Windows auth legacy integration (Kerberos/NTLM). Two services confirmed dependent (Assets, Contracted Services). [See ~/gitlab/billing/billing/docs/]	Resolved
27	ElasticSearch	Client Library (`TELS.Assets.ElasticSearchClient` v1.0.x)	`TELS.WebServices.Assets/`	Asset search indexing and full-text search queries.	Unresolved
29	Housekeeping Service	HTTP API	`TELS.WebServices.Customers/Proxies/HousekeepingProxy.cs`	Housekeeping operations called from Customers Service.	Unresolved
30	Integrations Service	HTTP API (NTLM) + NuGet (`TELS.Integrations.Contracts`)	`TELS.WebServices.Customers/Proxies/IntegrationsProxy.cs`, `TELS.MQServices.WorkOrders/Proxies/IntegratingPartiesProxy.cs`	Third-party integrations. Customers Service and Work Orders subscriber both call it. Work Orders fetches integration settings for webhook dispatch to external integrators.	Unresolved
31	SiteVisits Service	HTTP API	`TELS.WebServices.Customers/Proxies/SiteVisitsProxy.cs`	Site visit operations called from Customers Service.	Unresolved
32	UserAccountSync Service	HTTP API	`TELS.WebServices.Customers/Proxies/UserAccountSyncProxy.cs`	User account synchronization from Customers Service.	Unresolved
33	VirtualDistribution Service	HTTP API (3 proxies)	`TELS.WebServices.Customers/Proxies/VirtualDistribution*Proxy.cs`	Virtual distribution auth, customers, and DSE DB operations. Customers publishes `VDistContactDeactivated` events to it.	Unresolved

External Databases

#	Referenced Component	Reference Type	Found In	Context	Status
8	TELS database (dbo schema)	Cross-database SQL	`Tasks.DbUp/Schema/20200429 - TELS.dbo.TaskInstance.sql`, `Tasks.DbUp/StoredProcedures/TIG/*.sql`, multiple migration scripts	Core tables: `dbo.telsTask`, `dbo.telsTaskInstance`, `dbo.telsTaskInstanceHist`, `dbo.telsTaskSchedule`, `dbo.telsProgram`, `dbo.LogTemplate`, `dbo.telsDefaultReqDocTasks`. Tasks schema has FK relationships into these dbo tables. TIG stored procedures operate directly on dbo tables.	Unresolved
9	CONTACT database	Cross-database SQL	`Tasks.DbUp/StoredProcedures/`, `TELS.Auth.Api/Data/`, `Customers.DbUp/StoredProcedures_E/`	Contact/person data lookups. Auth reads 10+ tables and writes to cPasswordLockout. Customers reads/writes telsContactReln, buBusinessUnit, telsFacility, cUserAccount, cPerson. Three services now confirmed dependent.	Unresolved
22	DSI_APP database	Cross-database SQL	`TELS.Auth.Api/` (via Auth.v_Identity_ByDsUser view)	DS user records, AD integration, contact relationships. Tables: DsUser, DsUserADInfo, DsUserContactReln. Referenced by Auth identity resolution views.	Unresolved
23	MDID_BTRIEVE database	Cross-database SQL	`TELS.Auth.Api/` (via Auth identity views)	Customer/supplier contact records. Tables: ClCont, ClEmail, ApCont. Referenced by Auth identity resolution for contact key mapping.	Unresolved
24	DSHE_APP database	Cross-database SQL	`TELS.Auth.Api/` (via Auth SecurityEditor SPs)	Security group hierarchy. Tables: DsSecurityGroup, DsGroupReln, DsTeam, DsDepartment, DsCompany, and related junction tables. Recursive hierarchy traversal for authorization.	Unresolved
28	ChangeTrack database	Cross-database SQL	`Assets.DbUp/StoredProcedures/`	User auditing via `ChangeTrack.dbo.GetUser()` function called from Assets stored procedures.	Unresolved
34	INTERNET database	Cross-database SQL	`Customers.DbUp/StoredProcedures_E/`	Internet/external-facing data. Referenced by Customers Service stored procedures.	Unresolved
35	DynaList database	Cross-database SQL	`Customers.DbUp/StoredProcedures_I/`	Dynamic list/lookup data. Referenced by Customers Service internal stored procedures.	Unresolved

External Event Sources

#	Referenced Component	Reference Type	Found In	Context	Status
10	Customers Events Publisher	MQ + NuGet (`DSE.TELS.Customers.Events` v1.0.287926)	`TELS.Tasks.MQServices/Consumers/BusinessUnitChangeConsumer.cs`	Publishes `IBusinessUnitChangeV1` events that trigger task instance generation when business units are activated. Source is Customers Service repo (`TELS.Customers.Messages` project). [See ~/gitlab/customers/customers/docs/]	Resolved

Internal Shared Libraries (NuGet)

#	Referenced Component	Reference Type	Found In	Context	Status
11	TELS.WebServiceClients	NuGet (multiple packages)	`TELS.Tasks.Api.csproj`, `TELS.Tasks.MQServices.csproj`, `TELS.WebServices.Files.csproj`, `TELS.MQServices.Files.csproj`	Shared HTTP client library for calling other TELS services. Provides typed clients for Auth, Customers, Assets, Files, Tasks, etc. Used by Tasks and Files services.	Unresolved
12	TELS.WebServices.Auth.Contracts	NuGet (v4.1.1)	`TELS.Tasks.Api.csproj`, `TELS.Tasks.MQServices.csproj`	Shared auth DTOs and token contracts used for JWT validation and service-to-service auth. Source lives in Auth API repo. [See ~/gitlab/auth/api/docs/]	Resolved
17	BuildingServices.Contracts	NuGet (v1.511.0-v1.524.0)	`CloudAPI.Api.csproj`, `CloudAPI.MQServices.csproj`, `TELS.ContractedServices.Api.csproj`, `TELS.ContractedServices.MQServices.csproj`	Shared event contracts for Building Services domain. Includes `CalculatePropensityToWinMessage`, `FlushCacheRequest`, `RequestType`, `AttachmentUpdated`, `AttachmentDeleted`. Contracted Services consumes attachment events.	Unresolved

Resolution Log

Date	Entry #	Action	Details
2026-03-02	—	Documented	CloudAPI repo documented at `~/gitlab/BuildingServices/CloudAPI/docs/`
2026-03-02	—	Documented	TicketExceptions repo documented at `~/gitlab/BuildingServices/TicketExceptions/docs/`
2026-03-02	—	Documented	Related-order-sync repo documented at `~/gitlab/BuildingServices/related-order-sync/docs/`
2026-03-02	#7	Resolved	BusProxy repo documented at `~/gitlab/BusProxy/docs/` + bus-proxy-queue-processor at `~/gitlab/bus-proxy-queue-processor/docs/`
2026-03-11	—	Documented	Auth API repo documented at `~/gitlab/auth/api/docs/`
2026-03-11	#1	Resolved	Auth Service documented at `~/gitlab/auth/api/docs/` — project-overview.md, er-diagram.md, api-documentation.md
2026-03-11	#12	Resolved	TELS.WebServices.Auth.Contracts — source lives in Auth API repo (`src/TELS.WebServices.Auth.Contracts/`), marked obsolete, replaced by TELS.Auth.Contracts
2026-03-11	#22-24	Added	New cross-database dependencies discovered from Auth: DSI_APP, MDID_BTRIEVE, DSHE_APP databases
2026-03-11	#25	Added	Microsoft Entra ID (external OAuth2/OIDC provider) discovered from Auth SSO flows
2026-03-11	—	Documented	Assets repo documented at `~/gitlab/assets/assets/docs/`
2026-03-11	#2	Resolved	Assets Service documented at `~/gitlab/assets/assets/docs/` — project-overview.md, er-diagram.md, api-documentation.md, event-catalog.md
2026-03-11	#26-28	Added	New dependencies from Assets: Billing Service, ElasticSearch, ChangeTrack database
2026-03-11	—	Documented	Customers repo documented at `~/gitlab/customers/customers/docs/`
2026-03-11	#3	Resolved	Customers Service documented at `~/gitlab/customers/customers/docs/` — project-overview.md, er-diagram.md, api-documentation.md, event-catalog.md
2026-03-11	#10	Resolved	Customers Events Publisher confirmed as same repo (TELS.Customers.Messages project publishes IBusinessUnitChangeV1)
2026-03-11	#29-35	Added	New dependencies from Customers: Housekeeping, Integrations, SiteVisits, UserAccountSync, VirtualDistribution services; INTERNET and DynaList databases
2026-03-11	—	Documented	Unity.Notifications repo documented at `~/gitlab/Unity.Notifications/docs/`
2026-03-11	#5	Resolved	Notifications Service documented at `~/gitlab/Unity.Notifications/docs/` — project-overview.md, er-diagram.md, api-documentation.md, event-catalog.md
2026-03-11	—	Documented	Files Service repo documented at `~/gitlab/tels-files/tels-files/docs/`
2026-03-11	#6	Resolved	Files Service documented at `~/gitlab/tels-files/tels-files/docs/` — project-overview.md, er-diagram.md, api-documentation.md, event-catalog.md
2026-03-11	—	Documented	Work Orders repo documented at `~/gitlab/work-orders/work-orders/docs/`
2026-03-11	#13	Resolved	Work Orders Service documented at `~/gitlab/work-orders/work-orders/docs/` — project-overview.md, er-diagram.md, api-documentation.md, event-catalog.md
2026-03-11	#38-39	Added	New dependencies from Work Orders: Work Items Service (MQ events), Configuration_Manager database
2026-03-11	—	Documented	Platform API repo documented at `~/gitlab/platform/api/docs/`
2026-03-11	#14	Resolved	Platform Service documented at `~/gitlab/platform/api/docs/` — project-overview.md, er-diagram.md, api-documentation.md (no event-catalog — no MQ)
2026-03-11	—	Documented	Quoting (formerly Bidding) repo documented at `~/gitlab/quoting/Quoting/docs/`
2026-03-11	#19	Resolved	Quoting Service documented at `~/gitlab/quoting/Quoting/docs/` — project-overview.md, er-diagram.md, api-documentation.md, event-catalog.md
2026-03-11	—	Documented	Compliance repo documented at `~/gitlab/tels-compliance/docs/`
2026-03-11	#20	Resolved	Compliance Service documented at `~/gitlab/tels-compliance/docs/` — project-overview.md, er-diagram.md, api-documentation.md, event-catalog.md
2026-03-11	#40-41	Added	New dependencies from Compliance: URL Shortener Service, Messaging Service
2026-03-11	—	Documented	Contracted Services repo documented at `~/gitlab/contracted-services/contracted-services/docs/`
2026-03-11	#21	Resolved	Contracted Services documented at `~/gitlab/contracted-services/contracted-services/docs/` — project-overview.md, er-diagram.md, api-documentation.md, event-catalog.md
2026-03-11	#42	Added	New dependency from Contracted Services: Service Provider Service (HTTP API)
2026-03-11	#38	Updated	Work Items Service now confirmed as dependency for 4 services (added Contracted Services)
2026-03-11	#17	Updated	BuildingServices.Contracts now consumed by Contracted Services (AttachmentUpdated/Deleted)
2026-03-11	#26	Updated	Billing Service now confirmed as dependency for 2 services (added Contracted Services)
2026-03-11	—	Documented	ServiceProviderJobNotifier satellite batch job documented at `~/gitlab/contracted-services/ServiceProviderJobNotifier/docs/`
2026-03-11	—	Documented	ETA Notifier satellite batch job documented at `~/gitlab/contracted-services/etanotifier/docs/`
2026-03-11	—	Documented	AvailableDocumentationNotifier satellite batch job documented at `~/gitlab/contracted-services/availabledocumentationnotifier/docs/`
2026-03-11	—	Documented	UpcomingServicesSummaryNotifier satellite batch job documented at `~/gitlab/contracted-services/UpcomingServicesSummaryNotifier/docs/`
2026-03-11	—	Documented	ContractedServiceEventScheduler satellite batch job documented at `~/gitlab/contracted-services/ContractedServiceEventScheduler/docs/`
2026-03-11	—	Documented	Billing Service repo documented at `~/gitlab/billing/billing/docs/`
2026-03-11	#26	Resolved	Billing Service documented at `~/gitlab/billing/billing/docs/` — project-overview.md, er-diagram.md, api-documentation.md, event-catalog.md
2026-03-11	#43-46	Added	New dependencies from Billing: DS TaxUtility (API key auth), vDist Sales Order (NTLM), DSE Transaction (NTLM), vDist SecurityEditor (NTLM)
2026-03-11	#37	Updated	DSSI/ECommerce Customer API now confirmed as dependency for 2 services (Files + Billing)
2026-03-11	—	Documented	Billing UI satellite documented at `~/gitlab/billing/billing-ui/docs/`
2026-03-11	—	Documented	Invoice Monitor satellite batch job documented at `~/gitlab/billing/invoice-monitor/docs/`
2026-03-11	—	Documented	Billing Utilities satellite utility documented at `~/gitlab/billing/billing-utilities/docs/`
2026-03-11	—	Documented	TELS Billing Processor satellite legacy batch documented at `~/gitlab/billing/tels-billing-processor/docs/`

Notes

Entries 3 (Customers Service) and 10 (Customers Events Publisher) likely live in the same repository but are listed separately because they represent different integration types (HTTP vs MQ).
Entry 8 (TELS dbo schema) is the highest-impact gap. The Tasks schema has direct FK references into dbo tables, and the TIG stored procedures execute against dbo tables. Understanding the full dbo schema is critical for a complete ER diagram.
Entry 7 (BusProxy) is shared infrastructure used by many services. Documenting it once will resolve the gap for all downstream repos.
The Auth Service (entry #1, now resolved) revealed extensive cross-database dependencies: 5+ databases, 30+ tables accessed via SQL views for identity resolution. Three new database gaps (#22-24) were added.
Entry 9 (CONTACT database) is now confirmed as high-impact — both Tasks and Auth have extensive dependencies on it. Auth writes to cPasswordLockout and reads 10+ tables.
The Auth repo also publishes 3 NuGet packages (TELS.Auth.Contracts, TELS.Auth.Sdk, TELS.WebServices.Auth.Contracts) consumed by many downstream services. This resolves entry #12.
Entry 25 (Microsoft Entra ID) is an external third-party service — not a candidate for internal documentation but tracked for ecosystem completeness.
The Assets Service (entry #2, now resolved) is one of the larger TELS microservices: 24 controllers, 162 stored procedures, 4 MQ consumers. It confirmed Work Orders (#13) as both HTTP and MQ dependency.
Entry 13 (Work Orders) is now referenced by both CloudAPI and Assets — it publishes IWorkOrderUpdated and IWorkItemUpdatedV1 events consumed by Assets for cost record linking.
Entry 27 (ElasticSearch) is infrastructure — may not have a repo to document but tracked for ecosystem awareness.
The Customers Service (entries #3 and #10, now resolved) is a major hub: 10 projects, 30 controllers, 6 MQ consumers, accesses 5 databases. It confirmed the CONTACT database (#9) as a cross-service dependency (Tasks, Auth, and Customers all access it).
Customers introduced 5 new service dependencies (#29-33) and 2 new database dependencies (#34-35). The service ecosystem is broader than initially cataloged.
Entry 14 (Platform Service) is now confirmed as a dependency for 3+ services (CloudAPI, Auth, Customers). It provides platform tokens and scheduled messages.
The Notifications Service (entry #5, now resolved) is a tri-channel platform: email (AWS SES), SMS (AWS Pinpoint), push (AWS SNS). 14 projects, 3 subscriber services. Uses MassTransit 7.3.1 (older than other TELS services at 8.2.5).
Entry #4 (Scheduling Service) was skipped — repo could not be located on GitLab. May need manual investigation.
The Files Service (entry #6, now resolved) is a metadata-centric file management service: 7 projects, 2 controllers (13 endpoints), 2 MQ consumers. It stores only metadata in SQL Server (Files schema in TELS DB) — actual file content lives in the Unity File Handler service. Uses MassTransit 8.3.0 (newer than most TELS services). Pure consumer — publishes no events.
Files Service introduced a new dependency: Unity File Handler (external HTTP service for file content storage). This is accessed via DSSIAuthenticationProxy (ECommerce Customer API tokens).
The Work Orders Service (entry #13, now resolved) is a substantial service: 7 projects, 6 controllers, 4 MQ consumers across dual RabbitMQ VHosts. Notable patterns: composite PK (WorkOrderID + LocationBusinessUnitID), self-referential parent-child work orders, configurable per-BU/per-status field requirements, mass creation with async MQ processing.
Work Orders consumes events from a "Work Items" domain (#38) — work orders appear to be a subtype (WorkRequestTypeId==1) within a broader work items system. This is a new dependency not seen in other documented services.
Work Orders subscriber calls back to its own API via HTTP proxies rather than accessing the database directly — a unique pattern among documented TELS services.
Entry 30 (Integrations Service) updated: now confirmed as a dependency for both Customers and Work Orders. Work Orders uses it (NTLM auth) to fetch third-party integration settings for webhook dispatch.
The Platform Service (entry #14, now resolved) is unique among TELS services: uses PostgreSQL (not SQL Server), has no MQ integration, and has no outbound HTTP dependencies. It is a foundational leaf service — a centralized JSONB settings store with 2 tables and 5 stored functions.
Platform publishes ScheduledMessageEvent contract consumed by Customers, but the publishing mechanism is not in this repo — likely a separate scheduler component.
The Quoting Service (entry #19, now resolved, formerly "Bidding") is one of the most feature-rich TELS services: AI-powered PDF-to-bid generation (AWS Bedrock + OpenAI), fairness scoring, sophisticated pricing elasticity models, and event-sourced bid history. PostgreSQL database like Platform.
Quoting confirms the Work Items service (#38) as a cross-cutting dependency — both Work Orders and Quoting consume INewWorkItemV1 and IStatusEventV1 events.
Quoting depends on BuildingServices (CloudAPI) for bid requests, service providers, and markets — confirming CloudAPI as a central hub for the building services domain.
The TELS.Bidding.Contracts namespace is retained for backward compatibility despite the rename to Quoting. Both /quoting/v1/ and /bidding/v1/ route prefixes work.
The Compliance Service (entry #20, now resolved) is a sophisticated approval workflow engine: JSONB-driven rules, multi-step approval workflows, hierarchical roles, multi-channel notifications (email/SMS/push), A/B email testing. PostgreSQL database — fourth TELS service on PostgreSQL.
Compliance uses MassTransit 5.5.6 (oldest version among documented services). Most of its 10+ published events are self-consumed to drive workflow state machine progression.
Compliance introduced 2 new dependencies: URL Shortener (#40) and Messaging Service (#41). The Messaging Service provides push notification addresses.
Entry #38 (Work Items) is now confirmed as a dependency for 3 services: Work Orders, Quoting, and Compliance. It's a central domain publishing work item lifecycle events.
The Contracted Services system (entry #21, now resolved) is the fifth TELS service on PostgreSQL (alongside Platform, Quoting, Compliance — uses Aurora Serverless v2 specifically). It is the most complex scheduling system in the ecosystem: offering-based, program-based, and on-demand service scheduling with weather-driven automation via National Weather Service API.
Contracted Services uses MassTransit 8.5.5 (most current among documented services). It has 16 consumers — the most of any documented service — spread across 2 RabbitMQ vHosts.
Contracted Services is unique in consuming AWS EventBridge-triggered messages for timed operations (notifications, weather batch processing) routed through Platform's ScheduledMessageEvent.
Contracted Services self-calls via TELS.WebServiceClients.ContractedServices.V2 in its subscriber — similar pattern to Work Orders.
Weather automation is unique to Contracted Services: integrates National Weather Service and Census Bureau Geocoding APIs with distributed rate limiting (exec_claim FIFO queue across cluster instances).
Entry #42 (Service Provider Service) is a new dependency discovered from Contracted Services. It provides service provider information used in contract management.
Entry #38 (Work Items) now has 4 confirmed consumers: Work Orders, Quoting, Compliance, and Contracted Services. It is the most widely consumed event source in the ecosystem.
Contracted Services has extensive Databricks reporting integration (10 Gold Layer SQL views), suggesting strong BI/analytics requirements.
The Billing Service (entry #26, now resolved) is unique among TELS services for its dual database architecture (TELS + MDID_TRAN) and heavy reliance on Windows auth legacy proxies (Kerberos/NTLM). It still uses WCF for DSE.CustomerDB — one of the few remaining WCF integrations.
Billing introduced 4 new dependencies (#43-46), all Windows/NTLM-authenticated legacy proxies (vDist Sales Order, DSE Transaction, vDist SecurityEditor) plus the DS TaxUtility (API key auth).
Billing has 4 satellite repos: billing-ui (React SPA on AWS Lambda), invoice-monitor (Nomad batch), billing-utilities (manual DSSI reporting utility), tels-billing-processor (Nomad legacy Windows batch wrapping TELSBillProcessing.exe).
The TELS Billing Processor is unique: infrastructure-only repo wrapping a legacy Windows executable with Nomad orchestration. Uses nomad-batch-legacy module and an impossible cron schedule (Feb 31st) for mutex unlock safety.
The billing-ui is the only TELS service using AWS Lambda (not ECS). It serves a React SPA with JWT-in-memory + refresh-in-cookie auth pattern.
The MDID_TRAN database is read-only from Billing's perspective — order transactions (TrOrder, TrOrderPO, TrCustInv, TrSpInv, TrAPInv, TrCheck) are written by the vDist/MDID transaction system.