CIMS - Support (Retainer)
project
9c77b9b57a003028
Normalized: cims support retainer
hubspot
linear
moreland_dashboard
toggl
Entity Properties (gold project table)
project_id
9c77b9b57a003028
name
CIMS - Support (Retainer)
client_id
ed2ee141cb338935
canonical_metadata
—
created_at
2026-02-12 05:36:13.625127+00:00
updated_at
2026-02-12 05:36:13.625127+00:00
status
—
billable
Yes
recurring
—
squad
Slate
qa_partner
John
project_manager
Steve
lead_dev
Ricky
description
—
state
—
team_name
—
closedate
2025-12-31 19:30:17.990000+00:00
dealstage
990408365
deal_amount
43000.0
contract_type
—
contract_hourly_rate
—
contract_estimated_hours
—
contract_total_fee
—
25%
Separation Confidence
How distinct this entity is from others. Higher means no close matches existed when it was created. Lower means a near-match was rejected just below the 80% threshold — worth reviewing.
Low — a near-match was rejected, review recommended
99%
Avg Match Confidence
The average confidence score across all active source mappings. Shows overall quality of linkage between source records and this canonical entity.
Strong source linkage
Source Mappings (28)
| Source | Source ID | Display Name | Confidence | Method | Status | Actions | |
|---|---|---|---|---|---|---|---|
| hubspot | 52036293545 | CIMS - Support Retainer | 1.00 | exact | Active |
|
|
|
Source Record
bronze_hubspot_deals
id
52036293545
created_at
2025-12-18 19:31:15.293000+00:00
updated_at
2025-12-29 15:34:38.744000+00:00
archived
No
amount
43000
closedate
2025-12-31 19:30:17.990000+00:00
createdate
2025-12-18 19:31:15.293000+00:00
dealname
CIMS - Support Retainer
dealstage
990408365
hs_lastmodifieddate
2025-12-29 15:34:38.744000+00:00
hs_object_id
52036293545
hubspot_owner_id
555004277
pipeline
default
associated_company_id
824762906
associated_companies_ids
824762906
associated_contact_id
64708293140
associated_contacts_ids
64708293140
|
|||||||
| hubspot | 22415439134 | CIMS Hosting and Support Retainer | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_hubspot_deals
id
22415439134
created_at
2024-09-19 13:25:08.787000+00:00
updated_at
2025-12-05 13:54:09.233000+00:00
archived
No
amount
108000
closedate
2024-10-08 18:40:36.136000+00:00
createdate
2024-09-19 13:25:08.787000+00:00
dealname
CIMS Hosting and Support Retainer
dealstage
144996904
hs_lastmodifieddate
2025-12-05 13:54:09.233000+00:00
hs_object_id
22415439134
hubspot_owner_id
429486978
pipeline
default
associated_company_id
824762906
associated_companies_ids
824762906
associated_contact_id
—
associated_contacts_ids
—
|
|||||||
| hubspot | 54354375091 | CIMS - Support Retainer (clone) | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_hubspot_deals
id
54354375091
created_at
2026-01-22 21:47:49.924000+00:00
updated_at
2026-01-22 21:48:58.433000+00:00
archived
No
amount
43000
closedate
2026-01-23 21:47:27.840000+00:00
createdate
2026-01-22 21:47:49.924000+00:00
dealname
CIMS - Support Retainer (clone)
dealstage
1268501096
hs_lastmodifieddate
2026-01-22 21:48:58.433000+00:00
hs_object_id
54354375091
hubspot_owner_id
26186329
pipeline
default
associated_company_id
824762906
associated_companies_ids
824762906
associated_contact_id
64708293140
associated_contacts_ids
64708293140
|
|||||||
| linear | dba9217e-18ab-4d0d-8e84-694fe599a126 | CIMS Support Retainer | 1.00 | exact | Active |
|
|
|
Source Record
bronze_linear_projects
id
dba9217e-18ab-4d0d-8e84-694fe599a126
name
CIMS Support Retainer
description
—
team_id
—
team_name
—
state
—
created_at
—
updated_at
—
_dlt_meta
—
|
|||||||
| moreland_dashboard | dLaDdj7XfBBQsw | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | 3iBDo3bwE8Q+vw | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | ydYTZfK61qNLIg | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | ssWzhdq3Vp6NfQ | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | W/wtwNgLeSUcFQ | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | d8/vV1+gmPzzaA | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | 2FP6ir5j5r8fCA | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | eQFj6cPpSVON9g | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | Fg1sACW/YknKEQ | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | Mxr+qgXay/8lPg | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | Z23b25+6+GUBOg | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | cu1b8Pd0L8gOyA | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | ZHNDkt4Ka8wJ+Q | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | eP3A4aZDqc5MSA | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | IEF7W3ReuMiLEg | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | fxtyRF5qfCCN7w | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | QHug6KTxy20fIg | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | e50FjnmJc3XHeg | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | JVaAHXCfpfYZ1Q | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | CIMS - Support (Retainer) | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
|
Source Record
bronze_moreland_dashboard_md_timetoqb
toggl
CIMS - Support (Retainer)
quickbooks
CIMS
sg_a_spread
True
project_type
Support
billing_type
T&M
squad
Slate
qa_partner
John
project_manager
Steve
lead_dev
Ricky
|
|||||||
| moreland_dashboard | r1QPGvjlkwbJxg | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | tJ0FzxBulV/7+w | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| moreland_dashboard | JdGOsCqSHTfijA | CIMS - Support (Retainer) | 1.00 | exact | Active |
|
|
| toggl | 171837641 | CIMS - Support (Retainer) | 1.00 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_toggl_projects
id
171837641
workspace_id
5511582
client_id
56091072
name
CIMS - Support (Retainer)
is_private
—
active
No
updated_at
—
created_at
2021-07-20T18:32:16+00:00
color
#465bb3
billable
Yes
template
—
auto_estimates
—
rate
150.0
currency
USD
recurring
—
actual_hours
—
actual_seconds
—
client_name
—
status
—
|
|||||||