Search

6.4.14 Aiding human readability

Messages created in accordance with this part of the RDR standard are designed so that they can be ingested and processed automatically. However, when establishing a new message exchange it may be helpful for humans to be able read a file. The same may be true for error handling during normal operations.

It is therefore recommended, for each Record type used in a message created in accordance with this part of the standard, to include above the first actual Record data an additional Record that sets out, once, all the Cell “headings” for that particular Record.

The first Cell of the “headings” Record shall be populated with the relevant Record identifier, preceded by a hash symbol (“#”) as shown in Figure 4.

Figure 4 – Human readable layout of a message created in accordance with this part of the RDR standard.

Figure 4 shows a message (with only the first few Cells shown) created in accordance with this part of the RDR standard loaded into a spreadsheet application, with some rows coloured to aid readability.

When creating such “headings” Records, the sender should ensure to use (i) the correct Record identifier (specifically: the correct version of the Record identifier) for the profile version used and (ii) the correct Cell names. While failing to this shall not cause automated ingestion to fail as these lines shall be ignored, they might lead to recipients questioning whether the remainder of the message is following the standard correctly.

The following table provides sample data for a RevenueSummary message with only one Record. Header and Footer Record have been omitted here.

The message has been transposed for ease of displaying the Record name and corresponding values, which would otherwise be presented as in Figure 4 above.

	Cell name	Record value
1	`RecordType`	`SRS1`
2	`RecordId`	`RRH_001`
3	`SummaryType`	`RightsController`
4	`CurrencyOfAccounting`	`GBP`
5	`NetRevenueInCurrencyOfAccounting`	`11481.32`
6	`PaymentDate`	`2020-06-30`
7	`PaymentRecipientId`	`PADPIDA2007081601G`
8	`PaymentRecipientName`	`Record Company Y`
9	`CollectingMlcName`
10	`PayingMlcName`	`MLC Company X`
11	`ClaimingMlcName`
12	`ClaimingMlcAllocatedPartyId`
13	`PayingMlcAllocatedPartyId`	`PADPIDA2007081601G`
14	`AllocatedPartyIPN`
15	`AllocatedPartyISNI`
16	`AllocatedPartyFullName`	`Record Company Ltd`
17	`AllocatedPartyNamesBeforeKeyName`
18	`AllocatedPartyKeyName`
19	`AllocatedPartyNamesAfterKeyName`
20	`CollectingMlcGrossAmount`
21	`PayingMlcGrossAmount`	`21050`
22	`CollectingMlcCommission`	`-1`
23	`PayingMlcCommission`	`-99`
24	`CollectingMlcSocialCultural Deduction`
25	`PayingMlcSocialCulturalDeduction`
26	`CollectingMlcAdministrationCost Deductions`
27	`PayingMlcAdministrationCost Deductions`	`-43.87`
28	`CollectingMlcOtherDeduction1`
29	`CollectingMlcOtherDeductionType1`
30	`PayingMlcOtherDeduction1`	`-10000`
31	`PayingMlcOtherDeductionType1`	`Advance Recoupment`
32	`CollectingMlcOtherDeduction2`
33	`CollectingMlcOtherDeductionType2`
34	`PayingMlcOtherDeduction2`	`-28.31`
35	`PayingMlcOtherDeductionType2`	`Union fees`
36	`CollectingMlcOtherDeduction3`
37	`CollectingMlcOtherDeductionType3`
38	`PayingMlcOtherDeduction3`
39	`PayingMlcOtherDeductionType3`
40	`CollectingMlcOtherDeduction4`
41	`CollectingMlcOtherDeductionType4`
42	`PayingMlcOtherDeduction4`
43	`PayingMlcOtherDeductionType4`
44	`CollectingMlcOtherDeduction5`
45	`CollectingMlcOtherDeductionType5`
46	`PayingMlcOtherDeduction5`
47	`PayingMlcOtherDeductionType5`
48	`CollectingMlcInterest`
49	`PayingMlcInterest`	`23`
50	`CollectingMlcInterestWithholding Tax`
51	`PayingMlcInterestWithholdingTax`	`0`
52	`CollectingMlcRoyaltyWithholdingTax`
53	`PayingMlcRoyaltyWithholdingTax`	`0`
54	`CollectingMlcOtherWithholdingTax`	`-3.5`
55	`PayingMlcOtherWithholdingTax`
56	`CollectingMlcVAT`
57	`PayingMlcVAT`	`584`
58	`NetAmount`	`11481.32`

Table 6 – Sample message transposed with only one Record for display purposes only, created in accordance with this part of the RDR standard.

The table that follows provides sample data for a RevenueDetails message with only one Record. Header and Footer Record have been omitted here.

The message has been transposed for ease of displaying the Record name and corresponding values, which would otherwise be presented as in Figure 4 above.

	Cell name	Record value
1	`RecordType`	`SRD1`
2	`RecordId`	`SRD1_0000001`
3	`CurrencyOfAccounting`	`GBP`
4	`NetRevenueInCurrencyOfAccounting`	`222946.35`
5	`SummaryRecordId`	`RRH_001`
6	`StatementType`	`RightsController`
7	`CollectingMlcName`
8	`PayingMlcName`	`MLC Company X`
9	`ClaimingMlcName`
10	`ClaimingMlcAllocatedPartyId`
11	`PayingMlcAllocatedPartyId`	`PADPIDA2008120501W::RRH01234`
12	`AllocatedPartyIPN`
13	`AllocatedPartyISNI`
14	`AllocatedPartyFullName`	`Record Company Y`
15	`ResourceType`	`SoundRecording`
16	`AudioVisualType`
17	`RevenueAllocationType`
18	`ISRC`	`GBBAD1501120`
19	`ISAN`
20	`EIDR`
21	`ProprietaryResourceId`	`PADPIDA2008120501W::MyTrackId:30261973`
22	`ResourceTitle`	`SWEET REVENUE`
23	`ResourceSubTitle`
24	`SeriesTitle`
25	`SeasonNumber`
26	`EpisodeNumber`
27	`Genre`
28	`ResourceDisplayArtistName`	`DYNAMIC DUET`
29	`HasMadeFeaturedContribution`
30	`HasMadeContractedContribution`
31	`AudioVisualContributorName`
32	`AudioVisualContributorRole`
33	`AllocatedPartyContributionRole`
34	`AllocationSharePercentage`	`33.33`
35	`ICPN`
36	`ReleaseCatalogNumber`
37	`AudioVisualProductionDate`
38	`AudioVisualCreationDate`
39	`TerritoryOfRevenueGeneration`	`GB`
40	`UseType`	`PerformInPublic`
41	`LicenseeName`
42	`LicenseeId`
43	`UsageSourceName`
44	`UsageSourceId`
45	`AllocationGuidance`
46	`UsageStartDate`	`2018-01`
47	`UsageEndDate`	`2018-12`
48	`RecipientRevenueType`	`ProducerRevenue`
49	`RevenueSourceType`	`RoyaltyRevenue`
50	`RevenuePoolName`	`PublicPerformance/Gyms`
51	`BasisForRevenueAllocation`
52	`UnitTypeForRevenueAllocation`
53	`UnitRate`
54	`Usages`
55	`ReallocationFromNonQualifying Performance`	`13`
56	`CollectingMlcGrossAmount`
57	`PayingMlcGrossAmount`	`20000`
58	`CollectingMlcCommission`
59	`PayingMlcCommission`
60	`CollectingMlcSocialCultural Deduction`
61	`PayingMlcSocialCulturalDeductions`
62	`CollectingMlcAdministrationCost Deductions`
63	`PayingMlcAdministrationCost Deductions`
64	`CollectingMlcOtherDeduction1`
65	`CollectingMlcOtherDeductionType1`
66	`PayingMlcOtherDeduction1`
67	`PayingMlcOtherDeductionType1`
68	`CollectingMlcOtherDeduction2`
69	`CollectingMlcOtherDeductionType2`
70	`PayingMlcOtherDeduction2`
71	`PayingMlcOtherDeductionType2`
72	`CollectingMlcOtherDeduction3`
73	`CollectingMlcOtherDeductionType3`
74	`PayingMlcOtherDeduction3`
75	`PayingMlcOtherDeductionType3`
76	`CollectingMlcOtherDeduction4`
77	`CollectingMlcOtherDeductionType4`
78	`PayingMlcOtherDeduction4`
79	`PayingMlcOtherDeductionType4`
80	`CollectingMlcOtherDeduction5`
81	`CollectingMlcOtherDeductionType5`
82	`PayingMlcOtherDeduction5`
83	`PayingMlcOtherDeductionType5`
84	`CollectingMlcInterest`
85	`PayingMlcInterest`
86	`CollectingMlcInterestWithholding Tax`
87	`PayingMlcInterestWithholdingTax`
88	`CollectingMlcRoyaltyWithholdingTax`
89	`PayingMlcRoyaltyWithholdingTax`
90	`CollectingMlcOtherWithholdingTax`
91	`PayingMlcOtherWithholdingTax`
92	`CollectingMlcVAT`
93	`PayingMlcVAT`
94	`NetAmount`	`20000`

Table 7 – Sample message transposed with only one Record for display purposes only, created in accordance with this part of the RDR standard.