Column conventions, key types, and a quick-reference grain table for all core CRM_RAW tables.
Column roles
Every column is classified into one of these roles:
Role
Description
Example
PK
Primary key — globally unique identifier
GIFT_KEY
FK
Foreign key — references a primary key in another table
CONTACT_KEY
Identifier
Non-key internal numeric ID (not for joins)
GIFT_ID
Date/Time
Timestamp or date field
GIFT_DATE_UTC
Flag
Boolean true/false field
GIFT_IS_DELETED
System
Snowflake sync metadata column
SF__ROW_SYNCED_DATE_TIME_UTC
Attribute
All other business data columns
AMOUNT, NAME
Key column conventions
_KEY vs_ID
Suffix
Type
Use for joins?
Notes
_KEY
TEXT
Yes — always use this
Global hash-based key; stable across environments
_ID
NUMBER
No
Virtuous internal numeric ID; not reliable for cross-table joins
_IS_DELETED
Every table has an ENTITY_IS_DELETED flag. Always filter WHERE ENTITY_IS_DELETED = FALSE — soft-deleted records are retained in the table but should be excluded from reports.
SF__ prefix
Columns prefixed with SF__ are Snowflake sync metadata (e.g. SF__ROW_SYNCED_DATE_TIME_UTC). Use SF__ROW_SYNCED_DATE_TIME_UTC to check data freshness. These columns are not business data and can be ignored in most queries.
Core tables quick reference
Table
Grain
Primary Key
Key foreign keys
CONTACTS
One row per contact (household or org)
CONTACT_KEY
—
CONTACT_INDIVIDUALS
One row per person within a contact
CONTACT_INDIVIDUAL_KEY
CONTACT_KEY
GIFTS
One row per gift transaction
GIFT_KEY
CONTACT_KEY, SEGMENT_KEY
GIFT_DESIGNATIONS
One row per project split within a gift
GIFT_DESIGNATION_KEY
GIFT_KEY, PROJECT_KEY
PROJECTS
One row per fund or program
PROJECT_KEY
—
CAMPAIGNS
One row per campaign
CAMPAIGN_KEY
—
COMMUNICATIONS
One row per channel within a campaign
COMMUNICATION_KEY
CAMPAIGN_KEY
SEGMENTS
One row per audience subgroup within a communication
SEGMENT_KEY
COMMUNICATION_KEY
RECURRING_GIFTS
One row per recurring giving commitment
RECURRING_GIFT_KEY
CONTACT_KEY
RECURRING_GIFT_PAYMENTS
One row per recurring payment instance
RECURRING_GIFT_PAYMENT_KEY
RECURRING_GIFT_KEY, GIFT_KEY
PLEDGES
One row per pledge commitment
PLEDGE_KEY
CONTACT_KEY, GIFT_ASK_KEY
PLEDGE_PAYMENTS
One row per pledge installment
PLEDGE_PAYMENT_KEY
PLEDGE_KEY, GIFT_KEY
GIFT_ASKS
One row per formal gift solicitation
GIFT_ASK_KEY
CONTACT_KEY, PROJECT_KEY
TASKS
One row per task associated with a contact
TASK_KEY
CONTACT_KEY
RECEIPTS
One row per receipt issued to a contact
RECEIPT_KEY
CONTACT_KEY
TYPE_REFERENCES
One row per valid code value
—
—
All tables above are in the CRM_RAW table group. In Snowflake SQL, reference them as [database].[schema].TABLE_NAME.
Finding columns with numeric codes
To identify every column in the schema that may need a decode lookup:
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, COMMENT AS DESCRIPTIONFROM [database].INFORMATION_SCHEMA.COLUMNSWHERE TABLE_SCHEMA = '[schema]' AND ( COLUMN_NAME LIKE '%STATUS%' OR COLUMN_NAME LIKE '%TYPE%' OR COLUMN_NAME LIKE '%FREQUENCY%' ) AND COLUMN_NAME NOT LIKE '%_KEY' AND COLUMN_NAME NOT LIKE '%_ID'ORDER BY TABLE_NAME, COLUMN_NAME;
Cross-reference the results against Lookup values to find the correct ENTITY and PROPERTY values for the decode join.
Data freshness: These tables sync continuously from Virtuous CRM. Typical lag is under 4 hours. To check when a record was last updated, inspect the SF__ROW_SYNCED_DATE_TIME_UTC column on any table.
Last modified on May 22, 2026
Was this page helpful?
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Virtuous API Docs","colors":{"primary":"#00A3E0","light":"#00A3E0","dark":"#00A3E0"},"logo":{"light":"https://mintcdn.com/virtuous-7a5d9ba3/3Z-OfpCv07Qt6t9Z/logo/light.svg?fit=max\u0026auto=format\u0026n=3Z-OfpCv07Qt6t9Z\u0026q=85\u0026s=a4a7a0098ed125e3782554092ea0c518","dark":"https://mintcdn.com/virtuous-7a5d9ba3/3Z-OfpCv07Qt6t9Z/logo/dark.svg?fit=max\u0026auto=format\u0026n=3Z-OfpCv07Qt6t9Z\u0026q=85\u0026s=942d0c1a195f85aa0edf4f6fbd3d5413","href":"https://virtuous.org"},"favicon":"https://mintcdn.com/virtuous-7a5d9ba3/3Z-OfpCv07Qt6t9Z/favicon.png?fit=max\u0026auto=format\u0026n=3Z-OfpCv07Qt6t9Z\u0026q=85\u0026s=4fd5393f4a0f0339258c9a2caad66f77","api":{"playground":{"display":"interactive"},"examples":{"defaults":"all","languages":["bash","javascript","python","dotnet","php","java","ruby","node"],"prefill":true,"autogenerate":true},"url":"full"},"appearance":{"default":"light"},"background":{"decoration":"windows","color":{"dark":"#081F2C"}},"navbar":{"links":[{"href":"https://app.virtuoussoftware.com/Account/Login","label":"Login"}],"primary":{"type":"button","label":"Request a Demo","href":"https://virtuous.org/schedule-a-demo/"}},"footer":{"socials":{"x":"https://x.com/virtuouscrm","facebook":"https://www.facebook.com/virtuouscrm","linkedin":"https://www.linkedin.com/company/virtuous","youtube":"https://www.youtube.com/VirtuousSoftware","instagram":"https://www.instagram.com/virtuouscrm"},"links":[{"header":"CRM","items":[{"label":"Login","href":"https://app.virtuoussoftware.com/Account/Login"},{"label":"Features","href":"https://virtuous.org/software/crm"},{"label":"Help Center","href":"https://support.virtuous.org/hc/en-us"}]},{"header":"RAISE","items":[{"label":"Login","href":"https://app.raisedonors.com/"},{"label":"Features","href":"https://explore.raisedonors.com/"},{"label":"Help Center","href":"https://help.raisedonors.com/hc/en-us"}]},{"header":"VOLUNTEER","items":[{"label":"Login","href":"https://app.vomo.org/login"},{"label":"Features","href":"https://virtuous.org/software/volunteer"},{"label":"Help Center","href":"https://support.vomo.org/hc/en-us"}]}]},"seo":{"metatags":{"robots":"noindex"}},"fonts":{"family":"Inter","format":"woff2"},"errors":{"404":{"redirect":false,"title":"Page Not Found"}},"contextual":{"options":["copy","view","chatgpt","claude","perplexity","mcp","cursor","vscode"],"display":"header"},"interaction":{"drilldown":true},"metadata":{"timestamp":true},"markdown":{"schema":false},"styling":{"latex":true},"navigation":{"global":{"anchors":[{"anchor":"Status","icon":"chart-simple","href":"https://virtuous.org/system-status/"},{"anchor":"Help Center","icon":"headset","href":"https://virtuous.org/resources/help-center"},{"anchor":"Product Hub","icon":"newspaper","href":"https://product.virtuous.org/"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"virtuous-7a5d9ba3","hasAudioNarration":false,"actualSubdomain":"virtuous-7a5d9ba3","customDomains":["docs.virtuous.org"],"gitSource":{"type":"github","owner":"virtuouscrm","repo":"api-docs-mintlify","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"feedback":{"thumbs":true,"agentFeedback":true,"contextualFeedback":{"allowEmail":true}},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"REMOVE_BRANDING":{"status":"ENABLED"},"CONTEXTUAL_FEEDBACK":{"status":"ENABLED"},"CODE_SNIPPET_FEEDBACK":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6b007f5089d041245aff48e0","clientVersion":"0.0.4269","searchFilterCounts":[{"language":"default","tag":"API Reference","count":468},{"language":"default","tag":"Virtuous CRM+","count":352},{"language":"default","tag":"Virtuous RAISE","count":181},{"language":"default","tag":"Guides","count":140},{"language":"default","tag":"Contacts and Individuals","count":98},{"language":"default","tag":"Virtuous VOLUNTEER","count":66},{"language":"default","tag":"Giving","count":63},{"language":"default","tag":"Donor","count":46},{"language":"default","tag":"Projects","count":34},{"language":"default","tag":"Workflows","count":26}],"searchSettings":{"showContentSnippets":true,"isFiltersEnabled":true}},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":true,"enableContextualStarterQuestions":true,"enableAskAiSearchBar":true,"deflection":{"enabled":true,"email":"integrations@virtuous.org"}},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"site-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"#page-title{color:#243746}.dark #page-title{color:#FFFFFF}"}]}
{"page":{"pagePath":"analytics/reference/column-reference","slug":"/analytics/reference/column-reference","pageMetadata":{"title":"Column Reference","description":"Column conventions, key types, and a quick-reference grain table for all core CRM_RAW tables.","href":"/analytics/reference/column-reference"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Column conventions, key types, and a quick-reference grain table for all core CRM_RAW tables.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,blockquote:`blockquote`,code:`code`,hr:`hr`,p:`p`,pre:`pre`,span:`span`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{CodeBlock,Heading,Table,Tip}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Tip)_missingMdxReference(`Tip`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`column-roles`,children:_jsx(_components.strong,{children:`Column roles`})}),`\n`,_jsx(_components.p,{children:`Every column is classified into one of these roles:`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{style:{textAlign:`left`},children:_jsx(_components.strong,{children:`Role`})}),_jsx(_components.th,{style:{textAlign:`left`},children:_jsx(_components.strong,{children:`Description`})}),_jsx(_components.th,{style:{textAlign:`left`},children:_jsx(_components.strong,{children:`Example`})})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`PK`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`Primary key — globally unique identifier`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`GIFT_KEY`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`FK`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`Foreign key — references a primary key in another table`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CONTACT_KEY`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`Identifier`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`Non-key internal numeric ID (not for joins)`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`GIFT_ID`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`Date/Time`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`Timestamp or date field`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`GIFT_DATE_UTC`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`Flag`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`Boolean true/false field`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`GIFT_IS_DELETED`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`System`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`Snowflake sync metadata column`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`SF__ROW_SYNCED_DATE_TIME_UTC`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`Attribute`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`All other business data columns`}),_jsxs(_components.td,{style:{textAlign:`left`},children:[_jsx(_components.code,{children:`AMOUNT`}),`, `,_jsx(_components.code,{children:`NAME`})]})]})]})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`key-column-conventions`,children:_jsx(_components.strong,{children:`Key column conventions`})}),`\n`,_jsxs(Heading,{level:`3`,id:`_key-vs-_id`,children:[_jsx(_components.code,{children:`_KEY `}),_jsx(_components.strong,{children:`vs`}),` `,_jsx(_components.code,{children:`_ID`})]}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{style:{textAlign:`left`},children:_jsx(_components.strong,{children:`Suffix`})}),_jsx(_components.th,{style:{textAlign:`left`},children:_jsx(_components.strong,{children:`Type`})}),_jsx(_components.th,{style:{textAlign:`left`},children:_jsx(_components.strong,{children:`Use for joins?`})}),_jsx(_components.th,{style:{textAlign:`left`},children:_jsx(_components.strong,{children:`Notes`})})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`_KEY`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`TEXT`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Yes — always use this`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Global hash-based key; stable across environments`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`_ID`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`NUMBER`}),_jsx(_components.td,{style:{textAlign:`left`},children:`No`}),_jsx(_components.td,{style:{textAlign:`left`},children:`Virtuous internal numeric ID; not reliable for cross-table joins`})]})]})]}),`\n`,_jsx(Heading,{level:`3`,id:`_is_deleted`,children:_jsx(_components.code,{children:`_IS_DELETED`})}),`\n`,_jsxs(_components.p,{children:[`Every table has an `,_jsx(_components.code,{children:`ENTITY_IS_DELETED`}),` flag. Always filter `,_jsx(_components.code,{children:`WHERE ENTITY_IS_DELETED = FALSE`}),` — soft-deleted records are retained in the table but should be excluded from reports.`]}),`\n`,_jsxs(Heading,{level:`3`,id:`sf__-prefix`,children:[_jsx(_components.code,{children:`SF__ `}),_jsx(_components.strong,{children:`prefix`})]}),`\n`,_jsxs(_components.p,{children:[`Columns prefixed with `,_jsx(_components.code,{children:`SF__`}),` are Snowflake sync metadata (e.g. `,_jsx(_components.code,{children:`SF__ROW_SYNCED_DATE_TIME_UTC`}),`). Use `,_jsx(_components.code,{children:`SF__ROW_SYNCED_DATE_TIME_UTC`}),` to check data freshness. These columns are not business data and can be ignored in most queries.`]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`core-tables-quick-reference`,children:_jsx(_components.strong,{children:`Core tables quick reference`})}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{style:{textAlign:`left`},children:_jsx(_components.strong,{children:`Table`})}),_jsx(_components.th,{style:{textAlign:`left`},children:_jsx(_components.strong,{children:`Grain`})}),_jsx(_components.th,{style:{textAlign:`left`},children:_jsx(_components.strong,{children:`Primary Key`})}),_jsx(_components.th,{style:{textAlign:`left`},children:_jsx(_components.strong,{children:`Key foreign keys`})})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CONTACTS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per contact (household or org)`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CONTACT_KEY`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`—`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CONTACT_INDIVIDUALS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per person within a contact`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CONTACT_INDIVIDUAL_KEY`})}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CONTACT_KEY`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`GIFTS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per gift transaction`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`GIFT_KEY`})}),_jsxs(_components.td,{style:{textAlign:`left`},children:[_jsx(_components.code,{children:`CONTACT_KEY`}),`, `,_jsx(_components.code,{children:`SEGMENT_KEY`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`GIFT_DESIGNATIONS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per project split within a gift`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`GIFT_DESIGNATION_KEY`})}),_jsxs(_components.td,{style:{textAlign:`left`},children:[_jsx(_components.code,{children:`GIFT_KEY`}),`, `,_jsx(_components.code,{children:`PROJECT_KEY`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`PROJECTS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per fund or program`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`PROJECT_KEY`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`—`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CAMPAIGNS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per campaign`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CAMPAIGN_KEY`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`—`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`COMMUNICATIONS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per channel within a campaign`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`COMMUNICATION_KEY`})}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CAMPAIGN_KEY`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`SEGMENTS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per audience subgroup within a communication`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`SEGMENT_KEY`})}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`COMMUNICATION_KEY`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`RECURRING_GIFTS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per recurring giving commitment`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`RECURRING_GIFT_KEY`})}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CONTACT_KEY`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`RECURRING_GIFT_PAYMENTS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per recurring payment instance`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`RECURRING_GIFT_PAYMENT_KEY`})}),_jsxs(_components.td,{style:{textAlign:`left`},children:[_jsx(_components.code,{children:`RECURRING_GIFT_KEY`}),`, `,_jsx(_components.code,{children:`GIFT_KEY`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`PLEDGES`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per pledge commitment`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`PLEDGE_KEY`})}),_jsxs(_components.td,{style:{textAlign:`left`},children:[_jsx(_components.code,{children:`CONTACT_KEY`}),`, `,_jsx(_components.code,{children:`GIFT_ASK_KEY`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`PLEDGE_PAYMENTS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per pledge installment`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`PLEDGE_PAYMENT_KEY`})}),_jsxs(_components.td,{style:{textAlign:`left`},children:[_jsx(_components.code,{children:`PLEDGE_KEY`}),`, `,_jsx(_components.code,{children:`GIFT_KEY`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`GIFT_ASKS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per formal gift solicitation`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`GIFT_ASK_KEY`})}),_jsxs(_components.td,{style:{textAlign:`left`},children:[_jsx(_components.code,{children:`CONTACT_KEY`}),`, `,_jsx(_components.code,{children:`PROJECT_KEY`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`TASKS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per task associated with a contact`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`TASK_KEY`})}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CONTACT_KEY`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`RECEIPTS`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per receipt issued to a contact`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`RECEIPT_KEY`})}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CONTACT_KEY`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`TYPE_REFERENCES`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`One row per valid code value`}),_jsx(_components.td,{style:{textAlign:`left`},children:`—`}),_jsx(_components.td,{style:{textAlign:`left`},children:`—`})]})]})]}),`\n`,_jsxs(_components.blockquote,{children:[`\n`,_jsxs(_components.p,{children:[`All tables above are in the `,_jsx(_components.code,{children:`CRM_RAW`}),` table group. In Snowflake SQL, reference them as `,_jsx(_components.code,{children:`[database].[schema].TABLE_NAME`}),`.`]}),`\n`]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`finding-columns-with-numeric-codes`,children:_jsx(_components.strong,{children:`Finding columns with numeric codes`})}),`\n`,_jsx(_components.p,{children:`To identify every column in the schema that may need a decode lookup:`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`16`,language:`text`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`text`,children:_jsxs(_components.code,{language:`text`,numberOfLines:`16`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`SELECT`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:` TABLE_NAME,`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:` COLUMN_NAME,`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:` DATA_TYPE,`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:` COMMENT AS DESCRIPTION`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`FROM [database].INFORMATION_SCHEMA.COLUMNS`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`WHERE TABLE_SCHEMA = '[schema]'`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:` AND (`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:` COLUMN_NAME LIKE '%STATUS%'`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:` OR COLUMN_NAME LIKE '%TYPE%'`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:` OR COLUMN_NAME LIKE '%FREQUENCY%'`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:` )`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:` AND COLUMN_NAME NOT LIKE '%_KEY'`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:` AND COLUMN_NAME NOT LIKE '%_ID'`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{children:`ORDER BY TABLE_NAME, COLUMN_NAME;`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{})})]})})}),`\n`,_jsxs(_components.p,{children:[`Cross-reference the results against `,_jsx(_components.a,{href:`https://github.com/jgunkelvirtuous/mintlify-virtuous-data-documentation/blob/main/data-models/reference/lookup-values`,children:_jsx(`u`,{children:`Lookup values`})}),` to find the correct `,_jsx(_components.code,{children:`ENTITY`}),` and `,_jsx(_components.code,{children:`PROPERTY`}),` values for the decode join.`]}),`\n`,_jsx(Tip,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Data freshness:`}),` These tables sync continuously from Virtuous CRM. Typical lag is under 4 hours. To check when a record was last updated, inspect the `,_jsx(_components.code,{children:`SF__ROW_SYNCED_DATE_TIME_UTC`}),` column on any table.`]})})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Column Reference","description":"Column conventions, key types, and a quick-reference grain table for all core CRM_RAW tables.","href":"/analytics/reference/column-reference"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Column roles","slug":"column-roles","depth":2,"children":[]},{"title":"Key column conventions","slug":"key-column-conventions","depth":2,"children":[{"title":"_KEY vs _ID","slug":"_key-vs-_id","depth":3,"children":[]},{"title":"_IS_DELETED","slug":"_is_deleted","depth":3,"children":[]},{"title":"SF__ prefix","slug":"sf__-prefix","depth":3,"children":[]}]},{"title":"Core tables quick reference","slug":"core-tables-quick-reference","depth":2,"children":[]},{"title":"Finding columns with numeric codes","slug":"finding-columns-with-numeric-codes","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"virtuous-7a5d9ba3","siteName":"Virtuous API Docs","title":"Column Reference - Virtuous API Docs","relatedPagesConfig":{"enabled":true,"limit":4,"mode":"automatic"},"contextualStarterQuestions":[{"_id":"6afc8dc8cf0ecb9705430ee1","deploymentId":"69d93d41280a4ed8d7469c6f","questionText":"How do I filter soft-deleted records?","status":"active","generatedBy":"contextual","path":"analytics/reference/column-reference","createdAt":"2026-11-17T17:24:24.608Z","updatedAt":"2026-11-17T17:24:24.608Z","__v":0},{"_id":"6afc8dc8cf0ecb9705430ee2","deploymentId":"69d93d41280a4ed8d7469c6f","questionText":"What does the grain column mean?","status":"active","generatedBy":"contextual","path":"analytics/reference/column-reference","createdAt":"2026-11-17T17:24:24.608Z","updatedAt":"2026-11-17T17:24:24.608Z","__v":0}],"navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{},"searchTabScopes":[{"product":"Virtuous","tab":"Guides"},{"product":"Virtuous","tab":"Partners"},{"product":"Virtuous","tab":"MCP"},{"product":"Virtuous","tab":"Glossary"},{"product":"Virtuous CRM+","tab":"Guides"},{"product":"Virtuous CRM+","tab":"API Reference"},{"product":"Virtuous CRM+","tab":"Changelog"},{"product":"Virtuous RAISE","tab":"Guides"},{"product":"Virtuous RAISE","tab":"API Reference"},{"product":"Virtuous RAISE","tab":"Changelog"},{"product":"Virtuous ANALYTICS","tab":"Data Models"},{"product":"Virtuous ANALYTICS","tab":"Changelog"},{"product":"Virtuous VOLUNTEER","tab":"Guides"},{"product":"Virtuous VOLUNTEER","tab":"API Reference"},{"product":"Virtuous VOLUNTEER","tab":"Changelog"},{"product":"Virtuous MOMENTUM","tab":"Guides"},{"product":"Virtuous MOMENTUM","tab":"Changelog"}]},"lastModified":"2026-11-17T17:24:01.878Z","gitLastModified":"2026-05-22T15:21:05.000Z","originalFileLocation":"analytics/reference/column-reference.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"light\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Column conventions, key types, and a quick-reference grain table for all core CRM_RAW tables.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Virtuous API Docs\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003cmeta data-mint-head name=\"robots\" content=\"noindex\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/virtuous-7a5d9ba3/vpUGFW8SOljP6x0V/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/virtuous-7a5d9ba3/vpUGFW8SOljP6x0V/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/virtuous-7a5d9ba3/vpUGFW8SOljP6x0V/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/virtuous-7a5d9ba3/vpUGFW8SOljP6x0V/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/virtuous-7a5d9ba3/vpUGFW8SOljP6x0V/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/virtuous-7a5d9ba3/vpUGFW8SOljP6x0V/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/virtuous-7a5d9ba3/vpUGFW8SOljP6x0V/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/virtuous-7a5d9ba3/vpUGFW8SOljP6x0V/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/virtuous-7a5d9ba3/vpUGFW8SOljP6x0V/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Column Reference - Virtuous API Docs\">\u003cmeta data-mint-head property=\"og:description\" content=\"Column conventions, key types, and a quick-reference grain table for all core CRM_RAW tables.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Virtuous API Docs\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.virtuous.org/analytics/reference/column-reference\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://virtuous-7a5d9ba3.mintlify.site/_mintlify/api/og/v2?division=Reference\u0026amp;title=Column+Reference\u0026amp;description=Column+conventions%2C+key+types%2C+and+a+quick-reference+grain+table+for+all+core+CRM_RAW+tables.\u0026amp;theme=483f305e7e8c97e32e572c97\u0026amp;signature=9b522339641f6740d3551e8817af470066f1da68860032bada53ab06b1903b8e\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Column Reference - Virtuous API Docs\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Column conventions, key types, and a quick-reference grain table for all core CRM_RAW tables.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://virtuous-7a5d9ba3.mintlify.site/_mintlify/api/og/v2?division=Reference\u0026amp;title=Column+Reference\u0026amp;description=Column+conventions%2C+key+types%2C+and+a+quick-reference+grain+table+for+all+core+CRM_RAW+tables.\u0026amp;theme=483f305e7e8c97e32e572c97\u0026amp;signature=9b522339641f6740d3551e8817af470066f1da68860032bada53ab06b1903b8e\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/virtuous-7a5d9ba3/vpUGFW8SOljP6x0V/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Virtuous API Docs\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#00A3E0\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.virtuous.org/analytics/reference/column-reference\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/analytics/reference/column-reference.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.virtuous.org/#organization\",\"name\":\"Virtuous API Docs\",\"url\":\"https://docs.virtuous.org\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/virtuous-7a5d9ba3/3Z-OfpCv07Qt6t9Z/logo/light.svg?fit=max\u0026auto=format\u0026n=3Z-OfpCv07Qt6t9Z\u0026q=85\u0026s=a4a7a0098ed125e3782554092ea0c518\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.virtuous.org#website\",\"name\":\"Virtuous API Docs\",\"url\":\"https://docs.virtuous.org\",\"publisher\":{\"@id\":\"https://docs.virtuous.org/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.virtuous.org/analytics/reference/column-reference#webpage\",\"url\":\"https://docs.virtuous.org/analytics/reference/column-reference\",\"name\":\"Column Reference\",\"description\":\"Column conventions, key types, and a quick-reference grain table for all core CRM_RAW tables.\",\"dateModified\":\"2026-05-22T15:21:05.000Z\",\"isPartOf\":{\"@id\":\"https://docs.virtuous.org#website\"},\"breadcrumb\":{\"@id\":\"https://docs.virtuous.org/analytics/reference/column-reference#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.virtuous.org/analytics/reference/column-reference#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Reference\",\"item\":\"https://docs.virtuous.org/analytics/reference/campaign-attribution\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Column Reference\",\"item\":\"https://docs.virtuous.org/analytics/reference/column-reference\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.virtuous.org/analytics/reference/column-reference#article\",\"headline\":\"Column Reference\",\"name\":\"Column Reference\",\"description\":\"Column conventions, key types, and a quick-reference grain table for all core CRM_RAW tables.\",\"url\":\"https://docs.virtuous.org/analytics/reference/column-reference\",\"mainEntityOfPage\":{\"@id\":\"https://docs.virtuous.org/analytics/reference/column-reference#webpage\"},\"dateModified\":\"2026-05-22T15:21:05.000Z\",\"publisher\":{\"@id\":\"https://docs.virtuous.org/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.virtuous.org#website\"}}]}\u003c/script>","agentPointerHref":"/analytics/reference/column-reference.md","siteName":"Virtuous API Docs","nav":{"global":{"anchors":[{"anchor":"Status","icon":"chart-simple","href":"https://virtuous.org/system-status/"},{"anchor":"Help Center","icon":"headset","href":"https://virtuous.org/resources/help-center"},{"anchor":"Product Hub","icon":"newspaper","href":"https://product.virtuous.org/"}]},"products":[{"product":"Virtuous","pages":[{"title":"Virtuous","href":""}]},{"product":"Virtuous CRM+","color":{"light":"#00a3e3","dark":"#00a3e3"},"pages":[{"title":"Virtuous CRM+","href":"/crm/overview"}]},{"product":"Virtuous RAISE","color":{"light":"#00a3e3","dark":"#00a3e3"},"pages":[{"title":"Virtuous RAISE","href":"/raise/overview"}]},{"product":"Virtuous ANALYTICS","tabs":[{"tab":"Data Models","groups":[{"group":"Overview","pages":[{"title":"Data Model Overview","href":"/analytics/data-model-overview"},{"title":"Engagement Flow","href":"/analytics/engagement-flow"},{"title":"Giving Flow","href":"/analytics/giving-flow"}]},{"group":"Reference","pages":[{"title":"Campaign Attribution","href":"/analytics/reference/campaign-attribution"},{"title":"Campaigns","description":"All tables in the campaigns hub — communications, segments, emails, sent emails, events, and segment statistics.","href":"/analytics/reference/campaigns"},{"title":"Column Reference","href":"/analytics/reference/column-reference"},{"title":"Contact Profile","description":"The contact record and its related engagement data — individuals, notes, tasks, and receipts.","href":"/analytics/reference/contact-profile"},{"title":"Contacts","href":"/analytics/reference/contacts"},{"title":"Core Gift Transaction","href":"/analytics/reference/gift-transaction"},{"title":"Gifts","href":"/analytics/reference/gifts"},{"title":"Lookup Values","href":"/analytics/reference/lookup-values"},{"title":"Pledges \u0026 Gift Asks","href":"/analytics/reference/pledges"},{"title":"Receipts","href":"/analytics/reference/receipts"},{"title":"Recurring Giving","href":"/analytics/reference/recurring-giving"}]}]},{"tab":"Changelog","pages":[{"title":"Changelog","href":"/changelog/analytics"}]}]},{"product":"Virtuous VOLUNTEER","color":{"light":"#00a3e3","dark":"#00a3e3"},"pages":[{"title":"Virtuous VOLUNTEER","href":"/volunteer/overview"}]},{"product":"Virtuous MOMENTUM","pages":[{"title":"Virtuous MOMENTUM","href":"/momentum/overview"}]}]},"basePath":"","title":"Column Reference - Virtuous API Docs","deploymentId":"dpl_7LpC8LvxVNTZSB7twCcVwH4TeFKv","buildId":"dpl_7LpC8LvxVNTZSB7twCcVwH4TeFKv","dynamics":[],"chunks":[]}