Understanding the Report Output Table

The report output tables may include some or all of the following elements:

• Item # – The numerical order of the data element as it appears within the state extract file.
• Data Element – The name of the data element.
• Description – Additional information about the data element, including state reporting rules.
• [Table] – The name of the table where the data is stored.
• Field Name – The name of the field where the data is stored.

Note: The Table name appears in brackets with the Field Name directly following. Example: [Table]FieldName.

• Field Type – The field type used for the data element, such as character string, numeric, etc.
• Field Length – The length of the data element when extracted.