Looks good Vinayak Kulkarni. EDI team confirms that they have not used these fields.
I take it back! Here are some questions.

• Which tab should we see to find what is being deleted? Is it "to be deleted" OR are the ones in red in Harbinger tab?
• There are some "duplicate fields" (see this screenshot: ) - possibly coming from "Add Employee" and "Add Employee Demographics" screens. This is surely confusing. Are they redundant?
• What do you mean by "unused"? Does that mean you have checked all the templates (using database scripts) to verify that the "unused" fields are not in use anywhere? We found the following fields in the "to be deleted" tab that are in use and hence SHOULD NOT BE DELETED. There could be more such fields, how can we be sure?

Enrollment ADP Terminated Record Indicator and Enrollment ADP Terminated Record with Zero Cost Indicator are ADP indicators used in Payroll export files.

The Enrollment Park View Payroll Indicator is used on Parkview’s Payroll file (sent during OE). The Enrollment PCP AffiliateID is used on City of Durham’s BenefitFocus files. Not sure about the Enrollment Health Imputed Amount field but I think this is associated with pulling imputed income for Domestic Partner’s Coverage Tier based plans?

Please also see the comment below from Nathaniel below.

"Customer ID"- why is that being deleted? I noticed that "company name" isnt available either.

Hi Abhay,

We have created this enhancement ticket to keep this task on list as other linked ticket was a support task and was marked as resolved.

As of now, we haven't checked fields which are marked as to be deleted using database script to check if they are used. However, when we schedule this ticket in upcoming sprint, then we will have all details checks and answers to your queries. Thanks.

Hello Abhay Patil and Vinayak Kulkarni

I can answer the first question here.

We need to refer the red cells in the sheet 'Harbinger'. These are 55 in count.

The other 2 sheets - Fields To be deleted and Fields Description were intermediate version which should have been removed by me while uploading.

Vinayak Kulkarni, Could you please remove current file and upload the file again after removing these 2 spreadsheets.?

Abhay Patil, As Vinayak Kulkarni has indicated in above comment these are not identified using scripts and he would do so once he plans this in a sprint.

Regards,
Lalit Kumar

Uploaded file again after removing two intermediate tabs in file.