table_name,field_name,field_type,theme,description,mapped_from_table,mapped_from_field,mapping_type,release_date,relationship_category,cardinality,exclude_from_live_insights
followStatus,id,NVARCHAR(64),Primary Id,The primary id for items in this table.,,,,prod,,,false
followStatus,userId,NVARCHAR(64),Who,The id of the user who is following the object.,users,id,,prod,,Nto1,false
followStatus,userFullName,NVARCHAR(128),Who,The name of the user who is following the object.,,,,prod,,,false
followStatus,occurredAt,TIMESTAMP,When,The date and time when the user started following the object.,,,,prod,,,false
followStatus,modifiedAt,TIMESTAMP,modifiedAt,"Same date and time as occurredAt, but aliased to proxy as system date.",,,,prod,,,false
followStatus,followedObject,NVARCHAR(64),What,The type of object being followed by the user.,,,,prod,,,false
followStatus,contentId,NVARCHAR(64),What,The id of the content being followed.,libraryContents,id,,prod,,Nto1,false
followStatus,contentName,NVARCHAR(64),What,The name of the content being followed.,,,,prod,,,false
followStatus,contentOwnerId,NVARCHAR(64),Who,The id of the owner of this content.,users,id,,prod,,Nto1,false
followStatus,contentOwnerUsername,NVARCHAR(256),Who,The username of the owner of this content.,,,,prod,,,false
followStatus,contentOwnerEmail,NVARCHAR(256),What,The email address of the owner of this content.,,,,prod,,,false
followStatus,teamsiteName,NVARCHAR(128),What,The name of the teamsite this content exists in.,,,,prod,,,false
followStatus,folderId,NVARCHAR(64),What,The id of the folder being followed.,,,,prod,,,false
followStatus,folderName,NVARCHAR(64),What,The name of the folder being followed.,,,,prod,,,false
followStatus,profileId,NVARCHAR(64),What,The id of the profile being followed.,contentProfiles,id,,prod,,Nto1,false
followStatus,profileName,NVARCHAR(64),What,The name of the profile being followed.,,,,prod,,,false
interactionContexts,id,NVARCHAR(64),Primary Id,The primary id for items in this table.,,,,prod,,,false
interactionContexts,interactionId,NVARCHAR(64),How,The id of the interaction to which this context is related.,userActivity,interactionId,,prod,informational,Nto1,false
interactionContexts,systemType,NVARCHAR(128),Where,"The identifier of the system type such as Salesforce, Dynamics, Sugar CRM, etc... that this context refers to.",,,,prod,,,false
interactionContexts,systemId,NVARCHAR(256),Where,"The id that uniquely identifies the specific instance of the external system, such as the Salesforce Org id.",,,,prod,,,false
interactionContexts,contextType,NVARCHAR(128),How,"The identifier of the type in the external integration system that this context refers to, typically the record type such as Opportunity, Contact, Account, etc...",,,,prod,,,false
interactionContexts,contextId,NVARCHAR(256),Where,An id that refers to a record of the respective contextType in the respective instance of the external system.,crmOpportunity,udm_id,,prod,informational,Nto1,false
interactionContexts,contextSourceType,NVARCHAR(64),Where,The type of the source that this integration context came from.,,,,prod,,,false
interactionContexts,contextSource,NVARCHAR(64),Where,The name of the application or integration which collected the context.,,,,prod,,,false
interactionContexts,udmContextId,NVARCHAR(64),Where,The id of the unified data model context that aligns with this interaction context.,,,,prod,,,false
interactionContexts,udmContextHistoryId,NVARCHAR(64),Where,The id of the unified data model snapshot that aligns with this interaction context.,historyCrmOpportunity,udm_historyId,,prod,informational,Nto1,false
interactionContexts,isDeleted,BOOLEAN,How,Flag indicating whether or not this context has been deleted.,,,,prod,,,false
interactionContexts,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
interactionContexts,interactionRecipientId,NVARCHAR(64),How,The id of the interaction recipient this context relates to.,,,,prod,,,false
interactionContexts,contextName,NVARCHAR(512),Where,"The name of the external record that the interaction relates to. This is typically the CRM record Name of a specific Opportunity, Contact, Account, etc. but can also contain the name of a record in a custom application.",,,,prod,,,false
interactionContexts,contextEmail,NVARCHAR(256),Where,The email address associated with the external record that this interaction relates to. This typically is only available for external records that represent people like Contact or Lead.,,,,prod,,,false
interactionContexts,systemName,NVARCHAR(256),Where,The name for the CRM system that the context is sourced from.,,,,prod,,,false
contentVersions,id,NVARCHAR(64),Primary Id,The version id of the content which can globally identify content versions from Library or WorkSpace.,,,,prod,,,false
contentVersions,libraryContentVersionId,NVARCHAR(64),What,The version id of the Library content. This id will populate when the content originated from the Seismic Library.,libraryContentVersions,id,,prod,informational,1to1,false
contentVersions,workspaceContentVersionId,NVARCHAR(64),What,The version id of the WorkSpace content.,workspaceContentVersions,id,,prod,informational,1to1,false
contentVersions,contentId,NVARCHAR(64),What,The id of the content which can globally identify content from Library or WorkSpace.,contents,id,,prod,,1to1,false
contentVersions,libraryContentId,NVARCHAR(64),What,The Library content id of the content. This id will populate when the content originated from the Seismic Library.,,,,prod,,,false
contentVersions,workspaceContentId,NVARCHAR(64),What,The WorkSpace content id.,,,,prod,,,false
contentVersions,isLatestVersion,BOOLEAN,What,Boolean indicating if this is the latest version of the content. The latest version of the content can be a published or non-published version.,,,,prod,,,false
contentVersions,repository,NVARCHAR(9),What,The repository where content version is located.,,,,prod,,,false
contentVersions,name,NVARCHAR(512),What,The name of the content the version is associated with.,,,,prod,,,false
contentVersions,thumbnailImageUrl,NVARCHAR(MAX),What,A URL to the lower resolution thumbnail image for this content version.,,,,prod,,,false
contentVersions,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
contentVersions,createdAt,TIMESTAMP,When,The timestamp when the record was created.,,,,prod,,,false
livesendViewingSessions,id,NVARCHAR(64),Primary Id,The primary id for items in this table.,,,,prod,,,false
livesendViewingSessions,livesendLinkId,NVARCHAR(64),What,"The Id of the livesendLink that contained the page on which the view occurred. Note - If LiveSend was sent from the system with ‘send separate emails’ checked, then the Viewing Session will be unique per recipient of the email. If LiveSend was sent from the system with ‘send one email to group,’ then the Viewing Session will not be unique per recipient of the email, and there will be no way to track which recipient from the recipient group is associated with each viewing session.",livesendLinks,id,,prod,primary,Nto1,false
livesendViewingSessions,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
livesendViewingSessions,sessionEndedAt,TIMESTAMP,When,The datetime that the viewing session ended in the recipient's browser.,,,,prod,,,false
livesendViewingSessions,sessionStartedAt,TIMESTAMP,When,The datetime that the viewing session started in the recipient's browser.,,,,prod,,,false
livesendViewingSessions,roomDurationSeconds,INTEGER,What,The number of seconds the buyer spent on the landing page (as opposed to content).,,,,prod,,,false
livesendViewingSessions,userWasLoggedIn,BOOLEAN,What,Whether or not the user was logged in during the session.,,,,prod,,,false
livesendViewingSessions,userLoginType,NVARCHAR(64),What,The type of user login.,,,,prod,,,false
livesendViewingSessions,geolocationLatitude,NVARCHAR(64),Where,Latitude for where the user was located when they viewed the LiveSend.,,,,prod,,,false
livesendViewingSessions,geolocationLongitude,NVARCHAR(64),Where,Longitude for where the user was located when they viewed the LiveSend.,,,,prod,,,false
livesendViewingSessions,ipAddress,NVARCHAR(64),Where,IP Address for where the user was located when they viewed the LiveSend.,,,,prod,,,false
livesendViewingSessions,city,NVARCHAR(64),Where,Name of the city where the user was located when they viewed the LiveSend.,,,,prod,,,false
livesendViewingSessions,state,NVARCHAR(64),Where,Name of the state where the user was located when they viewed the LiveSend (USA only).,,,,prod,,,false
livesendViewingSessions,country,NVARCHAR(64),Where,Name of the country where the user was located when they viewed the LiveSend (USA only).,,,,prod,,,false
livesendViewingSessions,engagementUserEmail,NVARCHAR(64),Who,Email of the user who is engaging with the digital room. Includes both internal and external user emails.,,,,prod,,,false
livesendViewingSessions,isInternalUser,BOOLEAN,Who,Identifies whether the user is a Seismic user.,,,,prod,,,false
livesendViewingSessions,interactionId,NVARCHAR(64),What,The id of the interaction relating to this viewing session.,,,,prod,,,false
livesendViewingSessions,interactionGroupId,NVARCHAR(64),What,"Represents the ""container"" around a group of livesends. Such containers can be email blasts, digital sales rooms, etc.",,,,prod,,,false
livesendViewingSessions,totalContentViewingDurationSeconds,INTEGER,What,The total number of seconds spent actively viewing content as part of this session.,,,,prod,,,false
generatedLivedocFields,id,NVARCHAR(64),Primary Id,"The primary id for items in this table. Note - this table reflects data on the generated LiveDoc's ""Tracked Fields"". Tracked Fields are designated in the Library (Content Manager).",,,,prod,,,false
generatedLivedocFields,generatedLivedocId,NVARCHAR(64),What,The id of the generated livedoc that this data belongs to.,generatedLivedocs,id,,prod,primary,Nto1,false
generatedLivedocFields,fieldType,NVARCHAR(32),What,"The type of Tracked Field such as integer, string, float, date.",,,,prod,,,false
generatedLivedocFields,fieldName,NVARCHAR(128),What,The name of the Tracked Field.,,,,prod,,,false
generatedLivedocFields,fieldValue,NVARCHAR(MAX),What,The value of the Tracked Field.,,,,prod,,,false
generatedLivedocFields,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
livedocCustomContentDataSourceRetrieveDataRequests,id,NVARCHAR(64),Primary Id,The id and primary key of the LiveDoc DataSource retrieve data requests for custom content.,,,,prod,,,false
livedocCustomContentDataSourceRetrieveDataRequests,region,NVARCHAR(512),What,The region of this request.,,,,prod,,,false
livedocCustomContentDataSourceRetrieveDataRequests,requestTime,TIMESTAMP,When,The datetime of the request occurrence.,,,,prod,,,false
livedocCustomContentDataSourceRetrieveDataRequests,dataSourceLibraryContentId,NVARCHAR(64),What,The id of the DataSource library content.,libraryContents,id,,prod,,Nto1,false
livedocCustomContentDataSourceRetrieveDataRequests,dataSourceLibraryContentVersionId,NVARCHAR(64),What,The id of the DataSource library content version.,libraryContentVersions,id,,prod,,Nto1,false
livedocCustomContentDataSourceRetrieveDataRequests,dataSourceLibraryContentName,NVARCHAR(512),What,The name of the DataSource library content.,,,,prod,,,false
livedocCustomContentDataSourceRetrieveDataRequests,customContentId,NVARCHAR(64),What,The id of the custom content.,,,,prod,,,false
livedocCustomContentDataSourceRetrieveDataRequests,customContentName,NVARCHAR(512),What,The name of the custom content.,,,,prod,,,false
livedocCustomContentDataSourceRetrieveDataRequests,customContentVersion,NVARCHAR(512),What,The version number of this custom content.,,,,prod,,,false
livedocCustomContentDataSourceRetrieveDataRequests,customContentTypeName,NVARCHAR(512),What,The name of the custom content schema name.,,,,prod,,,false
livedocCustomContentDataSourceRetrieveDataRequests,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
announcements,id,NVARCHAR(64),Primary Id,The id of the announcement.,,,,prod,,,false
announcements,announcementName,NVARCHAR(256),What,The name of the announcement.,,,,prod,,,false
announcements,createdAt,TIMESTAMP,When,The date and time when the announcement was created.,,,,prod,,,false
announcements,modifiedAt,TIMESTAMP,modifiedAt,The date and time when the announcement was last modified.,,,,prod,,,false
contentUsageHistory,id,NVARCHAR(64),Primary Id,The primary id for events in this table,,,,prod,,,false
contentUsageHistory,action,NVARCHAR(128),What,"The usage/delivery action such as Download, Livesend, Send by Email, Add to Workspace, etc.",,,,prod,,,false
contentUsageHistory,actionType,NVARCHAR(128),What,An indicator if the delivery action is 'Built-in' (standard Seismic delivery option) or is  'Custom' (custom developed delivery option).,,,,prod,,,false
contentUsageHistory,application,NVARCHAR(128),Where,"The application (Web, iOS, Android, Outlook, Gmail Salesforce, Dynamics, etc.) the content activity within Seismic took place on.",,,,prod,,,false
contentUsageHistory,contentId,NVARCHAR(64),What,The id of the content that the delivery was performed on.,contents,id,,prod,,Nto1,false
contentUsageHistory,contentVersionId,NVARCHAR(64),What,The version id of the content that the delivery was performed on.,contentVersions,id,,prod,,Nto1,false
contentUsageHistory,contentProfileId,NVARCHAR(64),Where,The id of the content profile this content was delivered from. This field is nullable when the delivered content originated from WorkSpace.,contentProfiles,id,,prod,,Nto1,false
contentUsageHistory,contentProfileName,NVARCHAR(MAX),Where,The name of the content profile this content was delivered from. This field is nullable when the delivered content originated from WorkSpace.,,,,prod,,,false
contentUsageHistory,contextId,NVARCHAR(64),Where,The unique Identifier of the external record that the delivery took place on.  Typically this is a CRM record id but can contain the unique id for any external system record depending on the integration.,,,,prod,,,false
contentUsageHistory,contextName,NVARCHAR(512),Where,"The Name of the external record that the delivery took place on. This is typically the CRM record Name of a specific Opportunity, Contact, Account, etc. but can also contain the name of a record in a custom application.",,,,prod,,,false
contentUsageHistory,contextType,NVARCHAR(256),Where,"The Type of external record that the delivery took place on. This is typically a CRM record Type such as Opportunity, Contact, Account, etc. but can also contain the record Type of a custom application.",,,,prod,,,false
contentUsageHistory,contextSystemType,NVARCHAR(256),Where,The System of the record that the delivery took place in. This typically contains the name of a CRM system but can contain the name of any external system depending on the integration.,,,,prod,,,false
contentUsageHistory,instanceName,NVARCHAR(512),What,"The name of the content as it appeared when delivered.  Typically this is the name as appears in the Library, except in cases of generated Livedocs, WorkSpace content, or Library content added to WorkSpace that has been altered.",,,,prod,,,false
contentUsageHistory,isBoundDelivery,BOOLEAN,How,Boolean indicating if the usage is the result of a bound delivery option.,,,,prod,,,false
contentUsageHistory,libraryContentId,NVARCHAR(64),What,The Library content id of the content. This id will populate when the content originated from the Seismic Library.,libraryContents,id,,prod,informational,Nto1,false
contentUsageHistory,libraryContentVersionId,NVARCHAR(64),What,The version id of the Library content that the delivery was performed on. This id will populate when the content originated from the Seismic Library.,libraryContentVersions,id,,prod,informational,Nto1,false
contentUsageHistory,livesendLinkContentId,NVARCHAR(64),What,The id assigned to the content when delivered via LiveSend. This is guaranteed unique in this table and can be treated as a primary key to join to the livesendLinkContents table.,livesendLinkContents,id,,prod,primary,Nto1,false
contentUsageHistory,livesendLinkId,NVARCHAR(64),What,The id of the livesend that the content was included in.,livesendLinks,id,,prod,informational,Nto1,false
contentUsageHistory,occurredAt,TIMESTAMP,When,The datetime when the delivery occurred.,,,,prod,,,false
contentUsageHistory,productArea,NVARCHAR(128),Where,The part of the Seismic platform the user was in when they performed the delivery.,,,,prod,,,false
contentUsageHistory,totalPages,INTEGER,What,"The number of pages of the delivered content.  Currently only provided for Livesend deliveries, but will be added for others in the future.",,,,prod,,,false
contentUsageHistory,userId,NVARCHAR(64),Who,The id of the user who performed the action.,users,id,,prod,,Nto1,false
contentUsageHistory,userUsername,NVARCHAR(256),Who,The username of the user who performed the action.,,,,prod,,,false
contentUsageHistory,workspaceContentId,NVARCHAR(64),What,The WorkSpace content id of the content. This id will populate when WorkSpace content was delivered.,workspaceContents,id,,prod,informational,Nto1,false
contentUsageHistory,workspaceContentVersionId,NVARCHAR(64),What,The version id of the workspace content that was delivered.,workspaceContentVersions,id,,prod,informational,Nto1,false
contentUsageHistory,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
contentUsageHistory,interactionId,NVARCHAR(64),How,The id of the interaction relating to this activity.,,,,prod,,,false
generatedLivedocOutputFormats,id,NVARCHAR(64),Primary Id,The primary id for items in this table.,,,,prod,,,false
generatedLivedocOutputFormats,generatedLivedocId,NVARCHAR(64),What,The id of the generated livedoc that this data belongs to.,generatedLivedocs,id,,prod,,Nto1,false
generatedLivedocOutputFormats,format,NVARCHAR(64),What,"The format of the generated livedoc output (pdf,pptx).",,,,prod,,,false
generatedLivedocOutputFormats,name,NVARCHAR(512),What,The display name for the generated livedoc (used when showing the generated livedoc in our product UI).,,,,prod,,,false
generatedLivedocOutputFormats,fileName,NVARCHAR(512),What,"The file name of the generated livedoc, this will be the name of the file as it appears when the livedoc is delivered.",,,,prod,,,false
generatedLivedocOutputFormats,imageDpi,INTEGER,What,The image DPI settings of the generated livedoc.,,,,prod,,,false
generatedLivedocOutputFormats,hasClearNotes,BOOLEAN,What,Boolean indicating if the output was generated with notes or with notes cleared.,,,,prod,,,false
generatedLivedocOutputFormats,outputLayout,NVARCHAR(64),What,The PDF output layout of Full Page Slides or Note Pages.,,,,prod,,,false
generatedLivedocOutputFormats,compatibility,NVARCHAR(256),What,The Acrobat version the PDF is designed for.,,,,prod,,,false
generatedLivedocOutputFormats,hasOwnerPassword,BOOLEAN,What,Boolean indicating if the PDF has a password to allow modifications.,,,,prod,,,false
generatedLivedocOutputFormats,hasOpenPassword,BOOLEAN,What,Boolean indicating if the PDF requires a password to open.,,,,prod,,,false
generatedLivedocOutputFormats,hasOwnerOptions,BOOLEAN,What,Boolean indicating if the PDF is set to limit the options the owner can change on the unlocked PDF.,,,,prod,,,false
generatedLivedocOutputFormats,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
generatedLivedocOutputFormats,size,INTEGER,What,"The size, in bytes, of the livedoc output.",,,,prod,,,false
emailTemplateVariableValues,id,NVARCHAR(64),Primary Id,The id for this email template variable input.,,,,prod,,,false
emailTemplateVariableValues,emailId,NVARCHAR(64),How,The id of the email that this template variable was used in.,emails,id,,prod,primary,Nto1,false
emailTemplateVariableValues,emailTemplateInstanceId,NVARCHAR(64),How,The id of the email template instance that this template variable was used in.,emailTemplateInstances,id,,prod,primary,Nto1,false
emailTemplateVariableValues,sectionName,NVARCHAR(256),What,The name of the email template section this variable value occurred in.,,,,prod,,,false
emailTemplateVariableValues,placeholderText,NVARCHAR(256),What,The placeholder text for the variable that is being replaced such as Sender.FirstName.,,,,prod,,,false
emailTemplateVariableValues,value,NVARCHAR(MAX),What,The value that was used for this instance of the email template.,,,,prod,,,false
emailTemplateVariableValues,modifiedAt,TIMESTAMP,modifiedAt,The system datetime that the email template was last updated for any reason.,,,,prod,,,false
emailTemplateVariableValues,sectionSelectionId,NVARCHAR(64),How,The id of the email template section selection that this variable was used in.,emailTemplateSectionSelections,id,,prod,primary,Nto1,false
emailTemplateVariableValues,variableType,NVARCHAR(256),What,The type of this email template variable.,,,,prod,,,false
emailTemplateVariableValues,createdAt,TIMESTAMP,What,The timestamp when the record was created.,,,,prod,,,false
distributionApprovalWorkflows,id,NVARCHAR(64),Primary Id,"The id of the approval workflow for a given engagement, primary key for table.",,,,prod,,,false
distributionApprovalWorkflows,interactionGroupId,NVARCHAR(64),What,The id of the associated engagement.,,,,prod,,,false
distributionApprovalWorkflows,engagementUrl,NVARCHAR(MAX),What,The URL link to the engagement in Seismic.,,,,prod,,,false
distributionApprovalWorkflows,startedAt,TIMESTAMP,When,Datetime this Distribution Approval Workflow started.,,,,prod,,,false
distributionApprovalWorkflows,endedAt,TIMESTAMP,When,Datetime this Distribution Approval Workflow ended.,,,,prod,,,false
distributionApprovalWorkflows,name,NVARCHAR(MAX),What,The name of this approval workflow.,,,,prod,,,false
distributionApprovalWorkflows,totalSteps,INTEGER,What,Total number of steps within this workflow.,,,,prod,,,false
distributionApprovalWorkflows,activeStepOrder,INTEGER,What,The ordinal number of the current step this workflow is on.,,,,prod,,,false
distributionApprovalWorkflows,durationSeconds,INTEGER,What,Duration of this Distribution Approval Workflow.,,,,prod,,,false
distributionApprovalWorkflows,status,NVARCHAR(256),What,The current status of this Distribution Approval Workflow.,,,,prod,,,false
distributionApprovalWorkflows,isDistributionApproved,BOOLEAN,What,Boolean indicating when all of the workflows associated with an engagement are approved.,,,,prod,,,false
distributionApprovalWorkflows,systemModifiedAt,TIMESTAMP,modifiedAt,The datetime this record was last modified by the system and is not indicative of any explicit user edit/update.,,,,prod,,,false
notificationStatus,id,NVARCHAR(64),Primary Id,The id of the notification event,,,,prod,,,false
notificationStatus,userId,NVARCHAR(64),Who,The id of the user who received the notification,users,id,,prod,,Nto1,false
notificationStatus,userFullName,NVARCHAR(128),Who,The name of the user who received the notification,,,,prod,,,false
notificationStatus,productArea,NVARCHAR(64),What,The area of the product that triggers this notification.,,,,prod,,,false
notificationStatus,activityTrigger,NVARCHAR(64),What,The activity which triggered the notification,,,,prod,,,false
notificationStatus,channel,NVARCHAR(64),What,The channel through which the notification was delivered.,,,,prod,,,false
notificationStatus,digestId,NVARCHAR(64),What,The id in the case when multiple notifications are sent in one digest,,,,prod,,,false
notificationStatus,sentTime,TIMESTAMP,When,The date and time when the notification was sent,,,,prod,,,false
notificationStatus,isRead,BOOLEAN,What,Status of whether the notification has been read.,,,,prod,,,false
notificationStatus,firstReadTime,TIMESTAMP,When,The date and time when the notification was first read.,,,,prod,,,false
notificationStatus,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
programAssociations,id,NVARCHAR(64),Primary Id,"Id of the association and primary id for this table; hashed from libraryContentId, taskId and programId.",,,,prod,,,false
programAssociations,libraryContentId,NVARCHAR(64),What,Id of the library content.,libraryContents,id,,prod,,Nto1,false
programAssociations,taskId,NVARCHAR(64),What,Id of the task.,programTasks,id,,prod,,Nto1,false
programAssociations,programId,NVARCHAR(64),What,Id of the program.,programs,id,,prod,,Nto1,false
programAssociations,taskShortId,NVARCHAR(64),What,"Unique id of the task, in its shortened form as provided by CMS.",,,,prod,,,false
microappScreens,id,NVARCHAR(64),Primary Id,Unique identifier of the microapp screen and primary id for this table.,,,,prod,,,false
microappScreens,name,NVARCHAR(64),What,"The title of the microapp screen when defined. If a title is not assigned, this field will reflect the screen’s screenIndex number.",,,,prod,,,false
microappScreens,layout,NVARCHAR(64),What,"The chosen layout of the microapp that this screen conforms to, such as Desktop, Mobile, or Tablet.",,,,prod,,,false
microappScreens,orientation,NVARCHAR(64),What,"The orientation of the microapp layout to which this screen conforms, such as Portrait or Landscape.",,,,prod,,,false
microappScreens,libraryContentId,NVARCHAR(64),What,The library content id of the microapp to which this screen belongs. This field can be utilized to group all screens that relate to a specific piece of microapp content in the library.,libraryContents,id,,prod,primary,1to1,false
microappScreens,libraryContentVersionId,NVARCHAR(64),What,The library content version id of the microapp of which this screen belongs to. This field can be utilized to group all screens that relate to a specific version of a microapp.,libraryContentVersions,id,,prod,primary,1to1,false
microappScreens,libraryContentName,NVARCHAR(64),What,The name of the Microapp content of which this screen belongs to.,,,,prod,,,false
microappScreens,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
microappScreens,screenType,NVARCHAR(64),What,"The type of screen, such as Page, Overlay, or State.",,,,prod,,,false
microappScreens,thumbnailImageUrl,NVARCHAR(64),What,An authenticated URL to the thumbnail image of the screen.,,,,prod,,,false
microappScreens,screenIndex,INTEGER,What,1-N based index of the microapp screen as it appears in the microapp.,,,,prod,,,false
microappScreens,createdAt,TIMESTAMP,When,The creation time of the microapp library content version of which this screen is a part.,,,,prod,,,false
contentReviews,id,NVARCHAR(64),Primary Id,The primary id of the review and primary id for records in this table.,,,,prod,,,false
contentReviews,userId,NVARCHAR(64),Who,The user id of the user who submitted the review.,users,id,,prod,,Nto1,false
contentReviews,libraryContentId,NVARCHAR(64),What,The library content id on which the review was submitted.,libraryContents,id,,prod,informational,Nto1,false
contentReviews,libraryContentVersionId,NVARCHAR(64),What,The library content version id on which the review was submitted.,libraryContentVersions,id,,prod,informational,Nto1,false
contentReviews,occurredAt,TIMESTAMP,When,The datetime the review was submitted.,,,,prod,,,false
contentReviews,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
contentReviews,rating,INTEGER,What,The 1-5 star INTEGER rating of the review.,,,,prod,,,false
contentReviews,starRating,NVARCHAR(5),What,The 1-5 star rating of the review as a STRING (★★★☆☆).,,,,prod,,,false
contentReviews,title,NVARCHAR(512),What,The review title entered by the user.,,,,prod,,,false
contentReviews,reviewContent,NVARCHAR(MAX),What,The review text entered by the user.,,,,prod,,,false
contentReviews,positivity,NVARCHAR(8),What,"The ""positivity"" of the review.",,,,prod,,,false
digitalSalesRoomTemplateVersions,id,NVARCHAR(64),Primary Id,The unique identifier for a given digital sales room template version in the Seismic Library (Content Manager).,,,,prod,,,false
digitalSalesRoomTemplateVersions,createdAt,TIMESTAMP,When,The datetime that this digital sales room template was created.,,,,prod,,,false
digitalSalesRoomTemplateVersions,createdBy,NVARCHAR(64),Who,The user id of the user who created this version.,users,id,,prod,,Nto1,false
digitalSalesRoomTemplateVersions,createdByUsername,NVARCHAR(256),Who,The username of the user who created this version.,,,,prod,,,false
digitalSalesRoomTemplateVersions,expiresAt,TIMESTAMP,When,The datetime that this version expires.,,,,prod,,,false
digitalSalesRoomTemplateVersions,isDeleted,BOOLEAN,What,Boolean indicating if this version of the digital sales room template is deleted.,,,,prod,,,false
digitalSalesRoomTemplateVersions,isPublished,BOOLEAN,What,A boolean indicating if this version of the digital sales room template is published.,,,,prod,,,false
digitalSalesRoomTemplateVersions,digitalSalesRoomTemplateId,NVARCHAR(64),What,The digital sales room template id of the digital sales room template version.,digitalSalesRoomTemplates,id,,prod,,Nto1,false
digitalSalesRoomTemplateVersions,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
digitalSalesRoomTemplateVersions,name,NVARCHAR(512),What,The name of the digital sales room template.,,,,prod,,,false
digitalSalesRoomTemplateVersions,version,NVARCHAR(512),What,The version number of this version such as 4.0.,,,,prod,,,false
microappScreenViews,id,NVARCHAR(64),Primary Id,Id of the screen view event and primary id for this table.,,,,prod,,,false
microappScreenViews,livesendContentViewingSessionId,NVARCHAR(64),What,Id of the livesend content viewing session where this screen view occurred.,livesendContentViewingSessions,id,,prod,informational,Nto1,false
microappScreenViews,livesendLinkContentId,NVARCHAR(64),What,Id of the livesend content of which this screen is a part.,livesendLinkContents,id,,prod,informational,Nto1,false
microappScreenViews,microappScreenId,NVARCHAR(64),What,The id of the microapp screen that was viewed when this view event occurred.,microappScreens,id,,prod,informational,Nto1,false
microappScreenViews,durationSeconds,INTEGER,What,The number of seconds spent viewing the screen.,,,,prod,,,false
microappScreenViews,occurredAt,TIMESTAMP,When,The datetime that the screen view took place.,,,,prod,,,false
microappScreenViews,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
microappScreenViews,sessionStartedAt,TIMESTAMP,When,The datetime the viewing session started.,,,,prod,,,false
microappScreenViews,sessionEndedAt,TIMESTAMP,When,The datetime the viewing session ended.,,,,prod,,,false
microappScreenViews,engagementUserEmailAddress,NVARCHAR(64),Who,The email address of the user who viewed the screen.,,,,prod,,,false
microappScreenViews,isInternalUser,BOOLEAN,Who,Boolean indicating if the user who did the screen view was internal. An internal user is defined as having an account within the Seismic platform.,,,,prod,,,false
publishingApprovalWorkflows,id,NVARCHAR(64),Primary Id,"The id of the approval workflow for a given content, primary key for table.",,,,prod,,,false
publishingApprovalWorkflows,contentId,NVARCHAR(64),What,Id of the associated library content.,libraryContents,id,,prod,,Nto1,false
publishingApprovalWorkflows,contentVersionId,NVARCHAR(64),What,Id of the associated library content version.,libraryContentVersions,id,,prod,,Nto1,false
publishingApprovalWorkflows,name,NVARCHAR(MAX),What,The name of this approval workflow.,,,,prod,,,false
publishingApprovalWorkflows,activeStepOrder,INTEGER,What,The ordinal number of the current step this workflow is on.,,,,prod,,,false
publishingApprovalWorkflows,durationSeconds,INTEGER,When,Duration of this Publishing Approval Workflow.,,,,prod,,,false
publishingApprovalWorkflows,startedAt,TIMESTAMP,When,Date and time this Publishing Approval Workflow started.,,,,prod,,,false
publishingApprovalWorkflows,endedAt,TIMESTAMP,When,Date and time this Publishing Approval Workflow ended.,,,,prod,,,false
publishingApprovalWorkflows,isVersionApproved,BOOLEAN,What,Boolean indicating when all of the workflows associated with a content version are approved.,,,,prod,,,false
publishingApprovalWorkflows,isVersionRejected,BOOLEAN,What,Boolean indicating if any of the workflows associated with a content version is rejected.,,,,prod,,,false
publishingApprovalWorkflows,status,NVARCHAR(256),What,The current status of this Publishing Approval Workflow.,,,,prod,,,false
publishingApprovalWorkflows,totalSteps,INTEGER,What,Total number of steps within this workflow.,,,,prod,,,false
publishingApprovalWorkflows,contentLibraryURL,NVARCHAR(MAX),What,The url link to the associated content in Seismic library (Content Manager).,,,,prod,,,false
publishingApprovalWorkflows,contentName,NVARCHAR(512),What,The name of the associated content in Seismic library (Content Manager).,,,,prod,,,false
publishingApprovalWorkflows,systemModifiedAt,TIMESTAMP,modifiedAt,The datetime this record was last modified by the system and is not indicative of any explicit user edit/update.,,,,prod,,,false
publishingApprovalWorkflows,submitterId,NVARCHAR(64),Who,The id of the user who submitted this workflow for approval.,users,id,,prod,,Nto1,false
publishingApprovalWorkflows,submitterUsername,NVARCHAR(MAX),Who,The username of the user who submitted this workflow for approval.,,,,prod,,,false
publishingApprovalWorkflows,submitWithAcknowledgements,BOOLEAN,What,Boolean indicating if this workflow has been submitted with agreed acknowledgements.,,,,prod,,,false
livesendCommentReactions,id,NVARCHAR(64),Primary Id,The id of the reaction,,,,prod,,,false
livesendCommentReactions,livesendCommentId,NVARCHAR(64),What,The id of the comment,livesendComments,id,,prod,primary,Nto1,false
livesendCommentReactions,reaction,NVARCHAR(64),What,"The emoji representing a reaction to a comment, such as 😀",,,,prod,,,false
livesendCommentReactions,reactionName,NVARCHAR(64),What,"Description of the reaction on a comment such as smiley face, thumbs up, question, sad face, grinning",,,,prod,,,false
livesendCommentReactions,engagementUserEmail,NVARCHAR(64),Who,Email of the user who added a reaction to the comment,,,,prod,,,false
livesendCommentReactions,createdAt,TIMESTAMP,When,The datetime that the reaction was created,,,,prod,,,false
livesendCommentReactions,isRemoved,BOOLEAN,What,A boolean indicating if the reaction has been deleted,,,,prod,,,false
livesendCommentReactions,modifiedAt,TIMESTAMP,modifiedAt,The datetime that the comment reaction was last edited,,,,prod,,,false
livesendLinks,id,NVARCHAR(64),Primary Id,The livesend link id and the primary id for items in this table.,,,,prod,,,false
livesendLinks,allowDownload,BOOLEAN,What,LiveSend Setting - is content downloadable.,,,,prod,,,false
livesendLinks,createdAt,TIMESTAMP,When,The datetime that the livesend link was created.,,,,prod,,,false
livesendLinks,createdBy,NVARCHAR(64),When,The user id of the user who created the livesend link. Note - For LiveSends created with 'Generate Livesend Link' there will be no associated livesendlinkmembers.,users,id,,prod,,Nto1,false
livesendLinks,expireAfterView,BOOLEAN,What,LiveSend Setting - allow single view of livesend.,,,,prod,,,false
livesendLinks,expiresAt,TIMESTAMP,When,LiveSend Setting - when the LiveSend link expires.,,,,prod,,,false
livesendLinks,isSeparateSend,BOOLEAN,How,"A boolean indicating if the link was generated as the result of a ""blast email"" which creates many links or if the link is a shared link across many recipients.",,,,prod,,,false
livesendLinks,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
livesendLinks,notificationMode,NVARCHAR(32),What,LiveSend Setting - notification setting for link.,,,,prod,,,false
livesendLinks,hasPassword,BOOLEAN,What,LiveSend Setting - is a password set for link.,,,,prod,,,false
livesendLinks,urlPath,NVARCHAR(512),What,"The url path of the livesend link, not including the base domain.",,,,prod,,,false
livesendLinks,isRoomCustomized,BOOLEAN,What,Whether or not the landing page is customized.,,,,prod,,,false
livesendLinks,isDigitalRoom,BOOLEAN,What,Whether or not this livesend link is for a digital sales room.,,,,prod,,,false
livesendLinks,loginEnabled,BOOLEAN,What,Whether or not logging in is enabled.,,,,prod,,,false
livesendLinks,interactionGroupName,NVARCHAR(MAX),What,"The name of the interactionGroup this link belongs to. An interactionGroup represents the ""container"" around a group livesends. Such containers can be email blasts, digital sales rooms, etc.",,,,prod,,,false
livesendLinks,interactionGroupId,NVARCHAR(64),What,"interactionGroupId represents the ""container"" around a group livesends. Such containers can be email blasts, digital sales rooms, etc.",,,,prod,,,false
userPropertyAssignments,userId,NVARCHAR(64),Primary Id,The id of the user that the user property value is assigned to.,users,id,,prod,primary,Nto1,false
userPropertyAssignments,userPropertyId,NVARCHAR(64),Primary Id,The id of the user property.,userProperties,id,,prod,primary,Nto1,false
userPropertyAssignments,userPropertyName,NVARCHAR(64),What (Details),The name of the user property.,,,,prod,,,false
userPropertyAssignments,userPropertyType,NVARCHAR(16),What (Details),"The type of the user property (string, integer, date, boolean, float).",,,,prod,,,false
userPropertyAssignments,userPropertyValue,NVARCHAR(MAX),What (Details),The user property value assigned to the listed user.,,,,prod,,,false
userPropertyAssignments,userPropertyValueBoolean,BOOLEAN,What (Details),The user property value casted to an explicit boolean field if the type is set to boolean.,,,,prod,,,false
userPropertyAssignments,userPropertyValueDatetime,TIMESTAMP,What (Details),The user property value casted to an explicit datetime field if the type is set to date.,,,,prod,,,false
userPropertyAssignments,userPropertyValueInteger,INTEGER,What (Details),The user property value casted to an explicit integer field if the type is set to integer.,,,,prod,,,false
userPropertyAssignments,userPropertyValueFloat,FLOAT,What (Details),The user property value casted to an explicit float field if the type is set to float.,,,,prod,,,false
userPropertyAssignments,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
emailTemplateSectionSelections,id,NVARCHAR(64),Primary Id,The id for this section selection.,,,,prod,,,false
emailTemplateSectionSelections,emailId,NVARCHAR(64),What,The id of the email that this section selection was used in.,emails,id,,prod,primary,Nto1,false
emailTemplateSectionSelections,emailTemplateInstanceId,NVARCHAR(64),What,The id of the email template instance that this section selection was used in.,emailTemplateInstances,id,,prod,primary,Nto1,false
emailTemplateSectionSelections,sectionName,NVARCHAR(256),What,The name of this email template section.,,,,prod,,,false
emailTemplateSectionSelections,sectionType,NVARCHAR(256),What,The type of this email template section.,,,,prod,,,false
emailTemplateSectionSelections,optionName,NVARCHAR(256),What,The name of the option the selection is being made for.,,,,prod,,,false
emailTemplateSectionSelections,modifiedAt,TIMESTAMP,modifiedAt,The system datetime that the section selection was last updated for any reason.,,,,prod,,,false
emailTemplateSectionSelections,isReadOnly,BOOLEAN,What,Boolean indicating if the section selection could be modified or if it was read only.,,,,prod,,,false
emailTemplateSectionSelections,isChangedFromDefault,BOOLEAN,What,Boolean indicating if the section selection was changed from the default state.,,,,prod,,,false
emailTemplateSectionSelections,isSharedTemplateComponentReadOnly,BOOLEAN,What,Boolean indicating if the shared template component that included the section selection could be modified or if it was read only.,,,,prod,,,false
emailTemplateSectionSelections,sharedTemplateComponentLibraryContentId,NVARCHAR(64),What,The library content id of the shared template component if this section selection relates to a shared template component.,libraryContents,id,,prod,,Nto1,false
emailTemplateSectionSelections,sharedTemplateComponentLibraryContentVersionId,NVARCHAR(64),What,The library content version id of the shared template component if this section selection relates to a shared template component.,libraryContentVersions,id,,prod,,Nto1,false
emailTemplateSectionSelections,sharedTemplateComponentTeamsiteId,NVARCHAR(64),Where,The teamsite id of the shared template component if this section selection relates to a shared template component.,teamsites,id,,prod,,Nto1,false
emailTemplateSectionSelections,createdAt,TIMESTAMP,When,The timestamp when the record was created.,,,,prod,,,false
searchClicks,id,NVARCHAR(64),Primary Id,The primary id for events in this table.,,,,prod,,,false
searchClicks,occurredAt,TIMESTAMP,When,The timestamp that the click occurred.,,,,prod,,,false
searchClicks,searchCycleId,NVARCHAR(64),What,An id for the combined cycle of steps for search and filter.,searchHistory,searchCycleId,,prod,informational,NtoN,false
searchClicks,searchHistoryId,NVARCHAR(64),What,The id of the search history resulting in this click.,searchHistory,id,,prod,informational,Nto1,false
searchClicks,userId,NVARCHAR(64),Who,The id of the user who performed the click.,users,id,,prod,,Nto1,false
searchClicks,clickedUserId,NVARCHAR(64),Who,The id of the user who was clicked (if clickType = person).,users,id,,prod,,Nto1,false
searchClicks,resultIndex,INTEGER,What,"The 1-indexed position of the item clicked, across all pages.",,,,prod,,,false
searchClicks,pageIndex,INTEGER,What,The 1-indexed page number for the item clicked.,,,,prod,,,false
searchClicks,viewMode,NVARCHAR(256),What,This is the view mode selected when the user clicks on the search result.,,,,prod,,,false
searchClicks,clickType,NVARCHAR(256),What,The type of click.,,,,prod,,,false
searchClicks,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
searchClicks,application,NVARCHAR(128),Where,The application that the user was in when they performed the search.,,,,prod,,,false
searchClicks,contentId,NVARCHAR(64),What,"The id of the content the user clicked, if they clicked content.",contents,id,,prod,,Nto1,false
searchClicks,contentVersionId,NVARCHAR(64),What,"The version id of the content the user clicked, if they clicked content.",contentVersions,id,,prod,,Nto1,false
searchClicks,instanceName,NVARCHAR(512),What,The name given to the content when the click was made.,,,,prod,,,false
searchClicks,normalizedName,NVARCHAR(512),What,The name currently given to the content. This will be the Library content name for all content that comes from the Library and the WorkSpace name for content directly uploaded to WorkSpace.,,,,prod,,,false
searchClicks,libraryContentId,NVARCHAR(64),What,The Library content id of the content. This id will populate when the content originated from the Seismic Library.,libraryContents,id,,prod,informational,Nto1,false
searchClicks,libraryContentVersionId,NVARCHAR(64),What,The Library content version id of the content. This id will populate when the content originated from the Seismic Library.,libraryContentVersions,id,,prod,informational,Nto1,false
searchClicks,workspaceContentId,NVARCHAR(64),What,The WorkSpace content id of the clicked content.,workspaceContents,id,,prod,informational,Nto1,false
searchClicks,workspaceContentVersionId,NVARCHAR(64),What,The workspace content version id of the content that was clicked.,workspaceContentVersions,id,,prod,informational,Nto1,false
searchClicks,contentProfileId,NVARCHAR(64),Where,The id of the content profile to which this content belongs. This field is nullable when the clicked content originated from WorkSpace.,contentProfiles,id,,prod,,Nto1,false
searchClicks,contentProfileName,NVARCHAR(MAX),Where,The name of the content profile to which this content belongs. This field is nullable when the clicked content originated from WorkSpace.,,,,prod,,,false
searchClicks,externalContentId,NVARCHAR(64),What,"The id of the external content the user clicked, if they clicked content.",,,,prod,,,false
searchClicks,externalSystemType,NVARCHAR(64),What,The type of external system related to this activity.,,,,prod,,,false
searchClicks,externalEntityType,NVARCHAR(64),What,The type of external content related to this activity.,,,,prod,,,false
searchClicks,externalContentUrl,NVARCHAR(64),Where,The URL of the external content related to this activity.,,,,prod,,,false
publishingApprovalWorkflowStepsHistory,id,NVARCHAR(64),Primary Id,"The id representing the recorded instance of the workflow step as it goes through the workflow approval process, and primary id for this table.",,,,prod,,,false
publishingApprovalWorkflowStepsHistory,durationSeconds,INTEGER,When,Duration in seconds of the step.,,,,prod,,,false
publishingApprovalWorkflowStepsHistory,comment,NVARCHAR(MAX),What,Comment sent when step was reviewed by reviewer.,,,,prod,,,false
publishingApprovalWorkflowStepsHistory,startedAt,TIMESTAMP,When,Datetime of the start of the step.,,,,prod,,,false
publishingApprovalWorkflowStepsHistory,endedAt,TIMESTAMP,When,Datetime of the end of the step.,,,,prod,,,false
publishingApprovalWorkflowStepsHistory,isLatest,BOOLEAN,What,Whether this step is the current step in the workflow lifecycle.,,,,prod,,,false
publishingApprovalWorkflowStepsHistory,isRevoked,BOOLEAN,What,"Whether this step has been revoked. By default it is false. Once a workflow step is approved or rejected by a user, the step became Approved or Rejected status. The user can revoke the approval or the rejection, so the step will be reverted to InReview, and isReovked will be set as true.",,,,prod,,,false
publishingApprovalWorkflowStepsHistory,name,NVARCHAR(MAX),What,Name of the workflow step.,,,,prod,,,false
publishingApprovalWorkflowStepsHistory,approverUserId,NVARCHAR(64),Who,The id of the user who reviewed and ultimately approved/rejected/revoked this step.,users,id,,prod,,Nto1,false
publishingApprovalWorkflowStepsHistory,approverUsername,NVARCHAR(MAX),Who,The username of the user who reviewed and ultimately approved/rejected/revoked this step.,,,,prod,,,false
publishingApprovalWorkflowStepsHistory,status,NVARCHAR(256),What,The status of the step at this point in history.,,,,prod,,,false
publishingApprovalWorkflowStepsHistory,stepOrder,INTEGER,What,The ordinal number of the step within the series of workflow steps.,,,,prod,,,false
publishingApprovalWorkflowStepsHistory,systemModifiedAt,TIMESTAMP,modifiedAt,The datetime this record was last modified by the system and is not indicative of any explicit user edit/update.,,,,prod,,,false
publishingApprovalWorkflowStepsHistory,contentVersionId,NVARCHAR(64),What,Id of the associated library content version.,libraryContentVersions,id,,prod,,Nto1,false
publishingApprovalWorkflowStepsHistory,workflowid,NVARCHAR(64),What,The id of the associated workflow.,publishingApprovalWorkflows,id,,prod,,Nto1,false
publishingApprovalWorkflowStepsHistory,workflowName,NVARCHAR(MAX),What,The name of the workflow associated with this step.,,,,prod,,,false
meetingParticipants,id,NVARCHAR(64),Primary Id,The id of the unique instance of participant and meeting.,,,,prod,,,false
meetingParticipants,meetingId,NVARCHAR(64),Who,The associated meeting Id of the joined participant.,meetings,id,,prod,,Nto1,false
meetingParticipants,userId,NVARCHAR(64),Who,The Seismic user id of the Seismic user who participated in the meeting.,users,id,,prod,,Nto1,false
meetingParticipants,userName,NVARCHAR(64),Who,The Seismic username of the Seismic user who participated the meeting.,,,,prod,,,false
meetingParticipants,engagementUserEmailAddress,NVARCHAR(64),Who,The email address of the user who participated in the meeting.,,,,prod,,,false
meetingParticipants,engagementUserEmailDomain,NVARCHAR(64),Who,The email address domain of the user who participated in the meeting.,,,,prod,,,false
meetingParticipants,engagementUserPhoneNumber,NVARCHAR(64),Who,The phone number of the user who participated in the meeting.,,,,prod,,,false
meetingParticipants,displayName,NVARCHAR(64),Who,Display name of the speaker in the video conferencing platform who spoke the keywords tracked in recorded meetings. This field needs to be filled as long as users participated in recorded meetings even if they didn't speak during the meetings.,,,,prod,,,false
meetingParticipants,externalMeetingUserIdentification,NVARCHAR(64),Who,"The external userId of meeting member, which is assign by meeting app.",,,,prod,,,false
meetingParticipants,isInternalUser,BOOLEAN,Who,True/False indicating if the user participated in the meeting was internal. An internal user is defined as having an account within the Seismic platform.,,,,prod,,,false
meetingParticipants,memberType,NVARCHAR(64),Who,The role of the meeting participant.,,,,prod,,,false
meetingParticipants,talkTimeSeconds,INTEGER,What,"The duration of time, in seconds, spent talking for an Ingested meeting.",,,,prod,,,false
meetingParticipants,listenTimeSeconds,INTEGER,What,"The duration of time, in seconds, spent listening for an Ingested meeting.",,,,prod,,,false
meetingParticipants,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
searchFacets,id,NVARCHAR(64),Primary Id,The id of the facet in this search.,,,,prod,,,false
searchFacets,searchHistoryId,NVARCHAR(64),What,The id of the search history that searched with this facet.,,,,prod,,,false
searchFacets,searchCycleId,NVARCHAR(64),What,An id for the combined cycle of steps for search and filter.,,,,prod,,,false
searchFacets,facetType,NVARCHAR(256),What,The type of facet.,,,,prod,,,false
searchFacets,contentPropertyId,NVARCHAR(64),What,"If searching by content property, this will be the id of the property.",contentProperties,id,,prod,,Nto1,false
searchFacets,facetName,NVARCHAR(256),What,The name of the built-in facet or content property.,,,,prod,,,false
searchFacets,facetValue,NVARCHAR(256),What,The value of the facet for which the search is made.,,,,prod,,,false
searchFacets,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
programDates,programId,NVARCHAR(64),Primary Id,The id of the program that this date is associated with.,programs,id,,prod,primary,Nto1,false
programDates,dateType,NVARCHAR(64),Primary Id,"The descriptive name representing a given program date field for this program date record, such as actualEndDate or plannedStartDate.",,,,prod,,,false
programDates,programDate,DATE,Primary Id,The calendar date for this program date and type.,,,,prod,,,false
programDates,programShortId,NVARCHAR(64),What,"unique id of the program, in its shortened form as provided by CMS.",,,,prod,,,false
aiActivity,id,NVARCHAR(64),Primary Id,The unique identifier of this table.,,,,prod,,,false
aiActivity,userId,NVARCHAR(64),Who,The Seismic user id of the user who interacted with the AI feature.,users,id,,prod,,Nto1,false
aiActivity,userName,NVARCHAR(256),Who,The username of the user who interacted with the AI feature.,,,,prod,,,false
aiActivity,aiGeneratedTextId,NVARCHAR(64),What,Reference to a AI Generative Request details (if applicable).,aiGeneratedText,id,,prod,,Nto1,false
aiActivity,useCase,NVARCHAR(256),What,The name of the feature or user workflow that made the call to the LLM Gateway. It’s purpose is to track usage and costing associated with a particular generative use case. Can be used to understand how users are adopting AI.,,,,prod,,,false
aiActivity,occurredAt,TIMESTAMP,When,Date and time the generative request was received by the model.,,,,prod,,,false
aiActivity,creditType,NVARCHAR(256),What,The type of credit consumed by the generative AI request.,,,,prod,,,false
aiActivity,creditsUsed,DECIMAL,What,The number of credits consumed by this request.,,,,prod,,,false
searchClickMatchDetails,id,NVARCHAR(64),Primary Id,The primary id for events in this table.,,,,prod,,,false
searchClickMatchDetails,searchClickId,NVARCHAR(64),What,The id of the search click.,searchClicks,id,,prod,informational,1to1,false
searchClickMatchDetails,field,NVARCHAR(64),What,The field's name.,,,,prod,,,false
searchClickMatchDetails,fieldType,NVARCHAR(64),What,Tells the user if the matched field is built-in (standard) or custom.,,,,prod,,,false
searchClickMatchDetails,matchedValue,NVARCHAR(MAX),What,The value in the field that was matched from the search click.,,,,prod,,,false
searchClickMatchDetails,matchType,NVARCHAR(256),What,This value describes how there is a match between the search click and the match details.,,,,prod,,,false
searchClickMatchDetails,modifiedAt,TIMESTAMP,modifiedAt,"The timestamp that the record was most recently changed, whether it be user- or system-driven.",,,,prod,,,false
contentSlideInsertInstances,id,NVARCHAR(64),Primary Id,The id of a content slide insert instance.,,,,prod,,,false
contentSlideInsertInstances,contentInsertInstanceId,NVARCHAR(64),What,The id of the content insert instance.,contentInsertInstances,id,,prod,,Nto1,false
contentSlideInsertInstances,slideId,NVARCHAR(64),What,The id of the slide inserted in this content slide insert instance.,,,,prod,,,false
contentSlideInsertInstances,slidePosition,INTEGER,What,1-N position (or location) of the slide within the Seismic content being inserted.,,,,prod,,,false
contentSlideInsertInstances,occurredAt,TIMESTAMP,When,The datetime when the content slide insert activity occurred.,,,,prod,,,false
contentSlideInsertInstances,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
contentSlideInsertInstances,thumbnailImageUrl,NVARCHAR(64),What,An authenticated URL to the thumbnail image of the slide.,,,,prod,,,false
virusScanAuditLog,id,NVARCHAR(64),Primary Id,The id of the virus scan log.,,,,prod,,,false
virusScanAuditLog,userId,NVARCHAR(64),Who,Seismic user id of the uploader,users,id,,prod,primary,Nto1,false
virusScanAuditLog,fileExtension,NVARCHAR(64),What,file type of scanned content,,,,prod,,,false
virusScanAuditLog,fileName,NVARCHAR(64),What,name of the scanned content as it appears on Seismic platform,,,,prod,,,false
virusScanAuditLog,hasVirus,BOOLEAN,What,True when the virus scanning service determined the file was infected. Null if file was not scanned. Otherwise False.,,,,prod,,,false
virusScanAuditLog,wasNotScanned,BOOLEAN,What,True if scanning service could not scan the file.,,,,prod,,,false
virusScanAuditLog,occurredAt,TIMESTAMP,When,The time at which the file was scanned (or skipped),,,,prod,,,false
virusScanAuditLog,productArea,NVARCHAR(128),Where,"The area of the product (ContentManager, WorkSpace, etc.) where the activity occurred.",,,,prod,,,false
virusScanAuditLog,email,NVARCHAR(256),Who,email address of the uploader,,,,prod,,,false
virusScanAuditLog,userName,NVARCHAR(256),Who,The uploader's username.,,,,prod,,,false
livesendLinkContents,id,NVARCHAR(64),Primary Id,The primary id for items in this table and is the id of the livesendlinkContent.,,,,prod,,,false
livesendLinkContents,createdAt,TIMESTAMP,When,The datetime that the content was added to the livesend link.,,,,prod,,,false
livesendLinkContents,createdBy,NVARCHAR(64),What,The user id of the user who created the livesend link.,users,id,,prod,informational,Nto1,false
livesendLinkContents,livesendLinkId,NVARCHAR(64),What,The id of the livesend link that this content is included in.,livesendLinks,id,,prod,primary,Nto1,false
livesendLinkContents,name,NVARCHAR(256),What,The name of the content in the livesend link.,,,,prod,,,false
livesendLinkContents,totalPages,INTEGER,What,The total number of pages of this content.,,,,prod,,,false
livesendLinkContents,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
livesendLinkContents,deletedAt,TIMESTAMP,When,The datetime this record was deleted.,,,,prod,,,false
livesendLinkContents,isDeleted,BOOLEAN,What,Boolean indicating if this link content record was deleted.,,,,prod,,,false
livesendLinkContents,libraryContentId,NVARCHAR(64),What,The Library content id of the content. This id will populate when the content originated from the Seismic Library.,libraryContents,id,,prod,informational,Nto1,true
livesendLinkContents,interactionGroupId,NVARCHAR(64),Where,"Represents the ""container"" around a group livesends. Such containers can be email blasts, digital sales rooms, etc.",,,,prod,,,false
livesendLinkContents,wasViewed,BOOLEAN,What,Boolean indicating if this link content record was viewed.,,,,prod,,,false
livesendLinkContents,numberOfSessions,INTEGER,What,The total number of viewing sessions over this content.,,,,prod,,,false
livesendLinkContents,livesendLinkMeetingContentId,NVARCHAR(64),What,The id of the livesend link meeting content of the content. This id will populate if the content was a meeting content such as meeting clip or meeting recording.,livesendLinkMeetingContents,id,,prod,informational,Nto1,false
customPropertyAssignments,customPropertyId,NVARCHAR(64),Primary Id,The id of the custom property associated with this assignment.,customProperties,id,,prod,primary,Nto1,false
customPropertyAssignments,customPropertyName,NVARCHAR(64),What (Details),The name of the custom property associated with this assignment.,,,,prod,,,false
customPropertyAssignments,objectId,NVARCHAR(64),Primary Id,The id of the specific object that this custom property Value is assigned to.,,,,prod,,,false
customPropertyAssignments,objectType,NVARCHAR(32),What (Details),"The type of object this custom property value is assigned to, such as project, task, or content.",,,,prod,,,false
customPropertyAssignments,customPropertyValue,NVARCHAR(MAX),What (Details),The custom property Value assigned to the listed object.,,,,prod,,,false
customPropertyAssignments,isRequired,BOOLEAN,What (Details),A Boolean indicating if this property is required to be assigned to a given object. Properties can be required on all or some object types.,,,,prod,,,false
customPropertyAssignments,isRequiredForPublish,BOOLEAN,What (Details),A Boolean indicating that this custom property must be assigned before a piece of content can be published.,,,,prod,,,false
customPropertyAssignments,teamsiteId,NVARCHAR(64),Where (Details),The id of the TeamSite associated with the content object this property value is assigned to.,teamsites,id,,prod,,Nto1,false
customPropertyAssignments,teamsiteName,NVARCHAR(128),Where (Details),The name of the TeamSite associated with the content object this property value is assigned to.,,,,prod,,,false
programItems,id,NVARCHAR(64),Primary Id,The id of the item and primary id for this table.,,,,prod,,,false
programItems,title,NVARCHAR(MAX),What,The name given to the item.,,,,prod,,,false
programItems,status,NVARCHAR(MAX),What,The descriptive name of the item's current status.,,,,prod,,,false
programItems,priority,NVARCHAR(MAX),What,Level of importance for a given item within a project.,,,,prod,,,false
programItems,rank,NVARCHAR(MAX),What,Rank defines the ordinal numbered order in which the item falls within the project's item series.,,,,prod,,,false
programItems,type,NVARCHAR(MAX),What,Denotes whether the program item type is a request or a task.,,,,prod,,,false
programItems,createdAt,TIMESTAMP,When,The datetime that the item was created.,,,,prod,,,false
programItems,systemModifiedAt,TIMESTAMP,modifiedAt,The datetime this record was last modified by the system and is not indicative of an explicit user edit/update to the item.,,,,prod,,,false
programItems,userModifiedAt,TIMESTAMP,modifiedAt,The datetime that the item was last updated/modified by a user.,,,,prod,,,false
programItems,plannedStartDate,TIMESTAMP,When,The datetime that the item was scheduled to start.,,,,prod,,,false
programItems,plannedDueDate,TIMESTAMP,When,The datetime that the item was scheduled to be completed.,,,,prod,,,false
programItems,plannedDurationDays,INTEGER,What,"The system-calculated length of time the item is scheduled to take. Duration is based on days between, and including, the planned start date and planned due date.",,,,prod,,,false
programItems,actualStartDate,TIMESTAMP,When,The system-set datetime when work on the item started. This date is triggered by the item moving into an appropriate status.,,,,prod,,,false
programItems,actualCompletedDate,TIMESTAMP,When,The system-set datetime when work on the item ended. This date is triggered by the item moving into the appropriate status of completed.,,,,prod,,,false
programItems,actualDurationDays,INTEGER,What,"The system-calculated length of time the item actually took to complete. Duration is based on days between, and including, the actual start date and actual completed date.",,,,prod,,,false
programItems,isOverdue,BOOLEAN,What,Boolean indicating if item is passed the planned due date.,,,,prod,,,false
programItems,isDeleted,BOOLEAN,What,A boolean indicating if the item is currently considered deleted.,,,,prod,,,false
programItems,deletedAt,TIMESTAMP,When,The datetime on which the item was deleted.,,,,prod,,,false
programItems,shortId,NVARCHAR(64),What,"unique id of the task/request, in its shortened form as provided by CMS.",,,,prod,,,false
dailyActiveUsers,userId,NVARCHAR(64),Primary Id,The id of the user who was or was not active on that date.,users,id,,prod,primary,NtoN,false
dailyActiveUsers,username,NVARCHAR(256),Who,The user's username.,,,,prod,,,false
dailyActiveUsers,date,DATE,When,The date on which a user may have been active.,,,,prod,,,false
dailyActiveUsers,includesLessonlyActivity,BOOLEAN,What,"Boolean indicating if the user was active in Lessonly on that date. Any trackable action on the Lessonly platform (such as progress on a lesson, creation of a path, etc.) will show TRUE for including Lessonly activity on this date for this user.",,,,prod,,,false
groups,id,NVARCHAR(64),Primary Id,The primary id for items in this table and is the id of the Group.,,,,prod,,,false
groups,name,NVARCHAR(MAX),Who,The name of the Group.,,,,prod,,,false
groups,type,NVARCHAR(64),What,The type of group.,,,,prod,,,false
groups,parentGroupId,NVARCHAR(64),What,The id of the parent group.,,,,prod,,,false
groups,isDeactivated,BOOLEAN,What,Indicates if the group is deactivated.,,,,prod,,,false
groups,isDeleted,BOOLEAN,What,Indicates if the group is deleted.,,,,prod,,,false
tables,name,NVARCHAR(256),What,The name of the model.,,,,prod,,,false
tables,description,NVARCHAR(MAX),What,A brief explanation of the model's purpose.,,,,prod,,,false
tables,releaseDate,DATE,When,The date when the model was made available.,,,,prod,,,false
tables,systems,NVARCHAR(MAX),What,"The tenant system this table is available in such as Unified, Content only, or Learning only.",,,,prod,,,false
tables,availability,BOOLEAN,What,"Comma separated list of where this table is available for use such as API, LiveInsights, or Reports & Data.",,,,prod,,,false
livesendContentViewingSessions,id,NVARCHAR(64),Primary Id,Id of the livesend content viewing session.,,,,prod,,,false
livesendContentViewingSessions,livesendLinkContentId,NVARCHAR(64),What (Engagement),Id of the content within the livesend link.,livesendLinkContents,id,,prod,informational,Nto1,false
livesendContentViewingSessions,livesendLinkId,NVARCHAR(64),Where (Engagement),Id of the livesend link.,livesendLinks,id,,prod,informational,Nto1,false
livesendContentViewingSessions,livesendViewingSessionId,NVARCHAR(64),Where (Engagement),Id of the viewing session for the livesend where user accessed the content.,livesendViewingSessions,id,,prod,informational,Nto1,false
livesendContentViewingSessions,interactionId,NVARCHAR(64),Where (Engagement),The id of the interaction relating to this viewing session.,,,,prod,,,false
livesendContentViewingSessions,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
livesendContentViewingSessions,engagementUserEmailAddress,NVARCHAR(64),Who (Engagement),The email address of the user email viewing content specific content on a digital room.,,,,prod,,,false
livesendContentViewingSessions,isInternalUser,BOOLEAN,Who (Engagement),Marks whether or not the user is a Seismic user.,,,,prod,,,false
livesendContentViewingSessions,sessionStartedAt,TIMESTAMP,When (Engagement),The datetime this content view session started.,,,,prod,,,false
livesendContentViewingSessions,sessionEndedAt,TIMESTAMP,When (Engagement),The datetime this content view session ended.,,,,prod,,,false
livesendContentViewingSessions,durationSeconds,INTEGER,What (Engagement),The total duration of this content session.,,,,prod,,,false
digitalSalesRoomTemplates,id,NVARCHAR(64),Primary Id,The unique identifier for a given digital sales room template in the Seismic Library (Content Manager).,contents,id,,prod,,1to1,false
digitalSalesRoomTemplates,name,NVARCHAR(512),What,The name of the digital sales room template.,,,,prod,,,false
digitalSalesRoomTemplates,version,NVARCHAR(32),What,The number of the current version of the dsr template such as 5.3.,,,,prod,,,false
digitalSalesRoomTemplates,createdAt,TIMESTAMP,When,The datetime that this digital sales room template was created.,,,,prod,,,false
digitalSalesRoomTemplates,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
digitalSalesRoomTemplates,isDeleted,BOOLEAN,What,Boolean indicating if this digital sales room template is deleted.,,,,prod,,,false
digitalSalesRoomTemplates,isPublished,BOOLEAN,What,Boolean indicating if any version of this digital sales room template is published.,,,,prod,,,false
digitalSalesRoomTemplates,publishedVersionExpiresAt,TIMESTAMP,When,The expiration date of the latest published version.,,,,prod,,,false
digitalSalesRoomTemplates,latestVersionCreatedAt,TIMESTAMP,When,The creation date for the latest version of this digital sales room template. This is what most people think of when they ask 'when was this last updated'.,,,,prod,,,false
digitalSalesRoomTemplates,latestVersionCreatedBy,NVARCHAR(64),Who,The id of the user who created the latest version of this digital sales room template.,users,id,,prod,,Nto1,false
digitalSalesRoomTemplates,latestVersionCreatedByUserName,NVARCHAR(256),Who,The username of the user who created the latest version of this digital sales room template.. This is what most people think of when they ask 'who was this last updated by'.,,,,prod,,,false
digitalSalesRoomTemplates,latestVersionId,NVARCHAR(64),What,The digitalSalesRoomTemplateVersionId for the latest version of this content.,digitalSalesRoomTemplateVersions,id,,prod,informational,1to1,false
digitalSalesRoomTemplates,libraryUrl,NVARCHAR(MAX),What,The URL/link to this digital sales room template in the Seismic Library (Content Manager).,,,,prod,,,false
digitalSalesRoomTemplates,userModifiedAt,TIMESTAMP,What,The datetime the digital sales room template was last modified by a user in Seismic Library (Content Manager).,,,,prod,,,false
workspaceContentVersions,id,NVARCHAR(64),Primary Id,The id of the version and the primary id for items in this table.,,,,prod,,,false
workspaceContentVersions,createdAt,TIMESTAMP,When,The datetime that this version was created.,,,,prod,,,false
workspaceContentVersions,createdBy,NVARCHAR(64),Who,"The user id of the user who created this version.  In the case of auto-update, this is the owner of the library content.",users,id,,prod,primary,Nto1,false
workspaceContentVersions,format,NVARCHAR(64),What,The format of this version of the workspace content.,,,,prod,,,false
workspaceContentVersions,libraryContentVersionId,NVARCHAR(64),What,"When the WorkSpace content associated with this version originated from the Library, this is the library content version id that this particular version is derived from.  If this version is the result of an upload, the library version id is retained from the last version created directly from the library. This field is nullable when the associated WorkSpace content did not originate from the Library.",libraryContentVersions,id,,prod,informational,Nto1,false
workspaceContentVersions,name,NVARCHAR(512),What,The name of the WorkSpace content the version is associated with.,,,,prod,,,false
workspaceContentVersions,previewImageId,NVARCHAR(64),What,An id to the higher resolution preview image for this workspace content version.,,,,prod,,,false
workspaceContentVersions,previewImageUrl,NVARCHAR(MAX),What,A URL to the higher resolution preview image for this workspace content version.,,,,prod,,,false
workspaceContentVersions,thumbnailImageId,NVARCHAR(64),What,An id to the lower resolution thumbnail image for this workspace content version.,,,,prod,,,false
workspaceContentVersions,thumbnailImageUrl,NVARCHAR(MAX),What,A URL to the lower resolution thumbnail image for this workspace content version.,,,,prod,,,false
workspaceContentVersions,size,INTEGER,What,The size in bytes of this version of the workspace content.,,,,prod,,,false
workspaceContentVersions,version,INTEGER,What,The version number of this version of the workspace content.,,,,prod,,,false
workspaceContentVersions,versionCreationMethod,NVARCHAR(32),What,"The approach used to create this version of the workspace content (Upload, Add to Cart, Save to Workspace, Automatic Update, Livedoc Iteration, etc.).",,,,prod,,,false
workspaceContentVersions,workspaceContentId,NVARCHAR(64),What,The id of the workspace content that this is a version of.,workspaceContents,id,,prod,primary,Nto1,false
workspaceContentVersions,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
workspaceContentVersions,generatedLivedocId,NVARCHAR(64),What,The id of the livedoc generation which was customized then added to WorkSpace.,generatedLivedocs,id,,prod,,Nto1,false
generatedLivedocs,id,NVARCHAR(64),Primary Id,The unique identifier for a given generated livedoc.,,,,prod,,,false
generatedLivedocs,userId,NVARCHAR(64),Who,The id of the user who generated the livedoc.,users,id,,prod,,Nto1,false
generatedLivedocs,contentId,NVARCHAR(64),What,The id of the content on which this generated livedoc is based.,contents,id,,prod,,Nto1,false
generatedLivedocs,contentVersionId,NVARCHAR(64),What,The version id of the content on which this generated livedoc is based.,contentVersions,id,,prod,,Nto1,false
generatedLivedocs,libraryContentId,NVARCHAR(64),What,The library content id on which this generated livedoc is based.,libraryContents,id,,prod,informational,Nto1,false
generatedLivedocs,libraryContentVersionId,NVARCHAR(64),What,The version id of the library content on which this generated livedoc is based.,libraryContentVersions,id,,prod,informational,Nto1,false
generatedLivedocs,workspaceContentId,NVARCHAR(64),What,The workspace content id on which this generated livedoc is based.,workspaceContents,id,,prod,informational,Nto1,false
generatedLivedocs,workspaceContentVersionId,NVARCHAR(64),What,The version id of the workspace content on which this generated livedoc is based.,workspaceContentVersions,id,,prod,informational,Nto1,false
generatedLivedocs,contentProfileId,NVARCHAR(64),Where,"The id of the content profile of the content on which this generated livedoc is based, if the content is in DocCenter.",contentProfiles,id,,prod,primary,Nto1,false
generatedLivedocs,contentProfileName,NVARCHAR(MAX),Where,"The name of the content profile of the content on which this generated livedoc is based, if the content is in DocCenter.",,,,prod,,,false
generatedLivedocs,libraryContentName,NVARCHAR(512),What,"The current name of the content on which this generated livedoc is based, if it is a library content.",,,,prod,,,false
generatedLivedocs,instanceName,NVARCHAR(512),What,The name of the content on which this generated livedoc was based at the time the livedoc was generated.,,,,prod,,,false
generatedLivedocs,normalizedName,NVARCHAR(512),What,The current name of the content on which this generated livedoc is based.,,,,prod,,,false
generatedLivedocs,processingTimeSecs,DECIMAL,What,"The time, in seconds, for the engine to construct the pptx or xlsx instance. This does not account for processing time to create the PDF rendition.",,,,prod,,,false
generatedLivedocs,previewImageId,NVARCHAR(64),What,An id to the higher resolution preview image representing the generated livedoc.,,,,prod,,,false
generatedLivedocs,previewImageUrl,NVARCHAR(MAX),What,The URL to the higher resolution preview image representing the generated livedoc.,,,,prod,,,false
generatedLivedocs,thumbnailImageId,NVARCHAR(64),What,An id to the lower resolution thumbnail image representing the generated livedoc.,,,,prod,,,false
generatedLivedocs,thumbnailImageUrl,NVARCHAR(MAX),What,The URL to the lower resolution thumbnail image representing the generated livedoc.,,,,prod,,,false
generatedLivedocs,createdAt,TIMESTAMP,When,The datetime the livedoc was generated.,,,,prod,,,false
generatedLivedocs,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
generatedLivedocs,flow,NVARCHAR(64),How,How the livedoc was generated.,,,,prod,,,false
generatedLivedocs,application,NVARCHAR(128),Where,The application that the user was in when they generated the livedoc.,,,,prod,,,false
generatedLivedocs,productArea,NVARCHAR(128),Where,The part of the Seismic platform the user was in when they generated the livedoc.,,,,prod,,,false
generatedLivedocComponents,id,NVARCHAR(64),Primary Id,The primary id for items in this table.,,,,prod,,,false
generatedLivedocComponents,createdAt,TIMESTAMP,When,The datetime the livedoc was generated.,,,,prod,,,false
generatedLivedocComponents,format,NVARCHAR(64),What,The format of content that was inserted via upload (will be null for all other components).,,,,prod,,,false
generatedLivedocComponents,componentType,NVARCHAR(64),What,"The type of component, related to format.",,,,prod,,,false
generatedLivedocComponents,generatedLivedocId,NVARCHAR(64),What,The id of the generated livedoc that this component was included in.,generatedLivedocs,id,,prod,primary,Nto1,false
generatedLivedocComponents,insertMethod,NVARCHAR(64),How,"The way this component was included in the presentation such as Shared, Reference, Dynamic, or External.",,,,prod,,,false
generatedLivedocComponents,insertSource,NVARCHAR(64),What,"The source of the component that was included in the presentation. The source is Library for all insertMethods except UserUpload. The source is User Created for insertMethod UserUpload, indicating the component is from a user's local drive and not the Seismic library.",,,,prod,,,false
generatedLivedocComponents,insertStatus,NVARCHAR(32),What,"The status of the component insert (Not Published, Not Found, Success).",,,,prod,,,false
generatedLivedocComponents,contentId,NVARCHAR(64),What,The id of the content the of the component.,contents,id,,prod,,Nto1,false
generatedLivedocComponents,contentVersionId,NVARCHAR(64),What,The version id of the content of the component.,contentVersions,id,,prod,,Nto1,false
generatedLivedocComponents,libraryContentId,NVARCHAR(64),What,The library content id of the component.,libraryContents,id,,prod,informational,Nto1,false
generatedLivedocComponents,libraryContentVersionId,NVARCHAR(64),What,The version id of the library content of the component.,libraryContentVersions,id,,prod,informational,Nto1,false
generatedLivedocComponents,workspaceContentId,NVARCHAR(64),What,The workspace content id of the component.,workspaceContents,id,,prod,informational,Nto1,false
generatedLivedocComponents,workspaceContentVersionId,NVARCHAR(64),What,The version id of the workspace content of the component.,workspaceContentVersions,id,,prod,informational,Nto1,false
generatedLivedocComponents,contentProfileId,NVARCHAR(64),Where,"The id of the content profile of the content of the component, if the content is in DocCenter.",contentProfiles,id,,prod,,Nto1,false
generatedLivedocComponents,contentProfileName,NVARCHAR(MAX),Where,"The name of the content profile of the content of the component, if the content is in DocCenter.",,,,prod,,,false
generatedLivedocComponents,libraryContentName,NVARCHAR(512),What,"The current name of the content of the component, if it is a library content.",,,,prod,,,false
generatedLivedocComponents,instanceName,NVARCHAR(512),What,The name of the content of the component at the time the livedoc was generated.,,,,prod,,,false
generatedLivedocComponents,normalizedName,NVARCHAR(512),What,The current name of the content of the component.,,,,prod,,,false
generatedLivedocComponents,parentComponentId,NVARCHAR(64),What,The id of the component that this component is a child of in this generated livedoc.,,,,prod,,,false
generatedLivedocComponents,thumbnailImageId,NVARCHAR(64),What,The lower resolution thumbnail image id of the content which can be used to get a thumbnail image of the content.,,,,prod,,,false
generatedLivedocComponents,thumbnailImageUrl,NVARCHAR(MAX),What,the lower resolution thumbnail image URL of the content.,,,,prod,,,false
generatedLivedocComponents,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
interactionRecipients,id,NVARCHAR(64),Primary Id,The id of the recipient of the interaction and the primary id for items in this table.,,,,prod,,,false
interactionRecipients,interactionId,NVARCHAR(64),How,The id of the interaction this recipient relates to.,userActivity,interactionId,,prod,,Nto1,false
interactionRecipients,internalUserId,NVARCHAR(64),Who,The id of the recipient in the users table.,users,id,,prod,informational,Nto1,false
interactionRecipients,isInternalUser,BOOLEAN,How,A boolean indicating whether or not the recipient is a Seismic user.,,,,prod,,,false
interactionRecipients,email,NVARCHAR(256),Who,The email address of the recipient.,,,,prod,,,false
interactionRecipients,emailDomain,NVARCHAR(256),Who,"The user's email address domain, such as seismic.com.",,,,prod,,,false
interactionRecipients,phoneNumber,NVARCHAR(256),Who,The phone number of the recipient.,,,,prod,,,false
interactionRecipients,recipientType,NVARCHAR(64),Who,The type of the recipient. Some values are only relevant to specific delivery types.,,,,prod,,,false
interactionRecipients,firstName,NVARCHAR(64),Who,"The recipient's first name or given name, if provided.",,,,prod,,,false
interactionRecipients,lastName,NVARCHAR(64),Who,"The recipient's last name or surname, if provided.",,,,prod,,,false
interactionRecipients,fullName,NVARCHAR(256),Who,"The full name of the recipient, if provided.",,,,prod,,,false
interactionRecipients,country,NVARCHAR(256),Who,"The country portion of the recipient's address, if provided. Only available for physical recipients when using delivery options such as print orders.",,,,prod,,,false
interactionRecipients,state,NVARCHAR(256),Who,"The state portion of the recipient's address, if provided. Only available for physical recipients.",,,,prod,,,false
interactionRecipients,city,NVARCHAR(256),Who,"The city portion of the recipient's address, if provided. Only available for physical recipients.",,,,prod,,,false
interactionRecipients,postalCode,NVARCHAR(256),Who,"The postal code portion of the recipient's address, if provided. Only available for physical recipients.",,,,prod,,,false
interactionRecipients,street,NVARCHAR(256),Who,"The street portion of the recipient's address, if provided. Only available for physical recipients.",,,,prod,,,false
interactionRecipients,createdAt,TIMESTAMP,When,The timestamp when the interaction recipient record was created.,,,,prod,,,false
interactionRecipients,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
externalContentDetails,id,NVARCHAR(64),Primary Id,The id of the external content record and primary key of this table.,,,,prod,,,false
externalContentDetails,libraryContentId,NVARCHAR(64),What,Id of the content that is synced in the library from an external source. One content may have more than one library content version.,libraryContents,id,,prod,primary,Nto1,false
externalContentDetails,libraryContentVersionId,NVARCHAR(64),What,Id of the content version that is synced in the library from an external source.,libraryContentVersions,id,,prod,primary,Nto1,false
externalContentDetails,originType,NVARCHAR(64),What,The origin source of the external content.,,,,prod,,,false
externalContentDetails,externalId,NVARCHAR(64),What,The Id of the content in the external source.,,,,prod,,,false
externalContentDetails,externalURL,NVARCHAR(MAX),What,The URL path of the content to the external source.,,,,prod,,,false
externalContentDetails,isDeleted,BOOLEAN,What,Boolean indicating if this content record was deleted.,,,,prod,,,false
externalContentDetails,isAutoUpdated,BOOLEAN,What,"If true, the sync service will auto sync the latest content when user change the content in external source.",,,,prod,,,false
externalContentDetails,isAutoPublished,BOOLEAN,What,"If true, the auto published configuration is enabled for when the content is synced.",,,,prod,,,false
externalContentDetails,syncOwnerId,NVARCHAR(64),Who,Id of the user who is responsible for the synced content.,users,id,,prod,,Nto1,false
externalContentDetails,syncOwnerUserName,NVARCHAR(64),Who,The username of the admin who is responsible for the synced content.,,,,prod,,,false
externalContentDetails,syncTimeStamp,TIMESTAMP,When,The timestamp of when the content was synced.,,,,prod,,,false
trainingGroupManagers,groupId,NVARCHAR(64),Primary Id,The id of the group.,trainingGroups,id,,prod,,Nto1,false
trainingGroupManagers,managerId,NVARCHAR(64),Primary Id,The user id of the manager.,users,id,,prod,,Nto1,false
trainingGroupManagers,managerUserId,NVARCHAR(64),Primary Id,The user id of the manager.,users,id,,prod,,Nto1,false
trainingGroupManagers,groupName,NVARCHAR(64),What,The name of the group.,,,,prod,,,false
contentPropertyAssignments,contentPropertyId,NVARCHAR(64),Primary Id,The id of the content property.,contentProperties,id,,prod,,Nto1,false
contentPropertyAssignments,libraryContentId,NVARCHAR(64),Primary Id,The id of the library content that this content property value is assigned to.,libraryContents,id,,prod,primary,Nto1,false
contentPropertyAssignments,contentPropertyName,NVARCHAR(64),What,The name of the content property.,,,,prod,,,false
contentPropertyAssignments,contentPropertyType,NVARCHAR(32),What,"The type of the content property (boolean, date, float, integer, multi-value, string, tag, datetime, any, dictionary).",,,,prod,,,false
contentPropertyAssignments,contentPropertyValue,NVARCHAR(MAX),What,The content property Value assigned to the listed piece of library content.,,,,prod,,,false
contentPropertyAssignments,contentPropertyValueBoolean,BOOLEAN,What,The content property value casted to an explicit boolean field if the type is set to boolean.,,,,prod,,,false
contentPropertyAssignments,contentPropertyValueDatetime,TIMESTAMP,What,The content property value casted to an explicit datetime field if the type is set to date.,,,,prod,,,false
contentPropertyAssignments,contentPropertyValueInteger,INTEGER,What,The content property value casted to an explicit integer field if the type is set to integer.,,,,prod,,,false
contentPropertyAssignments,contentPropertyValueFloat,FLOAT,What,The content property value casted to an explicit float field if the type is set to float.,,,,prod,,,false
groupMembers,groupId,NVARCHAR(64),Primary Id,The id of the group that this member belongs to.,groups,id,,prod,,Nto1,false
groupMembers,groupName,NVARCHAR(MAX),Who (Details),The name of the group.,,,,prod,,,false
groupMembers,userId,NVARCHAR(64),Who,The id of the user.,users,id,,prod,,Nto1,false
searchHistory,id,NVARCHAR(64),Primary Id,The primary id for events in this table.,,,,prod,,,false
searchHistory,occurredAt,TIMESTAMP,When,The timestamp that the search occurred.,,,,prod,,,false
searchHistory,activeScope,NVARCHAR(256),What,The scope active at the time of search.,,,,prod,,,false
searchHistory,application,NVARCHAR(128),Where (Seismic),The application that the user was in when they performed the search.,,,,prod,,,false
searchHistory,resultCount,INTEGER,What,The total number of results returned by the search.,,,,prod,,,false
searchHistory,resultCountContentManager,INTEGER,What,The total number of ContentManager results returned by the search.,,,,prod,,,false
searchHistory,resultCountControlCenter,INTEGER,What,The total number of ControlCenter results returned by the search.,,,,prod,,,false
searchHistory,resultCountDocCenter,INTEGER,What,The total number of DocCenter results returned by the search.,,,,prod,,,false
searchHistory,resultCountNewsCenter,INTEGER,What,The total number of NewsCenter results returned by the search.,,,,prod,,,false
searchHistory,resultCountWorkspace,INTEGER,What,The total number of Workspace results returned by the search.,,,,prod,,,false
searchHistory,resultCountSuggestedDoc,INTEGER,What,Total number of documents Quick Access Dropdown suggested in this search.,,,,prod,,,false
searchHistory,resultCountSuggestedFacet,INTEGER,What,Total number of facets Quick Access Dropdown suggested in this search.,,,,prod,,,false
searchHistory,resultCountSuggestedFolder,INTEGER,What,Total number of folders Quick Access Dropdown suggested in this search.,,,,prod,,,false
searchHistory,resultCountSuggestedKeyword,INTEGER,What,Total number of keywords Quick Access Dropdown has suggested in this search.,,,,prod,,,false
searchHistory,searchCycleId,NVARCHAR(64),What,An id for the combined cycle of steps for search and filter.,,,,prod,,,false
searchHistory,searchTermNormalized,NVARCHAR(256),What,The search term converted to lowercase and all special characters replaced by their ASCII equivalent.,,,,prod,,,false
searchHistory,searchTermRaw,NVARCHAR(1024),What,The search term as entered by the user.,,,,prod,,,false
searchHistory,searchType,NVARCHAR(32),What,The type of search based on the action the user took to create or modify the search.,,,,prod,,,false
searchHistory,sortBy,NVARCHAR(128),What,"What the search is sorted by, Relevance or Last Modified.",,,,prod,,,false
searchHistory,userId,NVARCHAR(64),Who,The id of the user who performed the search.,users,id,,prod,,Nto1,false
searchHistory,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
searchHistory,stepIndex,INTEGER,What,The 1-N based ordering of searches within a searchCycle. The first search in a cycle is always set to 1.,,,,prod,,,false
searchHistory,stepType,NVARCHAR(32),What,"Indicates whether or not this search was from an initial query, or from a follow-up refinement.",,,,prod,,,false
searchHistory,wasClicked,BOOLEAN,What,Indicates whether or not this search resulted in a click.,,,,prod,,,false
searchHistory,facetValues,NVARCHAR(MAX),What,Comma separated list of facet values applied to a given search.,,,,prod,,,false
contentProfileAssignments,contentProfileId,NVARCHAR(64),Primary Id,The content profile id of the profile to which the content is assigned.,contentProfiles,id,,prod,,Nto1,false
contentProfileAssignments,libraryContentVersionId,NVARCHAR(64),Primary Id,The library content version id of the content assigned to the content profile.,libraryContentVersions,id,,prod,,Nto1,false
contentProfileAssignments,contentProfileVersionId,NVARCHAR(64),What,The content profile version id of the profile to which the content is assigned.,contentProfiles,versionId,,prod,,Nto1,false
contentProfileAssignments,isPredictiveOnly,BOOLEAN,Where,A boolean indicating if the profile is for predictive content use only.,,,,prod,,,false
contentProfileAssignments,isPublished,BOOLEAN,Where,A boolean indicating if the profile is published.,,,,prod,,,false
contentProfileAssignments,contentProfileName,NVARCHAR(256),Where,The name of the profile to which the content is assigned.,,,,prod,,,false
contentProfileAssignments,contentProfileType,NVARCHAR(32),Where,The type of profile. Profiles can be ChannelProfile (for NewsCenter) or ContentProfile (for DocCenter/Collections).,,,,prod,,,false
contentProfileAssignments,libraryContentId,NVARCHAR(64),Where,The library content id of the content assigned to the content profile.,libraryContents,id,,prod,,Nto1,false
contentProfileAssignments,addToProfileAt,TIMESTAMP,When,The datetime that this content was added to the profile.,,,,prod,,,false
contentProfileAssignments,isDeleted,BOOLEAN,Where,Boolean indicating if this profile assignment is deleted.,,,,prod,,,false
contentProfileAssignments,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
contentProfileAssignments,contentStatus,NVARCHAR(64),What,The status of the content in the profile for tenants with Streamline Publishing enabled.,,,,prod,,,false
contentProfileAssignments,contentLastPublishedDate,TIMESTAMP,When,The datetime that this content was published to the profile.,,,,prod,,,false
livesendLinkMembers,externalUserId,NVARCHAR(64),Primary Id,The id of the external user in the externalUsers table.,externalUsers,id,,prod,primary,Nto1,false
livesendLinkMembers,livesendLinkId,NVARCHAR(64),Primary Id,"The id of the livesend link that was sent to this member (recipient). Note - If LiveSend was sent from system with ‘send separate emails’ checked, then the livesendLinkId will be unique per recipient (externalUserId). If LiveSend was sent from system with ‘send one email to group’ then livesendLinkId will not be unique per recipient (externalUserId) so multiple recipients will have the same livesendLinkId. For LiveSend links created with Generate Livesend Link there are no members.",livesendLinks,id,,prod,primary,Nto1,false
livesendLinkMembers,createdAt,TIMESTAMP,When (Details),The datetime that the link member (recipient) was added to the livesend link.,,,,prod,,,false
livesendLinkMembers,email,NVARCHAR(256),Who (Details),The email address of the link member (recipient).,,,,prod,,,false
livesendLinkMembers,internalUserId,NVARCHAR(64),Who (Details),"The id of the Seismic user if a user with this email address was found in the users table. This field is nullable when the member is not a Seismic user. In the case that more than one user was found, one of them will be chosen at random.",users,id,,prod,primary,Nto1,false
livesendLinkMembers,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
livesendLinkMembers,isInternalUser,BOOLEAN,Who (Details),A boolean indicating whether or not the member is a Seismic user.,,,,prod,,,false
livedocGlobalVariableRequests,id,NVARCHAR(64),Primary Id,The id and primary key of the LiveDoc Variable retrieve data requests.,,,,prod,,,false
livedocGlobalVariableRequests,region,NVARCHAR(64),What,The region of this request.,,,,prod,,,false
livedocGlobalVariableRequests,requestType,NVARCHAR(64),What,The type of request action.,,,,prod,,,false
livedocGlobalVariableRequests,requestTime,TIMESTAMP,When,The datetime of the request occurrence.,,,,prod,,,false
livedocGlobalVariableRequests,variableType,NVARCHAR(64),What,The type of this Variable type.,,,,prod,,,false
livedocGlobalVariableRequests,variableOutputDataType,NVARCHAR(64),What,The Variable output data type.,,,,prod,,,false
livedocGlobalVariableRequests,variableFormat,NVARCHAR(64),What,The type of this Variable content format.,,,,prod,,,false
livedocGlobalVariableRequests,variableVersion,NVARCHAR(64),What,The version of the Variable.,,,,prod,,,false
livedocGlobalVariableRequests,operatorId,NVARCHAR(64),Who,The user id of the operator.,users,id,,prod,,Nto1,false
livedocGlobalVariableRequests,operatorName,NVARCHAR(64),Who,The name of the operator.,,,,prod,,,false
livedocGlobalVariableRequests,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
indirectGroupMembers,id,NVARCHAR(64),Primary Id,The id of the unique indirect group member row.,,,,prod,,,false
indirectGroupMembers,groupId,NVARCHAR(64),What,The id of the group that this member belongs.,groups,id,,prod,,Nto1,false
indirectGroupMembers,groupName,NVARCHAR(MAX),Who (Details),The name of the group.,,,,prod,,,false
indirectGroupMembers,indirectUserId,NVARCHAR(64),What,The id of the indirect group member.,users,id,,prod,,1to1,false
generatedLivedocSlides,id,NVARCHAR(64),Primary Id,The unique identifier for a given slide in the generated LiveDoc.,,,,prod,,,false
generatedLivedocSlides,generatedLivedocId,NVARCHAR(64),What,The id of the generated LiveDoc that this slide was included in.,generatedLivedocs,id,,prod,primary,Nto1,false
generatedLivedocSlides,pageShortId,NVARCHAR(64),What,The global unique identifier for this slide.,,,,prod,,,false
generatedLivedocSlides,parentComponentId,NVARCHAR(64),What,The id of the component that this slide was in as part of this presentation.,,,,prod,,,false
generatedLivedocSlides,position,INTEGER,What,The 1-thru-N position of this slide in the presentation.,,,,prod,,,false
generatedLivedocSlides,title,NVARCHAR(256),What,The title of this slide.,,,,prod,,,false
generatedLivedocSlides,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
generatedLivedocSlides,originContentRepository,NVARCHAR(256),Where,The repository from which the content of this slide originated.,,,,prod,,,false
generatedLivedocSlides,originContentId,NVARCHAR(64),What,"The original library content Id of a slide. When a slide comes from a library component, the originContentId will be the slides source component Id. When the slide comes from the LiveDoc template itself, the originContentId will be the LiveDoc templates Id. For the slides that are uploaded from local, the originContentId will be null.",,,,prod,,,false
generatedLivedocSlides,originContentVersionId,NVARCHAR(64),What,The version id of the content of this slide.,,,,prod,,,false
generatedLivedocSlides,originContentPageIndex,INTEGER,What,The 1-N page index that this slide was in the origin content version.,,,,prod,,,false
generatedLivedocSlides,insertMethod,NVARCHAR(64),What,"The way this component was included in the presentation such as Shared, Reference, Dynamic, or External.",,,,prod,,,false
generatedLivedocSlides,thumbnailImageUrl,NVARCHAR(MAX),What,The lower resolution thumbnail image URL of the slide.,,,,prod,,,false
contentInsertInstances,id,NVARCHAR(64),Primary Id,The id of a content insert instance.,,,,prod,,,false
contentInsertInstances,contentInsertInstanceGroupId,NVARCHAR(64),What,The id shared among all content inserted in a single content insertion.,,,,prod,,,false
contentInsertInstances,contentVersionId,NVARCHAR(64),What,The version id of the content inserted.,contentVersions,id,,prod,informational,Nto1,false
contentInsertInstances,repository,NVARCHAR(16),What,The repository where content is located when the insert activity occurs.,,,,prod,,,false
contentInsertInstances,contentProfileId,NVARCHAR(64),Where,The id of the content profile during the content insertion activity.,contentProfiles,id,,prod,,Nto1,false
contentInsertInstances,contentProfileName,NVARCHAR(MAX),Where,The name of the content profile of the content inserted.,,,,prod,,,false
contentInsertInstances,userID,NVARCHAR(64),Who,The id of the user who inserted content in this instance.,users,id,,prod,informational,Nto1,false
contentInsertInstances,occurredAt,TIMESTAMP,When,The datetime when the content insert activity occurred.,,,,prod,,,false
contentInsertInstances,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
meetingAgendaUpdates,id,NVARCHAR(64),Primary Id,The id of the unique contributor and agenda update combination. The primary id for this table.,,,,prod,,,false
meetingAgendaUpdates,meetingId,NVARCHAR(64),What,The meeting id that the agenda belongs to.,meetings,id,,prod,,Nto1,false
meetingAgendaUpdates,userId,NVARCHAR(64),Who,The Seismic user id of the Seismic user who updated the agenda of the meeting.,users,id,,prod,,Nto1,false
meetingAgendaUpdates,userName,NVARCHAR(64),Who,The Seismic username of the Seismic user who updated the agenda the meeting.,,,,prod,,,false
meetingAgendaUpdates,occurredAt,TIMESTAMP,When,The datetime that the agenda update took place.,,,,prod,,,false
meetingAgendaUpdates,agendaCharacters,INTEGER,What,The character count of the plain text in the meeting agenda.,,,,prod,,,false
meetingAgendaUpdates,modifiedAt,TIMESTAMP,modifiedAt,"The datetime the meeting was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
meetings,id,NVARCHAR(64),Primary Id,The meeting id and the primary id for this table.,,,,prod,,,false
meetings,name,NVARCHAR(64),What,The name of the meeting.,,,,prod,,,false
meetings,type,NVARCHAR(64),What,The type of the meeting.,,,,prod,,,false
meetings,externalMeetingId,NVARCHAR(64),What,The external meeting id if applicable. Typically an Id created by an external source where the meeting took place.,,,,prod,,,false
meetings,externalMeetingType,NVARCHAR(64),What,The type of external meeting if applicable.,,,,prod,,,false
meetings,startedAt,TIMESTAMP,When,The datetime that the meeting started.,,,,prod,,,false
meetings,endedAt,TIMESTAMP,When,The datetime that the meeting ended.,,,,prod,,,false
meetings,durationSeconds,INTEGER,What,The length of the meeting from start to end in seconds.,,,,prod,,,false
meetings,hostId,NVARCHAR(64),Who,The user id of the user who hosted the meeting.,users,id,,prod,,Nto1,false
meetings,hostUserName,NVARCHAR(64),Who,The username of the user who hosted the meeting.,,,,prod,,,false
meetings,prepFirstActivityAt,TIMESTAMP,When,The datetime that the first activity before the meeting has started. This includes drafts which would be automatically created when the user uses the calendar integration.,,,,prod,,,false
meetings,prepLastActivityAt,TIMESTAMP,When,The datetime of the last activity before the meeting starts.,,,,prod,,,false
meetings,agendaCharacters,INTEGER,What,The character count of the plain text in the meeting agenda.,,,,prod,,,false
meetings,generalNotesCharacters,INTEGER,What,The character count of the plain text in the meeting general notes.,,,,prod,,,false
meetings,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
emails,id,NVARCHAR(64),Primary Id,The primary id of the email and the primary key for items in this table.,,,,prod,,,false
emails,interactionId,NVARCHAR(64),How,The id of the interaction related to this email. Is 1:1 with a given interaction.,userActivity,interactionId,,prod,,Nto1,false
emails,subject,NVARCHAR(MAX),What,The subject of the email.,,,,prod,,,false
emails,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
emails,status,NVARCHAR(MAX),What,The furthest status this email event has reached.,,,,prod,,,false
emails,occurredAt,TIMESTAMP,When,The datetime this email was sent.,,,,prod,,,false
emails,firstOpenedAt,TIMESTAMP,When,The datetime this email was first opened.,,,,prod,,,false
emails,interactionGroupId,NVARCHAR(64),What,The id of the interaction group this email belongs to.,,,,prod,,,false
emails,interactionGroupName,NVARCHAR(MAX),What,The name of the interaction group this email belongs to.,,,,prod,,,false
emails,isDeleted,BOOLEAN,What,Boolean indicating if this record is deleted.,,,,prod,,,false
emails,emailImpersonationUserId,NVARCHAR(64),Who,Userid of the impersonator who sent the blast on behalf of another user.,users,id,,prod,,Nto1,false
emails,sentAsBlast,BOOLEAN,How,Boolean indicating if the email was sent as part of a blast.,,,,prod,,,false
contentPages,id,NVARCHAR(8),Primary Id,The 8-bit id of the content page.,,,,prod,,,false
contentPages,pageIndex,INTEGER,What,The 1-N index of the page in the content.,,,,prod,,,false
contentPages,contentId,NVARCHAR(64),What,The id of the content that this page is a part of.,Contents,id,,prod,,Nto1,false
contentPages,contentVersionId,NVARCHAR(64),What,The version id of the content that this page is a part of.,ContentVersions,id,,prod,,Nto1,false
contentPages,repository,NVARCHAR(9),Where,The repository of the content that this page is a part of.,,,,prod,,,false
contentPages,parentPageId,NVARCHAR(8),What,"If the page originated from another page, the id of the page that this originated from.  For example library copies, library to workspace copies, workspace copies, etc.",contentPages,id,,prod,,Nto1,false
contentPages,parentPageIndex,INTEGER,What,The page index of the page in the parent content.,,,,prod,,,false
contentPages,parentContentId,NVARCHAR(64),What,The id of the content that the parent page is part of.,Contents,id,,prod,,Nto1,false
contentPages,parentContentVersionId,NVARCHAR(64),What,The version id of the content that the parent page is part of.,ContentVersions,id,,prod,,Nto1,false
contentPages,parentRepository,NVARCHAR(9),Where,The repository that the parent content is from.,,,,prod,,,false
contentPages,originLibraryContentPageId,NVARCHAR(8),What,"If this page is a decedent of a library page, this will be the id of that page.",contentPages,id,,prod,,Nto1,false
contentPages,originLibraryContentPageIndex,INTEGER,What,The page index of the page in the origin library Contents.,,,,prod,,,false
contentPages,originLibraryContentId,NVARCHAR(64),What,The id of the library content that the origin library page is part of.,libraryContents,id,,prod,,Nto1,false
contentPages,originLibraryContentVersionId,NVARCHAR(64),What,The version id of the library content that the origin library page is part of.,libraryContentVersions,id,,prod,,Nto1,false
contentPages,parents,ARRAY,What,"The full lineage of all parent pages of the page where each object contains the contentId, contentVersionId, id (which is the page id), pageIndex, and repository of the page as well as a “depth” field indicating how many ancestors it is away from this page, where 0 equals the first parent.",,,,prod,,,false
contentPages,occurredAt,TIMESTAMP,When,When the content page was added.,,,,prod,,,false
contentProfileAssignmentsHistory,contentProfileId,NVARCHAR(64),Primary Id,The content profile id of the profile to which the content is assigned.,contentProfiles,id,,prod,,Nto1,false
contentProfileAssignmentsHistory,libraryContentVersionId,NVARCHAR(64),Primary Id,The library content version id of the content assigned to the content profile.,libraryContentVersions,id,,prod,,Nto1,false
contentProfileAssignmentsHistory,contentProfileVersionId,NVARCHAR(64),What,The content profile version id of the profile to which the content is assigned.,contentProfiles,versionId,,prod,,Nto1,false
contentProfileAssignmentsHistory,isPredictiveOnly,BOOLEAN,Where,A boolean indicating if the profile is for predictive content use only.,,,,prod,,,false
contentProfileAssignmentsHistory,isPublished,BOOLEAN,Where,A boolean indicating if the profile is published.,,,,prod,,,false
contentProfileAssignmentsHistory,contentProfileName,NVARCHAR(256),Where,The name of the profile to which the content is assigned.,,,,prod,,,false
contentProfileAssignmentsHistory,contentProfileType,NVARCHAR(32),Where,The type of profile. Profiles can be ChannelProfile (for NewsCenter) or ContentProfile (for DocCenter/Collections).,,,,prod,,,false
contentProfileAssignmentsHistory,libraryContentId,NVARCHAR(64),Where,The library content id of the content assigned to the content profile.,libraryContents,id,,prod,,Nto1,false
contentProfileAssignmentsHistory,addToProfileAt,TIMESTAMP,When,The datetime that this content was added to the profile.,,,,prod,,,false
contentProfileAssignmentsHistory,isDeleted,BOOLEAN,Where,Boolean indicating if this profile assignment is deleted.,,,,prod,,,false
contentProfileAssignmentsHistory,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
contentProfileAssignmentsHistory,contentStatus,NVARCHAR(64),What,The status of the content in the profile for tenants with Streamline Publishing enabled.,,,,prod,,,false
contentProfileAssignmentsHistory,contentLastPublishedDate,TIMESTAMP,When,The datetime that this content was published to the profile.,,,,prod,,,false
userGroupsList,id,NVARCHAR(64),Primary Id,The id of the user and the primary id for items in this table.,,,,prod,,,false
userGroupsList,groupNameList,ARRAY,Who (Details),"A comma separated, alphabetical list of all groups the user is most recently associated with.",,,,prod,,,false
favoriteStatus,id,NVARCHAR(64),Primary Id,The id of a user-to-content association.,,,,prod,,,false
favoriteStatus,occurredAt,TIMESTAMP,When,The datetime that the content was favorited.,,,,prod,,,false
favoriteStatus,modifiedAt,TIMESTAMP,modifiedAt,"Same date and time as occurredAt, but aliased to proxy as system date.",,,,prod,,,false
favoriteStatus,userId,NVARCHAR(64),Who,The id of the user who favorited the content.,users,id,,prod,,Nto1,false
favoriteStatus,userFullName,NVARCHAR(MAX),Who,The full name of the user.,,,,prod,,,false
favoriteStatus,contentId,NVARCHAR(64),What,The id of the content that is favorited.,libraryContents,id,,prod,,Nto1,false
favoriteStatus,contentName,NVARCHAR(MAX),What,The name of the content.,,,,prod,,,false
customContentTypes,id,NVARCHAR(64),Primary Id,The unique id of a custom content schema chains.,customContents,customContentTypeId,,prod,,Nto1,false
customContentTypes,versionId,NVARCHAR(64),What,The unique version id associated with the Custom Content Type.,customContents,customContentTypeVersionId,,prod,,Nto1,false
customContentTypes,versionTag,NVARCHAR(64),What,The version number in text format for the custom content type.,,,,prod,,,false
customContentTypes,name,NVARCHAR(256),What,The name of the custom content type.,,,,prod,,,false
customContentTypes,description,NVARCHAR(MAX),What,The user-defined description of the custom content type.,,,,prod,,,false
customContentTypes,status,NVARCHAR(64),What,The status of the custom content type.,,,,prod,,,false
customContentTypes,createdAt,TIMESTAMP,When,The time the user created the record.,,,,prod,,,false
customContentTypes,userModifiedAt,TIMESTAMP,When,The time the user modified the record.,,,,prod,,,false
customContentTypes,deletedAt,TIMESTAMP,When,The time the user deleted the custom content type record.,,,,prod,,,false
customContentTypes,isDeleted,BOOLEAN,What,Boolean indicating if the custom content type record is or is not deleted.,,,,prod,,,false
contentAskExperts,id,NVARCHAR(64),Primary Id,The primary id of the Ask Expert question and primary id for records in this table.,,,,prod,,,false
contentAskExperts,libraryContentVersionId,NVARCHAR(64),What,The library content version id on which the question was sumitted.,libraryContentVersions,id,,prod,,Nto1,false
contentAskExperts,libraryContentId,NVARCHAR(64),What,The library content id on which the question was sumitted.,libraryContents,id,,prod,,Nto1,false
contentAskExperts,questionBy,NVARCHAR(64),Who,The user id of the user who submitted the question.,users,id,,prod,,Nto1,false
contentAskExperts,questionAt,TIMESTAMP,When,The datetime the question was first submitted.,,,,prod,,,false
contentAskExperts,question,NVARCHAR(512),What,The question submitted by the user.,,,,prod,,,false
contentAskExperts,answeredBy,NVARCHAR(64),Who,The id of the expert who answered the question.,users,id,,prod,,Nto1,false
contentAskExperts,answeredAt,TIMESTAMP,When,The datetime the answer was first submitted.,,,,prod,,,false
contentAskExperts,answer,NVARCHAR(MAX),What,The answer submitted by the expert.,,,,prod,,,false
contentAskExperts,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
contentAskExperts,isDeleted,BOOLEAN,What,Boolean indicating if this record is deleted.,,,,prod,,,false
meetingContentPresentations,id,NVARCHAR(64),Primary Id,The meeting content presentation id and the primary id for this table.,,,,prod,,,false
meetingContentPresentations,meetingId,NVARCHAR(64),Who,The associated meeting Id where the content presentation took place.,meetings,id,,prod,,Nto1,false
meetingContentPresentations,contentId,NVARCHAR(64),What,The id of the content which can globally identify content from Library or WorkSpace.,contents,id,,prod,,Nto1,false
meetingContentPresentations,contentVersionId,NVARCHAR(64),What,The id of the content version associated with the activity.,contentVersions,id,,prod,,Nto1,false
meetingContentPresentations,name,NVARCHAR(512),What,The name of the content the version is associated with.,,,,prod,,,false
meetingContentPresentations,repository,NVARCHAR(9),What,The repository where content is located when activity occurs.,,,,prod,,,false
meetingContentPresentations,startedAt,TIMESTAMP,When,The datetime that the content presentation started.,,,,prod,,,false
meetingContentPresentations,endedAt,TIMESTAMP,When,The datetime that the content presentation ended.,,,,prod,,,false
meetingContentPresentations,durationSeconds,INTEGER,What,The length of the content presentation from start to end in seconds.,,,,prod,,,false
meetingContentPresentations,presentedById,NVARCHAR(64),Who,The Seismic user id of the Seismic user who presented this instance of content in the meeting.,users,id,,prod,,Nto1,false
meetingContentPresentations,presentedByUserName,NVARCHAR(64),Who,The Seismic username of the Seismic who presented this instance of content in the meeting.,,,,prod,,,false
meetingContentPresentations,presentedByIsInternalUser,BOOLEAN,Who,True/False indicating if the user who did the content presentation was internal. An internal user is defined as having an account within the Seismic platform.,,,,prod,,,false
meetingContentPresentations,presentationType,NVARCHAR(64),What,The type of the content presentation that took place.,,,,prod,,,false
meetingContentPresentations,totalPages,INTEGER,What,The number of pages of the content presented.,,,,prod,,,false
meetingContentPresentations,isUploadedFromLocal,BOOLEAN,What,"True/False indicating if the content was uploaded from local directly. Otherwise, the content was added from the Library.",,,,prod,,,false
meetingContentPresentations,personalizationMethod,NVARCHAR(64),What,The personalization flow used for the added content being presented.,,,,prod,,,false
meetingContentPresentations,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
customContentTypeFields,id,NVARCHAR(64),Primary Id,The unique id of a custom content schema field.,,,,prod,,,false
customContentTypeFields,customContentTypeId,NVARCHAR(64),What,The id associated with the Custom Content Type.,customContentTypes,id,,prod,,Nto1,false
customContentTypeFields,name,NVARCHAR(256),What,The name of the custom content type field.,,,,prod,,,false
customContentTypeFields,description,NVARCHAR(MAX),What,The description of the custom content type field.,,,,prod,,,false
customContentTypeFields,fieldType,NVARCHAR(64),What,The type of custom content field.,,,,prod,,,false
customContentTypeFields,isOptional,BOOLEAN,What,Boolean indicating if the custom content type field is or is not optional.,,,,prod,,,false
customContentTypeFields,modifiedAt,TIMESTAMP,modifiedAt,The time the record was last modified.,,,,prod,,,false
searchWords,id,NVARCHAR(64),Primary Id,The primary id for events in this table.,,,,prod,,,false
searchWords,occurredAt,TIMESTAMP,When,The timestamp that the search occurred.,,,,prod,,,false
searchWords,searchCycleId,NVARCHAR(64),What,An id for the combined cycle of steps for search and filter.,searchHistory,searchCycleId,,prod,informational,NtoN,false
searchWords,searchHistoryId,NVARCHAR(64),What,The id of the search history that searched for this word.,searchHistory,id,,prod,informational,Nto1,false
searchWords,word,NVARCHAR(256),What,The word that was searched.,,,,prod,,,false
searchWords,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
customProperties,id,NVARCHAR(64),Primary Id,The Id of the custom property and primary id for this table.,,,,prod,,,false
customProperties,name,NVARCHAR(MAX),What,The name of the custom property.,,,,prod,,,false
customProperties,type,NVARCHAR(32),What,Defines the type of custom property such a multi-select or tag.,,,,prod,,,false
customProperties,helperText,NVARCHAR(MAX),What,"Provides insight about this property's input, such as how the input will be used.",,,,prod,,,false
customProperties,editState,NVARCHAR(32),What,Defines the edit settings for this property.,,,,prod,,,false
customProperties,listOrder,INTEGER,What,A 1-N number representing the order this property appears within the list of all custom properties.,,,,prod,,,false
customProperties,hasDomainOfValues,BOOLEAN,What,Boolean indicating if this property has an associated domain of values.,,,,prod,,,false
adminImpersonationSessions,id,NVARCHAR(64),Primary Id,The id of the impersonation session.,,,,prod,,,false
adminImpersonationSessions,adminImpersonationUserId,NVARCHAR(64),Who,Id of the user who started the impersonation session.,users,id,,prod,primary,Nto1,false
adminImpersonationSessions,impersonateeUserId,NVARCHAR(64),Who,Id of the user who is being impersonated in this session.,users,id,,prod,primary,Nto1,false
adminImpersonationSessions,sessionStartedAt,TIMESTAMP,When,Start time of the impersonation session.,,,,prod,,,false
adminImpersonationSessions,sessionEndedAt,TIMESTAMP,When,End time of the impersonation session.,,,,prod,,,false
adminImpersonationSessions,durationSeconds,INTEGER,What,Duration in seconds of the impersonation session.,,,,prod,,,false
adminImpersonationSessions,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
adminImpersonationSessions,adminImpersonationUserName,NVARCHAR(64),Who,The username of the admin using impersonation.,,,,prod,,,false
adminImpersonationSessions,impersonateeUserName,NVARCHAR(64),Who,The username of the user being impersonated.,,,,prod,,,false
entitlementRoles,id,NVARCHAR(64),Primary Id,The id of the role.,,,,prod,,,false
entitlementRoles,roleName,NVARCHAR(64),What,The name of the role.,,,,prod,,,false
entitlementRoles,isPredefined,BOOLEAN,What,Tells if the role is predefined by the system or created by customer as a customized role.,,,,prod,,,false
entitlementRoles,roleDescription,NVARCHAR(256),What,The description for the entitlement role.,,,,prod,,,false
entitlementRoles,createdAt,TIMESTAMP,When,The timestamp when the entitlement role was created.,,,,prod,,,false
entitlementRoles,createdBy,NVARCHAR(64),Who,The id of the user that created the entitlemnent role.,users,id,,prod,,Nto1,false
entitlementRoles,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
entitlementRoles,modifiedBy,NVARCHAR(64),Who,The id of the user that modified the entitlemnent role. Could also be a system-driven value.,users,id,,prod,,Nto1,false
entitlementRoles,isDeleted,BOOLEAN,Who,A boolean indicating if the entitlement role is currently considered deleted.,,,,prod,,,false
indirectGroupManagers,id,NVARCHAR(64),Primary Id,The id of the unique indirect group manager row.,,,,prod,,,false
indirectGroupManagers,groupId,NVARCHAR(64),What,The id of the group.,groups,id,,prod,,Nto1,false
indirectGroupManagers,groupName,NVARCHAR(MAX),Who (Details),The name of the group.,,,,prod,,,false
indirectGroupManagers,indirectManagerId,NVARCHAR(64),What,The user id of the manager.,users,id,,prod,,Nto1,false
channels,id,NVARCHAR(64),Primary Id,The id of the channel.,,,,prod,,,false
channels,channelName,NVARCHAR(256),What,The name of the channel.,,,,prod,,,false
channels,createdAt,TIMESTAMP,When,The datetime that the channel was created.,,,,prod,,,false
channels,modifiedAt,TIMESTAMP,modifiedAt,The datetime that the channel was last modified.,,,,prod,,,false
digitalSalesRoomViewingSessions,id,NVARCHAR(64),Primary Id,The unique identifier for a given viewing session.,,,,prod,,,false
digitalSalesRoomViewingSessions,digitalSalesRoomId,NVARCHAR(64),What,"The id of the digital sales room that contained the page on which the view occurred. Note - If DSR was sent from system with ‘send separate emails’ checked, then the Viewing Session will be unique per recipient of the email. If DSR was sent from system with ‘send one email to group’ then, the Viewing Session will be not unique per recipient of the email and there will be no way to track which recipient from recipient group is associated to each viewing session.",digitalSalesRooms,id,,prod,,Nto1,false
digitalSalesRoomViewingSessions,roomDurationSeconds,INTEGER,What,The number of seconds the buyer spent on the digital sales room (as opposed to content).,,,,prod,,,false
digitalSalesRoomViewingSessions,engagementUserEmail,NVARCHAR(256),Who,Email of user who is engaging with the digital sales room. Includes both internal and external user emails.,,,,prod,,,false
digitalSalesRoomViewingSessions,isEngagementUserInternal,BOOLEAN,Who,Indicates if the user who is engaging with the digital sales room is an internal user with Seismic account.,,,,prod,,,false
digitalSalesRoomViewingSessions,sessionStartedAt,TIMESTAMP,When,The datetime that the viewing session started in the recipient's browser.,,,,prod,,,false
digitalSalesRoomViewingSessions,sessionEndedAt,TIMESTAMP,When,The datetime that the viewing session ended in the recipient's browser.,,,,prod,,,false
digitalSalesRoomViewingSessions,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
digitalSalesRoomViewingSessions,city,NVARCHAR(256),Where,Name of the city where the user was located when they viewed the digital sales room.,,,,prod,,,false
digitalSalesRoomViewingSessions,state,NVARCHAR(256),Where,Name of the state where the user was located when they viewed the digital sales room.,,,,prod,,,false
digitalSalesRoomViewingSessions,country,NVARCHAR(256),Where,Name of the country where the user was located when they viewed the digital sales room.,,,,prod,,,false
digitalSalesRoomViewingSessions,ipAddress,NVARCHAR(256),Where,Ip Address for where the user was located when they viewed the digital sales room.,,,,prod,,,false
digitalSalesRoomViewingSessions,geolocationLatitude,NVARCHAR(64),Where,Latitude for where the user was located when they viewed the digital sales room.,,,,prod,,,false
digitalSalesRoomViewingSessions,geoLocationLongitude,NVARCHAR(64),Where,Longitude for where the user was located when they viewed the digital sales room.,,,,prod,,,false
digitalSalesRoomViewingSessions,userId,NVARCHAR(64),Who,Seismic user id of viewer of the session.,users,id,,prod,,Nto1,false
contentProperties,id,NVARCHAR(64),Primary Id,The id of the content property.,,,,prod,,,false
contentProperties,hasDomainOfValues,BOOLEAN,What,A boolean indicating if this property has a fixed domain of values.,,,,prod,,,false
contentProperties,isRequired,BOOLEAN,What,A boolean indicating if this property is required to be assigned to content. A required property must be assigned before a piece of content can be published.,,,,prod,,,false
contentProperties,listOrder,INTEGER,What,A 1-N number representing the order this property is in for the teamsite.,,,,prod,,,false
contentProperties,name,NVARCHAR(64),What,The name of the content property.,,,,prod,,,false
contentProperties,teamsiteId,NVARCHAR(64),Where,The id of the teamsite this property belongs to.,teamsites,id,,prod,informational,Nto1,false
contentProperties,type,NVARCHAR(32),What,"The type of the content property (multi-value, string, tag, integer, date, boolean, float).",,,,prod,,,false
userEntitlementRoleAssignments,id,NVARCHAR(64),Primary Id,The id of the role assignment.,,,,prod,,,false
userEntitlementRoleAssignments,roleId,NVARCHAR(64),What,The id of the role.,entitlement_roles,id,,prod,,Nto1,false
userEntitlementRoleAssignments,roleName,NVARCHAR(64),What,The name of the role.,,,,prod,,,false
userEntitlementRoleAssignments,assigneeId,NVARCHAR(64),Who,The user id of the assignee.,users,id,,prod,,Nto1,false
userEntitlementRoleAssignments,assignedAt,TIMESTAMP,When,The timestamp when the entitlement role assignment occurred.,,,,prod,,,false
userEntitlementRoleAssignments,createdBy,NVARCHAR(64),Who,The id of the user that assigned the entitlemnent role.,users,id,,prod,,Nto1,false
userEntitlementRoleAssignments,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
publishingApprovalWorkflowAcknowledgements,workflowId,NVARCHAR(64),What,The id of publishing approval workflow instance.,publishingApprovalWorkflows,id,,prod,,Nto1,false
publishingApprovalWorkflowAcknowledgements,acknowledgementId,NVARCHAR(64),What,Id of publishing workflow approval acknowledgement.,,,,prod,,,false
publishingApprovalWorkflowAcknowledgements,acknowledgementName,NVARCHAR(512),What,"Name of publishing workflow approval acknowledgement, it is the value set by admin when configuring acknowledgement for workflow rule.",,,,prod,,,false
publishingApprovalWorkflowAcknowledgements,acknowledgementTitle,NVARCHAR(512),What,Title of publishing workflow approval acknowledgement. It offers more detail than the name. This is the acknowledgement title that users see upon or after workflow submission.,,,,prod,,,false
publishingApprovalWorkflowAcknowledgements,acknowledgementMessage,NVARCHAR(MAX),What,The message in publishing workflow approval acknowledgement.,,,,prod,,,false
publishingApprovalWorkflowAcknowledgements,systemModifiedAt,TIMESTAMP,modifiedAt,The datetime when the acknowledgement is raised.,,,,prod,,,false
pageContentHistory,id,NVARCHAR(64),Primary Id,The id of a Page-to-Content association.,,,,prod,,,false
pageContentHistory,libraryContentId,NVARCHAR(64),What,The id of the Seismic Page.,libraryContents,id,,prod,,1to1,false
pageContentHistory,libraryContentVersionId,NVARCHAR(64),What,The id of the Seismic Page version.,libraryContents,id,,prod,,1to1,false
pageContentHistory,associatedObjectId,NVARCHAR(64),What,"The id of the content that appears on this Page. This Id can be joined to paths.id, lessons.id or the contents.id model depending on the associatedObjectType.",,,,prod,,,false
pageContentHistory,associatedObjectName,NVARCHAR(64),What,The associated object name.,,,,prod,,,false
pageContentHistory,associatedObjectType,NVARCHAR(64),What,"The type of the associated Content (e.g. seismic-content, lessonly-lesson, lessonly-path).",,,,prod,,,false
pageContentHistory,associatedSeismicContentId,NVARCHAR(64),What,The id of the associated Seismic Content.,contents,id,,prod,,Nto1,false
pageContentHistory,associatedSeismicContentVersionId,NVARCHAR(64),What,The id of the associated Seismic Content version.,contentVersions,id,,prod,,Nto1,false
pageContentHistory,associatedLessonlyId,NVARCHAR(64),What,The id of the associated Lessonly content. This Id can be joined to paths.id or lessons.id depending on the content type.,,,,prod,,,false
pageContentHistory,lastSeenOnPageAt,TIMESTAMP,When,The most recent time the page-to-content associated was recorded.,,,,prod,,,false
pageContentHistory,firstSeenOnPageAt,TIMESTAMP,What,The first time the page-to-content associated was recorded.,,,,prod,,,false
pageContentHistory,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
pageContentHistory,hadStaticAssociation,BOOLEAN,What,True if any associated between the Page and Content was through a static document list widget.,,,,prod,,,false
pageContentHistory,hadDynamicAssociation,BOOLEAN,What,True if any associated between the Page and Content was through a dynamic document list widget.,,,,prod,,,false
pageContentHistory,pageName,NVARCHAR(64),What,The name of the page.,,,,prod,,,false
pageContentHistory,pageOwnerId,NVARCHAR(64),Who,The page's owner Id.,users,id,,prod,,Nto1,false
pageContentHistory,associatedSeismicContentOwnerId,NVARCHAR(64),Who,The associated Seismic content owner's id.,,,,prod,,,false
pageContentHistory,associatedObjectViews,INTEGER,What,The aggregated number of views for the associated content object.,,,,prod,,,false
pageContentHistory,associatedObjectUsage,INTEGER,What,The aggregated number of usage for the associated content object.,,,,prod,,,false
pageContentHistory,associatedObjectLiveSends,INTEGER,What,The aggregated number of LiveSends for the associated content object.,,,,prod,,,false
pageContentHistory,associatedObjectUsers,INTEGER,What,The aggregated  number of distinct users for the associated content object.,,,,prod,,,false
pageContentHistory,isMinFirstSeenOnPageAt,BOOLEAN,What,Boolean indicating the minimum date that the content was first viewed on any page.,,,,prod,,,false
pageContentHistory,isMaxLastSeenOnPageAt,BOOLEAN,What,Boolean indicating the most recent date that the content was viewed on any page.,,,,prod,,,false
programRequestDates,requestId,NVARCHAR(64),Primary Id,The id of the request that this date is associated with.,programRequests,id,,prod,primary,Nto1,false
programRequestDates,requestDate,DATE,Primary Id,The calendar date for this request date.,,,,prod,,,false
programRequestDates,dateType,NVARCHAR(64),Primary Id,"The descriptive name representing a given request date field for this request date record, such as actualCompletedDate or plannedStartDate.",,,,prod,,,false
programRequestDates,requestShortId,NVARCHAR(64),What,"unique id of the request, in its shortened form as provided by CMS.",,,,prod,,,false
distributionApprovalWorkflowStepsHistory,id,NVARCHAR(64),Primary Id,"The id representing the recorded instance of the workflow step as it goes through the workflow approval process, and primary id for this table.",,,,prod,,,false
distributionApprovalWorkflowStepsHistory,stepId,NVARCHAR(64),What,The id of the workflow step.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,name,NVARCHAR(MAX),What,The name of this approval workflow step.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,workflowid,NVARCHAR(64),What,The id of the associated workflow.,distributionApprovalWorkflows,id,,prod,,Nto1,false
distributionApprovalWorkflowStepsHistory,workflowName,NVARCHAR(MAX),What,The name of the workflow associated with this step.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,status,NVARCHAR(256),What,The status of the step at this point in history.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,isRevoked,BOOLEAN,What,Boolean indicating if this step has been revoked.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,startedAt,TIMESTAMP,When,Datetime of the start of the step.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,endedAt,TIMESTAMP,When,Datetime of the end of the step.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,durationSeconds,INTEGER,What,Duration in seconds of the step.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,stepOrder,INTEGER,What,The ordinal number of the step within the series of workflow steps.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,isLatest,BOOLEAN,What,Boolean indicating if this step is the current step in the workflow lifecycle.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,comment,NVARCHAR(MAX),What,The comment sent when step was reviewed by reviewer.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,reviewerUserId,NVARCHAR(64),Who,The id of the user who reviewed and ultimately approved/rejected/revoked this step.,users,id,,prod,,Nto1,false
distributionApprovalWorkflowStepsHistory,reviewerUsername,NVARCHAR(MAX),Who,The username of the user who reviewed and ultimately approved/rejected/revoked this step.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,interactionGroupId,NVARCHAR(64),What,The id of the associated engagement.,,,,prod,,,false
distributionApprovalWorkflowStepsHistory,systemModifiedAt,TIMESTAMP,modifiedAt,The datetime this record was last modified by the system and is not indicative of any explicit user edit/update.,,,,prod,,,false
userProperties,id,NVARCHAR(64),Primary Id,The primary id for items in this table.,,,,prod,,,false
userProperties,name,NVARCHAR(64),Who,The name of the user property.,,,,prod,,,false
userProperties,type,NVARCHAR(16),Who,"The type of the user property (string, integer, date, boolean, float).",,,,prod,,,false
groupManagers,groupId,NVARCHAR(64),Primary Id,The id of the group.,groups,id,,prod,,Nto1,false
groupManagers,managerId,NVARCHAR(64),Primary Id,The user id of the manager.,users,id,,prod,,Nto1,false
groupManagers,managerUserId,NVARCHAR(64),Primary Id,The user id of the manager.,users,id,,prod,,Nto1,false
groupManagers,groupName,NVARCHAR(64),What,The name of the group.,,,,prod,,,false
libraryContents,id,NVARCHAR(64),Primary Id,The unique identifier for a given content in the Seismic Library (Content Manager).,contents,id,,prod,primary,1to1,false
libraryContents,name,NVARCHAR(512),What,The name of the content in the Seismic Library (Content Manager).,,,,prod,,,false
libraryContents,version,NVARCHAR(32),What,The number of the most current version of the content such as 5.3.,,,,prod,,,false
libraryContents,latestVersion,NVARCHAR(32),What,"The number of the most current version of the content such as 5.3. This column will rename and replace the ""version"" column in this model.",,,,prod,,,false
libraryContents,createdAt,TIMESTAMP,When,The datetime that this content was created.,,,,prod,,,false
libraryContents,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
libraryContents,type,NVARCHAR(64),What,The type of this content.,,,,prod,,,false
libraryContents,format,NVARCHAR(64),What,The format of this content.,,,,prod,,,false
libraryContents,isCheckedOut,BOOLEAN,What,Boolean indicating if this content is checked out.,,,,prod,,,false
libraryContents,isDeleted,BOOLEAN,What,Boolean indicating if this content is deleted.,,,,prod,,,false
libraryContents,deletedAt,TIMESTAMP,When,The datetime that this content was deleted.,,,,prod,,,false
libraryContents,deletedByUserId,NVARCHAR(64),Who,The id of the user who deleted this content.,users,id,,prod,,Nto1,false
libraryContents,deletedByUserName,NVARCHAR(256),Who,The username of the user who deleted this content.,,,,prod,,,false
libraryContents,isPublished,BOOLEAN,What,Boolean indicating if the latest version of this content is published.,,,,prod,,,false
libraryContents,isAvailableInProfile,BOOLEAN,What,Boolean indicating if this content is published and available in a profile.,,,,prod,,,false
libraryContents,publishedVersionExpiresAt,TIMESTAMP,When,The expiration date of the latest version if published.,,,,prod,,,false
libraryContents,latestLibraryContentVersionCreatedAt,TIMESTAMP,When,The creation date for the latest version of this content. This is what most people think of when they ask 'when was this last updated'.,,,,prod,,,false
libraryContents,latestLibraryContentVersionCreatedBy,NVARCHAR(64),Who,The id of the user who created the latest version of this content.,users,id,,prod,,Nto1,false
libraryContents,latestLibraryContentVersionCreatedByUsername,NVARCHAR(256),Who,The username of the user who created the latest version of this content. This is what most people think of when they ask 'who was this last updated by'.,,,,prod,,,false
libraryContents,latestLibraryContentVersionId,NVARCHAR(64),What,The libraryContentVersionId for the latest version of this content.,libraryContentVersions,id,,prod,informational,1to1,false
libraryContents,latestLibraryContentVersionSize,INTEGER,What,The size in bytes for the latest version of this content.,,,,prod,,,false
libraryContents,latestLibraryContentVersionStatus,NVARCHAR(64),What,The status of the latest version of this content.,,,,prod,,,false
libraryContents,latestLibraryContentVersionExpiresAt,TIMESTAMP,When,The expiration date of the latest version of this content.,,,,prod,,,false
libraryContents,libraryUrl,NVARCHAR(MAX),What,The URL/link to this content in the Seismic Library (Content Manager).,,,,prod,,,false
libraryContents,docCenterUrl,NVARCHAR(MAX),What,The URL/link to this content in DocCenter. This field is nullable when the content is not published to DocCenter.,,,,prod,,,false
libraryContents,newsCenterUrl,NVARCHAR(MAX),What,The URL/link to this content in NewsCenter. This field is nullable when the content is not published to NewsCenter.,,,,prod,,,false
libraryContents,ownerId,NVARCHAR(64),Who,The id of the owner of this content.,users,id,,prod,,Nto1,false
libraryContents,ownerUsername,NVARCHAR(256),Who,The username of the owner of this content.,,,,prod,,,false
libraryContents,ownerEmail,NVARCHAR(256),What,The email address of the owner of this content.,,,,prod,,,false
libraryContents,teamsiteId,NVARCHAR(64),What,The id of the teamsite this content exists in.,teamsites,id,,prod,primary,Nto1,false
libraryContents,teamsiteName,NVARCHAR(128),What,The name of the teamsite this content exists in.,,,,prod,,,false
libraryContents,previewImageId,NVARCHAR(64),What,An id to the higher resolution preview image representing the latest version of the library content.,,,,prod,,,false
libraryContents,previewImageUrl,NVARCHAR(MAX),What,A URL to the higher resolution preview image representing the latest version of the library content.,,,,prod,,,false
libraryContents,thumbnailImageId,NVARCHAR(64),What,An id to the lower resolution thumbnail image representing the latest version of the library content.,,,,prod,,,false
libraryContents,thumbnailImageUrl,NVARCHAR(MAX),What,A URL to the lower resolution thumbnail image for this library content version.,,,,prod,,,false
libraryContents,description,NVARCHAR(MAX),What,The description of the content in the Seismic Library (Content Manager).,,,,prod,,,false
libraryContents,shortId,NVARCHAR(64),What,The short indentifier for a given content in the Seismic Library (Content Manager).,,,,prod,,,false
libraryContents,parentFolderLibraryContentId,NVARCHAR(64),What,The unique indentifier for the parent folder of the respective content in the Seismic Library (Content Manager).,,,,prod,,,false
libraryContents,libraryPath,NVARCHAR(MAX),What,The file system path from the root of the library.,,,,prod,,,false
libraryContents,hasPlannerAssociations,BOOLEAN,What,Boolean indicating if the content has Planner associations.,,,,prod,,,false
libraryContents,hasProgramAssociations,BOOLEAN,What,Boolean indicating if the content has Program associations.,,,,prod,,,false
libraryContents,associatedProgramLibraryContentId,NVARCHAR(64),What,"This is a exact copy of the primary key of this table, libraryContents.Id. This column's purpose is to control join cardinality for the ProgramAssociations table which will increase the performance of the widgets that use the ProgramAssociations table in our dashboarding environment.",contents,id,,prod,primary,1to1,false
libraryContents,originType,NVARCHAR(64),How,"The origin that the content was sourced from such as SharePoint, an RSS Feed, MS Teams, Google, etc.",,,,prod,,,false
libraryContents,lastModified,TIMESTAMP,What,The datetime the content was last modified by a user in Seismic Library (Content Manager).,,,,prod,,,false
libraryContents,contentStatus,NVARCHAR(64),What,The status of the content for tenants with Streamline Publishing enabled.,,,,prod,,,false
libraryContents,publishedVersionId,NVARCHAR(64),What,The id of the published version of the content if it has one.,libraryContentVersions,id,,prod,,1to1,false
libraryContents,publishedAt,TIMESTAMP,When,The datetime that the content was published.,,,,prod,,,false
libraryContents,publishedByUserId,NVARCHAR(64),Who,The id of the user who published the content.,users,id,,prod,,Nto1,false
libraryContents,publishedByUsername,NVARCHAR(256),Who,The username of the user who published the content.,,,,prod,,,false
libraryContents,addLibraryContentToProfileAt,TIMESTAMP,When,The datetime that the content was added to profile.,,,,prod,,,false
libraryContents,unpublishedAt,TIMESTAMP,When,The datetime the content was last unpublished.,,,,prod,,,false
teamsites,id,NVARCHAR(64),Primary Id,The primary id for items in this table.,,,,prod,,,false
teamsites,name,NVARCHAR(128),What,The name of the teamsite.,,,,prod,,,false
teamsites,isDeleted,BOOLEAN,What,Boolean indicating if this teamsite is deleted.,,,,prod,,,false
posts,id,NVARCHAR(64),Primary Id,The id of the post.,,,,prod,,,false
posts,postName,NVARCHAR(256),What,The name of the post.,,,,prod,,,false
posts,channelId,NVARCHAR(64),What,The id of the channel that the post is in.,channels,id,,prod,,Nto1,false
posts,createdAt,TIMESTAMP,When,The date and time when the post was created.,,,,prod,,,false
posts,modifiedAt,TIMESTAMP,modifiedAt,The date and time when the post modified.,,,,prod,,,false
programTaskDates,taskId,NVARCHAR(64),Primary Id,The id of the task that this date is associated with.,programTasks,id,,prod,primary,Nto1,false
programTaskDates,dateType,NVARCHAR(64),Primary Id,"The descriptive name representing a given task date field for this task date record, such as actualCompletedDate or plannedStartDate.",,,,prod,,,false
programTaskDates,taskDate,DATE,Primary Id,The calendar date for this task date.,,,,prod,,,false
programTaskDates,taskShortId,NVARCHAR(64),What (Details),"unique id of the task, in its shortened form as provided by CMS.",,,,prod,,,false
meetingQuestions,id,NVARCHAR(64),Primary Id,The meeting question id and the primary id for this table.,,,,prod,,,false
meetingQuestions,meetingId,NVARCHAR(64),Who,The associated meeting Id of the question asked.,meetings,id,,prod,,Nto1,false
meetingQuestions,question,NVARCHAR(64),What,The transcribed question asked in the meeting.,,,,prod,,,false
meetingQuestions,topic,NVARCHAR(64),What,The name of the associated topic of the question.,,,,prod,,,false
meetingQuestions,speakerId,NVARCHAR(64),Who,The third-party identifier of the speaker who asked the question during the meetings.,,,,prod,,,false
meetingQuestions,speaker,NVARCHAR(64),Who,The third-party username of the user who asked the question in the meeting.,,,,prod,,,false
meetingQuestions,startedAt,TIMESTAMP,When,The starting timestamp of when questioned was asked during the meeting.,,,,prod,,,false
meetingQuestions,endedAt,TIMESTAMP,When,The ending timestamp of when questioned was asked during the meeting.,,,,prod,,,false
meetingQuestions,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
meetingGeneralNotesUpdates,id,NVARCHAR(64),Primary Id,The id of the unique contributor and meeting general notes update combination. The primary id for this table.,,,,prod,,,false
meetingGeneralNotesUpdates,meetingId,NVARCHAR(64),What,The meeting id that the general notes belongs to.,meetings,id,,prod,,Nto1,false
meetingGeneralNotesUpdates,userId,NVARCHAR(64),Who,The Seismic user id of the Seismic user who updated the general notes of the meeting.,users,id,,prod,,Nto1,false
meetingGeneralNotesUpdates,userName,NVARCHAR(64),Who,The Seismic username of the Seismic user who updated the general notes the meeting.,,,,prod,,,false
meetingGeneralNotesUpdates,occurredAt,TIMESTAMP,When,The datetime that the general notes update took place.,,,,prod,,,false
meetingGeneralNotesUpdates,generalNotesCharacters,INTEGER,What,The character count of the plain text in the meeting general notes.,,,,prod,,,false
meetingGeneralNotesUpdates,modifiedAt,TIMESTAMP,modifiedAt,"The datetime the meeting was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
livedocDataSourceRetrieveDataRequests,id,NVARCHAR(64),Primary Id,The id and primary key of the LiveDoc DataSource retrieve data requests.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,region,NVARCHAR(512),What,The region of this request.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,requestTime,TIMESTAMP,When,The datetime of the request occurrence.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,duration,INTEGER,What,The duration in milliseconds of data source retrieve data request.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,dataSourceLibraryContentId,NVARCHAR(64),What,The id of the DataSource library content.,libraryContents,id,,prod,primary,Nto1,false
livedocDataSourceRetrieveDataRequests,dataSourceLibraryContentVersionId,NVARCHAR(64),What,The id of the DataSource library content version.,libraryContentVersions,id,,prod,,Nto1,false
livedocDataSourceRetrieveDataRequests,dataSourceLibraryContentName,NVARCHAR(512),What,The name of the DataSource library content.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,dataSourceLibraryContentType,NVARCHAR(64),What,The type of this DataSource library content.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,dataSourceLibraryContentVersion,NVARCHAR(512),What,The version number of this DataSource library content.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,responseStatus,BOOLEAN,What,Boolean indicating if this request is a success.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,isSeismicCertificate,BOOLEAN,What,Boolean indicating whether the Seismic certificate was used to retrieve the customer data.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,certificateId,NVARCHAR(64),What,The certificate id used to retrieve the customer data.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,certificateThumbprint,NVARCHAR(512),What,The certificate thumbprint used to retrieve the customer data.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,tokenIsSeismicCertificate,BOOLEAN,What,Boolean indicating whether the Seismic certificate was used to retrieve the customer data.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,tokenCertificateId,NVARCHAR(64),What,The certificate id used to retrieve the customer data.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,tokenCertificateThumbprint,NVARCHAR(512),What,The certificate thumbprint used to retrieve the customer data.,,,,prod,,,false
livedocDataSourceRetrieveDataRequests,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
livesendPageViews,id,NVARCHAR(64),Primary Id,"The primary id for items in this table. Note - If LiveSend was sent from system with ‘send separate emails’ checked, then the Page View will be unique per recipient of the email. If LiveSend was sent from system with ‘send one email to group’ then, the Page View will be not unique per recipient of the email and there will be no way to track which recipient from recipient group is associated to each viewing session.",,,,prod,,,false
livesendPageViews,duration,INTEGER,What (Details),The number of milliseconds spent viewing the page until the next event occurs.,,,,prod,,,false
livesendPageViews,livesendLinkContentId,NVARCHAR(64),What (Details),The Id of the livesendlinkcontent that contained the page on which the view occurred.,livesendLinkContents,id,,prod,primary,Nto1,false
livesendPageViews,livesendViewingSessionId,NVARCHAR(64),What (Details),The id of the livesend viewing session that this page view is a part of.,livesendViewingSessions,id,,prod,primary,Nto1,false
livesendPageViews,occurredAt,TIMESTAMP,When (Details),The datetime that the page view occurred.,,,,prod,,,false
livesendPageViews,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
livesendPageViews,pageIndex,INTEGER,What (Details),The 1-N based page number that was viewed.,,,,prod,,,false
livesendPageViews,sessionEndedAt,TIMESTAMP,When (Details),The datetime that the viewing session ended in the recipient's browser.,,,,prod,,,false
livesendPageViews,sessionStartedAt,TIMESTAMP,When (Details),The datetime that the viewing session started in the recipient's browser.,,,,prod,,,false
livesendPageViews,livesendContentViewingSessionId,NVARCHAR(64),What (Details),The id of the livesend content viewing session that this page view is a part of.,,,,prod,,,false
livesendCommentMentions,id,NVARCHAR(64),Primary Id,The id of the comment mention.,,,,prod,,,false
livesendCommentMentions,livesendCommentId,NVARCHAR(64),Where,The id of the comment associated with the mention.,livesendComments,id,,prod,informational,Nto1,false
livesendCommentMentions,mentionedUserEmail,NVARCHAR(64),Who,Email of user mentioned in comment within livesend link.,,,,prod,,,false
livesendCommentMentions,mentionedLivesendLinkContentId,NVARCHAR(64),What,The unique id of the content mentioned in the livesend link comment.,livesendLinkContents,id,,prod,informational,NtoN,false
livesendCommentMentions,mentionedLivesendLinkContentName,NVARCHAR(64),What,The name of the content mentioned in the livesend link comment.,,,,prod,,,false
livesendCommentMentions,isRemoved,BOOLEAN,What,A boolean indicating if the comment author removed the comment mention.,,,,prod,,,false
livesendCommentMentions,modifiedAt,TIMESTAMP,modifiedAt,The datetime that the comment mention was last edited.,,,,prod,,,false
livesendCommentMentions,createdAt,TIMESTAMP,When,The datetime that the comment mention was created.,,,,prod,,,false
contentViewHistory,id,NVARCHAR(64),Primary Id,The primary id for events in this table.,,,,prod,,,false
contentViewHistory,action,NVARCHAR(128),How,"The type of view action taken, currently always set to 'View' but may have additional view actions in the future.",,,,prod,,,false
contentViewHistory,application,NVARCHAR(128),Where,The application that the user was in when they performed the view.,,,,prod,,,false
contentViewHistory,contentId,NVARCHAR(64),What,The id of the content the view took place on.,contents,id,,prod,primary,Nto1,false
contentViewHistory,contentVersionId,NVARCHAR(64),What,The version id of the content the view took place on.,,,,prod,,,false
contentViewHistory,contentProfileId,NVARCHAR(64),Where,The id of the content profile this content was viewed from. This field is nullable when the viewed content originated from WorkSpace.,contentProfiles,id,,prod,primary,Nto1,false
contentViewHistory,contentProfileName,NVARCHAR(MAX),Where,The name of the content profile this content was viewed from. This field is nullable when the viewed content originated from WorkSpace.,,,,prod,,,false
contentViewHistory,contextId,NVARCHAR(64),Where,The unique Identifier of the external record that the view took place on. Typically this is a CRM record id but can contain the unique id for any external system record depending on the integration.,,,,prod,,,false
contentViewHistory,contextName,NVARCHAR(512),Where,"The Name of the external record that the view took place on. This is typically the CRM record Name of a specific Opportunity, Contact, Account, etc. but can also contain the name of a record in a custom application.",,,,prod,,,false
contentViewHistory,contextType,NVARCHAR(256),Where,"The Type of external record that the view took place on. This is typically a CRM record Type such as Opportunity, Contact, Account, etc. but can also contain the record Type of a custom application.",,,,prod,,,false
contentViewHistory,contextSystemType,NVARCHAR(256),Where,The System of the record that the view took place in. This typically contains the name of a CRM system but can contain the name of any external system depending on the integration.,,,,prod,,,false
contentViewHistory,instanceName,NVARCHAR(512),What,"The name given to the content before it was delivered. Typically this is the name as appears in the Library, except in cases of generated Livedocs, WorkSpace content, or Library content added to WorkSpace that has been altered.",,,,prod,,,false
contentViewHistory,libraryContentId,NVARCHAR(64),What,The Library content id of the content. This id will populate when the content originated from the Seismic Library.,libraryContents,id,,prod,informational,Nto1,false
contentViewHistory,libraryContentVersionId,NVARCHAR(64),What,The Library content version id of the content. This id will populate when the content originated from the Seismic Library.,libraryContentVersions,id,,prod,informational,Nto1,false
contentViewHistory,occurredAt,TIMESTAMP,When,The datetime when the view occurred.,,,,prod,,,false
contentViewHistory,productArea,NVARCHAR(128),Where,The part of the Seismic platform the user was in when they performed the view.,,,,prod,,,false
contentViewHistory,userId,NVARCHAR(64),Who,The id of the user who performed the view.,users,id,,prod,,Nto1,false
contentViewHistory,userUsername,NVARCHAR(256),Who,The username of the user who performed the view.,,,,prod,,,false
contentViewHistory,workspaceContentId,NVARCHAR(64),What,The WorkSpace content id of the viewed content.,workspaceContents,id,,prod,informational,Nto1,false
contentViewHistory,workspaceContentVersionId,NVARCHAR(64),What,The workspace content version id of the content that was viewed.,workspaceContentVersions,id,,prod,informational,Nto1,false
contentViewHistory,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
programs,id,NVARCHAR(64),Primary Id,The id of the program and primary id for this table.,,,,prod,,,false
programs,title,NVARCHAR(MAX),What,The name given to the program.,,,,prod,,,false
programs,description,NVARCHAR(MAX),What,The description of the program.,,,,prod,,,false
programs,createdAt,TIMESTAMP,When,The datetime that the program was created.,,,,prod,,,false
programs,createdBy,NVARCHAR(64),Who,Id of the user who created the program.,users,id,,prod,,Nto1,false
programs,createdByUsername,NVARCHAR(256),Who,Username of the user who created the program.,,,,prod,,,false
programs,systemModifiedAt,TIMESTAMP,modifiedAt,The datetime this record was last modified by the system and is not indicative of an explicit user edit/update to the program.,,,,prod,,,false
programs,userModifiedAt,TIMESTAMP,modifiedAt,The datetime that the program was last updated/modified by a user.,,,,prod,,,false
programs,modifiedBy,NVARCHAR(64),Who,Id of the user who last updated/modified the program.,users,id,,prod,,Nto1,false
programs,modifiedByUsername,NVARCHAR(256),Who,Username of the user who last updated/modified the program.,,,,prod,,,false
programs,programManagerId,NVARCHAR(64),Who,Id of the user responsible for this program.,users,id,,prod,,Nto1,false
programs,programManagerUsername,NVARCHAR(256),Who,Username of the user responsible for this program.,,,,prod,,,false
programs,plannedStartDate,TIMESTAMP,When,The datetime that the program was scheduled to start.,,,,prod,,,false
programs,plannedEndDate,TIMESTAMP,When,The datetime that the program was scheduled to be completed.,,,,prod,,,false
programs,plannedDurationDays,INTEGER,What,"The system-calculated length of time the program is scheduled to take. Duration is based on days between, and including, the planned start date and planned end date.",,,,prod,,,false
programs,actualStartDate,TIMESTAMP,When,The system-set datetime when work on the program started. This date is triggered by the program moving into an appropriate status.,,,,prod,,,false
programs,actualEndDate,TIMESTAMP,When,The system-set datetime when work on the program ended. This date is triggered by the program moving into the appropriate status of completed.,,,,prod,,,false
programs,actualDurationDays,INTEGER,What,"The system-calculated length of time the program actually took to complete. Duration is based on days between, and including, the actual start date and actual end date.",,,,prod,,,false
programs,isOverdue,BOOLEAN,What,Boolean indicating if program is passed the planned end date.,,,,prod,,,false
programs,templateId,NVARCHAR(64),What,"Id of the template from which this program was created, if this program leveraged a template.",programs,id,,prod,,Nto1,false
programs,copyFromId,NVARCHAR(64),What,Id of the original program if the program was created via a copy.,programs,id,,prod,,Nto1,false
programs,creationMethod,NVARCHAR(8),What,Indicates how the program was created.,,,,prod,,,false
programs,isDeleted,BOOLEAN,What,A boolean indicating if the program is currently considered deleted.,,,,prod,,,false
programs,deletedAt,TIMESTAMP,When,The datetime on which the program was deleted.,,,,prod,,,false
programs,shortId,NVARCHAR(64),What,"unique id of the program, in its shortened form as provided by CMS.",,,,prod,,,false
programs,programAudience,NVARCHAR(MAX),What,The list of audience users or groups that this program is associated with.,,,,prod,,,true
programs,programArchived,BOOLEAN,What,Boolean indicating if this program is archived (true) or enabled (false).,,,,prod,,,false
programs,programLaunchDate,TIMESTAMP,When,The datetime of when this program launches.,,,,prod,,,false
programs,programOnboardingGroup,NVARCHAR(64),What,The Onboarding Group for this program.,,,,prod,,,false
programs,programOutcomeKpiFirst,NVARCHAR(64),What,The first Outcome Kpi metric for this program.,,,,prod,,,false
programs,programOutcomeKpiSecond,NVARCHAR(64),What,The second Outcome Kpi metric for this program.,,,,prod,,,false
programs,programOutcomeKpiThird,NVARCHAR(64),What,The third Outcome Kpi metric for this program.,,,,prod,,,false
programs,programType,NVARCHAR(64),What,The type of this program.,,,,prod,,,false
programs,programTopics,NVARCHAR(MAX),What,The user-set list of topics for this program.,,,,prod,,,true
programs,programTrackers,NVARCHAR(MAX),What,"The list of trackers for this program, set by the system based on the value of programTopics.",,,,prod,,,true
workspaceContents,id,NVARCHAR(64),Primary Id,The id of the WorkSpace content and the primary id for items in this table.,contents,id,,prod,primary,1to1,false
workspaceContents,createdAt,TIMESTAMP,When,The datetime that the content was created in WorkSpace.,,,,prod,,,false
workspaceContents,createdBy,NVARCHAR(64),What,The user id of the user who created this content in WorkSpace.,users,id,,prod,primary,Nto1,false
workspaceContents,isCartContent,BOOLEAN,What,A boolean indicating if this is content in a user's content cart.,,,,prod,,,false
workspaceContents,isContextualFolderContent,BOOLEAN,What,A boolean indicating if this content belongs to a contextual WorkSpace folder.,,,,prod,,,false
workspaceContents,isDeleted,BOOLEAN,What,A boolean indicating if this content has been deleted from WorkSpace.,,,,prod,,,false
workspaceContents,latestWorkspaceContentVersionCreatedAt,TIMESTAMP,When,The datetime that the highest version was created.,,,,prod,,,false
workspaceContents,latestWorkspaceContentVersionId,NVARCHAR(64),What,The WorkSpace version id of the highest version.,workspaceContentVersions,id,,prod,informational,1to1,false
workspaceContents,latestWorkspaceContentVersionSize,INTEGER,What,The size in bytes for the latest version of this content.,,,,prod,,,false
workspaceContents,originContentProfileId,NVARCHAR(64),Where,The id of the content profile that WorkSpace content originated from. This field will be populated when the WorkSpace content originally came from DocCenter and is considered to have a source of Library.,contentProfiles,id,,prod,,,false
workspaceContents,libraryContentId,NVARCHAR(64),What,The library content id that WorkSpace content originated from. This field is nullable when the content was directly uploaded to WorkSpace and did not originate from DocCenter or the Seismic Library.,libraryContents,id,,prod,informational,Nto1,false
workspaceContents,materializedPath,NVARCHAR(4000),Where,The full path of workspaceContentIds representing the parent folder path to this WorkSpace content.,,,,prod,,,false
workspaceContents,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
workspaceContents,name,NVARCHAR(512),What,The name of the content.,,,,prod,,,false
workspaceContents,previewImageId,NVARCHAR(64),What,An id to the higher resolution preview image representing the latest version of the WorkSpace content.,,,,prod,,,false
workspaceContents,previewImageUrl,NVARCHAR(MAX),What,A URL to the higher resolution preview image representing the latest version of the WorkSpace content.,,,,prod,,,false
workspaceContents,thumbnailImageId,NVARCHAR(64),What,An id to the lower resolution thumbnail image representing the latest version of the WorkSpace content.,,,,prod,,,false
workspaceContents,thumbnailImageUrl,NVARCHAR(MAX),What,A URL to the lower resolution thumbnail image representing the latest version of the WorkSpace content.,,,,prod,,,false
workspaceContents,version,INTEGER,What,The current version number of the content.,,,,prod,,,false
workspaceContents,contextId,NVARCHAR(64),What,"The unique identifier of the CRM record associated with the contextual WorkSpace folder the content is located in. Note, this will reflect the unique ID of any external context where applicable, but CRM is most common.",,,,prod,,,false
workspaceContents,contextName,NVARCHAR(512),What,"The name of the contextual WorkSpace folder, which reflects the name of the specific Opportunity, Contact, Account, etc. Note, this will reflect the name of any external context where applicable, but CRM is most common.",,,,prod,,,false
workspaceContents,contextType,NVARCHAR(256),What,"The type of CRM object the contextual WorkSpace folder is associated with, typically objects like Opportunity, Contact, Account, etc. Note, this will reflect the type of any external context where applicable, but CRM is most common.",,,,prod,,,false
workspaceContents,contextSystemType,NVARCHAR(64),What,"The CRM system the contextual WorkSpace folder is associated with. Note, this will reflect the system of any external context where applicable, but CRM is most common.",,,,prod,,,false
workspaceContents,originApplication,NVARCHAR(64),What,The source application of the WorkSpace content.,,,,prod,,,false
pageClicks,id,NVARCHAR(64),Primary Id,Unique Id for each row.,,,,prod,,,false
pageClicks,userId,NVARCHAR(64),Who,The Id of the user who performed the activity.,users,id,,prod,primary,Nto1,false
pageClicks,username,NVARCHAR(256),Who,The user's username.,,,,prod,,,false
pageClicks,occurredAt,TIMESTAMP,When,The datetime when the activity occurred.,,,,prod,,,false
pageClicks,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
pageClicks,productArea,NVARCHAR(128),Where,The area of the product where the activity occurred.,,,,prod,,,false
pageClicks,application,NVARCHAR(128),Where,"The application (Web, iOS, Android, Outlook, Gmail Salesforce, Dynamics, etc.) the activity took place on.",,,,prod,,,false
pageClicks,actionType,NVARCHAR(128),How,The type of action whose value can be either 'Built-In' (for standard Seismic actions and delivery options) or 'Custom' (custom developed actions or delivery options).,,,,prod,,,false
pageClicks,action,NVARCHAR(128),How,The specific activity done by a user and the most granular row descriptor in this model.,,,,prod,,,false
pageClicks,pageType,NVARCHAR(64),What,Specifies the source of the click.,,,,prod,,,false
pageClicks,pageContentId,NVARCHAR(64),What,The library content Id of the page.,libraryContents,id,,prod,informational,Nto1,false
pageClicks,pageContentVersionId,NVARCHAR(64),What,The library content version Id of the page.,libraryContentVersions,id,,prod,informational,Nto1,false
pageClicks,clickType,NVARCHAR(64),What,The target of the user action.,,,,prod,,,false
pageClicks,targetContentId,NVARCHAR(64),What,The Id of the clicked content.,libraryContents,id,,prod,informational,Nto1,false
pageClicks,targetContentVersionId,NVARCHAR(64),What,The library content version Id of the clicked content.,libraryContentVersions,id,,prod,informational,Nto1,false
pageClicks,targetUrl,NVARCHAR(MAX),What,Clicked content URL.,,,,prod,,,false
pageClicks,isSuccessfulClick,BOOLEAN,What,"A boolean field that answers if the user clicked on a link. If the value is false, it means the link is dead.",,,,prod,,,false
pageClicks,widgetId,NVARCHAR(64),What,The Id of the widget that was clicked.,,,,prod,,,false
pageClicks,widgetTitle,NVARCHAR(MAX),What,The title of the widget that was clicked.,,,,prod,,,false
pageClicks,widgetType,NVARCHAR(MAX),What,The type of widget that was clicked.,,,,prod,,,false
pageClicks,widgetSubType,NVARCHAR(MAX),What,The subtype of widget that was clicked.,,,,prod,,,false
pageClicks,widgetRowIndex,INTEGER,What,The vertical position of a widget on the page.,,,,prod,,,false
pageClicks,widgetColumnIndex,INTEGER,What,The horizontal position of a widget on the page.,,,,prod,,,false
pageClicks,widgetCount,INTEGER,What,Tells how many widgets are on the page.,,,,prod,,,false
contentProfiles,id,NVARCHAR(64),Primary Id,The id of the profile.,,,,prod,,,false
contentProfiles,versionId,NVARCHAR(64),What,The version id of the profile.,,,,prod,,,false
contentProfiles,isPredictiveOnly,BOOLEAN,What,A boolean indicating if the profile is for predictive content use only.,,,,prod,,,false
contentProfiles,isPublished,BOOLEAN,What,A boolean indicating if the profile is published.,,,,prod,,,false
contentProfiles,modifiedAt,TIMESTAMP,When,The datetime that the profile was last modified.,,,,prod,,,false
contentProfiles,name,NVARCHAR(256),What,The name of the profile.,,,,prod,,,false
contentProfiles,teamsiteId,NVARCHAR(64),Where,The id of the teamsite the profile belongs to.,teamsites,id,,prod,,Nto1,false
contentProfiles,type,NVARCHAR(32),What,The type of profile. Profiles can be ChannelProfile (for NewsCenter) or ContentProfile (for DocCenter).,,,,prod,,,false
contentProfiles,isDeleted,BOOLEAN,What,Boolean indicating if this profile is deleted.,,,,prod,,,false
contentProfiles,isStagingProfile,BOOLEAN,What,Boolean indicating if this profile is a staging profile for test purposes.,,,,prod,,,false
programTasks,id,NVARCHAR(64),Primary Id,The id of the task and primary id for this table.,,,,prod,,,false
programTasks,title,NVARCHAR(MAX),What,The name given to the task.,,,,prod,,,false
programTasks,description,NVARCHAR(MAX),What,The description of the task.,,,,prod,,,false
programTasks,status,NVARCHAR(MAX),What,The descriptive name of the task’s current status.,,,,prod,,,false
programTasks,priority,NVARCHAR(MAX),What,Level of importance for a given task within a program.,,,,prod,,,false
programTasks,rank,NVARCHAR(MAX),What,Rank defines the ordinal numbered order in which the task falls within the program's task series.,,,,prod,,,false
programTasks,createdAt,TIMESTAMP,When,The datetime that the task was created.,,,,prod,,,false
programTasks,createdBy,NVARCHAR(64),Who,Id of the user who created the task.,users,id,,prod,,Nto1,false
programTasks,createdByUsername,NVARCHAR(256),Who,Username of the user who created the task.,,,,prod,,,false
programTasks,systemModifiedAt,TIMESTAMP,modifiedAt,The datetime this record was last modified by the system and is not indicative of an explicit user edit/update to the task.,,,,prod,,,false
programTasks,userModifiedAt,TIMESTAMP,modifiedAt,The datetime that the task was last updated/modified by a user.,,,,prod,,,false
programTasks,modifiedBy,NVARCHAR(64),Who,Id of the user who last updated/modified the task.,users,id,,prod,,Nto1,false
programTasks,modifiedByUsername,NVARCHAR(256),Who,Username of the user who last updated/modified the task.,,,,prod,,,false
programTasks,requestorId,NVARCHAR(64),Who,Id of the user who requested the task.,users,id,,prod,,Nto1,false
programTasks,requestorUsername,NVARCHAR(256),Who,Username of the user who requested the task.,,,,prod,,,false
programTasks,assigneeId,NVARCHAR(64),Who,Id of the user who is assigned to the task.,users,id,,prod,,Nto1,false
programTasks,assigneeUsername,NVARCHAR(256),Who,Username of the user who is assigned to the task.,,,,prod,,,false
programTasks,plannedStartDate,TIMESTAMP,When,The datetime that the task was scheduled to start.,,,,prod,,,false
programTasks,plannedDueDate,TIMESTAMP,When,The datetime that the task was scheduled to be completed.,,,,prod,,,false
programTasks,plannedDurationDays,INTEGER,What,"The system-calculated length of time the task is scheduled to take. Duration is based on days between, and including, the planned start date and planned due date.",,,,prod,,,false
programTasks,actualStartDate,TIMESTAMP,When,The system-set datetime when work on the task started. This date is triggered by the task moving into an appropriate status.,,,,prod,,,false
programTasks,actualCompletedDate,TIMESTAMP,When,The system-set datetime when work on the task ended. This date is triggered by the task moving into the appropriate status of completed.,,,,prod,,,false
programTasks,actualDurationDays,INTEGER,What,"The system-calculated length of time the task actually took to complete. Duration is based on days between, and including, the actual start date and actual completed date.",,,,prod,,,false
programTasks,isOverdue,BOOLEAN,What,Boolean indicating if task is passed the planned due date.,,,,prod,,,false
programTasks,isFromProgramTemplate,BOOLEAN,What,"Boolean indicating that the task and its details came from a program template which contained stored task values for fields such as title, description, rank, etc. If the task came from a program template the stored values can be overwritten/edited.",,,,prod,,,false
programTasks,copyFromId,NVARCHAR(64),What,Id of the original task if the task was created via a copy.,programTasks,id,,prod,,Nto1,false
programTasks,programId,NVARCHAR(64),What,Id of the program which this task belongs to.,programs,id,,prod,,Nto1,false
programTasks,isDeleted,BOOLEAN,What,A boolean indicating if the task is currently considered deleted.,,,,prod,,,false
programTasks,deletedAt,TIMESTAMP,When,The datetime on which the task was deleted.,,,,prod,,,false
programTasks,shortId,NVARCHAR(64),Primary Id,"unique id of the task, in its shortened form as provided by CMS.",,,,prod,,,false
livesendLinkMeetingContents,id,NVARCHAR(64),Primary Id,The primary id for items in this table and is the id of the livesendlinkMeetingContent.,,,,prod,,,false
livesendLinkMeetingContents,name,NVARCHAR(256),What,The name of the meeting clip or recording in the livesend link.,,,,prod,,,false
livesendLinkMeetingContents,meetingClipId,NVARCHAR(64),What,The id of the meeting clip.,,,,prod,,,false
livesendLinkMeetingContents,meetingRecordingId,NVARCHAR(64),What,The id of the meeting recording.,,,,prod,,,false
livesendLinkMeetingContents,meetingId,NVARCHAR(64),What,The id of the meeting where the clip or recording came from.,,,,prod,,,false
livesendLinkMeetingContents,type,NVARCHAR(64),What,"The type of content, such as meeting clip or recording.",,,,prod,,,false
livesendLinkMeetingContents,livesendLinkId,NVARCHAR(64),What,The id of the livesend link that this meeting clip or recording is included in.,livesendLinks,id,,prod,primary,Nto1,false
livesendLinkMeetingContents,createdBy,NVARCHAR(64),What,The user id of the user who created the livesend link.,users,id,,prod,informational,Nto1,false
livesendLinkMeetingContents,createdAt,TIMESTAMP,When,The datetime that the meeting clip or recording was added to the livesend link.,,,,prod,,,false
livesendLinkMeetingContents,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
livesendLinkMeetingContents,isDeleted,BOOLEAN,What,Boolean indicating if this record was deleted.,,,,prod,,,false
livesendLinkMeetingContents,deletedAt,TIMESTAMP,When,The datetime this record was deleted.,,,,prod,,,false
livesendLinkMeetingContents,interactionGroupId,NVARCHAR(64),Where,"Represents the ""container"" around a group livesends. Such containers can be email blasts, digital sales rooms, etc.",,,,prod,,,false
livesendLinkMeetingContents,wasViewed,BOOLEAN,What,Boolean indicating if this link meeting content record was viewed.,,,,prod,,,false
livesendLinkMeetingContents,numberOfSessions,INTEGER,What,The total number of viewing sessions over this meeting content.,,,,prod,,,false
meetingContentPagePresentations,id,NVARCHAR(64),Primary Id,The meeting content page presentation id and the primary id for this table.,,,,prod,,,false
meetingContentPagePresentations,meetingContentPresentationId,NVARCHAR(64),When,The associated meeting content presentation id which this page presentation was a part of.,meetingContentPresentations,id,,prod,,Nto1,false
meetingContentPagePresentations,startedAt,TIMESTAMP,When,The datetime that the content page presentation started.,,,,prod,,,false
meetingContentPagePresentations,endedAt,TIMESTAMP,When,The datetime that the content page presentation ended.,,,,prod,,,false
meetingContentPagePresentations,durationSeconds,INTEGER,What,The length of the content presentation from start to end in seconds.,,,,prod,,,false
meetingContentPagePresentations,barcode,NVARCHAR(64),What,The captured barcode of the page presented.,,,,prod,,,false
meetingContentPagePresentations,pageIndex,INTEGER,What,The index of the page with the content at the time the page presentation took place.,,,,prod,,,false
meetingContentPagePresentations,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
libraryContentExpertAssociations,id,NVARCHAR(64),Primary Id,The id of the library content to expert relationship.,,,,prod,,,false
libraryContentExpertAssociations,libraryContentId,NVARCHAR(64),What,The Id of the library content with an expert.,libraryContents,id,,prod,,Nto1,false
libraryContentExpertAssociations,contentExpertId,NVARCHAR(64),Who,The Id of the user designated as an expert for the library content.,users,id,,prod,,Nto1,false
libraryContentExpertAssociations,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
livesendComments,id,NVARCHAR(64),Primary Id,The ID of the comment,,,,prod,,,false
livesendComments,livesendViewingSessionId,NVARCHAR(64),What,The id of the viewing session,livesendViewingSessions,id,,prod,informational,Nto1,false
livesendComments,livesendLinkId,NVARCHAR(64),What,The id of the livesend link,livesendLinks,id,,prod,informational,Nto1,false
livesendComments,engagementUserEmail,NVARCHAR(64),Who,The email of the commenter,,,,prod,,,false
livesendComments,engagementUserName,NVARCHAR(64),Who,The username of the commenter,,,,prod,,,false
livesendComments,isInternalUser,BOOLEAN,Who,Whether the commenter is in the user table or not,,,,prod,,,false
livesendComments,isHidden,BOOLEAN,What,A boolean indicating if the comment is hidden from view,,,,prod,,,false
livesendComments,isRemoved,BOOLEAN,What,A boolean indicating if the comment has been deleted,,,,prod,,,false
livesendComments,hasMentions,BOOLEAN,What,A boolean indicating if the comment has mentions (user or content),,,,prod,,,false
livesendComments,hasReactions,BOOLEAN,What,A boolean indicating if the comment has reactions,,,,prod,,,false
livesendComments,modifiedAt,TIMESTAMP,modifiedAt,The datetime that the comment was last edited,,,,prod,,,false
livesendComments,createdAt,TIMESTAMP,When,The datetime that the comment was originally created,,,,prod,,,false
notificationFrequencySettings,id,NVARCHAR(64),Primary Id,The primary id for items in this table.,,,,prod,,,false
notificationFrequencySettings,userId,NVARCHAR(64),Who,The id of the user who has the setting.,users,id,,prod,,Nto1,false
notificationFrequencySettings,userFullName,NVARCHAR(128),Who,The name of the user who has the setting.,,,,prod,,,false
notificationFrequencySettings,type,NVARCHAR(64),What,"The type of notification setting, tenant or user.",,,,prod,,,false
notificationFrequencySettings,productArea,NVARCHAR(64),What,The area of the product that triggers this notification.,,,,prod,,,false
notificationFrequencySettings,activityTrigger,NVARCHAR(64),What,The activity which triggered the notification.,,,,prod,,,false
notificationFrequencySettings,channel,NVARCHAR(64),What,The channel through which the notification was delivered.,,,,prod,,,false
notificationFrequencySettings,frequency,NVARCHAR(64),What,The frequency that the user would like to receive the notifications for the activity.,,,,prod,,,false
notificationFrequencySettings,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
meetingKeywords,id,NVARCHAR(64),Primary Id,"The id of the unique meeting, speaker, topic, and keyword combination. The primary key for this model.",,,,prod,,,false
meetingKeywords,meetingId,NVARCHAR(64),Who,The associated meeting id of the where the keyword was mentioned in.,meetings,id,,prod,,Nto1,false
meetingKeywords,meetingParticipantDisplayName,NVARCHAR(64),Who,Display name of the speaker in the video conferencing platform who spoke the keywords tracked in recorded meetings.,,,,prod,,,false
meetingKeywords,meetingParticipantDisplayIdentification,NVARCHAR(64),Who,The speaker identification to identify unique speakers in the case when the conference service does not provide a speaker display name.,,,,prod,,,false
meetingKeywords,keyword,NVARCHAR(64),What,A single word and/or a phrase spoken in recorded meetings.,,,,prod,,,false
meetingKeywords,topic,NVARCHAR(64),What,Topics are collections of keywords users set to track and analyze from their recorded meetings. Users can select or add custom topics. This step is configured by customer admins under System settings > Application settings >  Common settings > User-Generated topics.,,,,prod,,,false
meetingKeywords,startedAt,TIMESTAMP,When,The datetime that the keyword word and/or a phrase started.,,,,prod,,,false
meetingKeywords,endedAt,TIMESTAMP,When,The datetime that the keyword word and/or a phrase ended.,,,,prod,,,false
meetingKeywords,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
contents,id,NVARCHAR(64),Primary Id,The id of the content which can globally identify content from Library or WorkSpace.,,,,prod,,,false
contents,instanceName,NVARCHAR(512),What,"The name of the content as it appeared when delivered.  Typically this is the name as appears in the Library, except in cases of generated Livedocs, WorkSpace content, or Library content added to WorkSpace that has been altered.",,,,prod,,,false
contents,libraryContentId,NVARCHAR(64),What,The Library content id of the content. This id will populate when the content originated from the Seismic Library.,libraryContents,id,,prod,informational,1to1,false
contents,normalizedName,NVARCHAR(512),What,The normalized source content name.  This will be the Library content name for all content that comes from the Library and the WorkSpace name for content directly uploaded to WorkSpace.,,,,prod,,,false
contents,originRepository,NVARCHAR(9),What,The source repository of the content. This will be 'Library' for content from the Seismic Library or 'WorkSpace' for content uploaded directly to WorkSpace.,,,,prod,,,false
contents,repository,NVARCHAR(9),What,The repository where content is located when activity occurs.,,,,prod,,,false
contents,workspaceContentId,NVARCHAR(64),What,The WorkSpace content id.,workspaceContents,id,,prod,informational,1to1,false
contents,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
contents,createdAt,TIMESTAMP,When,The timestamp when the record was created.,,,,prod,,,false
contents,originApplication,NVARCHAR(64),What,The source application of the content.,,,,prod,,,false
contents,format,NVARCHAR(64),What,"The format of this content. For contents originating from WorkSpace, this is the format of the latest version of that WorkSapce content.",,,,prod,,,false
contents,isDeleted,BOOLEAN,What,Boolean indicating if the content has been deleted.,,,,prod,,,false
meetingTrackers,id,NVARCHAR(64),Primary Id,The id of the meeting and tracker/topic instance.,,,,prod,,,false
meetingTrackers,meetingId,NVARCHAR(64),Who,The associated meeting Id of the tracker/topic details.,meetings,id,,prod,,Nto1,false
meetingTrackers,tracker,NVARCHAR(64),What,The tracker mentioned in the meeting.,,,,prod,,,false
meetingTrackers,topic,NVARCHAR(64),What,The name of the associated topic of the tracker.,,,,prod,,,false
meetingTrackers,aggMentions,INTEGER,What,The aggregate count of topic/tracker combination mentions in the duration of the particular meeting.,,,,prod,,,false
meetingTrackers,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
emailTemplateInstances,id,NVARCHAR(64),Primary Id,The primary id for items in this table.,,,,prod,,,false
emailTemplateInstances,emailId,NVARCHAR(64),How,The id of the email that is an instance of the respective email template.,emails,id,,prod,,Nto1,false
emailTemplateInstances,emailTemplateId,NVARCHAR(64),What,The id of the seller template when saved in the Email Blast product area and used in an email blast.,,,,prod,,,false
emailTemplateInstances,emailTemplateLibraryContentId,NVARCHAR(64),What,The LibraryContents Id of the marketer email template used in an email blast.,libraryContents,id,,prod,,Nto1,false
emailTemplateInstances,emailTemplateLibraryContentVersionId,NVARCHAR(64),What,The LibraryContentVersions Id of the email template used in this email.,libraryContentVersions,id,,prod,,Nto1,false
emailTemplateInstances,position,INTEGER,What,The 1-thru-N position of this email template in the email.,,,,prod,,,false
emailTemplateInstances,modifiedAt,TIMESTAMP,modifiedAt,The system datetime that the email template was last updated for any reason.,,,,prod,,,false
emailTemplateInstances,isReadOnly,BOOLEAN,What,Boolean indicating if the email template instance could be modified or if it was read only.,,,,prod,,,false
emailTemplateInstances,createdAt,TIMESTAMP,When,The timestamp when the record was created.,,,,prod,,,false
emailTemplateInstances,name,NVARCHAR(512),What,The name of the email template.,,,,prod,,,false
emailTemplateInstances,emailTemplateContentProfileId,NVARCHAR(64),Where,The id of the content profile that the email template is assigned to.,contentProfiles,id,,prod,primary,Nto1,false
emailTemplateInstances,isSenderCreated,BOOLEAN,What,Boolean indicating if the template associated with the email was created by the Sender. A sender template is created when the sender saves their own template. The template can be used for the current engagement or user has the option to select one of their own previously saved personal email templates.,,,,prod,,,false
emailTemplateInstances,isClickedDelivery,BOOLEAN,What,Boolean indicating if the delivery of the email sent from this email tempalte instance was clicked. Clicked is defined by any Engagement actions in User Activity.,,,,prod,,,false
externalUsers,id,NVARCHAR(64),Primary Id,The primary id this table and is the id of the external user.,,,,prod,,,false
externalUsers,email,NVARCHAR(256),Who,The email address of the external user.,,,,prod,,,false
externalUsers,emailDomain,NVARCHAR(256),Who,The email domain of the external user.,,,,prod,,,false
externalUsers,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
aiGeneratedTextUserFeedback,feedbackId,NVARCHAR(64),Primary Id,The id given to a feedback response.,,,,prod,,,false
aiGeneratedTextUserFeedback,aiGeneratedTextId,NVARCHAR(64),What,The id of the generated content that the feedback applies to.,aiGeneratedText,id,,prod,,Nto1,false
aiGeneratedTextUserFeedback,userId,NVARCHAR(64),Who,The Seismic user id of the user who gave the feedback.,users,id,,prod,,Nto1,false
aiGeneratedTextUserFeedback,userName,NVARCHAR(256),Who,The username of the user who gave the feedback.,,,,prod,,,false
aiGeneratedTextUserFeedback,email,NVARCHAR(256),Who,The email of the user who gave the feedback.,,,,prod,,,false
aiGeneratedTextUserFeedback,submittedAt,TIMESTAMP,When,The date and time when the feedback was provided.,,,,prod,,,false
aiGeneratedTextUserFeedback,score,FLOAT,What,"The score given by the user. This is a decimal number between 0.0 and 1.0. If score type is binary, this field will be 0 or 1. If the score type is gradient5, this field will be 0, .25, .5, .75 or 1. If the score type is gradient0, this field will be  0, 0.11, 0.22, .. 1. For thumbs up, a 1 is recored. For thumbs up, a 0 is recorded.",,,,prod,,,false
aiGeneratedTextUserFeedback,scoreType,NVARCHAR(256),What,"The Type of feedback mechanism presented to the user. Can be either binary - Indicates the user had a binary option (usually thumbs up/down), gradient5 - Indicates the user had a range of 5 gradient options (usually 1-5), or gradient10 - Indicates the user had a range of 10 gradient options (usually 1-10).",,,,prod,,,false
aiGeneratedTextUserFeedback,feedback,NVARCHAR(MAX),What,Human feedback on generated content fragment.,,,,prod,,,false
libraryContentVersions,id,NVARCHAR(64),Primary Id,The primary id for items in this table and is the id of the version of the Library content.,,,,prod,,,false
libraryContentVersions,createdAt,TIMESTAMP,When,The datetime that this version was created.,,,,prod,,,false
libraryContentVersions,createdBy,NVARCHAR(64),Who,The user id of the user who created this version.,users,id,,prod,,Nto1,false
libraryContentVersions,createdByUsername,NVARCHAR(256),Who,The username of the user who created this version.,,,,prod,,,false
libraryContentVersions,expiresAt,TIMESTAMP,When,The datetime that this version expires.,,,,prod,,,false
libraryContentVersions,isDeleted,BOOLEAN,What,A boolean indicating if this version or the respective content is deleted.,,,,prod,,,false
libraryContentVersions,deletedAt,TIMESTAMP,When,The datetime that this content version was deleted.,,,,prod,,,false
libraryContentVersions,deletedByUserId,NVARCHAR(64),Who,The id of the user who deleted this content version.,users,id,,prod,,Nto1,false
libraryContentVersions,deletedByUserName,NVARCHAR(256),Who,The username of the user who deleted this content version.,,,,prod,,,false
libraryContentVersions,isPublished,BOOLEAN,What,Boolean indicating if this version of the content published.,,,,prod,,,false
libraryContentVersions,isAvailableInProfile,BOOLEAN,What,Boolean indicating if this content version is published and available in a profile.,,,,prod,,,false
libraryContentVersions,libraryContentId,NVARCHAR(64),What,The id of the library content this is a version of.,libraryContents,id,,prod,primary,Nto1,false
libraryContentVersions,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
libraryContentVersions,name,NVARCHAR(512),What,The name of the library content.,,,,prod,,,false
libraryContentVersions,previewImageId,NVARCHAR(64),What,An id to the higher resolution preview image for this library content version.,,,,prod,,,false
libraryContentVersions,previewImageUrl,NVARCHAR(MAX),What,The URL to the higher resolution preview image for this library content version.,,,,prod,,,false
libraryContentVersions,thumbnailImageId,NVARCHAR(64),What,An id to the lower resolution thumbnail image for this library content version.,,,,prod,,,false
libraryContentVersions,thumbnailImageUrl,NVARCHAR(MAX),What,A URL to the lower resolution thumbnail image for this library content version.,,,,prod,,,false
libraryContentVersions,size,INTEGER,What,The size in bytes of this version of the content.,,,,prod,,,false
libraryContentVersions,version,NVARCHAR(512),What,The version number of this version such as 4.0.,,,,prod,,,false
libraryContentVersions,versionStatus,NVARCHAR(64),What,The publication status of the library content version for tenants with Streamline Publishing enabled.,,,,prod,,,false
libraryContentVersions,teamsiteId,NVARCHAR(64),Where,The id of the teamsite this version of the library content exists in.,teamsites,id,,prod,primary,Nto1,false
libraryContentVersions,uploadedAt,TIMESTAMP,When,The datetime that this version was uploaded.,,,,prod,,,false
libraryContentVersions,publishedAt,TIMESTAMP,When,The datetime that this version was published.,,,,prod,,,false
libraryContentVersions,publishedByUserId,NVARCHAR(64),Who,The user id of the user who published this version.,users,id,,prod,,Nto1,false
libraryContentVersions,unpublishedAt,TIMESTAMP,When,The datetime that this version was unpublished.,,,,prod,,,false
userActivity,id,NVARCHAR(64),Primary Id,The id of the activity and primary id for events in this table.,,,,prod,,,false
userActivity,action,NVARCHAR(128),How,The specific activity done by a user and the most granular row descriptor in this model.,,,,prod,,,false
userActivity,actionCategory,NVARCHAR(128),How,"The category of the activity that can be used to aggregate different types of actions. Categories include Content Discussion, Engagement, Livedoc Generated, Search, Usage, View, and Training.",,,,prod,,,false
userActivity,actionType,NVARCHAR(128),How,The type of action whose value can be either 'Built-In' (for standard Seismic actions and delivery options) or 'Custom' (custom developed actions or delivery options).,,,,prod,,,false
userActivity,application,NVARCHAR(128),Where,"The application (Web, iOS, Android, Outlook, Gmail Salesforce, Dynamics, etc.) the activity took place on.",,,,prod,,,false
userActivity,contentId,NVARCHAR(64),What,The id of the content associated with the activity.,contents,id,,prod,,Nto1,false
userActivity,contentVersionId,NVARCHAR(64),What,The id of the content version associated with the activity.,contentVersions,id,,prod,primary,Nto1,false
userActivity,contentProfileId,NVARCHAR(64),Where,The id of the content profile in which the content was involved in the activity.,contentProfiles,id,,prod,primary,Nto1,false
userActivity,contentProfileName,NVARCHAR(MAX),Where,The name of the content profile in which this content exists.,,,,prod,,,false
userActivity,contextId,NVARCHAR(64),Where (External),The unique Id of the external record that the delivery took place on. Typically this is a CRM record id but can contain the unique id for any external system record depending on the integration.,,,,prod,,,false
userActivity,contextName,NVARCHAR(512),Where (External),"The Name of the external record that the delivery took place on. This is typically the CRM record Name of a specific Opportunity, Contact, Account, etc. but can also contain the name of a record in a custom application.",,,,prod,,,false
userActivity,contextType,NVARCHAR(256),Where (External),"The Type of external record that the delivery took place on. This is typically a CRM record Type such as Opportunity, Contact, Account, etc. but can also contain the record Type of a custom application.",,,,prod,,,false
userActivity,contextSystemType,NVARCHAR(256),Where (External),The System of the record that the delivery took place in. This typically contains the name of a CRM system but can contain the name of any external system depending on the integration.,,,,prod,,,false
userActivity,instanceName,NVARCHAR(512),What,"The name of the content as it appeared when the activity took place. Typically this is the name as appears in the Library, except in cases of generated Livedocs, WorkSpace content, or Library content added to WorkSpace that has been altered.",,,,prod,,,false
userActivity,isBoundDelivery,BOOLEAN,How,Boolean indicating if the usage is the result of a bound delivery option.,,,,prod,,,false
userActivity,libraryContentId,NVARCHAR(64),What,The library content id of the content upon which the activity took place - this id will populate when the content originated from the seismic library.,libraryContents,id,,prod,informational,Nto1,false
userActivity,libraryContentVersionId,NVARCHAR(64),What,"The library content version id of the content upon which the activity took place, this id will populate when the content originally came by library.",libraryContentVersions,id,,prod,informational,Nto1,false
userActivity,livesendLinkContentId,NVARCHAR(64),What,The id assigned to the content when delivered via LiveSend. This is guaranteed unique in this table and can be treated as a primary key to join to and table that can be joined to livesendLinkContents.,livesendLinkContents,id,,prod,primary,1to1,false
userActivity,livesendLinkId,NVARCHAR(64),How,The id of the LiveSend in which the content was included. Note - For LiveSends created with 'Generate Livesend Link' there will be no associated livesendLinkMembers.,livesendLinks,id,,prod,primary,Nto1,false
userActivity,occurredAt,TIMESTAMP,When,The datetime when the activity occurred.,,,,prod,,,false
userActivity,productArea,NVARCHAR(128),Where,"The area of the product where the activity occurred such as DocCenter, NewsCenter, WorkSpace, etc.",,,,prod,,,false
userActivity,totalPages,INTEGER,What,The number of pages of the delivered or presented content related to the row's action.,,,,prod,,,false
userActivity,userId,NVARCHAR(64),Who,The id of the user who performed the activity.,users,id,,prod,primary,Nto1,false
userActivity,userUsername,NVARCHAR(256),Who,The username of the user who performed the activity.,,,,prod,,,false
userActivity,workspaceContentId,NVARCHAR(64),Content,The workspace content id of the content upon which the activity took place.,workspaceContents,id,,prod,informational,Nto1,false
userActivity,workspaceContentVersionId,NVARCHAR(64),Content,The workspace content version id of the content upon which the activity took place.,workspaceContentVersions,id,,prod,informational,Nto1,false
userActivity,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
userActivity,interactionId,NVARCHAR(64),How,The id of the interaction relating to this activity.,,,,prod,,,false
userActivity,interactionGroupId,NVARCHAR(64),What,The id of the interaction group relating to this activity.,,,,prod,,,false
userActivity,isBlastInteractionGroup,BOOLEAN,What,"Boolean indicating if the engagement, also known as the interactionGroupId in the data model, is associated with an Email Blast.",,,,prod,,,false
userActivity,searchClickId,NVARCHAR(64),Search,The id of the search click relating to this activity.,searchClicks,id,,prod,primary,1to1,false
userActivity,searchCycleId,NVARCHAR(64),Search,An id for the combined cycle of steps for search and filter.,searchHistory,searchCycleId,,prod,informational,NtoN,false
userActivity,searchHistoryId,NVARCHAR(64),Search,The id of the search history relating to this activity.,searchHistory,id,,prod,primary,Nto1,false
userActivity,generatedLivedocId,NVARCHAR(64),LiveDoc,The id of the Generated LiveDoc relating to this activity.,generatedLivedocs,id,,prod,informational,1to1,false
userActivity,contentAskExpertsId,NVARCHAR(64),AskExpert,The id of the Ask Expert occurrence relating to this activity.,contentAskExperts,id,,prod,informational,Nto1,false
userActivity,contentReviewId,NVARCHAR(64),Review,The id of the Content Review occurrence relating to this activity.,contentReviews,id,,prod,informational,1to1,false
userActivity,isEngagementUserInternal,BOOLEAN,Engagement,Tied specifically to denote if the action on this row came from an internal user or an external user.,,,,prod,,,false
userActivity,engagementUserEmail,NVARCHAR(64),Engagement,"For LiveSend Links, this field will contain the user email for the user who performed the engagement associated with the LiveSend. In contrast, the userUserName on userActivity on this row will denote the creator of the LiveSend Link. To further clarify, for LiveSend Links where actionCategory = Engagement, the userUsername field will ALWAYS refer to the creator of the LiveSend Link and engagementUserEmail will include internal and external users who are viewing, commenting, sharing, or engaging with the LiveSend link or LiveSend content.",,,,prod,,,false
userActivity,livesendCommentId,NVARCHAR(64),LiveSend,Id for the comments added to a LiveSend for a DSR.,livesendComments,id,,prod,informational,Nto1,false
userActivity,livesendViewingSessionId,NVARCHAR(64),LiveSend,The id of the viewing session for the LiveSend.,livesendViewingSessions,id,,prod,informational,Nto1,false
userActivity,livesendContentViewingSessionId,NVARCHAR(64),LiveSend,The id of the viewing session for content in the LiveSend.,livesendContentViewingSessions,id,,prod,informational,Nto1,false
userActivity,livesendReactionId,NVARCHAR(64),LiveSend,The id for a reaction added to a LiveSend.,livesendCommentReactions,id,,prod,informational,Nto1,false
userActivity,learningProgressId,NVARCHAR(64),Learning,The id for a path or lesson progress in Lessonly.,learningProgress,id,,prod,,Nto1,false
userActivity,socialShareId,NVARCHAR(64),Social,The id for a social share.,socialShares,id,,prod,informational,Nto1,true
userActivity,textMessageId,NVARCHAR(64),Social,The id for a text message.,textMessages,id,,prod,informational,Nto1,true
userActivity,skillAssessmentId,NVARCHAR(64),Skill Assessment,The id for the skill assessment in Lessonly.,skillAssessments,id,,prod,,Nto1,true
userActivity,contentInsertInstanceId,NVARCHAR(64),Seismic for Slides,The id for the instance of a content insert in an application such as Seismic for Powerpoint.,contentInsertInstances,id,,prod,informational,Nto1,false
userActivity,meetingId,NVARCHAR(64),Meetings,The id for a meeting that has taken place.,meetings,id,,prod,informational,Nto1,false
userActivity,digitalSalesRoomId,NVARCHAR(64),Digital Sales Room,The id for a digital sales room that was created.,digitalSalesRooms,id,,prod,informational,Nto1,false
userActivity,digitalSalesRoomViewingSessionsId,NVARCHAR(64),Digital Sales Room,The id for a digital sales room viewing session.,digitalSalesRoomViewingSessions,id,,prod,informational,Nto1,false
userActivity,learningStatusId,NVARCHAR(64),Learning,The foriegn key id to the learning status model that connects end-user learning activites in this model with the learning fact tables in LiveInsights.,learningStatuses,id,,prod,,1to1,false
userActivity,channelId,NVARCHAR(64),Channels,The id of the channel that the activity took place in.,channels,id,,prod,,Nto1,false
userActivity,postId,NVARCHAR(64),Channels,The id of the post that the activity took place in.,posts,id,,prod,,Nto1,false
userActivity,postContentId,NVARCHAR(64),Channels,The id of the locally uploaded post content upon which the activty took place.,postContents,id,,prod,,Nto1,false
userActivity,announcementId,NVARCHAR(64),Announcements,The id of the announcement that the activity took place in.,announcements,id,,prod,,Nto1,false
userActivity,pageClickId,NVARCHAR(64),Pages,The id of the page click.,pageClicks,id,,prod,,Nto1,false
aiGeneratedText,id,NVARCHAR(64),Primary Id,The unique id given to a response.,,,,prod,,,false
aiGeneratedText,userId,NVARCHAR(64),Who,The Seismic user id of the user who interacted with the AI feature.,users,id,,prod,,Nto1,false
aiGeneratedText,userName,NVARCHAR(256),Who,The username of the user who interacted with the AI feature.,,,,prod,,,false
aiGeneratedText,email,NVARCHAR(256),Who,The email of the user who interacted with the AI feature.,,,,prod,,,false
aiGeneratedText,useCase,NVARCHAR(256),What,The name of the feature or user workflow that made the call to the LLM Gateway.  It’s purpose is to track usage and costing associated with a particular generative use case. Can be used to understand how users are adopting AI.,,,,prod,,,false
aiGeneratedText,flowRequestId,NVARCHAR(64),What,"Optionally used to tie multiple rows of generated text to a single user event or entity. Sometimes, a user workflow or use case requires more than one call to the LLM to produce an answer for the user. This Id will help group all calls into one user interaction with Aura.",,,,prod,,,false
aiGeneratedText,aiModel,NVARCHAR(256),What,Model used to generate content. E.g. gpt-35-turbo-0613.,,,,prod,,,false
aiGeneratedText,aiModelProvider,NVARCHAR(256),What,The Model hosting provider. E.g. azure.,,,,prod,,,false
aiGeneratedText,occurredAt,TIMESTAMP,When,Date and time the generative request was received by the model.,,,,prod,,,false
aiGeneratedText,isAuraCopilotFeature,BOOLEAN,What,A boolean field indicating if the AI interaction is part of the Aura Copilot feature set.,,,,prod,,,false
digitalSalesRooms,id,NVARCHAR(64),Primary Id,The unique identifier for a given digital sales room.,,,,prod,,,false
digitalSalesRooms,name,NVARCHAR(512),What,The name of the digital sales room.,,,,prod,,,false
digitalSalesRooms,digitalSalesRoomTemplateId,NVARCHAR(64),What,The id of the digital sales room template id which the digital sales room was created from.,digitalSalesRoomTemplates,id,,prod,,Nto1,false
digitalSalesRooms,digitalSalesRoomTemplateVersionId,NVARCHAR(64),What,The version id of the digital sales room template which the digital sales room was created from.,digitalSalesRoomTemplateVersions,id,,prod,,Nto1,false
digitalSalesRooms,createdBy,NVARCHAR(64),Who,The user id of the user who created this digital sales room.,users,id,,prod,,Nto1,false
digitalSalesRooms,createdByUsername,NVARCHAR(256),Who,The username of the user who created this digital sales room.,,,,prod,,,false
digitalSalesRooms,createdAt,TIMESTAMP,When,The datetime that this digital sales room was created.,,,,prod,,,false
digitalSalesRooms,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
digitalSalesRooms,userModifiedAt,TIMESTAMP,modifiedAt,The datetime this digital sales room was last modified by a user.,,,,prod,,,false
programRequests,id,NVARCHAR(64),Primary Id,The id of the request and primary id for this table.,,,,prod,,,false
programRequests,title,NVARCHAR(MAX),What,The name given to the request.,,,,prod,,,false
programRequests,status,NVARCHAR(MAX),What,The descriptive name of the request's current status.,,,,prod,,,false
programRequests,priority,NVARCHAR(MAX),What,Level of importance for a given request within a program.,,,,prod,,,false
programRequests,rank,NVARCHAR(MAX),What,Rank defines the ordinal numbered order in which the request falls within the program's request series.,,,,prod,,,false
programRequests,note,NVARCHAR(MAX),What,Text field contains an optional acceptance or rejection note for the request.,,,,prod,,,false
programRequests,createdAt,TIMESTAMP,When,The datetime that the request was created.,,,,prod,,,false
programRequests,createdBy,NVARCHAR(64),Who,Id of the user who created the request.,users,id,,prod,,Nto1,false
programRequests,createdByUsername,NVARCHAR(256),Who,Username of the user who created the request.,,,,prod,,,false
programRequests,systemModifiedAt,TIMESTAMP,modifiedAt,The datetime this record was last modified by the system and is not indicative of an explicit user edit/update to the request.,,,,prod,,,false
programRequests,userModifiedAt,TIMESTAMP,modifiedAt,The datetime that the task was last updated/modified by a request.,,,,prod,,,false
programRequests,modifiedBy,NVARCHAR(64),Who,Id of the user who last updated/modified the request.,users,id,,prod,,Nto1,false
programRequests,modifiedByUsername,NVARCHAR(256),Who,Username of the user who last updated/modified the request.,,,,prod,,,false
programRequests,requestorId,NVARCHAR(64),Who,Id of the user who requested the request.,users,id,,prod,,Nto1,false
programRequests,requestorUsername,NVARCHAR(256),Who,Username of the user who requested the request.,,,,prod,,,false
programRequests,assigneeId,NVARCHAR(64),Who,Id of the user who is assigned to the request.,users,id,,prod,,Nto1,false
programRequests,assigneeUsername,NVARCHAR(256),Who,Username of the user who is assigned to the request.,,,,prod,,,false
programRequests,plannedStartDate,TIMESTAMP,When,The datetime that the request was scheduled to start.,,,,prod,,,false
programRequests,plannedDueDate,TIMESTAMP,When,The datetime that the request was scheduled to be completed.,,,,prod,,,false
programRequests,plannedDurationDays,INTEGER,What,"The system-calculated length of time the request is scheduled to take. Duration is based on days between, and including, the planned start date and planned due date.",,,,prod,,,false
programRequests,isOverdue,BOOLEAN,What,Boolean indicating if request is passed the planned due date.,,,,prod,,,false
programRequests,programId,NVARCHAR(64),What,Id of the program which this request belongs to.,programs,id,,prod,,Nto1,false
programRequests,isDeleted,BOOLEAN,What,A boolean indicating if the request is currently considered deleted.,,,,prod,,,false
programRequests,deletedAt,TIMESTAMP,When,The datetime on which the task was deleted.,,,,prod,,,false
programRequests,shortId,NVARCHAR(64),What,"unique id of the request, in its shortened form as provided by CMS.",,,,prod,,,false
emailTemplateStaticImages,id,NVARCHAR(64),Primary Id,Id representing the Static Image for the Email Template Instance and primary id for this table.,,,,prod,,,false
emailTemplateStaticImages,emailTemplateInstanceId,NVARCHAR(64),What,The id of the emailTemplateInstance associated with the Static Image.,emailTemplateInstances,id,,prod,primary,Nto1,false
emailTemplateStaticImages,repository,NVARCHAR(12),Where,Location from which the user chose to upload the image.,,,,prod,,,false
emailTemplateStaticImages,contentId,NVARCHAR(64),What,"The Seismic contentId of the Static Image content, if inserted from within Seismic.",contents,id,,prod,primary,Nto1,false
emailTemplateStaticImages,contentVersionId,NVARCHAR(64),What,"The Seismic contentVersionId of the Static Image content, if inserted from within Seismic.",contentVersions,id,,prod,primary,Nto1,false
emailTemplateStaticImages,libraryContentId,NVARCHAR(64),What,"The libraryContentId of the Static Image content, if inserted from within Seismic.",libraryContents,id,,prod,informational,Nto1,false
emailTemplateStaticImages,libraryContentVersionId,NVARCHAR(64),What,"The libraryContentVersionId of the Static Image content, if inserted from within Seismic.",libraryContentVersions,id,,prod,informational,Nto1,false
emailTemplateStaticImages,workspaceContentId,NVARCHAR(64),What,"The workspaceContentId of the Static Image content, if inserted from within Seismic.",workspaceContents,id,,prod,informational,Nto1,false
emailTemplateStaticImages,workspaceContentVersionId,NVARCHAR(64),What,"The workspaceContentVersionId of the Static Image content, if inserted from within Seismic.",workspaceContentVersions,id,,prod,informational,Nto1,false
emailTemplateStaticImages,contentProfileId,NVARCHAR(64),Where,The content profile id of the profile to which the Static Image content is assigned.,contentProfiles,id,,prod,,Nto1,false
emailTemplateStaticImages,contentProfileName,NVARCHAR(MAX),Where,The name of the profile to which the Static Image content is assigned.,,,,prod,,,false
emailTemplateStaticImages,instanceName,NVARCHAR(512),What,"The name of the image content as it appeared when the email was sent, or null if the image was uploaded. Typically this is the name as appears in the Library, except in cases of WorkSpace content or Library content added to WorkSpace that has been altered.",,,,prod,,,false
emailTemplateStaticImages,targetUrl,NVARCHAR(MAX),What,"The hyperlink to which an image links, when the sender chooses to leverage this optional setting.",,,,prod,,,false
emailTemplateStaticImages,alternativeText,NVARCHAR(MAX),What,Text as an alternative to the Static Image in a template. Optional setting upon image upload.,,,,prod,,,false
emailTemplateStaticImages,alignment,NVARCHAR(23),What,Alignment of the static image within the email template.,,,,prod,,,false
emailTemplateStaticImages,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
customContents,id,NVARCHAR(64),Primary Id,The unique id of a custom content within the tenant.,,,,prod,,,false
customContents,libraryContentId,NVARCHAR(64),What,The id associated with the Library Content.,libraryContents,id,,prod,,Nto1,false
customContents,libraryContentVersionId,NVARCHAR(64),What,The id associated with the Library Content Version.,libraryContentVersions,id,,prod,,Nto1,false
customContents,customContentTypeId,NVARCHAR(64),What,The id associated with the Custom Content Type.,customContentTypes,id,,prod,,Nto1,false
customContents,customContentTypeVersionId,NVARCHAR(64),What,The id associated with the Custom Content Type Version.,customContentTypes,versionId,,prod,,Nto1,false
customContents,modifiedAt,TIMESTAMP,modifiedAt,The time the record was last modified.,,,,prod,,,false
livedocDataSourceInfo,id,NVARCHAR(64),Primary Id,The id of the DataSource content and the primary key of this model.,,,,prod,,,false
livedocDataSourceInfo,libraryContentId,NVARCHAR(64),What,The id of the DataSource library content.,libraryContents,id,,prod,,Nto1,false
livedocDataSourceInfo,libraryContentVersionId,NVARCHAR(64),What,The id of the DataSource library content version.,libraryContentVersions,id,,prod,,Nto1,false
livedocDataSourceInfo,libraryContentName,NVARCHAR(512),What,The name of the DataSource library content.,,,,prod,,,false
livedocDataSourceInfo,libraryContentType,NVARCHAR(64),What,The type of this DataSource library content.,,,,prod,,,false
livedocDataSourceInfo,libraryContentVersion,NVARCHAR(512),What,The version number of this DataSource library content.,,,,prod,,,false
livedocDataSourceInfo,teamsiteId,NVARCHAR(64),What,The id of the teamsite this DataSource library content exists in.,teamsites,id,,prod,,Nto1,false
livedocDataSourceInfo,isReturnOneRow,BOOLEAN,What,Boolean that is true if the DataSource only returns one row of data.,,,,prod,,,false
livedocDataSourceInfo,salesforceVersion,NVARCHAR(64),What,The salesforce DataSource version.,,,,prod,,,false
livedocDataSourceInfo,salesforceBaseObject,NVARCHAR(64),What,The salesforce DataSource base object.,,,,prod,,,false
livedocDataSourceInfo,isDeleted,BOOLEAN,What,Boolean indicating if this DataSource is deleted.,,,,prod,,,false
livedocDataSourceInfo,createdAt,TIMESTAMP,When,The datetime of the DataSource record was created.,,,,prod,,,false
livedocDataSourceInfo,createdBy,NVARCHAR(64),Who,The id of the user who created the DataSource.,users,id,,prod,,Nto1,false
livedocDataSourceInfo,lastModified,TIMESTAMP,When,The datetime of the DataSource record was last modified by a user.,,,,prod,,,false
livedocDataSourceInfo,lastModifiedBy,NVARCHAR(64),Who,The id of the user who last modified the DataSource.,users,id,,prod,,Nto1,false
livedocDataSourceInfo,systemModifiedAt,TIMESTAMP,When,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
users,id,NVARCHAR(64),Primary Id,The id of the user and the primary id for items in this table.,,,,prod,,,false
users,groupMembersUserId,NVARCHAR(64),Who,"This is a exact copy of the primary key of this table, users.Id. This column's purpose is to control join cardinality in the groupMembers table increasing the performance of the widgets in our dashboarding environment.",,,,prod,,,false
users,userPropertyAssignmentsUserId,NVARCHAR(64),What,"This is a exact copy of the primary key of this table, users.Id. This column's purpose is to control join cardinality in the userPropertyAssignments table increasing the performance of the widgets in our dashboarding environment.",,,,prod,,,false
users,username,NVARCHAR(256),Who,The user's username.,,,,prod,,,false
users,email,NVARCHAR(256),What,The email address of the user.,,,,prod,,,false
users,emailDomain,NVARCHAR(256),What,The user's email address domain such as seismic.com.,,,,prod,,,false
users,firstName,NVARCHAR(64),Who,The user's first name or given name.,,,,prod,,,false
users,lastName,NVARCHAR(64),Who,The user's last name or surname.,,,,prod,,,false
users,fullName,NVARCHAR(128),Who,The user's full name.,,,,prod,,,false
users,address,NVARCHAR(64),What,The user's address.,,,,prod,,,false
users,phoneNumber,NVARCHAR(64),What,The user's phone number.,,,,prod,,,false
users,createdAt,TIMESTAMP,When,The timestamp when the user record was created.,,,,prod,,,false
users,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
users,deletedAt,TIMESTAMP,When,The timestamp when the user record was marked deleted.,,,,prod,,,false
users,latestActivityDate,DATE,When,The date when the user record most recently has had activity.,,,,prod,,,false
users,organization,NVARCHAR(1024),What,The user's organization.,,,,prod,,,false
users,department,NVARCHAR(1024),What,The user's department.,,,,prod,,,false
users,title,NVARCHAR(1024),What,The user's title.,,,,prod,,,false
users,isDeleted,BOOLEAN,What,A boolean indicating if the user is currently considered deleted.,,,,prod,,,false
users,isLocked,BOOLEAN,What,A boolean indicating if the user is currently considered locked.,,,,prod,,,false
users,isDeactivated,BOOLEAN,What,A boolean indicating if the user is currently considered deactivated.,,,,prod,,,false
users,deactivatedAt,TIMESTAMP,When,The datetime this user was deactivated in the system.,,,,prod,,,false
users,licenseType,NVARCHAR(128),What,"The license type for the user such as premium, business, or partner.",,,,prod,,,false
users,isSeismicEmployee,BOOLEAN,What,A boolean indicating if the user is a Seismic employee.,,,,prod,,,false
users,isSystemAdmin,BOOLEAN,What,A boolean indicating if the user has system administration permissions.,,,,prod,,,false
users,defaultContentProfileId,NVARCHAR(64),Who,The id of the user's default content profile.,contentProfiles,id,,prod,,Nto1,false
users,defaultContentProfileName,NVARCHAR(256),What,The name of the user's default content profile.,,,,prod,,,false
users,managerId,NVARCHAR(64),Who,The id of the user's manager.,groupManagers,managerId,,prod,,1to1,false
users,managerName,NVARCHAR(64),Who,The name of the user's manager.,,,,prod,,,false
users,hireDate,DATE,When,The user's hire date.,,,,prod,,,false
users,location,NVARCHAR(64),What,The user's location.,,,,prod,,,false
users,ssoUserId,NVARCHAR(64),Who,The single sign-on id for the user.,,,,prod,,,false
users,externalId,NVARCHAR(64),Who,"The id for this user in an external system which contains relevant user data such as an HRIS. This field is not intended for SSO provider account Ids, those Ids should be input into the ssoUserId field.",,,,prod,,,false
users,isSeismicEnabled,BOOLEAN,What,Boolean indicating whether this user is a Seismic user.,,,,prod,,,false
users,isLessonlyEnabled,BOOLEAN,What,A boolean indicating if the user is a Lessonly user.,,,,prod,,,false
users,businessUnit,NVARCHAR(256),What,The business unit associated with the user.,,,,prod,,,false
users,languageCode,NVARCHAR(64),What,The language code associated with the user.,,,,prod,,,false
postContents,id,NVARCHAR(64),Primary Id,The id of the post.,,,,prod,,,false
postContents,postContentName,NVARCHAR(256),What,The name of the post content.,,,,prod,,,false
postContents,postContentType,NVARCHAR(256),What,"The type of channels content such as Presentation, Documentation etc.",,,,prod,,,false
postContents,postContentFormat,NVARCHAR(256),What,"The format of the post content such as PNG, PDF etc.",,,,prod,,,false
postContents,createdAt,TIMESTAMP,When,The date and time when the post content was created.,,,,prod,,,false
contentActivities,id,NVARCHAR(64),Primary Id,The primary id of the activity and primary key for records in this table.,,,,prod,,,false
contentActivities,userId,NVARCHAR(64),Who,The user id of the user who performed the action.,users,id,,prod,,Nto1,false
contentActivities,userName,NVARCHAR(256),Who,The username of the user who performed the action.,,,,prod,,,false
contentActivities,actionCategory,NVARCHAR(64),What,The category of the activity.,,,,prod,,,false
contentActivities,action,NVARCHAR(256),What,The specific activity done on content by the user.,,,,prod,,,false
contentActivities,instanceName,NVARCHAR(256),What,The name of the content as it appeared when the activity took place.,,,,prod,,,false
contentActivities,libraryContentId,NVARCHAR(64),What,The library content id of the content upon which the activity took place.,libraryContents,id,,prod,,Nto1,false
contentActivities,libraryContentVersionId,NVARCHAR(64),What,The library content version id of the content upon which the activity took place.,libraryContentVersions,id,,prod,,Nto1,false
contentActivities,productArea,NVARCHAR(64),Where,The area of the product where the activity occurred.,,,,prod,,,false
contentActivities,application,NVARCHAR(64),Where,The application the content activity within Seismic took place on.,,,,prod,,,false
contentActivities,occurredAt,TIMESTAMP,When,The datetime that the action occurred.,,,,prod,,,false
contentActivities,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
aiSuggestedContentProperties,id,NVARCHAR(64),Primary Id,"Only serves as the model's primary key, there is no business meaning.",,,,prod,,,false
aiSuggestedContentProperties,suggestedContentPropertyId,NVARCHAR(64),What,The id of the suggested content property.,contentProperties,id,,prod,informational,Nto1,false
aiSuggestedContentProperties,suggestedContentPropertyValueId,NVARCHAR(64),What,The id of the suggested content property value.,,,,prod,,,false
aiSuggestedContentProperties,suggestedContentPropertyValue,NVARCHAR(256),What,The value of the suggested content property.,,,,prod,,,false
aiSuggestedContentProperties,score,FLOAT,What,"The score of the suggested content property, measureed in terms of user acceptance out of number of suggestions. The score should be between 0 and 1.",,,,prod,,,false
aiSuggestedContentProperties,isDeclined,BOOLEAN,What,Indicates whether or not the suggested content property has been declined by the user. Default value is null.,,,,prod,,,false
aiSuggestedContentProperties,libraryContentId,NVARCHAR(64),What,The unique identifier for a given content in the Seismic Library (Content Manager).,libraryContents,id,,prod,informational,Nto1,false
aiSuggestedContentProperties,createdAt,TIMESTAMP,When,The datetime that AIML created the suggestion.,,,,prod,,,false
aiSuggestedContentProperties,modifiedAt,TIMESTAMP,modifiedAt,The datetime that is the latest time the suggestion was updated.,,,,prod,,,false
watermarks,id,NVARCHAR(64),Primary Id,The id of the watermark. Domain determines this value.,,,,prod,,,false
watermarks,productArea,NVARCHAR(64),Where,Area within Seismic such as DocCenter or LiveSend.,,,,prod,,,false
watermarks,application,NVARCHAR(64),Where,The application the watermark was viewed in or downloaded from.  This affects the source* field which is filled.,,,,prod,,,false
watermarks,contentRepository,NVARCHAR(64),Where,The repository the content resided in which may affect the content* reference ID.,,,,prod,,,false
watermarks,contentVersionId,NVARCHAR(64),What,The content version delivered with a watermark.,contentVersions,id,,prod,,Nto1,false
watermarks,userId,NVARCHAR(64),Who,The id of the internal Seismic user viewing or downloading the content.,users,id,,prod,,Nto1,false
watermarks,interactionId,NVARCHAR(64),What,The id of the Engagement interaction which had a watermark.,userActivity,interactionId,,prod,,Nto1,false
watermarks,watermarkTemplateText,NVARCHAR(MAX),What,The text of the watermark template as defined in the configuration at the time this watermark occurred.,,,,prod,,,false
watermarks,watermarkRuleFilterText,NVARCHAR(MAX),What,Friendly text of all the rules as applied.,,,,prod,,,false
watermarks,watermarkType,NVARCHAR(8),What,The type of watermark.,,,,prod,,,false
watermarks,watermarkRawText,NVARCHAR(MAX),What,The raw text of the watermark applied.,,,,prod,,,false
watermarks,occurredAt,TIMESTAMP,When,The datetime this event occurred at.,,,,prod,,,false
watermarks,modifiedAt,TIMESTAMP,modifiedAt,"The datetime this record was last modified, which may happen long after the record is created as new data is added over time to old records.",,,,prod,,,false
fields,name,NVARCHAR(256),What,The name of the field.,,,,prod,,,false
fields,tableName,NVARCHAR(256),Where,The name of the table the field belongs to.,tables,name,,prod,,Nto1,false
fields,description,NVARCHAR(MAX),What,A brief explanation of the field's purpose.,,,,prod,,,false
fields,isNullable,BOOLEAN,What,Indicates whether the field allows null values.,,,,prod,,,false
fields,type,NVARCHAR(64),What,The data type of the field.,,,,prod,,,false
fields,sqlType,NVARCHAR(64),What,The SQL data type of the field.,,,,prod,,,false
fields,isKey,BOOLEAN,What,Indicates whether the field is a primary key.,,,,prod,,,false
fields,theme,NVARCHAR(64),What,The theme or category of the field.,,,,prod,,,false
fields,joinTo,NVARCHAR(256),How,The table and field this field joins to.,,,,prod,,,false
fields,joinCardinality,NVARCHAR(64),How,"The cardinality of the join (e.g., Nto1, 1to1).",,,,prod,,,false
CRM_ACCOUNT,UDM_ADDRESSCITY,NVARCHAR(256),Context,The city of the account,,,,prod,,,false
CRM_ACCOUNT,UDM_ADDRESSCOUNTRY,NVARCHAR(256),Context,The country of the account,,,,prod,,,false
CRM_ACCOUNT,UDM_ADDRESSPOSTALCODE,NVARCHAR(256),Context,The postal code or zip code of the account such as 92130,,,,prod,,,false
CRM_ACCOUNT,UDM_ADDRESSSTATEORPROVINCE,NVARCHAR(256),Context,The state or province of the account,,,,prod,,,false
CRM_ACCOUNT,UDM_ADDRESSSTREET,NVARCHAR(MAX),Context,The street address of the account such as 123 James St.,,,,prod,,,false
CRM_ACCOUNT,UDM_ANNUALREVENUE,FLOAT,Context,The annual revenue for the account,,,,prod,,,false
CRM_ACCOUNT,UDM_CREATEDAT,TIMESTAMP,Context,The timestamp that this account was created in the CRM,,,,prod,,,false
CRM_ACCOUNT,UDM_GLOBALID,NVARCHAR(64),Primary Id,A global id which represents a cross-CRM id for this particular account,interactionContexts,udmcontextglobalid,,prod,,1to1,false
CRM_ACCOUNT,UDM_ID,NVARCHAR(256),Context,The id of this account according to the CRM,,,,prod,,,false
CRM_ACCOUNT,UDM_INDUSTRY,NVARCHAR(256),Context,The industry of the account,,,,prod,,,false
CRM_ACCOUNT,UDM_ISDELETED,BOOLEAN,Context,A boolean indicating if this account has been deleted,,,,prod,,,false
CRM_ACCOUNT,UDM_LASTMODIFIEDAT,TIMESTAMP,Context,The timestamp that this record was last modified by the system or a user,,,,prod,,,false
CRM_ACCOUNT,UDM_NAME,NVARCHAR(765),Context,The name of the account,,,,prod,,,false
CRM_ACCOUNT,UDM_NUMBEROFEMPLOYEES,INTEGER,Context,The number of employees for the account,,,,prod,,,false
CRM_ACCOUNT,UDM_OWNEREMAIL,NVARCHAR(384),Context,The email address of the CRM user who owns this account,,,,prod,,,false
CRM_ACCOUNT,UDM_OWNERFULLNAME,NVARCHAR(363),Context,The full name of the CRM user who owns this account,,,,prod,,,false
CRM_ACCOUNT,UDM_OWNERID,NVARCHAR(256),Context,The external id of the CRM user who owns this account,,,,prod,,,false
CRM_ACCOUNT,UDM_SYSTEMID,NVARCHAR(256),Context,The id of the CRM.  This is typically the organization id for any given CRM,,,,prod,,,false
CRM_ACCOUNT,UDM_SYSTEMTYPE,NVARCHAR(256),Context,"The name of the CRM in which the account lives, such as Salesforce, Microsoft Dynamics, etc.",,,,prod,,,false
CRM_ACCOUNT,UDM_TIMESTAMP,TIMESTAMP,Context,The timestamp that this record was last synced,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_HISTORYID,NVARCHAR(256),Context,The id of the history record and primary key for this table.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_ID,NVARCHAR(64),Primary Id,The id of this CRM account.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_SYSTEMID,NVARCHAR(256),Context,The organization id of the CRM.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_SYSTEMTYPE,NVARCHAR(256),Context,"The name of the CRM, such as Salesforce, Microsoft Dynamics, etc.",,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_ADDRESSCITY,NVARCHAR(256),Context,The city of the CRM account.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_CREATEDAT,TIMESTAMP,Context,The timestamp that this CRM account was created.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_ADDRESSCOUNTRY,NVARCHAR(256),Context,The country of the CRM account.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_ANNUALREVENUE,FLOAT,Context,The annual revenue of the CRM account.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_INDUSTRY,NVARCHAR(256),Context,The industry of the CRM account.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_ADDRESSPOSTALCODE,NVARCHAR(256),Context,The postal code or zip code of the CRM account.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_ISDELETED,BOOLEAN,Context,A boolean indicating if this CRM account has been deleted.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_ADDRESSSTATEORPROVINCE,NVARCHAR(256),Context,The state or province of the CRM account.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_LASTMODIFIEDAT,TIMESTAMP,Context,The timestamp that this record was last modified by the system or a user.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_ADDRESSSTREET,NVARCHAR(256),Context,The street address of the CRM account.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_NAME,NVARCHAR(363),Context,The name of the CRM account.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_OWNEREMAIL,NVARCHAR(384),Context,The email address of the user who owns this account.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_OWNERFULLNAME,NVARCHAR(363),Context,The full name of the user who owns this account.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_NUMBEROFEMPLOYEES,INTEGER,Context,The number of employees for the account,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_OWNERID,NVARCHAR(256),Context,The id of the user who owns this account.,,,,prod,,,false
HISTORY_CRM_ACCOUNT,UDM_TIMESTAMP,TIMESTAMP,Context,The timestamp that this record was last synced.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_HISTORYID,NVARCHAR(256),Context,The id of the history record and primary key for this table.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_ID,NVARCHAR(64),Primary Id,The id of this CRM opportunity.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_SYSTEMID,NVARCHAR(256),Context,The organization id of the CRM.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_SYSTEMTYPE,NVARCHAR(256),Context,"The name of the CRM, such as Salesforce, Microsoft Dynamics, etc.",,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_ACCOUNTID,NVARCHAR(256),Context,The id of the account this opportunity belongs to.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_AMOUNT,FLOAT,Context,The amount of the CRM opportunity.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_CREATEDAT,TIMESTAMP,Context,The timestamp that this CRM opportunity was created.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_CLOSEDATE,TIMESTAMP,Context,The date the CRM opportunity is closed or is expected to close.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_ISCLOSED,BOOLEAN,Context,A boolean indicating if this CRM opportunity is closed.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_ISDELETED,BOOLEAN,Context,A boolean indicating if this CRM opportunity has been deleted.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_ISWON,BOOLEAN,Context,A boolean indicating if this CRM opportunity is won.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_EXPECTEDREVENUE,FLOAT,Context,The expected amount of revenue for this CRM opportunity.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_LASTMODIFIEDAT,TIMESTAMP,Context,The timestamp that this record was last modified by the system or a user.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_NAME,NVARCHAR(363),Context,The name of the CRM opportunity.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_OWNEREMAIL,NVARCHAR(384),Context,The email address of the user who owns this opportunity.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_OWNERFULLNAME,NVARCHAR(363),Context,The full name of the user who owns this opportunity.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_OWNERID,NVARCHAR(256),Context,The id of the user who owns this opportunity.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_STAGENAME,NVARCHAR(256),Context,The name of the current sales stage of the CRM opportunity.,,,,prod,,,false
HISTORY_CRM_OPPORTUNITY,UDM_TIMESTAMP,TIMESTAMP,Context,The timestamp that this record was last synced,,,,prod,,,false
CRM_LEAD,UDM_ADDRESSCITY,NVARCHAR(256),Context,The city of the lead,,,,prod,,,false
CRM_LEAD,UDM_ADDRESSCOUNTRY,NVARCHAR(256),Context,The country of the lead,,,,prod,,,false
CRM_LEAD,UDM_ADDRESSPOSTALCODE,NVARCHAR(256),Context,The postal code or zip code of the lead such as 92130,,,,prod,,,false
CRM_LEAD,UDM_ADDRESSSTATEORPROVINCE,NVARCHAR(256),Context,The state or province of the lead,,,,prod,,,false
CRM_LEAD,UDM_ADDRESSSTREET,NVARCHAR(256),Context,The street address of the lead such as 123 James St.,,,,prod,,,false
CRM_LEAD,UDM_ANNUALREVENUE,NVARCHAR(256),Context,The annual revenue for the company that the lead belongs to,,,,prod,,,false
CRM_LEAD,UDM_COMPANY,NVARCHAR(765),Context,The name of the company for the lead (since leads aren't directly linked to accounts),,,,prod,,,false
CRM_LEAD,UDM_CREATEDAT,TIMESTAMP,Context,The timestamp that this lead was created in the CRM,,,,prod,,,false
CRM_LEAD,UDM_EMAIL,NVARCHAR(384),Context,The primary email address of the lead,,,,prod,,,false
CRM_LEAD,UDM_GLOBALID,NVARCHAR(64),Context,A global id which represents a cross-CRM id for this particular lead,interactionContexts,udmcontextglobalid,,prod,,Nto1,false
CRM_LEAD,UDM_ID,NVARCHAR(256),Primary Id,The id of this leadaccording to the CRM,,,,prod,,,false
CRM_LEAD,UDM_INDUSTRY,NVARCHAR(256),Context,The industry of the lead,,,,prod,,,false
CRM_LEAD,UDM_ISDELETED,BOOLEAN,Context,A boolean indicating if this user has been deleted,,,,prod,,,false
CRM_LEAD,UDM_LASTMODIFIEDAT,TIMESTAMP,Context,The timestamp that this record was last modified by the system or a user,,,,prod,,,false
CRM_LEAD,UDM_LEADSOURCE,NVARCHAR(256),Context,The source of this lead according to the CRM,,,,prod,,,false
CRM_LEAD,UDM_NAME,NVARCHAR(363),Context,The full name of the lead,,,,prod,,,false
CRM_LEAD,UDM_NUMBEROFEMPLOYEES,INTEGER,Context,The number of employees at the company of this lead,,,,prod,,,false
CRM_LEAD,UDM_OWNEREMAIL,NVARCHAR(384),Context,The email address of the CRM user who owns this lead,,,,prod,,,false
CRM_LEAD,UDM_OWNERFULLNAME,NVARCHAR(363),Context,The full name of the CRM user who owns this lead,,,,prod,,,false
CRM_LEAD,UDM_OWNERID,NVARCHAR(256),Context,The external id of the CRM user who owns this lead,,,,prod,,,false
CRM_LEAD,UDM_STATUS,NVARCHAR(256),Context,The status of this lead according to the status field in the CRM,,,,prod,,,false
CRM_LEAD,UDM_SYSTEMID,NVARCHAR(256),Context,The id of the CRM.  This is typically the organization id for any given CRM,,,,prod,,,false
CRM_LEAD,UDM_SYSTEMTYPE,NVARCHAR(256),Context,"The name of the CRM in which the account lives, such as Salesforce, Microsoft Dynamics, etc.",,,,prod,,,false
CRM_LEAD,UDM_TIMESTAMP,TIMESTAMP,Context,The timestamp that this record was last synced,,,,prod,,,false
CRM_LEAD,UDM_TITLE,NVARCHAR(384),Context,The title of the lead,,,,prod,,,false
CRM_CONTACT,UDM_ACCOUNTID,NVARCHAR(256),Context,The id of the account according to the CRM that this contact belongs to,,,,prod,,,false
CRM_CONTACT,UDM_ADDRESSCITY,NVARCHAR(256),Context,The city of the contact,,,,prod,,,false
CRM_CONTACT,UDM_ADDRESSCOUNTRY,NVARCHAR(256),Context,The country of the contact,,,,prod,,,false
CRM_CONTACT,UDM_ADDRESSPOSTALCODE,NVARCHAR(256),Context,The postal code or zip code of the contact such as 92130,,,,prod,,,false
CRM_CONTACT,UDM_ADDRESSSTATEORPROVINCE,NVARCHAR(256),Context,The state or province of the contact,,,,prod,,,false
CRM_CONTACT,UDM_ADDRESSSTREET,NVARCHAR(256),Context,The street address of the contact such as 123 James St.,,,,prod,,,false
CRM_CONTACT,UDM_CREATEDAT,TIMESTAMP,Context,The timestamp that this contact was created in the CRM,,,,prod,,,false
CRM_CONTACT,UDM_EMAIL,NVARCHAR(384),Context,The primary email address of the contact,,,,prod,,,false
CRM_CONTACT,UDM_GLOBALID,NVARCHAR(64),Context,A global id which represents a cross-CRM id for this particular user,interactionContexts,udmcontextglobalid,,prod,,Nto1,false
CRM_CONTACT,UDM_ID,NVARCHAR(256),Primary Id,The id of this contact according to the CRM,,,,prod,,,false
CRM_CONTACT,UDM_ISDELETED,BOOLEAN,Context,A boolean indicating if this user has been deleted,,,,prod,,,false
CRM_CONTACT,UDM_LASTMODIFIEDAT,TIMESTAMP,Context,The timestamp that this record was last modified by the system or a user,,,,prod,,,false
CRM_CONTACT,UDM_NAME,NVARCHAR(363),Context,The name of the contact,,,,prod,,,false
CRM_CONTACT,UDM_OWNEREMAIL,NVARCHAR(384),Context,The email address of the CRM user who owns this contact,,,,prod,,,false
CRM_CONTACT,UDM_OWNERFULLNAME,NVARCHAR(363),Context,The full name of the CRM user who owns this contact,,,,prod,,,false
CRM_CONTACT,UDM_OWNERID,NVARCHAR(256),Context,The external id of the CRM user who owns this contact,,,,prod,,,false
CRM_CONTACT,UDM_PHONE,NVARCHAR(256),Context,The primary phone number for this contact,,,,prod,,,false
CRM_CONTACT,UDM_SYSTEMID,NVARCHAR(256),Context,The id of the CRM.  This is typically the organization id for any given CRM,,,,prod,,,false
CRM_CONTACT,UDM_SYSTEMTYPE,NVARCHAR(256),Context,"The name of the CRM in which the account lives, such as Salesforce, Microsoft Dynamics, etc.",,,,prod,,,false
CRM_CONTACT,UDM_TENANTID,NVARCHAR(64),Context,The timestamp that this record was last synced,,,,prod,,,false
CRM_CONTACT,UDM_TIMESTAMP,TIMESTAMP,Context,The timestamp that this record was last synced,,,,prod,,,false
CRM_CONTACT,UDM_TITLE,NVARCHAR(384),Context,The title of the contact,,,,prod,,,false
SRS_USERS,UDM_EMAILADDRESS,NVARCHAR(512),Context,"Email address for the user, as provided by the SRS vendor.",,,,prod,,,false
SRS_USERS,UDM_GLOBALID,NVARCHAR(64),Context,A global ID which represents a cross-SRS system ID for this particular user.,,,,prod,,,false
SRS_USERS,UDM_ID,NVARCHAR(512),Primary Id,The ID of the user according to the external SRS system.,,,,prod,,,false
SRS_USERS,UDM_ISDELETED,BOOLEAN,Context,Boolean indicating whether or not the user is deleted in the external SRS system.,,,,prod,,,false
SRS_USERS,UDM_NAME,NVARCHAR(512),Context,Full name of the external user.,,,,prod,,,false
SRS_USERS,UDM_SEISMICUSERID,NVARCHAR(256),Context,Seismic ID associated with the user.,,,,prod,,,false
SRS_USERS,UDM_SYSTEMID,NVARCHAR(256),Context,"Human readable tenant/orgID for the external system (for example, the Lessonly subdomain or the Brainshark org ID).",,,,prod,,,false
SRS_USERS,UDM_SYSTEMTYPE,NVARCHAR(256),Context,"Name of the external system (e.g. Lessonly, Brainshark).",,,,prod,,,false
SRS_USERS,UDM_TENANTID,NVARCHAR(64),Context,Seismic tenant ID.,,,,prod,,,false
SRS_USERS,UDM_TIMESTAMP,TIMESTAMP,Context,The timestamp that this record was last synced.,,,,prod,,,false
SRS_USERACTIVITY,UDM_ASSIGNEDDATE,TIMESTAMP,Context,Date the object was assigned to the user.,,,,prod,,,false
SRS_USERACTIVITY,UDM_COMPLETEDDATE,TIMESTAMP,Context,Date the assignment was completed by the user.,,,,prod,,,false
SRS_USERACTIVITY,UDM_DUEDATE,TIMESTAMP,Context,Date the assignment is due to be completed.,,,,prod,,,false
SRS_USERACTIVITY,UDM_GLOBALID,NVARCHAR(64),Context,"A global ID which represents a cross-SRS system ID for this particular SRS user activity record. Unique identifier for the row, which represents the progress of a particular user with a particular piece of external training or coaching content.",,,,prod,,,false
SRS_USERACTIVITY,UDM_GLOBALOBJECTID,NVARCHAR(64),Context,A global ID which represents a cross-SRS system ID for this particular object.,srsObjects,udm_globalid,,prod,,,false
SRS_USERACTIVITY,UDM_GLOBALUSERID,NVARCHAR(64),Context,A global ID which represents a cross-SRS system ID for this particular user.,srsUsers,udm_globalid,,prod,,,false
SRS_USERACTIVITY,UDM_ID,NVARCHAR(256),Primary Id,The ID of the user activity record according to the external SRS system.,,,,prod,,,false
SRS_USERACTIVITY,UDM_ISASSIGNED,BOOLEAN,Context,"True indicates that the content has been formally assigned to the user, regardless of completion status. False indicates that the content is not assigned to the user.",,,,prod,,,false
SRS_USERACTIVITY,UDM_ISDELETED,BOOLEAN,Context,Boolean indicating whether or not the record is deleted in the external SRS system.,,,,prod,,,false
SRS_USERACTIVITY,UDM_LASTMODIFIEDDATE,TIMESTAMP,Context,"Timestamp indicating when the record was last modified, as provided by the external SRS system.",,,,prod,,,false
SRS_USERACTIVITY,UDM_SCORE,INTEGER,Context,Score the user received on any quiz/test within the piece of content.,,,,prod,,,false
SRS_USERACTIVITY,UDM_STARTDATE,TIMESTAMP,Context,Date the user began to work on the assignment.,,,,prod,,,false
SRS_USERACTIVITY,UDM_STATUS,NVARCHAR(256),Context,"Normalized status. Potential values: Not Started, In Progress, Complete",,,,prod,,,false
SRS_USERACTIVITY,UDM_SYSTEMID,NVARCHAR(256),Context,"Human readable tenant/orgID for the external system (for example, the Lessonly subdomain or the Brainshark org ID).",,,,prod,,,false
SRS_USERACTIVITY,UDM_SYSTEMTYPE,NVARCHAR(256),Context,"Name of the external system (e.g. Lessonly, Brainshark).",,,,prod,,,false
SRS_USERACTIVITY,UDM_TENANTID,NVARCHAR(64),Context,Seismic tenant ID.,,,,prod,,,false
SRS_USERACTIVITY,UDM_TIMESTAMP,TIMESTAMP,Context,The timestamp that this record was last synced.,,,,prod,,,false
SRS_OBJECTS,UDM_CREATEDDATE,TIMESTAMP,Context,The date the external object was created in the external SRS system.,,,,prod,,,false
SRS_OBJECTS,UDM_GLOBALID,NVARCHAR(64),Context,A global ID which represents a cross-SRS system ID for this particular object.,,,,prod,,,false
SRS_OBJECTS,UDM_ID,NVARCHAR(256),Primary Id,The ID of the object according to the external SRS system.,,,,prod,,,false
SRS_OBJECTS,UDM_ISDELETED,BOOLEAN,Context,Boolean indicating whether or not the object is deleted in the external SRS system.,,,,prod,,,false
SRS_OBJECTS,UDM_NAME,NVARCHAR(256),Context,Name of the training or coaching content.,,,,prod,,,false
SRS_OBJECTS,UDM_SYSTEMID,NVARCHAR(256),Context,"Human readable tenant/orgID for the external system (for example, the Lessonly subdomain or the Brainshark org ID).",,,,prod,,,false
SRS_OBJECTS,UDM_SYSTEMTYPE,NVARCHAR(256),Context,"Name of the external system (e.g. Lessonly, Brainshark).",,,,prod,,,false
SRS_OBJECTS,UDM_TENANTID,NVARCHAR(64),Context,Seismic tenant ID.,,,,prod,,,false
SRS_OBJECTS,UDM_TIMESTAMP,TIMESTAMP,Context,The timestamp that this record was last synced.,,,,prod,,,false
SRS_OBJECTS,UDM_TYPE,NVARCHAR(256),Context,"Type of content. For example, ‘Course’ or ‘Curriculum’.",,,,prod,,,false
SRS_OBJECTS,UDM_URL,NVARCHAR(512),Context,Source URL where the content can be accessed.,,,,prod,,,false
CRM_USER,UDM_ADDRESSCITY,NVARCHAR(256),Context,The city of the user,,,,prod,,,false
CRM_USER,UDM_ADDRESSCOUNTRY,NVARCHAR(256),Context,The country of the user,,,,prod,,,false
CRM_USER,UDM_ADDRESSPOSTALCODE,NVARCHAR(256),Context,The postal code or zip code of the user such as 92130,,,,prod,,,false
CRM_USER,UDM_ADDRESSSTATEORPROVINCE,NVARCHAR(256),Context,The state or province of the user,,,,prod,,,false
CRM_USER,UDM_ADDRESSSTREET,NVARCHAR(256),Context,The street address of the user such as 123 James St.,,,,prod,,,false
CRM_USER,UDM_CREATEDAT,TIMESTAMP,Context,The timestamp that this user was created in the CRM,,,,prod,,,false
CRM_USER,UDM_EMAIL,NVARCHAR(256),Context,The email address of the user,,,,prod,,,false
CRM_USER,UDM_FULLNAME,NVARCHAR(256),Context,The full name of the user,,,,prod,,,false
CRM_USER,UDM_GLOBALID,NVARCHAR(64),Context,A global id which represents a cross-CRM id for this particular user,interactionContexts,udmcontextglobalid,,prod,,1to1,false
CRM_USER,UDM_ID,NVARCHAR(256),Primary Id,The id of this user according to the CRM,,,,prod,,,false
CRM_USER,UDM_ISDELETED,BOOLEAN,Context,A boolean indicating if this user has been deleted,,,,prod,,,false
CRM_USER,UDM_LASTMODIFIEDAT,TIMESTAMP,Context,The timestamp that this record was last modified by the system or a user,,,,prod,,,false
CRM_USER,UDM_MANAGERID,NVARCHAR(256),Context,The CRM's user id of the given user's manager,,,,prod,,,false
CRM_USER,UDM_PHONE,NVARCHAR(256),Context,The primary phone number for the user,,,,prod,,,false
CRM_USER,UDM_SYSTEMID,NVARCHAR(256),Context,The id of the CRM.  This is typically the organization id for any given CRM,,,,prod,,,false
CRM_USER,UDM_SYSTEMTYPE,NVARCHAR(256),Context,"The name of the CRM in which the account lives, such as Salesforce, Microsoft Dynamics, etc.",,,,prod,,,false
CRM_USER,UDM_TIMESTAMP,TIMESTAMP,Context,The timestamp that this record was last synced,,,,prod,,,false
CRM_USER,UDM_TITLE,NVARCHAR(256),Context,The user's title,,,,prod,,,false
CRM_PRODUCT,UDM_CREATEDAT,TIMESTAMP,Context,The timestamp that this product was created in the CRM,,,,prod,,,false
CRM_PRODUCT,UDM_FAMILY,NVARCHAR(256),Context,The product family that the product belongs to,,,,prod,,,false
CRM_PRODUCT,UDM_GLOBALID,NVARCHAR(64),Context,A global id which represents a cross-CRM id for this particular user,interactionContexts,udmcontextglobalid,,prod,,Nto1,false
CRM_PRODUCT,UDM_ID,NVARCHAR(256),Primary Id,The id of this product according to the CRM,,,,prod,,,false
CRM_PRODUCT,UDM_ISACTIVE,BOOLEAN,Context,A boolean indicating if this product is currently active,,,,prod,,,false
CRM_PRODUCT,UDM_ISDELETED,BOOLEAN,Context,A boolean indicating if this product has been deleted,,,,prod,,,false
CRM_PRODUCT,UDM_LASTMODIFIEDAT,TIMESTAMP,Context,The timestamp that this record was last modified by the system or a user,,,,prod,,,false
CRM_PRODUCT,UDM_NAME,NVARCHAR(256),Context,The name of the product,,,,prod,,,false
CRM_PRODUCT,UDM_SYSTEMID,NVARCHAR(256),Context,The id of the CRM.  This is typically the organization id for any given CRM,,,,prod,,,false
CRM_PRODUCT,UDM_SYSTEMTYPE,NVARCHAR(256),Context,"The name of the CRM in which the account lives, such as Salesforce, Microsoft Dynamics, etc.",,,,prod,,,false
CRM_PRODUCT,UDM_TIMESTAMP,TIMESTAMP,Context,The timestamp that this record was last synced,,,,prod,,,false
CRM_OPPORTUNITY,UDM_ACCOUNTID,NVARCHAR(256),Context,The id of the account according to the CRM that this opportunity belongs to,,,,prod,,,false
CRM_OPPORTUNITY,UDM_AMOUNT,FLOAT,Context,The amount of the opportunity,,,,prod,,,false
CRM_OPPORTUNITY,UDM_CLOSEDATE,TIMESTAMP,Context,The date the opportunity closed or is expected to close,,,,prod,,,false
CRM_OPPORTUNITY,UDM_CREATEDAT,TIMESTAMP,Context,The timestamp that this opportunity was created in the CRM,,,,prod,,,false
CRM_OPPORTUNITY,UDM_EXPECTEDREVENUE,FLOAT,Context,The expected amount of revenue for this opportunity according to the CRM,,,,prod,,,false
CRM_OPPORTUNITY,UDM_GLOBALID,NVARCHAR(64),Context,A global id which represents a cross-CRM id for this particular user,interactionContexts,udmcontextglobalid,,prod,,Nto1,false
CRM_OPPORTUNITY,UDM_ID,NVARCHAR(256),Primary Id,The id of this opportunity according to the CRM,,,,prod,,,false
CRM_OPPORTUNITY,UDM_ISCLOSED,BOOLEAN,Context,A boolean indicating if this opportunity is closed,,,,prod,,,false
CRM_OPPORTUNITY,UDM_ISDELETED,BOOLEAN,Context,A boolean indicating if this opportunity has been deleted,,,,prod,,,false
CRM_OPPORTUNITY,UDM_ISWON,BOOLEAN,Context,A boolean indicating if this opportunity is won,,,,prod,,,false
CRM_OPPORTUNITY,UDM_LASTMODIFIEDAT,TIMESTAMP,Context,The timestamp that this record was last modified by the system or a user,,,,prod,,,false
CRM_OPPORTUNITY,UDM_NAME,NVARCHAR(256),Context,The name of the opportunity,,,,prod,,,false
CRM_OPPORTUNITY,UDM_OWNEREMAIL,NVARCHAR(384),Context,The email address of the CRM user who owns this opportunity,,,,prod,,,false
CRM_OPPORTUNITY,UDM_OWNERFULLNAME,NVARCHAR(363),Context,The full name of the CRM user who owns this opportunity,,,,prod,,,false
CRM_OPPORTUNITY,UDM_OWNERID,NVARCHAR(256),Context,The external id of the CRM user who owns this opportunity,,,,prod,,,false
CRM_OPPORTUNITY,UDM_STAGENAME,NVARCHAR(256),Context,The name of the current sales stage of the opportunity,,,,prod,,,false
CRM_OPPORTUNITY,UDM_SYSTEMID,NVARCHAR(256),Context,The id of the CRM.  This is typically the organization id for any given CRM,,,,prod,,,false
CRM_OPPORTUNITY,UDM_SYSTEMTYPE,NVARCHAR(256),Context,"The name of the CRM in which the account lives, such as Salesforce, Microsoft Dynamics, etc.",,,,prod,,,false
CRM_OPPORTUNITY,UDM_TIMESTAMP,TIMESTAMP,Context,The timestamp that this record was last synced,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_HISTORYID,NVARCHAR(256),Context,The id of the history record and primary key for this table.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_ID,NVARCHAR(64),Primary Id,The id of this CRM contact.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_SYSTEMID,NVARCHAR(256),Context,The organization id of the CRM.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_SYSTEMTYPE,NVARCHAR(256),Context,"The name of the CRM, such as Salesforce, Microsoft Dynamics, etc.",,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_ACCOUNTID,NVARCHAR(256),Context,The id of the account this contact belongs to.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_ADDRESSCITY,NVARCHAR(256),Context,The city of the CRM contact.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_CREATEDAT,TIMESTAMP,Context,The timestamp that this CRM contact was created.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_ADDRESSCOUNTRY,NVARCHAR(256),Context,The country of the CRM contact.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_EMAIL,NVARCHAR(384),Context,The primary email address of the CRM contact.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_ADDRESSPOSTALCODE,NVARCHAR(256),Context,The postal code or zip code of the CRM contact.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_ISDELETED,BOOLEAN,Context,A boolean indicating if this CRM contact has been deleted.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_ADDRESSSTATEORPROVINCE,NVARCHAR(256),Context,The state or province of the CRM contact.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_LASTMODIFIEDAT,TIMESTAMP,Context,The timestamp that this record was last modified by the system or a user.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_ADDRESSSTREET,NVARCHAR(256),Context,The street address of the CRM contact.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_NAME,NVARCHAR(363),Context,The name of the CRM contact.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_OWNEREMAIL,NVARCHAR(384),Context,The email address of the user who owns this contact.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_OWNERFULLNAME,NVARCHAR(363),Context,The full name of the user who owns this contact.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_OWNERID,NVARCHAR(256),Context,The id of the user who owns this contact.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_TIMESTAMP,TIMESTAMP,Context,The timestamp that this record was last synced.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_TITLE,NVARCHAR(384),Context,The title of the CRM contact.,,,,prod,,,false
HISTORY_CRM_CONTACT,UDM_PHONE,NVARCHAR(256),Context,The primary phone number for this CRM contact.,,,,prod,,,false