This is a basic layout of what may be used to load into IPTL. This sample shows all values that can be loaded onto the IPTL
| Record # | Field # | Name | Beg Pos | End Pos |
|---|---|---|---|---|
| 1 | 1 | PLPL.ENTITY_CODE | - 1 | - 1 |
| 1 | 2 | PLPL.PERSON_CODE | - 1 | - 1 |
| 1 | 3 | PLPL.START_DATE | - 1 | - 1 |
| 1 | 4 | PLPL.END_DATE | - 1 | - 1 |
| 1 | 5 | PLPL.PC_CODE | - 1 | - 1 |
| 1 | 6 | PLPL.TIME_CODE | - 1 | - 1 |
| 1 | 7 | PLPL.TIME_OR_AMOUNT | - 1 | - 1 |
| 1 | 8 | PLPL.RATE_BASIS | - 1 | - 1 |
| 1 | 9 | PLPL.EMPLOYMENT_TYPE | - 1 | - 1 |
| 1 | 10 | PLPL.CATEGORY_CODE | - 1 | - 1 |
| 1 | 11 | PLPL.DESTINATION_TYPE | - 1 | - 1 |
| 1 | 12 | PLPL.UPTL_STATUS | - 1 | - 1 |
| 1 | 13 | PLPL.BATCH_CODE | - 1 | - 1 |
| 1 | 14 | PLPL.JOB_CODE | - 1 | - 1 |
| 1 | 15 | PLPL.DISTRIBUTION_MASK | - 1 | - 1 |
This is an example of an IPTL load to a PC Code showing the bare minimum set up required to load.
- The file type being used is .CSV
- Values with a start and end pos of "0" are hardcoded into the interface and are not required in the file.
- "XXXXXX" would be replaced with your organizations entity code.
- "YYYYYY" would be replaced with the desired Pay Category Code.
| Record # | Field # | Name | Beg Pos | End Pos | Constant |
|---|---|---|---|---|---|
| 1 | 1 | PLPL.PERSON_CODE | -1 | -1 | |
| 1 | 2 | PLPL.START_DATE | -1 | -1 | |
| 1 | 3 | PLPL.PC_CODE | -1 | -1 | |
| 1 | 4 | PLPL.TIME_OR_AMOUNT | -1 | -1 | |
| 1 | 5 | PLPL.ENTITY_CODE | 0 | 0 | XXXXXX |
| 1 | 6 | PLPL.EMPLOYMENT_TYPE | 0 | 0 | 01 |
| 1 | 7 | PLPL.CATEGORY_CODE | 0 | 0 | YYYYYY |
| 1 | 8 | PLPL.DESTINATION_TYPE | 0 | 0 | 02 |
| 1 | 9 | PLPL.UPTL_STATUS | 0 | 0 | 00 |
