| Variable | Data type | Comment | |
|---|---|---|---|
| 1 | MediaCompany | Integer | See table 7.1. Media Company ID |
Kantar ID | Numeric | ||
Content name | Alphanumeric id | ||
Title code | Numeric, links to TITLES table | ||
Description code | Numeric, links to DESCRIPTIONS table | ||
Duration | Content duration (seconds) | ||
First linear date | dd/mm/yyyy | ||
First linear channel | Alphanumeric | ||
Season | Numeric | ||
Episode | Numeric | ||
Start date | First date content is available | ||
End date | Last date content is available | ||
Content code | Numeric | ||
| 2 | ID | Integer | |
| 3 | ContentName | String | |
| 4 | CodTitle | Integer | |
| 5 | CodDescription | Integer | |
| 6 | Duration | Integer | Seconds |
| 7 | firstLinearDate | Date | yyyymmdd |
| 8 | firstLinearChannel | Integer | |
| 9 | Season | Integer | |
| 10 | Episode | Integer | |
| 11 | StartDate | Date | yyyymmdd. First date content is available (firstOnDemandDate) |
| 12 | EndDate | Date | yyyymmdd. Last date content is available |
| 13 | ContentID | Integer | Internal id (KantarId) |
| 14 | BroadcasterContentID | String | Alphanumeric id provided by the broadcaster |
| 15 | AlternativeTitle1 | String | Alphanumeric |
| 16 | AlternativeTitle2 | String | Alphanumeric |
| 17 | Additional1 | String | Alphanumeric |
| 18 | Additional2 | String | Alphanumeric |
| 19 | Additional3 | String | Alphanumeric |
| 20 | Additional4 | String | Alphanumeric |
| 21 | BaseChannel | Integer | Numeric, links to station ID tableto 2.1 Station ID |
| 22 | _LoadOp_ | Integer | Only for .update-files: 1 = add, 2 = delete, 3 = modify |
...