Data Administration › Time Slices

Time Slices

You need the Administration - Application access right to set up time slices.

A time slice is a flat table that contains data that is derived from a sliced binary large object (BLOB). A BLOB is a collection of binary data that is stored as a single entity in a database. BLOBs are used to store curve and calendar data.

The data model contains several BLOBs that cannot be read by most reporting tools. Time slicing is performed by the Time Slicing job, which extracts data into a readable flat table based upon the criteria you set in the time slice request. You can then query the time slice to run reports.

You determine which objects are time-sliced and the frequency with which this is done. Each record in the time slice table contains an object ID that corresponds to a data element. The report writer uses these object IDs to identify the resource associated with the slice record.

Note: See the Studio Developer's Guide for more information.

The following objects require time slicing:

prAllocCurve

The percentage of a resource's availability that is allocated to a project (as a rate curve).

Source table: PRTeam

prActCurve

Actuals posted to an assignment. This is stored in the database column prExtension.

Source table: PRAssignment

prEstCurve

Estimates for an assignment. This is stored in the database column prExtension.

Source table: PRAssignment

prBaseCurve

Baselines for an assignment. This is stored in the database column prExtension.

Source table: PRAssignment

prAvailCurve

The resource's availability (as rate curve).

Source table: PRResource

prValue

Work time information, such as shifts, days off, and holidays. While this table is used to calculate resource availability and allocation, you cannot select this table for time slicing.

Source table: PRCalendar

prAllocCurve

Values on timesheet time entries.

Source Table: PRTimeentry

More information:

Reports and Jobs

Create Time Slice Requests

Change Time Slice Requests

Delete Time Slice Requests