#48 – Newborn in Home or Host country

CASE
    WHEN [Assignment Dependent (Custom Fields): Dependent Effective Start Date]
         = [Assignment Dependent: Birth Date]
         AND [Assignment Dependent: Country of Birth]
         = [Assignment: From Country]
    THEN 'Home Country'

    WHEN [Assignment Dependent (Custom Fields): Dependent Effective Start Date]
         = [Assignment Dependent: Birth Date]
         AND [Assignment Dependent: Country of Birth]
         = [Assignment: To Country]
    THEN 'Host Country'

    WHEN [Assignment Dependent (Custom Fields): Dependent Effective Start Date]
         = [Assignment Dependent: Birth Date]
    THEN 'Other Country'

    ELSE 'Not Newborn'
END

same way check #49 – Child born in Home Country and #53 – Child born in Host Company. They should use the newborn criterion, not the Family Size Effective Date.

#50 – Update Accompanying Status as Not Accompanying

CASE
    WHEN [Assignment Dependent (Custom Fields): Dependent Effective Start Date]
         = [Assignment Dependent: Birth Date]
         AND [Assignment Dependent: Country of Birth]
         = [Assignment: From Country]
         AND [Assignment Dependent: Status] <> 'Not Accompanying'
    THEN 'Yes'
    ELSE 'No'
END