Primetric

Tables in the Primetric connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	organization_teams	2
2	organization_roles	3
3	assignments	72				API Reference
4	projects	22				API Reference
5	organization_timeoff_types	2
6	hashtags	2	uuid	Full Refresh		API Reference
7	rag_ratings	3
8	timeoffs	8				API Reference
9	people	5				API Reference
10	organization_identity_providers	4
11	organization_positions	2
12	skills	8				API Reference
13	organization_seniorities	3
14	organization_rag_scopes	5
15	projects_vacancies	8
16	organization_clients	2
17	organization_tags	2
18	employees	15				API Reference
19	worklogs	11				API Reference
20	organization_company_groups	2
21	organization_departments	2

Table: organization_teams

No	Column Name	Type	Notes
1	text	VARCHAR
2	uuid	VARCHAR

Table: organization_roles

No	Column Name	Type	Notes
1	text	VARCHAR
2	uuid	VARCHAR
3	default_hour_rate	VARCHAR

Table: assignments

No	Column Name	Type	Notes
1	financial_total_scheduled_cost	VARCHAR
2	work_by_capacity_per_saturday	INTEGER
3	total_tracked	DOUBLE
4	work_per_wednesday	INTEGER
5	only_billable_work	BOOLEAN
6	scheduling_mode	INTEGER
7	uuid	VARCHAR
8	custom_attributes	VARCHAR
9	financial_settled_cost	VARCHAR
10	financial_client_currency_exchange_rate	DOUBLE
11	financial_settled_income	VARCHAR
12	project_id	VARCHAR
13	work_on_saturday	BOOLEAN
14	financial_total_scheduled_income	VARCHAR
15	work_on_sunday	BOOLEAN
16	ends_at	VARCHAR
17	work_by_capacity_per_thursday	INTEGER
18	start_local_date	VARCHAR
19	total_scheduled	DOUBLE
20	scheduled_work_per_time_frame	INTEGER
21	financial_default_hour_rate_source	INTEGER
22	financial_total_work_for_cost	INTEGER
23	adjust_scheduling_to_public_holidays	BOOLEAN
24	work_per_monday	INTEGER
25	is_settled	BOOLEAN
26	financial_total_tracked_income	VARCHAR
27	financial_contractor_hour_cost	VARCHAR
28	work_on_friday	BOOLEAN
29	financial_budget_mode	INTEGER
30	reduce_utilization_by_public_holidays	BOOLEAN
31	affects_capacity	BOOLEAN
32	background	BOOLEAN
33	employee_id	VARCHAR
34	work_on_thursday	BOOLEAN
35	project_role_id	VARCHAR
36	hash_tag_ids	VARCHAR
37	work_on_wednesday	BOOLEAN
38	status	INTEGER
39	adjust_scheduling_to_time_off	BOOLEAN
40	note	VARCHAR
41	starts_at	VARCHAR
42	financial_total_work_for_income	INTEGER
43	reduce_utilization_by_time_off	BOOLEAN
44	financial_employee_default_hour_cost	VARCHAR
45	color	VARCHAR
46	work_by_capacity_per_friday	INTEGER
47	scheduling_time_frame	INTEGER
48	created_at	VARCHAR
49	use_billable_capacity	BOOLEAN
50	work_per_tuesday	INTEGER
51	work_on_monday	BOOLEAN
52	work_per_saturday	INTEGER
53	financial_use_default_hour_cost	BOOLEAN
54	work_per_friday	INTEGER
55	financial_client_currency	VARCHAR
56	updated_at	VARCHAR
57	work_by_capacity_per_tuesday	INTEGER
58	work_per_thursday	INTEGER
59	financial_hour_rate	VARCHAR
60	work_by_capacity_per_wednesday	INTEGER
61	end_local_date	VARCHAR
62	work_by_capacity_per_sunday	INTEGER
63	financial_total_tracked_cost	VARCHAR
64	work_by_capacity_per_monday	INTEGER
65	label	VARCHAR
66	billable	BOOLEAN
67	daily_data	VARCHAR
68	volatile_work_settings	BOOLEAN
69	work_on_tuesday	BOOLEAN
70	capacity_based_load	INTEGER
71	work_per_sunday	INTEGER
72	project_phase_id	VARCHAR

Table: projects

No	Column Name	Type	Notes
1	end_date	VARCHAR
2	billing_model	INTEGER
3	color	VARCHAR
4	description	VARCHAR
5	tentative	BOOLEAN
6	title	VARCHAR
7	uuid	VARCHAR
8	last_date	VARCHAR
9	custom_attributes	VARCHAR
10	currency_rate	VARCHAR
11	project_group_id	VARCHAR
12	hour_rate_source	INTEGER
13	likelihood	INTEGER
14	assigned_manager_ids	VARCHAR
15	is_public	BOOLEAN
16	currency	VARCHAR
17	hash_tag_ids	VARCHAR
18	customer_id	VARCHAR
19	assigned_manager_readonly_ids	VARCHAR
20	integrations	VARCHAR
21	start_date	VARCHAR
22	status	INTEGER

Table: organization_timeoff_types

No	Column Name	Type	Notes
1	text	VARCHAR
2	uuid	VARCHAR

Table: hashtags

No	Column Name	Type	Notes
1	text	VARCHAR
2	uuid	VARCHAR	Primary Key

Table: rag_ratings

No	Column Name	Type	Notes
1	project_id	VARCHAR
2	project_url	VARCHAR
3	rag_ratings	VARCHAR

Table: timeoffs

No	Column Name	Type	Notes
1	end_date	VARCHAR
2	approved	BOOLEAN
3	approved_by	VARCHAR
4	approved_at	VARCHAR
5	employee_id	VARCHAR
6	uuid	VARCHAR
7	start_date	VARCHAR
8	custom_attributes	VARCHAR

Table: people

No	Column Name	Type	Notes
1	archived	BOOLEAN
2	mail	VARCHAR
3	roles	VARCHAR
4	name	VARCHAR
5	uuid	VARCHAR

Table: organization_identity_providers

No	Column Name	Type	Notes
1	connector	VARCHAR
2	name	VARCHAR
3	uuid	VARCHAR
4	status	VARCHAR

Table: organization_positions

No	Column Name	Type	Notes
1	text	VARCHAR
2	uuid	VARCHAR

Table: skills

No	Column Name	Type	Notes
1	path	VARCHAR
2	has_children	BOOLEAN
3	level	INTEGER
4	name	VARCHAR
5	abstract	BOOLEAN
6	ancestors	VARCHAR
7	uuid	VARCHAR
8	desc	VARCHAR

Table: organization_seniorities

No	Column Name	Type	Notes
1	level	INTEGER
2	text	VARCHAR
3	uuid	VARCHAR

Table: organization_rag_scopes

No	Column Name	Type	Notes
1	default_choice	INTEGER
2	rag_type	INTEGER
3	text	VARCHAR
4	allow_undefined	BOOLEAN
5	is_financial	BOOLEAN

Table: projects_vacancies

No	Column Name	Type	Notes
1	end_date	VARCHAR
2	note	VARCHAR
3	seniority_id	VARCHAR
4	project_id	VARCHAR
5	uuid	VARCHAR
6	start_date	VARCHAR
7	position_id	VARCHAR
8	custom_attributes	VARCHAR

Table: organization_clients

No	Column Name	Type	Notes
1	text	VARCHAR
2	uuid	VARCHAR

Table: organization_tags

No	Column Name	Type	Notes
1	text	VARCHAR
2	uuid	VARCHAR

Table: employees

No	Column Name	Type	Notes
1	summary	VARCHAR
2	assigned_finance_manager_ids	VARCHAR
3	note	VARCHAR
4	seniority_id	VARCHAR
5	assigned_manager_id	VARCHAR
6	department_id	VARCHAR
7	team_id	VARCHAR
8	uuid	VARCHAR
9	custom_attributes	VARCHAR
10	nick	VARCHAR
11	nationality	VARCHAR
12	name	VARCHAR
13	hash_tag_ids	VARCHAR
14	email	VARCHAR
15	position_id	VARCHAR

Table: worklogs

No	Column Name	Type	Notes
1	assignment_id	VARCHAR
2	starts_at	VARCHAR
3	in_progress	BOOLEAN
4	project_id	VARCHAR
5	work	INTEGER
6	created_at	VARCHAR
7	uuid	VARCHAR
8	billable	BOOLEAN
9	developer_id	VARCHAR
10	desc	VARCHAR
11	custom_attributes	VARCHAR

Table: organization_company_groups

No	Column Name	Type	Notes
1	text	VARCHAR
2	uuid	VARCHAR

Table: organization_departments

No	Column Name	Type	Notes
1	text	VARCHAR
2	uuid	VARCHAR

External Resources

• Capacities
• Organization Clients
• Organization Company Groups
• Organization Departments
• Organization Identity Providers
• Organization Positions
• Organization Rag Scopes
• Organization Roles
• Organization Seniorities
• Organization Tags
• Organization Teams
• Organization Timeoff Types
• Projects Vacancies
• Rag Ratings
• Client Secret

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.