Creating File Layout Definitions

The following example shows how to create a file layout to be used with the QE_ABSENCE_HIST record:

This example illustrates the fields and controls on the QE_ABSENCE_HIST record definition. You can find definitions for the fields and controls later on this page.

QE_ABSENCE_HIST record definition

For simplicity, suppose that each row in the FIXED format file has the following structure:

888 A
000 8001 VAC  1981-09-12 1981-09-26 14  .0                     P Y  
888 A
000 8001 VAC  1983-03-02 1983-03-07 5   .0                     P Y  
888 A
000 8001 VAC  1983-08-26 1983-09-10 13  .0                     P Y  
888 A
000 8516 MAT  1986-06-06 1986-08-01 56  .0                     P Y  
888 C
000 8516 SCK  1988-08-06 1988-08-07 1   .0                     P Y  
888 A
000 8516 VAC  1987-07-14 1987-07-28 14  .0                     P Y  
888 A
000 8553 JUR  1990-12-12 1990-12-17 5   .0  Local Jury Duty    P N  
888 A
000 8553 MAT  1992-02-20 1992-10-01 224 .0  Maternity Leave    U N  
888 A
000 8553 MAT  1994-08-19 1995-03-01 194 .0  Maternity          U Y  
888 A
000 8553 PER  1993-04-15 1993-04-19 4   .0                     U N Personal 
Day required
888 C
000 8553 SCK  1987-01-28 1987-01-30 2   .0  Hong Kong Flu      P N  
888 A
000 8553 SCK  1988-08-02 1988-08-03 1   .0  Sick               P N  
888 A
000 8553 SCK  1995-09-12 1995-09-13 1   .0                     P N  
888 C
000 G001 MAT  1991-07-02 1991-09-28 88  .0  3-month Maternity  P Y Maternity will 
be paid as 80% of Claudia's current salary.

000 is the file record ID for ABSENCE_HIST, and each field appears in the same order as in the ABSENCE_HIST database record. 888 is the file record ID for an extra segment called CHANGE_ACTION, which contains an AUDIT_ACTION field with the following meanings:

  • A: Row inserted.

  • C: Row updated, but no key fields changed.

Note:

The end of file (EOF) character must be on a separate line and not on a line containing data for any incoming file, regardless of the file type. Each data line needs to be terminated with an end of line (EOL) character, which is different than an EOF character.

To create a file layout definition:

  1. Use the QE_ABSENCE_HIST record definition as the template for the file layout.

    Create a new file layout and then drag the QE_ABSENCE_HIST record into the open file layout.

  2. Save the file layout with the name ABS_HIST.

    The name of the first node changes from NEW FILE to ABS_HIST.