State Form Definition - Constant Values
Using the State Form Definition form, system administrators can specify constant values to be used for auto-generated data elements (like from and through dates).
In the Constant Value column, enter a value to be used for elements that are always the same constant value.
Note: If this column is used, the Table Field and SQL Generated Data columns will be disabled.
The
The following special values may be entered in the Constant Value column:
- Will correspond to whatever is entered in the From Date field on the State Form File Generation form when the compile is run.
- Will correspond to whatever is entered in the Through Date field on the State Form File Generation form when the compile is run.
- Will correspond to whatever is entered in the File Description field on the State Form File Generation form when the compile is run.
- Will correspond to whatever is entered in the Batch Number field on the State Form File Generation form when the compile is run.
- Will correspond to the current system date and time when the compile is run.
- Count of all rows returned for all records in the definition. Specific records may be counted by entering a colon (:) after RowCount and entering all record IDs to be counted, delimited by commas (for example,
<rowcount:40,41>).
Auto-generated data elements can also be used in the Additional SQL Condition column of State Form Definition 'Define Record Tables' grid. Most elements above can be used in the following format:
- [FromDate] - replace < > with [ ]
Example: TableName.FieldName <= [ThroughDate]