List Upload
- DarkLight
List Upload
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Source Table | Column Name | Display Name | Data Type | Description | Platform |
|---|---|---|---|---|---|
RPT_AE_ListInfo | LISTTYPE | LISTTYPE | nvarchar (10) (null) | The list type. Defines if it is upload via an API or via a file. | All |
RPT_AE_ListInfo | LISTID | LISTID | int (null) | The List ID auto-generated by the application for this list. | All |
RPT_AE_ListInfo | STARTTIME | STARTTIME | datetime (null) | The date and time the list started uploading. | All |
RPT_AE_ListInfo | ENDTIME | ENDTIME | datetime (null) | The date and time the list completed uploading. | All |
RPT_AE_ListInfo | RECORDSINSERTED | RECORDSINSERTED | bigint (null) | The number of records uploaded from this list. | All |
RPT_AE_ListInfo | RECORDSFAILED | RECORDSFAILED | bigint (null) | The number of records that failed to upload from this list. | All |
RPT_AE_ListInfo | RECORDSDNC | RECORDSDNC | bigint (null) | The number of DNC records from this list. | All |
RPT_AE_ListInfo | RecordsDuplicated | RecordsDuplicated | bigint (null) | The number of duplicate records from this list. | All |
RPT_AE_ListInfo | RECORDSSCRUBBED | RECORDSSCRUBBED | bigint (null) | The number of contacts scrubbed from this list | All |
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. | All |
RPT_AE_ListInfo | USERID | USERID | nvarchar (50) (null) | The name of the user who uploaded the contacts. | All |
RPT_AE_ListInfo | LOCATION | LOCATION | nvarchar (32) (null) | The location where the file to be processed is placed. | All |
RPT_AE_ListInfo | RECORDSMOVED | RECORDSMOVED | bigint (null) | The number of records moved from this list. | All |
RPT_AE_ListInfo | ListStopFlag | ListStopFlag | bit (null) | The flag to indicate if the list is in a stopped state. | All |
RPT_AE_ListInfo | ListStartDate | ListStartDate | datetime (null) | The date and time that contacts from this list commenced upload to campaigns. | All |
RPT_AE_ListInfo | ListStopDate | ListStopDate | datetime (null) | The date and time that the list was stopped. | All |
RPT_AE_ListInfo | GlobalListID | GlobalListID | bigint (null) | The list ID generated by the application for each list placed for global upload. | All |
RPT_AE_ListInfo | ListStatus | ListStatus | int (null) | The status of the List such as Success, Failure, Error, and so on. | All |
RPT_AE_ListInfo | ListProcessingDate | ListProcessingDate | datetime (null) | The date and time the contact file was taken up for processing. | All |
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. | All |
RPT_AE_ListInfo | TTLBusinessDays | TTLBusinessDays | bit (null) | The flag to indicate if the Time To Live for the list is calculated by Business Days. | All |
RPT_AE_ListInfo | TotalRecordsGoingToProcessed | TotalRecordsGoingToProcessed | int (null) | The total number of records process for upload. | All |
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. | All |
RPT_AE_ListInfo | TenantID | TenantID | int (null) | The Tenant ID auto-generated by the application when a new tenant is created. | All |
RPT_AE_ListInfo | SubTenantID | SubTenantID | int (null) | The Sub Tenant ID autogenerated by the application when a new tenant is created. | All |
RPT_AE_UploadHistory | UploadType | UploadType | varchar (17) (not null) | The upload type such as JSON, API, and so on. | All |
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. | All |
RPT_AE_UploadHistory | LastAccessed | LastAccessed | datetime (null) | The date and time the table was last modified. | All |
RPT_AE_UploadHistory | ChildListID | ChildListID | int (null) | The child list ID auto-generated by the application for this list. | All |
RPT_AE_UploadHistory | ModeBlockedInComplianceDNC | ModeBlockedInComplianceDNC | int (null) | The modes that are blocked by DNC requirements. | All |
RPT_AE_UploadHistory | ContactBlockedInComplianceDNC | ContactBlockedInComplianceDNC | int (null) | The modes that are blocked by NDNC requirements. | All |
RPT_AE_UploadHistory | ModeBlockedInComplianceLitigation | ModeBlockedInComplianceLitigation | int (null) | The modes that are blocked by Litigation requirements. | All |
RPT_AE_UploadHistory | ContactBlockedInComplianceLitigation | ContactBlockedInComplianceLitigation | int (null) | The number of contacts that are blocked by Litigation requirements. | All |
RPT_AE_UploadHistory | SourceDetails | SourceDetails | nvarchar (512) (null) | The upload file name with extension. | All |
RPT_AE_UploadHistory | ProfileName | ProfileName | nvarchar (512) (null) | The Profile through which the contacts were uploaded. | All |
RPT_AE_UploadHistory | UpdatedListID | UpdatedListID | int (null) | The updated list ID generated by the application. | All |
RPT_AE_UploadHistory | UploadedDuration | UploadedDuration | int (7) (null) | The time taken by the application to complete uploading of the list. | All |
Was this article helpful?