From ICIHelp7.15
Jump to: navigation, search
 
(36 intermediate revisions by 4 users not shown)
Line 6: Line 6:
 
*Average Agreement Turn Around Time  
 
*Average Agreement Turn Around Time  
 
*Clause Profiling Report  
 
*Clause Profiling Report  
 +
*Clause Summary Report
 
*Template-Clause Report  
 
*Template-Clause Report  
−
*Agreement Cycle Time Report  
+
*Cycle Time Report  
 
*User Profiling Report  
 
*User Profiling Report  
 
*User Login Report  
 
*User Login Report  
 
*Signature Type Report  
 
*Signature Type Report  
 
*CLM Activity Report  
 
*CLM Activity Report  
 +
*Masterdata Information Report
  
 
== Average Agreement Turn Around Time ==
 
== Average Agreement Turn Around Time ==
Line 23: Line 25:
 
*''Agreement Code, Contract Type, Average turn around time ''(days)  
 
*''Agreement Code, Contract Type, Average turn around time ''(days)  
 
*''Deviated By, Deviated Date ''and''Time, Deviation Status, Comments Added By, Comments Added Date & Time, Comments, Approved By ''(multiple entries''), ''or ''Approved Date & Time ''(multiple entries)  
 
*''Deviated By, Deviated Date ''and''Time, Deviation Status, Comments Added By, Comments Added Date & Time, Comments, Approved By ''(multiple entries''), ''or ''Approved Date & Time ''(multiple entries)  
−
<div class="image-green-border">[[File:Reports Admin AverageAgreementTurnAroundTime.png|900x300px|Reports Admin AverageAgreementTurnAroundTime.png]]</div>  
+
<div class="image-green-border">[[File:Reports Admin AverageAgreementTurnAroundTime.png|720px|Reports Admin AverageAgreementTurnAroundTime.png]]</div>  
 
== Clause Profiling Report ==
 
== Clause Profiling Report ==
  
Line 39: Line 41:
  
 
*''Contract Type Name, Clause Name, Clause Code, Clause Version, Template Name, Template Code,'' and&nbsp;''Template Version.''  
 
*''Contract Type Name, Clause Name, Clause Code, Clause Version, Template Name, Template Code,'' and&nbsp;''Template Version.''  
−
<div class="image-green-border">[[File:Reports Admin ClauseProfillingReport.png|RTENOTITLE]]</div>  
+
<div class="image-green-border">[[File:Reports Admin ClauseProfillingReport.png|720px|RTENOTITLE]]</div>  
 +
&nbsp;
 +
 
 +
 
 +
== Clause Summary Report ==
 +
 
 +
Clause library maintenance is a crucial activity for any enterprise managing its contracts digitally. Administrators working with clause libraries also need to handle several recurring clause changes.&nbsp;<br/> The Clause Summary Report is being introduced in order to help clause administrators to understand the impact any changes made to a clause would have. This would enable them to assess how any clause has been used across different agreements, amendments, associations and templates. Further, these users would be able to identify which version of a clause was used in a particular entity.&nbsp;<br/> This default report is accessible from the Admin category of reports and its access will be based on Security Groups.
 +
 
 +
To view the clause summary report:
 +
 
 +
1.&nbsp;'''Click''' ''Reports'' tile. The ''Reports'' page opens.
 +
<div class="image-green-border">[[File:7.14-ClauseSummaryReport.png|720px|7.14-ClauseSummaryReport.png]]</div>
 +
2.&nbsp;'''Click''' the arrows on the ''Reports'' page to navigate to the ''Clause Summary Report''.&nbsp;
 +
<div class="image-green-border">[[File:7.14-ClauseSummaryReport1.png|720px|7.14-ClauseSummaryReport1.png]]</div>
 +
3.&nbsp;'''Click''' ''Clause Summary Report''. The ''Reports'' page opens displaying the ''Clause Name'' and ''Clause version'' list.
 +
<div class="image-green-border">[[File:7.14-ClauseSummaryReport2.png|720px|7.14-ClauseSummaryReport2.png]]</div>
 +
4.&nbsp;'''Select''' the ''Clause Name'' and the ''Clause version'' from the list and '''click''' ''View Report''. For example, select Liquidated Damages Clause as the clause name and Select All to select clause versions 1 and 2. &nbsp;&nbsp;
 +
<div class="note-box">'''Note''':&nbsp;By default, all the available clause versions will be selected. You can select any one or more than one version at a time to generate the report.</div>
 +
The ''Clause Summary Report'' is displayed for the selected clause and displays the following information.
 +
 
 +
*Clause Summary:&nbsp;Displays information about the selected clause such as the ''Clause Name, Clause Code, Created By, Created On, Clause Language'', whether the selected clause is a Primary Clause, if the selected clause is not a primary clause it displays the linked primary clause.
 +
<div class="image-green-border">[[File:7.14-ClauseSummaryReport3.png|720px|7.14-ClauseSummaryReport3.png]]</div>
 +
*Clause Version Summary: Displays the following information.
 +
**Version:&nbsp;The different versions of the clause are listed as column headers. Details of each version are displayed in a separate column. Clicking the version number displays a sub-report for that version.
 +
**Status: Displays the status of the clause. For example, ''Approved''.
 +
**Approvers: Displays the approver user added to the clause team. If there are no approvers added to the clause team this field will not display any information.
 +
**Is Latest: Displays ''Yes'' if the selected clause version is the latest version available in the system for the selected clause.
 +
**<div class="image-green-border">Contract Types: Displays the list of contract types with which the selected version of the clause is associated. For example, Purchase Agreement.</div>   
 +
<div class="image-green-border">[[File:7.14-ClauseSummaryReportSummary.png|720px|7.14-ClauseSummaryReportSummary.png]]</div> <ul style="margin-left: 40px;">
 +
<li>Clause Group: Displays the name of the Clause group to which the selected clause version belongs.&nbsp;</li>
 +
<li>Is Alternate Clause:&nbsp;Displays a Yes or No depending on whether the selected clause version is an alternate version of another clause or not.</li>
 +
<li>Alternate Of: Displays the name of the clause of which the selected clause version is an alternate.</li>
 +
<li>Is Mandatory:&nbsp;Displays a ''Yes'' or ''No'' depending on whether the selected clause version is mandatory to be added to the contract.</li>
 +
<li>Is Editable: Displays a ''Yes'' or ''No'' value depending on whether the selected clause version can be edited when used.</li>
 +
<li>Deviation Analysis: Displays a ''Yes'' or ''No'' value depending on whether ICI tracks the deviations for the selected clause.</li>
 +
<li>Is Dependent: Displays a ''Yes'' or ''No'' value depending on whether the selected clause is dependent on another clause.</li>
 +
<li>Depends On: Displays the name of the clause on which the selected clause version is dependent.</li>
 +
<li>Clause Text:&nbsp;Displays the clause text for the selected clause version.</li>
 +
<li>File: Displays the name of the file attached, if any, for the selected clause version.</li>
 +
<li>Clause Description: Displays the description of the selected clause, if added.</li>
 +
</ul>
 +
<div class="image-green-border">[[File:7.14-ClauseSummaryReport-ActionsAllowed.png|720px|7.14-ClauseSummaryReport-ActionsAllowed.png]]</div>
 +
5.&nbsp;'''Click''' the version number, for example ''Version 1.&nbsp;''The sub-report for the selected clause version is displayed.&nbsp;
 +
<div class="image-green-border">[[File:7.14-ClauseSummaryReportSummary2.png|720px|7.14-ClauseSummaryReportSummary2.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:7.14-ClauseVersionSummary.png|720px|7.14-ClauseVersionSummary.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">In this example, Version 1 has been used in 2 templates, Template_56 and Template_58<br/> 6.&nbsp;'''Click''' the back button to go back to the parent report and click Version 2 (see Step 5). The sub-report for that version is displayed with the following columns: ''Agreement Code, Version, Contract Type, Agreement Name, Agreement Created By, Agreement Created On'' and ''Agreement Status''. In this example, Version 2 is used in 115 agreements, among other entities.</div> <div class="image-green-border">[[File:7.14-ClauseVersionSummary1.png|720px|7.14-ClauseVersionSummary1.png]]</div>
 +
7.&nbsp;'''Click''' the arrows above the report to navigate ahead to the remaining pages, to view other entities where the selected Liquidated Damages Clause Version 2 has been used.
 +
<div class="note-box">'''Note''':&nbsp;Select an entity from the ''Entity Name'' field and click ''View Report'' to filter the sub-report by entities. This displays the entities where the selected clause version has been used, such as Agreement, Amendment, Associations and Templates. One or more entities can be selected at a time.</div>
 +
'''Actions allowed on Clause Summary Report&nbsp;'''
 +
 
 +
You can perform the following actions on the Clause Summary Report page.
 +
 
 +
*Find: '''Search''' and view the clause versions for the selected clause.
 +
*Export: '''Select''' the format to which you want to export the clause summary report. You can export it to Excel, PDF and CSV (comma delimited) format.
 +
*Refresh: '''Click''' Refresh to refresh the clause summary report page to view the latest information on the Clause Summary Report page.
 +
<div class="image-green-border">[[File:7.14-ClauseSummaryReport-Export.png|720px|7.14-ClauseSummaryReport-Export.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">The report is enhanced to display a Clause Extension Summary which displays details on extended clause attributes. If the Clause Extended Entity is defined for an ICI instance, then this report will display the information of the clause extension attributes. Further, the Clause Extension Summary will display the latest values of clause extension attributes.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">The additional attributes added for the clause will be displayed in the Clause Extension Summary section.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:7.15 CSR.png|720px]]</div> <div class="image-green-border">&nbsp;</div>
 +
 
 
== Template Clause Report ==
 
== Template Clause Report ==
  
Line 55: Line 111:
  
 
The report is sort by the alphabetical order of the Contract Type name followed by the alphabetical order of the Template&nbsp;name, followed by ascending order of Template version.
 
The report is sort by the alphabetical order of the Contract Type name followed by the alphabetical order of the Template&nbsp;name, followed by ascending order of Template version.
−
<div class="image-green-border">[[File:Reports Admin TemplateClauseReport.png|RTENOTITLE]]</div>  
+
<div class="image-green-border">[[File:Reports Admin TemplateClauseReport.png|720px|RTENOTITLE]]</div>  
−
== Agreement Cycle Time Report ==
+
== Cycle Time Report ==
  
−
The Agreement Cycle Time Report is a drill down report that shows the cycles for an Agreement and the change of status from the date of creation to the date of execution as well as the elapsed time. The purpose of this Report is to enable you detect the deficiencies in the processes and turnaround time for tasks. It helps you identify patterns that lead to longer cycle times and take corrective actions in the process and streamline it better.&nbsp;&nbsp;
+
The Cycle Time Report is a drill down report that shows the cycles for an Agreement and the change of status from the date of creation to the date of execution as well as the elapsed time. The purpose of this Report is to enable you detect the deficiencies in the processes and turnaround time for tasks. It helps you identify patterns that lead to longer cycle times and take corrective actions in the process and streamline it better.&nbsp;
  
 +
Reports can be filtered using the Entity field with the following values: Agreements, Agreements with Contract Request, and Contract Requests.
 +
<div class="image-green-border">[[File:Cycle Time Report 7.8.png|720px|RTENOTITLE]]</div>
 +
When the user selects Agreements:
 +
 +
*Amendments will also be displayed.
 +
*An additional column Parent Agreement Code has been added to the tabular data that will display the parent Agreement of the Amendment.
 +
<div class="image-green-border">[[File:Cycle Time Report Parent AgreementCode 7.8.png|720px|RTENOTITLE]]</div>
 +
&nbsp;
 +
<div class="image-green-border">[[File:Agreementwith ContractRequest Cycle TimeReport7.8.png|720px|RTENOTITLE]]</div>
 +
When the user selects Agreements with Contract Request:
 +
 +
*A chart appears that displays the Contract Type by Average Cycle Time for all Agreements that have been created through Contract Requests. Clicking the Contract Type on this chart opens another chart that displays the Contract Requests by Status. The possible states include ''Waiting for Contract Creation, Draft, Waiting For Approval, Approved, Waiting For Internal Signature, Waiting For External Signature, On Hold, Cancelled, Contract Request Draft, Contract Request Waiting For Approval, Contract Request Approved, Waiting For Contract Creation, Contract Request On Hold, and Contract Request Cancelled.&nbsp;''
 +
*The following columns have been added to the tabular data – Contract Request Code, Contract Request Name, Contract Request Created Date, and Type of Agreement.&nbsp;
 +
 +
<br/> When the user selects Contract Requests:
 +
 +
*A chart appears that displays the Contract Type by Average Cycle Time for all Contract Requests. Clicking the Contract Type on this chart opens another chart that displays the Contract Requests by Status (''Draft, Waiting For Approval, and Approved'').
 +
<div class="image-green-border">[[File:ContractRequest Cycle TimeReport7.8.PNG|720px|RTENOTITLE]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:ContractRequest Cycle TimeReport Average Cycle TimeReport7.8.PNG|720px|RTENOTITLE]]</div>
 
Each time the Agreement returns to a previous state, a new entry is created. For example, If the approver is rejected and the Agreement comes back to the ''Draft'' state it is recalled from ''Waiting for External Signature ''state and so on. This is applicable only to executed Agreements. Each&nbsp;cycle is displayed as a new row when expanded. The excel export takes care of the relevant groupings and display all the data. This report displays charts.&nbsp;These charts help the user to easily compare the average cycle time for different contract types. They also help to easily identify the status in which Agreements remain for a longer duration.&nbsp;
 
Each time the Agreement returns to a previous state, a new entry is created. For example, If the approver is rejected and the Agreement comes back to the ''Draft'' state it is recalled from ''Waiting for External Signature ''state and so on. This is applicable only to executed Agreements. Each&nbsp;cycle is displayed as a new row when expanded. The excel export takes care of the relevant groupings and display all the data. This report displays charts.&nbsp;These charts help the user to easily compare the average cycle time for different contract types. They also help to easily identify the status in which Agreements remain for a longer duration.&nbsp;
  
−
The ''Contract Type ''filter option has been removed from the parameter section. The Bar graph on the left hand side displays the Contract Type by Average Cycle Time. By default, the report is filtered by ''Time Duration In'' ''Days'', but you have the option to filter it by ''Hours'' as well. Clicking a bar on the graph displays the chart on the right hand side that displays the Average Cycle Time by Status of the Contract.
+
The Bar graph on the left hand side displays the Contract Type by Average Cycle Time. By default, the report is filtered by ''Time Duration In'' ''Days'', but you have the option to filter it by ''Hours'' as well. Clicking a bar on the graph displays the chart on the right hand side that displays the Average Cycle Time by Status of the Contract.
  
−
For example, the following two Agreements are displayed in the list: Agreement ICMMSA_SD (Total Duration – 3.87) and Agreement (Total Duration – 0.07). The bar on the chart displays an average of the total duration of these 2 reports i.e. 3.87+0.07/2 == 1.97
+
For example, the following two Agreements are displayed in the list: Agreement ICIMSA_SD (Total Duration – 3.87) and Agreement (Total Duration – 0.07). The bar on the chart displays an average of the total duration of these 2 reports i.e. 3.87+0.07/2 == 1.97
  
−
Clicking the bar on the Agreement ICMMSA_SD will display the Average Cycle Time Status (''Approved, Draft, WaitingForApproval ''or''WaitingForExternalSignature'') chart for this Agreement in days on the right hand side.
+
Clicking the bar on the Agreement ICIMSA_SD will display the Average Cycle Time Status (''Approved, Draft, WaitingForApproval ''or''WaitingForExternalSignature'') chart for this Agreement in days on the right hand side.
  
 
The Report can be filtered on the Contract Type, total cycle time, the date range of creation as well as the duration in days/hours.
 
The Report can be filtered on the Contract Type, total cycle time, the date range of creation as well as the duration in days/hours.
Line 75: Line 149:
  
 
*''Agreement Code, Agreement Name, Primary Owner, Created Date, OU, Execution Date, Total Duration (Days), Draft Duration (Days), Waiting for Approval Duration (Days), Approved Duration (Days), Waiting for Internal Signature Duration (Days), Waiting for External Signature Duration (Days), On Hold Duration (Days), and Cancelled Duration (Days).''  
 
*''Agreement Code, Agreement Name, Primary Owner, Created Date, OU, Execution Date, Total Duration (Days), Draft Duration (Days), Waiting for Approval Duration (Days), Approved Duration (Days), Waiting for Internal Signature Duration (Days), Waiting for External Signature Duration (Days), On Hold Duration (Days), and Cancelled Duration (Days).''  
−
<div class="image-green-border">''[[File:Wiki cycle time report.png|1000x400px|Wiki cycle time report.png]]''</div>
+
<div class="image-green-border">&nbsp;</div>  
−
&nbsp;
+
−
<div class="image-green-border">[[File:Reports Admin AgreementCycleTimeReport img1.png|RTENOTITLE]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Reports Admin AgreementCycleTimeReport img2.png|RTENOTITLE]]</div>
+
−
&nbsp;
+
−
 
+
 
== User Profiling Report ==
 
== User Profiling Report ==
  
Line 93: Line 163:
  
 
When the flag&nbsp;''Show Only Orphan Records'' is toggled to ''Yes'', the records where the selected user is the only active (Primary/Secondary) user is displayed, so that you can easily identify the number of records that would get orphaned on de-provisioning the selected user. When the flag&nbsp;''Show Only Orphan Records'' is toggled to ''No'', all records where this user is part of the team, irrespective of the role, are displayed.
 
When the flag&nbsp;''Show Only Orphan Records'' is toggled to ''Yes'', the records where the selected user is the only active (Primary/Secondary) user is displayed, so that you can easily identify the number of records that would get orphaned on de-provisioning the selected user. When the flag&nbsp;''Show Only Orphan Records'' is toggled to ''No'', all records where this user is part of the team, irrespective of the role, are displayed.
−
<div class="image-green-border">[[File:User Profiling Report.png|User Profiling Report - C7.SP6]]</div> <div class="image-green-border">&nbsp;</div>  
+
<div class="image-green-border">[[File:User Profiling Report.png|720px|User Profiling Report - C7.SP6]]</div> <div class="image-green-border">&nbsp;</div>  
 
== User Login Report ==
 
== User Login Report ==
  
Line 104: Line 174:
 
As a result, the following columns will display with hyperlinks to the actual Agreement:
 
As a result, the following columns will display with hyperlinks to the actual Agreement:
  
−
*''User Name, User Email Address, Organization Unit ''(path)'', Type Of User, Login Date ''and''Time, Session Duration (Hrs), ''and&nbsp;''IP Address.''  
+
*''User Name, User Email Address, Organization Unit ''(path)'', Type Of User, Login Date ''and&nbsp;''Time,&nbsp;''and&nbsp;''IP Address.''  
 +
 
 +
The IP Address column captures the IP address from all possible scenarios along with the Session Start Time.&nbsp;
  
 
The report is sorted by the alphabetical order of the user name first followed by the descending order of the login date.
 
The report is sorted by the alphabetical order of the user name first followed by the descending order of the login date.
−
<div class="image-green-border">[[File:Reports Admin UserLoginReport.png|900x250px|Reports Admin UserLoginReport.png]]</div>  
+
<div class="image-green-border">[[File:Reports Admin UserLoginReport.png|720px|Reports Admin UserLoginReport.png]]</div>  
 
== Signature Type Report ==
 
== Signature Type Report ==
  
Line 119: Line 191:
  
 
The report is sort by alphabetical order of the Contract Type followed by the alphabetical order of Agreement code.
 
The report is sort by alphabetical order of the Contract Type followed by the alphabetical order of Agreement code.
−
<div class="image-green-border">[[File:Reports Admin SignatureTypeReport img1.png|900x250px|Reports Admin SignatureTypeReport img1.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Reports Admin SignatureTypeReports img2.png|900x250px|Reports Admin SignatureTypeReports img2.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">
+
<div class="image-green-border">[[File:Reports Admin SignatureTypeReport img1.png|720px|Reports Admin SignatureTypeReport img1.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Reports Admin SignatureTypeReports img2.png|720px|Reports Admin SignatureTypeReports img2.png]]</div> <div class="image-green-border">&nbsp;</div>
−
'''Related Topics:'''&nbsp;[[Reports|Overview of Reports]]&nbsp;| [[Agreement_details_page_reports|Agreement Details Page Reports]] |&nbsp;[[Legal_&_Compliance|Legal & Compliance Reports&nbsp;]]&nbsp;| [[Workflow_Reports|Workflow Reports]]&nbsp;|
+
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
== CLM Activity Report ==
 +
<div class="image-green-border">This report gives a quick view for the CTOs, CFOs, etc. on the current high level status of the Agreements, Contract Requests and user activity to gauge the adoption of the ICI platform in their organization and take corrective action to increase adoption of the platform. The report can be filtered on the ''Frequency ''either ''Day Wise (default), Week Wise ''and ''Month Wis''e.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:7.12 CLM Activity Report.PNG|720px|7.12 CLM Activity Report.PNG]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">This report is filtered on the ''Frequency'' either ''Day Wise, Week Wise ''and ''Month Wise''. By default, the ''Day Wise'' frequency is selected.&nbsp;<br/> On selecting the&nbsp;''Day Wise ''option, the report displays the trend for the last 15 days (excluding the present day). However, for the ''Week Wise'', the report displays the trend for the last 12 weeks (excluding the present week) and the ''Month Wise'' option displays the trend for the last 12 months (excluding the present month).&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">Above this report, a ''Summary'' (cumulative numbers) since customer onboarding displays:&nbsp;</div>
 +
*''The Total Contracts Created''
 +
*''The Total Contracts Executed''
 +
*''The number of Active Users''
 +
*''The Average Contract Cycle Time (in Days)''
 +
<div class="image-green-border">[[File:SP7 CLM Actiity Report 2.PNG|720px|C7.SP7 - CLM Activity Report 2]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">For example, in the report shown in the screenshot below, the Summary tile displays that 644 contracts were created, of which 109 contracts were executed till date. A total of 18 users have logged in to the system since customer onboarding and the overall average contract cycle time is 0.71 days to date.<br/> &nbsp;</div> <div class="image-green-border">The information provided in the CLM Activity Report is based on the following 3 reports:</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">1. The ''User Activity Report ''includes the following information:</div>
 +
*''Total Users Provisioned'' (line graph)
 +
*''Active Users'' (line graph)
 +
<div class="image-green-border">For example, in the report shown below in the screenshot, on Oct 24, 94 users were provisioned in the system and of which, 9 users logged in to the system on that day.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:SP7 CLM Actiity Report 3.PNG|720px|C7.SP7 - CLM Activity Report 3]]<br/> &nbsp;</div> <div class="image-green-border">2. The ''Contracts Report'' includes the following information:</div>
 +
*''Average Contract Turnaround Time'' (line graph)
 +
*''Contracts Created ''(bar chart)
 +
*''Contracts In Progress ''(bar chart)&nbsp;
 +
*''Contracts Executed'' (bar chart)&nbsp;
 +
 
 +
For example, in the report shown in the screenshot below, on Oct 23, 81 contracts were created in ICI. Apart from that, 366 contracts were in progress and only 9 contracts got executed on that date. The average contract turnaround time was 14 days on Oct 23.
 +
<div class="image-green-border">[[File:SP7 CLM Actiity Report 4.PNG|720px|C7.SP7 - CLM Activity Report 4]]</div>
 +
3. The ''Contract Requests'' includes the following information:
 +
 
 +
*''Average Contracts Turnaround Time'' (line graph)
 +
*''Total Contract Requests Approved ''(bar chart)
 +
*''Total Contract Requests Created'' (bar chart)&nbsp;
 +
 
 +
For example, in the report shown in the screenshot below, on Oct 19, 7 contract requests were created in ICI. Also, 1 contract request was approved and average contracts turnaround time was 1 day as of Oct 19.
 +
<div class="image-green-border">[[File:SP7 CLM Actiity Report 5.PNG|720px|C7.SP7 - CLM Activity Report 5]]<br/> &nbsp;</div> <div class="note-box">The ''Contract Requests Report'' will be displayed only if the Contract Request Contract Type is present.</div>
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
 
 +
== Masterdata Information Report ==
 +
 
 +
This report displays a summary of Masterdata and helps the user easily identify all the areas that will be affected or need to be modified by any change to the Masterdata Attribute values. The user can update and extract this detailed report on Masterdata and subsequently any reference of it in Rules, Contract Types, Contract Request, Masterdata, Agreements/ Amendments, Associations and User Groups where the given Masterdata Attribute value to make informed decisions. To access this report, users must have Configuration and Security group access. By default, the latest records are listed first but the list can be sorted as required.&nbsp;
 +
<div class="image-green-border">[[File:7.12 Masterdata Information Report.PNG|720px|7.12 Masterdata Information Report.PNG]]</div>
 +
For Contract types, all the Contract Type references where a particular Masterdata value (provided in the filter) is referred are displayed.&nbsp;<br/> The records displayed will include:
 +
 
 +
*Attributes of any Contract Type that is configured as a conditional attribute on another attribute (Masterdata Lookup). For example, the attribute Discount may be configured as a conditional attribute that will be applicable if the attribute Project Value is more than $500,000.
 +
*Any attribute of a Contract Type that is configured as a Lookup attribute and cascading is done on another attribute which is a Masterdata Lookup. For example, the attribute City (such as, New York) may be configured as a lookup and cascade on the attribute Country (such as, United States of America).
 +
 
 +
The report can be filtered using the following parameters:
 +
 
 +
*Contract Type
 +
*Attribute Name
 +
*Attribute Value
 +
 
 +
The Masterdata Information Report contains a ''Document Map'' on the left hand side that displays the only sections for which relevant records are present. Hyperlinks are provided for all the instances displayed in the report to easily navigate to the particular section.
 +
<div class="image-green-border">[[File:SP7 Masterdata Information Report - Document Map.png|720px|SP7 Masterdata Information Report - Document Map.png]]</div>
 +
The ''Contract Type'' section of the Masterdata Information Report can be filtered on the basis of the Contract Type and Attributes available for that Contract Type. Based on the applied filters, all the Contract Type references where a particular Masterdata value (provided in the filter) is referred are displayed. The records displayed will include:
 +
 
 +
*Attributes of any Contract Type that is configured as a conditional attribute of another attribute (Masterdata Lookup)
 +
*Any attribute of a Contract Type that is configured as a Lookup attribute and cascading is done on another attribute which is a Masterdata
 +
 
 +
The following columns are displayed:
 +
 
 +
*''Contract Type Name ''(hyperlink to the latest ''Contract Type Details'' page),&nbsp;''Contract Type Code,''&nbsp;''Type of Contract,''&nbsp;''Contract Type Version,''&nbsp;''Attribute Name,&nbsp;Attribute System Name.'''&nbsp;'''Status''
 +
<div class="image-green-border">[[File:SP7 Masterdata Information Report - Contract Type.png|720px|SP7 Masterdata Information Report - Contract Type.png]]</div>
 +
The ''Master Data'' section of the Masterdata Information Report can be filtered on the basis of the Contract Type and Attributes available for that Contract Type. Based on the applied filters, all the Masterdata instances where a particular Masterdata value (which is provided in the filter) is referred, with all instances that either Active or Inactive, are displayed.
 +
 
 +
The following columns are displayed:
 +
 
 +
*''Contract Type,&nbsp;Masterdata Name, Masterdata Code (hyperlink to the Masterdata Details page), Attribute Name,&nbsp;Attribute System Name, Status''
 +
<div class="image-green-border">''[[File:SP7 Masterdata Information Report - Masterdata.png|720px|SP7 Masterdata Information Report - Masterdata.png]]''</div>
 +
The&nbsp;''Agreements/Amendments ''section of the Masterdata Information Report can be filtered on the basis of the Contract Type and Attributes available for that Contract Type. Based on the applied filters, all the Agreement and Amendment instances where a particular Masterdata value (provided in the filter) is referred (Attributes or Template Variables) are displayed. Legacy Agreements are displayed as well.
 +
 
 +
The following columns are displayed:<br/> •&nbsp;&nbsp;&nbsp;&nbsp;''Agreement Name ''(hyperlink to the ''Agreement Details ''page),&nbsp;''Agreement Code,&nbsp;Attribute Name,&nbsp;Attribute System Name, ''''S''''tatus''
 +
<div class="image-green-border">''[[File:SP7 Masterdata Information Report - Agreements - Amendments.png|720px|SP7 Masterdata Information Report - Agreements - Amendments.png]]''</div>
 +
The ''Associations'' section of the Masterdata Information Report can be filtered on the basis of the Contract Type and Attributes available for that Contract Type. Based on the applied filters, all the Association instances for Agreements and Amendments where a particular Masterdata value (provided in the filter) is referred are displayed.
 +
 
 +
The following columns are displayed:<br/> •&nbsp;&nbsp;&nbsp;&nbsp;''Association Name ''(hyperlink to the ''Association Details'' page),&nbsp;''Association Type,&nbsp;Association Parent, Association Parent ID,&nbsp;Attribute Name.&nbsp;Attribute System Name, Status''
 +
<div class="image-green-border">''[[File:SP7 Masterdata Information Report - Associations.png|720px|SP7 Masterdata Information Report - Associations.png]]''</div>
 +
The ''Contract Request'' section of the Masterdata Information Report can be filtered on the basis of the Contract Type and Attributes available for that Contract Type. Based on the applied filters, all the Contract Type Requests’ references where a particular Masterdata value (provided in the filter) is referred are displayed.&nbsp;
 +
 
 +
The following columns are displayed:<br/> •&nbsp;&nbsp;&nbsp;&nbsp;''Contract Request Name ''(hyperlink to the Contract Request Details page),&nbsp;''Contract Request Code,&nbsp;Attribute Name,&nbsp;Attribute System Name,&nbsp;Status''
 +
<div class="image-green-border">''[[File:SP7 Masterdata Information Report - Contract Request.png|720px|SP7 Masterdata Information Report - Contract Request.png]]''</div>
 +
The ''Rules ''section of the Master Information Report can be filtered on the basis of the Contract Type and attributes available in the Attributes Name drop-down for that Contract Type. Based on the applied filters, all the Rules where a particular Masterdata value (which is provided in the filter) is referred is displayed.
 +
 
 +
The following columns are displayed:
 +
 
 +
*''Rule Name,&nbsp;Rule Type ''(hyperlink to the ''Rules Edit ''page),&nbsp;''Rule For,&nbsp;Rule Description,&nbsp;Active,&nbsp;Last Updated,&nbsp;Contract Type,&nbsp;Rule,&nbsp;Condition, Action''
 +
 
 +
A link to the ''User Groups'' is provided in the report that directs the user to the User Group page where you can manually verify if the particular Masterdata value (provided in the filter) is referred anywhere in the User Group.
 +
<div class="image-green-border">[[File:7.12 Masterdata Information Report User Groups.PNG|720px|7.12 Masterdata Information Report User Groups.PNG]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">
 +
== Tagged Attributes Report ==
 +
 
 +
With this release, a new “Tagged Attributes Report”, which helps administrators understand the complete profile of an attribute, and how it has been tagged across different clauses and templates. This provides them better visibility into attribute usage and saves them considerable time.
 +
 
 +
This report, available on the “Reports” tile, can be accessed based on the security groups configuration. The report can be filtered using the “Select Attribute” and “Select Entity” parameters. Based on the selected entity, the following columns are displayed – Clause/Template Code, Clause/Template Name, Contract Type, Clause/Template Version, Clause/Template Created By, Clause/Template Created On, Version Updated On, Attribute tagged as Template Variable, Attribute tagged as Clause extended attribute and Attribute Display Name.
 +
 
 +
To view the Tagged Attributes Report for a clause or a template:
 +
 
 +
1. '''Click '''the ''Reports ''tile on the ''Home ''page. The Reports page opens.
 +
 
 +
[[File:7.15 Tagged Attributes Report 01.png|720px]]<br/> &nbsp;<br/> 2. '''Click '''through to the Tagged Attributes Report using the right arrow icon. The report page opens.
 +
 
 +
[[File:7.15 Tagged Attributes Report 02.png|720px]]
 +
 
 +
&nbsp;<br/> 3. '''Filter '''using the following criteria:
 +
 
 +
*Attribute: Select the attribute for which you want to view the report.
 +
*Entity: Select Clauses or Templates or both.
 +
*Timezone: Select the time zone in which you want to view the report. The default selection is based on the user preferences of the logged in user.
 +
 
 +
4. '''Click '''''View Report''. The Tagged Attributes Report is displayed.
 +
 
 +
[[File:7.15 Tagged Attributes Report 03.png|720px]]<br/> &nbsp;<br/> The report displays ''Attribute Name'', ''Data Type'' of the attribute and whether the attribute ''Is Global''. It further displays two sections:
 +
 
 +
*Clauses: Displays columns ''Clause Code, Clause Name, Contract Type, Clause Version, Clause Created By, Clause Created On, Version Updated On, Is Template Variable, Is Extended Attribute'' and ''Attribute Display Name''.
 +
 
 +
&nbsp;[[File:7.15 Tagged Attributes Report 04.png|720px]]
 +
 
 +
*Templates: Displays ''Template Code, Template Name, Contract Type, Template Version, Template Created By, Template Created On, Version Updated On, Is Template Variable'' and ''Attribute Display Name''.
 +
 
 +
&nbsp;[[File:7.15 Tagged Attributes Report 05.png|720px]]
 +
 
 +
[[File:7.15 Tagged Attributes Report 06.png|720px]]<br/> &nbsp;<br/> The report can be downloaded in standard formats of Excel, PDF and CSV.<br/> [[File:7.15 Tagged Attributes Report 07.png|720px]]&nbsp;<br/> &nbsp;
 +
</div>
 +
&nbsp;
 +
 
 +
&nbsp;
 +
<div class="image-green-border">
 +
'''Related Topics:'''&nbsp;[[Reports|Overview of Reports]]&nbsp;| [[Agreement_details_page_reports|Agreement Details Page Reports]] |&nbsp;[[Legal_&_Compliance|Legal & Compliance Reports&nbsp;]]&nbsp;| [[Workflow_Reports|Workflow Reports]]&nbsp;| [[Obligation_Management_Reports|Obligation_Management_Reports]] | [[Sourcing_Reports|Sourcing Reports]]&nbsp;|
 
</div>
 
</div>

Latest revision as of 05:01, 25 January 2021

Admin Reports

The following reports belong to this category:

  • Average Agreement Turn Around Time
  • Clause Profiling Report
  • Clause Summary Report
  • Template-Clause Report
  • Cycle Time Report
  • User Profiling Report
  • User Login Report
  • Signature Type Report
  • CLM Activity Report
  • Masterdata Information Report

Average Agreement Turn Around Time

The Average Agreement Turn Around Time Report provides information on the average number of days required for executing an Agreement/Amendment, from the date of its creation till the date of its execution.

The report will only provide information that the user is authorized to view. The result displays a list of agreements for a Contract Type and provides details about the status changed date to be able to track the turnaround time. . The graphs summarize the average turn-around time for executing the Agreements along Contract Type and organization units.

The report displays the following columns with hyperlinks to the actual Agreement:

  • Agreement Code, Contract Type, Average turn around time (days)
  • Deviated By, Deviated Date andTime, Deviation Status, Comments Added By, Comments Added Date & Time, Comments, Approved By (multiple entries), or Approved Date & Time (multiple entries)
Reports Admin AverageAgreementTurnAroundTime.png

Clause Profiling Report

The Clause Profiling Report helps in the mapping of Clauses to the corresponding Templates, with respect to the selected Contract Types. It helps application administrators to view the impact of a particular Clause on all Templates that have the Clause added in the system. It displays the Clause, it’s corresponding version and the Template details in which that Clause has been incorporated. The base entity for the Report is Clause.

Even if the Clause does not have an associated Template, it must appear in the Report.

The filters to generate the report include Contract Type, Clause Name, Only Clauses and Is Latest. Contract Type and Clause Name are visible to the user based on their authorization.

If Only Clauses is set to True, only the Clause details are displayed in the Report; the Template details are not visible. However, if Only Clauses is set to False, then both the clauses and the respective template details are visible. The Default Value for this is False.

If Is Latest is set to True, only the latest version of the Clause will be displayed. However, if Is Latest is set to False, then all the versions of the Clause are displayed. The Default Value for this is False.

Based on the combinations of the applied filter, the following columns will be displayed with hyperlinks to the actual Agreement:

  • Contract Type Name, Clause Name, Clause Code, Clause Version, Template Name, Template Code, and Template Version.
RTENOTITLE

 


Clause Summary Report

Clause library maintenance is a crucial activity for any enterprise managing its contracts digitally. Administrators working with clause libraries also need to handle several recurring clause changes. 
The Clause Summary Report is being introduced in order to help clause administrators to understand the impact any changes made to a clause would have. This would enable them to assess how any clause has been used across different agreements, amendments, associations and templates. Further, these users would be able to identify which version of a clause was used in a particular entity. 
This default report is accessible from the Admin category of reports and its access will be based on Security Groups.

To view the clause summary report:

1. Click Reports tile. The Reports page opens.

7.14-ClauseSummaryReport.png

2. Click the arrows on the Reports page to navigate to the Clause Summary Report. 

7.14-ClauseSummaryReport1.png

3. Click Clause Summary Report. The Reports page opens displaying the Clause Name and Clause version list.

7.14-ClauseSummaryReport2.png

4. Select the Clause Name and the Clause version from the list and click View Report. For example, select Liquidated Damages Clause as the clause name and Select All to select clause versions 1 and 2.   

Note: By default, all the available clause versions will be selected. You can select any one or more than one version at a time to generate the report.

The Clause Summary Report is displayed for the selected clause and displays the following information.

  • Clause Summary: Displays information about the selected clause such as the Clause Name, Clause Code, Created By, Created On, Clause Language, whether the selected clause is a Primary Clause, if the selected clause is not a primary clause it displays the linked primary clause.
7.14-ClauseSummaryReport3.png
  • Clause Version Summary: Displays the following information.
    • Version: The different versions of the clause are listed as column headers. Details of each version are displayed in a separate column. Clicking the version number displays a sub-report for that version.
    • Status: Displays the status of the clause. For example, Approved.
    • Approvers: Displays the approver user added to the clause team. If there are no approvers added to the clause team this field will not display any information.
    • Is Latest: Displays Yes if the selected clause version is the latest version available in the system for the selected clause.
    • Contract Types: Displays the list of contract types with which the selected version of the clause is associated. For example, Purchase Agreement.
7.14-ClauseSummaryReportSummary.png
  • Clause Group: Displays the name of the Clause group to which the selected clause version belongs. 
  • Is Alternate Clause: Displays a Yes or No depending on whether the selected clause version is an alternate version of another clause or not.
  • Alternate Of: Displays the name of the clause of which the selected clause version is an alternate.
  • Is Mandatory: Displays a Yes or No depending on whether the selected clause version is mandatory to be added to the contract.
  • Is Editable: Displays a Yes or No value depending on whether the selected clause version can be edited when used.
  • Deviation Analysis: Displays a Yes or No value depending on whether ICI tracks the deviations for the selected clause.
  • Is Dependent: Displays a Yes or No value depending on whether the selected clause is dependent on another clause.
  • Depends On: Displays the name of the clause on which the selected clause version is dependent.
  • Clause Text: Displays the clause text for the selected clause version.
  • File: Displays the name of the file attached, if any, for the selected clause version.
  • Clause Description: Displays the description of the selected clause, if added.
7.14-ClauseSummaryReport-ActionsAllowed.png

5. Click the version number, for example Version 1. The sub-report for the selected clause version is displayed. 

7.14-ClauseSummaryReportSummary2.png
 
7.14-ClauseVersionSummary.png
 
In this example, Version 1 has been used in 2 templates, Template_56 and Template_58
6. Click the back button to go back to the parent report and click Version 2 (see Step 5). The sub-report for that version is displayed with the following columns: Agreement Code, Version, Contract Type, Agreement Name, Agreement Created By, Agreement Created On and Agreement Status. In this example, Version 2 is used in 115 agreements, among other entities.
7.14-ClauseVersionSummary1.png

7. Click the arrows above the report to navigate ahead to the remaining pages, to view other entities where the selected Liquidated Damages Clause Version 2 has been used.

Note: Select an entity from the Entity Name field and click View Report to filter the sub-report by entities. This displays the entities where the selected clause version has been used, such as Agreement, Amendment, Associations and Templates. One or more entities can be selected at a time.

Actions allowed on Clause Summary Report 

You can perform the following actions on the Clause Summary Report page.

  • Find: Search and view the clause versions for the selected clause.
  • Export: Select the format to which you want to export the clause summary report. You can export it to Excel, PDF and CSV (comma delimited) format.
  • Refresh: Click Refresh to refresh the clause summary report page to view the latest information on the Clause Summary Report page.
7.14-ClauseSummaryReport-Export.png
 
The report is enhanced to display a Clause Extension Summary which displays details on extended clause attributes. If the Clause Extended Entity is defined for an ICI instance, then this report will display the information of the clause extension attributes. Further, the Clause Extension Summary will display the latest values of clause extension attributes.
 
The additional attributes added for the clause will be displayed in the Clause Extension Summary section.
 
7.15 CSR.png
 

Template Clause Report

The Template Clause Report helps mapping Templates to the corresponding Clauses, with respect to the Contract Types. It helps application administrators to view the impact when a particular Clause or Template is changed in the system. It displays the Template, it’s corresponding version and the clauses present in the respective Template. The base entity for this Report is the Template.

The filters to generate the Report include Contract Type, Clause Name, Only Clauses and Is Latest. Contract Type and Clause Name are visible to the user based on their authorization.

If Only Templates is set to True, only the Template details are displayed in the Report; the Clause details are not visible. However, if Only Templates is set to False, then both the templates and the respective clause details are visible. The Default Value for this is False.

If Is Latest is set to True, only the latest version of the Template will be displayed. However, if Is Latest is set to False, then all the versions of the Template are displayed. The Default Value for this is False.

Based on the combinations of the applied filter, the following columns will be displayed with hyperlinks to the actual Agreement:

  • Contract Type Name, Template Name, Template Code, Template Version, Clause Name, Clause Code, and Clause Version.

The report is sort by the alphabetical order of the Contract Type name followed by the alphabetical order of the Template name, followed by ascending order of Template version.

RTENOTITLE

Cycle Time Report

The Cycle Time Report is a drill down report that shows the cycles for an Agreement and the change of status from the date of creation to the date of execution as well as the elapsed time. The purpose of this Report is to enable you detect the deficiencies in the processes and turnaround time for tasks. It helps you identify patterns that lead to longer cycle times and take corrective actions in the process and streamline it better. 

Reports can be filtered using the Entity field with the following values: Agreements, Agreements with Contract Request, and Contract Requests.

RTENOTITLE

When the user selects Agreements:

  • Amendments will also be displayed.
  • An additional column Parent Agreement Code has been added to the tabular data that will display the parent Agreement of the Amendment.
RTENOTITLE

 

RTENOTITLE

When the user selects Agreements with Contract Request:

  • A chart appears that displays the Contract Type by Average Cycle Time for all Agreements that have been created through Contract Requests. Clicking the Contract Type on this chart opens another chart that displays the Contract Requests by Status. The possible states include Waiting for Contract Creation, Draft, Waiting For Approval, Approved, Waiting For Internal Signature, Waiting For External Signature, On Hold, Cancelled, Contract Request Draft, Contract Request Waiting For Approval, Contract Request Approved, Waiting For Contract Creation, Contract Request On Hold, and Contract Request Cancelled. 
  • The following columns have been added to the tabular data – Contract Request Code, Contract Request Name, Contract Request Created Date, and Type of Agreement. 


When the user selects Contract Requests:

  • A chart appears that displays the Contract Type by Average Cycle Time for all Contract Requests. Clicking the Contract Type on this chart opens another chart that displays the Contract Requests by Status (Draft, Waiting For Approval, and Approved).
RTENOTITLE
 
RTENOTITLE

Each time the Agreement returns to a previous state, a new entry is created. For example, If the approver is rejected and the Agreement comes back to the Draft state it is recalled from Waiting for External Signature state and so on. This is applicable only to executed Agreements. Each cycle is displayed as a new row when expanded. The excel export takes care of the relevant groupings and display all the data. This report displays charts. These charts help the user to easily compare the average cycle time for different contract types. They also help to easily identify the status in which Agreements remain for a longer duration. 

The Bar graph on the left hand side displays the Contract Type by Average Cycle Time. By default, the report is filtered by Time Duration In Days, but you have the option to filter it by Hours as well. Clicking a bar on the graph displays the chart on the right hand side that displays the Average Cycle Time by Status of the Contract.

For example, the following two Agreements are displayed in the list: Agreement ICIMSA_SD (Total Duration – 3.87) and Agreement (Total Duration – 0.07). The bar on the chart displays an average of the total duration of these 2 reports i.e. 3.87+0.07/2 == 1.97

Clicking the bar on the Agreement ICIMSA_SD will display the Average Cycle Time Status (Approved, Draft, WaitingForApproval orWaitingForExternalSignature) chart for this Agreement in days on the right hand side.

The Report can be filtered on the Contract Type, total cycle time, the date range of creation as well as the duration in days/hours.

Based on the applied filter, the result provides details about the date of creation and execution, the duration of the report whether it is in the draft, approval, waiting for signature or executed state for an Agreement.

The following columns with hyperlinks to the actual Agreement will be displayed:

  • Agreement Code, Agreement Name, Primary Owner, Created Date, OU, Execution Date, Total Duration (Days), Draft Duration (Days), Waiting for Approval Duration (Days), Approved Duration (Days), Waiting for Internal Signature Duration (Days), Waiting for External Signature Duration (Days), On Hold Duration (Days), and Cancelled Duration (Days).
 

User Profiling Report

The User Profiling Report helps you find details associated to an individual user such as the role, groups and the associated entities. This enables you to interpret the impact of the user on the system, the impact of deprovisioning a user, and so on. The Report helps to analyze the critical actions pending for a user that may have a big impact. It also provides a direct link to the records and configuration modification which can help curb the impact. It can also act as a prerequisite to the Replace User functionality.

The report can be filtered by searching a user by name or email ID, the entity name or status or the role of the user and then clicking View Report which generates entities for the specified user name. This is followed by email ID, name of the entity and its status. You can also filter the Report by the role of the user.

Based on the applied filter, different set of columns will be displayed for each entity association type. The result includes details of the user including the name, email, associated groups, organization path and the roles assigned thus helping to identify critical actions related to the use.

The following columns will be displayed with hyperlinks to the actual Agreement:

  • User Name, Email ID, Organization Unit Path, and Roles Assigned

When the flag Show Only Orphan Records is toggled to Yes, the records where the selected user is the only active (Primary/Secondary) user is displayed, so that you can easily identify the number of records that would get orphaned on de-provisioning the selected user. When the flag Show Only Orphan Records is toggled to No, all records where this user is part of the team, irrespective of the role, are displayed.

User Profiling Report - C7.SP6
 

User Login Report

The User Login Report provides information of all user logins for a selected date range. It provides an insight on the adoption of the tool by providing details for the user as well as which function, unit and region is using the tool.

The possible filters to generate this report include the date range (by default current date minus 7 days) or the user name (as a type ahead or free text entry).

The result includes details such as the type of user, the login date and time, how long a user was active in the system, the IP address, and so on.

As a result, the following columns will display with hyperlinks to the actual Agreement:

  • User Name, User Email Address, Organization Unit (path), Type Of User, Login Date and Time, and IP Address.

The IP Address column captures the IP address from all possible scenarios along with the Session Start Time. 

The report is sorted by the alphabetical order of the user name first followed by the descending order of the login date.

Reports Admin UserLoginReport.png

Signature Type Report

The Signature Type Report provides information on the percentage of Contracts that have been executed manually as compared to electronically. Electronic signatures have become popular as companies have started going green and minimizing the use of paper. Since this involves the entire ecosystem and is a time-consuming process, this Report provides visibility into the number of contracts that are signed manually against those signed electronically to facilitate compliance and adoption.

The filters to generate this report include the date range that helps to filter Agreements that moved to the Executed state for a Contract Type. inclusive of both dates. The results includes the Agreement details, its state, the effect and expiration date, the signature type, and so on.Multiple graphs may be seen based on the organizational units.

The following columns are displayed with hyperlinks to the actual Agreement:

  • Agreement Code, Agreement Name, Contract Type Name, Status, Business Status, Effective Date, Expiry Date, Signature Type, and Type Of Paper.

The report is sort by alphabetical order of the Contract Type followed by the alphabetical order of Agreement code.

Reports Admin SignatureTypeReport img1.png
 
Reports Admin SignatureTypeReports img2.png
 

 

 

CLM Activity Report

This report gives a quick view for the CTOs, CFOs, etc. on the current high level status of the Agreements, Contract Requests and user activity to gauge the adoption of the ICI platform in their organization and take corrective action to increase adoption of the platform. The report can be filtered on the Frequency either Day Wise (default), Week Wise and Month Wise.
 
7.12 CLM Activity Report.PNG
 
This report is filtered on the Frequency either Day Wise, Week Wise and Month Wise. By default, the Day Wise frequency is selected. 
On selecting the Day Wise option, the report displays the trend for the last 15 days (excluding the present day). However, for the Week Wise, the report displays the trend for the last 12 weeks (excluding the present week) and the Month Wise option displays the trend for the last 12 months (excluding the present month). 
 
Above this report, a Summary (cumulative numbers) since customer onboarding displays: 
  • The Total Contracts Created
  • The Total Contracts Executed
  • The number of Active Users
  • The Average Contract Cycle Time (in Days)
C7.SP7 - CLM Activity Report 2
 
For example, in the report shown in the screenshot below, the Summary tile displays that 644 contracts were created, of which 109 contracts were executed till date. A total of 18 users have logged in to the system since customer onboarding and the overall average contract cycle time is 0.71 days to date.
 
The information provided in the CLM Activity Report is based on the following 3 reports:
 
1. The User Activity Report includes the following information:
  • Total Users Provisioned (line graph)
  • Active Users (line graph)
For example, in the report shown below in the screenshot, on Oct 24, 94 users were provisioned in the system and of which, 9 users logged in to the system on that day.
 
C7.SP7 - CLM Activity Report 3
 
2. The Contracts Report includes the following information:
  • Average Contract Turnaround Time (line graph)
  • Contracts Created (bar chart)
  • Contracts In Progress (bar chart) 
  • Contracts Executed (bar chart) 

For example, in the report shown in the screenshot below, on Oct 23, 81 contracts were created in ICI. Apart from that, 366 contracts were in progress and only 9 contracts got executed on that date. The average contract turnaround time was 14 days on Oct 23.

C7.SP7 - CLM Activity Report 4

3. The Contract Requests includes the following information:

  • Average Contracts Turnaround Time (line graph)
  • Total Contract Requests Approved (bar chart)
  • Total Contract Requests Created (bar chart) 

For example, in the report shown in the screenshot below, on Oct 19, 7 contract requests were created in ICI. Also, 1 contract request was approved and average contracts turnaround time was 1 day as of Oct 19.

C7.SP7 - CLM Activity Report 5
 
The Contract Requests Report will be displayed only if the Contract Request Contract Type is present.

 

 


Masterdata Information Report

This report displays a summary of Masterdata and helps the user easily identify all the areas that will be affected or need to be modified by any change to the Masterdata Attribute values. The user can update and extract this detailed report on Masterdata and subsequently any reference of it in Rules, Contract Types, Contract Request, Masterdata, Agreements/ Amendments, Associations and User Groups where the given Masterdata Attribute value to make informed decisions. To access this report, users must have Configuration and Security group access. By default, the latest records are listed first but the list can be sorted as required. 

7.12 Masterdata Information Report.PNG

For Contract types, all the Contract Type references where a particular Masterdata value (provided in the filter) is referred are displayed. 
The records displayed will include:

  • Attributes of any Contract Type that is configured as a conditional attribute on another attribute (Masterdata Lookup). For example, the attribute Discount may be configured as a conditional attribute that will be applicable if the attribute Project Value is more than $500,000.
  • Any attribute of a Contract Type that is configured as a Lookup attribute and cascading is done on another attribute which is a Masterdata Lookup. For example, the attribute City (such as, New York) may be configured as a lookup and cascade on the attribute Country (such as, United States of America).

The report can be filtered using the following parameters:

  • Contract Type
  • Attribute Name
  • Attribute Value

The Masterdata Information Report contains a Document Map on the left hand side that displays the only sections for which relevant records are present. Hyperlinks are provided for all the instances displayed in the report to easily navigate to the particular section.

SP7 Masterdata Information Report - Document Map.png

The Contract Type section of the Masterdata Information Report can be filtered on the basis of the Contract Type and Attributes available for that Contract Type. Based on the applied filters, all the Contract Type references where a particular Masterdata value (provided in the filter) is referred are displayed. The records displayed will include:

  • Attributes of any Contract Type that is configured as a conditional attribute of another attribute (Masterdata Lookup)
  • Any attribute of a Contract Type that is configured as a Lookup attribute and cascading is done on another attribute which is a Masterdata

The following columns are displayed:

  • Contract Type Name (hyperlink to the latest Contract Type Details page), Contract Type Code, Type of Contract, Contract Type Version, Attribute Name, Attribute System Name. Status
SP7 Masterdata Information Report - Contract Type.png

The Master Data section of the Masterdata Information Report can be filtered on the basis of the Contract Type and Attributes available for that Contract Type. Based on the applied filters, all the Masterdata instances where a particular Masterdata value (which is provided in the filter) is referred, with all instances that either Active or Inactive, are displayed.

The following columns are displayed:

  • Contract Type, Masterdata Name, Masterdata Code (hyperlink to the Masterdata Details page), Attribute Name, Attribute System Name, Status
SP7 Masterdata Information Report - Masterdata.png

The Agreements/Amendments section of the Masterdata Information Report can be filtered on the basis of the Contract Type and Attributes available for that Contract Type. Based on the applied filters, all the Agreement and Amendment instances where a particular Masterdata value (provided in the filter) is referred (Attributes or Template Variables) are displayed. Legacy Agreements are displayed as well.

The following columns are displayed:
•    Agreement Name (hyperlink to the Agreement Details page), Agreement Code, Attribute Name, Attribute System Name, 'S'tatus

SP7 Masterdata Information Report - Agreements - Amendments.png

The Associations section of the Masterdata Information Report can be filtered on the basis of the Contract Type and Attributes available for that Contract Type. Based on the applied filters, all the Association instances for Agreements and Amendments where a particular Masterdata value (provided in the filter) is referred are displayed.

The following columns are displayed:
•    Association Name (hyperlink to the Association Details page), Association Type, Association Parent, Association Parent ID, Attribute Name. Attribute System Name, Status

SP7 Masterdata Information Report - Associations.png

The Contract Request section of the Masterdata Information Report can be filtered on the basis of the Contract Type and Attributes available for that Contract Type. Based on the applied filters, all the Contract Type Requests’ references where a particular Masterdata value (provided in the filter) is referred are displayed. 

The following columns are displayed:
•    Contract Request Name (hyperlink to the Contract Request Details page), Contract Request Code, Attribute Name, Attribute System Name, Status

SP7 Masterdata Information Report - Contract Request.png

The Rules section of the Master Information Report can be filtered on the basis of the Contract Type and attributes available in the Attributes Name drop-down for that Contract Type. Based on the applied filters, all the Rules where a particular Masterdata value (which is provided in the filter) is referred is displayed.

The following columns are displayed:

  • Rule Name, Rule Type (hyperlink to the Rules Edit page), Rule For, Rule Description, Active, Last Updated, Contract Type, Rule, Condition, Action

A link to the User Groups is provided in the report that directs the user to the User Group page where you can manually verify if the particular Masterdata value (provided in the filter) is referred anywhere in the User Group.

7.12 Masterdata Information Report User Groups.PNG
 

Tagged Attributes Report

With this release, a new “Tagged Attributes Report”, which helps administrators understand the complete profile of an attribute, and how it has been tagged across different clauses and templates. This provides them better visibility into attribute usage and saves them considerable time.

This report, available on the “Reports” tile, can be accessed based on the security groups configuration. The report can be filtered using the “Select Attribute” and “Select Entity” parameters. Based on the selected entity, the following columns are displayed – Clause/Template Code, Clause/Template Name, Contract Type, Clause/Template Version, Clause/Template Created By, Clause/Template Created On, Version Updated On, Attribute tagged as Template Variable, Attribute tagged as Clause extended attribute and Attribute Display Name.

To view the Tagged Attributes Report for a clause or a template:

1. Click the Reports tile on the Home page. The Reports page opens.

7.15 Tagged Attributes Report 01.png
 
2. Click through to the Tagged Attributes Report using the right arrow icon. The report page opens.

7.15 Tagged Attributes Report 02.png

 
3. Filter using the following criteria:

  • Attribute: Select the attribute for which you want to view the report.
  • Entity: Select Clauses or Templates or both.
  • Timezone: Select the time zone in which you want to view the report. The default selection is based on the user preferences of the logged in user.

4. Click View Report. The Tagged Attributes Report is displayed.

7.15 Tagged Attributes Report 03.png
 
The report displays Attribute Name, Data Type of the attribute and whether the attribute Is Global. It further displays two sections:

  • Clauses: Displays columns Clause Code, Clause Name, Contract Type, Clause Version, Clause Created By, Clause Created On, Version Updated On, Is Template Variable, Is Extended Attribute and Attribute Display Name.

 7.15 Tagged Attributes Report 04.png

  • Templates: Displays Template Code, Template Name, Contract Type, Template Version, Template Created By, Template Created On, Version Updated On, Is Template Variable and Attribute Display Name.

 7.15 Tagged Attributes Report 05.png

7.15 Tagged Attributes Report 06.png
 
The report can be downloaded in standard formats of Excel, PDF and CSV.
7.15 Tagged Attributes Report 07.png 
 

 

 

Related Topics: Overview of Reports | Agreement Details Page Reports | Legal & Compliance Reports  | Workflow Reports | Obligation_Management_Reports | Sourcing Reports |

Retrieved from "https://iciwikiapac.icertis.com:15443/ICIHelp7.15/index.php?title=Admin_Reports&oldid=15815"