Works

A work is not a large static data sheet. A work consists of:

• a small sheet that contains the general information: title, subtitle (s), company, territory, number, etc. Essentially, the area outlined in red on the screen below:

• • copyright * attached to this work; these * copyrights * are in fact a link between an actor data sheet and a worksheet,
• • royalties * attached to this work; these * royalties * are, also, a link between an actor’s sheet and a worksheet but for other use,
• a list of * codes * attached to this work,
• a list of * groups * to which this work is attached (again, it is a link between groups and works),
• a list of * tags * related to the work,
• other sheets and lists related to the work.

List of works

The list of works is used in two steps:

• search engine
• the list itself and its functions

Search engine

Advanced search allows you to:

• find a work when only a vague notion of its characteristics is known.
• find several works with common characteristics.

The list and its functions

Functions:

• Create: creates a new work
• Edit: opens the sheet of the selected work (also accessible by double-clicking on the work)
• Delete: deletes the selected work (no multiple deletion for the moment)
• Refresh: refresh the list of works
• Clone the work: copies the data of the selected work into a new work and opens the new sheet for modification
• Save column customisation
• Optimise all columns” sizes

Actions when you click right :

• ** Look for lost works **: searches for works that have no information « royalties » and which are not attached to a group related to a contract
• ** Create static group **: creates a group with the works selected
• ** Check payouts **: checks payouts during a selected period on the work selected.
• ** Merge 2 works **: see below
• ** Apply this template **: see below
• ** Search for lost works **: search and / or recreates works whose CoCv exists in the spreadsheets but not in the database of the works
• ** List templates **: you can customise the columns available and their order.

Merge 2 works

The merger of two works will retain work A and delete work B having previously recovered all the information it contains and which is not present in work A. The work retained will recover the rights (SACEM and direct), copyright information and royalties, the presence of the work in groups, links to movies, records and collections and all the fields that are filled in in sheet B but not in sheet A: for example, if the field « Territory » of sheet A is empty but that it is indicated in B, it will be copied.

Avertissement

This function can cause duplicates (for example the presence of the copyright data of both works). It is recommended to check the contents of the remaining work after merging.

You must first select 2 works: Click on the first and Control + Click on the second.

• Use Swap to choose which work you want to keep/discard.
• You can choose not to copy royalties or copyright information.

Apply this template

The application of a template allows the use of the information of a work, to copy it into the works of a group.

1. Select the work you want as model by right-clicking
2. Apply this model
3. Select the group to apply it to
4. Select the information to copy:

• General
• Copyright
• Royalties

5. Start

The box on the right shows the information of the selected work.

Work’s form

General

This form collects all the information related to the work.

• Its identification
• Its associated actors
• Associated contracts

Identification

The identification of a work is in the box on the left.

• Subtitle: it may be interesting to add a subtitle to the work so that homonymous titles can easily be distinguished.
• Company: This is the original publisher, yourself or the publisher you represent on a territory. This notion is important when exporting the statements, so that the paid actors are identified with the good company. The notion of company within a contract or in the royalties (« controlled by ») will be priority on this information indicated in the work.
• Interpreter (s): optional. You can also add one or more actors in the « Copyright » area with the interpreting role.
• Authors: optional because we will inform them in the copyright. This pane is useful to force the names of the authors indicated on the statements (especially when they are numerous in the copyright and you wish to restrict this list).
• Territories: the territory on which you represent the title.
• N ° cotage: publisher’s internal number
• ISWC: international work code (add / modify via the « Codes » tab)
• datedepotsacem: date the work was first filed in
• idimport: allows to know by which import this work appeared in the base
• From the movie
• From the album
• Protected: protected work during massive treatments in the catalogue fixing workshop. It will not undergo the modifications.
• Do not export: the work will not be exported in the catalogs.
• already registered: means that the original work has been registered. Forces « REV », as revised work for the next registration.
• registration comment
• natsacem: nationality of the work for SACEM (useful for HRF2 filing only)
• genre: type of music
• duration: duration of the original title
• infosdecl1: to hide
• infosdecl2: to hide
• datecontrat: used when generating contracts in word format.
• datefincontrat: to hide
• benefcontrat: to hide
• account: to hide
• contratgeneral: to hide
• genreinstru: to hide
• formatdejafabrique: to hide
• formatstock: to hide
• catalog: to hide
• subcatalogue: to hide
• datedernierdeczeroformat: to hide
• dateerniereventeformat: to hide
• datecrea: to hide
• expensesengages: to mask
• reversexcept: to hide
• contractcoedsoused: to be hidden
• contractfragmentation: to hide

Copyrights

Copyrights are the actors of a work and their respective shares in terms of copyright.

For each one must be defined:

• his role : the artistic roles -A-: author, composer, songwriter, arranger, adapter.
• the roles of representatives -E-: original publisher, sub-publisher, publisher substituted, co-publisher, with commercial rights, administrator
• SACEM roles:
• pot pourri / Sample: samples are both author’s and publisher’s part.
• reserve account: SACEM, shares for which there is a conflict, we do not know to whom to assign them.
• public domain: non assigned shares.
• Roles not managed by Sage -?
• Artist
• control: management or not of copyright for the actor.
• lettering: chain of rights between actors within the work (who represents who)
• third party: this field is filled in if the information comes from a catalog import sent by a Third Party. It will be mentioned as long as no modification on the line of the actor has been made.
• PRO agreement : contract number given by a PRO (normally only sub-publisher and substituted publisher have a PRO agreement)
• the shares of each according to owned and possesed shares to be registered. The total shares must equal 100%.

Royalties

Royalties come in two formats:

• horizontally
• vertically: this version can be hidden with the blue arrow above.

Two levels of operation coexist to define the royalties in a work: the « ** contract  » mode and the «  work ** » mode.

In both modes, the definition of the payouts is done in the same way: you define one or several actors and the shares (percentages) which will be paid to them according to the types of rights recived.

In the ** contract ** mode, you create a contract and enter the payout information (the « royalties »). You attach this contract to a group and the royalties will apply to all the works of this group. This mode is preferred because:

• it is as efficient if the group contains one or more thousands of works,
• if you realize an error in your payments, you simply correct the contract and all the works benefit instantly from the correction
• if new works are created and you have to apply the same repayments to them, simply add them to the group; in some cases, this addition can even be automatic (dynamic groups)

In the « works » mode, the royalties are defined directly in the work’s form and applied in place of those that could have been defined in the contract (s) to which the work could be attached; it is important to understand that ** the repayment information defined in the work has priority ** on contracts. If you change the percentages in a contract and your statements do not change, it is likely that the rates taken into account are those defined directly in the work.

This operation makes it possible to define a general case and exceptions.

Codes

All codes related to the work are listed. These codes are integrated manually and via catalog and rights imports.

• Code types: ISWC, CoCv, etc …
• idcodead: internal number given by the sage
• Third party: entity that provided the information
• Author: takes the actors in the work
• Album Ref: Album to which the work belongs
• Num pist: Number of the track within the album
• Duration: duration of the title
• Fixation year: year of registration
• Label: label that produced the album
• Performer: performer of the song on the album
• created: creation date in Sage
• N ° import: Import by which the work has been added in Le Sage (internal number to the Sage).

A work may have several codes of the same type. If the latter has multiple ISWC or CoCv codes, the Sage will export, or fill in your documents with the code that was entered in Le Sage first. To choose the code and to avoid that bad code being used it must be defined as ** main code **.

** To mark a code as principal: Select the line with the main code and press the icon at the bottom right: | Icone_codeprincipal | . **

Notes

These notes are internal to Le Sage and have no impact. They help manage the catalogs.

Rights

List of all the royalties linked to the work. The display is flexible according to the chosen « list template ».

• n° droits : internal number assigned to the line of right
• TypeDroits : Phono, DEP, DRM, Synchro…
• Titre : work’s title
• Source : where the rights come from
• amount paid : amount received
• amount collected : amount collected by the third party
• % collecté : % collected amound all the shares for one work
• type of rights_text : type of rights information coming from the import file
• country_text : country that may have been given in the import file
• sacem_COCV : CoCV (SACEM number)
• sacem_repart :number of repartition SACEM
• sacem_repartorigin :
• sacem_indicatifordre :
• sacem_tyrepart :
• sacem_coderubrique :
• sacem_codefilm:
• sacem_titrefilm:
• sacem_codecompo:
• sacem_adapayer : CoCV of the actor being payed
• sacem_adorigine :
• sacem_iswc : ISWC code
• sacem_depqpadapayer :
• sacem_drmqpadapayer:
• sacem_av_isan :
• sacem_av_genreoeuvre:
• sacem)av_categorieoeuvre :
• sacem_av_anneeprod
• sacem_av_nomproducteur :
• sacem_av_nomrealisateur :
• sacem_av_interprete :
• sacem_av_paysorigine :
• sacem_av_titreoriginal :
• sacem_av_titrelocal :
• sacem_av_titreoriginalepisode :
• sacem_av_titrelocalepisode :
• sacem_av_numeroproducteurepisode :
• sacem_av_numerosocieteepisode :
• sacem_av_dureetotaleoeuvre :
• sacem_av_dureetotalemusique :
• sacem_av_dureetotalemusiqueprotegee :
• sacem_av_dureeoeuvre :
• sacem_av_version :
• sacem_av_codefilmsacem :
• sacem_rubnom :
• sacem_rubabr :
• sacem_rubdedr :
• sacem_rubcolfeuillet :
• sacem_rubcontrcentr :
• sacem_rubcodetab :
• sacem_rubcodesstab :
• sacem_rubsrvsacem :
• sacem_paysorigine :
• sacem_rubrique4car :
• sacem_felix_famille :
• sacem_felix_typeutil :
• sacem_felix_codeutil :
• sacem_felix_origedit :
• sacem_distributioncategory :
• idoeu : internal number assigned to the work
• idrighttag : tag number linked to the right’s line.

Group & tags

This page lists all the groups to which the work belongs and all the (work) tags associated.

Records

Films, CDs or others meadias in which the work appears. This tab is currently disabled.

Exports

Exports in which the work was present.

Ads