CIS-PPM practice question 12 of 15
When a time card is approved, the actual time is stored in which two tables? (Choose two.)
Full set: 60 questionsWhen a time card is approved in ServiceNow, the system processes the hours worked as "actuals." This action triggers business rules that update the resource management data structure. The actual hours are first recorded in the resourceallocationdaily table, which stores the day-by-day breakdown of allocated versus actual hours for a resource on a specific task. Subsequently, this daily data is rolled up into the resourceaggregate tables (daily, weekly, and monthly). These aggregate tables are crucial for performance, as they provide pre-calculated summaries used in resource capacity planning, availability reports, and resource workbenches, preventing the need for real-time, resource-intensive calculations on the daily records.
A. Project Time table: This table is not the primary destination for actuals generated from the time card approval process; that data is processed into the resource management tables.
C. Resource Event table: This table tracks the lifecycle and state changes of a resource plan (e.g., Requested, Confirmed, Allocated), not the actual hours worked by a resource.
1. ServiceNow Product Documentation - Resource Management Data Model: This document outlines the key tables. It describes the resourceallocationdaily table as storing "daily allocation data for a resource on a resource plan" and the resourceaggregatedaily/weekly/monthly tables as storing "aggregated data for resource plans." This confirms their roles in storing daily and aggregated actuals. (ServiceNow Vancouver Release, Doc ID: KB1122538, Section: "Resource management data model").
2. ServiceNow Product Documentation - Resource Aggregates: "The resource aggregate tables store aggregated data for resource plans... When a time card for a resource is approved, the actual hours from the time card are updated in the resource aggregate tables." This explicitly links time card approval to the updating of aggregate tables. (ServiceNow Vancouver Release, Product Documentation, Topic ID: conceptResourceAggregates.html).
3. ServiceNow Product Documentation - Time management: "When a time card is approved, the actual hours are updated in the Resource Allocation Daily [resourceallocationdaily] table. The business rule Update resource aggregates then updates the resource aggregate tables." This provides the exact sequence of table updates upon approval. (ServiceNow Vancouver Release, Product Documentation, Topic ID: conceptTimeManagement.html, Section: "Time card process flow").
Keep practicing
Take the free CIS-PPM practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other CIS-PPM practice questions
- Question 1In what way would you restrict the assigned to field on a project task to only allow user…
- Question 2Which of the following checks to see if the assessable record exists for the demand and c…
- Question 4To use the Time Sheet dashboard, what plugin must be installed?
- Question 5How is a resource group’s capacity derived for resource planning?
- Question 6In order for a business unit to have its own Idea Portal to retrieve data, what must be c…
- Question 7The PPM Standard plugin enables an it_project_manager to perform the following activities…
