APPENDIX A: INTRODUCTION TO REPORT FORMS WITH DATA MAPS

Appendix A contains report forms on which have been indicated cell names for each data element. This is useful when accessing data directly through Standard Query Language (SQL) or ACE reports and when evaluating edit messages that refer to these cell designations.

Data tables for required reports generally contain some identical information on each record that will not be specified on the Data Maps. Useful common data elements are:

Description Name

Description	Name
State FIPS	st
Last Day of the Report Period to Which the Data Relate	reptdate
Date the Record was Created	crdate
Date the Record was Last Revised	revdate
Number of Times the Record was Revised	mods
Machine on Which the Record was Created or Last Revised	hostname
User ID of the Individual Who Created or Last Revised the Record	user_id

The statistical data items are then stored using cell names c1 through cn where n is the highest number required to report all data items. While most reports will have cell numbers in sequence as displayed on the report form, reports that have been amended over time will not. When cells have been combined, an alphabetic suffix might be used, e.g., c14a.

Each required report also has a comment table associated with it. These comment tables use the same name as the associated data table bu with a suffix of "cm" appended. These tables store any information that was provided to explain unusual data or to report special information the State wishes to provide or that was requested by the National Office.