Global Upload

RPT_AE_GUActivity

GlobalListID

GlobalListID

int

(not null)

The list ID generated by the application for each list placed for global upload.

RPT_AE_GUActivity

GlobalFileName

GlobalFileName

nvarchar

(1024) (null)

The name of contacts files placed for upload.

RPT_AE_GUActivity

Status

Status

nvarchar

(16) (not null)

The status of the upload file - Success, Error, and so on.

RPT_AE_GUActivity

ProcessedTime

ProcessedTime

datetime

(not null)

The date and time the contact file was taken up for processing.

RPT_AE_GUActivity

ErrorDescription

ErrorDescription

nvarchar

(max) (null)

The description of the error, in case of contacts that are not uploaded. For example, failed.

RPT_AE_GUActivity

TotalRecords

TotalRecords

bigint

(null)

The total number of records in the uploaded from the contact list.

RPT_AE_GUActivity

BadRecords

BadRecords

bigint

(null)

The number of bad records – the records that failed to upload – from the contact list.

RPT_AE_GUActivity

UnmatchedRecords

UnmatchedRecords

bigint

(null)

The total number of records that could not be uploaded to any campaign, that is, remained unmatched.

RPT_AE_GUActivity

CampaignLevelRecords

CampaignLevelRecords

nvarchar

(max) (null)

The total number of records uploaded to each campaign via this upload.

RPT_AE_GUActivity

UploadedFileName

UploadedFileName

nvarchar

(700) (null)

The name of the file placed for upload.

RPT_AE_GUActivity

ListStatus

ListStatus

nvarchar

(16) (null)

The status of the List - Success, Failure, Error, and so on.

RPT_AE_GUActivity

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.

RPT_AE_GUActivity

SubTenantID

SubTenantID

int

(null)

The Sub Tenant ID autogenerated by the application when a new tenant is created.

RPT_AE_UploadHistory

UploadTime

UploadTime

datetime

(null)

The date and time a contact was uploaded.

RPT_AE_UploadHistory

TotalContactsProcessed

TotalContactsProcessed

int

(null)

The total number of contacts processed for upload.

RPT_AE_UploadHistory

ContactsUploaded

ContactsUploaded

int

(null)

The total number of contacts uploaded to various campaigns.

RPT_AE_UploadHistory

ContactFailedToUpload

ContactFailedToUpload

int

(null)

The total number of contacts that failed, and not uploaded to any campaign.

RPT_AE_UploadHistory

DuplicateContacts

DuplicateContacts

int

(null)

The total number of duplicate contacts.

RPT_AE_UploadHistory

ContactsBlockedInNDNC

ContactsBlockedInNDNC

int

(null)

The total number of contacts blocked by the National Do Not Call configuration.

RPT_AE_UploadHistory

ContactsBlockedInCorporateDNC

ContactsBlockedInCorporateDNC

int

(null)

The total number of contacts blocked by this enterprise under the Do Not Call configuration.

RPT_AE_UploadHistory

ModesBlockedInNDNC

ModesBlockedInNDNC

int

(null)

The modes blocked for contact upload due to a Do Not Call configuration.

RPT_AE_UploadHistory

ModesBlockedInCorporateDNC

ModesBlockedInCorporateDNC

int

(null)

The modes blocked for contact upload by an enterprise due to a Do Not Call configuration.

RPT_AE_UploadHistory

UpdatedContacts

UpdatedContacts

int

(null)

The number of contacts that were updated using the upload functionality.

RPT_AE_UploadHistory

UploadType

UploadType

varchar

(17) (not null)

The upload type such as JSON, API, and so on.

RPT_AE_UploadHistory

UploadSubType

UploadSubType

varchar

(26) (not null)

The upload subtype. The values are N for a new file, U for update an already available file, and C if it is a copy of another file.

RPT_AE_UploadHistory

LastAccessed

LastAccessed

datetime

(null)

The date and time the table was last modified.

RPT_AE_UploadHistory

ChildListID

ChildListID

int

(null)

The child list ID auto-generated by the application for this list.

RPT_AE_UploadHistory

ModeBlockedInComplianceDNC

ModeBlockedInComplianceDNC

int

(null)

The modes that are blocked by DNC requirements.

RPT_AE_UploadHistory

ContactBlockedInComplianceDNC

ContactBlockedInComplianceDNC

int

(null)

The modes that are blocked by NDNC requirements.

RPT_AE_UploadHistory

ModeBlockedInComplianceLitigation

ModeBlockedInComplianceLitigation

int

(null)

The modes that are blocked by Litigation requirements.

RPT_AE_UploadHistory

ContactBlockedInComplianceLitigation

ContactBlockedInComplianceLitigation

int

(null)

The number of contacts that are blocked by Litigation requirements.

RPT_AE_UploadHistory

SourceDetails

SourceDetails

nvarchar

(512) (null)

The upload file source.

RPT_AE_UploadHistory

ProfileName

ProfileName

nvarchar

(512) (null)

The Profile through which the contacts were uploaded.

RPT_AE_UploadHistory

UpdatedListID

UpdatedListID

nvarchar

(null)

The updated list ID generated by the application.

RPT_AE_UploadHistory

UploadedDuration

UploadedDuration

time

(7) (null)

The time taken by the application to complete uploading the list.

RPT_AE_UploadHistory

RPT_AE_UploadHistory