List Upload
    • Dark
      Light

    List Upload

    • Dark
      Light

    Article summary

    Source Table

    Column Name

    Display Name

    Data Type

    Description

    Cisco CCE

    WxCC

    Amazon Connect

    Amazon SCV

    Twilio Flex

    UJET

    Cisco CCX

    Five9 VCC

    RPT_AE_ListInfo

    LISTTYPE

    LISTTYPE

    nvarchar

    (10) (null)

    The list type. Defines if it is upload via an API or via a file.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    LISTID

    LISTID

    int

    (null)

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

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    STARTTIME

    STARTTIME

    datetime

    (null)

    The date and time the list started uploading.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    ENDTIME

    ENDTIME

    datetime

    (null)

    The date and time the list completed uploading.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    RECORDSINSERTED

    RECORDSINSERTED

    bigint

    (null)

    The number of records uploaded from this list.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    RECORDSFAILED

    RECORDSFAILED

    bigint

    (null)

    The number of records that failed to upload from this list.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    RECORDSDNC

    RECORDSDNC

    bigint

    (null)

    The number of DNC records from this list.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    RecordsDuplicated

    RecordsDuplicated

    bigint

    (null)

    The number of duplicate records from this list.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    RECORDSSCRUBBED

    RECORDSSCRUBBED

    bigint

    (null)

    The number of contacts scrubbed from this list.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    SOURCETYPE

    SOURCETYPE

    nvarchar

    (18) (not null)

    The file source type. Some values are W for Web, M for Media, F for File, and L for List.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    USERID

    USERID

    nvarchar

    (50) (null)

    The name of the user who uploaded the contacts.

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️

    ✖️

    ✖️

    ✖️

    RPT_AE_ListInfo

    LOCATION

    LOCATION

    nvarchar

    (32) (null)

    The location where the file to be processed is placed.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    RECORDSMOVED

    RECORDSMOVED

    bigint

    (null)

    The number of records moved from this list.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    ListStopFlag

    ListStopFlag

    bit

    (null)

    The flag to indicate if the list is in a stopped state.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    ListStartDate

    ListStartDate

    datetime

    (null)

    The date and time that contacts from this list commenced upload to campaigns.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    ListStopDate

    ListStopDate

    datetime

    (null)

    The date and time that the list was stopped.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    GlobalListID

    GlobalListID

    bigint

    (null)

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

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    ListStatus

    ListStatus

    int

    (null)

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

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    ListProcessingDate

    ListProcessingDate

    datetime

    (null)

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

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    ListTimeToLive

    ListTimeToLive

    int

    (null)

    The number of days the list is live before contacts can no longer be uploaded from this list.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    TTLBusinessDays

    TTLBusinessDays

    bit

    (null)

    The flag to indicate if the Time To Live for the list is calculated by Business Days.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    TotalRecordsGoingToProcessed

    TotalRecordsGoingToProcessed

    int

    (null)

    The total number of records process for upload.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    UniqueTimeZone

    UniqueTimeZone

    nvarchar

    (128) (null)

    This defines if the list is uploaded with a unique time zone. The contacts are processed as per the contact time zone.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    TenantID

    TenantID

    int

    (null)

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

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_ListInfo

    SubTenantID

    SubTenantID

    int

    (null)

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

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    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 number of contacts that are blocked by DNC 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 name with extension.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_UploadHistory

    ProfileName

    ProfileName

    nvarchar

    (512) (null)

    The Profile through which the contacts were uploaded.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_UploadHistory

    UpdatedListID

    UpdatedListID

    int

    (null)

    The updated list ID generated by the application.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_UploadHistory

    UploadedDuration

    UploadedDuration

    int

    (7) (null)

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

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    RPT_AE_UploadHistory

    Campaign ID

    Campaign ID

    The campaign ID from which the list was uploaded.

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️

    ✔️


    Was this article helpful?

    What's Next
    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.
    ESC

    Eddy AI, facilitating knowledge discovery through conversational intelligence