Lawson Insight Technical Documentation |
|
EMDEDMASTR
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
BN51.2 BN66.1 HR211 PR139 PR140 PR141
PR160 PR180 PR214 PR226 PR239 PR240
PR241 PR247 PR260 PR261 PR277 PR299
PR89.1 UK141 UK201 UK202 UK277 PR02.1
PR05.1 HR170 HR70.1 PR280
UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN245 BN305 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN430 BN45.1 BN531
BN65.1 BN71.1 BN72.1 BS13.1 BS14.1 BS15.1
BS32.1 ET530 ETI1.1 ETI2.1 HR11.1 HR11.2
HR511 LP130 PA02.1 PA100 PA102 PA115
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 PR14.2 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 PR35.9 PR36.1 PR39.1
PR39.2 PR45.1 PR47.1 PR47.2 PR514 PR529
PR530 PR539 PR560 PR80.1 PR80.3 PR82.1
PR85.1 UK102 UK13.1 UK145 UK183 UK184
UK47.1 UK47.2 UK560 TA147
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EDM-COMPANY Numeric 4 BN100 BN101
Element: Company Hr BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-EMPLOYEE Numeric 9 BN100 BN101
Element: Employee Contains the employee number. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-DED-CODE Alpha 4 BN100 BN101
Element: Deduction Contains the user-defined value that BN102 BN103
represents a deduction. BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-SEQ-NBR Numeric 4 BN100 BN101
Element: Seq Nbr Contains the deduction sequence number. BN102 BN103
The value of this field is always zeros BN104 BN105
if created through the Payroll system BN145 BN150
because the system allows entry of only BN245 BN305
one employee deduction record for a BN31.1 BN31.2
deduction. In the Benefits system, many BN32.1 BN32.2
employee deductions can exist for the BN32.3 BN45.1
same deduction with non-overlapping BN531 BN65.1
effective and ending dates. Therefore, BN71.1 BN72.1
this field is needed to maintain BS13.1 BS14.1
uniqueness. When you create records BS15.1 BS32.1
through the Benefits system, the system ET530 ETI1.1
automatically sequences this field based ETI2.1 HR11.1
on the last employee deduction sequence HR11.2 HR511
number. LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-DED-CYCLE Alpha 1 Occurs 9 Times BN100 BN101
Element: Ded 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 BN150
Deduction Cycles field in the Deduction BN245 BN305
file but you can override the value for BN31.1 BN31.2
each employee deduction. Valid values BN32.1 BN32.2
are: BN32.3 BN45.1
BN531 BN65.1
X - The system takes the deduction and BN71.1 BN72.1
updates taxable wages for withholding BS13.1 BS14.1
type deductions. On a non-tax deduction, BS15.1 BS32.1
the system takes the deduction. ET530 ETI1.1
ETI2.1 HR11.1
T - The system does not take the HR11.2 HR511
deduction but updates taxable wages for LP130 PA02.1
withholding type deductions. PA100 PA102
PA115 PA13.1
Blank - The system does not take the PA13.2 PA502
deduction and does not update taxable PA513 PA52.1
wages for withholding type deductions. PA52.3 PA52.4
On a non-tax deduction, the system does PA52.5 PR110
not take the deduction. PR113 PR115
PR120 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR14.2
...
EDM-BALANCE-TYPE Alpha 1 BN100 BN101
Element: Balance Type Contains the value that determines how BN102 BN103
the deduction affects the Balance Amount BN104 BN105
field. BN145 BN150
A = Ascending Balance BN245 BN305
D = Descending Balance BN31.1 BN31.2
L = Limit BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-BALANCE-AMT Signed 18.2 BN100 BN101
Element: Intl Amt Contains the balance amount for BN102 BN103
deductions that have a balance type. BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-NEXT-AMOUNT Signed 13.4 BN100 BN101
Element: Amount or PercContains the amount or percent to be BN102 BN103
deducted. The calculation type defined BN104 BN105
for the deduction determines if the BN145 BN150
value is an amount or a percent. The BN245 BN305
value in this field defaults from the BN31.1 BN31.2
Amount or Percent field in the Deduction BN32.1 BN32.2
file but you can override the value for BN32.3 BN45.1
each employee deduction. BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
...
EDM-DED-PRIORITY Numeric 1 BN100 BN101
Element: Priority Contains the value that indicates the BN102 BN103
order in which deductions are processed BN104 BN105
within the following categories: BN145 BN150
withholding type deductions, deductions BN245 BN305
that are excluded from disposable BN31.1 BN31.2
income, garnishment deductions, all BN32.1 BN32.2
other deductions, all one-time BN32.3 BN45.1
deductions, and all company matching BN531 BN65.1
deductions. BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
...
EDM-EFFECT-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: Effect Date Contains the effective date of the BN102 BN103
deduction. The value in this field BN104 BN105
defaults from the deduction Effective BN145 BN150
Date - Beginning field on the More form BN245 BN305
tab on PR05.1 (Deduction) but you can BN31.1 BN31.2
override the value for each employee BN32.1 BN32.2
deduction. BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
...
EDM-END-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: End 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 BN150
Date - Ending field on the More form tab BN245 BN305
on PR05.1 (Deduction) but you can BN31.1 BN31.2
override the value for each employee BN32.1 BN32.2
deduction. BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
...
EDM-ARREARS Alpha 1 BN100 BN101
Element: 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 BN150
in its entirety, and whether the system BN245 BN305
takes all, nothing, or as much of the BN31.1 BN31.2
deduction as possible. The value in this BN32.1 BN32.2
field defaults from the Arrears field in BN32.3 BN45.1
the Deduction file but you can override BN531 BN65.1
the value for each employee deduction. BN71.1 BN72.1
A = All Or None - Create Arrears BS13.1 BS14.1
D = All Or None - No Arrears BS15.1 BS32.1
N = Net To Zero - No Arrears ET530 ETI1.1
Y = Net To Zero - Create Arrears ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
...
EDM-PCT-MATCHED Signed 5.2 BN100 BN101
Element: Pct 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 BN150
field. The system uses this field to BN245 BN305
calculate company-matched deductions BN31.1 BN31.2
when a company limit is defined as a BN32.1 BN32.2
percent of the employee's gross pay or a BN32.3 BN45.1
percent of a specific pay class for an BN531 BN65.1
employee. BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-MONTHLY-LIMIT Signed 11.2 BN100 BN101
Element: 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 BN150
from the Monthly Limit field in the BN245 BN305
Deduction file but you can override the BN31.1 BN31.2
value for each employee deduction. BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-PAY-PRD-LIMIT Signed 11.2 BN100 BN101
Element: Pay Period LimContains 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 BN150
Limit field in the Deduction file but BN245 BN305
you can override the value for each BN31.1 BN31.2
employee deduction. BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-PRIORITY-FLAG Alpha 1 BN100 BN101
Element: 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 BN150
Deduction file and therefore is not BN245 BN305
updated if you change the deduction. BN31.1 BN31.2
X = Deduction Code Override BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-ARREARS-FLAG Alpha 1 BN100 BN101
Element: Arrears Flag A value in this field indicates that BN102 BN103
the value in the Arrears field did not BN104 BN105
default from the Arrears field in the BN145 BN150
Deduction file and therefore is not BN245 BN305
updated if you change the deduction. BN31.1 BN31.2
X = Deduction Code Override BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-EFF-DATE-FLAG Alpha 1 BN100 BN101
Element: Eff 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 BN150
the Deduction file and therefore is not BN245 BN305
updated if you change the deduction. BN31.1 BN31.2
X = Deduction Code Override BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-END-DATE-FLAG Alpha 1 BN100 BN101
Element: 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 BN150
Deduction file and therefore is not BN245 BN305
updated if you change the deduction. BN31.1 BN31.2
X = Deduction Code Override BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-DED-CYC-FLAG Alpha 1 BN100 BN101
Element: Ded Cyc 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 BN150
Cycles fields in the Deduction file and BN245 BN305
therefore is not updated if you change BN31.1 BN31.2
the deduction. BN32.1 BN32.2
X = Ded taken and Taxable updated BN32.3 BN45.1
T = Ded not taken/Taxable updated BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-AMOUNT-FLAG Alpha 1 BN100 BN101
Element: 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 BN150
Percent field in the Deduction file and BN245 BN305
therefore is not updated if you change BN31.1 BN31.2
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-AMOUNT-2-FLAG Alpha 1 BN100 BN101
Element: Amount 2 Flag BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-MTH-LIMIT-FLAG Alpha 1 BN100 BN101
Element: Mth Limit FlagA 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 BN150
in the Deduction file and therefore is BN245 BN305
not updated if you change the deduction. 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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
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 BN150
Limit Flag field in the Deduction file BN245 BN305
and therefore is not updated if you BN31.1 BN31.2
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-DED-ORDER Numeric 3 BN100 BN101
Element: Ded Order Insures that the system processes BN102 BN103
withholding deductions first. BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-RES-CODE Alpha 1 BN100 BN101
Element: 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 BN150
Y = Resident BN245 BN305
N = Non-Resident BN31.1 BN31.2
0 = Resident BN32.1 BN32.2
1 = Nonresident receiving pension BN32.3 BN45.1
2 = Nonresident continuous employ BN531 BN65.1
3 = Nonresident non-cont employ BN71.1 BN72.1
4 = Indiana Resident January 1 BS13.1 BS14.1
5 = Indiana Non-Resident January 1 BS15.1 BS32.1
6 = Indiana Res/Work January 1 ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-MARITAL-STATUS Numeric 2 BN100 BN101
Element: Marital StatusContains the marital status associated BN102 BN103
with the employee's tax deduction. BN104 BN105
01 = Single BN145 BN150
02 = Married BN245 BN305
03 = Married Filing Separate BN31.1 BN31.2
04 = Married Both Spouses Working BN32.1 BN32.2
05 = Married One Spouse Working BN32.3 BN45.1
06 = Head of Household BN531 BN65.1
07 = Married Multiple Employers BN71.1 BN72.1
08 = Widow or Widower BS13.1 BS14.1
09 = Married Not Living With Spouse BS15.1 BS32.1
10 = Married Joint Claiming All ET530 ETI1.1
11 = Married Joint Claiming Half ETI2.1 HR11.1
12 = Married Separate Claiming All HR11.2 HR511
13 = Married Joint Claiming None LP130 PA02.1
14 = Married Living With Spouse PA100 PA102
15 = Married Withhold at Single PA115 PA13.1
16 = Civil Union PA13.2 PA502
17 = Civil Union Withhold at Single 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
PR14.2 PR15.1
...
EDM-EXEMPTIONS Numeric 5 BN100 BN101
Element: Exemptions Contains the number of exemptions BN102 BN103
associated with the employee's tax BN104 BN105
deduction. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-EXEMPT-AMOUNT Signed 9.2 BN100 BN101
Element: Exempt Amount Contains the exempt amount associated BN102 BN103
with the employee's tax deduction. BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-CERT-CODE Numeric 1 BN100 BN101
Element: 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 BN150
of the tax authority, is exempt from BN245 BN305
withholding, or receives a withholding BN31.1 BN31.2
tax credit for the tax authority BN32.1 BN32.2
associated with the deduction. BN32.3 BN45.1
0 = No Certificate BN531 BN65.1
1 = Certificate of Non-Residence BN71.1 BN72.1
2 = Exempt From Withholding BS13.1 BS14.1
3 = Withholding Tax Credit BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-PERS-EXEMPTS Numeric 1 BN100 BN101
Element: Pers Exempts Contains the number of personal BN102 BN103
exemptions defined for the employee BN104 BN105
deduction. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-DEPEND-EXEMPTS Numeric 5 BN100 BN101
Element: Depend ExemptsContains the number of dependent BN102 BN103
exemptions defined for the employee BN104 BN105
deduction. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-ADDL-EXEMPTS Numeric 5 BN100 BN101
Element: Addl Exempts Contains the number of additional BN102 BN103
exemptions defined for the employee BN104 BN105
deduction. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-ADDL-EXEMP-AMT Signed 9.2 BN100 BN101
Element: Addl Exemp AmtContains the additional exemption BN102 BN103
amount defined for the employee BN104 BN105
deduction. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-ADDL-TAX-CODE Numeric 2 BN100 BN101
Element: Addl Tax Code Contains additional tax codes BN102 BN103
associated with the employee deduction. BN104 BN105
The tax code indicates if the additional BN145 BN150
tax is an additional, replacement, or BN245 BN305
exempt amount. BN31.1 BN31.2
01 = Replacement Amount BN32.1 BN32.2
02 = Additional Amount BN32.3 BN45.1
03 = Replacement Percent BN531 BN65.1
04 = Additional Percent BN71.1 BN72.1
05 = Replacement Amount and Percent BS13.1 BS14.1
06 = Exempt Amount BS15.1 BS32.1
07 = Exempt Percent ET530 ETI1.1
11 = Replace Amt; Tax exceed txbl ETI2.1 HR11.1
12 = Addl Amt; Tax exceed txbl HR11.2 HR511
13 = Replace Pct; Tax exceed txbl LP130 PA02.1
14 = Addl Pct; Tax exceed txbl PA100 PA102
15 = Replace Amt & pct;Tax exc txbl PA115 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
PR14.2 PR15.1
...
EDM-ADDL-RATE Signed 7.4 BN100 BN101
Element: Addl Rate Contains a value if the Addl Tax Code BN102 BN103
field value indicates a percent. BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-ADDL-AMOUNT Signed 9.2 BN100 BN101
Element: Addl Amount Contains a value if the Addl Tax Code BN102 BN103
field value indicates an amount. BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-FORMULA-NUMBER Numeric 1 BN100 BN101
Element: Formula NumberContains the value that identifies the BN102 BN103
formula used in calculating the BN104 BN105
deduction. BN145 BN150
BN245 BN305
The system uses this field to define BN31.1 BN31.2
custom data or a specific tax BN32.1 BN32.2
calculation for a tax authority. BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-FILING-STATUS Numeric 1 BN100 BN101
Element: Filing Status Contains the employee's filing status. BN102 BN103
BN104 BN105
The system uses the value in the Filing BN145 BN150
Status field to determine the amount of BN245 BN305
wages protected according to the Federal BN31.1 BN31.2
Tax Levy Exempt Wage Tables. BN32.1 BN32.2
1 = Single BN32.3 BN45.1
2 = Married - separately BN531 BN65.1
3 = Married - joint/ widow(er) BN71.1 BN72.1
4 = Unmarried head of household BS13.1 BS14.1
5 = Single 65+ or blind BS15.1 BS32.1
6 = Head of household 65+ or blind ET530 ETI1.1
7 = M - separately 65+ or blind ETI2.1 HR11.1
8 = M-joint/widow(er) 65+ or blind HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-LEVY-EXEMPTS Numeric 2 BN100 BN101
Element: 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 BN150
amount of wages protected according to BN245 BN305
the Federal Tax Levy Exempt Wage Tables. 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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-LEVY-YEAR Numeric 4 BN100 BN101
Element: 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 BN150
system uses the most current year table BN245 BN305
available based on the current payroll BN31.1 BN31.2
year defined for the company. BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-ADDL-STD-DED Numeric 1 BN100 BN101
Element: Addl Std Ded Contains additional standard deductions BN102 BN103
defined for the employee for tax levy BN104 BN105
garnishment deductions. An employee can BN145 BN150
have up to 4 additional deductions. BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-OBJ-ID Numeric 12 BN100 BN101
Element: Obj Id This is the object identifier. It is BN102 BN103
used to relate commitments or posted BN104 BN105
transactions back to the originating BN145 BN150
subsystems. Each subsystem record that BN245 BN305
is updated as a commitment or posted BN31.1 BN31.2
transaction is assigned an object BN32.1 BN32.2
identifier. The object identifier is BN32.3 BN45.1
maintained in the subsystem files and in BN531 BN65.1
the Activity Commitments Detail and BN71.1 BN72.1
Activity Transaction files. The object BS13.1 BS14.1
identifier is a unique key used to drill BS15.1 BS32.1
back from Activity Management to the ET530 ETI1.1
subsystems. ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-EXP-DIST-CO Numeric 4 BN100 BN101
Element: Company Contains the value from the Expense BN102 BN103
Distribution Company field in the BN104 BN105
Deduction file. The value is stored in BN145 BN150
this file for efficiency purposes. BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-EXP-ACCT-UNIT Alpha 15 BN100 BN101
Element: Acct Unit Contains the value from the Expense BN102 BN103
Accounting Unit field in the Deduction BN104 BN105
file. The value is stored in this file BN145 BN150
for efficiency purposes. BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-EXP-ACCOUNT Numeric 6 BN100 BN101
Element: 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 BN150
efficiency purposes. BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-EXP-SUB-ACCT Numeric 4 BN100 BN101
Element: Expense SubaccContains the value from the Expense BN102 BN103
Subaccount field in the Deduction file. BN104 BN105
The value is stored in this file for BN145 BN150
efficiency purposes. BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-ACR-DIST-CO Numeric 4 BN100 BN101
Element: Company Contains the value from the Accrual BN102 BN103
Distribution Company field in the BN104 BN105
deduction file. BN145 BN150
BN245 BN305
The value is stored in this file for BN31.1 BN31.2
efficiency purposes. BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-ACR-ACCT-UNIT Alpha 15 BN100 BN101
Element: Acct Unit Contains the value from the Accrual BN102 BN103
Accounting Unit field in the Deduction BN104 BN105
file. The value is stored in this file BN145 BN150
for efficiency purposes. BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-ACR-ACCOUNT Numeric 6 BN100 BN101
Element: Account Contains the value from the Accrual BN102 BN103
Account field in the Deduction file. The BN104 BN105
value is stored in this file for BN145 BN150
efficiency purposes. BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-ACR-SUB-ACCT Numeric 4 BN100 BN101
Element: Sub Acct Contains the value from the Accrual BN102 BN103
Subaccount field in the Deduction file. BN104 BN105
The value is stored in this file for BN145 BN150
efficiency purposes. BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-SUB-PRIORITY Numeric 2 BN100 BN101
Element: Sub Priority Defines the order in which deductions BN102 BN103
are withheld within the same priority BN104 BN105
for an employee. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-GARN-OBJ-ID Numeric 12 BN100 BN101
Element: Garn Obj Id Assigned when an employee garnishment BN102 BN103
table (PREMPGARN) is added and BN104 BN105
deductions are created. This ID links BN145 BN150
the employee deductions to this BN245 BN305
garnishment (case number/file number). BN31.1 BN31.2
If the same deduction is created for BN32.1 BN32.2
this employee, this ID along with the BN32.3 BN45.1
sequence number keeps the record unique. BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-AMOUNT-2 Signed 13.4 BN100 BN101
Element: Amount 2 Used for calculation types 1 and 2. BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-NET-CLAIM-AMT Signed 11.2 BN100 BN101
Element: Net Claim Amt This field is used for Canada income BN102 BN103
taxes. BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-PRESCRIBEDAREA Signed 11.2 BN100 BN101
Element: Prescribedarea BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-STUDENT-PEN-EX Signed 9.2 BN100 BN101
Element: Student Pen Ex BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-TD1-FILING-DAT Numeric 8 (yyyymmdd) BN100 BN101
Element: Td1 Filing Dat BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-TD1-ADJUST-DAT Numeric 8 (yyyymmdd) BN100 BN101
Element: Td1 Adjust Dat BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-APPROVED-STOCK Signed 9.2 BN100 BN101
Element: Approved Stock BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-TAX-EXEMPT-FLG Alpha 1 BN100 BN101
Element: Tax Exempt FlgN = No BN102 BN103
Y = Yes; Exempt tax only BN104 BN105
B = Yes; Exempt both tax and wages BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-CYC1 Derived
Element: Cycle 1
EDM-CYC2 Derived
Element: Cycle 2
EDM-CYC3 Derived
Element: Cycle 3
EDM-CYC4 Derived
Element: Cycle 4
EDM-CYC5 Derived
Element: Cycle 5
EDM-CYC6 Derived
Element: Cycle 6
EDM-CYC7 Derived
Element: Cycle 7
EDM-CYC8 Derived
Element: Cycle 8
EDM-CYC9 Derived
Element: Cycle 9
EDM-AUTH-TAX-CRED Signed 9.2 BN100 BN101
Element: Auth Tax Cred BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-AUTH-TAX-DED Signed 9.2 BN100 BN101
Element: Auth Tax Ded BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-MARRIED-EQUIV Alpha 1 BN100 BN101
Element: Married Equiv N = No BN102 BN103
Y = Yes BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-AGE-65-OVER Alpha 1 BN100 BN101
Element: Age 65 Over N = No BN102 BN103
Y = Yes BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-EMP-DISABILITY Alpha 1 BN100 BN101
Element: Emp DisabilityN = No BN102 BN103
Y = Yes BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-DEP-UNDER-18 Numeric 2 BN100 BN101
Element: Dep Under 18 BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-DEP-DIS-OVR-17 Numeric 2 BN100 BN101
Element: Dep Dis Ovr 17 BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-CURRENCY-CODE Alpha 5 BN100 BN101
Element: Currency Code This field contains the company base BN102 BN103
currency code established in Company BN104 BN105
(GL10.1 ). BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-CURR-ND Numeric 1 BN100 BN101
Element: Acct Nd The number of decimals assigned to a BN102 BN103
particular account as determined by the BN104 BN105
account currency. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-NI-CODE Alpha 1 BN100 BN101
Element: Ni Code BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-DIRECTOR Alpha 1 BN100 BN101
Element: Director BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-NI-CERT-ISSUED Numeric 8 (yyyymmdd) UK13.1
Element: Ni Cert Issued
EDM-NI-CERT-NBR Alpha 10 UK13.1
Element: Ni Cert Nbr
EDM-TAX-CODE Alpha 10 BN100 BN101
Element: Tax Code This field contains a code representing BN102 BN103
specific tax information. This must be BN104 BN105
valid Tax Code. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-TAX-BASIS Alpha 1 BN100 BN101
Element: Tax Basis BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-REF-WITHELD Alpha 1 UK13.1
Element: Ref Witheld
EDM-P46-ISSUED Alpha 1 UK13.1
Element: P46 Issued
EDM-P46-ISSUE-DATE Numeric 8 (yyyymmdd) UK13.1
Element: P46 Issue Date
EDM-P45-ISSUED Alpha 1 UK13.1 UK145
Element: P45 Issued
EDM-P45-ISSUE-DATE Numeric 8 (yyyymmdd) UK13.1 UK145
Element: P45 Issue Date
EDM-PAY-FREQUENCY Numeric 1
Element: Pay Frequency
EDM-CONTRACTED-OUT Alpha 1 BN100 BN101
Element: Contracted Out BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-DFLT-TCA-FLAG Numeric 4 BN100 BN101
Element: Dflt Tca Flag This BSI parameter indicates whether or BN102 BN103
not the provincial (TCA) total claim BN104 BN105
amount is used when the total claim BN145 BN150
amount interface is zero. BN245 BN305
0000 = Use default TCA BN31.1 BN31.2
0001 = Do not use default TCA BN32.1 BN32.2
BN32.3 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-HM-PROC-LEVEL Alpha 5 BN100 BN101
Element: Process Level This field contains the process level, BN102 BN103
which is the reporting hierarchy below BN104 BN105
company. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-EXCLUDE-AMT Signed 13.4 BN100 BN101
Element: Exclude Amt BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-EXCL-AMT-FLAG Alpha 1 BN100 BN101
Element: Excl Amt Flag BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
PR14.2 PR15.1
...
EDM-CREATE-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: Date Stamp This field contains the server date BN102 BN103
(month, date, and year) of the last BN104 BN105
change to this record. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-CREATE-TIME Numeric 6 (hhmmss) BN100 BN101
Element: Time Stamp Contains the server time (hour, minute, BN102 BN103
and second) when the record was last BN104 BN105
changed. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-CREATE-USER-ID Alpha 10 (Lower Case) BN100 BN101
Element: User Id Contains the user ID of the person who BN102 BN103
last changed this record. BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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 PR14.2
...
EDM-DATE-STAMP Numeric 8 (yyyymmdd) BN100 BN101
Element: Date Stamp This field contains the server date BN102 BN103
(month, date, and year) of the last BN104 BN105
change to this record. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
...
EDM-TIME-STAMP Numeric 6 (hhmmss) BN100 BN101
Element: Time Stamp Contains the server time (hour, minute, BN102 BN103
and second) when the record was last BN104 BN105
changed. BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
...
EDM-USER-ID Alpha 10 (Lower Case) BN100 BN101
Element: User Id Contains the user ID of the person who BN102 BN103
last changed this record. BN104 BN105
BN145 BN150
BN245 BN305
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
ET530 ETI1.1
ETI2.1 HR11.1
HR11.2 HR511
LP130 PA02.1
PA100 PA102
PA115 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
...
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 BN150
BN245 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN430
BN45.1 BN51.2
BN531 BN65.1
BN66.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 ET530
ETI1.1 ETI2.1
...
EDMSET2 COMPANY PR02.1 PR05.1
DED-CODE PR114 PR115
EMPLOYEE PR15.1
SEQ-NBR
EDMSET3 COMPANY KeyChange BN100 BN101
EMPLOYEE BN102 BN103
DED-ORDER BN104 BN105
DED-PRIORITY BN145 BN150
SUB-PRIORITY BN245 BN305
DED-CODE BN31.1 BN31.2
SEQ-NBR 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 ET530
ETI1.1 ETI2.1
HR11.1 HR11.2
...
EDMSET4 OBJ-ID KeyChange HR170 HR70.1
PR280
EDMSET5 COMPANY KeyChange PR14.2 PR514
EMPLOYEE PR539 PR82.1
DED-CODE UK13.1 UK145
EFFECT-DATE*
SEQ-NBR
EDMSET6 COMPANY KeyChange BN150 BN305
HM-PROC-LEVEL BN66.1 ET530
EMPLOYEE ETI2.1 HR11.1
DED-CODE HR11.2 HR170
SEQ-NBR HR511 HR70.1
LP130 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
...
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
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
EDM-COMPANY -> PDH-COMPANY
EDM-EMPLOYEE -> PDH-EMPLOYEE
EDM-DED-CODE -> PDH-DED-CODE
EDM-SEQ-NBR -> PDH-SEQ-NBR
PDH-YEAR
PDH-PERIOD-NBR
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
|