Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Current »

It outlines the steps and activities involved in generating reports for good and bad records within a system. The document details various stages of data processing, including picking up source files from an FTP location, validating and mapping data, creating trigger and control files, and handling error notifications.

Pre-requisite:

  1. Configure Database

  2. Create a Template.

Solution Design:

1. Process Flow Activity:

image-20240823-054731.png

image-20240823-060653.png

Text to Text Conversion for Standard Format and Validation Workflow

  1. Conversion of Source File Data to a Standardized Format

    • The source file data undergoes a transformation process where it is converted into a standardized file format. This step is crucial for ensuring consistency across various datasets, allowing for uniform processing and facilitating easier application of validation rules.

  2. Application of Validation Rules on Standardized Data

    • Once the data is in a standardized format, a comprehensive set of validation rules is applied. These rules are designed to ensure that the data meets the required standards and adheres to the business logic. The validation process is critical for identifying any discrepancies or errors in the data.

  3. Generation of Good and Bad Record Streams Through Validation Mapping

    • The validation process results in the categorization of data into two distinct streams:

      • Good Records Stream: This stream consists of data records that have successfully passed all validation checks. These records are deemed accurate and ready for further processing.

      • Bad Records Stream: This stream includes data records that have failed one or more validation checks. These records are flagged for further review and correction.

image-20240823-061703.png

Validation Rule Applied at the Record Level for SingleFile_ADP_Text_Layout”

image-20240823-062701.png

Validation Rules

 Conditions (Expand to View)

$Input_SL_SingleFile_ADP_Text_Layout/Root/Record[
(
($var_fetch_key_identifier = 'Employee SSN' and Employee_SSN != '' and (saxonJavaMapperUtilityClass:replaceAll(Employee_SSN, $varRegexSSN, 'VALID') = 'VALID'))
or
($var_fetch_key_identifier = 'Employee ID' and Employee_ID != '' and (saxonJavaMapperUtilityClass:replaceAll(Employee_ID, $varRegexCheckEmpID, 'VALID') = 'VALID')))
and
(Employee_Title= '' or (Employee_Title!= '' and $Var_EmployeeTittleVM != 'InvalidTitle'))
and
(Employee_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Employee_First_Name, $varRegexFirstName,'VALID') = 'VALID'))
and
(Employee_Middle_Name = '' or (Employee_Middle_Name!= '' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Middle_Name, $varRegexMiddleName,'VALID') = 'VALID')))
and
(Employee_Last_Name!= '' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Last_Name, $varRegexLastName,'VALID') = 'VALID'))
and
(Employee_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Date_of_Birth, $var_DateFormat_REGEX,'VALID') = 'VALID'))
and
(Employee_Gender!= '' and $Var_GenderCodesVM!= 'InvalidGender')
and
(Marital_Status ='' or (Marital_Status!='' and $var_MaritialStatus!= 'InvalidMaritalStatus'))
and
(Employee_Home_Address_Line_1!='' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Home_Address_Line_1, $varRegexAddress,'VALID') = 'VALID'))
and
(Employee_Home_Address_Line_2='' or (Employee_Home_Address_Line_2!='' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Home_Address_Line_2, $varRegexAddress,'VALID') = 'VALID')))
and
(Employee_Home_Address_Line_3='' or (Employee_Home_Address_Line_3 !='' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Home_Address_Line_3, $varRegexAddress,'VALID') = 'VALID')))
and
(Employee_Home_City!='' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Home_City, $varRegexHomeCity,'VALID') = 'VALID'))
and
(Employee_Home_State!='' and $Var_EmployeeHomeStateVM!= 'NonState')
and
(Employee_Home_Zip_Code!='' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Home_Zip_Code, $varRegexZipCode,'VALID') = 'VALID'))
and
(Employee_Country ='' or (Employee_Country!='' and $Var_EmployeeCountryCodesVM != 'InvalidCountry'))
and
(Employee_County='' or (Employee_County!='' and (saxonJavaMapperUtilityClass:replaceAll(Employee_County, $VarCounty,'VALID') = 'VALID')))
and
(Employee_Home_Address_Region ='' or (Employee_Home_Address_Region !='' and (matches (Employee_Home_Address_Region,$varRegexAddressRegion))))
and
(Employee_Home_Phone_Number='' or (Employee_Home_Phone_Number!='' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Home_Phone_Number, $varNumberMobilePhone,'VALID') = 'VALID')))
and
(Employee_Mobile_Phone_Number='' or (Employee_Mobile_Phone_Number!='' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Mobile_Phone_Number, $varNumberMobilePhone,'VALID') = 'VALID')))
and
(Organization_Unit= '' or (Organization_Unit!= '' and (saxonJavaMapperUtilityClass:replaceAll(Organization_Unit, $varRegexOrganizationUnit,'VALID') = 'VALID')))
and
(Employee_Job_Title= '')or ((Employee_Job_Title!= '') and (saxonJavaMapperUtilityClass:replaceAll(Employee_Job_Title, $varRegexEmployeeJobTitle,'VALID') = 'VALID'))
and
(Employee_Original_Date_of_Hire='' or (Employee_Original_Date_of_Hire!='' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Original_Date_of_Hire, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Employee_Most_Recent_Date_of_Hire=''or(Employee_Most_Recent_Date_of_Hire!=''and(saxonJavaMapperUtilityClass:replaceAll(Employee_Most_Recent_Date_of_Hire, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Employee_Adjusted_Date_of_Hire=''or(Employee_Adjusted_Date_of_Hire!=''and(saxonJavaMapperUtilityClass:replaceAll(Employee_Adjusted_Date_of_Hire, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Employee_Work_State ='' or (Employee_Work_State!='' and $Var_EmployeeWorkStateVM != 'InvalidWorkState'))
and
(Employment_Status!='' and $Var_EmploymentStatusVM != 'InvalidEmploymentStatus')

and
(Employment_Type ='' or (Employment_Type!='' and $Var_EmploymentTypeVM != 'InvalidEmploymentType'))

and
(Employee_Email_Address='' or (Employee_Email_Address!='' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Email_Address,$varRegexEmail,'VALID') = 'VALID')))
and
(Work_Email_Address='' or (Work_Email_Address!='' and (saxonJavaMapperUtilityClass:replaceAll(Work_Email_Address,$varRegexEmail,'VALID') = 'VALID')))
and
(Work_Mobile_Phone_Number='' or (Work_Mobile_Phone_Number!='' and (saxonJavaMapperUtilityClass:replaceAll(Work_Mobile_Phone_Number, $varNumberMobilePhone,'VALID') = 'VALID')))
and
(Business_Unit='' or (Business_Unit!='' and (saxonJavaMapperUtilityClass:replaceAll(Business_Unit,$varRegexBusinessUnit,'VALID') = 'VALID')))
and
(Division='' or (Division!='' and (saxonJavaMapperUtilityClass:replaceAll(Division,$varRegexBusinessUnit,'VALID') = 'VALID')))
and
(Exempt_Status='' or (Exempt_Status!='' and $Var_ExemptionTypeVM != 'InvalidExemptionType'))
and
(Compensation_Method='' or (Compensation_Method!='' and $Var_CompensationMethodVM != 'InvalidCompensationMethod'))
and
(Employee_Earnings = '' or (Employee_Earnings!= '' and (saxonJavaMapperUtilityClass:replaceAll(Employee_Earnings, $varRegexEmployeeEarning,'VALID') = 'VALID')))
and
(Earnings_Frequency = '' or (Earnings_Frequency != '' and $var_EmployeeFrequencyVM != 'InvalidEarningsFrequency'))
and
(Earnings_Effective_Date ='' or (Earnings_Effective_Date !='' and (saxonJavaMapperUtilityClass:replaceAll(Earnings_Effective_Date, $var_DateFormat_REGEX,'VALID')='VALID')))
and
(Group_Type='' or (Group_Type!='' and (saxonJavaMapperUtilityClass:replaceAll(Group_Type, $varRegexGroupType,'VALID')='VALID')))
and
(Primary_Phone_Type='' or (Primary_Phone_Type!='' and $Var_PhoneTypeVM != 'InvalidPhoneType'))

and
(Union_Type='' or (Union_Type!='' and $Var_UnionTypeVM != 'InvalidUnionType'))
and
(Union_Name='' or (Union_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Union_Name, $VarRegexUnionName,'VALID')='VALID')))
and
(Field_50_In_75_Rule_Indicator='' or (Field_50_In_75_Rule_Indicator!='' and (saxonJavaMapperUtilityClass:replaceAll(Field_50_In_75_Rule_Indicator, $varRegexKeyEmployeeIndicator,'VALID')='VALID')))
and
(Work_At_Home_Indicator='' or (Work_At_Home_Indicator!='' and (saxonJavaMapperUtilityClass:replaceAll(Work_At_Home_Indicator, $varRegexKeyEmployeeIndicator,'VALID')='VALID')))
and
(Employment_Class ='' or (Employment_Class!='' and $Var_EmploymentClass != 'InvalidEmploymentClass'))
and
(Employment_Strength ='' or (Employment_Strength!='' and $Var_EmploymentStrengthsVM != 'InvalidEmployeeStrength'))
and
(Hours_Worked_Previous_12_Months='' or (Hours_Worked_Previous_12_Months!='' and (saxonJavaMapperUtilityClass:replaceAll(Hours_Worked_Previous_12_Months, $varRegexHoursWorked,'VALID')='VALID')))
and
(Weeks_Worked_Previous_12_Months ='' or (Weeks_Worked_Previous_12_Months !='' and (matches(Weeks_Worked_Previous_12_Months, $varRegexHoursWorked))) )
and
(Key_Employee_Indicator='' or (Key_Employee_Indicator!='' and (saxonJavaMapperUtilityClass:replaceAll(Key_Employee_Indicator, $varRegexKeyEmployeeIndicator,'VALID')='VALID')))
and
(Supervisor_Employee_ID ='' or (Supervisor_Employee_ID!='' and (saxonJavaMapperUtilityClass:replaceAll(Supervisor_Employee_ID, $varRegexSupervisorEID,'VALID')='VALID')))
and
(Supervisor_First_Name ='' or (Supervisor_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Supervisor_First_Name, $varRegexFirstName,'VALID')='VALID')))
and
(Supervisor_Last_Name ='' or (Supervisor_Last_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Supervisor_Last_Name, $varRegexLastName,'VALID')='VALID')))
and
(STD_Eligibility_Date ='' or (STD_Eligibility_Date!='' and (saxonJavaMapperUtilityClass:replaceAll(STD_Eligibility_Date, $var_DateFormat_REGEX,'VALID')='VALID')))
and
(STD_Weekly_Earnings ='' or (STD_Weekly_Earnings !='' and (matches(STD_Weekly_Earnings, $varRegexEmployeeEarning))) )
and
(STD_Earnings_Amount ='' or (STD_Earnings_Amount !='' and (matches(STD_Earnings_Amount, $varRegexEmployeeEarning))) )
and
(STD_Earnings_Effective_Date ='' or (STD_Earnings_Effective_Date !='' and (matches(STD_Earnings_Effective_Date, $var_DateFormat_REGEX))) )
and
(STD_Earnings_Frequency ='' or (STD_Earnings_Frequency !='' and $var_STDFreqVM != 'InvalidEarningsFrequency'))
and
(LTD_Monthly_Earnings ='' or (LTD_Monthly_Earnings !='' and (matches(LTD_Monthly_Earnings, $varRegexEmployeeEarning))) )
and
(STD_Election ='' or (STD_Election!='' and $Var_STD_ElectionVM != 'InvalidBenefitElectionType'))
and
(STD_Benefit_Amount ='' or (STD_Benefit_Amount!='' and (saxonJavaMapperUtilityClass:replaceAll(STD_Benefit_Amount, $varRegexBenefitAmount,'VALID')='VALID')))
and
(STD_Class ='' or (STD_Class!='' and (saxonJavaMapperUtilityClass:replaceAll(STD_Class, $varRegexClass,'VALID')='VALID')))
and
(STD_Coverage_Termination_Date ='' or (STD_Coverage_Termination_Date!='' and (saxonJavaMapperUtilityClass:replaceAll(STD_Coverage_Termination_Date
, $var_DateFormat_REGEX,'VALID')='VALID')))
and
(Statutory_Disability_Type ='' or (Statutory_Disability_Type!='' and $Var_StatutoryDisabilityTypeVM != 'InvalidStatutoryDisabilityType'))
and
(LTD_Eligibility_Date ='' or (LTD_Eligibility_Date!='' and (saxonJavaMapperUtilityClass:replaceAll(LTD_Eligibility_Date, $var_DateFormat_REGEX,'VALID')='VALID')))
and
(LTD_Election= '' or (LTD_Election!= '' and $Var_LTD_ElectionVM != 'InvalidBenefitElectionType'))
and
(LTD_Benefit_Amount ='' or (LTD_Benefit_Amount!='' and (saxonJavaMapperUtilityClass:replaceAll(LTD_Benefit_Amount, $varRegexBenefitAmount,'VALID')='VALID')))
and
(LTD_Class='' or (LTD_Class!='' and (saxonJavaMapperUtilityClass:replaceAll(LTD_ClassvarRegexClass,'VALID')='VALID')))
and
(LTD_Coverage_Termination_Date='' or (LTD_Coverage_Termination_Date!='' and (saxonJavaMapperUtilityClass:replaceAll(LTD_Coverage_Termination_Date
, $var_DateFormat_REGEX,'VALID')='VALID')))
and
(Occupation_Qualifier1 ='' or (Occupation_Qualifier1!='' and (saxonJavaMapperUtilityClass:replaceAll(Occupation_Qualifier1, $varRegexOccupQual,'VALID')='VALID')))
and
(Occupation_Qualifier2 ='' or (Occupation_Qualifier2!='' and (saxonJavaMapperUtilityClass:replaceAll(Occupation_Qualifier2, $varRegexOccupQual,'VALID')='VALID')))
and
(Occupation_Qualifier3 ='' or (Occupation_Qualifier3!='' and (saxonJavaMapperUtilityClass:replaceAll(Occupation_Qualifier3, $varRegexOccupQual,'VALID')='VALID')))
and
(Occupation_Qualifier4 ='' or (Occupation_Qualifier4!='' and (saxonJavaMapperUtilityClass:replaceAll(Occupation_Qualifier4, $varRegexOccupQual,'VALID')='VALID')))
and
(Occupation_Qualifier5 ='' or (Occupation_Qualifier5!='' and (saxonJavaMapperUtilityClass:replaceAll(Occupation_Qualifier5, $varRegexOccupQual,'VALID')='VALID')))
and
(Occupation_Qualifier6 ='' or (Occupation_Qualifier6!='' and (saxonJavaMapperUtilityClass:replaceAll(Occupation_Qualifier6, $varRegexOccupQual,'VALID')='VALID')))
and
(Occupation_Qualifier7 ='' or (Occupation_Qualifier7!='' and (saxonJavaMapperUtilityClass:replaceAll(Occupation_Qualifier7, $varRegexOccupQual,'VALID')='VALID')))
and
(Occupation_Qualifier8 ='' or (Occupation_Qualifier8!='' and (saxonJavaMapperUtilityClass:replaceAll(Occupation_Qualifier8, $varRegexOccupQual,'VALID')='VALID')))
and
(Occupation_Qualifier9 ='' or (Occupation_Qualifier9!='' and (saxonJavaMapperUtilityClass:replaceAll(Occupation_Qualifier9, $varRegexOccupQual,'VALID')='VALID')))
and
(Occupation_Qualifier10 ='' or (Occupation_Qualifier10!='' and (saxonJavaMapperUtilityClass:replaceAll(Occupation_Qualifier10, $varRegexOccupQual,'VALID')='VALID')))
and
(ER_Contact_1='' or (ER_Contact_1 !='' and (saxonJavaMapperUtilityClass:replaceAll(ER_Contact_1,$varRegexEmployerContact,'VALID')='VALID')))
and
(ER_Contact_2='' or (ER_Contact_2 !='' and (saxonJavaMapperUtilityClass:replaceAll(ER_Contact_2,$varRegexEmployerContact,'VALID')='VALID')))
and
(ER_Contact_3='' or (ER_Contact_3 !='' and (saxonJavaMapperUtilityClass:replaceAll(ER_Contact_3,$varRegexEmployerContact,'VALID')='VALID')))
and
(ER_Contact_4='' or (ER_Contact_4 !='' and (saxonJavaMapperUtilityClass:replaceAll(ER_Contact_4,$varRegexEmployerContact,'VALID')='VALID')))
and
(ER_Contact_5='' or (ER_Contact_5 !='' and (saxonJavaMapperUtilityClass:replaceAll(ER_Contact_5,$varRegexEmployerContact,'VALID')='VALID')))
and
(ER_Contact_6='' or (ER_Contact_6 !='' and (saxonJavaMapperUtilityClass:replaceAll(ER_Contact_6,$varRegexEmployerContact,'VALID')='VALID')))
and
(ER_Contact_7='' or (ER_Contact_7 !='' and (saxonJavaMapperUtilityClass:replaceAll(ER_Contact_7,$varRegexEmployerContact,'VALID')='VALID')))
and
(ER_Contact_8='' or (ER_Contact_8 !='' and (saxonJavaMapperUtilityClass:replaceAll(ER_Contact_8,$varRegexEmployerContact,'VALID')='VALID')))
and
(ER_Contact_9='' or (ER_Contact_9 !='' and (saxonJavaMapperUtilityClass:replaceAll(ER_Contact_9 ,$varRegexEmployerContact,'VALID')='VALID')))
and
(ER_Contact_10='' or (ER_Contact_10 !='' and (saxonJavaMapperUtilityClass:replaceAll(ER_Contact_10,$varRegexEmployerContact,'VALID')='VALID')))
and
(Reporting_Field1='' or (Reporting_Field1 !='' and (saxonJavaMapperUtilityClass:replaceAll(Reporting_Field1,$varRegexReportingField,'VALID')='VALID')))
and
(Reporting_Field2='' or (Reporting_Field2 !='' and (saxonJavaMapperUtilityClass:replaceAll(Reporting_Field2,$varRegexReportingField,'VALID')='VALID')))
and
(Reporting_Field3='' or (Reporting_Field3 !='' and (saxonJavaMapperUtilityClass:replaceAll(Reporting_Field3,$varRegexReportingField,'VALID')='VALID')))
and
(Reporting_Field4='' or (Reporting_Field4 !='' and (saxonJavaMapperUtilityClass:replaceAll(Reporting_Field4,$varRegexReportingField,'VALID')='VALID')))
and
(Reporting_Field5='' or (Reporting_Field5 !='' and (saxonJavaMapperUtilityClass:replaceAll(Reporting_Field5,$varRegexReportingField,'VALID')='VALID')))
and
(Spouse_Date_of_Change = '' or (Spouse_Date_of_Change != '' and matches(Spouse_Date_of_Change, $var_DateFormat_REGEX)))
and
(Spouse_First_Name ='' or (Spouse_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Spouse_First_Name, $varRegexFirstName,'VALID')='VALID')))
and
(Spouse_Last_Name ='' or (Spouse_Last_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Spouse_Last_Name, $varRegexLastName,'VALID')='VALID')))
and
(Spouse_Date_of_Birth ='' or (Spouse_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Spouse_Date_of_Birth, $var_DateFormat_REGEX,'VALID')='VALID')))
and
(Spouse_SSN ='' or (Spouse_SSN!='' and (saxonJavaMapperUtilityClass:replaceAll(Spouse_SSN, $VarRegexSpouseSSN,'VALID')='VALID')))
and
(Spouse_Employee_ID ='' or (Spouse_Employee_ID!='' and (saxonJavaMapperUtilityClass:replaceAll(Spouse_Employee_ID, $VarRegexSpouseEMPID,'VALID')='VALID')))
and
(Spouse_Reason_of_Change ='' or (Spouse_Reason_of_Change!='' and $Var_SpouseROC != 'InvalidSpouseROC'))
and
(Policy_Number='' or (Policy_Number!='' and (saxonJavaMapperUtilityClass:replaceAll(Policy_Number,$VarRegexPolicyNumber,'VALID')='VALID')))
and
(Dep_Dental_Prem_Post_Tax ='' or (Dep_Dental_Prem_Post_Tax !='' and (matches(Dep_Dental_Prem_Post_Tax, $varRegexTax))) )
and
(Dep_Dental_Prem_Pre_Tax ='' or (Dep_Dental_Prem_Pre_Tax !='' and (matches(Dep_Dental_Prem_Pre_Tax, $varRegexTax))) )
and
(Dep_Life_Ins_Prem_Post_Tax ='' or (Dep_Life_Ins_Prem_Post_Tax !='' and (matches(Dep_Life_Ins_Prem_Post_Tax, $varRegexTax))) )
and
(Dep_Life_Ins_Prem_Pre_Tax ='' or (Dep_Life_Ins_Prem_Pre_Tax !='' and (matches(Dep_Life_Ins_Prem_Pre_Tax, $varRegexTax))) )
and
(Dep_Med_Prem_Post_Tax ='' or (Dep_Med_Prem_Post_Tax !='' and (matches(Dep_Med_Prem_Post_Tax, $varRegexTax))) )
and
(Dep_Med_Prem_Pre_Tax ='' or (Dep_Med_Prem_Pre_Tax !='' and (matches(Dep_Med_Prem_Pre_Tax, $varRegexTax))) )
and
(Hospital_Indemnity_Prem_Post_Tax ='' or (Hospital_Indemnity_Prem_Post_Tax !='' and (matches(Hospital_Indemnity_Prem_Post_Tax, $varRegexTax))) )
and
(Hospital_Indemnity_Prem_Pre_Tax ='' or (Hospital_Indemnity_Prem_Pre_Tax !='' and (matches(Hospital_Indemnity_Prem_Pre_Tax, $varRegexTax))) )
and
(Long_Term_Care_Prem_Post_Tax ='' or (Long_Term_Care_Prem_Post_Tax !='' and (matches(Long_Term_Care_Prem_Post_Tax, $varRegexTax))) )
and
(Long_Term_Care_Prem_Pre_Tax ='' or (Long_Term_Care_Prem_Pre_Tax !='' and (matches(Long_Term_Care_Prem_Pre_Tax, $varRegexTax))) )
and
(LTD_Prem_Post_Tax ='' or (LTD_Prem_Post_Tax !='' and (matches(LTD_Prem_Post_Tax, $varRegexTax))) )
and
(LTD_Prem_Pre_Tax ='' or (LTD_Prem_Pre_Tax !='' and (matches(LTD_Prem_Pre_Tax, $varRegexTax))) )
and
(Misc_1_Prem_Post_Tax ='' or (Misc_1_Prem_Post_Tax !='' and (matches(Misc_1_Prem_Post_Tax, $varRegexTax))) )
and
(Misc_1_Prem_Pre_Tax ='' or (Misc_1_Prem_Pre_Tax !='' and (matches(Misc_1_Prem_Pre_Tax, $varRegexTax))) )
and
(Misc_2_Prem_Post_Tax ='' or (Misc_2_Prem_Post_Tax !='' and (matches(Misc_2_Prem_Post_Tax, $varRegexTax))) )
and
(Misc_2_Prem_Pre_Tax ='' or (Misc_2_Prem_Pre_Tax !='' and (matches(Misc_2_Prem_Pre_Tax, $varRegexTax))) )
and
(Misc_3_Prem_Post_Tax ='' or (Misc_3_Prem_Post_Tax !='' and (matches(Misc_3_Prem_Post_Tax, $varRegexTax))) )
and
(Misc_3_Prem_Pre_Tax ='' or (Misc_3_Prem_Pre_Tax !='' and (matches(Misc_3_Prem_Pre_Tax, $varRegexTax))) )

and
(Other_Dental_Prem_Post_Tax ='' or (Other_Dental_Prem_Post_Tax !='' and (matches(Other_Dental_Prem_Post_Tax, $varRegexTax))) )
and
(Other_Dental_Prem_Pre_Tax ='' or (Other_Dental_Prem_Pre_Tax !='' and (matches(Other_Dental_Prem_Pre_Tax, $varRegexTax))) )
and
(Other_Life_Ins_Prem_Post_Tax ='' or (Other_Life_Ins_Prem_Post_Tax !='' and (matches(Other_Life_Ins_Prem_Post_Tax, $varRegexTax))) )
and
(Other_Life_Ins_Prem_Pre_Tax ='' or (Other_Life_Ins_Prem_Pre_Tax !='' and (matches(Other_Life_Ins_Prem_Pre_Tax, $varRegexTax))) )
and
(Other_Med_Prem_Post_Tax ='' or (Other_Med_Prem_Post_Tax !='' and (matches(Other_Med_Prem_Post_Tax, $varRegexTax))) )
and
(Other_Med_Prem_Pre_Tax ='' or (Other_Med_Prem_Pre_Tax !='' and (matches(Other_Med_Prem_Pre_Tax, $varRegexTax))) )
and
(Other_Vision_Prem_Post_Tax ='' or (Other_Vision_Prem_Post_Tax !='' and (matches(Other_Vision_Prem_Post_Tax, $varRegexTax))) )
and
(Other_Vision_Prem_Pre_Tax ='' or (Other_Vision_Prem_Pre_Tax !='' and (matches(Other_Vision_Prem_Pre_Tax, $varRegexTax))) )
and
(Personal_Accident_Ins_Prem_Post_Tax ='' or (Personal_Accident_Ins_Prem_Post_Tax !='' and (matches(Personal_Accident_Ins_Prem_Post_Tax, $varRegexTax))) )
and
(Personal_Accident_Ins_Prem_Pre_Tax ='' or (Personal_Accident_Ins_Prem_Pre_Tax !='' and (matches(Personal_Accident_Ins_Prem_Pre_Tax, $varRegexTax))) )

and
(Primary_Cancer_Prem_Post_Tax ='' or (Primary_Cancer_Prem_Post_Tax !='' and (matches(Primary_Cancer_Prem_Post_Tax, $varRegexTax))) )
and
(Primary_Cancer_Prem_Pre_Tax ='' or (Primary_Cancer_Prem_Pre_Tax !='' and (matches(Primary_Cancer_Prem_Pre_Tax, $varRegexTax))) )
and
(Primary_Critical_Illness_Prem_Post_Tax =''or (Primary_Critical_Illness_Prem_Post_Tax !='' and (matches(Primary_Critical_Illness_Prem_Post_Tax, $varRegexTax))) )
and
(Primary_Critical_Illness_Prem_Pre_Tax ='' or (Primary_Critical_Illness_Prem_Pre_Tax !='' and (matches(Primary_Critical_Illness_Prem_Pre_Tax, $varRegexTax))) )
and
(Primary_Dental_Prem_Post_Tax ='' or (Primary_Dental_Prem_Post_Tax !='' and (matches(Primary_Dental_Prem_Post_Tax, $varRegexTax))) )
and
(Primary_Dental_Prem_Pre_Tax ='' or (Primary_Dental_Prem_Pre_Tax !='' and (matches(Primary_Dental_Prem_Pre_Tax, $varRegexTax))) )
and
(Primary_Life_Ins_Prem_Post_Tax ='' or (Primary_Life_Ins_Prem_Post_Tax !='' and (matches(Primary_Life_Ins_Prem_Post_Tax, $varRegexTax))) )
and
(Primary_Life_Ins_Prem_Pre_Tax ='' or (Primary_Life_Ins_Prem_Pre_Tax !='' and (matches(Primary_Life_Ins_Prem_Pre_Tax, $varRegexTax))) )
and
(Primary_Med_Prem_Post_Tax ='' or (Primary_Med_Prem_Post_Tax !='' and (matches(Primary_Med_Prem_Post_Tax, $varRegexTax))) )
and
(Primary_Med_Prem_Pre_Tax ='' or (Primary_Med_Prem_Pre_Tax !='' and (matches(Primary_Med_Prem_Pre_Tax, $varRegexTax))) )
and
(Primary_Vision_Prem_Post_Tax ='' or (Primary_Vision_Prem_Post_Tax !='' and (matches(Primary_Vision_Prem_Post_Tax, $varRegexTax))) )
and
(Primary_Vision_Prem_Pre_Tax ='' or (Primary_Vision_Prem_Pre_Tax !='' and (matches(Primary_Vision_Prem_Pre_Tax, $varRegexTax))) )
and
(Spouse_Cancer_Prem_Post_Tax ='' or (Spouse_Cancer_Prem_Post_Tax !='' and (matches(Spouse_Cancer_Prem_Post_Tax, $varRegexTax))) )
and
(Spouse_Cancer_Prem_Pre_Tax ='' or (Spouse_Cancer_Prem_Pre_Tax !='' and (matches(Spouse_Cancer_Prem_Pre_Tax, $varRegexTax))) )
and
(Spouse_Critical_Illness_Prem_Post_Tax ='' or (Spouse_Critical_Illness_Prem_Post_Tax !='' and (matches(Spouse_Critical_Illness_Prem_Post_Tax, $varRegexTax))) )
and
(Spouse_Critical_Illness_Prem_Pre_Tax ='' or(Spouse_Critical_Illness_Prem_Pre_Tax !='' and (matches(Spouse_Critical_Illness_Prem_Pre_Tax, $varRegexTax))) )
and
(Spouse_Life_Ins_Prem_Post_Tax ='' or(Spouse_Life_Ins_Prem_Post_Tax !='' and (matches(Spouse_Life_Ins_Prem_Post_Tax, $varRegexTax))) )
and
(Spouse_Life_Ins_Prem_Pre_Tax ='' or (Spouse_Life_Ins_Prem_Pre_Tax !='' and (matches(Spouse_Life_Ins_Prem_Pre_Tax, $varRegexTax))) )
and
(STD_Prem_Post_Tax ='' or (STD_Prem_Post_Tax !='' and (matches(STD_Prem_Post_Tax, $varRegexTax))) )
and
(STD_Prem_Pre_Tax ='' or (STD_Prem_Pre_Tax !='' and (matches(STD_Prem_Pre_Tax, $varRegexTax))) )
and
(Accident_Choice ='' or (Accident_Choice !='' and (matches(Accident_Choice, $varRegexOccupQual))) )
and
(Accident_Class ='' or (Accident_Class !='' and (matches(Accident_Class, $varRegexClass))) )
and
(Accident_Eligibility_Date ='' or (Accident_Eligibility_Date !='' and (matches(Accident_Eligibility_Date, $var_DateFormat_REGEX))) )
and
(Accident_Coverage_Termination_Date ='' or (Accident_Coverage_Termination_Date !='' and (matches(Accident_Coverage_Termination_Date, $var_DateFormat_REGEX))) )
and
(Accident_Dependent_Tier ='' or (Accident_Dependent_Tier !='' and $var_AccidentDependentTierVM != 'InvalidDependentTierCodes'))
and
(Employee_Critical_Illness_Coverage_Termination_Date ='' or (Employee_Critical_Illness_Coverage_Termination_Date !='' and (matches(Employee_Critical_Illness_Coverage_Termination_Date, $var_DateFormat_REGEX))) )
and
(Employee_Critical_Illness_Eligibility_Date ='' or (Employee_Critical_Illness_Eligibility_Date !='' and (matches(Employee_Critical_Illness_Eligibility_Date, $var_DateFormat_REGEX))) )
and
(Employee_Critical_Illness_Requested_Amount ='' or (Employee_Critical_Illness_Requested_Amount !='' and (matches(Employee_Critical_Illness_Requested_Amount, $varRegexBenefitAmount))) )
and
(Critical_Illness_Choice ='' or (Critical_Illness_Choice !='' and (matches(Critical_Illness_Choice, $varRegexOccupQual))) )
and
(Critical_Illness_Class ='' or (Critical_Illness_Class !='' and (matches(Critical_Illness_Class, $varRegexClass))) )
and
(Spouse_Critical_Illness_Coverage_Termination_Date ='' or (Spouse_Critical_Illness_Coverage_Termination_Date !='' and (matches(Spouse_Critical_Illness_Coverage_Termination_Date, $var_DateFormat_REGEX))) )
and
(Spouse_Critical_Illness_Eligibility_Date ='' or (Spouse_Critical_Illness_Eligibility_Date !='' and (matches(Spouse_Critical_Illness_Eligibility_Date, $var_DateFormat_REGEX))) )
and
(Spouse_Critical_Illness_Requested_Amount ='' or (Spouse_Critical_Illness_Requested_Amount !='' and (matches(Spouse_Critical_Illness_Requested_Amount, $varRegexBenefitAmount))) )
and
(Child_Critical_Illness_Coverage_Termination_Date ='' or (Child_Critical_Illness_Coverage_Termination_Date !='' and (matches(Child_Critical_Illness_Coverage_Termination_Date, $var_DateFormat_REGEX))) )
and
(Child_Critical_Illness_Eligibility_Date ='' or (Child_Critical_Illness_Eligibility_Date !='' and (matches(Child_Critical_Illness_Eligibility_Date, $var_DateFormat_REGEX))) )
and
(Child_Critical_Illness_Requested_Amount ='' or (Child_Critical_Illness_Requested_Amount !='' and (matches(Child_Critical_Illness_Requested_Amount, $varRegexBenefitAmount))) )
and
(Hospital_Indemnity_Choice ='' or (Hospital_Indemnity_Choice !='' and (matches(Hospital_Indemnity_Choice, $varRegexOccupQual))) )
and
(Hospital_Indemnity_Class ='' or (Hospital_Indemnity_Class !='' and (matches(Hospital_Indemnity_Class, $varRegexClass))) )
and
(Hospital_Indemnity_Coverage_Termination_Date ='' or (Hospital_Indemnity_Coverage_Termination_Date !='' and (matches(Hospital_Indemnity_Coverage_Termination_Date, $var_DateFormat_REGEX))) )
and
(Hospital_Indemnity_Dependent_Tier ='' or (Hospital_Indemnity_Dependent_Tier !='' and $var_HospitalIndemnityDependentTierVM != 'InvalidDependentTierCodes'))
and
(Hospital_Indemnity_Eligibility_Date_of_Coverage ='' or (Hospital_Indemnity_Eligibility_Date_of_Coverage !='' and (matches(Hospital_Indemnity_Eligibility_Date_of_Coverage, $var_DateFormat_REGEX))) )
and
(Voluntary_Cancer_Choice ='' or (Voluntary_Cancer_Choice !='' and (matches(Voluntary_Cancer_Choice, $varRegexOccupQual))) )
and
(Voluntary_Cancer_Class ='' or (Voluntary_Cancer_Class !='' and (matches (Voluntary_Cancer_Class,$varRegexClass))) )
and
(Voluntary_Cancer_Coverage_Termination_Date = '' or (Voluntary_Cancer_Coverage_Termination_Date != '' and (matches(Voluntary_Cancer_Coverage_Termination_Date, $var_DateFormat_REGEX) )))
and
(Voluntary_Cancer_Dependent_Tier = '' or (Voluntary_Cancer_Dependent_Tier != '' and $var_VoluntaryCancerDependentTierCodeVM != 'InvalidDependentTier'))
and
(Voluntary_Cancer_Eligibility_Date_of_Coverage = '' or (Voluntary_Cancer_Eligibility_Date_of_Coverage != '' and (matches(Voluntary_Cancer_Eligibility_Date_of_Coverage, $var_DateFormat_REGEX)) ))
and
(Employee_Smoker_Indicator = '' or (Employee_Smoker_Indicator != '' and (matches(Employee_Smoker_Indicator, $varRegexIndicator) )))
and
(Dependent_Spouse_First_Name='' or (Dependent_Spouse_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Spouse_First_Name,$varRegexFirstName,'VALID')='VALID')))
and
(Dependent_Spouse_Last_Name='' or (Dependent_Spouse_Last_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Spouse_Last_Name,$varRegexLastName,'VALID')='VALID')))
and
(Dependent_Spouse_Date_of_Birth='' or (Dependent_Spouse_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Spouse_Date_of_Birth, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Dependent_Spouse_Gender= '' or (Dependent_Spouse_Gender!= '' and $Var_DependentSpouseGenderCodesVM!= 'InvalidGender'))
and
(Dependent_Child_1_Date_of_Birth='' or (Dependent_Child_1_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_1_Date_of_Birth, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Dependent_Child_1_First_Name='' or (Dependent_Child_1_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_1_First_Name,$varRegexFirstName,'VALID')='VALID')))
and
(Dependent_Child_1_Gender= '' or (Dependent_Child_1_Gender!= '' and $Var_DependentChild1GenderCodesVM!= 'InvalidGender'))
and
(Dependent_Child_1_Last_Name='' or (Dependent_Child_1_Last_Name !='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_1_Last_Name,$varRegexLastName,'VALID')='VALID')))
and
(Dependent_Child_2_Date_of_Birth='' or (Dependent_Child_2_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_2_Date_of_Birth, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Dependent_Child_2_First_Name='' or (Dependent_Child_2_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_2_First_Name,$varRegexFirstName,'VALID')='VALID')))
and
(Dependent_Child_2_Gender= '' or (Dependent_Child_2_Gender!= '' and $Var_DependentChild2GenderCodesVM!= 'InvalidGender'))
and
(Dependent_Child_2_Last_Name='' or (Dependent_Child_2_Last_Name !='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_2_Last_Name,$varRegexLastName,'VALID')='VALID')))
and
(Dependent_Child_3_Date_of_Birth='' or (Dependent_Child_3_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_3_Date_of_Birth, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Dependent_Child_3_First_Name='' or (Dependent_Child_3_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_3_First_Name,$varRegexFirstName,'VALID')='VALID')))
and
(Dependent_Child_3_Gender= '' or (Dependent_Child_3_Gender!= '' and $Var_DependentChild3GenderCodesVM!= 'InvalidGender'))
and
(Dependent_Child_3_Last_Name='' or (Dependent_Child_3_Last_Name !='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_3_Last_Name,$varRegexLastName,'VALID')='VALID')))
and
(Dependent_Child_4_Date_of_Birth='' or (Dependent_Child_4_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_4_Date_of_Birth, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Dependent_Child_4_First_Name='' or (Dependent_Child_4_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_4_First_Name,$varRegexFirstName,'VALID')='VALID')))
and
(Dependent_Child_4_Gender= '' or (Dependent_Child_4_Gender!= '' and $Var_DependentChild4GenderCodesVM!= 'InvalidGender'))
and
(Dependent_Child_4_Last_Name='' or (Dependent_Child_4_Last_Name !='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_4_Last_Name,$varRegexLastName,'VALID')='VALID')))
and
(Dependent_Child_5_Date_of_Birth='' or (Dependent_Child_5_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_5_Date_of_Birth, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Dependent_Child_5_First_Name='' or (Dependent_Child_5_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_5_First_Name,$varRegexFirstName,'VALID')='VALID')))
and
(Dependent_Child_5_Gender= '' or (Dependent_Child_5_Gender!= '' and $Var_DependentChild5GenderCodesVM!= 'InvalidGender'))
and
(Dependent_Child_5_Last_Name='' or (Dependent_Child_5_Last_Name !='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_5_Last_Name,$varRegexLastName,'VALID')='VALID')))
and
(Dependent_Child_6_Date_of_Birth='' or (Dependent_Child_6_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_6_Date_of_Birth, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Dependent_Child_6_First_Name='' or (Dependent_Child_6_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_6_First_Name,$varRegexFirstName,'VALID')='VALID')))
and
(Dependent_Child_6_Gender= '' or (Dependent_Child_6_Gender!= '' and $Var_DependentChild6GenderCodesVM!= 'InvalidGender'))
and
(Dependent_Child_6_Last_Name='' or (Dependent_Child_6_Last_Name !='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_6_Last_Name,$varRegexLastName,'VALID')='VALID')))
and
(Dependent_Child_7_Date_of_Birth='' or (Dependent_Child_7_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_7_Date_of_Birth, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Dependent_Child_7_First_Name='' or (Dependent_Child_7_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_7_First_Name,$varRegexFirstName,'VALID')='VALID')))
and
(Dependent_Child_7_Gender= '' or (Dependent_Child_7_Gender!= '' and $Var_DependentChild7GenderCodesVM!= 'InvalidGender'))
and
(Dependent_Child_7_Last_Name='' or (Dependent_Child_7_Last_Name !='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_7_Last_Name,$varRegexLastName,'VALID')='VALID')))
and
(Dependent_Child_8_Date_of_Birth='' or (Dependent_Child_8_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_8_Date_of_Birth, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Dependent_Child_8_First_Name='' or (Dependent_Child_8_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_8_First_Name,$varRegexFirstName,'VALID')='VALID')))
and
(Dependent_Child_8_Gender= '' or (Dependent_Child_8_Gender!= '' and $Var_DependentChild8GenderCodesVM!= 'InvalidGender'))
and
(Dependent_Child_8_Last_Name='' or (Dependent_Child_8_Last_Name !='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_8_Last_Name,$varRegexLastName,'VALID')='VALID')))
and
(Dependent_Child_9_Date_of_Birth='' or (Dependent_Child_9_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_9_Date_of_Birth, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Dependent_Child_9_First_Name='' or (Dependent_Child_9_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_9_First_Name,$varRegexFirstName,'VALID')='VALID')))
and
(Dependent_Child_9_Gender= '' or (Dependent_Child_9_Gender!= '' and $Var_DependentChild9GenderCodesVM!= 'InvalidGender'))
and
(Dependent_Child_9_Last_Name='' or (Dependent_Child_9_Last_Name !='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_9_Last_Name,$varRegexLastName,'VALID')='VALID')))
and
(Dependent_Child_10_Date_of_Birth='' or (Dependent_Child_10_Date_of_Birth!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_10_Date_of_Birth, $var_DateFormat_REGEX,'VALID') = 'VALID')))
and
(Dependent_Child_10_First_Name='' or (Dependent_Child_10_First_Name!='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_10_First_Name,$varRegexFirstName,'VALID')='VALID')))
and
(Dependent_Child_10_Gender= '' or (Dependent_Child_10_Gender!= '' and $Var_DependentChild10GenderCodesVM!= 'InvalidGender'))
and
(Dependent_Child_10_Last_Name='' or (Dependent_Child_10_Last_Name !='' and (saxonJavaMapperUtilityClass:replaceAll(Dependent_Child_10_Last_Name,$varRegexLastName,'VALID')='VALID')))
and
(GAP_Class = '' or (GAP_Class != '' and (matches(GAP_Class, $varRegexClass))))
and
(GAP_Coverage_Termination_Date = '' or (GAP_Coverage_Termination_Date != '' and (matches(GAP_Coverage_Termination_Date, $var_DateFormat_REGEX))))
and
(GAP_Dependent_Tier = '' or (GAP_Dependent_Tier != '' and $var_GapDependentTierCodeVM != 'InvalidDependentTier'))
and
(GAP_Eligibility_Date_of_Coverage = '' or (GAP_Eligibility_Date_of_Coverage != '' and (matches(GAP_Eligibility_Date_of_Coverage, $var_DateFormat_REGEX))))
and
(GAP_Plan_Name ='' or (GAP_Plan_Name !='' and (matches (GAP_Plan_Name,$varGAPPlanName ))) )
and
(Full_Time_Part_Time_Status !='' and $Var_FullTimePartTimeVM != 'InvalidStatus')
and
(Other_AD_D_Prem_Post_Tax ='' or (Other_AD_D_Prem_Post_Tax !='' and (matches(Other_AD_D_Prem_Post_Tax, $varRegexTax))) )
and
(Other_AD_D_Prem_Pre_Tax ='' or (Other_AD_D_Prem_Pre_Tax !='' and (matches(Other_AD_D_Prem_Pre_Tax, $varRegexTax))) )
and
(Primary_AD_D_Prem_Post_Tax ='' or (Primary_AD_D_Prem_Post_Tax !='' and (matches(Primary_AD_D_Prem_Post_Tax, $varRegexTax))) )
and
(Primary_AD_D_Prem_Pre_Tax ='' or (Primary_AD_D_Prem_Pre_Tax !='' and (matches(Primary_AD_D_Prem_Pre_Tax, $varRegexTax))) )
and
(Spouse_AD_D_Prem_Post_Tax ='' or (Spouse_AD_D_Prem_Post_Tax !='' and (matches(Spouse_AD_D_Prem_Post_Tax, $varRegexTax))) )
and
(Spouse_AD_D_Prem_Pre_Tax ='' or(Spouse_AD_D_Prem_Pre_Tax !='' and (matches(Spouse_AD_D_Prem_Pre_Tax, $varRegexTax))) )
and
(Work_Site_Name = '' or matches(Work_Site_Name, $varRegexWorkSite) )
and
(Termination_Date = '' or matches(Termination_Date, '^(0?[1-9]|1[0-2])-/[-/]\d{4}$'))
and
(Scheduled_Hours_per_Week !='' and matches(Scheduled_Hours_per_Week ,$varRegexScheduledHrs))
and
(Scheduled_Days_per_Week='' or matches(Scheduled_Days_per_Week, $varRegexScheduledDays))
]

In the Validation Mapping, we are generating errors and warnings with the Error Records.

Error Condition

image-20240902-041519.png

Error Conditions

 Conditions (Expand to View)

IF CONDITION{name()='Employee_SSN' and $var_fetch_key_identifier = 'Employee SSN' and ../Employee_SSN = ''} VALUE=["Key Identifier is Employee SSN And Employee SSN is Missing|"]

IF CONDITION{name()='Employee_SSN' and $var_fetch_key_identifier = 'Employee SSN' and ../Employee_SSN != '' and ($varSSNValidation != 'VALID') } VALUE=[ 'Invalid SSN|']

IF CONDITION{name()='Emloyee_ID' and $var_fetch_key_identifier = 'Employee ID' and ../Emloyee_ID = ''} VALUE=["Key Identifier is Employee ID And Employee ID is Missing|"]

IF CONDITION{name()='Emloyee_ID' and $var_fetch_key_identifier = 'Employee ID' and ../Emloyee_ID != '' and (not(matches(Employee_ID,$varRegexCheckEmpID)))}
VALUE=["Emp ID is Invalid|" ]

IF CONDITION{name()='Employee_Title' and ../Employee_Title !='' and $Var_EmployeeTittleVM = 'InvalidTitle'} VALUE=["Invalid Employee Title|" ]

IF CONDITION{name()='Employee_First_Name' and ../Employee_First_Name = '' }
VALUE=["Missing Employee First Name|" ]
IF CONDITION{name()='Employee_First_Name' and ../Employee_First_Name !='' and not(matches(../Employee_First_Name,$varRegexFirstName)) }
VALUE=["Invalid Employee First Name|" ]

IF CONDITION{name()='Employee_Middle_Name' and ../Employee_Middle_Name != '' and not(matches(../Employee_Middle_Name,$varRegexMiddleName)) }
VALUE=["Invalid Employee Middle Name|" ]

IF CONDITION{name()='Employee_Last_Name' and ../Employee_Last_Name = '' }
VALUE=["Missing Employee Last Name|" ]
IF CONDITION{name()='Employee_Last_Name' and ../Employee_Last_Name != '' and not(matches(../Employee_Last_Name,$varRegexLastName)) }
VALUE=["Invalid Employee Last Name|" ]

IF CONDITION{name()='Employee_Gender' and ../Employee_Gender = ''} VALUE=[ 'Missing Employee Gender|']
IF CONDITION{name()='Employee_Gender' and ../Employee_Gender !='' and $Var_GenderCodesVM = 'InvalidGender'} VALUE=["Invalid Employee Gender|" ]

IF CONDITION{name()='Employee_Date_of_Birth' and ../Employee_Date_of_Birth = ''} VALUE=[ 'Missing Employee Date of Birth|']

IF CONDITION{name()='Employee_Date_of_Birth' and ../Employee_Date_of_Birth!='' and not(matches(../Employee_Date_of_Birth, $var_DateFormat_REGEX) )
} VALUE=['Invalid Employee Date Of Birth format|' ]

IF CONDITION{name()='Marital_Status' and ../Marital_Status != '' and $var_MaritialStatusVM = 'InvalidMaritalStatus'} VALUE=["Invalid Maritial Status|" ]

IF CONDITION{name()='Employee_Home_Address_Line_1' and ../Employee_Home_Address_Line_1 = '' }
VALUE=["Missing Employee Home Address Line 1|" ]
IF CONDITION{name()='Employee_Home_Address_Line_1' and ../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{name()='Employee_Home_Address_Line_1' and ../Employee_Home_Address_Line_1 = '' and ../Employee_Home_Address_Line_2 != ''} VALUE = ["Home Address Line 2 is present but missing Home Address Line 1"]

IF CONDITION{name()='Employee_Home_Address_Line_1' and ../Employee_Home_Address_Line_1 = '' and ../Employee_Home_Address_Line_2 = '' and ../Employee_Home_Address_Line_3 != ''} VALUE = ["Home Address Line 3 is present but missing Home Address Line 1 and Home Address Line 2"]

IF CONDITION{name()='Employee_Home_Address_Line_2' and ../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{name()='Employee_Home_Address_Line_3' and ../Employee_Home_Address_Line_3 != '' and not(matches(../Employee_Home_Address_Line_3,$varRegexAddress3)) }
VALUE=["Employee Home Address Line 3 has invalid Characters or length|" ]

IF CONDITION{name()='Employee_Home_City' and ../Employee_Home_City = ''}
VALUE=["Missing Employee Home City|" ]
IF CONDITION{name()='Employee_Home_City' and ../Employee_Home_City != '' and not(matches( ../Employee_Home_City, $varRegexHomeCity) ) }
VALUE=[ "Invalid Employee Home City|"]
IF CONDITION{name()='Employee_Home_State' and ../Employee_Home_State != '' and $Var_EmployeeHomeStateVM = 'NonState' }
VALUE=[ "Invalid Employee Home State|"]

IF CONDITION{name()='Employee_Home_State' and ../Employee_Home_State = '' }
VALUE=[ "Missing Employee Home State|"]

IF CONDITION{name()='Employee_Home_Zip_Code' and ../Employee_Home_Zip_Code = '' }
VALUE=["Missing Employee Zip Code|" ]
IF CONDITION{name()='Employee_Home_Zip_Code' and ../Employee_Home_Zip_Code != '' and not(matches(../Employee_Home_Zip_Code, $varRegexZipCode)) }
VALUE=["Invalid Employee Zip Code|" ]

IF CONDITION{name()='Employee_County' and ../Employee_County !='' and not(matches(../Employee_Country,$VarCounty)) } VALUE=["Invalid Employee County|" ]

IF CONDITION{name()='Employee_County' and ../Employee_Country != '' and $Var_EmployeeCountryCodesVM = 'InvalidCountry'}
VALUE=[ "Invalid Employee Country|"]

IF CONDITION{name()='Employee_Home_Address_Region' and (../Employee_Home_Address_Region !='') and (not(matches (../Employee_Home_Address_Region,$varRegexAddressRegion))) }
VALUE=["Invalid Employee Home Address Region|" ]

IF CONDITION{name()='Employee_Home_Phone_Number' and (../Employee_Home_Phone_Number !='') and (not(matches (../Employee_Home_Phone_Number,$varNumberMobilePhone ))) }
VALUE=["Invalid Employee Home Phone number|" ]

IF CONDITION{name()='Employee_Mobile_Phone_Number' and (../Employee_Mobile_Phone_Number !='') and (not(matches (../Employee_Mobile_Phone_Number,$varNumberMobilePhone ))) }
VALUE=["Invalid Employee Mobile Phone number|" ]

IF CONDITION{name()='Employee_Job_Title' and ../Employee_Job_Title !='' and not(matches(../Employee_Job_Title, $varRegexEmployeeJobTitle)) } VALUE=["Invalid Employee Job Title"]

IF CONDITION{name()='Employee_Original_Date_of_Hire' and ../Employee_Original_Date_of_Hire !='' and not(../matches(Employee_Original_Date_of_Hire, $var_DateFormat_REGEX)) } VALUE=["Invalid Employee Original Date of Hire"]

IF CONDITION{name()='Employee_Most_Recent_Date_of_Hire' and ../Employee_Most_Recent_Date_of_Hire !='' and not(matches(../Employee_Most_Recent_Date_of_Hire, $var_DateFormat_REGEX)) } VALUE=["Invalid Employee Most Recent Date of Hire"]

IF CONDITION{name()='Employee_Adjusted_Date_of_Hire' and ../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{name()='Employee_Work_State' and ../Employee_Work_State !='' and $Var_EmployeeWorkStateVM = 'InvalidWorkState'} VALUE=["Invalid Employee Work State"]

IF CONDITION{name()='Employment_Status' and ../Employment_Status =''} VALUE=["Missing Employment Status"]
IF CONDITION{name()='Employment_Status' and ../Employment_Status !='' and $Var_EmploymentStatusVM = 'InvalidEmploymentStatus'} VALUE=["Invalid Employment Status"]

IF CONDITION{name()='Termination_Date' and ../Termination_Date !='' and not(matches(../Termination_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid Termination Date"]

IF CONDITION{name()='Employment_Type' and ../Employment_Type !='' and $Var_EmploymentTypeVM = 'InvalidEmploymentType'} VALUE=["Invalid Employment Type"]

IF CONDITION{name()='Full_Time_Part_Time_Status' and ../Full_Time_Part_Time_Status =''} VALUE=["Missing Full Time Part Time Status"]

IF CONDITION{name()='Full_Time_Part_Time_Status' and ../Full_Time_Part_Time_Status !='' and $Var_FullTimePartTimeVM = 'InvalidStatus' } VALUE=["Invalid Full Time Part Time Status"]

IF CONDITION{name()='Employee_Email_Address' and ../Employee_Email_Address !='' and not(matches(../Employee_Email_Address, $varRegexEmail)) } VALUE=["Invalid Employee Email Address"]

IF CONDITION{name()='Work_Email_Address' and ../Work_Email_Address !='' and not(matches(../Work_Email_Address, $varRegexEmail)) } VALUE=["Invalid Work Email Address"]

IF CONDITION{name()='Work_Mobile_Phone_Number' and ../Work_Mobile_Phone_Number !='' and not(matches(../Work_Mobile_Phone_Number, $varNumberMobilePhone)) } VALUE=["Invalid Work Mobile Phone Number"]

IF CONDITION{name()='Business_Unit' and ../Business_Unit !='' and not(matches(../Business_Unit, $varRegexBusinessUnit)) } VALUE=["Invalid Business Unit"]

IF CONDITION{name()='Division' and ../Division !='' and not(matches(../Division, $varRegexBusinessUnit))} VALUE=["Invalid Division"]

IF CONDITION{name()='Exempt_Status' and ../Exempt_Status !='' and $Var_ExemptionTypeVM = 'InvalidExemptionType'} VALUE=["Invalid Exempt Status"]

IF CONDITION{name()='Compensation_Method' and ../Compensation_Method !='' and $Var_CompensationMethodVM ='InvalidCompensationMethod'} VALUE=["Invalid Compensation Method"]

IF CONDITION{name()='Employee_Earnings' and ../Employee_Earnings !='' and not(matches(../Employee_Earnings, $varRegexEmployeeEarning))} VALUE=["Invalid Employee Earnings"]

IF CONDITION{name()='Earnings_Frequency' and ../Earnings_Frequency !='' and $var_EmployeeFrequencyVM = 'InvalidEarningsFrequency'} VALUE=["Invalid Earnings Frequency"]

IF CONDITION{name()='Earnings_Effective_Date' and ../Earnings_Effective_Date !='' and not(matches(../Earnings_Effective_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid Earnings Effective Date"]

IF CONDITION{name()='Group_Type' and ../Group_Type !='' and not(matches(../Group_Type, $varRegexGroupType)) } VALUE=["Invalid Group Type"]

IF CONDITION{name()='Primary_Phone_Type' and ../Primary_Phone_Type !='' and $Var_PhoneTypeVM = 'InvalidPhoneType' } VALUE=["Invalid Primary Phone Type"]

IF CONDITION{name()='Scheduled_Days_per_Week' and ../Scheduled_Days_per_Week !='' and not(matches(../Scheduled_Days_per_Week, $varRegexScheduledDays)) } VALUE=["Invalid Scheduled Days per Week"]

IF CONDITION{name()='Scheduled_Hours_per_Week' and ../Scheduled_Hours_per_Week =''} VALUE=["Missing Scheduled Hours per Week"]

IF CONDITION{name()='Scheduled_Hours_per_Week' and ../Scheduled_Hours_per_Week !='' and not(matches(../Scheduled_Hours_per_Week, $varRegexScheduledDays)) } VALUE=["Invalid Scheduled Hours per Week"]

IF CONDITION{name()='Union_Name' and ../Union_Name !='' and not(matches(../Union_Name, $VarRegexUnionName)) } VALUE=["Invalid Union Name"]

IF CONDITION{name()='Union_Type' and ../Union_Type !='' and $Var_UnionTypeVM = 'InvalidUnionType' } VALUE=["Invalid Union Type"]

IF CONDITION{name()='Field_50_In_75_Rule_Indicator' and ../Field_50_In_75_Rule_Indicator !='' and not(matches(../Field_50_In_75_Rule_Indicator, $varRegexIndicator)) } VALUE=["Invalid Field 50 In 75 Rule Indicator"]

IF CONDITION{name()='Work_At_Home_Indicator' and ../Work_At_Home_Indicator !='' and not(matches(../Work_At_Home_Indicator, $varRegexIndicator)) } VALUE=["Invalid Work At Home Indicator"]

IF CONDITION{name()='Employment_Class' and ../Employment_Class !='' and $Var_EmploymentClass ='InvalidEmploymentClass'} VALUE=["Invalid Employment Class"]

IF CONDITION{name()='Employment_Strength' and ../Employment_Strength !='' and $Var_EmploymentStrengthsVM = 'InvalidEmployeeStrength'} VALUE=["Invalid Employment Strength"]

IF CONDITION{name()='Hours_Worked_Previous_12_Months' and ../Hours_Worked_Previous_12_Months !='' and not(matches(../Hours_Worked_Previous_12_Months, $varRegexHoursWorked))} VALUE=["Invalid Hours Worked Previous 12 Months"]

IF CONDITION{name()='Weeks_Worked_Previous_12_Months' and ../Weeks_Worked_Previous_12_Months !='' and not(../matches(Weeks_Worked_Previous_12_Months, $varRegexHoursWorked)) } VALUE=["Invalid Weeks Worked Previous 12 Months"]

IF CONDITION{name()='Key_Employee_Indicator' and ../Key_Employee_Indicator !='' and not(matches(../Key_Employee_Indicator, $varRegexIndicator)) } VALUE=["Invalid Key Employee Indicator"]

IF CONDITION{name()='Supervisor_Employee_ID' and../Supervisor_Employee_ID !='' and not(matches(../Supervisor_Employee_ID, $varRegexSupervisorEID)) } VALUE=["Invalid Supervisor Employee ID"]

IF CONDITION{name()='Supervisor_First_Name' and ../Supervisor_First_Name !='' and not(matches(../Supervisor_First_Name, $varRegexFirstName)) } VALUE=["Invalid Supervisor First Name"]

IF CONDITION{name()='Supervisor_Last_Name' and ../Supervisor_Last_Name !='' and not(matches(../Supervisor_Last_Name, $varRegexLastName)) } VALUE=["Invalid Supervisor Last Name"]

IF CONDITION{name()='STD_Class' and ../STD_Class !='' and not(matches(../STD_Class, $varRegexClass)) } VALUE=["Invalid STD Class"]

IF CONDITION{name()='STD_Election' and ../STD_Election !='' and $Var_STD_ElectionVM = 'InvalidBenefitElectionType'} VALUE=["Invalid STD Election"]

IF CONDITION{name()='STD_Eligibility_Date' and ../STD_Eligibility_Date !='' and not(matches(../STD_Eligibility_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid STD Eligibility Date"]

IF CONDITION{name()='STD_Weekly_Earnings' and ../STD_Weekly_Earnings !='' and not(matches(../STD_Weekly_Earnings, $varRegexEmployeeEarning)) } VALUE=["Invalid STD Weekly Earnings"]

IF CONDITION{name()='STD_Earnings_Amount' and ../STD_Earnings_Amount !='' and not(matches(../STD_Earnings_Amount, $varRegexEmployeeEarning)) } VALUE=["Invalid STD Earnings Amount"]

IF CONDITION{name()='STD_Earnings_Effective_Date' and ../STD_Earnings_Effective_Date !='' and not(matches(../STD_Earnings_Effective_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid STD Earnings Effective Date"]

IF CONDITION{name()='STD_Earnings_Frequency' and ../STD_Earnings_Frequency !='' and $var_STDFreqVM = 'InvalidEarningsFrequency'} VALUE=["Invalid STD Earnings Frequency"]

IF CONDITION{name()='STD_Benefit_Amount' and ../STD_Benefit_Amount !='' and not(matches(../STD_Benefit_Amount, $varRegexBenefitAmount)) } VALUE=["Invalid STD Benefit Amount"]

IF CONDITION{name()='STD_Coverage_Termination_Date' and ../STD_Coverage_Termination_Date !='' and not(matches(../STD_Coverage_Termination_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid STD Coverage Termination Date"]

IF CONDITION{name()='Statutory_Disability_Type' and ../Statutory_Disability_Type !='' and $Var_StatutoryDisabilityTypeVM = 'InvalidStatutoryDisabilityType'} VALUE=["Invalid Statutory Disability Type"]

IF CONDITION{name()='LTD_Class' and ../LTD_Class !='' and not(matches(../LTD_Class, $varRegexClass)) } VALUE=["Invalid LTD Class"]

IF CONDITION{name()='LTD_Election' and ../LTD_Election !='' and $Var_LTD_ElectionVM = 'InvalidBenefitElectionType'} VALUE=["Invalid LTD Election"]

IF CONDITION{name()='LTD_Eligibility_Date' and ../LTD_Eligibility_Date !='' and not(matches(../LTD_Eligibility_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid LTD Eligibility Date"]

IF CONDITION{name()='LTD_Monthly_Earnings' and ../LTD_Monthly_Earnings !='' and not(matches(../LTD_Monthly_Earnings, $varRegexEmployeeEarning)) } VALUE=["Invalid LTD Monthly Earnings"]

IF CONDITION{name()='LTD_Coverage_Termination_Date' and ../LTD_Coverage_Termination_Date !='' and not(matches(../LTD_Coverage_Termination_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid LTD Coverage Termination Date"]

IF CONDITION{name()='LTD_Benefit_Amount' and ../LTD_Benefit_Amount !='' and not(matches(../LTD_Benefit_Amount, $varRegexBenefitAmount)) } VALUE=["Invalid LTD Benefit Amount"]

IF CONDITION{name()='Occupation_Qualifier1' and ../Occupation_Qualifier1 !='' and not(matches(../Occupation_Qualifier1, $varRegexOccupQual)) } VALUE=["Invalid Occupation Qualifier1"]

IF CONDITION{name()='Occupation_Qualifier2' and ../Occupation_Qualifier2 !='' and not(matches(../Occupation_Qualifier2, $varRegexOccupQual)) } VALUE=["Invalid Occupation Qualifier2"]

IF CONDITION{name()='Occupation_Qualifier3' and ../Occupation_Qualifier3 !='' and not(matches(../Occupation_Qualifier3, $varRegexOccupQual)) } VALUE=["Invalid Occupation Qualifier3"]

IF CONDITION{name()='Occupation_Qualifier4' and ../Occupation_Qualifier4 !='' and not(matches(../Occupation_Qualifier4, $varRegexOccupQual)) } VALUE=["Invalid Occupation Qualifier4"]

IF CONDITION{name()='Occupation_Qualifier5' and ../Occupation_Qualifier5 !='' and not(matches(../Occupation_Qualifier5, $varRegexOccupQual)) } VALUE=["Invalid Occupation Qualifier5"]

IF CONDITION{name()='Occupation_Qualifier6' and ../Occupation_Qualifier6 !='' and not(matches(../Occupation_Qualifier6, $varRegexOccupQual)) } VALUE=["Invalid Occupation Qualifier6"]

IF CONDITION{name()='Occupation_Qualifier7' and ../Occupation_Qualifier7 !='' and not(matches(../Occupation_Qualifier7, $varRegexOccupQual)) } VALUE=["Invalid Occupation Qualifier7"]

IF CONDITION{name()='Occupation_Qualifier8' and ../Occupation_Qualifier8 !='' and not(matches(../Occupation_Qualifier8, $varRegexOccupQual)) } VALUE=["Invalid Occupation Qualifier8"]

IF CONDITION{name()='Occupation_Qualifier9' and ../Occupation_Qualifier9 !='' and not(matches(../Occupation_Qualifier9, $varRegexOccupQual)) } VALUE=["Invalid Occupation Qualifier9"]

IF CONDITION{name()='Occupation_Qualifier10' and ../Occupation_Qualifier10 !='' and not(matches(../Occupation_Qualifier10, $varRegexOccupQual)) } VALUE=["Invalid Occupation Qualifier10"]

IF CONDITION{name()='ER_Contact_1' and ../ER_Contact_1 !='' and not(matches(../ER_Contact_1, $varRegexEmployerContact)) } VALUE=["Invalid ER Contact 1"]

IF CONDITION{name()='ER_Contact_2' and ../ER_Contact_2 !='' and not(matches(../ER_Contact_2, $varRegexEmployerContact)) } VALUE=["Invalid ER Contact 2"]

IF CONDITION{name()='ER_Contact_3' and ../ER_Contact_3 !='' and not(matches(../ER_Contact_3, $varRegexEmployerContact)) } VALUE=["Invalid ER Contact 3"]

IF CONDITION{name()='ER_Contact_4' and ../ER_Contact_4 !='' and not(matches(../ER_Contact_4, $varRegexEmployerContact)) } VALUE=["Invalid ER Contact 4"]

IF CONDITION{name()='ER_Contact_5' and ../ER_Contact_5 !='' and not(matches(../ER_Contact_5, $varRegexEmployerContact)) } VALUE=["Invalid ER Contact 5"]

IF CONDITION{name()='ER_Contact_6' and ../ER_Contact_6 !='' and not(matches(../ER_Contact_6, $varRegexEmployerContact)) } VALUE=["Invalid ER Contact 6"]

IF CONDITION{name()='ER_Contact_7' and ../ER_Contact_7 !='' and not(matches(../ER_Contact_7, $varRegexEmployerContact)) } VALUE=["Invalid ER Contact 7"]

IF CONDITION{name()='ER_Contact_8' and ../ER_Contact_8 !='' and not(matches(../ER_Contact_8, $varRegexEmployerContact)) } VALUE=["Invalid ER Contact 8"]

IF CONDITION{name()='ER_Contact_9' and ../ER_Contact_9 !='' and not(matches(../ER_Contact_9, $varRegexEmployerContact)) } VALUE=["Invalid ER Contact 9"]

IF CONDITION{name()='ER_Contact_10' and ../ER_Contact_10 !='' and not(matches(../ER_Contact_10, $varRegexEmployerContact)) } VALUE=["Invalid ER Contact 10"]

IF CONDITION{name()='Reporting_Field1' and ../Reporting_Field1 !='' and not(matches(../Reporting_Field1, $varRegexReportingField)) } VALUE=["Invalid Reporting Field1"]

IF CONDITION{name()='Reporting_Field2' and ../Reporting_Field2 !='' and not(matches(../Reporting_Field2, $varRegexReportingField)) } VALUE=["Invalid Reporting Field2"]

IF CONDITION{name()='Reporting_Field3' and ../Reporting_Field3 !='' and not(matches(../Reporting_Field3, $varRegexReportingField)) } VALUE=["Invalid Reporting Field3"]

IF CONDITION{name()='Reporting_Field4' and ../Reporting_Field4 !='' and not(matches(../Reporting_Field4, $varRegexReportingField)) } VALUE=["Invalid Reporting Field4"]

IF CONDITION{name()='Reporting_Field5' and ../Reporting_Field5 !='' and not(matches(../Reporting_Field5, varRegexReportingField)) } VALUE=["Invalid Reporting Field5"]

IF CONDITION{name()='Spouse_Date_of_Birth' and ../Spouse_Date_of_Birth !='' and not(matches(../Spouse_Date_of_Birth, $var_DateFormat_REGEX)) } VALUE=["Invalid Spouse Date of Birth"]

IF CONDITION{name()='Spouse_Date_of_Change' and ../Spouse_Date_of_Change !='' and not(matches(../Spouse_Date_of_Change, $var_DateFormat_REGEX)) } VALUE=["Invalid Spouse Date of Change"]

IF CONDITION{name()='Spouse_Employee_ID' and ../Spouse_Employee_ID !='' and not(matches(../Spouse_Employee_ID, $VarRegexSpouseEMPID)) } VALUE=["Invalid Spouse Employee ID"]

IF CONDITION{name()='Spouse_SSN' and ../Spouse_SSN !='' and not(matches(../Spouse_SSN, $VarRegexSpouseSSN)) } VALUE=["Invalid Spouse SSN"]

IF CONDITION{name()='Spouse_First_Name' and ../Spouse_First_Name !='' and not(matches(../Spouse_First_Name, $varRegexFirstName)) } VALUE=["Invalid Spouse First Name"]

IF CONDITION{name()='Spouse_Last_Name' and ../Spouse_Last_Name !='' and not(matches(../Spouse_Last_Name, $varRegexLastName)) } VALUE=["Invalid Spouse Last Name"]

IF CONDITION{name()='Spouse_Reason_of_Change' and ../Spouse_Reason_of_Change !='' and $Var_SpouseROC = 'InvalidSpouseROC'} VALUE=["Invalid Spouse Reason of Change"]

IF CONDITION{name()='Policy_Number' and ../Policy_Number !='' and not(matches(../Policy_Number, $VarRegexPolicyNumber)) } VALUE=["Invalid Policy Number"]

IF CONDITION{name()='Dep_Dental_Prem_Post_Tax' and ../Dep_Dental_Prem_Post_Tax !='' and not(matches(../Dep_Dental_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Dep Dental Prem Post Tax"]

IF CONDITION{name()='Dep_Dental_Prem_Pre_Tax' and ../Dep_Dental_Prem_Pre_Tax !='' and not(matches(../Dep_Dental_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Dep Dental Prem Pre Tax"]

IF CONDITION{name()='Dep_Life_Ins_Prem_Post_Tax' and ../Dep_Life_Ins_Prem_Post_Tax !='' and not(matches(../Dep_Life_Ins_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Dep Life Ins Prem Post Tax"]

IF CONDITION{name()='Dep_Life_Ins_Prem_Pre_Tax' and ../Dep_Life_Ins_Prem_Pre_Tax !='' and not(matches(../Dep_Life_Ins_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Dep Life Ins Prem Pre Tax"]

IF CONDITION{name()='Dep_Med_Prem_Post_Tax' and ../Dep_Med_Prem_Post_Tax !='' and not(matches(../Dep_Med_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Dep Med Prem Post Tax"]

IF CONDITION{name()='Dep_Med_Prem_Pre_Tax' and ../Dep_Med_Prem_Pre_Tax !='' and not(matches(../Dep_Med_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Dep Med Prem Pre Tax"]

IF CONDITION{name()='Hospital_Indemnity_Prem_Post_Tax' and ../Hospital_Indemnity_Prem_Post_Tax !='' and not(matches(../Hospital_Indemnity_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Hospital Indemnity Prem Post Tax"]

IF CONDITION{name()='Hospital_Indemnity_Prem_Pre_Tax' and ../Hospital_Indemnity_Prem_Pre_Tax !='' and not(matches(../Hospital_Indemnity_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Hospital Indemnity Prem Pre Tax"]

IF CONDITION{name()='Long_Term_Care_Prem_Post_Tax' and ../Long_Term_Care_Prem_Post_Tax !='' and not(matches(../Long_Term_Care_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Long Term Care Prem Post Tax"]

IF CONDITION{name()='Long_Term_Care_Prem_Pre_Tax' and ../Long_Term_Care_Prem_Pre_Tax !='' and not(matches(../Long_Term_Care_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Long Term Care Prem Pre Tax"]

IF CONDITION{name()='LTD_Prem_Post_Tax' and ../LTD_Prem_Post_Tax !='' and not(matches(../LTD_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid LTD Prem Post Tax"]

IF CONDITION{name()='LTD_Prem_Pre_Tax' and ../LTD_Prem_Pre_Tax !='' and not(matches(../LTD_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid LTD Prem Pre Tax"]

IF CONDITION{name()='Misc_1_Prem_Post_Tax' and ../Misc_1_Prem_Post_Tax !='' and not(matches(../Misc_1_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Misc 1 Prem Post Tax"]

IF CONDITION{name()='Misc_1_Prem_Pre_Tax' and ../Misc_1_Prem_Pre_Tax !='' and not(matches(../Misc_1_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Misc 1 Prem Pre Tax"]

IF CONDITION{name()='Misc_2_Prem_Post_Tax' and ../Misc_2_Prem_Post_Tax !='' and not(matches(../Misc_2_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Misc 2 Prem Post Tax"]

IF CONDITION{name()='Misc_2_Prem_Pre_Tax' and ../Misc_2_Prem_Pre_Tax !='' and not(matches(../Misc_2_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Misc 2 Prem Pre Tax"]

IF CONDITION{name()='Misc_3_Prem_Post_Tax' and ../Misc_3_Prem_Post_Tax !='' and not(matches(../Misc_3_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Misc 3 Prem Post Tax"]

IF CONDITION{name()='Misc_3_Prem_Pre_Tax' and ../Misc_3_Prem_Pre_Tax !='' and not(matches(../Misc_3_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Misc 3 Prem Pre Tax"]

IF CONDITION{name()='Other_AD_D_Prem_Post_Tax' and ../Other_AD_D_Prem_Post_Tax !='' and not(matches(../Other_AD_D_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Other AD D Prem Post Tax"]

IF CONDITION{name()='Other_AD_D_Prem_Pre_Tax' and ../Other_AD_D_Prem_Pre_Tax !='' and not(matches(../Other_AD_D_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Other AD D Prem Pre Tax"]

IF CONDITION{name()='Other_Dental_Prem_Post_Tax' and ../Other_Dental_Prem_Post_Tax !='' and not(matches(../Other_Dental_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Other Dental Prem Post Tax"]

IF CONDITION{name()='Other_Dental_Prem_Pre_Tax' and ../Other_Dental_Prem_Pre_Tax !='' and not(matches(../Other_Dental_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Other Dental Prem Pre Tax"]

IF CONDITION{name()='Other_Life_Ins_Prem_Post_Tax' and ../Other_Life_Ins_Prem_Post_Tax !='' and not(matches(../Other_Life_Ins_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Other Life Ins Prem Post Tax"]

IF CONDITION{name()='Other_Life_Ins_Prem_Pre_Tax' and ../Other_Life_Ins_Prem_Pre_Tax !='' and not(matches(../Other_Life_Ins_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Other Life Ins Prem Pre Tax"]

IF CONDITION{name()='Other_Med_Prem_Post_Tax' and ../Other_Med_Prem_Post_Tax !='' and not(matches(../Other_Med_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Other Med Prem Post Tax"]

IF CONDITION{name()='Other_Med_Prem_Pre_Tax' and ../Other_Med_Prem_Pre_Tax !='' and not(matches(../Other_Med_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Other Med Prem Pre Tax"]

IF CONDITION{name()='Other_Vision_Prem_Post_Tax' and ../Other_Vision_Prem_Post_Tax !='' and not(matches(../Other_Vision_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Other Vision Prem Post Tax"]

IF CONDITION{name()='Other_Vision_Prem_Pre_Tax' and ../Other_Vision_Prem_Pre_Tax !='' and not(matches(../Other_Vision_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Other Vision Prem Pre Tax"]

IF CONDITION{name()='Personal_Accident_Ins_Prem_Post_Tax' and ../Personal_Accident_Ins_Prem_Post_Tax !='' and not(matches(../Personal_Accident_Ins_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Personal Accident Ins Prem Post Tax"]

IF CONDITION{name()='Personal_Accident_Ins_Prem_Pre_Tax' and ../Personal_Accident_Ins_Prem_Pre_Tax !='' and not(matches(../Personal_Accident_Ins_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Personal Accident Ins Prem Pre Tax"]

IF CONDITION{name()='Primary_AD_D_Prem_Post_Tax' and ../Primary_AD_D_Prem_Post_Tax !='' and not(matches(../Primary_AD_D_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Primary AD D Prem Post Tax"]

IF CONDITION{name()='Primary_AD_D_Prem_Pre_Tax' and ../Primary_AD_D_Prem_Pre_Tax !='' and not(matches(../Primary_AD_D_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Primary AD D Prem Pre Tax"]

IF CONDITION{name()='Primary_Cancer_Prem_Post_Tax' and ../Primary_Cancer_Prem_Post_Tax !='' and not(matches(../Primary_Cancer_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Primary Cancer Prem Post Tax"]

IF CONDITION{name()='Primary_Cancer_Prem_Pre_Tax' and ../Primary_Cancer_Prem_Pre_Tax !='' and not(matches(../Primary_Cancer_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Primary Cancer Prem Pre Tax"]

IF CONDITION{name()='Primary_Critical_Illness_Prem_Post_Tax' and ../Primary_Critical_Illness_Prem_Post_Tax !='' and not(matches(../Primary_Critical_Illness_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Primary Critical Illness Prem Post Tax"]

IF CONDITION{name()='Primary_Critical_Illness_Prem_Pre_Tax' and ../Primary_Critical_Illness_Prem_Pre_Tax !='' and not(matches(../Primary_Critical_Illness_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Primary Critical Illness Prem Pre Tax"]

IF CONDITION{name()='Primary_Dental_Prem_Post_Tax' and ../Primary_Dental_Prem_Post_Tax !='' and not(matches(../Primary_Dental_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Primary Dental Prem Post Tax"]

IF CONDITION{name()='Primary_Dental_Prem_Pre_Tax' and ../Primary_Dental_Prem_Pre_Tax !='' and not(matches(../Primary_Dental_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Primary Dental Prem Pre Tax"]

IF CONDITION{name()='Primary_Life_Ins_Prem_Post_Tax' and ../Primary_Life_Ins_Prem_Post_Tax !='' and not(matches(../Primary_Life_Ins_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Primary Life Ins Prem Post Tax"]

IF CONDITION{name()='Primary_Life_Ins_Prem_Pre_Tax' and ../Primary_Life_Ins_Prem_Pre_Tax !='' and not(matches(../Primary_Life_Ins_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Primary Life Ins Prem Pre Tax"]

IF CONDITION{name()='Primary_Med_Prem_Post_Tax' and ../Primary_Med_Prem_Post_Tax !='' and not(matches(../Primary_Med_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Primary Med Prem Post Tax"]

IF CONDITION{name()='Primary_Med_Prem_Pre_Tax' and ../Primary_Med_Prem_Pre_Tax !='' and not(matches(../Primary_Med_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Primary Med Prem Pre Tax"]

IF CONDITION{name()='Primary_Vision_Prem_Post_Tax' and ../Primary_Vision_Prem_Post_Tax !='' and not(matches(../Primary_Vision_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Primary Vision Prem Post Tax"]

IF CONDITION{name()='Primary_Vision_Prem_Pre_Tax' and ../Primary_Vision_Prem_Pre_Tax !='' and not(matches(../Primary_Vision_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Primary Vision Prem Pre Tax"]

IF CONDITION{name()='Spouse_AD_D_Prem_Post_Tax' and ../Spouse_AD_D_Prem_Post_Tax !='' and not(matches(../Spouse_AD_D_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Spouse AD D Prem Post Tax"]

IF CONDITION{name()='Spouse_AD_D_Prem_Pre_Tax' and ../Spouse_AD_D_Prem_Pre_Tax !='' and not(matches(../Spouse_AD_D_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Spouse AD D Prem Pre Tax"]

IF CONDITION{name()='Spouse_Cancer_Prem_Post_Tax' and ../Spouse_Cancer_Prem_Post_Tax !='' and not(matches(../Spouse_Cancer_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Spouse Cancer Prem Post Tax"]

IF CONDITION{name()='Spouse_Cancer_Prem_Pre_Tax' and ../Spouse_Cancer_Prem_Pre_Tax !='' and not(matches(../Spouse_Cancer_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Spouse Cancer Prem Pre Tax"]

IF CONDITION{name()='Spouse_Critical_Illness_Prem_Post_Tax' and ../Spouse_Critical_Illness_Prem_Post_Tax !='' and not(matches(../Spouse_Critical_Illness_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Spouse Critical Illness Prem Post Tax"]

IF CONDITION{name()='Spouse_Critical_Illness_Prem_Pre_Tax' and ../Spouse_Critical_Illness_Prem_Pre_Tax !='' and not(matches(../Spouse_Critical_Illness_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Spouse Critical Illness Prem Pre Tax"]

IF CONDITION{name()='Spouse_Life_Ins_Prem_Post_Tax' and ../Spouse_Life_Ins_Prem_Post_Tax !='' and not(matches(../Spouse_Life_Ins_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid Spouse Life Ins Prem Post Tax"]

IF CONDITION{name()='Spouse_Life_Ins_Prem_Pre_Tax' and ../Spouse_Life_Ins_Prem_Pre_Tax !='' and not(matches(../Spouse_Life_Ins_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid Spouse Life Ins Prem Pre Tax"]

IF CONDITION{name()='STD_Prem_Post_Tax' and ../STD_Prem_Post_Tax !='' and not(matches(../STD_Prem_Post_Tax, $varRegexTax)) } VALUE=["Invalid STD Prem Post Tax"]

IF CONDITION{name()='STD_Prem_Pre_Tax' and ../STD_Prem_Pre_Tax !='' and not(matches(../STD_Prem_Pre_Tax, $varRegexTax)) } VALUE=["Invalid STD Prem Pre Tax"]

IF CONDITION{name()='Accident_Choice' and ../Accident_Choice !='' and not(matches(../Accident_Choice, $varRegexOccupQual)) } VALUE=["Invalid Accident Choice"]

IF CONDITION{name()='Accident_Class' and ../Accident_Class !='' and not(matches(../Accident_Class, $varRegexClass)) } VALUE=["Invalid Accident Class"]

IF CONDITION{name()='Accident_Eligibility_Date' and ../Accident_Eligibility_Date !='' and not(matches(../Accident_Eligibility_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid Accident Eligibility Date"]

IF CONDITION{name()='Accident_Coverage_Termination_Date' and ../Accident_Coverage_Termination_Date !='' and not(matches(../Accident_Coverage_Termination_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid Accident Coverage Termination Date"]

IF CONDITION{name()='Accident_Dependent_Tier' and ../Accident_Dependent_Tier !='' and $var_AccidentDependentTierVM = 'InvalidDependentTierCodes'} VALUE=["Invalid Accident Dependent Tier"]

IF CONDITION{name()='Employee_Critical_Illness_Coverage_Termination_Date' and ../Employee_Critical_Illness_Coverage_Termination_Date !='' and not(matches(../Employee_Critical_Illness_Coverage_Termination_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid Employee Critical Illness Coverage Termination Date"]

IF CONDITION{name()='Employee_Critical_Illness_Eligibility_Date' and ../Employee_Critical_Illness_Eligibility_Date !='' and not(matches(../Employee_Critical_Illness_Eligibility_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid Employee Critical Illness Eligibility Date"]

IF CONDITION{name()='Employee_Critical_Illness_Requested_Amount' and ../Employee_Critical_Illness_Requested_Amount !='' and not(matches(../Employee_Critical_Illness_Requested_Amount, $varRegexBenefitAmount)) } VALUE=["Invalid Employee Critical Illness Requested Amount"]
IF CONDITION{name()='Critical_Illness_Choice' and ../Critical_Illness_Choice !='' and not(matches(../Critical_Illness_Choice, $varRegexOccupQual)) } VALUE=["Invalid Critical Illness Choice"]

IF CONDITION{name()='Critical_Illness_Class' and ../Critical_Illness_Class !='' and not(matches(../Critical_Illness_Class, $varRegexClass)) } VALUE=["Invalid Critical Illness Class"]

IF CONDITION{name()='Spouse_Critical_Illness_Coverage_Termination_Date' and ../Spouse_Critical_Illness_Coverage_Termination_Date !='' and not(matches(../Spouse_Critical_Illness_Coverage_Termination_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid Spouse Critical Illness Coverage Termination Date"]

IF CONDITION{name()='Spouse_Critical_Illness_Eligibility_Date' and ../Spouse_Critical_Illness_Eligibility_Date !='' and not(matches(../Spouse_Critical_Illness_Eligibility_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid Spouse Critical Illness Eligibility Date"]

IF CONDITION{name()='Spouse_Critical_Illness_Requested_Amount' and ../Spouse_Critical_Illness_Requested_Amount !='' and not(matches(../Spouse_Critical_Illness_Requested_Amount, $varRegexBenefitAmount)) } VALUE=["Invalid Spouse Critical Illness Requested Amount"]

IF CONDITION{name()='Child_Critical_Illness_Coverage_Termination_Date' and ../Child_Critical_Illness_Coverage_Termination_Date !='' and not(matches(../Child_Critical_Illness_Coverage_Termination_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid Child Critical Illness Coverage Termination Date"]

IF CONDITION{name()='Child_Critical_Illness_Eligibility_Date' and ../Child_Critical_Illness_Eligibility_Date !='' and not(matches(../Child_Critical_Illness_Eligibility_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid Child Critical Illness Eligibility Date"]

IF CONDITION{name()='Child_Critical_Illness_Requested_Amount' and Child_Critical_Illness_Requested_Amount !='' and not(matches(../Child_Critical_Illness_Requested_Amount, $varRegexBenefitAmount)) } VALUE=["Invalid Child Critical Illness Requested Amount"]

IF CONDITION{name()='Hospital_Indemnity_Choice' and Hospital_Indemnity_Choice !='' and not(matches(../Hospital_Indemnity_Choice, $varRegexOccupQual)) } VALUE=["Invalid Hospital Indemnity Choice"]

IF CONDITION{name()='Hospital_Indemnity_Class' and Hospital_Indemnity_Class !='' and not(matches(../Hospital_Indemnity_Class, $varRegexClass)) } VALUE=["Invalid Hospital Indemnity Class"]

IF CONDITION{name()='Hospital_Indemnity_Coverage_Termination_Date' and ../Hospital_Indemnity_Coverage_Termination_Date !='' and not(matches(../Hospital_Indemnity_Coverage_Termination_Date, $var_DateFormat_REGEX)) } VALUE=["Invalid Hospital Indemnity Coverage Termination Date"]

IF CONDITION{name()='Hospital_Indemnity_Dependent_Tier' and ../Hospital_Indemnity_Dependent_Tier !='' and $var_HospitalIndemnityDependentTierVM = 'InvalidDependentTierCodes'} VALUE=["Invalid Hospital Indemnity Dependent Tier"]

IF CONDITION{name()='Hospital_Indemnity_Eligibility_Date_of_Coverage' and ../Hospital_Indemnity_Eligibility_Date_of_Coverage !='' and not(matches(../Hospital_Indemnity_Eligibility_Date_of_Coverage, $var_DateFormat_REGEX)) } VALUE=["Invalid Hospital Indemnity Eligibility Date of Coverage"]

IF CONDITION{name()='Voluntary_Cancer_Choice' and ../Voluntary_Cancer_Choice !='' and not(matches(../Voluntary_Cancer_Choice, $varRegexOccupQual)) } VALUE=["Invalid Voluntary Cancer Choice"]

IF CONDITION{name()='Voluntary_Cancer_Class' and (../Voluntary_Cancer_Class !='') and (not(matches (../Voluntary_Cancer_Class,$varRegexClass))) }
VALUE=["Invalid Voluntary Cancer class|" ]

IF CONDITION{name()='Voluntary_Cancer_Coverage_Termination_Date' and ../Voluntary_Cancer_Coverage_Termination_Date != '' and not(matches(../Voluntary_Cancer_Coverage_Termination_Date, $var_DateFormat_REGEX) )} VALUE=['Invalid Voluntary Cancer Coverage Termination Date|']

IF CONDITION{name()='Voluntary_Cancer_Dependent_Tier' and ../Voluntary_Cancer_Dependent_Tier != '' and $var_VoluntaryCancerDependentTierCodeVM = 'InvalidDependentTier'} VALUE=['Invalid Voluntary Cancer Dependent Tier|' ]

IF CONDITION{name()='Voluntary_Cancer_Eligibility_Date_of_Coverage' and ../Voluntary_Cancer_Eligibility_Date_of_Coverage != '' and not(matches(../Voluntary_Cancer_Eligibility_Date_of_Coverage, $var_DateFormat_REGEX) )} VALUE=['Invalid Voluntary Cancer Eligibility Date of Coverage|']

IF CONDITION{name()='Employee_Smoker_Indicator' and ../Employee_Smoker_Indicator != '' and not(matches(../Employee_Smoker_Indicator, $varRegexIndicator) )} VALUE=['Invalid Employee Smoke Indicator|']

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

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

IF CONDITION{name()='Dependent_Spouse_Date_of_Birth' and ../Dependent_Spouse_Date_of_Birth != '' and not(matches(../Dependent_Spouse_Date_of_Birth, $var_DateFormat_REGEX) )} VALUE=['Invalid Spouse Date Of Birth format|']

IF CONDITION{name()='Dependent_Spouse_Gender' and ../Dependent_Spouse_Gender !='' and $Var_GenderCodesVM = 'InvalidGender'} VALUE=["Invalid Depenent Spouse Gender|"]

IF CONDITION{name()='Spouse_Smoker_Indicator' and ../Spouse_Smoker_Indicator != '' and not(matches(../Spouse_Smoker_Indicator, $varRegexIndicator) )} VALUE=['Invalid Spouse Smoke Indicator|']

IF CONDITION{name()='Dependent_Child_1_Date_of_Birth' and ../Dependent_Child_1_Date_of_Birth != '' and not(matches(../Dependent_Child_1_Date_of_Birth , $var_DateFormat_REGEX) )} VALUE=['Invalid Dependent Child 1 Date of Birth|']

IF CONDITION{name()='Dependent_Child_1_First_Name' and ../Dependent_Child_1_First_Name !='' and not(matches(../Dependent_Child_1_First_Name,$varRegexFirstName))}VALUE=["Invalid Dependent Child 1 first Name|"]

IF CONDITION{name()='Dependent_Child_1_Gender' and ../Dependent_Child_1_Gender !='' and $Var_GenderCodesVM = 'InvalidGender'} VALUE=["Invalid Dependent Child 1 Gender|"]

IF CONDITION{name()='Dependent_Child_1_Last_Name' and ../Dependent_Child_1_Last_Name !='' and not(matches(../Dependent_Child_1_Last_Name,$varRegexLastName))}VALUE=["Invalid Dependent Child 1 last Name|" ]

IF CONDITION{name()='Dependent_Child_2_Date_of_Birth' and ../Dependent_Child_2_Date_of_Birth != '' and not(matches(../Dependent_Child_2_Date_of_Birth , $var_DateFormat_REGEX))} VALUE=['Invalid Dependent Child 2 Date of Birth|']

IF CONDITION{name()='Dependent_Child_2_First_Name' and ../Dependent_Child_2_First_Name !='' and not(matches(../Dependent_Child_2_First_Name,$varRegexFirstName))}VALUE=["Invalid Dependent Child 2 first Name|" ]

IF CONDITION{name()='Dependent_Child_2_Gender' and ../Dependent_Child_2_Gender !='' and $Var_GenderCodesVM = 'InvalidGender'} VALUE=["Invalid Dependent Child 2 Gender|" ]

IF CONDITION{name()='Dependent_Child_2_Last_Name' and ../Dependent_Child_2_Last_Name !='' and not(matches(../Dependent_Child_2_Last_Name,$varRegexLastName))}VALUE=["Invalid Dependent Child 2 last Name|"]

IF CONDITION{name()='Dependent_Child_3_Date_of_Birth' and ../Dependent_Child_3_Date_of_Birth != '' and not(matches(../Dependent_Child_3_Date_of_Birth , $var_DateFormat_REGEX))} VALUE=['Invalid Dependent Child 3 Date of Birth|']

IF CONDITION{name()='Dependent_Child_3_First_Name' and ../Dependent_Child_3_First_Name !='' and not(matches(../Dependent_Child_3_First_Name,$varRegexFirstName))}VALUE=["Invalid Dependent Child 3 first Name|" ]

IF CONDITION{name()='Dependent_Child_3_Gender' and ../Dependent_Child_3_Gender !='' and $Var_GenderCodesVM = 'InvalidGender'} VALUE=["Invalid Dependent Child 3 Gender|"]

IF CONDITION{name()='Dependent_Child_3_Last_Name' and ../Dependent_Child_3_Last_Name !='' and not(matches(../Dependent_Child_3_Last_Name,$varRegexLastName)) }VALUE=["Invalid Dependent Child 3 last Name|"]

IF CONDITION{name()='Dependent_Child_4_Date_of_Birth' and ../Dependent_Child_4_Date_of_Birth != '' and not(matches(../Dependent_Child_4_Date_of_Birth, $var_DateFormat_REGEX))} VALUE=['Invalid Dependent Child 4 Date of Birth|']

IF CONDITION{name()='Dependent_Child_4_First_Name' and ../Dependent_Child_4_First_Name !='' and not(matches(../Dependent_Child_4_First_Name,$varRegexFirstName))}VALUE=["Invalid Dependent Child 4 first Name|" ]

IF CONDITION{name()='Dependent_Child_4_Gender' and ../Dependent_Child_4_Gender !='' and $Var_GenderCodesVM = 'InvalidGender'} VALUE=["Invalid Dependent Child 4 Gender|"]

IF CONDITION{name()='Dependent_Child_4_Last_Name' and ../Dependent_Child_4_Last_Name !='' and not(matches(../Dependent_Child_4_Last_Name,$varRegexLastName))}VALUE=["Invalid Dependent Child 4 last Name|" ]

IF CONDITION{name()='Dependent_Child_5_Date_of_Birth' and ../Dependent_Child_5_Date_of_Birth != '' and not(matches(../Dependent_Child_5_Date_of_Birth , $var_DateFormat_REGEX) )} VALUE=['Invalid Dependent Child 5 Date of Birth|']

IF CONDITION{name()='Dependent_Child_5_First_Name' and ../Dependent_Child_5_First_Name !='' and not(matches(../Dependent_Child_5_First_Name,$varRegexFirstName)) } VALUE=["Invalid Dependent Child 5 first Name|" ]

IF CONDITION{name()='Dependent_Child_5_Gender' and ../Dependent_Child_5_Gender !='' and $Var_GenderCodesVM = 'InvalidGender'} VALUE=["Invalid Dependent Child 5 Gender|"]

IF CONDITION{name()='Dependent_Child_5_Last_Name' and ../Dependent_Child_5_Last_Name !='' and not(matches(../Dependent_Child_5_Last_Name,$varRegexLastName)) }VALUE=["Invalid Dependent Child 5 last Name|"]

IF CONDITION{name()='Dependent_Child_6_Date_of_Birth' and ../Dependent_Child_6_Date_of_Birth != '' and not(matches(../Dependent_Child_6_Date_of_Birth ,$var_DateFormat_REGEX))}VALUE=['Invalid Dependent Child 6 Date of Birth|' ]

IF CONDITION{name()='Dependent_Child_6_First_Name' and ../Dependent_Child_6_First_Name !='' and not(matches(../Dependent_Child_6_First_Name,$varRegexFirstName))} VALUE=["Invalid Dependent Child 6 first Name|" ]

IF CONDITION{name()='Dependent_Child_6_Gender' and ../Dependent_Child_6_Gender !='' and $Var_GenderCodesVM = 'InvalidGender'} VALUE=["Invalid Dependent Child 6 Gender|"]

IF CONDITION{name()='Dependent_Child_6_Last_Name' and ../Dependent_Child_6_Last_Name !='' and not(matches(../Dependent_Child_6_Last_Name,$varRegexLastName))}VALUE=["Invalid Dependent Child 6 last Name|"]

IF CONDITION{name()='Dependent_Child_7_Date_of_Birth' and ../Dependent_Child_7_Date_of_Birth != '' and not(matches(../Dependent_Child_7_Date_of_Birth , $var_DateFormat_REGEX))} VALUE=['Invalid Dependent Child 7 Date of Birth|']

IF CONDITION{name()='Dependent_Child_7_First_Name' and ../Dependent_Child_7_First_Name !='' and not(matches(../Dependent_Child_7_First_Name,$varRegexFirstName))} VALUE=["Invalid Dependent Child 7 first Name|" ]

IF CONDITION{name()='Dependent_Child_7_Gender' and ../Dependent_Child_7_Gender !='' and $Var_GenderCodesVM = 'InvalidGender'}VALUE=["Invalid Dependent Child 7 Gender|" ]

IF CONDITION{name()='Dependent_Child_7_Last_Name' and ../Dependent_Child_7_Last_Name !='' and not(matches(../Dependent_Child_7_Last_Name,$varRegexLastName))}VALUE=["Invalid Dependent Child 7 last Name|"]

IF CONDITION{name()='Dependent_Child_8_Date_of_Birth' and ../Dependent_Child_8_Date_of_Birth != '' and not(matches(../Dependent_Child_8_Date_of_Birth , $var_DateFormat_REGEX) )} VALUE=['Invalid Dependent Child 8 Date of Birth|']

IF CONDITION{name()='Dependent_Child_8_First_Name' and ../Dependent_Child_8_First_Name !='' and not(matches(../Dependent_Child_8_First_Name,$varRegexFirstName)) } VALUE=["Invalid Dependent Child 8 first Name|"]

IF CONDITION{name()='Dependent_Child_8_Gender' and ../Dependent_Child_8_Gender !='' and $Var_GenderCodesVM = 'InvalidGender'} VALUE=["Invalid Dependent Child 8 Gender|"]

IF CONDITION{name()='Dependent_Child_8_Last_Name' and ../Dependent_Child_8_Last_Name !='' and not(matches(../Dependent_Child_8_Last_Name,$varRegexLastName))} VALUE=["Invalid Dependent Child 8 last Name|"]

IF CONDITION{name()='Dependent_Child_9_Date_of_Birth' and ../Dependent_Child_9_Date_of_Birth != '' and not(matches(../Dependent_Child_9_Date_of_Birth , $var_DateFormat_REGEX) )} VALUE=['Invalid Dependent Child 9 Date of Birth|']

IF CONDITION{name()='Dependent_Child_9_First_Name' and ../Dependent_Child_9_First_Name !='' and not(matches(../Dependent_Child_9_First_Name,$varRegexFirstName))} VALUE=["Invalid Dependent Child 9 first Name|"]

IF CONDITION{name()='Dependent_Child_9_Gender' and ../Dependent_Child_9_Gender !='' and $Var_GenderCodesVM = 'InvalidGender'} VALUE=["Invalid Dependent Child 9 Gender|"]

IF CONDITION{name()='Dependent_Child_9_Last_Name' and ../Dependent_Child_9_Last_Name !='' and not(matches(../Dependent_Child_9_Last_Name,$varRegexLastName))} VALUE=["Invalid Dependent Child 9 last Name|"]

IF CONDITION{name()='Dependent_Child_10_Date_of_Birth' and ../Dependent_Child_10_Date_of_Birth != '' and not(matches(../Dependent_Child_10_Date_of_Birth , $var_DateFormat_REGEX))} VALUE=['Invalid Dependent Child 10 Date of Birth|']

IF CONDITION{name()='Dependent_Child_10_First_Name' and ../Dependent_Child_10_First_Name !='' and not(matches(../Dependent_Child_10_First_Name,$varRegexFirstName))} VALUE=["Invalid Dependent Child 10 first Name|"]

IF CONDITION{name()='Dependent_Child_10_Gender' and ../Dependent_Child_10_Gender !='' and $Var_GenderCodesVM = 'InvalidGender'} VALUE=["Invalid Dependent Child 10 Gender|" ]

IF CONDITION{name()='Dependent_Child_10_Last_Name' and ../Dependent_Child_10_Last_Name !='' and not(matches(../Dependent_Child_10_Last_Name,$varRegexLastName))} VALUE=["Invalid Dependent Child last Name|"]

IF CONDITION{name()='GAP_Class' and ../GAP_Class != '' and not(matches(../GAP_Class, $varRegexClass))} VALUE=['Invalid GAP Class|']

IF CONDITION{name()='GAP_Coverage_Termination_Date' and ../GAP_Coverage_Termination_Date != '' and not(matches(../GAP_Coverage_Termination_Date, $var_DateFormat_REGEX))} VALUE=['Invalid GAP Coverage Termination Date|']

IF CONDITION{name()='GAP_Dependent_Tier' and ../GAP_Dependent_Tier != '' and $var_GapDependentTierCodeVM = 'InvalidDependentTier'} VALUE=['Invalid GAP Dependent Tier|']

IF CONDITION{name()='GAP_Eligibility_Date_of_Coverage' and ../GAP_Eligibility_Date_of_Coverage != '' and not(matches(../GAP_Eligibility_Date_of_Coverage, $var_DateFormat_REGEX))} VALUE=['Invalid GAP Eligibility Date of Coverage|']

IF CONDITION{name()='GAP_Plan_Name' and (../GAP_Plan_Name !='') and (not(matches (../GAP_Plan_Name,$varGAPPlanName ))) }
VALUE=["Invalid GAP Plan Name|" ]

IF CONDITION{name()='Scheduled_Days_per_Week' and ../Scheduled_Days_per_Week !='' and not(matches(Scheduled_Days_per_Week, $varRegexScheduledDays)) } VALUE=["Invalid Scheduled Days per Week"]

IF CONDITION{name()='Scheduled_Hours_per_Week' and ../Scheduled_Hours_per_Week =''} VALUE=["Missing Scheduled Hours per Week"]

IF CONDITION{name()='Scheduled_Hours_per_Week' and ../Scheduled_Hours_per_Week !='' and not(matches(Scheduled_Hours_per_Week, $varRegexScheduledDays)) } VALUE=["Invalid Scheduled Hours per Week"]

IF CONDITION{name()='Employee_SSN' and (preceding ::Employee_SSN = ../Employee_SSN) } VALUE=[ "Duplicate SSN|" ]
IF CONDITION{name()='Employee_ID' and (preceding ::Employee_ID = ../Employee_ID) } VALUE=[ "Duplicate Employee ID|" ]

Warning Conditions

image-20240902-042102.png

Warning Conditions

 Conditions (Expand to View)

IF CONDITION{name()='Employee_Home_Phone_Number' and ../Employee_Home_Phone_Number = ''} VALUE=["Missing Employee Home Phone Number|" ]

IF CONDITION{name()='Employee_Mobile_Phone_Number' and ../Employee_Mobile_Phone_Number = ''} VALUE=["Missing Employee Mobile Phone Number|" ]

IF CONDITION{name()='Employee_Job_Title' and ../Employee_Job_Title = ''} VALUE=["Missing Employee Job Tittle|" ]

IF CONDITION{name()='Employee_Work_State' and ../Employee_Work_State = ''} VALUE=["Missing Employee Work State|" ]

IF CONDITION{name()='Employment_Status' and ../Employment_Status = ''} VALUE=["Missing Employment Status|" ]

IF CONDITION{name()='Employment_Status' and(../Employment_Status = 'TE') or (../Employment_Status = 'RT') and (../Termination_Date = '')} VALUE=["Missing Term date based on Employment Status|" ]

IF CONDITION{name()='Employee_Email_Address' and ../Employee_Email_Address = ''} VALUE=["Missing Employment Email Address|" ]

IF CONDITION{name()='Employee_Earning' and ../Employee_Earning != '' and ../Earnings_Frequency = ''} VALUE=["Missing Earnings Frequency|" ]

IF CONDITION{name()='Employee_Earning' and ../Employee_Earning != '' and ../Earnings_Effective_Date = ''} VALUE=["Missing Earnings Effective Date|" ]

IF CONDITION{name()='Field_50_In_75_Rule_Indicator' and ../Field_50_In_75_Rule_Indicator = ''} VALUE=["Missing 50 In 75 Rule Indicator|" ]

IF CONDITION{name()='Hours_Worked_Previous_12_Months' and ../Hours_Worked_Previous_12_Months = ''} VALUE=["Missing Hours Worked Previous 12 Months|" ]

IF CONDITION{name()='Key_Employee_Indicator' and ../Key_Employee_Indicator = ''} VALUE=["Missing Key Employee Indicator|" ]

IF CONDITION{name()='STD_Eligibility_Date' and ../STD_Eligibility_Date = '' } VALUE=["Missing STD Eligibility Date|" ]

IF CONDITION{name()='LTD_Eligibility_Date' and ../LTD_Eligibility_Date = '' } VALUE=["Missing LTD Eligibility Date|" ]

IF CONDITION{name()='LTD_Eligibility_Date' and ../LTD_Eligibility_Date != '' and ../LTD_Benefit_Amount ='' } VALUE=["Missing LTD Class|" ]

IF CONDITION{name()='LTD_Eligibility_Date' and ../LTD_Eligibility_Date != '' and ../LTD_Benefit_Amount =''} VALUE=["Missing LTD Election|" ]

IF CONDITION{name()='Work_At_Home_Indicator' and ../Work_At_Home_Indicator = '' } VALUE=["Missing Work At Home Indicator|" ]

IF CONDITION{name()='Supervisor_Employee_ID' and ../Supervisor_Employee_ID = '' } VALUE=["Missing Supervisor Employee ID|" ]

IF CONDITION{name()='STD_Eligibility_Date' and ../STD_Eligibility_Date != '' and ../STD_Benefit_Amount ='' } VALUE=["Missing STD Class|" ]

IF CONDITION{name()='STD_Earnings_Amount' and ../STD_Earnings_Amount != '' and ../STD_Earnings_Frequency ='' } VALUE=["Missing STD Earnings Effective Date|" ]

IF CONDITION{name()='STD_Earnings_Amount' and ../STD_Earnings_Amount != '' and ../STD_Earnings_Frequency =''} VALUE=["Missing STD Earnings Frequency|" ]

IF CONDITION{name()='STD_Eligibility_Date' and ../STD_Eligibility_Date != '' and ../STD_Benefit_Amount ='' } VALUE=["Missing STD Benefit Amount|" ]

IF CONDITION{name()='LTD_Eligibility_Date' and ../LTD_Eligibility_Date != '' and ../LTD_Benefit_Amount ='' } VALUE=["Missing LTD Benefit Amount|" ]
IF CONDITION{name()='Organization_Unit' and ../Organization_Unit !='' and not(matches(../Organization_Unit, $varRegexOrganizationUnit)) } VALUE=["Invalid Organization Unit"]
IF CONDITION{name()='Employee_Job_Title' and ../Employee_Job_Title = '' } VALUE=[ "Missing Employee Job Title|"]

  1. Record-Level Validation for Error Records

    • When dealing with records categorized under the bad records stream, a thorough validation process is carried out at the individual record level. This meticulous step is crucial in pinpointing specific errors, enabling accurate error detection, reporting, and the implementation of necessary corrective measures.

  2. Comprehensive Validation for Good Records

    • Records in the good stream undergo an additional layer of validation. Both record-level and field-level validations are conducted to ensure that each data point is accurate and consistent. This thorough validation process guarantees the integrity of the data before it is moved to the next stage.

  3. Generation and Documentation of Output Files

    • Two output files are generated as a result of the validation process:

      • Good Records File: This file contains all records that have passed the validation process. It is prepared for delivery or further processing as required by the business needs.

      • Bad Records File: This file contains all records that failed the validation checks. It is used for error reporting and corrective measures.

    • Detailed information about both files, including their content and status, is securely stored in the database for audit and tracking purposes.

  4. Client Notification via Email for Bad Records

    • The bad records file is automatically sent to the client via a structured email notification. This communication includes relevant details about the errors identified, enabling the client to take corrective actions promptly.

  5. Deployment of the Good Records File to the Target Location

    • The validated good records file is securely transferred to the designated target location. This step ensures that the accurate data is readily available for the client or subsequent processing stages, as per the agreed-upon workflow.


2. Transaction Creation:

Upon commencing the process, essential parameters concerning the source data, file layout specifications, and target configurations are methodically established within the transaction framework. This guarantees that all ensuing operations adhere to the predetermined standards and necessities.

  1. Create a Transaction: Define Name & Description.

image-20240822-073343.png
  1. Select Partner.

image-20240822-083442.png
  1. Define Parameters: Add Parameters.

image-20240822-100123.pngimage-20240822-100237.png
  1. Define Transaction Settings:

image-20240822-100405.png
  1. Select File Location: Source

image-20240823-073903.png
  1. Select Source Data Format & Layout.

image-20240823-074250.png
  1. Create a Text Layout.

image-20240823-074501.png
  1. Select FTP as Target: FTP Account

image-20240823-074706.png
  1. Select File Location.

image-20240823-075137.png
  1. Create Data Mapping.

image-20240823-075435.png

In this Mapping, we are standardizing the SingleFile_ADP_Layout.

image-20240902-040833.png
  1. Turn on the Transaction.

image-20240823-080009.png

  • No labels