14 job 008s streamlined focused edit scoring fester report

© 2019 - State of Utah - Department of Technology Services
Jump to navigation Jump to search

Job 008S - Streamlined Focused Edit Scoring (“FESTER”) Report

Es2j008s.png


Job 008S is a streamlined version of the 008D job. It produces the same format of report, listing high volatility and targeted-error accounts. However, it does not perform its own edits, but relies upon the contents of the current Micro Edit File. This limits the job to running either for the current or immediate prior quarter only. It may also identify accounts that have had conditions resolved yet not updated in the Micro Edit File (such as ES2C changes). These disadvantages are offset, however, by the fact that this job runs much more quickly and economically than the 008D job, granting it the nickname of “Faster FESTER.” It uses the same processing options as Job 008D, as described below.


1. Year/Quarter for Edit Scoring - The year/quarter is listed as a 3-digit field (“yyq” format). This parameter must be either the current or prior quarter on the Micro File. Edit codes will be combined with scoring processing to determine which records to list.


2. Bypass Accounts with Comment Codes Present? (Unless Error is Selected) - This option permits records with comment codes listed for the selected quarter to be omitted from the report, unless they contain a “special attention” edit code. The assumption is that these have already been reviewed (in order to receive the comment codes), so don’t need to be rehashed.

  • a. ‘Y’ - Ignore establishments that have comment codes present, as they have already been reviewed. However, the presence of one of the specially-targeted edit codes for this employer will override this bypass, so it will still be listed.
  • b. ‘N’ - The presence or absence of comment codes has no effect on processing.


3. Two Primary Sort Fields - Two one-character sort codes can be used here to alter the sorting of the FESTER output, providing page breaks on value changes, where they are appropriate. Valid values are:

  • a. blank - Use no sorting routine on the data. The report will appear in a descending score sequence, with ties broken by SESA-ID sorting.
  • b. ‘C’ (“County”) - Sort by county FIPS code. Each county break will generate a form feed in the report.
  • c. ‘O’ (“Owner”) - Sort by ownership code, with page breaks generated for each owner change.
  • d. ‘Q’ (“QMSA”) - Sort by Quasi-MSA (QMSA geographic partitioning) code, with a page break between QMSA’s.
  • e. ‘T’ (“Township”) - Allows scored errors to be segregated according to their sub-county New England township (or other three-byte designator) code.
  • f. ‘1’, ‘2’, ‘3’, ‘4’, ‘5’, ‘6’, ‘7’, ‘8’, or ‘9’ - Divides the FESTER according to the value found in the first, second, etc., digit of the U-I account number. This is helpful for those States that delegate the editing workload based upon a U-I account digit. Page breaks divide the values of the selected U-I digit.
  • g. ‘0’ (zero) - Splits the report based on the value found in the 10th digit of the U-I account number. A page break is produced when each value of this digit has been processed.


4. Give Invalid Codes Added Score? - This option permits the employment/wage volatility score to be augmented when an invalid code (county, ownership, NAICS) is present. These represent the most significant edit conditions that are not associated with volatility of employment and wage changes.

  • a. ‘Y’ (“Yes”) - Add 15 points to the score of any employer that has been flagged for an invalid key code (related to the account’s placement in macro totals).
  • b. ‘N’ (“No”) - Grant no special treatment to invalid-code establishments; look only for extreme employment and wage changes.


SPECIAL ATTENTION ERRORS - This is a list of up to ten micro edit codes that are to receive added points in their score to make it a virtual certainty that they will be selected to appear on the report. These are listed briefly below. The bonus score is awarded only once. If all ten codes were found on an employer, the score would still only be increased by the standard 20 points, rather than 200.


5. 1st - This is an optional field that can be used to identify one of the 3-digit edit exception codes found in micro-edit processing. It is the first of up to ten edit codes that can be selected in this section of the screen. If an error code is entered here, that code’s presence will add 20 points to the score of the associated establishment, making it certain for inclusion on the report.


6. 2nd - This optional field may represent a second edit code to select for special attention. If any of the codes mentioned here is found, the score will be adjusted with 20 extra points.


7. 3rd - Optional third edit code to select for an extra 20 points on the score.


8. 4th - Optional fourth edit code to select for an extra 20 points on the score.


9. 5th - Optional fifth edit code to receive extra score if found.


10. 6th - Optional sixth edit code to enable the 20-point augmenting of the score.


11. 7th - Optional seventh edit code to select for special attention (an extra 20 points).


12. 8th - Optional eighth edit code to receive extra score if found.


13. 9th - Optional ninth edit code to select for extra score.


14. 10th - Optional tenth edit code to match for an added 20 points on the score. Again, the add-on is not multiple in its nature. When two or three targeted codes are found for the same establishment, the add-on value is still 20 points, rather than 40, 60, etc.


15. First Error Code to Deselect (Less Score) - This option 3-digit field identifies a micro edit code that should be ignored from scored-edit consideration. If this code is found for an employer, it will reduce the score value by 20 points. This would counteract the effect of finding a “selected” error code (above), and would make virtually any account without a target edit code unusable for the report. The one exception would be the presence of an extremely high score that cannot be mitigated by such a deselection attempt.


16. Second Error Code to Deselect (Less Score) - This second of two optional codes to “deselect” can drop the score by 20 points when either (or both) code(s) is present.


17. Create Output File in Addition to Report - This option allows the data from the FESTER printed output to be replicated as a disk file for additional analysis and review (such as in an Excel spreadsheet).

  • a. ‘Y’ - Produce the FESTER file output in addition to the report.
  • b. ‘N’ - Print the FESTER report, but do not generate a separate file.


18. Minimum Score to Select - This 2-digit value identifies what score value to use as a division between selected and deselected accounts (normal value is 10).


19. Split Families from Singles? - This option is useful for some States for which the processing of multi-worksite families is handled by one or more individuals, while the singles are handled by the rest of the staff. This report split can be enabled with this switch.

  • a. 'Y’ (“Yes”) - Segregate the single establishments from the multi-worksite families in the FESTER. Score-based sorting can still be employed within the multi-worksite data, as it is for the singles, even though this means that the families will not appear as a contiguous group.
  • b. ‘N’ (“No”) - Keep singles and families together in the report, using only the sort parameters and the score values as organization directives.


Job 008S is run on demand, but reviews only those records on the current Micro Edit File. It is therefore more of an edit-data filter than a true “editing” tool. It is much cheaper to run than the 008D job, so it can be run earlier and more frequently.


Related Links