You are here: File Descriptions > Payroll > PATPxxx - PA Trans. Post File

# PATPxxx - PA Trans. Post File

The Payroll Transaction Post file stores records that have been posted from Transaction entry.

Entries in this file are created from the Transaction entry. Records are stored for each earning code and deduction code. A special record is also kept if pieces are entered.

There is one record for each earning code and one record for each deduction code. A sequence number allows for earnings to be split between several paychecks. The Prepare Checks function creates checks from this file. The Post Checks function will remove those records that were used to create the current check run in process.

| Template: | DIM PATP:"GENA0:C(43*), GENA1:C(1*), GENN0:N(9*), GENN1:N(12*), SEQTRAN:C(7*), ISVA:C(1*), ISVN[2]:N(1*)"
|  | Earnings - DIM PATP_1:"EMPL:C(6), SEQ:C(3), RECTYP:C(1), EARN:C(3), TAXGP:C(6), DEPT:C(6), JOB:C(6), PHASE:C(6), CSTC:C(3), LABOR:C(3*), ETYPE:C(1*), HRS:N(9*), AMT:N(12*), SEQTRAN:C(7*), ISVA:C(1*), ISVN[2]:N(1*)"
|  | Pieces - DIM PATP_2:"EMPL:C(6), SEQ:C(3), RECTYP:C(1), RSV1:C(3), RSV2:C(6), DEPT:C(6), JOB:C(6), PHASE:C(6), CSTC:C(3), LABOR:C(3*), RSV4:C(1*), PIECES:N(5*), RSV5:N(1*), SEQTRAN:C(7*), ISVA:C(1*), ISVN[2]:N(1*)"
|  | Deductions - DIM PATP_3:"EMPL:C(6), SEQ:C(3), RECTYP:C(1), DEDUC:C(3), TAXGP:C(6), DEPT:C(6), JOB:C(6), PHASE:C(6), CSTC:C(3), LABOR:C(3*), RSV1:C(1*), HRS:N(9*), AMT:N(12*), SEQTRAN:C(7*), ISVA:C(1*), ISVN[2]:N(1*)"
| IOLIST: | 0999 PATPXXX: IOLIST TP0$, TP1$, TP0, TP1, TP2$, TP99$[ALL], TP99[ALL]
| Array Sizes: | DIM TP99$[0], TP99[1]
| String Sizes: | DIM TP0$(43), TP1$(1), TP2$(7)

Key Definitions

| Key Number | Field | Description
| 0 | [1:1:6] + | Employee ID +
|  | [1:7:3] + | Sequence Number +
|  | [1:10:1] + | Record Type +
|  | [1:11:3] + | Earning Code +
|  | [1:14:6] + | Tax Group +
|  | [1:20:6] + | Department ID +
|  | [1:26:6] + | Job ID +
|  | [1:32:6] + | Phase ID +
|  | [1:38:3] + | Cost Code +
|  | [1:41:3] | Labor Class
| 1 | [1:26:6] + | Job ID +
|  | [1:32:6] + | Phase ID +
|  | [1:1:6] + | Employee ID +
|  | [1:7:3] + | Sequence Number +
|  | [1:10:1] + | Record Type +
|  | [1:11:3] + | Earning Code +
|  | [1:14:6] + | Tax Group +
|  | [1:20:6] + | Department ID +
|  | [1:38:3] + | Cost Code +
|  | [1:41:3] | Labor Class
|  | __________ |
|  | 20 segments |

PA Trans. Post File - Earnings

| File Name: | PATPxxx | Record Size: | 83(128)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 2

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1(1,6) | EMPL | TP0$(1,6) | Employee ID | A | 6 |
| 1(7,3) | SEQ | TP0$(7,3) | Sequence Number | A | 3 | "000"
| 1(10,1) | RECTYP | TP0$(10,1) | Record Type | A | 1 | E=Earnings
| 1(11,3) | EARN | TP0$(11,3) | Earning Code | A | 3 |
| 1(14,6) | TAXGP | TP0$(14,6) | Tax Group | A | 6 |
| 1(20,6) | DEPT | TP0$(20,6) | Department ID | A | 6 |
| 1(26,6) | JOB | TP0$(26,6) | Job ID | A | 6 |
| 1(32,6) | PHASE | TP0$(32,6) | Phase ID | A | 6 |
| 1(38,3) | CSTC | TP0$(38,3) | Cost Code | A | 3 | "001"-"999"
| 1(41,3) | LABOR | TP0$(41,3) | Labor Class | A | 3 |
| 2 | ETYPE | TP1$ | Earning Type | A | 1 |
| 3 | HRS | TP0 | Hours Worked | N | 9 | HOUR
| 4 | AMT | TP1 | Amount | N | 12 | DOLL
| 5 | SEQTRAN | TP2$ | Sequence for Transaction | A | 7 |
| 6 | ISVA | TP99$[0] | Reserved for ISV | A | 1 |
| 7 | ISVN[1] | TP99[0] | Reserved for ISV 1 | N | 1 |
| 8 | ISVN[2] | TP99[1] | Reserved for ISV 2 | N | 1 |

PA Trans. Post File - Pieces

| File Name: | PATPxxx | Record Size: | 70(128)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 2

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1(1,6) | EMPL | TP0$(1,6) | Employee ID | A | 6 |
| 1(7,3) | SEQ | TP0$(7,3) | Sequence Number | A | 3 | "000"
| 1(10,1) | RECTYP | TP0$(10,1) | Record Type | A | 1 | P = Pieces
| 1(11,3) | RSV1 | TP0$(11,3) | Reserved for OSD | A | 3 |
| 1(14,6) | RSV2 | TP0$(14,6) | Reserved for OSD | A | 6 |
| 1(20,6) | DEPT | TP0$(20,6) | Department ID | A | 6 |
| 1(26,6) | JOB | TP0$(26,6) | Job ID | A | 6 |
| 1(32,6) | PHASE | TP0$(32,6) | Phase ID | A | 6 |
| 1(38,3) | CSTC | TP0$(38,3) | Cost Code | A | 3 | "001"-"999"
| 1(41,3) | LABOR | TP0$(41,3) | Labor Class | A | 3 |
| 2 | RSV4 | TP1$ | Reserved for OSD | A | 1 |
| 3 | PIECES | TP0 | Pieces | N | 7 | 7.0-
| 4 | RSV5 | TP1 | Reserved for OSD | N | 1 |
| 5 | SEQTRAN | TP2$ | Sequence for Transaction | A | 7 |
| 6 | ISVA | TP99$[0] | Reserved for ISV | A | 1 |
| 7 | ISVN[1] | TP99[0] | Reserved for ISV 1 | N | 1 |
| 8 | ISVN[2] | TP99[1] | Reserved for ISV 2 | N | 1 |

PA Trans. Post File - Deductions

| File Name: | PATPxxx | Record Size: | 83(128)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 2

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1(1,6) | EMPL | TP0$(1,6) | Employee ID | A | 6 |
| 1(7,3) | SEQ | TP0$(7,3) | Sequence Number | A | 3 | "000"
| 1(10,1) | RECTYP | TP0$(10,1) | Record Type | A | 1 | D = Deduction
| 1(11,3) | DEDUC | TP0$(11,3) | Deduction Code | A | 3 |
| 1(14,6) | TAXGP | TP0$(14,6) | Tax Group | A | 6 |
| 1(20,6) | DEPT | TP0$(20,6) | Department ID | A | 6 |
| 1(26,6) | JOB | TP0$(26,6) | Job ID | A | 6 |
| 1(32,6) | PHASE | TP0$(32,6) | Phase ID | A | 6 |
| 1(38,3) | CSTC | TP0$(38,3) | Cost Code | A | 3 | "001"-"999"
| 1(41,3) | LABOR | TP0$(41,3) | Labor Class | A | 3 |
| 2 | RSV1 | TP1$ | Reserved for OSD | A | 1 |
| 3 | HRS | TP0 | Hours Worked | N | 9 | HOUR
| 4 | AMT | TP1 | Amount | N | 12 | DOLL
| 5 | SEQTRAN | TP2$ | Sequence for Transaction | A | 7 |
| 6 | ISVA | TP99$[0] | Reserved for ISV | A | 1 |
| 7 | ISVN[1] | TP99[0] | Reserved for ISV 1 | N | 1 |
| 8 | ISVN[2] | TP99[1] | Reserved for ISV 2 | N | 1 |