Activity and automation

Intelligent Agent Objects data set: columns, keys and joins

Primary key: AgentId 23 columns

Checked against D2L on October 31, 2026

Columns

Column	Type	Size	Key
`AgentId`	`bigint`	`8`	PK
`OrgUnitId`	`int`	`4`	FK
`AgentName`	`nvarchar`	`128`
`Description`	`nvarchar`	`1000`
`Enabled`	`bit`	`1`
`SpecificRoles`	`nvarchar`	`1000`
`LoginConditionEnabled`	`bit`	`1`
`LoginConditionThreshold`	`int`	`4`
`LoginConditionType`	`nvarchar`	`14`
`AccessConditionEnabled`	`bit`	`1`
`AccessConditionThreshold`	`int`	`4`
`AccessConditionType`	`nvarchar`	`20`
`ResultId`	`bigint`	`8`	FK
`RepeatType`	`nvarchar`	`10`
`EmailWhenSatisfied`	`bit`	`1`
`EnableSchedule`	`bit`	`1`
`ScheduleType`	`nvarchar`	`10`
`ScheduleRepeatsEvery`	`int`	`4`
`StartDate`	`datetime2`	`8`
`EndDate`	`datetime2`	`8`
`LastModified`	`datetime2`	`8`
`LastModifiedBy`	`int`	`4`	FK
`IsDeleted`	`bit`	`1`