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 questions
Answer options
A: Project Time table
B: Resource Allocation Daily table Correct answer
C: Resource Event table
D: Resource Aggregate tables (Daily, Weekly, and Monthly) Correct answer
Correct Answer:
B. Resource Allocation Daily table; D. Resource Aggregate tables (Daily, Weekly, and Monthly)
Explanation

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

Why Incorrect

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.

References

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").

Scroll to Top