Guardian News & Media
GNM RCS
Contract reporting
Technical specification
Prepared by O3 Team Limited
Authors Nigel Robson
Creation date 03/09/2013
Document Ref. GNM_RCS_Contract_Reporting_TS.docx
Version draft for review
.Introduction
Purpose
The document GNM_RCS_Contract_Management_FS.docx is the functional specification that describes what business functions RCS supports in relation to entering into contracts with contributors to procure content from them on a long-term basis.
This document is one of a set of technical specifications that provide details of how those functions are implemented in RCS.
Scope
This document focusses on the reports available in RCS that relate to editorial contracts with content suppliers, aka contributors.
Separate documents cover the entry of new contracts and their subsequent processing and also the renewal of contracts.
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.
.Contracts list
Users can request a list of current contracts, delivered in comma separated values (csv) format.
Requesting the report
To request this list choose menu option Contracts → Reports… → Contracts list…
This opens the screen rcs_reports_200_pc.fmb
The list can be restricted by the criteria shown above, all of which are self-explanatory.
Upon pressing the “Finish” button the request will be recorded in the REPORT_REQUESTS table, and will be picked up by a batch job and processed.
Report output
The report output file lists the data in comma separated values (csv) format, and is emailed to the requestor of the report. The file contains these columns:
Contributor, Reference, Format, Type, Subtype, Start, End, Months, Terminated on, Rate, Currency, Total fee, Contribution, Status, Fee split description, Rate, Fee split, Extra payments, Estimate?, Legal entity code, Legal entity name, Cost centre code, Cost centre name, Account code, Account name, Product code, Product name, <Spare> code, <Spare> name, Analysis 1 code, Analysis 1 name, Analysis 2 code, Analysis 2 name, Project code, Project name, Payment terms, Advance/arrears, Specific date, Owner(s)
.Contracts not returned
Users can request a list of Contracts not returned (i.e. not countersigned by the contributor), delivered in comma separated values (csv) format.
Requesting the report
To request this list choose menu option Contracts → Reports… → Contracts not returned list…
This opens the screen rcs_reports_230_pc.fmb
By pressing the “Next” button the user is presented with a window in which they can decide whether to restrict the list to just unpaid contracts.
Upon pressing the “Finish” button the request will be recorded in the REPORT_REQUESTS table, and will be picked up by a batch job and processed.
Report output
The report output file lists the data in comma separated values (csv) format, and is emailed to the requestor of the report. The file contains these columns:
Contributor, ARN, Handled by, Starts on, End on, Cost centre, Product, Issued on, Chased on, Fee, Service fee, Currency, Format, Contribution, Comments
.Content history report
The Content history report can provide a list of all content matched against a contract.
This is achieved by following these steps:
Choose menu option Contracts → Review contracts and select the relevant contributor;
In the Review contracts screen scroll to the relevant contract;
Press the “Content” button to open the Content history screen for that contract; and
In the Content history screen press the “Show report” button for a PDF report, displayed in the browser, showing all content matched to the report. The user can choose a detailed report listing all the content, or a summary report that just shows the totals.
This report is described in more detail in separate documentation that focuses on Content.
.Financial reports
Contracts data appears in other reports that are described in the documents relating to the Finance functions in RCS:
Finance → Spend analysis
Finance → Accruals & Prepayments → Contract accrual reports
Finance → Delayed payments report
End of Document
<enter keywords here>
Keywords (or tags) are important to provide accurate search results. They are vital if you have attached rather than pasted content to this page.