The report output tables in this guide include the following elements:
[Paper Reports]
-
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.
-
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.
[Extracts]
-
Item # – Either the numerical order of the data element (first element is 1, second element is 2).
-
Data Element – The name of the data element.
-
[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]Field_Name.
-
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.
-
Begin/End Position - The position of the data element 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.
[XML]
-
Data Element – The name of the data element.
-
[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]Field_Name.