Sample Advanced Positional Data Definition file format

Please reference the attached sample definition file to build an Advanced Positional Layout in Adeptia Connect.

For example, suppose we have a data file that contains multiple record types such as Header, Compensation, Demographics and Trailer.

HDR 0001012848Groof File 2018100920181010180501
COMP0001012848007 70 23879999420181012201801012018123100000348400000292018092320181006
DEMO0001012848007 70 238799994271444 Niaal M Baanett 2001010 dmont Hills Pl Apartment 
DMTR0001012848000000006934000000003467020640127696000893696594000005988229000000299728

The definition file to build a layout in order to read or create this type of file should have the following format:

First line is listing all the record types along with the identifier values. The subsequent lines list all the fields that are part of each of these record types. For fields we need the field name, type, length, L (for left aligned), F (whether to skip a field, F means false / do not skip).

Header:HDR,Compensation:COMP,Demographics:DEMO,Trailer:DMTR
HDR,Header,,,string,,,4,L,F
HDR,RecordVersionNumber,,,string,,,4,L,F
HDR,MasterContractNumber,,,string,,,6,L,F
HDR,FileDesc,,,string,,,30,L,F
COMP,Compensation,,,string,,,4,L,F
COMP,RecordVersionNumber,,,string,,,4,L,F
COMP,MasterContractNumber,,,string,,,6,L,F
COMP,LocationCode,,,string,,,4,L,F
COMP,PensionPlanCode,,,string,,,4,L,F
COMP,SSN,,,string,,,9,L,F
DEMO,Demographics,,,string,,,4,L,F
DEMO,RecordVersionNum,,,string,,,4,L,F
DEMO,MasterContractNum,,,string,,,6,L,F
DEMO,LocationCode,,,string,,,4,L,F
DEMO,PensionPlanCode,,,string,,,4,L,F
DEMO,PensionPlantransferDate,,,string,,,8,L,F
DEMO,SSN,,,string,,,9,L,F
DEMO,EmployeeNumber,,,string,,,12,L,F
DEMO,PrefixName,,,string,,,4,L,F
DEMO,FirstName,,,string,,,15,L,F
DMTR,Trailer,,,string,,,4,L,F
DMTR,RecordVersionNumber,,,string,,,4,L,F
DMTR,MasterContractNumber,,,string,,,6,L,F
DMTR,TotalFileRecords,,,string,,,12,L,F
DMTR,TotalDemographicChangeRecords,,,string,,,12,L,F

For field level list you can also use an excel spreadsheet to copy/paste the field names from your specification document and build this definition file. You can then upload this definition file in the Layout screen as shown below and click Save.

Select Import Definition File for Definition Mode option.

Select Field Length for the Field Separator option.

Select Field in the Definition File drop-down.

Click on Choose File and upload your Definition file and Save the layout.

Once the layout is created and saved using the definition file, you can go back, edit the layout and configure the Hierarchy Definition in terms of parent-child relationships between these record types.

Also refer to docs: https://docs.adeptia.com/display/AC35/Advanced+Positional+Layout