Creating a .CSV file: Requirements

The first record must be a header record. One or more detail records can follow the header record. Each detail record must match the header record field position.

• The Package Type field is required (CSV field name LOAN_PREFORPKGTYPE)
• The Property State field is required (CSV field name PROP_STATE)
• Records are separated by CR/LF.
• Field names are case sensitive (this includes the header row).
• Fields are delimited by a comma.
• Two consecutive commas in a row indicate that the field does not apply.
• Field values containing a comma must be enclosed in double quotes.
• Double quotes are prohibited within a field value if the field value is already encapsulated within double quotes. For example, the first name field value of “William, “Will”” is not valid.
• Field values submitted by servicer are transformed to an XML document without modifying its value. The servicer is responsible for formatting a field value according to data field documentation. For example, dates must be supplied in YYYY /MM/DD format.
• If formatting errors are found while processing the file they are logged and processing continues to the next record in the file.