Interaction Administrator License Attribute Log View
This view captures the changes made for a user or a workstation license attribute.
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| IALicenseAttributeLogId | int (4) | False | No | Unique ID for the license change. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| EnhancedIAChangeLogId | int (4) | False | No | Foreign key to the IAChangeLog table. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| License | smallint (2) | False | No | The ID of the license. This corresponds to the ID found in the IALicenseLookup table. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| IsAssignable | bit (1) | False | No | If the license allocation method for the given IAChangeLog entry key is assignable or concurrent. A value of 1 in this column means assignable and 0 is concurrent. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| IsActive | bit (1) | False | No | If the licenses are enabled for the given IAChangeLog entry key. 1 means enabled and 0 means disabled |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| CallCallback | bit (1) | False | No | Field used to denote if call/callback is selected as the ACD media type. Only valid for ACD Media 2 and ACD Media 3 licenses |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| Chat | bit (1) | False | No | Field used to denote if chat is selected as the ACD media type. Only valid for ACD Media 2 and ACD Media 3 licenses. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| bit (1) | False | No | Field used to denote if chat is selected as the ACD media type. Only valid for ACD Media 2 and ACD Media 3 licenses. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. | |
| Generic | bit (1) | False | No | Field used to denote if generic is selected as the ACD media type. Only valid for ACD Media 2 and ACD Media 3 licenses. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| ChangeDateTimeGMT | datetime (8) | False | No | Greenwich Mean Time for when the change was made. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| SiteId | smallint (2) | False | No | Site ID |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| IALICENSEATTRIBUTELOGID | number (22) | False | No | Unique ID for the license change. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| ENHANCEDIACHANGELOGID | number (22) | False | No | Foreign key to the IAChangeLog table. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| LICENSE | number (22) | False | No | The ID of the license. This corresponds to the ID found in the IALicenseLookup table. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| ISASSIGNABLE | number (22) | False | No | If the license allocation method for the given IAChangeLog entry key is assignable or concurrent. A value of 1 in this column means assignable and 0 is concurrent. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| ISACTIVE | number (22) | False | No | If the licenses are enabled for the given IAChangeLog entry key. 1 means enabled and 0 means disabled |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| CALLCALLBACK | number (22) | False | No | Field used to denote if call/callback is selected as the ACD media type. Only valid for ACD Media 2 and ACD Media 3 licenses |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| CHAT | number (22) | False | No | Field used to denote if chat is selected as the ACD media type. Only valid for ACD Media 2 and ACD Media 3 licenses. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| number (22) | False | No | Field used to denote if chat is selected as the ACD media type. Only valid for ACD Media 2 and ACD Media 3 licenses. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. | |
| GENERIC | number (22) | False | No | Field used to denote if generic is selected as the ACD media type. Only valid for ACD Media 2 and ACD Media 3 licenses. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| CHANGEDATETIMEGMT | timestamp | False | No | Greenwich Mean Time for when the change was made. |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |
| SITEID | number (22) | False | No | Site ID |
17.4.0.0 | Added for data extraction from IALicenseAttributeLog table. |