Letter Extract File Structure

The following refers to logic supported by letter extract process C1-LTPEX – Letter Extract. Refer to The Letter Extract Processes for more information.

The letter extract file structure is impacted by the extract format. The extract batch, contains a File Format parameter that supports XML, CSV, and fixed position extract formats.

When the format is set to XML, the organizing data area as described in Letter Data Area Organization, is treated as a single schema. The included data areas are nested within the organizing data area. For example, an account record configured with two characteristics to extract will be nested in a single schema with a detail group and two occurrences of the characteristic list group.

When the format is set to CSV or fixed position, the included data areas are treated as an individual schema so that each record is extracted on a separate row. For example, an account record configured with two characteristics to extract will produce three rows in the extract file.