Catalogue Forecast
Content
Documentation for Catalogue Forecast
Declaration of schema elements
Provider Column
ContentType Column
ExternalId Column
Title Column
Parental Title Id Column
Episode_Number Column
Season_External_Id Column
Season_Title Column
Season_Number Column
Season_Episodes_Number Column
Serie_External_Id Column
Serie_Title Column
Serie_Seasons_Number Column
Period_Start Column
Period_End Column
Expiry_Date Column
Brand Column
Priority Column
All_Language Column
All_Subtitle Column
Full example
Change tracking
|
Version
|
Modification Date
|
Change reason
|
1.0
|
04/03/2024
|
First version.
|
Documentation for Catalog Forecast loads
Declaration of schema elements
The following sections represent each of the columns that must be included in the data schema. Each element includes a brief description of the expected data, the most relevant information, and any specific conditions where necessary. The field names and the order in which they appear must be respected. All columns must appear together, with no other columns separating them. For further details, we recommend consulting the sample file.
Provider Column
Element Description
This is a mandatory element and specifies the provider name. It must match the value set at the "catalog" attribute at the VOD-CatchUp XML upload file.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
------------------------------------------------------------------------------------------
PROVIDER | Alphanumeric | 6 | Yes
Sample
MOV +
Content_Type Column
Element Description
The ContentType element informs the type of content, among the five possible values listed. It can be: episode, title, trailer, extra or preview (video preview). The content type is a mandatory element.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
--------------------------------------------------------------------------------------------
CONTENT_TYPE | Alphanumeric (fixed values) | 7 | Yes
XML Sample
title
Expected Values
episode
title
trailer
extra
preview
External_Id Column
Element Description
This element indicates the unique content Identifier at the external provider's system. It must be the same value as the one specified in the <ExternalId> element for the VOD-Catchup XML files. It is a required text field and is allowed up to 50 characters.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
------------------------------------------------------------------------------------------
EXTERNAL_ID | Alphanumeric | 50 | Yes
Sample
A0064201001TRL3_PFMORGP2P
Title Column
Element Description
This element allows defining a title for contents, series and additional materials. It is mandatory and it cannot exceed 100 characters.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
------------------------------------------------------------------------------------------
TITLE | Alphanumeric | 100 | Yes
Sample
La infiltrada
Parental Title Id Column
Element Description
This element is mandatory only for trailers, extras and video previews. In it can be specified the External ID of the content to which the additional material is associated.
Note that the column name does not have the "_" character.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-------------------------------------------------------------------------------------------------------
PARENTAL TITLE ID | Alphanumeric | 50 | Only for 'episode'
Sample
A006420100101
Episode_Number Column
Element Description
This element indicates the episode number, for season elements (ContentType equal to 'episode'). It must be a positive integer. It is an optional element.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-------------------------------------------------------------------------------------------------------
EPISODE_NUMBER | Numeric positive | 5 | Only for 'episode'
Sample
1
Season_External_Id Column
Element Description
This element must only be reported for elements with 'episode' content type and, only in this case, it is mandatory. It indicates the identifier of the season to which the episode is associated.
Must match the value assigned in the <SeriesRef> element of the VOD-CatchUp upload XML.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-------------------------------------------------------------------------------------------------------
SEASON_EXTERNAL_ID | Alphanumeric | 50 | Only for 'episode'
Sample
A0026501_ORG
Season_Title Column
Element Description
Applies only to elements with 'episode' conten type, in which case it is mandatory. This field specifies the title of the season to which the episode belongs. It cannot exceed 100 characters.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-------------------------------------------------------------------------------------------------------
SEASON_TITLE | Alphanumeric | 100 | Only for 'episode'
Sample
Rapa - T2
Season_Number Column
Element Description
Mandatory only for elements with 'episode' content type, it is the season number to which the detailed episode belongs. It must be a positive integer value.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-------------------------------------------------------------------------------------------------------
SEASON_NUMBER | Numeric positive | 5 | Only for 'episode'
Sample
1
Season_Episodes_Number Column
Element Description
This element is mandatory only for 'episode' content type elements. This element indicates the total number of episodes of the season to which the episode is associated. A positive integer must be entered.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-------------------------------------------------------------------------------------------------------
SEASON_EPISODES_NUMBER | Numeric positive | 5 | Only for 'episode'
Sample
10
Serie_External_Id Column
Element Description
This is an element that is only mandatory when the content type is 'episode'. It indicates the External ID of the supra-content to which the episode belongs. It must match que value set at the <SupraRef> element for the episode at the VOD-CatchUp XML updload file.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-------------------------------------------------------------------------------------------------------
SERIE_EXTERNAL_ID | Alphanumeric | 50 | Only for 'episode'
Sample
A00265_ORG
Serie_Title Colum
Element Description
This is a mandatory element for 'episode' content type . It must be set whith the title of the supra-content to which the episode belongs. It cannot exceed 100 characters.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-------------------------------------------------------------------------------------------------------
SERIE_TITLE | Alphanumeric | 100 | Only for 'episode'
Sample
Rapa
Serie_Seasons_Number Column
Element Description
This element applies only for 'episode' content type contents. Its value will be set when available. It informs the total number of seasons of the supra-content to which the episode belongs.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-------------------------------------------------------------------------------------------------------
SERIE_SEASONS_NUMBER | Numeric positive | 5 | No
Sample
6
Period_Start Column
Element Description
This element allows defining the start date of the range in which a content will be published. This is a mandatory element. It is recommended to use dates/times with UTC reference (GMT+0).
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-----------------------------------------------------------------------------------------------
PERIOD_START | Datetime | N/A | Yes
Sample
2025-05-01 T16:00:00Z
Period_End Column
Element Description
This element allows defining the end date of the range in which a content will be published. It is recommended to use dates/times with UTC reference (GMT+0). It is an optional element.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-----------------------------------------------------------------------------------------------
PERIOD_END | Datetime | N/A | No
Sample
2025-06-15 T16:00:00Z
Expiry_Date Column
Element Description
It is the maximum rights date allowed for the content. This is an optional element. Both the start and end date of the section must be less than this date, if it is reported. It is recommended to use dates/times with UTC reference (GMT+0).
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-----------------------------------------------------------------------------------------------
EXPIRY_DATE | Datetime | N/A | No
Sample
2025-12-15 T16:00:00Z
Brand Column
Element Description
This column informs the brand of the content. It is an optional element.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-----------------------------------------------------------------------------------------------
BRAND | Alphanumeric | 100 | No
Sample
Originales
Priority Column
Element Description
The Priority element is used to set the importance of the content within the month. It is an optional data and must be an integer and positive numeric type.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-----------------------------------------------------------------------------------------------
PRIORITY | Numeric positive
| 5 | No
Sample
7
All_Language Column
Element Description
The AllLanguage element is used to set all the available audio languages for the content. The ISO 639-2 standard should be used for this purpose,
http://www.loc.gov/standards/iso639-2/php/English_list.php. If there is more than one language available, the values should be concatenated with a semicolon (“;”). Audio information is optional.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
------------------------------------------------------------------------------------------------
ALL_LANGUAGE | Alphanumeric | 4000 | No
Sample
spa;eng;ADS
All_Subtitle Column
Element Description
The AllSubtitle element is used to set all the available subtitle languages for the content. The ISO 639-2 standard should be used for this purpose,
http://www.loc.gov/standards/iso639-2/php/English_list.php. If there is more than one subtitle, the values will be concatenated with semicolon (“;”). The subtitle information is optional.
Summary
COLUMN NAME | DATA TYPE | MAX. LENGTH ALLOWED | MANDATORY
-----------------------------------------------------------------------------------------------
ALL_SUBTITLE | Alphanumeric | 4000 | No
Sample
spa;fra;SRD
