Product documentation Docs
    • English
    • Deutsch
    • 日本語
    • 한국어
    • Français
  • More Sites
    • Now Community
    • Developer Site
    • Knowledge Base
    • Product Information
    • ServiceNow.com
    • Training
    • Customer Success Center
    • ServiceNow Support Videos
  • Log in

Product documentation

  • Home
How search works:
  • Punctuation and capital letters are ignored
  • Special characters like underscores (_) are removed
  • Known synonyms are applied
  • The most relevant topics (based on weighting and matching to search terms) are listed first in search results
Topics are ranked in search results by how closely they match your search terms
  • A match on the entire phrase you typed
  • A match on part of the phrase you typed
  • A match on ALL of the terms in the phrase you typed
  • A match on ANY of the terms in the phrase you typed

Note: Matches in titles are always highly ranked.

  • Release version
    Table of Contents
    • IT Business Management
Table of Contents
Choose your release version
    Home Orlando IT Business Management IT Business Management Project Portfolio Management Rate Model

    Rate Model

    • Save as PDF Selected topic Topic & subtopics All topics in contents
    • Unsubscribe Log in to subscribe to topics and get notified when content changes.
    • Share this page

    Rate Model

    Use a rate model to derive date-effective, criteria-driven hourly rates for calculating planned and actual resource costs for a project or demand.

    Using a rate model enables you to define different rates of a specific resource, group, or role for different periods.

    Labor rates are based on the user attribute only, but the rate model can derive the hourly rates based on up to 10 attributes from predefined entities such as projects, demands, project tasks, users, groups, roles, and resource plans.

    To derive hourly rates from a rate model for the resource plans and time cards of a project or demand, associate the rate model with the project or demand. The rates are then derived from the rate model during resource planning or allocation, and during time card processing.
    Note: If a project or demand does not have an associated rate model, the default labor rate is used.

    Rate lines

    A rate model is a collection of multiple rate lines. A rate line is a unique combination of different criteria values that defines the hourly rate for a resource, group, or role for a specific date range. You can create multiple rate lines for the same set of criteria that have different rates for different date ranges, provided the dates do not overlap.

    Rate model processing

    The rate model associated with a project or demand evaluates the rate lines to find and return the hourly rate that matches the requested criteria.

    The rate is returned in the functional currency specified in the matching rate line.

    Figure 1. Rate model processing flow diagram
    Flow diagram of rate model processing

    The following video describes how to sett up a rate model and the evaluation method to find and return the hourly rate to a request.

    When a rate is requested, the rate model uses the following process.

    1. Finds rate lines that are in the requested date range and discards the remaining rate lines.
    2. Evaluates rate lines resulting from the previous step to find values matching the requested value in the first criteria column and discards the remaining rate lines.

      If the requested value is empty, it checks for rate lines containing NULL.

      If no exact match is found, it checks for the rate line having the value All other (*).

      The evaluation is repeated for the other criteria columns in order of priority until all criteria columns are processed.

    3. Returns the rate if one or more rate lines match the request.
      • If a single rate line is found, the corresponding rate is returned.
      • If multiple rate lines are found, the system determines the number of hours in the request that applies to each rate.
      • For example, say the rate requested is for resource allocation from July 1 to July 30. The rate model has one rate from July 1 to July 15 and a different rate from July 16 to July 30 for the same set of criteria. The rate model applies the first rate to the requested hours for July 1–15 and the second rate to the requested hours for July 16–30.

      If no rate lines match the request, then the request uses the default rate card.

    • Create or modify a rate model

      Create or modify a rate model that can be associated to a project or demand to deliver date-effective, criteria-driven hourly rates. These rates from the rate model help determine the resource costs and actuals for that investment.

    • Define criteria of a rate model

      Set the criteria of a rate model by adding attributes from a set of predefined entities to derive resource hourly rates based on the criteria.

    • Create a rate line

      Create a rate line in the rate model to define an hourly rate based on a specific set of criteria effective for a given date range.

    • Export a file to add or modify rate lines

      Export rate lines in a rate model to an export file to quickly update or add new rate lines into a rate model.

    • Import rate lines into a rate model

      Use the import rate lines function to quickly add multiple rate lines from an export file into a rate model.

    Tags:

    Feedback
    On this page

    Previous topic

    Next topic

    • Contact Us
    • Careers
    • Terms of Use
    • Privacy Statement
    • Sitemap
    • © ServiceNow. All rights reserved.

    Release version
    Choose your release version

      Rate Model

      • Save as PDF Selected topic Topic & subtopics All topics in contents
      • Unsubscribe Log in to subscribe to topics and get notified when content changes.
      • Share this page

      Rate Model

      Use a rate model to derive date-effective, criteria-driven hourly rates for calculating planned and actual resource costs for a project or demand.

      Using a rate model enables you to define different rates of a specific resource, group, or role for different periods.

      Labor rates are based on the user attribute only, but the rate model can derive the hourly rates based on up to 10 attributes from predefined entities such as projects, demands, project tasks, users, groups, roles, and resource plans.

      To derive hourly rates from a rate model for the resource plans and time cards of a project or demand, associate the rate model with the project or demand. The rates are then derived from the rate model during resource planning or allocation, and during time card processing.
      Note: If a project or demand does not have an associated rate model, the default labor rate is used.

      Rate lines

      A rate model is a collection of multiple rate lines. A rate line is a unique combination of different criteria values that defines the hourly rate for a resource, group, or role for a specific date range. You can create multiple rate lines for the same set of criteria that have different rates for different date ranges, provided the dates do not overlap.

      Rate model processing

      The rate model associated with a project or demand evaluates the rate lines to find and return the hourly rate that matches the requested criteria.

      The rate is returned in the functional currency specified in the matching rate line.

      Figure 1. Rate model processing flow diagram
      Flow diagram of rate model processing

      The following video describes how to sett up a rate model and the evaluation method to find and return the hourly rate to a request.

      When a rate is requested, the rate model uses the following process.

      1. Finds rate lines that are in the requested date range and discards the remaining rate lines.
      2. Evaluates rate lines resulting from the previous step to find values matching the requested value in the first criteria column and discards the remaining rate lines.

        If the requested value is empty, it checks for rate lines containing NULL.

        If no exact match is found, it checks for the rate line having the value All other (*).

        The evaluation is repeated for the other criteria columns in order of priority until all criteria columns are processed.

      3. Returns the rate if one or more rate lines match the request.
        • If a single rate line is found, the corresponding rate is returned.
        • If multiple rate lines are found, the system determines the number of hours in the request that applies to each rate.
        • For example, say the rate requested is for resource allocation from July 1 to July 30. The rate model has one rate from July 1 to July 15 and a different rate from July 16 to July 30 for the same set of criteria. The rate model applies the first rate to the requested hours for July 1–15 and the second rate to the requested hours for July 16–30.

        If no rate lines match the request, then the request uses the default rate card.

      • Create or modify a rate model

        Create or modify a rate model that can be associated to a project or demand to deliver date-effective, criteria-driven hourly rates. These rates from the rate model help determine the resource costs and actuals for that investment.

      • Define criteria of a rate model

        Set the criteria of a rate model by adding attributes from a set of predefined entities to derive resource hourly rates based on the criteria.

      • Create a rate line

        Create a rate line in the rate model to define an hourly rate based on a specific set of criteria effective for a given date range.

      • Export a file to add or modify rate lines

        Export rate lines in a rate model to an export file to quickly update or add new rate lines into a rate model.

      • Import rate lines into a rate model

        Use the import rate lines function to quickly add multiple rate lines from an export file into a rate model.

      Tags:

      Feedback

          Share this page

          Got it! Feel free to add a comment
          To share your product suggestions, visit the Idea Portal.
          Please let us know how to improve this content

          Check any that apply

          To share your product suggestions, visit the Idea Portal.
          Confirm

          We were unable to find "Coaching" in Jakarta. Would you like to search instead?

          No Yes
          • Contact Us
          • Careers
          • Terms of Use
          • Privacy Statement
          • Sitemap
          • © ServiceNow. All rights reserved.

          Subscribe Subscribed Unsubscribe Last updated: Tags: January February March April May June July August September October November December No Results Found Versions Search preferences successfully updated My release version successfully updated My release version successfully deleted An error has occurred. Please try again later. You have been unsubscribed from all topics. You are now subscribed to and will receive notifications if any changes are made to this page. You have been unsubscribed from this content Thank you for your feedback. Form temporarily unavailable. Please try again or contact  docfeedback@servicenow.com  to submit your comments. The topic you requested does not exist in the release. You were redirected to a related topic instead. The available release versions for this topic are listed There is no specific version for this documentation. Explore products Click to go to the page. Release notes and upgrades Click to open the dropdown menu. Delete Remove No selected version Reset This field is required You are already subscribed to this topic Attach screenshot The file you uploaded exceeds the allowed file size of 20MB. Please try again with a smaller file. Please complete the reCAPTCHA step to attach a screenshot
          Log in to personalize your search results and subscribe to topics
          No, thanks Login