Installed with Assessments and Surveys
Several types of components are installed with the activation of Assessments and Surveys.
- Demo data is available for Assessments and Surveys.
- ServiceNow® Vendor Performance offers an extra set of vendor assessment demo data.
Tables
| Table | Description: Assessments | Description: Surveys |
|---|---|---|
| Assessable Record \[asmt\_assessable\_record\] | Stores all assessable records. | For system use only. |
| Assessment Category Result \[asmt\_category\_result\] | Stores all category results. | For system use only. |
| Assessment Category User \[asmt\_m2m\_category\_user\] | Stores associations between users and metric categories that they can evaluate. A user that is associated to a category is a category user. | Stores associations between users and surveys. A user that is associated to a survey is a survey user and is automatically associated to all the survey's categories. |
| Assessment Group \[asmt\_assessment\] | Stores all assessment groups. | For system use only. |
| Assessment Instance \[asmt\_assessment\_instance\] | Stores all assessment instances. | Stores all survey instances. |
| Assessment Instance Question \[asmt\_assessment\_instance\_question\] | Stores all assessment instance questions, each of which represents one question on one assessment instance. | Stores all survey instance questions, each of which represents one question on one survey instance. |
| Assessment Metric \[asmt\_metric\] | Stores all metrics. | Stores all survey questions. |
| Assessment Metric Definition \[asmt\_metric\_definition\] | Stores all metric definitions. | Stores all answer options for survey questions. |
| Assessment Metric Template \[asmt\_template\] | Stores all metric templates. | Stores all question templates. |
| Assessment Metric Type \[asmt\_metric\_type\] | Stores all metric types. | Stores all survey definitions. |
| Assessment Stakeholders \[asmt\_m2m\_stakeholder\] | Stores associations between assessable records and category users. A category user that is associated to an assessable record is a stakeholder. | Not used for surveys. |
| Assessment Template Definition \[asmt\_template\_definition\] | Stores all metric template definitions. | Stores all question template definitions. |
| Assessment X Category Matrix \[asmt\_m2m\_xcategory\_matrix\] | Users can specify metric categories as the X axis of a decision matrix. | Not used for surveys. |
| Assessment Y Category Matrix \[asmt\_m2m\_ycategory\_matrix\] | Users can specify metric categories as the Y axis of a decision matrix. | Not used for surveys. |
| Bubble Chart \[asmt\_bubble\_chart\] | Stores all bubble chart definitions. | Not used for surveys. |
| Category Assessable Records \[asmt\_m2m\_category\_assessment\] | Stores associations between assessable records and metric categories. | For system use only. |
| Decision Matrix \[asmt\_decision\_matrix\] | Stores all decision matrixes. | Not used for surveys. |
| Metric Category \[asmt\_metric\_category\] | Stores all metric categories. | Stores all survey categories. |
| Metric Result \[asmt\_metric\_result\] | Stores all metric results. | Stores all survey responses. |
| Signature \[asmt\_signature\] | Stores all signature records for assessments and \[\[Attestations\|GRC attestations\]\]. | Stores all signature records forSurveys. |
| Trigger Condition \[asmt\_condition\] | Stores all assessment trigger conditions. | Stores all survey trigger conditions. |
Properties
You can configure various properties to customize the appearance of Assessments and Surveys questionnaires, require authentication for user signatures, open surveys in the Service Portal view from emails, and limit the number of items shown in a decision matrix field filter.
Assessments and Surveys installs the following properties. You can find these properties by navigating to the following locations:
- All > Assessments > Administration > Assessment Properties
- All > Survey > Administration > Properties
Important: You can customize the css.assessment.question.header.background.color, assessment.caption.background.color, and the css.assessment.caption.font.color fields only if Next Experience is turned off.
| Property | Description |
|---|---|
| sn\_portal\_surveys.sp\_survey.email\_redirection | When this property is enabled, users can use a link in an email to open a survey or assessment in Service Portal.- Type: Yes or No - Default value: Yes |
| com.snc.assessment.signature\_authentication | When this property is enabled, an authentication is required by user signature. When Yes is selected, this property requires credentials for a full name signature.- Type: Yes or No - Default value: Yes For more information about working with signatures, see Signatures. |
| com.snc.assessment.collect.stats | List of Assessments for which Recent Sent & Recent Completed stats must be collected in an asmt\_assessment\_stat table. Comma-separated list of eligible Assessment Metric Type Sys IDs. |
| css.assessment.question.header.background.color | Background color of question headers on assessment and survey questionnaires.- Type: Color - Default value: #767676 |
| sn\_portal\_surveys.sp\_survey.show\_progress\_bar | Shows or hides a progress bar on the survey pages on Service Portal.- Type: Yes or No - Default value: Yes Note: If the Pagination setting is set to None, the survey is displayed in a single page, and no progress bar is shown. |
| show\_lang\_picker\_for\_publicsurveys | Enable or disable whether to show language picker when a public survey is taken.- Type: Yes or No - Default value: Yes |
| css.assessment.caption.background.color | Sets the background color of the caption on assessment and survey questionnaires.- Type: Color - Default value: #eee |
| com.snc.assessment.decision\_matrix\_filter\_max\_entries | Maximum number of items to show for a decision matrix field filter.- Type: integer - Default value: 1000 |
| css.assessment.caption.font.color | Sets the font color of the caption text on assessment and survey questionnaires.- Type: color - Default value: #ffffff |
For more information about customizing the appearance of a survey, see Customize the appearance of a survey.
User roles
| Role title \[name\] | Description | Contains roles |
|---|---|---|
| assessment administrator\[assessment\_admin\] | Can administer the Assessments application. Can access all the modules of the Assessments application.Note: The assessment_admin role is contained by the itil_admin role. This role is also contained by the survey_admin role. | None |
Script includes
| Name | Description |
|---|---|
| AssessmentUtils | Core code for assessment functionality. |
| AssessmentUtilsAJAX | AJAX-based code for displaying scorecard data. |
| MigrateSurveyToAssessment | Code for migrating legacy surveys to assessment surveys. |
| RatingUtilsAJAX | Reserved for future use. |
| SurveyUtils | Core code for survey functionality. |
Client scripts
| Name | Table | Description |
|---|---|---|
| Calculate Assessable Record Field choice list | Trigger Condition \[asmt\_condition\] | Limits the Assessable Record Field choices to those choices that are compatible with the selected assessment. |
| Check survey schedule period | Trigger Condition \[asmt\_condition\] | Checks the selected survey definition's Schedule period. If Schedule period is set to Only Once, this client script displays a warning message that each user can only take the selected survey once. |
| Clear display\_when when depends changed | Assessment Metric \[asmt\_metric\] | Shows the Display when field when the Depends on field is set. Clears the Display when field when the Depends on field changes and the options must change. |
| Conditionally Set Type for Surveys | Group \[sys\_user\_group\] | Sets the user group Type to survey if you create a new group from the User Groups module. |
| Data type -- Hide choices for surveys | Assessment Metric \[asmt\_metric\] | Ensures only Data type options that are valid for surveys are available on the Survey Question form. |
| Data type -- Show/Hide Not Applicable | Assessment Metric \[asmt\_metric\] | Hides the Allow not applicable field and sets its value to false if the metric method is Assessment and the data type is Percentage, Checkbox, Date, Date/Time, Number, or String. |
| Data type defaults to String for surveys | Assessment Metric \[asmt\_metric\] | Sets the default Data type field value to String on the Survey Question form. |
| Fetch Min/Max | Assessment Metric \[asmt\_metric\] | Updates the Min and Max fields to match the least and greatest metric template definition values if an assessment administrator selects or changes the Template value. |
| Hide Assessable Record Field | Trigger Condition \[asmt\_condition\] | Hides the Assessable Record field unless the evaluation method of the metric type selected in the Assessment field is Assessment. |
| Hide Survey Instance Trigger ID if empty | Assessment Instance \[asmt\_assessment\_instance\] | Hides the Trigger ID field and makes it read-only unless it contains a value. |
| Hide user lists | Assessable Record \[asmt\_assessable\_record\] | Hides the Category users related list if the associated metric type schedule type is On demand. |
| Hide user related lists | Metric Category \[asmt\_metric\_category\] | Hides the User related list if the associated metric schedule type is On demand and the Evaluation method isn't Survey. |
| Hide value or String value | Assessment Instance Question \[asmt\_assessment\_instance\_question\] | Hides the Value field and shows the String value field if the associated metric data type is Date, Date/Time, or String. Does the opposite if the data type is anything or else. |
| Live feed deletion warning | Assessable Record \[asmt\_assessable\_record\] | Displays a warning message if an assessment administrator clears the Live feed check box. |
| Method -- Show/Hide Not applicable | Assessment Metric \[asmt\_metric\] | Hides the Mandatory and Allow not applicable fields and sets both values to false if the metric method is Script. Shows the Mandatory field if the metric method is Assessment. Shows the Allow not applicable field if the method is Assessment, except when the data type is Percentage, Checkbox, Date, Date/Time, Number, or String. |
| Min/Max Control | Assessment Metric \[asmt\_metric\] | Makes the Min and Max fields mandatory except when the data type is Template. |
| Min/Max Read-only | Assessment Metric \[asmt\_metric\] | Makes the Min and Max fields read-only when the data type is Choice or Likert Scale. |
| Populate Groups | Assessment Metric Type \[asmt\_metric\_type\] | Populates the available values for the Filter field with fields from the selected metric type table. |
| Read only Type | Metric Category \[asmt\_metric\_category\] | Makes the Type field read-only when it contains a value. |
| Reload Decision Matrix Filter Columns | Assessment Metric Type \[asmt\_metric\_type\] | Populates the available choices for the Default matrix filter as appropriate if the Filter field value changes. |
| Reload default filters | Assessment Metric Type \[asmt\_metric\_type\] | Populates the available choices for the Default filter as appropriate if the Display all filters value changes. |
| Set scale factor | Assessment Metric Type \[asmt\_metric\_type\] | Reserved for future use. |
| Set table field | Metric Category \[asmt\_metric\_category\] | Sets the category Table value to that of the metric type. |
| Show and Hide Scheduled Job | Assessment Metric Type \[asmt\_metric\_type\] | Hides the Scheduled job field if the Schedule type is On demand and shows the Scheduled job field if the Schedule type is Scheduled. |
| Show and Hide Scheduled Job Survey View | Assessment Metric Type \[asmt\_metric\_type\] | Shows the Scheduled job field on the Survey Definition form if the Schedule period is Daily, Weekly, Monthly, or Yearly. |
| Toggle Metric Definitions \(Load\) | Assessment Metric \[asmt\_metric\] | Displays the Assessment Metric Definitions related list if the data type is Choice or Likert Scale. |
| Toggle Metric Definitions \(Update\) | Assessment Metric \[asmt\_metric\] | Displays the Assessment Metric Definitions related list if the data type is Choice or Likert Scale. Sets the Method field to the appropriate value if the data type is compatible with one method only. |
| Update Min And Max Default Values | Assessment Metric \[asmt\_metric\] | Sets reasonable default values for the Min and Max fields, based on the data type. |
| Validate Probability | Survey Trigger Condition \[asmt\_condition\] | Ensures that the Probability (%) value is a whole number between 1 and 100. |
| Verify Max | Assessment Metric \[asmt\_metric\] | Verifies that the Max value is greater than the Min value and greater than or equal to zero if the metric method is Assessment. |
| Verify Min | Assessment Metric \[asmt\_metric\] | Verifies that the Min value is less than the Max value and greater than or equal to zero if the metric method is Assessment. |
| Verify Value | Assessment Metric Definition\[asmt\_metric\_definition\] | Verifies that the Value is greater than or equal to zero. |
| Verify Value | Assessment Template Definition\[asmt\_template\_definition\] | Verifies that the Value is greater than or equal to zero. |
Business rules
| Name | Table | Description |
|---|---|---|
| Assessable domain matches type | Assessable Record \[asmt\_assessable\_record\] | Ensures that all new assessable records are in the same domain as the metric type. This is a special requirement of assessment domain separation, that all records must be in the same domain. |
| Auto stakeholder creation | Assessment Category User \[asmt\_m2m\_category\_user\] | Assigns new category users as stakeholders automatically for assessable records if the associated category has the Create stakeholders option selected. |
| Auto stakeholder creation | Category Assessable Records \[asmt\_m2m\_category\_assessment\] | Creates stakeholders from all of a category's category users automatically for new assessable records if:- The Create stakeholders option is selected for the metric category. - The same metric category is associated to the new assessable record. |
| Auto stakeholder creation | Metric Category \[asmt\_metric\_category\] | Assigns all of a category's category users as stakeholders for each assessable record associated to the category when the Create stakeholders option is selected for the category. |
| Calculate category max weight | Assessment Metric \[asmt\_metric\] | Calculates the sum of all metric weights in a category. |
| Cancel notification workflow | Assessment Instance \[asmt\_assessment\_instance\] | Cancels the workflow that generates assessment email notifications when an assessment instance is deleted or changes the state to Complete or Canceled. |
| Category domain matches type | Metric Category \[asmt\_metric\_category\] | Ensures that all new categories are in the same domain as the metric type. This is a special requirement of assessment domain separation, that all records must be in the same domain. |
| Check Live Feed Groups | Assessable Record \[asmt\_assessable\_record\] | Selects the Live feed option if a Live Feed group is associated with the source record. If the Live feed option is selected and no Live Feed group is associated with the source record, this business rule clears the check box. |
| Check only one default | Bubble Chart \[asmt\_bubble\_chart\] | Ensures that there is only one default bubble chart for a metric type. |
| Check only one default | Decision Matrix \[asmt\_decision\_matrix\] | Ensures that there is only one default decision matrix for a metric type. |
| Create actual results | Assessment Instance \[asmt\_assessment\_instance\] | Generates assessment and category results from the user responses if a user completes an assessment. |
| Create Business Rule on Remote table | Assessment Metric Type \[asmt\_metric\_type\] | Generates the following business rules if an assessment administrator creates or updates a metric type:- Business rule called Auto business rule for Assessments, which monitors the Table selected for the metric type. When someone adds a record that meets the metric type conditions, this business rule generates an assessable record. If someone changes the metric type's Table or conditions, the Create Business Rule on Remote table business rule updates the automatic business rule script to reflect the changes. - Business rule called Auto deletion rule for Assessments, which prevents users from deleting a record on the metric type's Table if the record is associated to metric or category results. If the record has no associated results and a user deletes it, this business rule deletes any associated assessable records. The Create Business Rule on Remote table business rule generates automatic business rules only for metric types with Evaluation method set to Assessment. |
| Create Scheduled Job | Assessment Metric Type \[asmt\_metric\_type\] | Assessments: Generates a scheduled job for the creation of assessment components if either of these conditions is met:- Someone creates a new metric type with the schedule type set to Scheduled. - The schedule type changes from On demand to Scheduled. Surveys: Generates a scheduled job for the creation of survey components if the schedule period for a survey definition is set to Daily, Weekly, Monthly, or Yearly. |
| Create Survey Records | Assessment Metric Type \[asmt\_metric\_type\] | Generates various records and populates certain fields on those records when someone creates a new survey definition, which is a metric type with Evaluation method set to Survey. More specifically, this business rule generates a survey category and assessable record, both associated to the survey definition. |
| Create UI Action on Remote table | Assessment Metric Type \[asmt\_metric\_type\] | Reserved for future use. |
| decision\_matrix\_axis | Global \[global\] | Limits available categories for X- and Y-axes to those that belong to the type if there is a metric type specified on the Decision Matrix form. |
| Delete Live Feed Group | Assessable Record \[asmt\_assessable\_record\] | Deletes the assessable record's Live Feed group, if there is one, when an assessment administrator deletes an assessable record. |
| delete related users | Category Assessable Records \[asmt\_m2m\_category\_assessment\] | Deletes any stakeholders for the assessable record and category when an assessment administrator disassociates a category from an assessable record. |
| Do not allow category to change | Assessment Metric \[asmt\_metric\] | Prevents the Category field from being changed if there are any conditional question dependencies related to the current record. |
| Do not allow datatype to change | Assessment Metric \[asmt\_metric\] | Prevents the Data type and Template fields from being changed if there are any conditional questions that depend on the current record. |
| Ensure Types Match | Assessment Metric \[asmt\_metric\] | Sets the type of a metric to the type of the associated category. |
| Ensure types match | Assessment Stakeholders \[asmt\_m2m\_stakeholder\] | Ensures that users can only create a stakeholder from a category user and assessable record of the same type. |
| Ensure types match | Category Assessable Records \[asmt\_m2m\_category\_assessment\] | Prevents users from associating categories of one type to an assessable record of a different type. |
| Evaluate filters | Assessable Record \[asmt\_assessable\_record\] | Performs the following after the system generates a new assessable record:- Checks all filter conditions for categories in the type. - Automatically associates the new assessable record to all categories for which it meets the category filter conditions. |
| Generate assessment trigger condition | Trigger Condition \[asmt\_condition\] | Generates a business rule that the survey or assessment trigger condition uses to send surveys or assessments. |
| getStakeholders | Global \[global\] | Ensures that only category users for categories associated with the assessable record are available on the Assessable Record form when users edit the Category users related list. |
| Link assessable record and category | Metric Category \[asmt\_metric\_category\] | Sets these hidden fields as follows for a newly created survey category:- Table: Assessment Metric Type \[asmt\_metric\_type\] - Filter: <sys\_id of the survey definition the new survey category is associated with> |
| Live Feed Group | Assessable Record \[asmt\_assessable\_record\] | Creates a Live Feed group for the assessable record, if one doesn't exist, when the record is saved with the Live feed option selected. If the check box is then cleared and the record saved, this business rule deletes an existing Live Feed group. |
| Metric domain matches category | Assessment Metric \[asmt\_metric\] | Ensures that all new metrics are in the same domain as the category to which they belong. This rule is a special requirement of assessment domain separation, that all records must be in the same domain. |
| Notify assessment user | Assessment Instance \[asmt\_assessment\_instance\] | Starts a workflow that sends an email notification to the assigned user when an assessment instance changes to the Ready state or the user to which it is assigned changes. The workflow generates other assessment email notifications at later stages. |
| Prevent recursive dependencies | Assessment Metric \[asmt\_metric\] | Prevents the Depends on field from being set in a way that creates a recursive conditional question dependency. |
| Publish Survey | Assessment Metric Type \[asmt\_metric\_type\] | Generates survey instances and assigns them to the associated survey users when the survey definition state changes from Draft to Published. |
| Remove auto create Business Rules | Assessment Metric Type \[asmt\_metric\_type\] | Deletes the automatically created business rule for a metric type when an assessment administrator deletes that metric type. |
| Remove auto create UI actions | Assessment Metric Type \[asmt\_metric\_type\] | Reserved for future use. |
| Remove auto created business rule | Survey Trigger Condition \[asmt\_condition\] | Deletes the automatically created business rule when someone deletes the survey trigger condition. |
| Remove Scheduled Job | Assessment Metric Type \[asmt\_metric\_type\] | Assessments: Deletes the scheduled job for a metric type if either of these conditions is met:- Someone deletes the metric type. - Someone changes the schedule type from Scheduled to On demand. Surveys: Deletes the scheduled job for a survey definition if the schedule period is set to Only Once or No Limit. |
| Reset Min/Max for metric | Assessment Metric Definition \[asmt\_metric\_definition\] | Updates the Min and Max fields for metrics and survey questions based on the metric definition value. |
| Set Domain for M2M Cat Assessable Recs | Category Assessable Records \[asmt\_m2m\_category\_assessment\] | Ensures that assessable records are only associated to categories in the same domain. This rule is a special requirement of assessment domain separation, that all records must be in the same domain. |
| Set Domain for M2M Category Users | Assessment Category User \[asmt\_m2m\_category\_user\] | Ensures that users are only linked to categories in the same domain. This is a special requirement of assessment domain separation, that all records must be in the same domain. |
| Set Domain for M2M Stakeholders | Assessment Stakeholders \[asmt\_m2m\_stakeholder\] | Ensures that assessable records are only linked to category users in the same domain. This is a special requirement of assessment domain separation, that all records must be in the same domain. |
| Set scratchpad fields | Assessment Metric Type \[asmt\_metric\_type\] | Caches field values for use by other scripts that run on the Assessment Metric Type form. |
| Store view type | Metric Category \[asmt\_metric\_category\] | Ensures that the Type field only allows users to select metric types used for assessments. |
| Synchronize category survey users | Assessment Category User \[asmt\_m2m\_category\_user\] | Ensures that the same users are associated with all of a survey's categories. |
| Synchronize survey users and stakeholder. | Metric Category \[asmt\_metric\_category\] | Adds all users associated with a survey's existing categories to any newly created category for that survey. |
| Update Category Count | Assessment Metric \[asmt\_metric\] | Updates the value in the Total metrics field on the Metric Category form when metrics are added to and deleted from the category. |
| Update records that match filter | Metric Category \[asmt\_metric\_category\] | Automatically performs these tasks when an assessment administrator edits the Filter field:- Associates the category to assessable records that meet the filter conditions. - Disassociates the category from assessable records that don't meet the filter conditions. The Assessable records related list reflects these changes when the record is saved. |
| Update scheduled job on schedule change | Assessment Metric Type \[asmt\_metric\_type\] | Updates the survey creation scheduled job to reflect schedule period changes. |
| Validate mandatory and not applicable | Assessment Metric \[asmt\_metric\] | Sets the Mandatory and Allow not applicable fields to false if the metric method is Script. If the metric data type is Percentage, the business rule sets the Allow not applicable field to false. |
| Verify min/max | Assessment Metric \[asmt\_metric\] | Ensures that the Min is greater than or equal to zero and less than the Max. Sets the Min to 0 and the Max to 1 if the data type is Checkbox or Yes/No. |
| Verify value | Assessment Template Definition \[asmt\_template\_definition\] | Ensures that the metric template definition Value is:- Greater than or equal to zero. - Different from the Value for all other metric template definitions related to the template. |
| Verify value | Assessment Metric Definition \[asmt\_metric\_definition\] | Ensures that users can only enter a metric definition Value greater than or equal to zero. Ensures that the metric definition value is different from the Value for all other metric definitions related to the metric. |
Parent Topic:Assessments and Surveys