GNM_RCS_Commission_Reporting_TS

• 1. Introduction

     1. Purpose

The document GNM_RCS_Commissions_FS.docx is the functional specification that describes what business functions RCS supports in relation to Commissioning content from contributors.

This document is one of a set of technical specifications that provide details of how those functions are implemented in RCS.

• 1. Scope

This document focusses on the commission reports available within RCS.

This document is intended as a high-level technical document outlining how the relevant business functions are implemented in terms of software modules.

Importantly, this document does not aim to provide the level of detail that would be required in a programming specification in areas such as program structure, detailed business rules, data integrity, validation, locking considerations, data security, and calls to/from other software modules, performance considerations, and so forth.

For details of program logic and coding, the reader should refer to the program files themselves.

• 1. Commission approval reports

These reports are available so that the approval process can be monitored after commissions have been approved.

There are two reports available, both of which are generated by the Oracle Report rcs_comm_020.rdf

• 1. Approval by Editor’s office report

This report lists commissions that have been approved by the Managing Editors, for a specified period.

• 1. Requesting the report

The report is run from this menu option: Commissions → Reports → Approve by Editor’s office

This menu option opens screen rcs_reports_010_pc.fmb which allows the user to enter the period to report on and the order the data should be listed in.

The report is generated when the user presses the “Finish” button and is presented as a PDF document to the user in their browser.

.

• 1. Report layout

An example of the report layout is given below:

.

• 1. Approval by Department head report

This report lists commissions that have been approved by the Department Head, for a specified period.

• 1. Requesting the report

The report is run from this menu option: Commissions → Reports → Approve by Dept head

As for the previous report, this menu option opens screen rcs_reports_010_pc.fmb which allows the user to enter the period to report on and the order the data should be listed in.

• 1. Report layout

As the same report is used to generate the output for both the “Approved by Editor’s office” and “Approved by Dept head” please see previous section for example layout.

.

• 1. Unfulfilled commissions report

This report lists all commissions that remain unfulfilled on the system, which usually delays payment.

• 1. Requesting the report

The report is run from this menu option: Commissions → Commission reports

This menu option opens screen rcs_reports_060_pc.fmb.

Once the report has been chosen by checking the relevant checkbox the user can enter the cost centre to be reported on, or leave it blank to report on all cost centres that the user works with.

The content format to be reported on can also be specified, or the "All" option can be chosen.

Finally the user can choose to get the report output in a single file or a separate file per cost centre.

• 1. Report output

The report output file(s) list the data in comma separated values (csv) format, which are emailed to the requestor of the report. The file(s) contain these columns:

Contributor,Agreed on,Cost centre,Product,Item type,Wordage,Contribution,CRN,Due on,Fee,Fee type,Created by,Created on

• 1. Unmatched, fulfilled commissions report

This report lists fulfilled commissions that have not yet been matched. This enables the requestor of the report to monitor what has been fulfilled (and most likely paid for) but not linked to published content.

It is important to ensure commissions are matched to content wherever possible to ensure the rights defined against the commission are applied to the published content.

• 1. Requesting the report

This report is requested using the same menu option and report request screen described in the previous section.

• 1. Report output

The report output file(s) list the data in comma separated values (csv) format, which are emailed to the requestor of the report. The file(s) contain these columns:

Cost centre,Product,Contributor,Payee,CRN,Contribution,Agreed on,Currency,Fee,Fee type

.

• 1. Financial reports

Commissions appear in a number of reports that are described in the documents relating to the Finance functions in RCS:

• • Finance → Spend analysis

  • Finance → Accruals + Prepayments → Commission + other payment accruals

  • Finance → Accruals + Prepayments → Unpublished commissions report

  • Finance → Accruals + Prepayments → Prepayments report

  • Finance → Delayed payments report

End of Document