Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SL_PF_Outbound_MergeFlow_v2

...

Solution Design:

  1. Source File_Trigger.txt from FTP Location.

...

  1. Map values from File Trigger to Context.

...

  1. Once the values are mapped to the context, we validate good and bad data in the Trading_Partner File via Mapping. Maps Trading_Partner file data to a standard file

...

In the Error Layout, we are generating Errors and Warnings as well.

...

Expand
titleError Conditions

IF CONDITION{$var_fetch_key_identifier = 'Employee SSN' and EMPLOYEE_SSN = ''} VALUE=["Key Identifier is Employee SSN and Employee SSN is Missing|"]

IF CONDITION{$var_fetch_key_identifier = 'Employee ID' and EMPLOYEE_ID = ''} VALUE=["Key Identifier is Employee ID and Employee ID is Missing|"]

IF CONDITION{($var_fetch_key_identifier = 'Employee SSN' and EMPLOYEE_SSN != '' ) and (saxonJavaMapperUtilityClass:replaceAll(EMPLOYEE_SSN, $varRegexSSN ,'VALID' ) != 'VALID')} VALUE=['Invalid Employee SSN|']

IF CONDITION{($var_fetch_key_identifier = 'Employee ID' and EMPLOYEE_ID!= '') and (saxonJavaMapperUtilityClass:replaceAll(EMPLOYEE_ID, $varRegexCheckEmpID,'VALID') != 'VALID')} VALUE=[ "Invalid Employee ID|"]

IF CONDITION{EMPLOYEE_EARNING != '' and not(matches(EMPLOYEE_EARNING,$varRegexEmployeeEarning))} VALUE=["Invalid Employee Earning|"]

IF CONDITION{EARNINGS_FREQUENCY != '' and $var_EmployeeFrequencyVM = 'InvalidEarningsFrequency'} VALUE=["Invalid Earnings Frequency|"]

IF CONDITION{EARNINGS_EFFECTIVE_DATE !='' and not(matches(EARNINGS_EFFECTIVE_DATE, $var_DateFormat_REGEX))} VALUE=['Invalid Earning Effective date format|']

IF CONDITION{STD_WEEKLY_EARNINGS !='' and not(matches(STD_WEEKLY_EARNINGS ,$varRegexMonthlyWeeklyEarning))} VALUE=['Invalid STD Weekly Earnings|']

IF CONDITION{LTD_MONTHLY_EARNINGS!='' and not(matches(LTD_MONTHLY_EARNINGS, $varRegexMonthlyWeeklyEarning))} VALUE=['Invalid LTD Weekly Earnings|']

IF CONDITION{STD_ELIGIBILITY_DATE!='' and not(matches(STD_ELIGIBILITY_DATE, $var_DateFormat_REGEX) )} VALUE=['Invalid STD Eligibility Date format|']

IF CONDITION{STD_ELECTION !='' and $Var_STD_ElectionVM = 'InvalidBenefitElectionType'} VALUE=["Invalid STD Election|"]

IF CONDITION{STD_BENEFIT_AMOUNT != '' and not(matches(STD_BENEFIT_AMOUNT, $varRegexBenefitAmount))} VALUE=['Invalid STD Benefit Amount|']

IF CONDITION{STD_CLASS != '' and not(matches(STD_CLASS,$varRegexClass))} VALUE=["Invalid STD Class|"]

IF CONDITION{STD_TERMINATION_DATE!= '' and not(matches(STD_TERMINATION_DATE, $var_DateFormat_REGEX))} VALUE=['Invalid STD Termination Date format|']

IF CONDITION{STATUTORY_DISABILITY_TYPE !='' and $Var_StatutoryDisabilityTypeVM ='InvalidStatutoryDisabilityType'} VALUE=["Invalid Statutory Disability Type|"]

IF CONDITION{LTD_ELIGIBILITY_DATE!='' and not(matches(LTD_ELIGIBILITY_DATE, $var_DateFormat_REGEX))} VALUE=['Invalid LTD Eligibility Date format|']

IF CONDITION{LTD_ELECTION !='' and $Var_LTD_ElectionVM = 'InvalidBenefitElectionType'} VALUE=["Invalid LTD Election|"]

IF CONDITION{LTD_BENEFIT_AMOUNT != '' and not(matches(LTD_BENEFIT_AMOUNT, $varRegexBenefitAmount) )} VALUE=['Invalid LTD Benefit Amount|']

IF CONDITION{LTD_CLASS != '' and not(matches(LTD_CLASS,$varRegexClass))} VALUE=["Invalid LTD Class|"]

IF CONDITION{LTD_TERMINATION_DATE != '' and not(matches(LTD_TERMINATION_DATE, $var_DateFormat_REGEX))} VALUE=['Invalid LTD Termination Date format|']

IF CONDITION{SUPERVISOR_EMPLOYEE_ID != '' and not(matches(SUPERVISOR_EMPLOYEE_ID ,$varRegexSupervisorEID))}VALUE=["Invalid Supervisor Employee ID|"]

IF CONDITION{SUPERVISOR_FIRST_NAME != '' and not(matches(SUPERVISOR_FIRST_NAME ,$varRegexFirstName))}VALUE=["Invalid Supervisor First Name|"]

IF CONDITION{SUPERVISOR_LAST_NAME != '' and not(matches(SUPERVISOR_LAST_NAME,$varRegexLastName))} VALUE=["Invalid Supervisor Last Name|"]

IF CONDITION{OCCUPATION_QUALIFIER1 != '' and not(matches(OCCUPATION_QUALIFIER1,$varRegexOccupQual))} VALUE=["Invalid Occupation Qualifier1|"]

IF CONDITION{OCCUPATION_QUALIFIER2 != '' and not(matches(OCCUPATION_QUALIFIER2,$varRegexOccupQual))} VALUE=["Invalid Occupation Qualifier2|"]

IF CONDITION{OCCUPATION_QUALIFIER3 != '' and not(matches(OCCUPATION_QUALIFIER3,$varRegexOccupQual))} VALUE=["Invalid Occupation Qualifier3|"]

IF CONDITION{OCCUPATION_QUALIFIER4 != '' and not(matches(OCCUPATION_QUALIFIER4,$varRegexOccupQual))} VALUE=["Invalid Occupation Qualifier4|"]

IF CONDITION{OCCUPATION_QUALIFIER5 != '' and not(matches(OCCUPATION_QUALIFIER5,$varRegexOccupQual))} VALUE=["Invalid Occupation Qualifier5|"]

IF CONDITION{OCCUPATION_QUALIFIER6 != '' and not(matches(OCCUPATION_QUALIFIER6,$varRegexOccupQual))} VALUE=["Invalid Occupation Qualifier6|"]

IF CONDITION{OCCUPATION_QUALIFIER7 != '' and not(matches(OCCUPATION_QUALIFIER7,$varRegexOccupQual))} VALUE=["Invalid Occupation Qualifier7|"]

IF CONDITION{OCCUPATION_QUALIFIER8 != '' and not(matches(OCCUPATION_QUALIFIER8,$varRegexOccupQual))} VALUE=["Invalid Occupation Qualifier8|"]

IF CONDITION{OCCUPATION_QUALIFIER9 != '' and not(matches(OCCUPATION_QUALIFIER9,$varRegexOccupQual))} VALUE=["Invalid Occupation Qualifier9|"]

IF CONDITION{OCCUPATION_QUALIFIER10 != '' and not(matches(OCCUPATION_QUALIFIER10,$varRegexOccupQual))} VALUE=["Invalid Occupation Qualifier10|"]

IF CONDITION{SPOUSE_DATE_OF_CHANGE!='' and not(matches(SPOUSE_DATE_OF_CHANGE, $var_DateFormat_REGEX))} VALUE=['Invalid Spouse Date of Change format|']

IF CONDITION{SPOUSE_FIRST_NAME != '' and not(matches(SPOUSE_FIRST_NAME ,$varRegexFirstName)) }VALUE=["Invalid Spouse First Name|"]

IF CONDITION{SPOUSE_LAST_NAME != '' and not(matches(SPOUSE_LAST_NAME,$varRegexLastName))}VALUE=["Invalid Spouse Last Name|" ]

IF CONDITION{SPOUSE_DATE_OF_BIRTH != '' and not(matches(SPOUSE_DATE_OF_BIRTH, $var_DateFormat_REGEX))} VALUE=['Invalid Spouse Date of Birth format|']

IF CONDITION{SPOUSE_SSN != '' and not(matches(SPOUSE_SSN,$VarRegexSpouseSSN))} VALUE=["Spouse SSN is Invalid|"]

IF CONDITION{SPOUSE_EMPLOYEE_ID != '' and (not(matches(SPOUSE_EMPLOYEE_ID,$VarRegexSpouseEMPID)))} VALUE=["Spouse Emp ID is Invalid|"]

IF CONDITION{MARITAL_STATUS != '' and $var_MaritialStatus = 'InvalidMaritalStatus'} VALUE=["Invalid Maritial Status|"]

IF CONDITION{SPOUSE_REASON_OF_CHANGE != '' and $Var_SpouseROC = 'InvalidSpouseROC'} VALUE=["Invalid Spouse Reason of Change|"]

IF CONDITION{EMPLOYMENT_CLASS != '' and $Var_EmploymentClass = 'InvalidEmploymentClass'} VALUE=["Invalid Employment Class|"]

IF CONDITION{EMPLOYMENT_STRENGTH != '' and $Var_EmploymentStrengthsVM = 'InvalidEmployeeStrength'} VALUE=["Invalid Employee Strength|"]

image-20240827-105913.pngImage Added

Expand
titleWarning Conditions

IF CONDITION{generate-id(.) != generate-id(key('First_Name_Key', concat(EMPLOYEE_FIRST_NAME, '|',EMPLOYEE_LAST_NAME)))[1]} VALUE=["Duplicate First Name and last Name | " ]
IF CONDITION{EMPLOYEE_TITLE !='' and $Var_EmployeeTitleVM = 'InvalidTitle'} VALUE=["Invalid Employee Title|" ]
IF CONDITION{EMPLOYEE_FIRST_NAME = '' } VALUE=["Missing Employee First Name|" ]
IF CONDITION{EMPLOYEE_FIRST_NAME!='' and not(matches(EMPLOYEE_FIRST_NAME ,$varRegexFirstName))}VALUE=["Invalid Employee First Name|" ]
IF CONDITION{EMPLOYEE_MIDDLE_NAME = ''}VALUE=["Missing Employee Middle Name|" ]
IF CONDITION{EMPLOYEE_MIDDLE_NAME!= ''and not(matches(EMPLOYEE_MIDDLE_NAME,$varRegexMiddleName))}VALUE=["Invalid Employee Middle Name|" ]
IF CONDITION{EMPLOYEE_LAST_NAME = '' } VALUE=["Missing Employee Last Name|" ]
IF CONDITION{ EMPLOYEE_LAST_NAME != '' and not(matches(EMPLOYEE_LAST_NAME,$varRegexLastName))}VALUE=["Invalid Employee Last Name|" ]
IF CONDITION{ EMPLOYEE_GENDER = ''} VALUE=[ 'Missing Employee Gender|']
IF CONDITION{ EMPLOYEE_GENDER!='' and $Var_GenderCodesVM = 'InvalidGender'} VALUE=["Invalid Employee Gender|" ]
WHEN CONDITION{EMPLOYEE_DATE_OF_BIRTH= ''} VALUE=['Missing Employee Date of Birth|'] OTHERWISE VALUE=[IF CONDITION{EMPLOYEE_DATE_OF_BIRTH !='' and not(matches(EMPLOYEE_DATE_OF_BIRTH, $var_DateFormat_REGEX))} VALUE=['Invalid Employee Date Of Birth format|' ]]
IF CONDITION{ EMPLOYEE_HOME_ADDRESS_LINE_1 = '' }VALUE=["Missing Employee Home Address Line 1|" ]
IF CONDITION{EMPLOYEE_HOME_ADDRESS_LINE_1 != '' and not(matches(EMPLOYEE_HOME_ADDRESS_LINE_1,$varRegexAddress1))}VALUE=["Employee Home Address Line 1 has invalid Characters or length|"]
IF CONDITION{ EMPLOYEE_HOME_ADDRESS_LINE_2 = '' }VALUE=["Missing Employee Home Address Line 2|" ]
IF CONDITION{EMPLOYEE_HOME_ADDRESS_LINE_2 != '' and not(matches(EMPLOYEE_HOME_ADDRESS_LINE_2,$varRegexAddress2))}VALUE=["Employee Home Address Line 2 has invalid Characters or length|" ]
IF CONDITION{ EMPLOYEE_CITY = ''} VALUE=["Missing Employee Home City|" ]
IF CONDITION{EMPLOYEE_CITY != '' and not(matches( EMPLOYEE_CITY, $varRegexHomeCity))} VALUE=[ "Invalid Employee Home City|"]
IF CONDITION{EMPLOYEE_STATE = '' } VALUE=[ "Missing Employee Home State|"]
IF CONDITION{ EMPLOYEE_STATE != '' and $Var_EmployeeHomeStateVM = 'NonState' } VALUE=["Invalid Employee Home State|"]
IF CONDITION{EMPLOYEE_HOME_ZIP_CODE = '' } VALUE=["Missing Employee Zip Code|" ]
IF CONDITION{EMPLOYEE_HOME_ZIP_CODE != '' and not(matches(EMPLOYEE_HOME_ZIP_CODE, $varRegexZipCode)) }
VALUE=["Invalid Employee Zip Code|"]
IF CONDITION{EMPLOYEE_COUNTY = '' } VALUE=["Missing Employee County|" ]
IF CONDITION{EMPLOYEE_COUNTY !='' and not(matches(EMPLOYEE_COUNTY,$VarCounty))} VALUE=["Invalid Employee County|" ]
IF CONDITION{EMPLOYEE_COUNTRY = ''} VALUE=[ "Missing Employee Country|"]
IF CONDITION{EMPLOYEE_COUNTRY !='' and $Var_EmployeeCountryCodesVM = 'InvalidCountry' } VALUE=[ "Invalid Employee Country|"]
IF CONDITION{ (EMPLOYEE_HOME_PHONE_NUMBER !='') and (not(matches(EMPLOYEE_HOME_PHONE_NUMBER,$varNumberMobilePhone )))} VALUE=["Invalid Employee Home Phone number|" ]
IF CONDITION{ (EMPLOYEE_MOBILE_PHONE_NUMBER !='') and (not(matches(EMPLOYEE_MOBILE_PHONE_NUMBER,$varNumberMobilePhone )))}VALUE=["Invalid Employee Mobile Phone number|" ]
IF CONDITION{PRIMARY_PHONE_TYPE !='' and $Var_PhoneTypeVM = 'InvalidPhoneType'} VALUE=["Invalid Phone Type|" ]
IF CONDITION{ (EMPLOYEE_EMAIL_ADDRESS != '' ) and (not(matches(EMPLOYEE_EMAIL_ADDRESS, $varRegexEmail))) }
VALUE=["Invalid Employee Email Address|"]
IF CONDITION{ (EMPLOYEE_WORK_EMAIL_ADDRESS != '' ) and (not(matches(EMPLOYEE_WORK_EMAIL_ADDRESS, $varRegexEmail))) }VALUE=["Invalid Employee Work Email Address|"]
IF CONDITION{EMPLOYEE_WORK_STATE !='' and $Var_EmployeeWorkStateVM = 'InvalidWorkState' } VALUE=[ "Invalid Employee Work State| "]
IF CONDITION{ EMPLOYEE_ORIGINAL_DATE_OF_HIRE != '' and not(matches(EMPLOYEE_ORIGINAL_DATE_OF_HIRE,$var_DateFormat_REGEX))} VALUE=["Invalid Original Date Of Hire| " ]
IF CONDITION{ EMPLOYEE_MOST_RECENT_DATE_OF_HIRE != '' and
not(matches(EMPLOYEE_MOST_RECENT_DATE_OF_HIRE,$var_DateFormat_REGEX))} VALUE=["Invalid Most recent date of hire|" ]
IF CONDITION{EMPLOYEE_ADJUSTED_DATE_OF_HIRE != '' and
not(matches(EMPLOYEE_ADJUSTED_DATE_OF_HIRE,$var_DateFormat_REGEX))} VALUE=["Invalid Employee Adjusted date of hire|" ]
IF CONDITION{EMPLOYEE_JOB_TITLE = '' } VALUE=[ "Missing Employee Job Title|"]
IF CONDITION{EMPLOYEE_JOB_TITLE != '' and not(matches(EMPLOYEE_JOB_TITLE,$varRegexEmployeeJobTitle)) } VALUE=[ "Invalid Employee Job Title|"]
IF CONDITION{EMPLOYMENT_STATUS = '' } VALUE=[ "Missing Employment Status|"]
IF CONDITION{ EMPLOYMENT_STATUS != '' and $Var_EmploymentStatusVM = 'InvalidEmploymentStatus' }
VALUE=[ "Invalid Employment Status|"]
IF CONDITION{ FULL_TIME_PART_TIME_STATUS != '' and $Var_FullTimePartTimeVM = 'InvalidStatus' }
VALUE=[ "Invalid full/part time status| "]
IF CONDITION{EXEMPT_STATUS !='' and $Var_ExemptionTypeVM = 'InvalidExemptionType'} VALUE=["Invalid Exempt Status|" ]
IF CONDITION{COMPENSATION_METHOD !='' and $Var_CompensationMethodVM = 'InvalidCompensationMethod'} VALUE=["Invalid Compensation Method|" ]
IF CONDITION{UNION_TYPE !='' and $Var_UnionTypeVM = 'InvalidUnionType'} VALUE=["Invalid Union Type|" ]
IF CONDITION{UNION_NAME !='' and not(matches(UNION_NAME,$VarRegexUnionName)) } VALUE=[ "Invalid Union Name|"]
IF CONDITION{SCHEDULED_HOURS_PER_WEEK != '' and not(matches(SCHEDULED_HOURS_PER_WEEK,$varRegexScheduledHrs)) } VALUE=[ "Invalid Scheduled Hours Per Week|"]
IF CONDITION{SCHEDULED_DAYS_PER_WEEK != '' and not(matches(SCHEDULED_DAYS_PER_WEEK,$varRegexScheduledDays)) } VALUE=[ "Invalid Scheduled Days Per Week|"]
IF CONDITION{EMPLOYMENT_TYPE != '' and $Var_EmploymentTypeVM = 'InvalidEmploymentType'} VALUE=["Invalid Employment Type|" ]
IF CONDITION{WORK_SITE_NAME != '' and not(matches(WORK_SITE_NAME,$varRegexWorkSite)) } VALUE=[ "Invalid Work Site|"]
IF CONDITION{ORGANIZATION_UNIT != '' and not(matches(ORGANIZATION_UNIT,$varRegexOrganizationUnit)) } VALUE=[ "Invalid Organization Unit|"]
IF CONDITION{ (($VarWorkSiteCount > 1) and (ORGANIZATION_UNIT = ''))} VALUE=[ "No Organization Unit|"]
IF CONDITION{BUSINESS_UNIT != '' and not(matches(BUSINESS_UNIT,$varRegexBusinessUnit)) } VALUE=[ "Invalid Business Unit|"]
IF CONDITION{DIVISION != '' and not(matches(DIVISION,$varRegexBusinessUnit)) } VALUE=[ "Invalid Division|"]
IF CONDITION{GROUP_TYPE != '' and not(matches(GROUP_TYPE,$varRegexGroupType)) } VALUE=[ "Invalid Group Type|"]
IF CONDITION{EMPLOYEE_EARNING = ''} VALUE=["Missing Employee Earning|" ]
IF CONDITION{EMPLOYEE_EARNING != '' and EARNINGS_FREQUENCY = '' } VALUE=["Missing Earning Frequency|" ]
IF CONDITION{EMPLOYEE_EARNING != '' and EARNINGS_EFFECTIVE_DATE = '' } VALUE=["Missing Earnings Effective Date|" ]
IF CONDITION{STD_WEEKLY_EARNINGS != '' and not(matches(STD_WEEKLY_EARNINGS, $varRegexSTDWeeklyEarnings))} VALUE=["Invalid STD Weekly Earnings|"]
IF CONDITION{LTD_MONTHLY_EARNINGS != '' and not(matches(LTD_MONTHLY_EARNINGS, $VarRegexLTDMonthlyEarnings) )} VALUE=['Invalid LTD Monthly Earnings|' ]
IF CONDITION{((EMPLOYMENT_STATUS = 'TE') or (EMPLOYMENT_STATUS = 'RT')) and (TERMINATION_DATE = '')} VALUE=["Missing Term date based on Employment Status|" ]
WHEN CONDITION{TERMINATION_DATE = ''} VALUE=[TERMINATION_DATE] OTHERWISE VALUE=[IF CONDITION{TERMINATION_DATE !='' and not(matches(TERMINATION_DATE, $var_DateFormat_REGEX))} VALUE=['Invalid Termination date format|']]
IF CONDITION{STD_ELIGIBILITY_DATE = '' }VALUE=["Missing STD Eligibility Date|" ]
IF CONDITION{STD_ELIGIBILITY_DATE != '' and STD_BENEFIT_AMOUNT = ''} VALUE=["Missing STD Benefit Amount|" ]
IF CONDITION{LTD_ELIGIBILITY_DATE = '' } VALUE=["Missing LTD Eligibility Date|" ]
IF CONDITION{LTD_ELIGIBILITY_DATE != '' and LTD_BENEFIT_AMOUNT = ''} VALUE=["Missing LTD Benefit Amount|" ]
IF CONDITION{POLICY_NUMBER != '' and not(matches(POLICY_NUMBER,$VarRegexPolicyNumber)) } VALUE=[ "Invalid Policy Number|"]
IF CONDITION{KEY_EMPLOYEE_INDICATOR != '' and not(matches(KEY_EMPLOYEE_INDICATOR,$varRegexKeyEmployeeIndicator)) } VALUE=[ "Invalid Key Employee Indicator|"]
IF CONDITION{WORK_AT_HOME_INDICATOR != '' and not(matches(WORK_AT_HOME_INDICATOR,$varRegexKeyEmployeeIndicator)) } VALUE=[ "Invalid Work at home Indicator|"]
IF CONDITION{Field_50_IN_75_RULE_INDICATOR != '' and not(matches(Field_50_IN_75_RULE_INDICATOR,$varRegexKeyEmployeeIndicator)) } VALUE=[ "Invalid 50 in 75 Rule Indicator|"]
IF CONDITION{HOURS_WORKED_PREVIOUS_12_MONTHS != '' and not(matches(HOURS_WORKED_PREVIOUS_12_MONTHS,$varRegexHoursWorked)) } VALUE=[ "Invalid Hours Worked Previous 12 Months|"]
IF CONDITION{EMPLOYER_CONTACT_1 != '' and not(matches(EMPLOYER_CONTACT_1,$varRegexEmployerContact)) } VALUE=[ "Invalid Employer Contact 1|"]
IF CONDITION{EMPLOYER_CONTACT_2 != '' and not(matches(EMPLOYER_CONTACT_2,$varRegexEmployerContact)) } VALUE=[ "Invalid Employer Contact 2|"]
IF CONDITION{EMPLOYER_CONTACT_3 != '' and not(matches(EMPLOYER_CONTACT_3,$varRegexEmployerContact)) } VALUE=[ "Invalid Employer Contact 3|"]
IF CONDITION{EMPLOYER_CONTACT_4 != '' and not(matches(EMPLOYER_CONTACT_4,$varRegexEmployerContact)) } VALUE=[ "Invalid Employer Contact 4|"]
IF CONDITION{EMPLOYER_CONTACT_5 != '' and not(matches(EMPLOYER_CONTACT_5,$varRegexEmployerContact)) } VALUE=[ "Invalid Employer Contact 5|"]
IF CONDITION{EMPLOYER_CONTACT_6 != '' and not(matches(EMPLOYER_CONTACT_6,$varRegexEmployerContact)) } VALUE=[ "Invalid Employer Contact 6|"]
IF CONDITION{EMPLOYER_CONTACT_7 != '' and not(matches(EMPLOYER_CONTACT_7,$varRegexEmployerContact)) } VALUE=[ "Invalid Employer Contact 7|"]
IF CONDITION{EMPLOYER_CONTACT_8 != '' and not(matches(EMPLOYER_CONTACT_8,$varRegexEmployerContact)) } VALUE=[ "Invalid Employer Contact 8|"]
IF CONDITION{EMPLOYER_CONTACT_9 != '' and not(matches(EMPLOYER_CONTACT_9,$varRegexEmployerContact)) } VALUE=[ "Invalid Employer Contact 9|"]
IF CONDITION{EMPLOYER_CONTACT_10 != '' and not(matches(EMPLOYER_CONTACT_10,$varRegexEmployerContact)) } VALUE=[ "Invalid Employer Contact 10|"]
IF CONDITION{REPORTING_FIELD1 != '' and not(matches(REPORTING_FIELD1,$varRegexReportingField))} VALUE=[ "Invalid Reporting Field 1|"]
IF CONDITION{REPORTING_FIELD2 != '' and not(matches(REPORTING_FIELD2,$varRegexReportingField))} VALUE=[ "Invalid Reporting Field 2|"]
IF CONDITION{REPORTING_FIELD3 != '' and not(matches(REPORTING_FIELD3,$varRegexReportingField))} VALUE=[ "Invalid Reporting Field 3|"]
IF CONDITION{REPORTING_FIELD4 != '' and not(matches(REPORTING_FIELD4,$varRegexReportingField))} VALUE=[ "Invalid Reporting Field 4|"]
IF CONDITION{SUPERVISOR_EMPLOYEE_ID = ''} VALUE = ['No Supervisor ID provided|']
IF CONDITION{SUPERVISOR_EMPLOYEE_ID !='' and (SUPERVISOR_FIRST_NAME = '' or SUPERVISOR_LAST_NAME = '' )} VALUE=[ "Supervisor without First Name and Last Name| "]
IF CONDITION{((EMPLOYMENT_STATUS = 'IN') or (EMPLOYMENT_STATUS = 'OL') or (EMPLOYMENT_STATUS = 'AE') or (EMPLOYMENT_STATUS = 'SU')) and (TERMINATION_DATE != '') } VALUE=["Term date present in non Term/Retired employment status |" ]
IF CONDITION{ contains(SCHEDULED_DAYS_PER_WEEK ,'.' )} VALUE=['Partial work days|']
IF CONDITION{$varOriginalDate<0 } VALUE=['Original DOH > Most Recent DOH|']
IF CONDITION{(preceding ::Employee_SSN = EMPLOYEE_SSN) } VALUE=[ "Duplicate SSN|" ]
IF CONDITION{(preceding ::Employee_ID = EMPLOYEE_ID) } VALUE=[ "Duplicate Employee ID|" ]