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 HR211 PR141 PR160 PR180 PR214
PR226 PR239 PR247 PR260 PR277 PR298
UK141 UK201 UK202 UK277 PR02.1 PR05.1
HR170 HR70.1 PR280
UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN245 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
HR11.1 HR11.2 HR511 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 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 PR529 PR530 PR560 PR82.1 PR85.1
UK102 UK145 UK183 UK184 UK47.1 UK47.2
TA147 TP135 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EDM-COMPANY Numeric 4 BN100 BN101
Element: Company Hr Identifies the AP company if the BN102 BN103
resource type = V. Identifies the HR BN104 BN105
company if the resource type = E. It is BN145 BN150
blank for type A, P or Q resources. 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.2
...
EDM-EMPLOYEE Numeric 9 BN100 BN101
Element: Employee Contains the employee number. 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.2
...
EDM-SEQ-NBR Numeric 4 BN100 BN101
Element: Sequence NumbeContains 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 BN31.1
one employee deduction record for a BN31.2 BN32.1
deduction. In the Benefits system, many BN32.2 BN32.3
employee deductions can exist for the BN45.1 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 HR11.2 HR511
automatically sequences this field based PA02.1 PA100
on the last employee deduction sequence PA102 PA13.1
number. 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 PR205
PR26.1 PR29.1
PR32.2 PR33.2
...
EDM-DED-CYCLE Alpha 1 Occurs 9 Times BN100 BN101
Element: Deduction CyclContains 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 BN31.1
file but you can override the value for BN31.2 BN32.1
each employee deduction. Valid values BN32.2 BN32.3
are: BN45.1 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. HR11.2 HR511
PA02.1 PA100
T - The system does not take the PA102 PA13.1
deduction but updates taxable wages for PA13.2 PA502
withholding type deductions. PA513 PA52.1
PA52.3 PA52.4
Blank - The system does not take the PA52.5 PR110
deduction and does not update taxable PR113 PR115
wages for withholding type deductions. PR120 PR128
On a non-tax deduction, the system does PR13.1 PR13.2
not take the deduction. PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR205
PR26.1 PR29.1
PR32.2 PR33.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 BN31.1
D = Descending Balance BN31.2 BN32.1
L = Limit 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR197 PR205
PR26.1 PR29.1
PR32.2 PR33.2
...
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 BN31.1
value in this field defaults from the BN31.2 BN32.1
Amount or Percent field in the Deduction BN32.2 BN32.3
file but you can override the value for BN45.1 BN531
each employee deduction. BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
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
PR205 PR26.1
PR29.1 PR32.2
...
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 BN31.1
that are excluded from disposable BN31.2 BN32.1
income, garnishment deductions, all BN32.2 BN32.3
other deductions, all one-time BN45.1 BN531
deductions, and all company matching BN65.1 BN71.1
deductions. BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
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
PR205 PR26.1
PR26.2 PR29.1
...
EDM-EFFECT-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: Effective DateContains 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 BN31.1
tab on PR05.1 (Deduction) but you can BN31.2 BN32.1
override the value for each employee BN32.2 BN32.3
deduction. BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
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
PR205 PR26.1
PR29.1 PR32.2
...
EDM-END-DATE Numeric 8 (yyyymmdd) BN100 BN101
Element: 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 BN150
Date - Ending field on the More form tab BN245 BN31.1
on PR05.1 (Deduction) but you can BN31.2 BN32.1
override the value for each employee BN32.2 BN32.3
deduction. BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
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
PR205 PR26.1
PR29.1 PR32.2
...
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 BN31.1
takes all, nothing, or as much of the BN31.2 BN32.1
deduction as possible. The value in this BN32.2 BN32.3
field defaults from the Arrears field in BN45.1 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 HR11.2 HR511
Y = Net To Zero - Create Arrears 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
PR205 PR26.1
PR29.1 PR32.2
...
EDM-PCT-MATCHED Signed 5.2 BN100 BN101
Element: Percentage MatContains 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 BN31.1
calculate company-matched deductions BN31.2 BN32.1
when a company limit is defined as a BN32.2 BN32.3
percent of the employee's gross pay or a BN45.1 BN531
percent of a specific pay class for an BN65.1 BN71.1
employee. BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 BN31.1
Deduction file but you can override the BN31.2 BN32.1
value for each employee deduction. 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 BN31.1
you can override the value for each BN31.2 BN32.1
employee deduction. 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 BN31.1
updated if you change 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.2
...
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 BN150
Deduction file and therefore is not BN245 BN31.1
updated if you change 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.2
...
EDM-EFF-DATE-FLAG Alpha 1 BN100 BN101
Element: Effective DateA 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 BN31.1
updated if you change 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 BN31.1
updated if you change 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.2
...
EDM-DED-CYC-FLAG Alpha 1 BN100 BN101
Element: Deduction CyclA 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 BN31.1
therefore is not updated if you change BN31.2 BN32.1
the deduction. BN32.2 BN32.3
X = Ded taken and Taxable updated BN45.1 BN531
T = Ded not taken/Taxable updated BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 BN31.1
therefore is not updated if you change BN31.2 BN32.1
the deduction. BN32.2 BN32.3
X = Deduction Code Override BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-AMOUNT-2-FLAG Alpha 1
Element: Amount 2 Flag
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 BN31.1
not updated if you 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 BN31.1
and therefore is not updated if you BN31.2 BN32.1
change the deduction. 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 BN31.1
N = Non-Resident BN31.2 BN32.1
0 = Resident BN32.2 BN32.3
1 = Nonresident receiving pension BN45.1 BN531
2 = Nonresident continuous employ BN65.1 BN71.1
3 = Nonresident non-cont employ BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
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
PR205 PR26.1
PR26.2 PR29.1
PR32.2 PR33.2
...
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 BN31.1
03 = Married Filing Separate BN31.2 BN32.1
04 = Married Both Spouses Working BN32.2 BN32.3
05 = Married One Spouse Working BN45.1 BN531
06 = Head of Household BN65.1 BN71.1
07 = Married Multiple Employers BN72.1 BS13.1
08 = Widow or Widower BS14.1 BS15.1
09 = Married Not Living With Spouse BS32.1 HR11.1
10 = Married Joint Claiming All HR11.2 HR511
11 = Married Joint Claiming Half PA02.1 PA100
12 = Married Separate Claiming All PA102 PA13.1
13 = Married Joint Claiming None PA13.2 PA502
14 = Married Living With Spouse PA513 PA52.1
15 = Married Withhold at Single PA52.3 PA52.4
16 = Civil Union PA52.5 PR110
17 = Civil Union Withhold at Single PR113 PR120
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 BN31.1
withholding, or receives a withholding BN31.2 BN32.1
tax credit for the tax authority BN32.2 BN32.3
associated with the deduction. BN45.1 BN531
0 = No Certificate BN65.1 BN71.1
1 = Certificate of Non-Residence BN72.1 BS13.1
2 = Exempt From Withholding BS14.1 BS15.1
3 = Withholding Tax Credit BS32.1 HR11.1
HR11.2 HR511
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 BN31.1
exempt amount. 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 BN31.1
The system uses this field to define BN31.2 BN32.1
custom data or a specific tax BN32.2 BN32.3
calculation for a tax authority. BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 BN31.1
wages protected according to the Federal BN31.2 BN32.1
Tax Levy Exempt Wage Tables. BN32.2 BN32.3
1 = Single BN45.1 BN531
2 = Married - separately BN65.1 BN71.1
3 = Married - joint/ widow(er) BN72.1 BS13.1
4 = Unmarried head of household BS14.1 BS15.1
5 = Single 65+ or blind BS32.1 HR11.1
6 = Head of household 65+ or blind HR11.2 HR511
7 = M - separately 65+ or blind PA02.1 PA100
8 = M-joint/widow(er) 65+ or blind 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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 BN31.1
the Federal Tax Levy Exempt Wage Tables. 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 BN31.1
available based on the current payroll BN31.2 BN32.1
year defined for the company. 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 BN150
subsystems. Each subsystem record that BN245 BN31.1
is updated as a commitment or posted BN31.2 BN32.1
transaction is assigned an object BN32.2 BN32.3
identifier. The object identifier is BN45.1 BN531
maintained in the subsystem files and in BN65.1 BN71.1
the Activity Commitments Detail and BN72.1 BS13.1
Activity Transaction files. The object BS14.1 BS15.1
identifier is a unique key used to drill BS32.1 HR11.1
back from Activity Management to the HR11.2 HR511
subsystems. 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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.2
...
EDM-EXP-ACCT-UNIT Alpha 15 BN100 BN101
Element: Accounting UniContains 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 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 BN31.1
The value is stored in this file for BN31.2 BN32.1
efficiency purposes. 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.2
...
EDM-ACR-ACCT-UNIT Alpha 15 BN100 BN101
Element: Accounting UniContains 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 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.2
...
EDM-ACR-SUB-ACCT Numeric 4 BN100 BN101
Element: Subaccount 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 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 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
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
PR205 PR26.1
PR26.2 PR29.1
PR32.2 PR33.2
...
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 BN31.1
garnishment (case number/file number). BN31.2 BN32.1
If the same deduction is created for BN32.2 BN32.3
this employee, this ID along with the BN45.1 BN531
sequence number keeps the record unique. BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-PRESCRIBEDAREA Signed 11.2 BN100 BN101
Element: Prescribedarea 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-STUDENT-PEN-EX Signed 9.2 BN100 BN101
Element: Student Pen Ex 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-TD1-FILING-DAT Numeric 8 (yyyymmdd) BN100 BN101
Element: Td1 Filing Dat 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-TD1-ADJUST-DAT Numeric 8 (yyyymmdd) BN100 BN101
Element: Td1 Adjust Dat 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-APPROVED-STOCK Signed 9.2 BN100 BN101
Element: Approved Stock 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-AUTH-TAX-DED Signed 9.2 BN100 BN101
Element: Auth Tax Ded 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-MARRIED-EQUIV Alpha 1 BN100 BN101
Element: Married Equiv N = No BN102 BN103
Y = Yes 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-AGE-65-OVER Alpha 1 BN100 BN101
Element: Age 65 Over N = No BN102 BN103
Y = Yes 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-EMP-DISABILITY Alpha 1 BN100 BN101
Element: Emp DisabilityN = No BN102 BN103
Y = Yes 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-DEP-UNDER-18 Numeric 2 BN100 BN101
Element: Dep Under 18 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-DEP-DIS-OVR-17 Numeric 2 BN100 BN101
Element: Dep Dis Ovr 17 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-CURR-ND Numeric 1 BN100 BN101
Account Currency Represents the number of decimals BN102 BN103
Code defined for the currency of the object. 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-NI-CODE Alpha 1 BN100 BN101
Element: Ni Code 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-DIRECTOR Alpha 1 BN100 BN101
Element: Director 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-NI-CERT-ISSUED Numeric 8 (yyyymmdd)
Element: Ni Cert Issued
EDM-NI-CERT-NBR Alpha 10
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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-TAX-BASIS Alpha 1 BN100 BN101
Element: Tax Basis 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-REF-WITHELD Alpha 1
Element: Ref Witheld
EDM-P46-ISSUED Alpha 1
Element: P46 Issued
EDM-P46-ISSUE-DATE Numeric 8 (yyyymmdd)
Element: P46 Issue Date
EDM-P45-ISSUED Alpha 1 UK145
Element: P45 Issued
EDM-P45-ISSUE-DATE Numeric 8 (yyyymmdd) 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 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
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
PR205 PR26.1
PR29.1 PR32.2
PR33.2 PR33.3
...
EDM-DFLT-TCA-FLAG Numeric 4
Element: Dflt Tca Flag This BSI parameter indicates whether or
not the provincial (TCA) total claim
amount is used when the total claim
amount interface is zero.
0000 = Use default TCA
0001 = Do not use default TCA
EDM-HM-PROC-LEVEL Alpha 5 BN100 BN101
Element: Process Level Contains the employee's home process BN102 BN103
level. 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
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 PR205
PR26.1 PR29.1
PR32.2 PR33.2
...
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 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN430 BN45.1
BN51.2 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR211
HR511 PA02.1
...
EDMSET2 COMPANY PR02.1 PR05.1
DED-CODE PR114 PR115
EMPLOYEE PR15.1 PR160
SEQ-NBR PR180
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
HR11.2 HR511
PA02.1 PA100
PA102 PA13.1
...
EDMSET4 OBJ-ID KeyChange HR170 HR70.1
PR280
EDMSET5 COMPANY KeyChange UK145
EMPLOYEE
DED-CODE
EFFECT-DATE*
SEQ-NBR
EDMSET6 COMPANY KeyChange BN150 HR11.1
HM-PROC-LEVEL HR11.2 HR170
EMPLOYEE HR511 HR70.1
DED-CODE PA02.1 PA100
SEQ-NBR PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
...
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
|