Expand All Collapse All

IPA_Jobs Table

  • Table Type - Historical
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
JobExecID uniqueidentifier False Unknown

4.0.106.453 4.0 Release Job Execution ID Attribute Interaction Process Automation
StartDateTime datetime2 False Unknown

4.0.106.453 4.0 Release Start Date Time Attribute Interaction Process Automation
StartDateTimeOffset int False Unknown

4.0.106.453 4.0 Release Start Date Time Offset Fact Interaction Process Automation
EndDateTime datetime2 True Unknown

4.0.106.453 4.0 Release End Date Time Attribute Interaction Process Automation
EndDateTimeOffset int True Unknown

4.0.106.453 4.0 Release End Date Time Offset Fact Interaction Process Automation
SiteID smallint False Unknown

4.0.106.453 4.0 Release Site ID Attribute Interaction Process Automation
Version int False Unknown

4.0.106.453 4.0 Release Version Fact Interaction Process Automation

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IPA_Jobs Clustered JobExecID (Ascending)