This is a basic layout of what may be used to load into IPSN.
| Record # | Field # | Name | Beg Pos | End Pos | Add to UK Set |
|---|---|---|---|---|---|
| 1 | 1 | PSL.EAS_ID.ASSIGNMENT_CODE | -1 | -1 | Y |
| 1 | 2 | PSL.EAS_ID.EEM_ID.EID_ID.PERSON_CODE | -1 | -1 | Y |
| 1 | 3 | PSL.EEM_ID.EID_ID.PERSON_CODE | -1 | -1 | Y |
| 1 | 4 | PSL.PFQ_ID.FREQUENCY_CODE | -1 | -1 | Y |
| 1 | 5 | PSL.PPC_ID.PC_CODE | -1 | -1 | Y |
| 1 | 6 | PSL.TIME_ENTERED | -1 | -1 | |
| 1 | 7 | PSL.START_DATE | -1 | -1 | Y |
| 1 | 8 | PSL.END_DATE | -1 | -1 | |
| 1 | 9 | PSL.TIME_BASIS | -1 | -1 | |
| 1 | 10 | PSL.SUNDRY_LINE_TYPE | -1 | -1 | |
| 1 | 11 | PSLD.PPC_ID.PC_CODE | -1 | -1 | |
| 1 | 12 | PSLD.AMOUNT | -1 | -1 | |
| 1 | 13 | PSLD.AMOUNT_OVERRIDE | -1 | -1 | |
| 1 | 14 | PSLD.DESCRIPTION | -1 | -1 | |
| 1 | 15 | PSLD.PC_DETAIL_TYPE | -1 | -1 | |
| 1 | 16 | PSLD.PC_ACTION | -1 | -1 |
_Focus on the correct assignment_
Any time loading into a table that has EAS_ID as a column the interface format should also be defined with fields that include EAS.EEM_ID and EAS.ASSIGNMENT_CODE so that the LTMD can focus to the correct record in the database. In the above example, we are providing PSL.EAS_ID.ASSIGNMENT_CODE, PSL.EAS_ID.EEM_ID.EID_ID.PERSON_CODE, PSL.EEM_ID.EID_ID.PERSON_CODE. The reason for this is so that the LMTD can focus to the correct EAS_ID in the sundry table based on the EAS_EEM_ID and EAS_ASSIGNMENT_CODE.
