Output Format

You can choose the output of the Full Table Publish utility to be in the following formats:

  • Message (default value).

  • Flat file.

  • Flat file with control record.

You can create multiple publish rules with different output formats for the same service operation.

Flat File Output

You select the flat file option when you set up publish rule definitions for the service operation. If a file layout object exists with the same name as the message object, you can modify the output format field on the Publish Rule Definition page.

If you select flat file output, the header and trailer messages aren’t created, and a single output flat file is created even if you already specified the chunking rule.

The file layout definition must have a record structure identical to that of the message; if the AUDIT_ACTN field does not exist in the record, you must add it to the file layout record definition.

The option becomes modifiable if a file layout object exists with the same name as the message definition.

The directory location of the flat file is determined by the value in the OUTPUT parameter in PeopleSoft Configuration Manager.

The flat file name is messageName_SequenceNumber.out, where messageName is the message name and SequenceNumber is the next available sequential number for files with that message name.