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
PR11.1 PR139 PR140 PR141 PR160 PR180
PR214 PR226 PR260 PR277 PR297 PR298
PR80.1 PR80.2 PR89.1 BN10.1 PR02.1 PR05.1
BN150 PR128 PR131 PR132 PR134 PR136
PR32.2 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR36.1 PR530
UK102 UK120 PR280
UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 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 HR511 PA100 PA52.1 PA52.4 PA52.5
PR114 PR115 PR13.1 PR13.2 PR14.1 PR15.1
PR15.2 PR150 PR195 PR199 PR205 PR26.1
PR26.2 PR39.1 PR39.2 PR514 PR560 PR82.1
PR85.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EDM-COMPANY Numeric 4 BN100 BN101
Company The company number represents an BN102 BN103
established company and is entered on BN104 BN105
all function codes. BN145 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
HR511 PA100
PA52.1 PA52.4
PA52.5 PR114
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
PR560
EDM-EMPLOYEE Numeric 9 BN100 BN101
Employee Contains the employee number. BN102 BN103
BN104 BN105
BN145 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
HR511 PA100
PA52.1 PA52.4
PA52.5 PR114
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
PR560
EDM-DED-CODE Alpha 4 BN100 BN101
Deduction Contains the user-defined value that BN102 BN103
represents a deduction. BN104 BN105
BN145 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
HR511 PA100
PA52.1 PA52.4
PA52.5 PR114
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
PR560
EDM-SEQ-NBR Numeric 4 BN100 BN101
Sequence Number Contains the deduction sequence number. BN102 BN103
The value of this field is always zeros BN104 BN105
if created through the Payroll system BN145 BN245
because the system allows entry of only BN31.1 BN31.2
one employee deduction record for a BN32.1 BN32.2
deduction. In the Benefits system, many BN32.3 BN45.1
employee deductions can exist for the BN500 BN531
same deduction with non-overlapping BN65.1 BN71.1
effective and ending dates. Therefore, BN72.1 BS13.1
this field is needed to maintain BS14.1 BS15.1
uniqueness. When you create records BS32.1 HR11.1
through the Benefits system, the system HR511 PA100
automatically sequences this field based PA52.1 PA52.4
on the last employee deduction sequence PA52.5 PR114
number. PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-DED-CYCLE Alpha 1 Occurs 9 Times BN100 BN101
Deduction Cycle Contains the value that indicates in BN102 BN103
which cycles a deduction is taken. The BN104 BN105
value in this field defaults from the BN145 BN245
Deduction Cycles field in the Deduction BN31.1 BN31.2
file but you can override the value for BN32.1 BN32.2
each employee deduction. Valid values BN32.3 BN45.1
are: BN500 BN531
BN65.1 BN71.1
X - The system takes the deduction and BN72.1 BS13.1
updates taxable wages for withholding BS14.1 BS15.1
type deductions. On a non-tax deduction, BS32.1 HR11.1
the system takes the deduction. HR511 PA100
PA52.1 PA52.4
T - The system does not take the PA52.5 PR115
deduction but updates taxable wages for PR13.1 PR13.2
withholding type deductions. PR14.1 PR15.1
PR15.2 PR205
Blank - The system does not take the PR26.1 PR39.1
deduction and does not update taxable PR39.2 PR514
wages for withholding type deductions. PR560
On a non-tax deduction, the system does
not take the deduction.
EDM-BALANCE-TYPE Alpha 1 BN100 BN101
Balance Type Contains the value that determines how BN102 BN103
the deduction affects the Balance Amount BN104 BN105
field. BN145 BN245
A = Ascending Balance BN31.1 BN31.2
D = Descending Balance BN32.1 BN32.2
L = Limit BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-BALANCE-AMT Signed 11.2 BN100 BN101
Balance Amount Contains the balance amount for BN102 BN103
deductions that have a balance type. BN104 BN105
BN145 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
HR511 PA100
PA52.1 PA52.4
PA52.5 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR150 PR195
PR199 PR205
PR26.1 PR39.1
PR39.2 PR514
PR82.1 PR85.1
EDM-NEXT-AMOUNT Signed 13.4 BN100 BN101
Amount or Percent Contains the amount or percent to be BN102 BN103
deducted. The calculation type defined BN104 BN105
for the deduction determines if the BN145 BN245
value is an amount or a percent. The BN31.1 BN31.2
value in this field defaults from the BN32.1 BN32.2
Amount or Percent field in the Deduction BN32.3 BN45.1
file but you can override the value for BN500 BN531
each employee deduction. BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR511 PA100
PA52.1 PA52.4
PA52.5 PR114
PR115 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514 PR560
EDM-DED-PRIORITY Numeric 1 BN100 BN101
Priority Contains the value that indicates the BN102 BN103
order in which deductions are processed BN104 BN105
within the following categories: BN145 BN245
withholding type deductions, deductions BN31.1 BN31.2
that are excluded from disposable BN32.1 BN32.2
income, garnishment deductions, all BN32.3 BN45.1
other deductions, all one-time BN500 BN531
deductions, and all company matching BN65.1 BN71.1
deductions. BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR511 PA100
PA52.1 PA52.4
PA52.5 PR114
PR115 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514 PR560
EDM-EFFECT-DATE Numeric 8 (yyyymmdd) BN100 BN101
Effective Date Contains the effective date of the BN102 BN103
deduction. The value in this field BN104 BN105
defaults from the deduction Effective BN145 BN245
Date - Beginning field on the More form BN31.1 BN31.2
tab on PR05.1 (Deduction) but you can BN32.1 BN32.2
override the value for each employee BN32.3 BN45.1
deduction. BN500 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR511 PA100
PA52.1 PA52.4
PA52.5 PR114
PR115 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514 PR560
EDM-END-DATE Numeric 8 (yyyymmdd) BN100 BN101
Ending Date Contains the last date the deduction BN102 BN103
can be taken. The value in this field BN104 BN105
defaults from the deduction Effective BN145 BN245
Date - Ending field on the More form tab BN31.1 BN31.2
on PR05.1 (Deduction) but you can BN32.1 BN32.2
override the value for each employee BN32.3 BN45.1
deduction. BN500 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR511 PA100
PA52.1 PA52.4
PA52.5 PR114
PR115 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514 PR560
EDM-ARREARS Alpha 1 BN100 BN101
Arrears Contains the value that determines if BN102 BN103
the system places the deduction in BN104 BN105
arrears if it cannot take the deduction BN145 BN245
in its entirety, and whether the system BN31.1 BN31.2
takes all, nothing, or as much of the BN32.1 BN32.2
deduction as possible. The value in this BN32.3 BN45.1
field defaults from the Arrears field in BN500 BN531
the Deduction file but you can override BN65.1 BN71.1
the value for each employee deduction. BN72.1 BS13.1
A = All Or None - Create Arrears BS14.1 BS15.1
D = All Or None - No Arrears BS32.1 HR11.1
N = Net To Zero - No Arrears HR511 PA100
Y = Net To Zero - Create Arrears PA52.1 PA52.4
PA52.5 PR114
PR115 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514 PR560
EDM-PCT-MATCHED Signed 5.2 BN100 BN101
Percentage Matched Contains the percent to be matched by BN102 BN103
the company. The Benefits system is the BN104 BN105
only system that moves a value to this BN145 BN245
field. The system uses this field to BN31.1 BN31.2
calculate company-matched deductions BN32.1 BN32.2
when a company limit is defined as a BN32.3 BN45.1
percent of the employee's gross pay or a BN531 BN65.1
percent of a specific pay class for an BN71.1 BN72.1
employee. BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-MONTHLY-LIMIT Signed 11.2 BN100 BN101
Monthly Limit Contains the monthly limit that can be BN102 BN103
taken for the deduction in a single BN104 BN105
month. The value in this field defaults BN145 BN245
from the Monthly Limit field in the BN31.1 BN31.2
Deduction file but you can override the BN32.1 BN32.2
value for each employee deduction. BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR115 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-PAY-PRD-LIMIT Signed 11.2 BN100 BN101
Pay Period Limit Contains the deduction limit that can BN102 BN103
be taken in a pay period. The value in BN104 BN105
this field defaults from the Payment BN145 BN245
Limit field in the Deduction file but BN31.1 BN31.2
you can override the value for each BN32.1 BN32.2
employee deduction. BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR115 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-PRIORITY-FLAG Alpha 1 BN100 BN101
Priority Flag A value in this field indicates that BN102 BN103
the value in the Priority field did not BN104 BN105
default from the Priority field in the BN145 BN245
Deduction file and therefore is not BN31.1 BN31.2
updated if you change the deduction. BN32.1 BN32.2
X = Deduction Code Override BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-ARREARS-FLAG Alpha 1 BN100 BN101
Arrears Indicator A value in this field indicates that BN102 BN103
Override the value in the Arrears field did not BN104 BN105
default from the Arrears field in the BN145 BN245
Deduction file and therefore is not BN31.1 BN31.2
updated if you change the deduction. BN32.1 BN32.2
X = Deduction Code Override BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-EFF-DATE-FLAG Alpha 1 BN100 BN101
Effective Date Flag A value in this field indicates that BN102 BN103
the value in the Begin Date field did BN104 BN105
not default from the Begin Date field in BN145 BN245
the Deduction file and therefore is not BN31.1 BN31.2
updated if you change the deduction. BN32.1 BN32.2
X = Deduction Code Override BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-END-DATE-FLAG Alpha 1 BN100 BN101
End Date Flag A value in this field indicates that BN102 BN103
the value in the End Date field did not BN104 BN105
default from the End Date field in the BN145 BN245
Deduction file and therefore is not BN31.1 BN31.2
updated if you change the deduction. BN32.1 BN32.2
X = Deduction Code Override BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514 PR560
EDM-DED-CYC-FLAG Alpha 1 BN100 BN101
Deduction Cycle Flag A value in this field indicates that BN102 BN103
the value in the Deduction Cycles fields BN104 BN105
did not default from the Deduction BN145 BN245
Cycles fields in the Deduction file and BN31.1 BN31.2
therefore is not updated if you change BN32.1 BN32.2
the deduction. BN32.3 BN45.1
X = Deduction Code Override BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-AMOUNT-FLAG Alpha 1 BN100 BN101
Amount Flag A value in this field indicates that BN102 BN103
the value in the Amount or Percent field BN104 BN105
did not default from the Amount or BN145 BN245
Percent field in the Deduction file and BN31.1 BN31.2
therefore is not updated if you change BN32.1 BN32.2
the deduction. BN32.3 BN45.1
X = Deduction Code Override BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
PR560
EDM-MTH-LIMIT-FLAG Alpha 1 BN100 BN101
Mth Limit Flag A value in this field indicates that BN102 BN103
the value in the Monthly Limit field did BN104 BN105
not default from the Monthly Limit field BN145 BN245
in the Deduction file and therefore is BN31.1 BN31.2
not updated if you change the deduction. 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-PRD-LIMIT-FLAG Alpha 1 BN100 BN101
Pay Period Limit A value in this field indicates that BN102 BN103
Flag the value in the Payment Limit Flag BN104 BN105
field did not default from the Payment BN145 BN245
Limit Flag field in the Deduction file BN31.1 BN31.2
and therefore is not updated if you BN32.1 BN32.2
change the deduction. BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-DED-ORDER Numeric 1 BN100 BN101
Ded Order Insures that the system processes BN102 BN103
withholding deductions first. BN104 BN105
BN145 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
HR511 PA100
PA52.1 PA52.4
PA52.5 PR114
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
PR560
EDM-RES-CODE Alpha 1 BN100 BN101
Res Code Contains the value that indicates if BN102 BN103
the employee is a resident of the tax BN104 BN105
authority associated with the deduction. BN145 BN245
Y = Resident BN31.1 BN31.2
N = Non-Resident 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-MARITAL-STATUS Numeric 2 BN100 BN101
Marital Status Contains the marital status associated BN102 BN103
with the employee's tax deduction. BN104 BN105
01 = Single BN145 BN245
02 = Married BN31.1 BN31.2
03 = Married Filing Separate BN32.1 BN32.2
04 = Married Both Spouses Working BN32.3 BN45.1
05 = Married One Spouse Working BN531 BN65.1
06 = Head of Household BN71.1 BN72.1
07 = Married Multiple Employers BS13.1 BS14.1
08 = Widow or Widower BS15.1 BS32.1
09 = Married Not Living With Spouse HR11.1 HR511
10 = Married Joint Claiming All PA100 PA52.1
11 = Married Joint Claiming Half PA52.4 PA52.5
12 = Married Separate Claiming All PR13.1 PR13.2
13 = Married Joint Claiming None PR14.1 PR15.1
14 = Married Living With Spouse PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
PR560
EDM-EXEMPTIONS Numeric 5 BN100 BN101
Exemptions Contains the number of exemptions BN102 BN103
associated with the employee's tax BN104 BN105
deduction. BN145 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-EXEMPT-AMOUNT Signed 9.2 BN100 BN101
Exempt Amount Contains the exempt amount associated BN102 BN103
with the employee's tax deduction. BN104 BN105
BN145 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-CERT-CODE Numeric 1 BN100 BN101
Cert Code Contains the value that indicates the BN102 BN103
employee has on file, a certificate BN104 BN105
verifying the employee is a nonresident BN145 BN245
of the tax authority, is exempt from BN31.1 BN31.2
withholding, or receives a withholding BN32.1 BN32.2
tax credit for the tax authority BN32.3 BN45.1
associated with the deduction. BN531 BN65.1
0 = No Certificate BN71.1 BN72.1
1 = Certificate of Non-Residence BS13.1 BS14.1
2 = Exempt From Withholding BS15.1 BS32.1
3 = Withholding Tax Credit HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-PERS-EXEMPTS Numeric 1 BN100 BN101
Pers Exempts Contains the number of personal BN102 BN103
exemptions defined for the employee BN104 BN105
deduction. BN145 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-DEPEND-EXEMPTS Numeric 5 BN100 BN101
Depend Exempts Contains the number of dependent BN102 BN103
exemptions defined for the employee BN104 BN105
deduction. BN145 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-ADDL-EXEMPTS Numeric 5 BN100 BN101
Addl Exempts Contains the number of additional BN102 BN103
exemptions defined for the employee BN104 BN105
deduction. BN145 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-ADDL-EXEMP-AMT Signed 9.2 BN100 BN101
Addl Exemp Amt Contains the additional exemption BN102 BN103
amount defined for the employee BN104 BN105
deduction. BN145 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-ADDL-TAX-CODE Numeric 2 BN100 BN101
Addl Tax Code Contains additional tax codes BN102 BN103
associated with the employee deduction. BN104 BN105
The tax code indicates if the additional BN145 BN245
tax is an additional, replacement, or BN31.1 BN31.2
exempt amount. BN32.1 BN32.2
01 = Replacement Amount BN32.3 BN45.1
02 = Additional Amount BN531 BN65.1
03 = Replacement Percent BN71.1 BN72.1
04 = Additional Percent BS13.1 BS14.1
05 = Replacement Amount and Percent BS15.1 BS32.1
06 = Exempt Amount HR11.1 HR511
07 = Exempt Percent PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-ADDL-RATE Signed 7.4 BN100 BN101
Addl Rate Contains a value if the Addl Tax Code BN102 BN103
field value indicates a percent. BN104 BN105
BN145 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-ADDL-AMOUNT Signed 9.2 BN100 BN101
Addl Amount Contains a value if the Addl Tax Code BN102 BN103
field value indicates an amount. BN104 BN105
BN145 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-FORMULA-NUMBER Numeric 1 BN100 BN101
Formula Number Contains the value that identifies the BN102 BN103
formula used in calculating the BN104 BN105
deduction. BN145 BN245
BN31.1 BN31.2
The system uses this field to define BN32.1 BN32.2
custom data or a specific tax BN32.3 BN45.1
calculation for a tax authority. BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-FILING-STATUS Numeric 1 BN100 BN101
Filing Status Contains the employee's filing status. BN102 BN103
BN104 BN105
The system uses the value in the Filing BN145 BN245
Status field to determine the amount of BN31.1 BN31.2
wages protected according to the Federal BN32.1 BN32.2
Tax Levy Exempt Wage Tables. BN32.3 BN45.1
1 = Single BN531 BN65.1
2 = Married - separately BN71.1 BN72.1
3 = Married - joint/ widow(er) BS13.1 BS14.1
4 = Unmarried head of household BS15.1 BS32.1
5 = Single 65+ or blind HR11.1 HR511
6 = Head of household 65+ or blind PA100 PA52.1
7 = M - separately 65+ or blind PA52.4 PA52.5
8 = M-joint/widow(er) 65+ or blind PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-LEVY-EXEMPTS Numeric 2 BN100 BN101
Levy Exempts Contains the number of levy exemptions BN102 BN103
for the employee. The system uses the BN104 BN105
value in this field to determine the BN145 BN245
amount of wages protected according to BN31.1 BN31.2
the Federal Tax Levy Exempt Wage Tables. 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-LEVY-YEAR Numeric 4 BN100 BN101
Levy Year Contains the effective year of the BN102 BN103
exempt wage table used for the BN104 BN105
deduction. If a year is not entered, the BN145 BN245
system uses the most current year table BN31.1 BN31.2
available based on the current payroll BN32.1 BN32.2
year defined for the company. BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-ADDL-STD-DED Numeric 1 BN100 BN101
Addl Std Ded Contains additional standard deductions BN102 BN103
defined for the employee for tax levy BN104 BN105
garnishment deductions. An employee can BN145 BN245
have up to 4 additional deductions. 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-OBJ-ID Numeric 12 BN100 BN101
Object This is the object identifier. It is BN102 BN103
Identification used to relate commitments or posted BN104 BN105
transactions back to the originating BN145 BN245
subsystems. Each subsystem record that BN31.1 BN31.2
is updated as a commitment or posted BN32.1 BN32.2
transaction is assigned an object BN32.3 BN45.1
identifier. The object identifier is BN531 BN65.1
maintained in the subsystem files and in BN71.1 BN72.1
the Activity Commitments Detail and BS13.1 BS14.1
Activity Transaction files. The object BS15.1 BS32.1
identifier is a unique key used to drill HR11.1 HR511
back from Activity Management to the PA100 PA52.1
subsystems. PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514 PR560
EDM-EXP-DIST-CO Numeric 4 BN100 BN101
Exp Dist Co Contains the value from the Expense BN102 BN103
Distribution Company field in the BN104 BN105
Deduction file. The value is stored in BN145 BN245
this file for efficiency purposes. 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-EXP-ACCT-UNIT Alpha 15 BN100 BN101
Expense Accounting Contains the value from the Expense BN102 BN103
Unit Accounting Unit field in the Deduction BN104 BN105
file. The value is stored in this file BN145 BN245
for efficiency purposes. 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-EXP-ACCOUNT Numeric 6 BN100 BN101
Expense Account Contains the value from the Expense BN102 BN103
Account field in the Deduction file. The BN104 BN105
value is stored in this file for BN145 BN245
efficiency purposes. 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-EXP-SUB-ACCT Numeric 4 BN100 BN101
Expense Subaccount Contains the value from the Expense BN102 BN103
Subaccount field in the Deduction file. BN104 BN105
The value is stored in this file for BN145 BN245
efficiency purposes. 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-ACR-DIST-CO Numeric 4 BN100 BN101
Acr Dist Co Contains the value from the Accrual BN102 BN103
Distribution Company field in the BN104 BN105
deduction file. BN145 BN245
BN31.1 BN31.2
The value is stored in this file for BN32.1 BN32.2
efficiency purposes. BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-ACR-ACCT-UNIT Alpha 15 BN100 BN101
Accrual Accounting Contains the value from the Accrual BN102 BN103
Unit Accounting Unit field in the Deduction BN104 BN105
file. The value is stored in this file BN145 BN245
for efficiency purposes. 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-ACR-ACCOUNT Numeric 6 BN100 BN101
Accrual Account Contains the value from the Accrual BN102 BN103
Number Account field in the Deduction file. The BN104 BN105
value is stored in this file for BN145 BN245
efficiency purposes. 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-ACR-SUB-ACCT Numeric 4 BN100 BN101
Accrual Subaccount Contains the value from the Accrual BN102 BN103
Number Subaccount field in the Deduction file. BN104 BN105
The value is stored in this file for BN145 BN245
efficiency purposes. 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR114 PR13.1
PR13.2 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR39.1 PR39.2
PR514
EDM-SUB-PRIORITY Numeric 2 BN100 BN101
Sub Priority Defines the order in which deductions BN102 BN103
are withheld within the same priority BN104 BN105
for an employee. BN145 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR26.2
PR39.1 PR39.2
PR514
EDM-GARN-OBJ-ID Numeric 12 BN100 BN101
Garn Obj Id Assigned when an employee garnishment BN102 BN103
table (PREMPGARN) is added and BN104 BN105
deductions are created. This ID links BN145 BN245
the employee deductions to this BN31.1 BN31.2
garnishment (case number/file number). BN32.1 BN32.2
If the same deduction is created for BN32.3 BN45.1
this employee, this ID along with the BN531 BN65.1
sequence number keeps the record unique. BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
EDM-AMOUNT-2 Signed 13.4 BN100 BN101
Amount 2 Used for calculation types 1 and 2. BN102 BN103
BN104 BN105
BN145 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 HR511
PA100 PA52.1
PA52.4 PA52.5
PR13.1 PR13.2
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR39.1
PR39.2 PR514
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-CUR-YTD-AMT Derived
Cur Ytd Amt
EDM-CUR-YTD-TXBL Derived
Cur Ytd Txbl
EDM-DED-DESC Derived
Ded Desc
EMDEDMASTR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EDMSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
DED-CODE BN104 BN105
SEQ-NBR BN145 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 HR11.1
HR170 HR211
...
EDMSET2 COMPANY BN10.1 PR02.1
DED-CODE PR05.1 PR114
EMPLOYEE PR115 PR15.1
SEQ-NBR PR160 PR180
PR80.2
EDMSET3 COMPANY KeyChange BN100 BN101
EMPLOYEE BN102 BN103
DED-ORDER BN104 BN105
DED-PRIORITY BN145 BN150
SUB-PRIORITY BN245 BN31.1
DED-CODE BN31.2 BN32.1
SEQ-NBR BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR511 PA100
PA52.1 PA52.4
PA52.5 PR128
...
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
Cur Ytd Hist PREMDEDHST Not Required
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
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
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-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
Quartded QUARTDED
EDM-COMPANY -> QTD-COMPANY
PRS-PAYROLL-YEAR -> QTD-PAYROLL-YEAR
EDM-EMPLOYEE -> QTD-EMPLOYEE
EDM-DED-CODE -> QTD-DED-CODE
QTD-QUARTER
QTD-PROCESS-LEVEL
QTD-WORK-STATE
Tax Group PRTAXGRP Delete Cascades
EDM-COMPANY -> PXG-COMPANY
EDM-EMPLOYEE -> PXG-EMPLOYEE
EDM-DED-CODE -> PXG-DED-CODE
PXG-TAX-GROUP
|