Understanding the Report Output Table

The report output tables include the following elements:

• Item # or Position – Either the numerical order of the data element (first element is 1, second element is 2), or the position in the report. For example, if there is a string of data elements, such as 2009YNYN08091989, the particular element may start at position 5. In this example, position 5 is Y.
• Column – The name of the data column.
• Description – Additional information about the data in the columns, 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.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.