From ICIHelp8.1
Jump to: navigation, search
Line 1: Line 1:
  
= '''Admin Reports''' =
+
= Admin Reports =
  
 
The following reports belong to this category:
 
The following reports belong to this category:
  
#Average Agreement Turn Around Time  
+
*Average Agreement Turn Around Time  
#Clause Profiling Report  
+
*Clause Profiling Report  
#Template-Clause Report  
+
*Template-Clause Report  
#Agreement Cycle Time Report  
+
*Agreement Cycle Time Report  
#User Profiling Report  
+
*User Profiling Report  
#User Login Report  
+
*User Login Report  
#Signature Type Report  
+
*Signature Type Report  
  
 
== Average Agreement Turn Around Time ==
 
== Average Agreement Turn Around Time ==
  
This 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 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 is auto-filtered for the current agreement/amendment and 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 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:
+
The report displays the following columns with hyperlinks to the actual Agreement:
  
 
*''Agreement Code, Contract Type, Average turn around time ''(days)  
 
*''Agreement Code, Contract Type, Average turn around time ''(days)  
*''Deviated By, Deviated Date & 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:AvgAgreementTurnAroundTimeReport.PNG|900px|Average Agreement Turn Around Time Report]]</div>  
 
<div class="image-green-border">[[File:AvgAgreementTurnAroundTimeReport.PNG|900px|Average Agreement Turn Around Time Report]]</div>  
 
== Clause Profiling Report ==
 
== 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 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.
+
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.&nbsp;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.
+
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.
 
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 ''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”.
+
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 permutations and combinations of the applied filter, the following columns will be displayed with hyperlinks to the actual agreement:
+
Based on the&nbsp;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.''  
+
*''Contract Type Name, Clause Name, Clause Code, Clause Version, Template Name, Template Code,'' and&nbsp;''Template Version.''  
 
<div class="image-green-border">[[File:ClauseProfilingReport.PNG|900px|Clause Profiling Report]]</div>  
 
<div class="image-green-border">[[File:ClauseProfilingReport.PNG|900px|Clause Profiling Report]]</div>  
 
== Template Clause Report ==
 
== Template Clause Report ==
  
The Template Clause Report helps mapping templates to the corresponding clauses, with respect to the contract types. 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 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.&nbsp;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.
+
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 ''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”.
+
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 permutations and combinations of the applied filter, the following columns will be displayed with hyperlinks to the actual agreement:
+
Based on the&nbsp;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.''  
 
*''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 clause name, followed by ascending order of clause 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:TemplateClauseReport.PNG|900px|Template Clause Report]]</div>  
 
<div class="image-green-border">[[File:TemplateClauseReport.PNG|900px|Template Clause Report]]</div>  
 
== Agreement Cycle Time Report ==
 
== Agreement Cycle Time Report ==
  
The Agreement Cycle Time Report is a drill down report that shows the cycles for each of the record based status change to previous states. The purpose of this report is to enable you detect the deficiencies in the processes and turnaround time for tasks.&nbsp;
+
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;
  
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 etc. 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.
+
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.
  
Using filters for 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 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 following columns with hyperlinks to the actual agreement will be displayed:
+
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).''  
 
*''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).''  
Line 71: Line 73:
 
== User Profiling Report ==
 
== 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, etc. The report helps to analyse 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 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&nbsp;'''clicking&nbsp;'''''View Report&nbsp;''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.
  
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.<br/> Based on the applied filter,&nbsp;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.
+
Based on the applied filter, different set of columns will be displayed for each entity association type.&nbsp;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:
 
The following columns will be displayed with hyperlinks to the actual agreement:
Line 85: Line 89:
 
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 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, etc.
+
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:
+
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 & Time, Session Duration (Hrs), ''and''IP Address.''  
+
*''User Name, User Email Address, Organization Unit ''(path)'', Type Of User, Login Date ''and''Time, Session Duration (Hrs), ''and&nbsp;''IP Address.''  
  
The report is sort 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:UserLoginReport.PNG|900px|User Login Report]]</div>  
 
<div class="image-green-border">[[File:UserLoginReport.PNG|900px|User Login Report]]</div>  
 
== Signature Type Report ==
 
== Signature Type Report ==
  
The Signature Type Report provides information on the percentage of contracts that have been executed manually vs. digitally. 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 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, etc.
+
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 display with hyperlinks to the actual agreement:
+
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.''  
 
*''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.
+
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:SignatureTypeReport.PNG|900px|Signature Type Report]]</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:SignatureTypeReport.PNG|900px|Signature Type Report]]</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">
 
'''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;|
 
'''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;|
 
</div>
 
</div>

Revision as of 12:43, 15 February 2018

Admin Reports

The following reports belong to this category:

  • Average Agreement Turn Around Time
  • Clause Profiling Report
  • Template-Clause Report
  • Agreement Cycle Time Report
  • User Profiling Report
  • User Login Report
  • Signature Type 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)
Average Agreement Turn Around Time Report

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.
Clause Profiling Report

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.

Template Clause Report

Agreement 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.  

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.

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).
Average Cycle Time Report

 

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
User Profiling Report

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 andTime, Session Duration (Hrs), and IP Address.

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

User Login Report

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.

Signature Type Report