Skip to main content

Add/Remove State Form Processing Flags

  1. Last updated
  2. Save as PDF

Clear flags that prevent records from being picked up in a state form compile/generation cycle, or manually add additional flags.

On the Add/Remove State Form Processing Flags form:

  • The processing flags are optionally set once a record is included in a state form. Only posted flags are shown.
  • Flagged records will be ignored in future compiles. Removing the flags enables the records to be reprocessed.
  • Rows of data can be manually added to the list of compile flags.
  • Currently flagged rows can be re-flagged. When this is done, the flag date and time will be updated to the current date and time.

In order to filter results by fields from a non-primary table, a join must be entered in the State Form Table Joins form between the primary table for the record and the desired non-primary table.

RADplus Utilities > State Forms Tools > Add/Remove State Form Processing Flags

  1. In the Action field, select either Remove Flags or Add Flags.
  2. In the State Form field, select the state form.
  3. In the Record field, select the record to either remove flags from or add flags to. This field is populated with all records present in the selected state form definition. If only one record is present, that record is the default. If each record in the definition has the same primary table, the All selection is the default. 
  4. The Primary Table field defaults to the primary table for the record and is display-only. This is the table whose primary key is flagged to specify that a row is flagged.
  5. The Secondary Table field is populated once a record is selected. This field contains one or more non-primary tables contained in the record or records selected (or non-primary tables contained in all of the records if All is selected). In order for a secondary table to display in the list, an entry must also be created in the State Form Table Joins form for the combination of the primary table and secondary table.
  6. In the Properties to Display field, select the properties to use in identifying the desired rows. If no properties are selected, only the Batch Number will be shown in the Select Table Rows window.
    Note: Use the Primary Table ID Key fields when the flagged table does not contain any data at the time of unflagging.

SQL Selection Builder section

This section is where you build an SQL statement to filter the flagged rows in a table. There are three main pieces to the SQL selection criteria: table property, operator, and comparison value. 

For example, to remove the flags for PATID 12345 only, you could build SQL selection criteria that returns only the flagged rows with a PATID of 12345. The table property would be 'PATID', the operator would be 'Is Equal To', and the comparison value would be '12345'.

  1. For the Table Property field, select the value that will be compared to a specific value. If the same property appears in a primary and secondary table, select the property from the primary table.
  2. In the Operator field, select the kind of comparison to make between the table property and the comparison value. 
    • Note: The 'Is Null' operator will pull rows where the property is blank, and the 'Is Not Null' operator will pull rows where the property is not blank. For the 'Is Null' and 'Is Not Null' values, no comparison value is needed.
  3. For the Comparison Value field, enter the value to compare the table property to. 
  4. Click Add. The SQL Selection Criteria field is updated to contain the new condition. The SQL condition is used to identify the records that will be selected.
  5. Repeat steps 1-4 in this section to add another condition.
  6. When adding to an existing condition, the And/Or field is enabled as the new condition must be concatenated to the existing condition. Select either And (&) or Or (\).
    • For example, to select PATID 12345 or an admission date after 01/01/2014, the condition would be: SYSTEM.patient_current_demographics.PATID = '12345' \ SYSTEM.admission_data.admission_date > 01/01/2014
    • Valid date formats are MM/DD/YY or MM/DD/YYYY.​
  7. To delete part of the condition, edit it manually. To delete the entire condition, click Clear All. 
  8. To check whether or not the current condition is valid, click Validate SQL. This is useful when editing a condition manually.

Batch Filter section

Filter the results to those contained in one or more specific batches.

  1. In the From Date and Through Date fields, define a date range. Any batch with a compile date within the date range will be available for selection in the Select Batches field. A blank value in either field will remove the date restriction on that end of the date range, so leaving both fields blank will populate the Select Batches field with all batches for the current definition.
  2. In the Select Batches field, select one or more batches. The batch description contains the ID number of the batch, the file description entered in the State Form File Generation form when the batch was compiled, and the date and time the batch was compiled. For example, "Batch 4: Test File Oct 30 - Compiled: 10/30/2014 3:55 PM."

Select Rows section

Select the table rows to either remove flags from or add flags to.

  1. In the Properties to Display field, select one or more properties to be displayed for each row in the results. By default, only the batch number is displayed for each row in the results so it is a good idea to select one or more properties to identify each row.

  2. In the Default Select All or None field, choose All to select all rows in the results by default. Choose None to not select any rows in the results by default.  
  3. Click Select Table Rows to return a list of all rows that match the entered criteria. If there are more than 50 results, page between entries by selecting the boxes for Show Next 50 Table Row Entries and Show Previous 50 Table Row Entries.
  4. If adding flags, rows that are already flagged will not show up in the results.
  5. Select the rows to be processed and click OK.
  6. Click Submit to either remove or add flags for the specified rows.