Stock Job Descriptions › Datamart Rollup - Time Facts and Time Summary Job

Datamart Rollup - Time Facts and Time Summary Job

This is an optional job that populates the following time facts and time summary tables for resources who want to develop custom reports:

• NBI_PM_PT_FACTS
• NBI_FM_PT_FACTS
• NBI_RT_FACTS
• NBI_PM_PROJECT_TIME_SUMMARY
• NBI_FM_PROJECT_TIME_SUMMARY
• NBI_RESOURCE_TIME_SUMMARY

The populated data is not used in standard CA Clarity PPM reports.

Requirements

(Recommended) Run this job after the Datamart Extraction job.

Restrictions

This job cannot run concurrently with the following jobs:

• Datamart Rollup - Time Facts and Time Summary

  Other instances of this job cannot exist.

• Datamart Extraction
• Delete Investments

Parameters

None