Data Validation

Facilities Information Management System

Data Validation Guidance was signed out on September 3, 2009

Data Validation Forms

The data validation reporting forms automatically populate the FIMS data from the Random Generator to the individual sample facility worksheets. These forms automatically generate the Scorecard that includes the percentages as a result of the validation. Instructions for completing this process are included.

	Building/Trailer Data Validation Reporting form*
	OSF Data Validation Reporting Form*
	Source Documentation Worksheet

* Scorecard is automatically generated within data validation reporting forms.

Sample Forms

	Sample Corrective Action Plan
	Sample Inbrief Powerpoint presentation
	Sample Outbrief Powerpoint presentation
	Sample Building/RP Trailer Validation form
	Sample OSF Validation form

A compilation of lessons learned has been developed based on experiences from recent data validation reviews.

Data Validation Tools

	Random Building Generator Standard Report #70 can be used to randomly select a sample set of buildings and real property trailers for the validation process.
	Outlier Selections Standard Report #70a can be used to easily identify buildings that are high in RPV, Deferrred Maintenance, or Gross Sqft that may be selected as an Outlier and included in the sample set.
	FRPC Bldg Data Element Report Standard Report #70b can be used to easily extract all FRPC data elements for a particular building. This report is also beneficial for selecting all of the FRPC data elements for buildings that have been selected as an Outlier.
	Random OSF Generator Standard Report #70c can be used to randomly select a sample set of OSF's for the validation process.
	FRPC OSF Data Element Report Standard Report #70d can be used to easily extract all FRPC data elements for a particular OSF. This report is also beneficial for selecting all of the FRPC data elements for OSF's that have been selected as an Outlier.
	Sample Size Chart Identifies the number of owned assets (buildings, real property trailers and OSF's) to include in the random sample set. These numbers are based on providing a 90% confidence level in the FIMS data.
	Geographic Location Code Table

FIMS Data Validation Training

Training PowerPoint Slides

Data Validation Training Schedule for FY10
Two Data Validation training classes will be offered in FY10. These classes will provide the necessary instruction to DOE and Contractor facilities management staff on the processes required for validation of key FIMS information. Specifically, participants will complete the course with an applied knowledge of the statistical principles, validation standard, and the step by step process required to perform a validation of the Federal Real Property Council required data elements. The class will consist of mainly lecture/demonstration with exercises that will provide participants with an opportunity to explore functions of the data validation process. Each person attending will receive 1 copy of the Data Validation training manual. The class schedule and locations are provided below. For those who wish to register for one of these classes, please email the following information to Mark Gordy (mark.gordy@hq.doe.gov). w Your Name w Class Dates w Phone Number w Email Address w Site you represent Any questions related to the data validation training classes can also be directed to the FIMS Hotline at 301-903-0850.
Dates: January 27-28, 2010 Time: 8:30am - 4:00pm Location: Oak Ridge, TN Oak Ridge Federal Building 200 Administration Rd Oak Ridge, TN 37831 Room #: B10-12 Instructor: TBD (OECM) Site POC: Rebecca Whitehead (865-241-2161) Registration POC: Mark Gordy (mark.gordy@hq.doe.gov)	Dates: February 23-24, 2010 Time: 8:30am - 4:00pm Location: Las Vegas, NV Nevada Site Office 232 Energy Way North Las Vegas, NV 89030 Room #: Great Basin Conference Room (1st Floor) Instructor: TBD (OECM) Site POC: J.P. Martinez (702-295-5209) Registration POC: Mark Gordy (mark.gordy@hq.doe.gov)