Page 1

NFS DW Reporting Awareness Items

December 2011

Page 2

Reporting Awareness Items

Item Refer to:

WBS Structure Differences between PTA and DW See page 3

Timing of Accounting Information See page 4

Current Values and Month End Close Filters See page 5

PTA Awareness Items See page 8

Page 3

WBS Structure Differences

WBS # PTA DW

00000 Construction - Building Construction - Building

00000 Construction - Onsite Construction - Onsite

00000 Construction - Offsite Construction - Offsite

00000 Construction - Unique Construction - Unique

98200 IT Equipment IT Equipment

91000 Professional Fees Professional Fees

91500 Built in Equipment Builtin Equipment

90000 Land/Building Purchase/Disposition Site Acquisition

95500 Imaging Equipment Imaging Equipment

99000 Recharges Proj Mgmt Recharge

97000 Artwork & Plants Artwork/Plants

98000 IT Cabling & Labor IT Cabling + Labor

93000 Contingency Contingency

94000 Construction Escalation Escalation (Constr.)

94000 Equipment Escalation Escalation (Eqpt.)

95000 Equipment Moveable Equipment

92000 Owner's Misc. Misc. Owner's Cost

96000 Furnishings Furnishing

99500 Tenant Improvement Allowances Offset for TI Allowance

Page 4

Timing of Accounting Information

Timing of Accounting Information should be taken into account when creating or interpreting reports. Data which comes from Accounting systems to the NFS DW through PTA will be 2 days old when displayed in the Reports.

Example:Day 1: Accounting commitment and expenditures are loaded into PTA on a nightly basis.

Day 2: Accounting commitment and expenditures are then loaded from PTA to the NFS Data Warehouse.

The timing of the nightly loads should be taken into consideration when creating and reviewing reports. The NFS DW team will be working on incorporating data directly from the accounting systems in future phases.

Page 5

Current Values and Month End Close Filters

1. Since the NFS Data Warehouse retains historical values, while creating ad-hoc reports please add “Current Value” Filter to the Query Filter Pane when using Objects from the following classes:

Project Cost Sheet Values Project Revisions Values Contract Values Invoices Values Schedule Values Acct Expenditures Values Account Commits Values See page 8 for the “Current Value” Filter

2. The “MEC” filter has been created for easy Month-End-Close reporting. This will only apply to Project Cost sheet and Contracts Classes. See page 9 for “MEC” Filter

Page 6

“Current Value” Filter

Add “Current Value” Filter to Query Filter Pane as shown.

Page 7

Month End Close (“MEC”) Filter

Add “MEC” Filter to Query Filter Pane as shown.

Page 8

PTA Awareness Items

These items only impact only PTA.1. The “Current Budget Authorized to Spend” shows authorized dollars,

but these dollars have not been approved to spend for QI projects (Place holder projects).

2. The PTA NFT report shows the rollup project target budget whereas the DW NFT report shows the project target budget. As a result the forecast variance (target budget – current forecast) will differ.

3. The PTA CQE report will show a 0 amount for original budget, when in fact there is an actual amount in the project. The DW CQE report shows the actual amount as expected.

4. The PTA CME report will show some service areas as REG. The DW CME report will show the correct service area name.

5. In PTA’s NFT report, projects that are Cancelled or Final Closeout phase and the expenditure and target budget are $0, the project is omitted from the report. The DW NFT report will include these projects.

6. Vendor Evaluations created prior to May 2, 2011 are not available in the DW. Prior to this date, evaluation data was not required in PTA.