Data export field reference

Every field of every JSON file in a Cogram Data Export, with the data it comes from, and the data that never leaves Cogram.

This page lists, for every kind of record in a Data Export, the fields its JSON carries and the stored data that is deliberately not exported. Where each file sits in the zip is on the package layout page.

The page is generated from the export's own coverage registry, which Cogram's tests check against the database schema, so it is complete: a column that is not listed as a field here is listed as not exported, with the reason.

Field types are JSON types: string, number, boolean, object, null where a value is missing, datetime and date for ISO-8601 strings, and the name of another record type where a field holds one of those records (or a list of them).

Organization (organizations)

Field	Type	From
id	string	column id
name	string or null	column name
domains	list[string] or null	column domains
hq_address	string or null	column hq_address
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
creation_source	internal worker, bot, upload or sync state
invited_by_org_id	internal worker, bot, upload or sync state
is_self_serve	billing or licensing, not customer data
mcp_rate_limit_rpm	billing or licensing, not customer data
name_is_generated	internal worker, bot, upload or sync state
org_settings	templates, styling or settings; out of scope
organization_logo_public_height	templates, styling or settings; out of scope
organization_logo_public_url	templates, styling or settings; out of scope
organization_logo_public_width	templates, styling or settings; out of scope
organization_logo_s3_key	templates, styling or settings; out of scope
tenancy	internal worker, bot, upload or sync state

User (users)

Field	Type	From
id	string	column id
name	string	columns first_name, last_name
email	string	column email
role	string or null	derived

Not exported:

Column	Reason
banned_until	access control or automation config; out of scope
bio	users.json carries identity only: id, name, email, role
created_at	users.json carries identity only: id, name, email, role
email_confirmed_at	internal worker, bot, upload or sync state
invitation_sent_at	internal worker, bot, upload or sync state
is_pending_since	internal worker, bot, upload or sync state
is_sso_user	access control or automation config; out of scope
job_title	users.json carries identity only: id, name, email, role
last_activity_at	internal worker, bot, upload or sync state
last_sign_in_at	internal worker, bot, upload or sync state
location	users.json carries identity only: id, name, email, role
modified_at	users.json carries identity only: id, name, email, role
ms_user_id	integration sync bookkeeping (Procore, Microsoft, Unanet)
organization_id	organization_id; implied by the export scope
phone_number	users.json carries identity only: id, name, email, role
profile_photo_s3_key	users.json carries identity only: id, name, email, role
raw_user_meta_data	internal worker, bot, upload or sync state
sso_exempt	access control or automation config; out of scope
tours_state	templates, styling or settings; out of scope
user_settings	templates, styling or settings; out of scope

UserRole (user_roles)

Ships as the .eml file itself, not as JSON. The columns below ride as RFC-822 headers or MIME parts:

• role

Not exported:

Column	Reason
created_at	join row; the recipient is identified and timestamped by its party
modified_at	join row; the recipient is identified and timestamped by its party
user_id	parent reference; implied by the file's place in the zip

Company (companies)

Field	Type	From
id	string	column id
name	string	column name
aliases	list[string] or null	column aliases
email_domains	list[string] or null	column email_domains
website	string or null	column website
phone	string or null	column phone
address	string or null	column address
description	string or null	column description
types	list[string] or null	column types
disciplines	list[string] or null	column disciplines
is_own_firm	boolean	column is_own_firm
source	string	column source
archived_at	datetime or null	column archived_at
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
organization_id	organization_id; implied by the export scope

Contact (contacts)

Field	Type	From
id	string	column id
primary_email	string	column primary_email
additional_emails	list[string] or null	column additional_emails
first_name	string or null	column first_name
last_name	string or null	column last_name
title	string or null	column title
company_id	string or null	column company_id
phone	string or null	column phone
mobile_phone	string or null	column mobile_phone
address	string or null	column address
discipline	string or null	column discipline
is_employee	boolean or null	column is_employee
linked_user_id	string or null	column linked_user_id
source	string	column source
archived_at	datetime or null	column archived_at
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
organization_id	organization_id; implied by the export scope

ProjectCompany (project_companies)

Field	Type	From
id	string	column id
company_id	string	column company_id
project_function	string or null	column project_function
is_primary_for_function	boolean	column is_primary_for_function
joined_at	datetime or null	column joined_at
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
organization_id	organization_id; implied by the export scope
project_id	parent reference; implied by the file's place in the zip

ProjectContact (project_contacts)

Field	Type	From
id	string	column id
contact_id	string	column contact_id
project_company_id	string or null	column project_company_id
project_function	string or null	column project_function
joined_at	datetime or null	column joined_at
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
notification_preferences	templates, styling or settings; out of scope
organization_id	organization_id; implied by the export scope
project_id	parent reference; implied by the file's place in the zip

Project (projects)

Field	Type	From
id	string	column id
organization_id	string	column organization_id
creator_id	string or null	column creator_id
name	string	column name
description	string or null	column description
archived_at	datetime or null	column archived_at
source	string	column source
asset_visibility	string or null	column asset_visibility
is_public	boolean	column is_public
is_dummy	boolean	column is_dummy
is_personal	boolean	column is_personal
email_filing_enabled	boolean	column email_filing_enabled
board_auto_apply_mode	string	column board_auto_apply_mode
customer_project_id	string or null	column customer_project_id
client_name	string or null	column client_name
project_address	string or null	column project_address
project_type	_LookupRef or null	columns project_type_id
unanet_project_id	string or null	column unanet_project_id
unanet_lead_stage	string or null	column unanet_lead_stage
unanet_custom_fields	object or null	column unanet_custom_fields
unanet_market_sectors	list[object] or null	column unanet_market_sectors
meta	object or null	column meta
stage	_LookupRef or null	columns stage_id
client_company_id	string or null	column client_company_id
meeting_filing_enabled	boolean	column meeting_filing_enabled
chat_enabled	boolean	column chat_enabled
cover_image_filename	string or null	columns image_s3_key
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
default_auto_assign	access control or automation config; out of scope
procore_company_id	integration sync bookkeeping (Procore, Microsoft, Unanet)
procore_environment	integration sync bookkeeping (Procore, Microsoft, Unanet)
procore_project_id	integration sync bookkeeping (Procore, Microsoft, Unanet)

Meeting (meetings)

Field	Type	From
id	string	column id
organization_id	string	column organization_id
project_id	string or null	column project_id
user_id	string	column user_id
name	string or null	column name
source	string or null	column source
meeting_time	datetime	column meeting_time
meeting_url	string or null	column meeting_url
started_timestamp	datetime or null	column started_timestamp
ended_timestamp	datetime or null	column ended_timestamp
status	string	column status
language	string	column language
is_dummy	boolean	column is_dummy
word_count	number or null	column word_count
condensed	boolean	column condensed
user_is_organizer	boolean or null	column user_is_organizer
calendar_description	string or null	column calendar_description
participants	object or list[any] or null	column participants
attendees	object or list[any] or null	column attendees
speakers	object or list[any] or null	column speakers
geo_coordinates	object or list[any] or null	column geo_coordinates
geo_data	object or list[any] or null	column geo_data
note	NoteExport or null	derived
action_items	list[ActionItemExport]	derived
attachments	list[MeetingAttachmentExport]	derived
photos	list[MeetingPhotoExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
audio_url	meeting audio never leaves Cogram (customer policy)
backfilled_to_my_workspace_at	internal worker, bot, upload or sync state
bot_audio_analytics	internal worker, bot, upload or sync state
bot_id	internal worker, bot, upload or sync state
bot_launch_result	internal worker, bot, upload or sync state
bot_left_on_silence_at	internal worker, bot, upload or sync state
bot_restarted_count	internal worker, bot, upload or sync state
bot_speaker_timeline	internal worker, bot, upload or sync state
bot_speaker_timeline_v2	internal worker, bot, upload or sync state
debug_info	internal worker, bot, upload or sync state
deleted_at	soft-delete or operational metadata
deletion_reason	soft-delete or operational metadata
external_media_scrubbed_at	soft-delete or operational metadata
failure_code	soft-delete or operational metadata
fluester_audio_uri	meeting audio never leaves Cogram (customer policy)
fluester_client_processing_status	internal worker, bot, upload or sync state
fluester_debug_info	internal worker, bot, upload or sync state
fluester_job_id	internal worker, bot, upload or sync state
internal_share_token	token or credential; never leaves Cogram
internal_share_token_expires_at	token or credential; never leaves Cogram
multipart_object_key	internal worker, bot, upload or sync state
multipart_part_count	internal worker, bot, upload or sync state
multipart_part_size_bytes	internal worker, bot, upload or sync state
multipart_photo_metadata	internal worker, bot, upload or sync state
multipart_upload_id	internal worker, bot, upload or sync state
notification_sent_at	internal worker, bot, upload or sync state
origin	internal worker, bot, upload or sync state
raw_analytics_data	internal worker, bot, upload or sync state
raw_fluester_response	internal worker, bot, upload or sync state
read_only_token	token or credential; never leaves Cogram
recurrence_id	internal worker, bot, upload or sync state
uid	internal worker, bot, upload or sync state

Transcript (transcripts)

Field	Type	From
id	string	column id
meeting_id	string	column meeting_id
data	object or list[any] or null	column data
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

ChainResult (chain_results)

Field	Type	From
id	string	column id
chain_id	string or null	column chain_id
building_block	_BuildingBlockRef or null	derived
user_id	string or null	column user_id
output	string or null	column output
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
group_id	access control or automation config; out of scope
input	internal worker, bot, upload or sync state
meeting_id	parent reference; implied by the file's place in the zip
organization_id	organization_id; implied by the export scope

Note (notes)

Field	Type	From
id	string	column id
user_id	string or null	column user_id
text	string or null	column text
content	object or list[any] or null	column content
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
meeting_id	parent reference; implied by the file's place in the zip

ActionItem (action_items)

Field	Type	From
id	string	column id
user_id	string or null	column user_id
origin	string or null	column origin
status	string or null	column status
due_date_timestamp	datetime or null	column due_date_timestamp
archived	boolean	column archived
assignee	string or null	column assignee
description	string or null	column description
marked_done_timestamp	datetime or null	column marked_done_timestamp
migrated_to_board_item_id	string or null	column migrated_to_board_item_id
migrated_to_suggestion_id	string or null	column migrated_to_suggestion_id
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
meeting_id	parent reference; implied by the file's place in the zip

MeetingAttachment (meeting_attachments)

Field	Type	From
id	string	column id
uploader_id	string	column uploader_id
filename	string	column filename
mime_type	string	column mime_type
size_bytes	number	column size_bytes
extracted_content	string or null	column extracted_content
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
meeting_id	parent reference; implied by the file's place in the zip
organization_id	organization_id; implied by the export scope
s3_key	S3 key; the binary itself ships as a sibling file

MeetingPhoto (meeting_photos)

Field	Type	From
id	string	column id
note	string or null	column note
taken_at	datetime or null	column taken_at
geo_coordinates	object or list[any] or null	column geo_coordinates
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
meeting_id	parent reference; implied by the file's place in the zip
s3_photo_key	S3 key; the binary itself ships as a sibling file
s3_thumbnail_key	thumbnail or preview derived from the shipped binary; UI only

Email (emails)

Ships as the .eml file itself, not as JSON. The columns below ride as RFC-822 headers or MIME parts:

• body

• cc

• conversation_id

• created_at

• html

• id

• internet_message_id

• is_dummy

• modified_at

• recipients

• sender

• sent_at

• subject

• user_id

Not exported:

Column	Reason
confidential_type	not in the .eml; a Continuous Data Export carries it in each email's email.json
eml_s3_key	S3 key; the binary itself ships as a sibling file
headers	raw transport header text; an archived .eml carries the original headers and a rebuilt one the headers Cogram knows
message_id	integration sync bookkeeping (Procore, Microsoft, Unanet)
organization_id	organization_id; implied by the export scope
project_id	parent reference; implied by the file's place in the zip

EmailAttachment (email_attachments)

Ships as the .eml file itself, not as JSON. The columns below ride as RFC-822 headers or MIME parts:

• content_id

• content_type

• filename

• is_inline

Not exported:

Column	Reason
created_at	emails have no JSON sidecar; the .eml is the whole record
email_id	parent reference; implied by the file's place in the zip
extracted_text	emails have no JSON sidecar; the .eml is the whole record
id	an archived .eml is the original wire bytes, never rewritten below the header block, so no part can carry a Cogram id
modified_at	emails have no JSON sidecar; the .eml is the whole record
organization_id	organization_id; implied by the export scope
s3_key	embedded in the .eml as a MIME part

Document (documents)

Field	Type	From
id	string	column id
organization_id	string	column organization_id
project_id	string	column project_id
creator_id	string	column creator_id
filename	string	column filename
title	string or null	column title
document_number	string or null	column document_number
category	string	column category
custom_category	string or null	column custom_category
mime_type	string	column mime_type
size_bytes	number	column size_bytes
extracted_content	string or null	column extracted_content
folder_id	string or null	column folder_id
current_version_id	string or null	column current_version_id
source_meeting_attachment_id	string or null	column source_meeting_attachment_id
source_email_attachment_id	string or null	column source_email_attachment_id
source_chat_attachment_id	string or null	column source_chat_attachment_id
versions	list[DocumentVersionExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
s3_key	S3 key; the binary itself ships as a sibling file

DocumentVersion (document_versions)

Field	Type	From
id	string	column id
version_number	number	column version_number
revision_code	string or null	column revision_code
note	string	column note
status	string or null	column status
size_bytes	number	column size_bytes
mime_type	string	column mime_type
creator_id	string	column creator_id
restored_from_version_id	string or null	column restored_from_version_id
is_current	boolean	derived
filename	string	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
document_id	parent reference; implied by the file's place in the zip
organization_id	organization_id; implied by the export scope
s3_key	S3 key; the binary itself ships as a sibling file

Folder (folders)

Field	Type	From
id	string	column id
parent_id	string or null	column parent_id
name	string	column name
path	string	derived
system_key	string or null	column system_key
creator_id	string	column creator_id
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
organization_id	organization_id; implied by the export scope
project_id	parent reference; implied by the file's place in the zip
restricted	access control or automation config; out of scope

Drawing (drawings)

Field	Type	From
id	string	column id
organization_id	string	column organization_id
project_id	string	column project_id
creator_id	string	column creator_id
drawing_set_id	string or null	column drawing_set_id
drawing_no	string	column drawing_no
title	string	column title
category	string or null	column category
drawing_date	date or null	column drawing_date
discipline	_LookupRef or null	columns discipline_id
extracted_content	string or null	column extracted_content
is_dummy	boolean	column is_dummy
revisions	list[DrawingRevisionExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

DrawingRevision (drawing_revisions)

Field	Type	From
id	string	column id
creator_id	string	column creator_id
version_number	number	column version_number
file_name	string	column file_name
file_size	number	column file_size
page_number	number or null	column page_number
is_active	boolean	column is_active
revision_code	string or null	column revision_code
status	string or null	column status
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
drawing_id	parent reference; implied by the file's place in the zip
organization_id	organization_id; implied by the export scope
s3_image_key	S3 key; the binary itself ships as a sibling file
s3_pdf_key	S3 key; the binary itself ships as a sibling file
s3_thumbnail_key	thumbnail or preview derived from the shipped binary; UI only
upload_job_id	internal worker, bot, upload or sync state

DrawingSet (drawing_sets)

Field	Type	From
id	string	column id
organization_id	string	column organization_id
project_id	string	column project_id
name	string	column name
drawing_ids	list[string]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

FieldReport (field_reports)

Field	Type	From
id	string	column id
organization_id	string	column organization_id
project_id	string	column project_id
user_id	string	column user_id
name	string	column name
summary	string or null	column summary
location	string or null	column location
language	string or null	column language
status	string or null	column status
start_time	datetime or null	column start_time
end_time	datetime or null	column end_time
source_meeting_id	string or null	column source_meeting_id
meta_data	object or list[any] or null	column meta_data
geo_data	object or list[any] or null	column geo_data
observation_ids	list[string]	derived
field_report_type_id	string or null	column field_report_type_id
field_report_type_name	string or null	derived
field_report_type_field_values	list[FieldReportTypeFieldValueExport]	derived
field_report_type_table_cells	list[FieldReportTypeTableCellExport]	derived
assignee	string or null	column assignee
assignee_role	string or null	column assignee_role
assignee_user_id	string or null	column assignee_user_id
assignee_contact_id	string or null	column assignee_contact_id
assignee_company_id	string or null	column assignee_company_id
is_dummy	boolean	column is_dummy
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

FieldReportTypeTableCell (field_report_type_table_cells)

Field	Type	From
id	string	column id
field_report_type_field_id	string	column field_report_type_field_id
field_name	string	derived
field_report_type_table_column_id	string or null	column field_report_type_table_column_id
column_name	string	column column_name
row_index	number	column row_index
value	string	column value
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
field_report_id	parent reference; implied by the file's place in the zip
organization_id	organization_id; implied by the export scope

FieldReportTypeFieldValue (field_report_type_field_values)

Field	Type	From
id	string	column id
field_name	string	column field_name
value	string	column value
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
field_report_id	parent reference; implied by the file's place in the zip
field_report_type_field_id	reference to org-level definition; name is denormalized
organization_id	organization_id; implied by the export scope

Observation (observations)

Field	Type	From
id	string	column id
organization_id	string	column organization_id
project_id	string	column project_id
user_id	string	column user_id
field_report_id	string or null	column field_report_id
title	string	column title
note	string	column note
status	_LookupRef or null	columns status_id
type	_LookupRef or null	columns type_id
drawing_id	string or null	column drawing_id
drawing_coordinates	object or list[any] or null	column drawing_coordinates
geo_coordinates	object or list[any] or null	column geo_coordinates
meta_data	object or list[any] or null	column meta_data
source_meeting_id	string or null	column source_meeting_id
photos	list[ObservationPhotoExport]	derived
assignee	string or null	column assignee
assignee_role	string or null	column assignee_role
assignee_user_id	string or null	column assignee_user_id
assignee_contact_id	string or null	column assignee_contact_id
assignee_company_id	string or null	column assignee_company_id
is_dummy	boolean	column is_dummy
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

ObservationPhoto (observation_photos)

Field	Type	From
id	string	column id
source_meeting_photo_id	string or null	column source_meeting_photo_id
note	string or null	column note
taken_at	datetime or null	column taken_at
geo_coordinates	object or list[any] or null	column geo_coordinates
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
observation_id	parent reference; implied by the file's place in the zip
organization_id	organization_id; implied by the export scope
s3_photo_key	S3 key; the binary itself ships as a sibling file
s3_thumbnail_key	thumbnail or preview derived from the shipped binary; UI only

ProjectBoardItem (project_board_items)

Field	Type	From
id	string	column id
organization_id	string	column organization_id
project_id	string	column project_id
source_meeting_id	string or null	column source_meeting_id
creator_user_id	string or null	column creator_user_id
title	string	column title
body	string or null	column body
status	string	column status
priority	string or null	column priority
due_date	date or null	column due_date
meeting_series_uid	string or null	column meeting_series_uid
archived	boolean	column archived
assignee	string or null	column assignee
assignee_role	string or null	column assignee_role
assignee_user_id	string or null	column assignee_user_id
assignee_contact_id	string or null	column assignee_contact_id
assignee_company_id	string or null	column assignee_company_id
history	list[TaskHistoryEntryExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

BoardItemHistoryEntry (project_board_item_history)

Field	Type	From
id	string	column id
changed_by_user_id	string or null	column changed_by_user_id
triggered_by_meeting_id	string or null	column triggered_by_meeting_id
previous_status	string or null	column previous_status
new_status	string or null	column new_status
previous_assignee	string or null	column previous_assignee
new_assignee	string or null	column new_assignee
previous_assignee_user_id	string or null	column previous_assignee_user_id
new_assignee_user_id	string or null	column new_assignee_user_id
previous_assignee_contact_id	string or null	column previous_assignee_contact_id
new_assignee_contact_id	string or null	column new_assignee_contact_id
previous_assignee_company_id	string or null	column previous_assignee_company_id
new_assignee_company_id	string or null	column new_assignee_company_id
previous_assignee_role	string or null	column previous_assignee_role
new_assignee_role	string or null	column new_assignee_role
previous_priority	string or null	column previous_priority
new_priority	string or null	column new_priority
previous_due_date	date or null	column previous_due_date
new_due_date	date or null	column new_due_date
previous_project_id	string or null	column previous_project_id
new_project_id	string or null	column new_project_id
reason	string or null	column reason
comment	string or null	column comment
changed_at	datetime	column changed_at
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
board_item_id	parent reference; implied by the file's place in the zip
organization_id	organization_id; implied by the export scope

Transmittal (transmittals)

Field	Type	From
id	string	column id
organization_id	string	column organization_id
project_id	string	column project_id
creator_id	string	column creator_id
sender_org_id	string	column sender_org_id
transmittal_number	string	column transmittal_number
subject	string	column subject
purpose	string	column purpose
status	string	column status
remarks	string or null	column remarks
due_date	datetime or null	column due_date
sent_at	datetime or null	column sent_at
revoked_at	datetime or null	column revoked_at
revoked_by_id	string or null	column revoked_by_id
revoke_reason	string or null	column revoke_reason
thread_id	string or null	column thread_id
require_recipient_verification	boolean or null	column require_recipient_verification
assignee	string or null	column assignee
assignee_role	string or null	column assignee_role
assignee_user_id	string or null	column assignee_user_id
assignee_contact_id	string or null	column assignee_contact_id
assignee_company_id	string or null	column assignee_company_id
recipients	list[TransmittalRecipientExport]	derived
documents	list[TransmittalDocumentExport]	derived
events	list[TransmittalEventExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

CorrespondenceThread (correspondence_threads)

Field	Type	From
id	string	column id
organization_id	string	column organization_id
project_id	string	column project_id
registration_type	string	column registration_type
direction	string	column direction
subject	string or null	column subject
registered_as	ThreadRegistrationExport or null	derived
parties	list[ThreadPartyExport]	derived
messages	list[ThreadMessageExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

CorrespondenceParty (correspondence_parties)

Field	Type	From
id	string	column id
contact_id	string or null	column contact_id
external_ref	string or null	column external_ref
display_name	string or null	column display_name
standing_role	string	column standing_role
first_viewed_at	datetime or null	column first_viewed_at
first_viewed_verified	boolean or null	column first_viewed_verified
first_downloaded_at	datetime or null	column first_downloaded_at
first_downloaded_verified	boolean or null	column first_downloaded_verified
acknowledged_at	datetime or null	column acknowledged_at
acknowledged_verified	boolean or null	column acknowledged_verified
responded_at	datetime or null	column responded_at
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
access_token	token or credential; never leaves Cogram
notification_message_id	internal worker, bot, upload or sync state
organization_id	organization_id; implied by the export scope
thread_id	parent reference; implied by the file's place in the zip

CorrespondenceMessage (correspondence_messages)

Field	Type	From
id	string	column id
message_uid	string	column message_uid
in_reply_to	string or null	column in_reply_to
reference_uids	list[string] or null	column reference_uids
from_party_id	string or null	column from_party_id
sender_party_id	string or null	column sender_party_id
direction	string	column direction
body	string or null	column body
disposition	string or null	column disposition
revision	string or null	column revision
source	string	column source
source_email_id	string or null	column source_email_id
sent_at	datetime or null	column sent_at
eml_filename	string or null	columns eml_s3_key
addressees	list[MessageAddresseeExport]	derived
documents	list[MessageDocumentExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
organization_id	organization_id; implied by the export scope
thread_id	parent reference; implied by the file's place in the zip

MessageAddressee (message_addressees)

Field	Type	From
party_id	string	column party_id
role	string	column role

Not exported:

Column	Reason
created_at	join row; the recipient is identified and timestamped by its party
id	join row; the recipient is identified and timestamped by its party
message_id	parent reference; implied by the file's place in the zip
modified_at	join row; the recipient is identified and timestamped by its party
organization_id	organization_id; implied by the export scope

MessageDocument (message_documents)

Field	Type	From
id	string	column id
document_id	string or null	column document_id
document_version_id	string or null	column document_version_id
drawing_revision_id	string or null	column drawing_revision_id
kind	string or null	column kind
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
message_id	parent reference; implied by the file's place in the zip
organization_id	organization_id; implied by the export scope

TransmittalDocument (transmittal_documents)

Field	Type	From
id	string	column id
document_id	string or null	column document_id
document_version_id	string or null	column document_version_id
drawing_id	string or null	column drawing_id
drawing_revision_id	string or null	column drawing_revision_id
dated	datetime or null	column dated
remarks	string or null	column remarks
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
organization_id	organization_id; implied by the export scope
transmittal_id	parent reference; implied by the file's place in the zip

TransmittalEvent (transmittal_events)

Field	Type	From
id	string	column id
event_type	string	column event_type
actor_id	string or null	column actor_id
details	object or list[any] or null	column details
created_at	datetime or null	column created_at

Not exported:

Column	Reason
organization_id	organization_id; implied by the export scope
transmittal_id	parent reference; implied by the file's place in the zip

Submittal (submittals)

Field	Type	From
id	string	column id
project_id	string	column project_id
creator_id	string or null	column creator_id
procore_submittal_id	number or null	column procore_submittal_id
procore_company_id	string or null	column procore_company_id
procore_project_id	string or null	column procore_project_id
procore_data	object or list[any] or null	columns procore_raw_obj
procore_last_sync_at	datetime or null	column procore_last_sync_at
cogram_status	string	column cogram_status
procore_response	string or null	column procore_response
response_comment	string or null	column response_comment
responded_at	datetime or null	column responded_at
ai_checks_result	object or list[any] or null	column ai_checks_result
ai_checks_run_at	datetime or null	column ai_checks_run_at
spec_compliance_result	object or list[any] or null	column spec_compliance_result
spec_compliance_run_at	datetime or null	column spec_compliance_run_at
title	string or null	column title
subject	string or null	column subject
number	string or null	column number
revision	string or null	column revision
package_label	string or null	column package_label
spec_csi_division	string or null	column spec_csi_division
spec_csi_section	string or null	column spec_csi_section
due_date	datetime or null	column due_date
counterparty_reference	string or null	column counterparty_reference
assignee_user_id	string or null	column assignee_user_id
source_email_id	string or null	column source_email_id
thread_id	string or null	column thread_id
ai_draft_response	string or null	column ai_draft_response
ai_draft_response_run_at	datetime or null	column ai_draft_response_run_at
ai_draft_status	string or null	column ai_draft_status
approvers	list[SubmittalApproverExport]	derived
attachments	list[SubmittalAttachmentMetaExport]	derived
external_reviews	list[ExternalReviewInvitationExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

SubmittalApprover (submittal_approvers)

Field	Type	From
id	string	column id
procore_approver_id	number or null	column procore_approver_id
procore_data	object or list[any] or null	columns procore_raw_obj
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
submittal_id	parent reference; implied by the file's place in the zip

SubmittalAttachment (submittal_attachments)

Field	Type	From
id	string	column id
parent_type	string	derived
parent_id	string	columns approver_id, submittal_id
filename	string	column filename
file_size_bytes	number or null	column file_size_bytes
mime_type	string or null	column mime_type
procore_attachment_id	number or null	column procore_attachment_id
procore_url	string or null	column procore_url
creator_id	string or null	column creator_id
extracted_text	string or null	column extracted_text
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
procore_raw_obj	duplicate of data already in the zip
s3_key	S3 key; the binary itself ships as a sibling file
s3_uploaded_at	integration sync bookkeeping (Procore, Microsoft, Unanet)

RFI (rfis)

Field	Type	From
id	string	column id
project_id	string	column project_id
creator_id	string or null	column creator_id
procore_rfi_id	number or null	column procore_rfi_id
procore_company_id	string or null	column procore_company_id
procore_project_id	string or null	column procore_project_id
procore_data	object or list[any] or null	columns procore_raw_obj
procore_last_sync_at	datetime or null	column procore_last_sync_at
cogram_status	string or null	column cogram_status
response_comment	string or null	column response_comment
responded_at	datetime or null	column responded_at
ai_checks_result	object or list[any] or null	column ai_checks_result
ai_checks_run_at	datetime or null	column ai_checks_run_at
title	string or null	column title
subject	string or null	column subject
number	string or null	column number
spec_csi_division	string or null	column spec_csi_division
spec_csi_section	string or null	column spec_csi_section
due_date	datetime or null	column due_date
counterparty_reference	string or null	column counterparty_reference
assignee_user_id	string or null	column assignee_user_id
source_email_id	string or null	column source_email_id
thread_id	string or null	column thread_id
ai_draft_response	string or null	column ai_draft_response
ai_draft_response_run_at	datetime or null	column ai_draft_response_run_at
ai_draft_status	string or null	column ai_draft_status
questions	list[RFIQuestionExport]	derived
attachments	list[RFIAttachmentMetaExport]	derived
external_reviews	list[ExternalReviewInvitationExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

RFIQuestion (rfi_questions)

Field	Type	From
id	string	column id
procore_question_id	number or null	column procore_question_id
procore_data	object or list[any] or null	columns procore_raw_obj
answers	list[RFIAnswerExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
rfi_id	parent reference; implied by the file's place in the zip

RFIAnswer (rfi_answers)

Field	Type	From
id	string	column id
question_id	string	column question_id
procore_answer_id	number or null	column procore_answer_id
procore_data	object or list[any] or null	columns procore_raw_obj
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

RFIAttachment (rfi_attachments)

Field	Type	From
id	string	column id
parent_type	string	derived
parent_id	string	columns answer_id, question_id
filename	string	column filename
file_size_bytes	number or null	column file_size_bytes
mime_type	string or null	column mime_type
procore_attachment_id	number or null	column procore_attachment_id
procore_url	string or null	column procore_url
creator_id	string or null	column creator_id
extracted_text	string or null	column extracted_text
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
procore_raw_obj	duplicate of data already in the zip
s3_key	S3 key; the binary itself ships as a sibling file
s3_uploaded_at	integration sync bookkeeping (Procore, Microsoft, Unanet)

ExternalReviewInvitation (external_review_invitations)

Field	Type	From
id	string	column id
rfi_id	string or null	column rfi_id
submittal_id	string or null	column submittal_id
email	string	column email
name	string or null	column name
company	string or null	column company
is_required	boolean	column is_required
deadline	datetime or null	column deadline
invited_by_user_id	string or null	column invited_by_user_id
reviewer_user_id	string or null	columns recipient_user_id
message	string or null	column message
response_status	string or null	column response_status
response_comment	string or null	column response_comment
response_custom_stamp	string or null	column response_custom_stamp
responded_at	datetime or null	column responded_at
expires_at	datetime or null	columns preview_token_expires_at
email_sent_at	datetime or null	column email_sent_at
revoked_at	datetime or null	column revoked_at
asset_type	string	column asset_type
asset_id	string or null	column asset_id
status	string	column status
sender_organization_id	string	column sender_organization_id
sender_user_id	string or null	column sender_user_id
recipient_contact_id	string or null	column recipient_contact_id
recipient_organization_id	string or null	column recipient_organization_id
accepted_copy_asset_id	string or null	column accepted_copy_asset_id
accepted_copy_project_id	string or null	column accepted_copy_project_id
party_id	string or null	column party_id
preview_first_viewed_at	datetime or null	column preview_first_viewed_at
attachments	list[ExternalReviewAttachmentMetaExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
preview_token	token or credential; never leaves Cogram
recipient_email	duplicate of data already in the zip
require_sign_in_to_view	access control or automation config; out of scope

ExternalReviewAttachment (external_review_attachments)

Field	Type	From
id	string	column id
invitation_id	string or null	column invitation_id
filename	string	column filename
file_size_bytes	number or null	column file_size_bytes
mime_type	string or null	column mime_type
uploaded_by	string	column uploaded_by
creator_user_id	string or null	column creator_user_id
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
s3_key	S3 key; the binary itself ships as a sibling file

KnowledgeEntry (knowledge_entries)

Field	Type	From
id	string	column id
creator_id	string	column creator_id
project_id	string or null	column project_id
scope	string	column scope
kind	string	column kind
title	string	column title
description	string	column description
body_text	string or null	column body_text
filename	string or null	derived
attachment_filename	string or null	derived
mime_type	string or null	column mime_type
size_bytes	number or null	column size_bytes
extracted_content	string or null	column extracted_content
content_sha256	string or null	column content_sha256
source_thread_id	string or null	column source_thread_id
source	string or null	column source
source_ref	string or null	column source_ref
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
organization_id	organization_id; implied by the export scope
s3_key	S3 key; the binary itself ships as a sibling file

Prompt (prompts)

Field	Type	From
id	string	column id
user_id	string	column user_id
title	string or null	column title
content	string	column content
tags	list[string]	column tags
scope	string	column scope
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
last_used_at	usage or sync telemetry, not customer data
organization_id	organization_id; implied by the export scope
search_vector	internal worker, bot, upload or sync state
used_count	usage or sync telemetry, not customer data

Agent (agents)

Field	Type	From
id	string	column id
created_by_id	string	column created_by_id
owner_id	string	column owner_id
name	string	column name
description	string or null	column description
instructions	string	column instructions
skill_ids	list[string]	column skill_ids
knowledge_entry_ids	list[string]	column knowledge_entry_ids
shared_with_org	boolean	column shared_with_org
managed_by_organization	boolean	column managed_by_organization
model	string	column model
reasoning_effort	string	column reasoning_effort
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
deleted_at	soft-delete or operational metadata
glyph_icon	templates, styling or settings; out of scope
glyph_seed	templates, styling or settings; out of scope
glyph_text	templates, styling or settings; out of scope
organization_id	organization_id; implied by the export scope
provided_key	internal worker, bot, upload or sync state

ProjectChatChannel (project_chat_channel)

Field	Type	From
id	string	column id
project_id	string	column project_id
name	string	column name
archived_at	datetime or null	column archived_at
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
organization_id	organization_id; implied by the export scope

ProjectChatMessage (project_chat_message)

Field	Type	From
id	string	column id
author_user_id	string	column author_user_id
body	string	column body
rich_body	string or null	column rich_body
mentioned_user_ids	list[string]	column mentioned_user_ids
edited_at	datetime or null	column edited_at
attachments	list[ChatAttachmentExport]	derived
reactions	list[ChatReactionExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
channel_id	parent reference; implied by the file's place in the zip
client_message_id	internal worker, bot, upload or sync state
deleted_at	soft-delete or operational metadata
organization_id	organization_id; implied by the export scope
project_id	parent reference; implied by the file's place in the zip

ProjectChatAttachment (project_chat_attachment)

Field	Type	From
id	string	column id
filename	string	column filename
attachment_filename	string	derived
size_bytes	number	column size_bytes
mime_type	string	column mime_type
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
deleted_at	soft-delete or operational metadata
message_id	parent reference; implied by the file's place in the zip
organization_id	organization_id; implied by the export scope
project_id	parent reference; implied by the file's place in the zip
s3_key	S3 key; the binary itself ships as a sibling file

ProjectChatReaction (project_chat_reaction)

Field	Type	From
id	string	column id
user_id	string	column user_id
reaction	string	column reaction
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
message_id	parent reference; implied by the file's place in the zip
organization_id	organization_id; implied by the export scope
project_id	parent reference; implied by the file's place in the zip

Schedule (schedules)

Field	Type	From
id	string	column id
project_id	string	column project_id
items	list[ScheduleItemExport]	derived
dependencies	list[ScheduleDependencyExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
organization_id	organization_id; implied by the export scope

ScheduleItem (schedule_items)

Field	Type	From
id	string	column id
kind	string	column kind
wbs_key	string or null	column wbs_key
name	string	column name
owner	string or null	column owner
owner_contact_id	string or null	column owner_contact_id
start_date	date or null	column start_date
finish_date	date or null	column finish_date
duration_days	number or null	column duration_days
status	string	column status
parent_item_id	string or null	column parent_item_id
position	number	column position
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
organization_id	organization_id; implied by the export scope
schedule_id	parent reference; implied by the file's place in the zip

ScheduleDependency (schedule_dependencies)

Field	Type	From
id	string	column id
predecessor_item_id	string	column predecessor_item_id
successor_item_id	string	column successor_item_id
dependency_type	string	column dependency_type
lag_days	number or null	column lag_days
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
organization_id	organization_id; implied by the export scope
schedule_id	parent reference; implied by the file's place in the zip

Workflow (workflows)

Field	Type	From
id	string	column id
organization_id	string	column organization_id
name	string	column name
description	string or null	column description
status	string	column status
project_ids	list[string]	column project_ids
trigger_config	object or list[any] or null	column trigger_config
data_config	object or list[any] or null	column data_config
prompt_config	object or list[any] or null	column prompt_config
output_config	object or list[any] or null	column output_config
email_config	object or list[any] or null	column email_config
last_run_at	datetime or null	column last_run_at
next_run_at	datetime or null	column next_run_at
kind	string	column kind
trigger_type	string	column trigger_type
project_selection_mode	string	column project_selection_mode
owner_project_id	string or null	column owner_project_id
author_id	string	column author_id
agent_id	string or null	column agent_id
model	string or null	column model
reasoning_effort	string or null	column reasoning_effort
managed_by_organization	boolean	column managed_by_organization
runs	list[WorkflowRunExport]	derived
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
builder_thread_id	internal worker, bot, upload or sync state
deleted_at	soft-delete or operational metadata
legacy_intake_exempt	internal worker, bot, upload or sync state
provided_key	internal worker, bot, upload or sync state

WorkflowRun (workflow_runs)

Field	Type	From
id	string	column id
workflow_id	string	column workflow_id
project_id	string or null	column project_id
status	string	column status
started_at	datetime	column started_at
completed_at	datetime or null	column completed_at
documents_processed	number	column documents_processed
report_content	string or null	column report_content
error_message	string or null	column error_message
outcome	string or null	column outcome
trigger_event	object or list[any] or null	column trigger_event
email_sent_at	datetime or null	column email_sent_at
email_recipients	list[string] or null	column email_recipients
result_record_type	string or null	column result_record_type
result_record_id	string or null	column result_record_id
agent_thread_id	string or null	column agent_thread_id
model	string or null	column model
run_config_snapshot	object or list[any] or null	column run_config_snapshot
created_at	datetime or null	column created_at
modified_at	datetime or null	column modified_at

Not exported:

Column	Reason
cost_usd	LLM usage accounting, not customer data
deleted_at	soft-delete or operational metadata
idempotency_key	internal worker, bot, upload or sync state
input_tokens	LLM usage accounting, not customer data
organization_id	organization_id; implied by the export scope
output_tokens	LLM usage accounting, not customer data
total_tokens	LLM usage accounting, not customer data