Two File Processing

When the team receives two files, they will update the procedures for checking and validating the data. In addition, they will implement a new process to connect to Sunlife’s system, allowing them to acquire a unique identifier (comparable to a tracking number). Moreover, they will merge individual reports into a unified document and improve the comprehensibility of error reports.

Trading Partner Flow

A file is placed in a designated location. The process flow retrieves this file and checks for the presence of a corresponding client file in the same location.
If the client file is found, the process creates a JSON trigger file in a specified location and relocates the two source files to the same location as the trigger file.
If the client file is not found, the process flow terminates.

SL_PF_InboundFile_TradingPartner_v2

Client Flow

A file is placed in a designated location. The process flow retrieves this file and checks for the presence of a corresponding trading partner file in the same location.
If the trading partner file is found, the process creates a JSON trigger file in a specified location and also relocates the two source files to the same location as the trigger file.
If the trading partner file is not found, the process flow terminates.

SL_PF_InboundFile_Client_v2

Merge Flow

Once a trigger file is created in the specified location, the merge process flow is activated.
The process first selects the trading partner file.
The data from the trading partner file is converted into a standard file format.
Validation rules are applied to the standardized file format.
Two data streams are generated from the validation process: one for valid records and another for erroneous records.
Validations are performed at the record level for error records, focusing on errors and warning fields.
Validations are conducted at both the record and field levels for valid records.
Two output files are generated—one containing valid records and another containing erroneous records. The details of these files are also stored in the database.
The process then selects the client file.
The data from the client file is converted into a standard file format.
Validation rules are applied to the standardized file format.
Two data streams are generated from the validation process: one for valid records and another for erroneous records.
Validations are performed at the record level for error records, focusing on errors and warning fields.
Validations are conducted at both the record and field levels for valid records.
Two output files are generated—one containing valid records and another containing erroneous records. The details of these files are also stored in the database.
Following this, a mapping process checks the pass percentage for valid records. This percentage must exceed the threshold defined in the transaction parameters.
If the percentage check is successful, both valid record files are forwarded to the merge mapping process.
The merge mapping generates three streams: a merged file, orphaned trading partner records, and orphaned client records.
A subsequent merge mapping consolidates orphaned records into a single file, including a descriptive file name.
An email notification is sent containing the erroneous records, the merged file, and the orphaned file.
Finally, all files are placed in the designated target location.

SL_PF_Outbound_MergeFlow_v2

Solution Design:

Source File_Trigger.txt from FTP Location.

Map values from File Trigger to Context.

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.

Error 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|"]

Warning 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|" ]