File Creation Utility - Complex field mapping

sthiemann

This is my first rodeo using File Creation Utility.  I'm configuring a HIPAA834 5010 interface file.  Mapping field E_REF: Policy Number (Row 41) is complex because its constructed by the concatenation of three fields: GroupID, BenefitID, & CategoryID.

 

GroupID + BenefitID are stored in a Cross Reference table indexed by the BenefitPlan code.

 

CategoryID is indexed by EmployeeBenefit derived field BenefitStatusCode which describes the insured ( Active Employee | Retired | Cobra ).

 

It was a bit involved to customize BenefitsHIPAA834 using Infor Process Designer, involving nodes for gleaning the business class & cross reference fields and then adding javascript to assemble the finished value.

 

Looking at Mapping options in FCU, I'm at a loss for how all that code will translate.  Hopeful a seasoned FCU wizard can provide some tips …

 

unknown

If you have a complex calculation for a field that you want to output in the FCU, the best thing to do is create a configured derived field on the business class the setup is using (in this case, the column is going against 'EmployeeBenefitTransaction') and then change the source field for that column to your new derived field.  Column mappings can use any available field on the business class it is defined against, either delivered fields or configured.

If you happen to be attending the Infor Connect conference in St Paul in 2 weeks, I am doing a FCU lab on Wednesday.  You could stop by and I could look at the details of what you are trying to do.