7. CONTENTS<yymmdd>.[TABLE | UPDATE].CSV
Variable | Data type | Comment | |
---|---|---|---|
1 | MediaCompany | Integer | See table 7.1. Media Company ID |
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 2.1 Station ID |
22 | _LoadOp_ | Integer | Only for .update-files: 1 = add, 2 = delete, 3 = modify |