--- schema_version: "1" id: 287a1ebf8211b1297eaf1c2898508113dcac1d14d7ef189e44e8b84eda02f3a8 title: "Data View: Reconcilable Disposition" collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_as_data_view_reconcilable_disposition.md canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_reconcilable_disposition.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 4825b5d8500b77b67b91111aaf777d53a22855ec826a252418d6b55d376a334f description: To view reconciliation disposition data for emails sent from your account, query the _ReconcilableDispositionView data view in Automation Studio. Data is retained for seven days. products: - Marketing - Marketing Cloud Engagement release: "264" --- # Data View: Reconcilable Disposition To view reconciliation disposition data for emails sent from your account, query the \_ReconcilableDispositionView data view in Automation Studio. Data is retained for seven days. ## Columns
Name Description Data Type Data Extension Data Type Nullable
JobId Unique identifier for the job. NVARCHAR(100) Text No
Channel

Channel Identifier

  • 0 - Email
  • 1 - SMS
  • 3 - Omni
  • 4 - Push
 BYTE Number No
Disposition

Disposition status for the subscriber.

  • 1 - Sent. Indicates that Marketing Cloud Engagement successfully handed the message off to the mail servers. It doesn't indicate inbox delivery or email address validation.
  • 2 - NotSent. Indicates that the message failed to hand off to the delivery system. This status applies to messages that expired in the queue or encountered an internal system failure.
 BYTE Number No
MessageKey

Message key used to reconcile message disposition from Marketing Cloud Engagement with external systems.

 NVARCHAR(100) Text No
SubscriberKey

Key that uniquely identifies the recipient within the MID.

 NVARCHAR(100) Text Yes
SubscriberId

Unique subscriber ID for the recipient. This value can be NULL if the intended subscriber was invalid.

 BIGINT

Number

 Yes
ErrorCodeId Error code ID returned when the message wasn’t sent to the subscriber. INT   Yes
ExpirationTime Timestamp when the message is considered expired by the system. DATETIME   No
ErrorName The name of the error returned when the message wasn’t sent to the subscriber. NVARCHAR(256)   No
StartTime

Timestamp when processing of the message began.

For data extension-based sends, this value represents when the job was originally scheduled to start.

For LLTS-based sends, this value represents when the API received the message.

 DATETIME