MovieLab
Avails
 

Excel Avails Change Log

This site contains a change log for the Avails spreadsheet.

Spreadsheet v1.7.1

v.1.7.1 (January 12, 2017)

 

This version includes the following changes that only impact TV:

  • Added NGAudio column (was correct in Movies and Data Dictionary)
  • Added PriceCurrency column (was correct in Movies and Data Dictionary)
  • Changed ExceptionsFlag to ExceptionFlag (no 's') to be consistent with Movies
  • Changed mapping note in Data Dictionary for AllowedLanguage and HoldbackLanguage to be consistent with Movie 

Spreadsheet v1.7

v1.7 (November 15, 2016)

 

Change Fields Excel 1.7 Movies Excel 1.7 TV XML v2.2 Excel Field Required/Optional Notes
Date and Time precision Start, End Change Change NC (no change) Required Add ability to specify time in Start and End (ISO format).  Clarified time associated with Start and End
AnnounceDate added AnnounceDate Add Add NC Optional Added announcement date for title visibility in pre-order
Add currency PriceCurrency Add Add NC Optional PriceCurrency added to reflect currency of PriceValue.  Already in XML.
DMRP, SMRP,  License Fee, Season Only PriceType Add Add Add Required DMRP added for Deemed Minimum Retail Price. Added SMRP for Suggested Minimum Retail Price.  Added "License Fee"
Added "Season Only" for season bonus
SRP as Term PriceType Remove Remove NC Required "SRP" was a valid value for PriceType, even though there's an SRP column.  Not an issue in XML
MediaProfile FormatProfile Change Change Change Required Format profiles limited to SD, HD, UHD, 3D, 3DSD, 3DHD, 3DUHD
Media Profile attributes HDR, WCG, HFR Add Add Add Optional True/False.  See MediaProfile for UHD value. HDR can be enumerated to DV and HDR10.
Next Gen audio NGAudio Add Add Add Optional True/False or audio format ("Atmos", "DTS:X", "Auro3D")
Entitlement IDs UV_ID, DMA_ID Add Add NC Optional Added columns and description.  Full support in XML.
Reporting ID ReportingID Add Add Add Optional Added ReportingID for future use
AltID now ALID AltID Change Change NC Required Changed AltID to ALID and updated definition.  See notes below.
TV ALID ALID N/A Add NC Required ALID added to TV.  Depending on avail, either episode or season ID gets repeated here.
ContentID now TitleID ContentID Change Change NC Optional Changed ContentID to TitleID and updated definition; typically EIDR Abstraction (llevel 1). Not an issue in XML
ProductID now EditID ProductID Change Change NC Optional Changed ProductID to EditID and updated definition; typically EIDR edit (level 2). Not an issue in XML
EncodeID now ContentID EncodeID, SeasonEncodeID Change Change NC Required Changed EncodeID with ContentID and defined.  Used as metadata reference. Not an issue in XML
SeasonContentID, EpisodeContentID SeasonContentID, EpisodeContentID N/A Change NC Required Season Content ID is required for episode and season avails.  EpisodeContentID required for episode avails.
EpisodeProductID, EncodeID EpisodeProductID, EncodeID N/A Remove N/A Optional Removed EpisodeProductID and EncodeID
AllowedLanguages HoldbackExclusionLanguage Change Change Change Optional Changed HoldbackExclusionLanguage to Allowed Languages.  XML supports distinct subs/dubs.  
AssetLanguage StoreLanguage Change Change Change Optional Changed StoreLanguage to AssetLanguage.  XML supports distinct subs/dubs and descriptive audio. 
sub and dub holdback HoldbackLanguage Not supported Not supported Change Optional Added ability to specify whether holdback applies to sub, dub or both.
Bundles Bundle ALIDs Add NC Add Optional Add bundle support.  Simple in Excel, full in XML
Excel Delivery N/A Change Change N/A Required 1) Files delivered in .xlsx format,
2) one tab per file,
3) matching performed on rows 1-2 (not column),
4) row 3 must be present but contain no avail data. 
Bonus and Promotion XML N/A N/A Add Optional Full support for availing promotion and supplemental (e.g., controlled windows for specific offerings).
Additional metadata for seasons and series XML N/A N/A Add Optional Added ratings, release history and captions exceptions to season and series metadata.
LicenseRightsDescription LicenseRightsDescription change change Change Optional There was no agreement about LRD beyond the 'Next Day TV' label and "POD" (Publish on Delivery).  Non-standard values can be used bilaterally.  The field remains optional, but can be made mandatory by bilateral agreement.
CompanyDisplayCredit CompanyDisplayCredit Add NC NC Optional Added CompanyDisplayCredit to movies
EpisodeTitleInternalAlias required EpisodeTitleInternalAlias N/A Change N/A Required Applicable TitleInternalAlias are always required.  This is required for episodes.

Spreadsheet v1.6

v1.6e2

  • Changed B3 to correct description
  • Changed "Tier as integer" to "Tier as number" since the tier can include decimals

v1.6e1

  • Editorial update: changed row 3 to wrap text

v1.6e

  • Editorial update: spec version

v1.6d.1

  • Change log
    • General
      • throughout doc, updated the use of “version” to “edit” in multiple instances when referring to edits of a movie. Purpose: to be consistent with terminology of “Edit EIDR” usage.
  • Per tab
    • Movies Data Dictionary
      • Territory: Added link to ISO country codes: https://www.iso.org/obp/ui/#search to header and dictionary
      • EntryType: Changed language and added information about Full Extract and Full Delete. Added the following:
        • "Full Extract" - means that all avail entries provided for an edit of a movie (e.g., Theatrical and Director's Cut are two different edits) within a territory should overwrite all previous avail entries for that edit within that territory. “Full Extract” should include all known current and future avails for an edit within a territory.
        • "Full Delete” - means all rights to an edit within a territory are lost. The studio would provide "Full Delete" and that would remove all avail entries for that edit within that territory.
      • Any additional instructions: added “such as studio information for either studio page collections or channel collections.”
      • SpecialPreOrderFulfillDate: Changed definition in header to match data dictionary definition - “Optional for preorders. Should be blank for all other license types. The date that a pre-ordered video can be released to the consumer for viewing *if* different from the earliest EST start date.”
    • TV & TV Data Dictionary
      • Added example of a French version of a full season, including localized titles.
      • StoreLanguage: removed [RFC5646] from the header definition since it was redundant information.
      • ExceptionFlag - changed to “ExceptionsFlag” as stated in XML and spec.
      • EncodeID - Corrected the Excel header definition to, “Encode Identifier. This should be the Encode Level EIDR.”
      • CaptionIncluded - added “Non-US territories may be left blank.”
      • Territory. Added link to ISO country codes: https://www.iso.org/obp/ui/#search to header and dictionary
      • Corrected “ComapnyDisplayCredits” to  “CompanyDisplayCredit” in TV Data Dictionary and column.
      • Added TV specific examples for RatingSystem and RatingSystem values.
    • General Instructions and FAQ