11 code 021 liability date format check
Liability Date Format Check - Code 021
The initial liability date (or worksite effective date, or “date of initial liability”) is represented by a ‘yyyymmdd’ format (4-digit year, 2-digit month and day fields). As such, the individual sub-fields are required to show legitimate values. Since the fields are predefined and prescreened for numerics, most of the checks conducted are on the month and day-of-the-month fields. The only year edit is to see if it is between 1935 and 2034, inclusive, since the year-2000 conversion uses this range as the standard for 2-digit to 4-digit year conversion. The liability month must be valid (1 to 12), but the day of the month must also agree with the month. Months allowing 31 days include: January, March, May, July, August, October, and December. Any other month showing the 31st day of the month as its liability date is flagged for an invalid format. Some preliminary defaulting of the day-of-month field is included in the edit program, prior to the edit itself.
February is a special case, since only 28 days exist in the month, except in leap years, which occur in years evenly divisible by 4, except for century years, which must also have the century divisible by 4 (e.g., 2000 was a leap year, but 2100 will not be a leap year). However, this edit doesn’t check for leap years, allowing a February day to range as high as 29 for any year. This edit may become more sophisticated in a later release, if necessary.
If the initial liability date format is found to be invalid, the field is flagged, and will be underscored in the edit report. This is identified as a crucial-level exception that must be addressed to keep it from reappearing on the next micro edit report. Since this edit deals with administrative data, whereas the edit flags (triggers for re-editing accounts) are quarterly fields, a selection between the two edit flags must be made. For convenience, current quarter is used for the associated edit flag for this and all other administrative edits of a crucial variety. BLS classification: C.1.4. EXPO “G” code: C021.
Related Links
