ANSI 834 Transaction Sets (ST/SE) Customization
I am working in Oracle 11i. I have created a copy of both the full profile and the change event ANSI 834 reports and am working on customizing the records to suit the client's needs. Out-of-the-box, this report uses one transaction set for the entire report. These are the records that are tagged with codes ST and SE. We would like to change this to have each family in the 834 file be its own transaction set.
I have tried setting up a new Detail type record with a repeating level of Person for the ST and used an advanced condition to control when it prints. This is working great. However, the SE record which I have also set up as a Detail type but with an Enrollment repeating level does not work when there is more than one dependent. Other issues with this setup are that I need a counter value for one of the ST and SE segments and also need to be able to count the total number of records between and including the ST and SE