DF_PlateStatus

DF_PlateStatus — Plate Status

Synopsis

DF_PlateStatus {-plate #}

Description

Display simple counts and statistics for all fields on the requested plate. This report is similar to DF_stats - the underlying data is the same but the presentation style is different.

The first part of the output is a summary table. Each data field is a row in the output table. The properties of each data field are presented in columns of the table. For each data field, the first 3 columns are properties defined by the database setup:

  • Field Number

  • Title

  • Field Type

The remaining columns contain derived / calculated results summarizing the data values in the database. These results include:

  • Totals: the number of records containing this field. This value should be the same for every field (row) in the table.

  • Blank, Illegal, Invalid, Legal, Missing Value: counts of the number of records meeting each criteria. Each data value will meet only one criterion.

  • Minimum, Maximum, Mean, Median, Mode Standard Deviation: statistical measures for the data field. These measures are reported for fields with a number field type. For fields with a field type of string, the length of the string is used in these measures.

The second part of the output is a simple chart view of the values meeting each of the data criteria. The length of each row in the output is the same as the Total value for the matching row in the table.

Options

-plate #

Select the plate number (required)