 |
Lawson Insight Technical Documentation |
|
EMDEDMASTR FILE
Employee Deduction
Contains employee payroll deductions. The system uses the deduction cycles,
effective date, and ending date to determine if PR140 (Earnings and Deductions
Calculation) takes the employee deduction. The Employee Payment Deductions
file contains the employee deductions associated with an Employee Payment
Master file record. PR14.1 (Employee Deduction) and PR15.1 (Deduction Speed
Entry) are the primary programs that update this file. The system
automatically creates records in this file for deductions defined as deduction
required codes in PR03.1 (Deduction Required Code).
The Benefits system maintains this file as it maintains employee benefits.
The records created by the Benefits system always have a sequence number of
one or higher. Records created through the Payroll system have a zero sequence
number.
REFERENCED BY
BN400 BN51.2 BN66.1 HR170 HR211 HR70.1
PR139 PR140 PR141 PR160 PR180 PR214
PR226 PR239 PR247 PR260 PR277 PR297
PR298 PR299 PR89.1 BN10.1 PR02.1 PR05.1
PR280
UPDATED BY
AC541 AC542 BN100 BN101 BN102 BN103
BN104 BN105 BN145 BN150 BN245 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN430 BN45.1
BN500 BN531 BN65.1 BN71.1 BN72.1 BS13.1
BS14.1 BS15.1 BS32.1 HR11.1 HR11.2 HR511
HR650 PA02.1 PA100 PA102 PA13.1 PA13.2
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PR110 PR113 PR114 PR115 PR120 PR128
PR13.1 PR13.2 PR13.5 PR13.6 PR13.8 PR130
PR131 PR132 PR134 PR136 PR14.1 PR15.1
PR15.2 PR189 PR195 PR197 PR205 PR26.1
PR26.2 PR29.1 PR32.2 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR36.1 PR39.1 PR39.2 PR45.1 PR47.1 PR47.2
PR514 PR529 PR530 PR560 PR80.1 PR80.3
PR82.1 PR85.1 UK102 TA147 UK120 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EDM-COMPANY Numeric 4 AC541 AC542
Company The company number represents an BN100 BN101
established company and is entered on BN102 BN103
all function codes. BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN500
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR114
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
...
EDM-EMPLOYEE Numeric 9 AC541 AC542
Employee Contains the employee number. BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN500
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR114
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
...
EDM-DED-CODE Alpha 4 AC541 AC542
Deduction Contains the user-defined value that BN100 BN101
represents a deduction. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN500
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR114
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
...
EDM-SEQ-NBR Numeric 4 AC541 AC542
Sequence Number Contains the deduction sequence number. BN100 BN101
The value of this field is always zeros BN102 BN103
if created through the Payroll system BN104 BN105
because the system allows entry of only BN145 BN150
one employee deduction record for a BN245 BN31.1
deduction. In the Benefits system, many BN31.2 BN32.1
employee deductions can exist for the BN32.2 BN32.3
same deduction with non-overlapping BN45.1 BN500
effective and ending dates. Therefore, BN531 BN65.1
this field is needed to maintain BN71.1 BN72.1
uniqueness. When you create records BS13.1 BS14.1
through the Benefits system, the system BS15.1 BS32.1
automatically sequences this field based HR11.1 HR11.2
on the last employee deduction sequence HR511 HR650
number. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR114
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
...
EDM-DED-CYCLE Alpha 1 Occurs 9 Times AC541 AC542
Deduction Cycle Contains the value that indicates in BN100 BN101
which cycles a deduction is taken. The BN102 BN103
value in this field defaults from the BN104 BN105
Deduction Cycles field in the Deduction BN145 BN150
file but you can override the value for BN245 BN31.1
each employee deduction. Valid values BN31.2 BN32.1
are: BN32.2 BN32.3
BN45.1 BN500
X - The system takes the deduction and BN531 BN65.1
updates taxable wages for withholding BN71.1 BN72.1
type deductions. On a non-tax deduction, BS13.1 BS14.1
the system takes the deduction. BS15.1 BS32.1
HR11.1 HR11.2
T - The system does not take the HR511 HR650
deduction but updates taxable wages for PA02.1 PA100
withholding type deductions. PA102 PA13.1
PA13.2 PA502
Blank - The system does not take the PA513 PA52.1
deduction and does not update taxable PA52.3 PA52.4
wages for withholding type deductions. PA52.5 PR110
On a non-tax deduction, the system does PR113 PR115
not take the deduction. PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
...
EDM-BALANCE-TYPE Alpha 1 AC541 AC542
Balance Type Contains the value that determines how BN100 BN101
the deduction affects the Balance Amount BN102 BN103
field. BN104 BN105
A = Ascending Balance BN145 BN150
D = Descending Balance BN245 BN31.1
L = Limit BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-BALANCE-AMT Signed 13.2 AC541 AC542
Balance Amount Contains the balance amount for BN100 BN101
deductions that have a balance type. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN500
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR195
...
EDM-NEXT-AMOUNT Signed 13.4 AC541 AC542
Amount or Percent Contains the amount or percent to be BN100 BN101
deducted. The calculation type defined BN102 BN103
for the deduction determines if the BN104 BN105
value is an amount or a percent. The BN145 BN150
value in this field defaults from the BN245 BN31.1
Amount or Percent field in the Deduction BN31.2 BN32.1
file but you can override the value for BN32.2 BN32.3
each employee deduction. BN45.1 BN500
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR114
PR115 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
...
EDM-DED-PRIORITY Numeric 1 AC541 AC542
Priority Contains the value that indicates the BN100 BN101
order in which deductions are processed BN102 BN103
within the following categories: BN104 BN105
withholding type deductions, deductions BN145 BN150
that are excluded from disposable BN245 BN31.1
income, garnishment deductions, all BN31.2 BN32.1
other deductions, all one-time BN32.2 BN32.3
deductions, and all company matching BN45.1 BN500
deductions. BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR114
PR115 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
...
EDM-EFFECT-DATE Numeric 8 (yyyymmdd) AC541 AC542
Effective Date Contains the effective date of the BN100 BN101
deduction. The value in this field BN102 BN103
defaults from the deduction Effective BN104 BN105
Date - Beginning field on the More form BN145 BN150
tab on PR05.1 (Deduction) but you can BN245 BN31.1
override the value for each employee BN31.2 BN32.1
deduction. BN32.2 BN32.3
BN45.1 BN500
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR114
PR115 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
...
EDM-END-DATE Numeric 8 (yyyymmdd) AC541 AC542
Ending Date Contains the last date the deduction BN100 BN101
can be taken. The value in this field BN102 BN103
defaults from the deduction Effective BN104 BN105
Date - Ending field on the More form tab BN145 BN150
on PR05.1 (Deduction) but you can BN245 BN31.1
override the value for each employee BN31.2 BN32.1
deduction. BN32.2 BN32.3
BN45.1 BN500
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR114
PR115 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
...
EDM-ARREARS Alpha 1 AC541 AC542
Arrears Contains the value that determines if BN100 BN101
the system places the deduction in BN102 BN103
arrears if it cannot take the deduction BN104 BN105
in its entirety, and whether the system BN145 BN150
takes all, nothing, or as much of the BN245 BN31.1
deduction as possible. The value in this BN31.2 BN32.1
field defaults from the Arrears field in BN32.2 BN32.3
the Deduction file but you can override BN45.1 BN500
the value for each employee deduction. BN531 BN65.1
A = All Or None - Create Arrears BN71.1 BN72.1
D = All Or None - No Arrears BS13.1 BS14.1
N = Net To Zero - No Arrears BS15.1 BS32.1
Y = Net To Zero - Create Arrears HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR114
PR115 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
...
EDM-PCT-MATCHED Signed 5.2 AC541 AC542
Percentage Matched Contains the percent to be matched by BN100 BN101
the company. The Benefits system is the BN102 BN103
only system that moves a value to this BN104 BN105
field. The system uses this field to BN145 BN150
calculate company-matched deductions BN245 BN31.1
when a company limit is defined as a BN31.2 BN32.1
percent of the employee's gross pay or a BN32.2 BN32.3
percent of a specific pay class for an BN45.1 BN531
employee. BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-MONTHLY-LIMIT Signed 11.2 AC541 AC542
Monthly Limit Contains the monthly limit that can be BN100 BN101
taken for the deduction in a single BN102 BN103
month. The value in this field defaults BN104 BN105
from the Monthly Limit field in the BN145 BN150
Deduction file but you can override the BN245 BN31.1
value for each employee deduction. BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR115 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-PAY-PRD-LIMIT Signed 11.2 AC541 AC542
Pay Period Limit Contains the deduction limit that can BN100 BN101
be taken in a pay period. The value in BN102 BN103
this field defaults from the Payment BN104 BN105
Limit field in the Deduction file but BN145 BN150
you can override the value for each BN245 BN31.1
employee deduction. BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR115 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-PRIORITY-FLAG Alpha 1 AC541 AC542
Priority Flag A value in this field indicates that BN100 BN101
the value in the Priority field did not BN102 BN103
default from the Priority field in the BN104 BN105
Deduction file and therefore is not BN145 BN150
updated if you change the deduction. BN245 BN31.1
X = Deduction Code Override BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-ARREARS-FLAG Alpha 1 AC541 AC542
Arrears Indicator A value in this field indicates that BN100 BN101
Override the value in the Arrears field did not BN102 BN103
default from the Arrears field in the BN104 BN105
Deduction file and therefore is not BN145 BN150
updated if you change the deduction. BN245 BN31.1
X = Deduction Code Override BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-EFF-DATE-FLAG Alpha 1 AC541 AC542
Effective Date Flag A value in this field indicates that BN100 BN101
the value in the Begin Date field did BN102 BN103
not default from the Begin Date field in BN104 BN105
the Deduction file and therefore is not BN145 BN150
updated if you change the deduction. BN245 BN31.1
X = Deduction Code Override BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-END-DATE-FLAG Alpha 1 AC541 AC542
End Date Flag A value in this field indicates that BN100 BN101
the value in the End Date field did not BN102 BN103
default from the End Date field in the BN104 BN105
Deduction file and therefore is not BN145 BN150
updated if you change the deduction. BN245 BN31.1
X = Deduction Code Override BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-DED-CYC-FLAG Alpha 1 AC541 AC542
Deduction Cycle Flag A value in this field indicates that BN100 BN101
the value in the Deduction Cycles fields BN102 BN103
did not default from the Deduction BN104 BN105
Cycles fields in the Deduction file and BN145 BN150
therefore is not updated if you change BN245 BN31.1
the deduction. BN31.2 BN32.1
X = Ded taken and Taxable updated BN32.2 BN32.3
T = Ded not taken/Taxable updated BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-AMOUNT-FLAG Alpha 1 AC541 AC542
Amount Flag A value in this field indicates that BN100 BN101
the value in the Amount or Percent field BN102 BN103
did not default from the Amount or BN104 BN105
Percent field in the Deduction file and BN145 BN150
therefore is not updated if you change BN245 BN31.1
the deduction. BN31.2 BN32.1
X = Deduction Code Override BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-MTH-LIMIT-FLAG Alpha 1 AC541 AC542
Mth Limit Flag A value in this field indicates that BN100 BN101
the value in the Monthly Limit field did BN102 BN103
not default from the Monthly Limit field BN104 BN105
in the Deduction file and therefore is BN145 BN150
not updated if you change the deduction. BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-PRD-LIMIT-FLAG Alpha 1 AC541 AC542
Pay Period Limit A value in this field indicates that BN100 BN101
Flag the value in the Payment Limit Flag BN102 BN103
field did not default from the Payment BN104 BN105
Limit Flag field in the Deduction file BN145 BN150
and therefore is not updated if you BN245 BN31.1
change the deduction. BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-DED-ORDER Numeric 3 AC541 AC542
Ded Order Insures that the system processes BN100 BN101
withholding deductions first. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN500
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR114
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
...
EDM-RES-CODE Alpha 1 AC541 AC542
Res Code Contains the value that indicates if BN100 BN101
the employee is a resident of the tax BN102 BN103
authority associated with the deduction. BN104 BN105
Y = Resident BN145 BN150
N = Non-Resident BN245 BN31.1
0 = Resident BN31.2 BN32.1
1 = Nonresident receiving pension BN32.2 BN32.3
2 = Nonresident continuous employ BN45.1 BN531
3 = Nonresident non-cont employ BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-MARITAL-STATUS Numeric 2 AC541 AC542
Marital Status Contains the marital status associated BN100 BN101
with the employee's tax deduction. BN102 BN103
01 = Single BN104 BN105
02 = Married BN145 BN150
03 = Married Filing Separate BN245 BN31.1
04 = Married Both Spouses Working BN31.2 BN32.1
05 = Married One Spouse Working BN32.2 BN32.3
06 = Head of Household BN45.1 BN531
07 = Married Multiple Employers BN65.1 BN71.1
08 = Widow or Widower BN72.1 BS13.1
09 = Married Not Living With Spouse BS14.1 BS15.1
10 = Married Joint Claiming All BS32.1 HR11.1
11 = Married Joint Claiming Half HR11.2 HR511
12 = Married Separate Claiming All HR650 PA02.1
13 = Married Joint Claiming None PA100 PA102
14 = Married Living With Spouse PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-EXEMPTIONS Numeric 5 AC541 AC542
Exemptions Contains the number of exemptions BN100 BN101
associated with the employee's tax BN102 BN103
deduction. BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-EXEMPT-AMOUNT Signed 9.2 AC541 AC542
Exempt Amount Contains the exempt amount associated BN100 BN101
with the employee's tax deduction. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-CERT-CODE Numeric 1 AC541 AC542
Cert Code Contains the value that indicates the BN100 BN101
employee has on file, a certificate BN102 BN103
verifying the employee is a nonresident BN104 BN105
of the tax authority, is exempt from BN145 BN150
withholding, or receives a withholding BN245 BN31.1
tax credit for the tax authority BN31.2 BN32.1
associated with the deduction. BN32.2 BN32.3
0 = No Certificate BN45.1 BN531
1 = Certificate of Non-Residence BN65.1 BN71.1
2 = Exempt From Withholding BN72.1 BS13.1
3 = Withholding Tax Credit BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-PERS-EXEMPTS Numeric 1 AC541 AC542
Pers Exempts Contains the number of personal BN100 BN101
exemptions defined for the employee BN102 BN103
deduction. BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-DEPEND-EXEMPTS Numeric 5 AC541 AC542
Depend Exempts Contains the number of dependent BN100 BN101
exemptions defined for the employee BN102 BN103
deduction. BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-ADDL-EXEMPTS Numeric 5 AC541 AC542
Addl Exempts Contains the number of additional BN100 BN101
exemptions defined for the employee BN102 BN103
deduction. BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-ADDL-EXEMP-AMT Signed 9.2 AC541 AC542
Addl Exemp Amt Contains the additional exemption BN100 BN101
amount defined for the employee BN102 BN103
deduction. BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-ADDL-TAX-CODE Numeric 2 AC541 AC542
Addl Tax Code Contains additional tax codes BN100 BN101
associated with the employee deduction. BN102 BN103
The tax code indicates if the additional BN104 BN105
tax is an additional, replacement, or BN145 BN150
exempt amount. BN245 BN31.1
BN31.2 BN32.1
01 = Replacement Amount BN32.2 BN32.3
02 = Additional Amount BN45.1 BN531
03 = Replacement Percent BN65.1 BN71.1
04 = Additional Percent BN72.1 BS13.1
05 = Replacement Amount and Percent BS14.1 BS15.1
06 = Exempt Amount BS32.1 HR11.1
07 = Exempt Percent HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-ADDL-RATE Signed 7.4 AC541 AC542
Addl Rate Contains a value if the Addl Tax Code BN100 BN101
field value indicates a percent. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-ADDL-AMOUNT Signed 9.2 AC541 AC542
Addl Amount Contains a value if the Addl Tax Code BN100 BN101
field value indicates an amount. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-FORMULA-NUMBER Numeric 1 AC541 AC542
Formula Number Contains the value that identifies the BN100 BN101
formula used in calculating the BN102 BN103
deduction. BN104 BN105
BN145 BN150
The system uses this field to define BN245 BN31.1
custom data or a specific tax BN31.2 BN32.1
calculation for a tax authority. BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-FILING-STATUS Numeric 1 AC541 AC542
Filing Status Contains the employee's filing status. BN100 BN101
BN102 BN103
The system uses the value in the Filing BN104 BN105
Status field to determine the amount of BN145 BN150
wages protected according to the Federal BN245 BN31.1
Tax Levy Exempt Wage Tables. BN31.2 BN32.1
1 = Single BN32.2 BN32.3
2 = Married - separately BN45.1 BN531
3 = Married - joint/ widow(er) BN65.1 BN71.1
4 = Unmarried head of household BN72.1 BS13.1
5 = Single 65+ or blind BS14.1 BS15.1
6 = Head of household 65+ or blind BS32.1 HR11.1
7 = M - separately 65+ or blind HR11.2 HR511
8 = M-joint/widow(er) 65+ or blind HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-LEVY-EXEMPTS Numeric 2 AC541 AC542
Levy Exempts Contains the number of levy exemptions BN100 BN101
for the employee. The system uses the BN102 BN103
value in this field to determine the BN104 BN105
amount of wages protected according to BN145 BN150
the Federal Tax Levy Exempt Wage Tables. BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-LEVY-YEAR Numeric 4 AC541 AC542
Levy Year Contains the effective year of the BN100 BN101
exempt wage table used for the BN102 BN103
deduction. If a year is not entered, the BN104 BN105
system uses the most current year table BN145 BN150
available based on the current payroll BN245 BN31.1
year defined for the company. BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-ADDL-STD-DED Numeric 1 AC541 AC542
Addl Std Ded Contains additional standard deductions BN100 BN101
defined for the employee for tax levy BN102 BN103
garnishment deductions. An employee can BN104 BN105
have up to 4 additional deductions. BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-OBJ-ID Numeric 12 AC541 AC542
Object This is the object identifier. It is BN100 BN101
Identification used to relate commitments or posted BN102 BN103
transactions back to the originating BN104 BN105
subsystems. Each subsystem record that BN145 BN150
is updated as a commitment or posted BN245 BN31.1
transaction is assigned an object BN31.2 BN32.1
identifier. The object identifier is BN32.2 BN32.3
maintained in the subsystem files and in BN45.1 BN531
the Activity Commitments Detail and BN65.1 BN71.1
Activity Transaction files. The object BN72.1 BS13.1
identifier is a unique key used to drill BS14.1 BS15.1
back from Activity Management to the BS32.1 HR11.1
subsystems. HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-EXP-DIST-CO Numeric 4 AC541 AC542
Exp Dist Co Contains the value from the Expense BN100 BN101
Distribution Company field in the BN102 BN103
Deduction file. The value is stored in BN104 BN105
this file for efficiency purposes. BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-EXP-ACCT-UNIT Alpha 15 AC541 AC542
Expense Accounting Contains the value from the Expense BN100 BN101
Unit Accounting Unit field in the Deduction BN102 BN103
file. The value is stored in this file BN104 BN105
for efficiency purposes. BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-EXP-ACCOUNT Numeric 6 AC541 AC542
Expense Account Contains the value from the Expense BN100 BN101
Account field in the Deduction file. The BN102 BN103
value is stored in this file for BN104 BN105
efficiency purposes. BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-EXP-SUB-ACCT Numeric 4 AC541 AC542
Expense Subaccount Contains the value from the Expense BN100 BN101
Subaccount field in the Deduction file. BN102 BN103
The value is stored in this file for BN104 BN105
efficiency purposes. BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-ACR-DIST-CO Numeric 4 AC541 AC542
Acr Dist Co Contains the value from the Accrual BN100 BN101
Distribution Company field in the BN102 BN103
deduction file. BN104 BN105
BN145 BN150
The value is stored in this file for BN245 BN31.1
efficiency purposes. BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-ACR-ACCT-UNIT Alpha 15 AC541 AC542
Accrual Accounting Contains the value from the Accrual BN100 BN101
Unit Accounting Unit field in the Deduction BN102 BN103
file. The value is stored in this file BN104 BN105
for efficiency purposes. BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-ACR-ACCOUNT Numeric 6 AC541 AC542
Accrual Account Contains the value from the Accrual BN100 BN101
Number Account field in the Deduction file. The BN102 BN103
value is stored in this file for BN104 BN105
efficiency purposes. BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-ACR-SUB-ACCT Numeric 4 AC541 AC542
Accrual Subaccount Contains the value from the Accrual BN100 BN101
Number Subaccount field in the Deduction file. BN102 BN103
The value is stored in this file for BN104 BN105
efficiency purposes. BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR114 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR189 PR205
...
EDM-SUB-PRIORITY Numeric 2 AC541 AC542
Sub Priority Defines the order in which deductions BN100 BN101
are withheld within the same priority BN102 BN103
for an employee. BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-GARN-OBJ-ID Numeric 12 AC541 AC542
Garn Obj Id Assigned when an employee garnishment BN100 BN101
table (PREMPGARN) is added and BN102 BN103
deductions are created. This ID links BN104 BN105
the employee deductions to this BN145 BN150
garnishment (case number/file number). BN245 BN31.1
If the same deduction is created for BN31.2 BN32.1
this employee, this ID along with the BN32.2 BN32.3
sequence number keeps the record unique. BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-AMOUNT-2 Signed 13.4 AC541 AC542
Amount 2 Used for calculation types 1 and 2. BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-NET-CLAIM-AMT Signed 11.2 AC541 AC542
Net Claim Amt This field is used for Canada income BN100 BN101
taxes. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-PRESCRIBEDAREA Signed 11.2 AC541 AC542
Prescribedarea BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-STUDENT-PEN-EX Signed 9.2 AC541 AC542
Student Pen Ex BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-TD1-FILING-DAT Numeric 8 (yyyymmdd) AC541 AC542
Td1 Filing Dat BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-TD1-ADJUST-DAT Numeric 8 (yyyymmdd) AC541 AC542
Td1 Adjust Dat BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-APPROVED-STOCK Signed 9.2 AC541 AC542
Approved Stock BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-TAX-EXEMPT-FLG Alpha 1 AC541 AC542
Tax Exempt Flg N = No BN100 BN101
Y = Yes BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-CYC1 Derived
Cycle 1
EDM-CYC2 Derived
Cycle 2
EDM-CYC3 Derived
Cycle 3
EDM-CYC4 Derived
Cycle 4
EDM-CYC5 Derived
Cycle 5
EDM-CYC6 Derived
Cycle 6
EDM-CYC7 Derived
Cycle 7
EDM-CYC8 Derived
Cycle 8
EDM-CYC9 Derived
Cycle 9
EDM-DED-DESC Derived
Ded Desc
EDM-AUTH-TAX-CRED Signed 9.2 AC541 AC542
Auth Tax Cred BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-AUTH-TAX-DED Signed 9.2 AC541 AC542
Auth Tax Ded BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-MARRIED-EQUIV Alpha 1 AC541 AC542
Married Equiv N = No BN100 BN101
Y = Yes BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-AGE-65-OVER Alpha 1 AC541 AC542
Age 65 Over N = No BN100 BN101
Y = Yes BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-EMP-DISABILITY Alpha 1 AC541 AC542
Emp Disability N = No BN100 BN101
Y = Yes BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-DEP-UNDER-18 Numeric 2 AC541 AC542
Dep Under 18 BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-DEP-DIS-OVR-17 Numeric 2 AC541 AC542
Dep Dis Ovr 17 BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-CURRENCY-CODE Alpha 5 AC541 AC542
Currency Code This field contains the company base BN100 BN101
currency code established in Company BN102 BN103
(GL10.1 ). BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EDM-CURR-ND Numeric 1 AC541 AC542
Currency Number of Represents the number of decimals BN100 BN101
Decimals defined for the currency of the object. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR189
PR205 PR26.1
...
EMDEDMASTR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EDMSET1 COMPANY AC541 AC542
EMPLOYEE BN100 BN101
DED-CODE BN102 BN103
SEQ-NBR BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN400 BN430
BN45.1 BN500
BN51.2 BN531
BN65.1 BN66.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
...
EDMSET2 COMPANY BN10.1 PR02.1
DED-CODE PR05.1 PR114
EMPLOYEE PR115 PR15.1
SEQ-NBR PR160 PR180
PR80.2
EDMSET3 COMPANY KeyChange AC541 AC542
EMPLOYEE BN100 BN101
DED-ORDER BN102 BN103
DED-PRIORITY BN104 BN105
SUB-PRIORITY BN145 BN150
DED-CODE BN245 BN31.1
SEQ-NBR BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN66.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR511 HR650
...
EDMSET4 OBJ-ID KeyChange BN400 HR170
HR70.1 PR280
EMDEDMASTR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accrual Acct GLMASTER Required
When EDM-ACR-ACCT-UNIT != Spaces
Or EDM-ACR-ACCOUNT != Zeroes
EDM-COMPANY -> GLM-COMPANY
EDM-ACR-ACCT-UNIT -> GLM-ACCT-UNIT
EDM-ACR-ACCOUNT -> GLM-ACCOUNT
EDM-ACR-SUB-ACCT -> GLM-SUB-ACCOUNT
Company PRSYSTEM Required
EDM-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Deduction Code DEDCODE Required
EDM-COMPANY -> DDC-COMPANY
EDM-DED-CODE -> DDC-DED-CODE
Employee EMPLOYEE Required
EDM-COMPANY -> EMP-COMPANY
EDM-EMPLOYEE -> EMP-EMPLOYEE
Expense Acct GLMASTER Required
When EDM-EXP-ACCT-UNIT != Spaces
Or EDM-EXP-ACCOUNT != Zeroes
EDM-COMPANY -> GLM-COMPANY
EDM-EXP-ACCT-UNIT -> GLM-ACCT-UNIT
EDM-EXP-ACCOUNT -> GLM-ACCOUNT
EDM-EXP-SUB-ACCT -> GLM-SUB-ACCOUNT
EMDEDMASTR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cur Ytd Hist PREMDEDHST
EDM-COMPANY -> PDH-COMPANY
EDM-EMPLOYEE -> PDH-EMPLOYEE
EDM-DED-CODE -> PDH-DED-CODE
EDM-SEQ-NBR -> PDH-SEQ-NBR
PRS-PAYROLL-YEAR -> PDH-YEAR
Zeroes -> PDH-MONTH
PDH-REPORT-ENTITY
Deduct Detail PAYDEDUCTN Delete Restricted
EDM-COMPANY -> PYD-COMPANY
EDM-EMPLOYEE -> PYD-EMPLOYEE
EDM-DED-CODE -> PYD-DED-CODE
EDM-SEQ-NBR -> PYD-EDM-SEQ-NBR
PYD-CHECK-ID
PYD-REPORT-ENTITY
PYD-BUS-NBR-GRP
PYD-QC-ENT-NBR-GRP
PYD-PROCESS-LEVEL
PYD-WORK-STATE
Emp Ded Hist PREMDEDHST Delete Restricted
EDM-COMPANY -> PDH-COMPANY
EDM-EMPLOYEE -> PDH-EMPLOYEE
EDM-DED-CODE -> PDH-DED-CODE
EDM-SEQ-NBR -> PDH-SEQ-NBR
PDH-YEAR
PDH-MONTH
PDH-REPORT-ENTITY
Quartded QUARTDED
EDM-COMPANY -> QTD-COMPANY
EMP-WORK-COUNTRY -> QTD-COUNTRY-CODE
PRS-PAYROLL-YEAR -> QTD-PAYROLL-YEAR
EDM-EMPLOYEE -> QTD-EMPLOYEE
EDM-DED-CODE -> QTD-DED-CODE
QTD-QUARTER
QTD-REPORT-ENTITY
QTD-BUS-NBR-GRP
QTD-QC-ENT-NBR-GRP
QTD-PROCESS-LEVEL
QTD-WORK-STATE
QTD-PENSION
|