You are here: File Descriptions > Payroll > PADPxxx - PA Department File

# PADPxxx - PA Department File

The Department file stores general information for each department.

There is one record for each earning code per department, one record for each employer paid withholding or deduction, one record that stores pieces totals, and one record for total hours.

| Template: | DIM PADP:"DEPT:C(6*), GENA1:C(20*), GENA2:C(8*), GENA3:C(12*), GENN1_0:N(12*), GENN1_1:N(12*), GENN1_2:N(13*), ISVA:C(1*), ISVN[2]:N(1*)"
|  | Hours Rec. - DIM PADP_1:"DEPT:C(6*), DEPNAM:C(20*), DEPTYP:C(1), RSV1:C(7*), RSV2:C(12*), HRSPTD:N(11*), HRSQTD:N(11*), HRSYTD:N(11*), ISVA:C(1*), ISVN[2]:N(1*)"
|  | Pieces Rec. - DIM PADP_2:"DEPT:C(6*), RSV1:C(20*), DEPTYP:C(1), RSV2:C(7*), RSV3:C(12*), PCSPTD:N(8*), PCSQTD:N(8*), PCSYTD:N(8*), ISVA:C(1*), ISVN[2]:N(1*)"
|  | Earnings - DIM PADP_3:"DEPT:C(6*), RSV1:C(20*), DEPTYP:C(1), EARN:C(3), RSV2:C(4*), GLACT:C(12*), ERNPTD:N(12*), ERNQTD:N(12*), ERNYTD:N(13*), ISVA:C(1*), ISVN[2]:N(1*)"
|  | Withholding - DIM PADP_4:"DEPT:C(6*), RSV1:C(20*), DEPTYP:C(1), STATE:C(2), LOCL:C(2), WHCD:C(3*), GLACT:C(12*), WHPTD:N(11*), WHQTD:N(11*), WHYTD:N(12*), ISVA:C(1*), ISVN[2]:N(1*)"
|  | Deductions - DIM PADP_5:"DEPT:C(6*), RSV1:C(20*), DEPTYP:C(1), DEDUC:C(3), RSV2:C(4*), GLACT:C(12*), DEDPTD:N(11*), DEDQTD:N(11*), DEDYTD:N(12*), ISVA:C(1*), ISVN[2]:N(1*)"
| IOLIST: | 0999 PADPXXX: IOLIST DP0$, DP1$, DP2$, DP3$, DP1[ALL], DP99$[ALL], DP99[ALL]
| Array Sizes: | DIM DP1[2], DP99[1]
| String Sizes: | DIM DP0$(6), DP1$(20), DP2$(8), DP3$(12)

Key Definitions

| Key Number | Field | Description
| 0 | [1:1:6] + | Department ID +
|  | [3:1:8] | Type/Code
| 1 | [1:1:6] + | Department ID +
|  | [4:1:12] | Reserved for OSD
| 2 | [4:1:12] + | Reserved for OSD +
|  | [3:1:8] + | Type/Code +
|  | [1:1:6] | Department ID
| 3 | [2:1:20] + | Department Name +
|  | [1:1:6] + | Department ID +
|  | [3:1:8] | Type/Code
|  | __________ |
|  | 10 segments |

PA Department File - Hours Rec.

| File Name: | PADPxxx | Record Size: | 92(128)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 4

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1 | DEPT | DP0$ | Department ID | A | 6 |
| 2 | DEPNAM | DP1$ | Department Name | A | 20 |
| 3(1,1) | DEPTYP | DP2$(1,1) | Department Type | A | 1 | A
| 3(2,7) | RSV1 | DP2$(2,7) | Reserved for OSD | A | 7 |
| 4 | RSV2 | DP3$ | Reserved for OSD | A | 12 |
| 5 | HRSPTD | DP1[0] | Hours Period to Date | N | 11 | HOUR
| 6 | HRSQTD | DP1[1] | Hours Quarter to Date | N | 11 | HOUR
| 7 | HRSYTD | DP1[2] | Hours YTD | N | 11 | HOUR
| 8 | ISVA | DP99$[0] | Reserved for ISV | A | 1 |
| 9 | ISVN[1] | DP99[0] | Reserved for ISV 1 | N | 1 |
| 10 | ISVN[2] | DP99[1] | Reserved for ISV 2 | N | 1 |

PA Department File - Pieces Rec.

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

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1 | DEPT | DP0$ | Department ID | A | 6 |
| 2 | RSV1 | DP1$ | Reserved for OSD | A | 20 |
| 3(1,1) | DEPTYP | DP2$(1,1) | Department Type | A | 1 | B
| 3(2,7) | RSV2 | DP2$(2,7) | Reserved for OSD | A | 7 |
| 4 | RSV3 | DP3$ | Reserved for OSD | A | 12 |
| 5 | PCSPTD | DP1[0] | Pieces Period to Date | N | 8 | 7.0-
| 6 | PCSQTD | DP1[1] | Pieces Quarter to Date | N | 8 | 7.0-
| 7 | PCSYTD | DP1[2] | Pieces Year to Date | N | 8 | 7.0-
| 8 | ISVA | DP99$[0] | Reserved for ISV | A | 1 |
| 9 | ISVN[1] | DP99[0] | Reserved for ISV 1 | N | 1 |
| 10 | ISVN[2] | DP99[1] | Reserved for ISV 2 | N | 1 |

PA Department File - Earnings

| File Name: | PADPxxx | Record Size: | 96(128)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 4

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1 | DEPT | DP0$ | Department ID | A | 6 |
| 2 | RSV1 | DP1$ | Reserved for OSD | A | 20 |
| 3(1,1) | DEPTYP | DP2$(1,1) | Department Type | A | 1 | C
| 3(2,3) | EARN | DP2$(2,3) | Earning Code | A | 3 |
| 3(5,4) | RSV2 | DP2$(5,4) | Reserved for OSD | A | 4 |
| 4 | GLACT | DP3$ | GL Earning Expense Account | A | 12 |
| 5 | ERNPTD | DP1[0] | Earnings Period to Date | N | 12 | DOLL
| 6 | ERNQTD | DP1[1] | Earnings Quarter to Date | N | 12 | DOLL
| 7 | ERNYTD | DP1[2] | Earnings Year to Date | N | 13 | DOLL
| 8 | ISVA | DP99$[0] | Reserved for ISV | A | 1 |
| 9 | ISVN[1] | DP99[0] | Reserved for ISV 1 | N | 1 |
| 10 | ISVN[2] | DP99[1] | Reserved for ISV 2 | N | 1 |

PA Department File - Withholding

| File Name: | PADPxxx | Record Size: | 93(128)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 4

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1 | DEPT | DP0$ | Department ID | A | 6 |
| 2 | RSV1 | DP1$ | Reserved for OSD | A | 20 |
| 3(1,1) | DEPTYP | DP2$(1,1) | Department Type | A | 1 | D
| 3(2,2) | STATE | DP2$(2,2) | State Code | A | 2 |
| 3(4,2) | LOCL | DP2$(4,2) | Local Code | A | 2 |
| 3(6,3) | WHCD | DP2$(6,3) | Withholding Code | A | 3 |
| 4 | GLACT | DP3$ | GL Withholding Expense Account | A | 12 |
| 5 | WHPTD | DP1[0] | Withholding Amt. Period to Date | N | 11 | DOLL
| 6 | WHQTD | DP1[1] | Withholding Amt. Quarter to Date | N | 11 | DOLL
| 7 | WHYTD | DP1[2] | Withholding Amt. Year to Date | N | 12 | DOLL
| 8 | ISVA | DP99$[0] | Reserved for ISV | A | 1 |
| 9 | ISVN[1] | DP99[0] | Reserved for ISV 1 | N | 1 |
| 10 | ISVN[2] | DP99[1] | Reserved for ISV 2 | N | 1 |

PA Department File - Deductions

| File Name: | PADPxxx | Record Size: | 93(128)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 4

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1 | DEPT | DP0$ | Department ID | A | 6 |
| 2 | RSV1 | DP1$ | Reserved for OSD | A | 20 |
| 3(1,1) | DEPTYP | DP2$(1,1) | Department Type | A | 1 | E
| 3(2,3) | DEDUC | DP2$(2,3) | Deduction Code | A | 3 | "000"
| 3(5,4) | RSV2 | DP2$(5,4) | Reserved for OSD | A | 4 |
| 4 | GLACT | DP3$ | GL Deduction Expense Account | A | 12 |
| 5 | DEDPTD | DP1[0] | Deduction Amt. Period to Date | N | 11 | DOLL
| 6 | DEDQTD | DP1[1] | Deduction Amt. Quarter to Date | N | 11 | DOLL
| 7 | DEDYTD | DP1[2] | Deduction Amt. Year to Date | N | 12 | DOLL
| 8 | ISVA | DP99$[0] | Reserved for ISV | A | 1 |
| 9 | ISVN[1] | DP99[0] | Reserved for ISV 1 | N | 1 |
| 10 | ISVN[2] | DP99[1] | Reserved for ISV 2 | N | 1 |