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.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
EDM-COMPANY
Element: Company Hr | Numeric 4
|
|
EDM-EMPLOYEE
Element: Employee | Numeric 9
Contains the employee number.
|
|
EDM-DED-CODE
Element: Deduction | Alpha 4
Contains the user-defined value that
represents a deduction.
|
|
EDM-SEQ-NBR
Element: Seq Nbr | Numeric 4
Contains the deduction sequence number.
The value of this field is always zeros
if created through the Payroll system
because the system allows entry of only
one employee deduction record for a
deduction. In the Benefits system, many
employee deductions can exist for the
same deduction with non-overlapping
effective and ending dates. Therefore,
this field is needed to maintain
uniqueness. When you create records
through the Benefits system, the system
automatically sequences this field based
on the last employee deduction sequence
number.
|
|
EDM-DED-CYCLE
Element: Ded Cycle | Alpha 1 Occurs 9 Times
Contains the value that indicates in
which cycles a deduction is taken. The
value in this field defaults from the
Deduction Cycles field in the Deduction
file but you can override the value for
each employee deduction. Valid values
are:
X - The system takes the deduction and
updates taxable wages for withholding
type deductions. On a non-tax deduction,
the system takes the deduction.
T - The system does not take the
deduction but updates taxable wages for
withholding type deductions.
Blank - The system does not take the
deduction and does not update taxable
wages for withholding type deductions.
On a non-tax deduction, the system does
not take the deduction.
|
|
EDM-BALANCE-TYPE
Element: Balance Type | Alpha 1
Contains the value that determines how
the deduction affects the Balance Amount
field.
A = Ascending Balance
D = Descending Balance
L = Limit |
|
EDM-BALANCE-AMT
Element: Intl Amt | Signed 18.2
Contains the balance amount for
deductions that have a balance type.
|
|
EDM-NEXT-AMOUNT
Element: Amount or Percent | Signed 13.4
Contains the amount or percent to be
deducted. The calculation type defined
for the deduction determines if the
value is an amount or a percent. The
value in this field defaults from the
Amount or Percent field in the Deduction
file but you can override the value for
each employee deduction.
|
|
EDM-DED-PRIORITY
Element: Priority | Numeric 1
Contains the value that indicates the
order in which deductions are processed
within the following categories:
withholding type deductions, deductions
that are excluded from disposable
income, garnishment deductions, all
other deductions, all one-time
deductions, and all company matching
deductions.
|
|
EDM-EFFECT-DATE
Element: Effect Date | Numeric 8 (yyyymmdd)
Contains the effective date of the
deduction. The value in this field
defaults from the deduction Effective
Date - Beginning field on the More form
tab on PR05.1 (Deduction) but you can
override the value for each employee
deduction.
|
|
EDM-END-DATE
Element: End Date | Numeric 8 (yyyymmdd)
Contains the last date the deduction
can be taken. The value in this field
defaults from the deduction Effective
Date - Ending field on the More form tab
on PR05.1 (Deduction) but you can
override the value for each employee
deduction.
|
|
EDM-ARREARS
Element: Arrears | Alpha 1
Contains the value that determines if
the system places the deduction in
arrears if it cannot take the deduction
in its entirety, and whether the system
takes all, nothing, or as much of the
deduction as possible. The value in this
field defaults from the Arrears field in
the Deduction file but you can override
the value for each employee deduction.
A = All Or None - Create Arrears
D = All Or None - No Arrears
N = Net To Zero - No Arrears
Y = Net To Zero - Create Arrears |
|
EDM-PCT-MATCHED
Element: Pct Matched | Signed 5.2
Contains the percent to be matched by
the company. The Benefits system is the
only system that moves a value to this
field. The system uses this field to
calculate company-matched deductions
when a company limit is defined as a
percent of the employee's gross pay or a
percent of a specific pay class for an
employee.
|
|
EDM-MONTHLY-LIMIT
Element: Monthly Limit | Signed 11.2
Contains the monthly limit that can be
taken for the deduction in a single
month. The value in this field defaults
from the Monthly Limit field in the
Deduction file but you can override the
value for each employee deduction.
|
|
EDM-PAY-PRD-LIMIT
Element: Pay Period Limit | Signed 11.2
Contains the deduction limit that can
be taken in a pay period. The value in
this field defaults from the Payment
Limit field in the Deduction file but
you can override the value for each
employee deduction.
|
|
EDM-PRIORITY-FLAG
Element: Priority Flag | Alpha 1
A value in this field indicates that
the value in the Priority field did not
default from the Priority field in the
Deduction file and therefore is not
updated if you change the deduction.
X = Deduction Code Override |
|
EDM-ARREARS-FLAG
Element: Arrears Flag | Alpha 1
A value in this field indicates that
the value in the Arrears field did not
default from the Arrears field in the
Deduction file and therefore is not
updated if you change the deduction.
X = Deduction Code Override |
|
EDM-EFF-DATE-FLAG
Element: Eff Date Flag | Alpha 1
A value in this field indicates that
the value in the Begin Date field did
not default from the Begin Date field in
the Deduction file and therefore is not
updated if you change the deduction.
X = Deduction Code Override |
|
EDM-END-DATE-FLAG
Element: End Date Flag | Alpha 1
A value in this field indicates that
the value in the End Date field did not
default from the End Date field in the
Deduction file and therefore is not
updated if you change the deduction.
X = Deduction Code Override |
|
EDM-DED-CYC-FLAG
Element: Ded Cyc Flag | Alpha 1
A value in this field indicates that
the value in the Deduction Cycles fields
did not default from the Deduction
Cycles fields in the Deduction file and
therefore is not updated if you change
the deduction.
X = Ded taken and Taxable updated
T = Ded not taken/Taxable updated |
|
EDM-AMOUNT-FLAG
Element: Amount Flag | Alpha 1
A value in this field indicates that
the value in the Amount or Percent field
did not default from the Amount or
Percent field in the Deduction file and
therefore is not updated if you change
the deduction.
X = Deduction Code Override |
|
EDM-AMOUNT-2-FLAG
Element: Amount 2 Flag | Alpha 1
|
|
EDM-MTH-LIMIT-FLAG
Element: Mth Limit Flag | Alpha 1
A value in this field indicates that
the value in the Monthly Limit field did
not default from the Monthly Limit field
in the Deduction file and therefore is
not updated if you change the deduction.
|
|
EDM-PRD-LIMIT-FLAG
Pay Period Limit
Flag | Alpha 1
A value in this field indicates that
the value in the Payment Limit Flag
field did not default from the Payment
Limit Flag field in the Deduction file
and therefore is not updated if you
change the deduction.
|
|
EDM-DED-ORDER
Element: Ded Order | Numeric 3
Insures that the system processes
withholding deductions first.
|
|
EDM-RES-CODE
Element: Res Code | Alpha 1
Contains the value that indicates if
the employee is a resident of the tax
authority associated with the deduction.
Y = Resident
N = Non-Resident
0 = Resident
1 = Nonresident receiving pension
2 = Nonresident continuous employ
3 = Nonresident non-cont employ
4 = Indiana Resident January 1
5 = Indiana Non-Resident January 1
6 = Indiana Res/Work January 1 |
|
EDM-MARITAL-STATUS
Element: Marital Status | Numeric 2
Contains the marital status associated
with the employee's tax deduction.
01 = Single
02 = Married
03 = Married Filing Separate
04 = Married Both Spouses Working
05 = Married One Spouse Working
06 = Head of Household
07 = Married Multiple Employers
08 = Widow or Widower
09 = Married Not Living With Spouse
10 = Married Joint Claiming All
11 = Married Joint Claiming Half
12 = Married Separate Claiming All
13 = Married Joint Claiming None
14 = Married Living With Spouse
15 = Married Withhold at Single
16 = Civil Union
17 = Civil Union Withhold at Single |
|
EDM-EXEMPTIONS
Element: Exemptions | Numeric 5
Contains the number of exemptions
associated with the employee's tax
deduction.
|
|
EDM-EXEMPT-AMOUNT
Element: Exempt Amount | Signed 9.2
Contains the exempt amount associated
with the employee's tax deduction.
|
|
EDM-CERT-CODE
Element: Cert Code | Numeric 1
Contains the value that indicates the
employee has on file, a certificate
verifying the employee is a nonresident
of the tax authority, is exempt from
withholding, or receives a withholding
tax credit for the tax authority
associated with the deduction.
0 = No Certificate
1 = Certificate on File
2 = Local Courtesy Withholding
3 = State Courtesy Withholding |
|
EDM-PERS-EXEMPTS
Element: Pers Exempts | Numeric 1
Contains the number of personal
exemptions defined for the employee
deduction.
|
|
EDM-DEPEND-EXEMPTS
Element: Depend Exempts | Numeric 5
Contains the number of dependent
exemptions defined for the employee
deduction.
|
|
EDM-ADDL-EXEMPTS
Element: Addl Exempts | Numeric 5
Contains the number of additional
exemptions defined for the employee
deduction.
|
|
EDM-ADDL-EXEMP-AMT
Element: Addl Exemp Amt | Signed 9.2
Contains the additional exemption
amount defined for the employee
deduction.
|
|
EDM-ADDL-TAX-CODE
Element: Addl Tax Code | Numeric 2
Contains additional tax codes
associated with the employee deduction.
The tax code indicates if the additional
tax is an additional, replacement, or
exempt amount.
01 = Replacement Amount
02 = Additional Amount
03 = Replacement Percent
04 = Additional Percent
05 = Replacement Amount and Percent
06 = Exempt Amount
07 = Exempt Percent
08 = AZ Res Vol W/H; outside wages
11 = Replace Amt; Tax exceed txbl
12 = Addl Amt; Tax exceed txbl
13 = Replace Pct; Tax exceed txbl
14 = Addl Pct; Tax exceed txbl
15 = Replace Amt & pct;Tax exc txbl
10 = Substitute Pct Mandatory Suppl
19 = AZ Res Addl Pct or Pct and Amt
18 = Sub VA Reciprocal Tax Credit |
|
EDM-ADDL-RATE
Element: Addl Rate | Signed 7.4
Contains a value if the Addl Tax Code
field value indicates a percent.
|
|
EDM-ADDL-AMOUNT
Element: Addl Amount | Signed 9.2
Contains a value if the Addl Tax Code
field value indicates an amount.
|
|
EDM-FORMULA-NUMBER
Element: Formula Number | Numeric 4
Contains the value that identifies the
formula used in calculating the
deduction.
The system uses this field to define
custom data or a specific tax
calculation for a tax authority.
|
|
EDM-FILING-STATUS
Element: Filing Status | Numeric 1
Contains the employee's filing status.
The system uses the value in the Filing
Status field to determine the amount of
wages protected according to the Federal
Tax Levy Exempt Wage Tables.
1 = Single
2 = Married - separately
3 = Married - joint/ widow(er)
4 = Unmarried head of household
5 = Single 65+ or blind
6 = Head of household 65+ or blind
7 = M - separately 65+ or blind
8 = M-joint/widow(er) 65+ or blind |
|
EDM-LEVY-EXEMPTS
Element: Levy Exempts | Numeric 2
Contains the number of levy exemptions
for the employee. The system uses the
value in this field to determine the
amount of wages protected according to
the Federal Tax Levy Exempt Wage Tables.
|
|
EDM-LEVY-YEAR
Element: Levy Year | Numeric 4
Contains the effective year of the
exempt wage table used for the
deduction. If a year is not entered, the
system uses the most current year table
available based on the current payroll
year defined for the company.
|
|
EDM-ADDL-STD-DED
Element: Addl Std Ded | Numeric 1
Contains additional standard deductions
defined for the employee for tax levy
garnishment deductions. An employee can
have up to 4 additional deductions.
|
|
EDM-OBJ-ID
Element: Obj Id | Numeric 12
This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
|
|
EDM-EXP-DIST-CO
Element: Company | Numeric 4
Contains the value from the Expense
Distribution Company field in the
Deduction file. The value is stored in
this file for efficiency purposes.
|
|
EDM-EXP-ACCT-UNIT
Element: Acct Unit | Alpha 15
Contains the value from the Expense
Accounting Unit field in the Deduction
file. The value is stored in this file
for efficiency purposes.
|
|
EDM-EXP-ACCOUNT
Element: Account | Numeric 6
Contains the value from the Expense
Account field in the Deduction file. The
value is stored in this file for
efficiency purposes.
|
|
EDM-EXP-SUB-ACCT
Element: Expense Subaccount | Numeric 4
Contains the value from the Expense
Subaccount field in the Deduction file.
The value is stored in this file for
efficiency purposes.
|
|
EDM-ACR-DIST-CO
Element: Company | Numeric 4
Contains the value from the Accrual
Distribution Company field in the
deduction file.
The value is stored in this file for
efficiency purposes.
|
|
EDM-ACR-ACCT-UNIT
Element: Acct Unit | Alpha 15
Contains the value from the Accrual
Accounting Unit field in the Deduction
file. The value is stored in this file
for efficiency purposes.
|
|
EDM-ACR-ACCOUNT
Element: Account | Numeric 6
Contains the value from the Accrual
Account field in the Deduction file. The
value is stored in this file for
efficiency purposes.
|
|
EDM-ACR-SUB-ACCT
Element: Sub Acct | Numeric 4
Contains the value from the Accrual
Subaccount field in the Deduction file.
The value is stored in this file for
efficiency purposes.
|
|
EDM-SUB-PRIORITY
Element: Sub Priority | Numeric 2
Defines the order in which deductions
are withheld within the same priority
for an employee.
|
|
EDM-GARN-OBJ-ID
Element: Garn Obj Id | Numeric 12
Assigned when an employee garnishment
table (PREMPGARN) is added and
deductions are created. This ID links
the employee deductions to this
garnishment (case number/file number).
If the same deduction is created for
this employee, this ID along with the
sequence number keeps the record unique.
|
|
EDM-AMOUNT-2
Element: Amount 2 | Signed 13.4
Used for calculation types 1 and 2.
|
|
EDM-NET-CLAIM-AMT
Element: Net Claim Amt | Signed 11.2
This field is used for Canada income
taxes.
|
|
EDM-PRESCRIBEDAREA
Element: Prescribedarea | Signed 11.2
|
|
EDM-STUDENT-PEN-EX
Element: Student Pen Ex | Signed 9.2
|
|
EDM-TD1-FILING-DAT
Element: Td1 Filing Dat | Numeric 8 (yyyymmdd)
|
|
EDM-TD1-ADJUST-DAT
Element: Td1 Adjust Dat | Numeric 8 (yyyymmdd)
|
|
EDM-APPROVED-STOCK
Element: Approved Stock | Signed 9.2
|
|
EDM-TAX-EXEMPT-FLG
Element: Tax Exempt Flg | Alpha 1
N = No
Y = Yes; Exempt tax only
B = Yes; Exempt both tax and wages |
|
EDM-CYC1
Element: Cycle 1 | Derived
|
|
EDM-CYC2
Element: Cycle 2 | Derived
|
|
EDM-CYC3
Element: Cycle 3 | Derived
|
|
EDM-CYC4
Element: Cycle 4 | Derived
|
|
EDM-CYC5
Element: Cycle 5 | Derived
|
|
EDM-CYC6
Element: Cycle 6 | Derived
|
|
EDM-CYC7
Element: Cycle 7 | Derived
|
|
EDM-CYC8
Element: Cycle 8 | Derived
|
|
EDM-CYC9
Element: Cycle 9 | Derived
|
|
EDM-AUTH-TAX-CRED
Element: Auth Tax Cred | Signed 9.2
|
|
EDM-AUTH-TAX-DED
Element: Auth Tax Ded | Signed 9.2
|
|
EDM-MARRIED-EQUIV
Element: Married Equiv | Alpha 1
N = No
Y = Yes |
|
EDM-AGE-65-OVER
Element: Age 65 Over | Alpha 1
N = No
Y = Yes |
|
EDM-EMP-DISABILITY
Element: Emp Disability | Alpha 1
N = No
Y = Yes |
|
EDM-DEP-UNDER-18
Element: Dep Under 18 | Numeric 2
|
|
EDM-DEP-DIS-OVR-17
Element: Dep Dis Ovr 17 | Numeric 2
|
|
EDM-CURRENCY-CODE
Element: Currency Code | Alpha 5
This field contains the company base
currency code established in Company
(GL10.1 ).
|
|
EDM-CURR-ND
Element: Acct Nd | Numeric 1
The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
EDM-NI-CODE
Element: Ni Code | Alpha 1
|
|
EDM-DIRECTOR
Element: Director | Alpha 1
|
|
EDM-NI-CERT-ISSUED
Element: Ni Cert Issued | Numeric 8 (yyyymmdd)
|
|
EDM-NI-CERT-NBR
Element: Ni Cert Nbr | Alpha 10
|
|
EDM-TAX-CODE
Element: Tax Code | Alpha 10
This field contains a code representing
specific tax information. This must be
valid Tax Code.
|
|
EDM-TAX-BASIS
Element: Tax Basis | Alpha 1
|
|
EDM-REF-WITHELD
Element: Ref Witheld | Alpha 1
|
|
EDM-P46-ISSUED
Element: P46 Issued | Alpha 1
|
|
EDM-P46-ISSUE-DATE
Element: P46 Issue Date | Numeric 8 (yyyymmdd)
|
|
EDM-P45-ISSUED
Element: P45 Issued | Alpha 1
|
|
EDM-P45-ISSUE-DATE
Element: P45 Issue Date | Numeric 8 (yyyymmdd)
|
|
EDM-PAY-FREQUENCY
Element: Pay Frequency | Numeric 1
|
|
EDM-CONTRACTED-OUT
Element: Contracted Out | Alpha 1
|
|
EDM-DFLT-TCA-FLAG
Element: Dflt Tca Flag | Numeric 4
This BSI parameter indicates whether or
not the provincial (TCA) total claim
amount is used when the total claim
amount interface is zero.
0000 = Not applicable
0009 = Lock-in |
|
EDM-HM-PROC-LEVEL
Element: Process Level | Alpha 5
This field contains the process level,
which is the reporting hierarchy below
company.
|
|
EDM-EXCLUDE-AMT
Element: Exclude Amt | Signed 13.4
|
|
EDM-EXCL-AMT-FLAG
Element: Excl Amt Flag | Alpha 1
|
|
EDM-CREATE-DATE
Element: Date Stamp | Numeric 8 (yyyymmdd)
This field contains the server date
(month, date, and year) of the last
change to this record.
|
|
EDM-CREATE-TIME
Element: Time Stamp | Numeric 6 (hhmmss)
Contains the server time (hour, minute,
and second) when the record was last
changed.
|
|
EDM-CREATE-USER-ID
Element: User Id | Alpha 10 (Lower Case)
Contains the user ID of the person who
last changed this record.
|
|
EDM-DATE-STAMP
Element: Date Stamp | Numeric 8 (yyyymmdd)
This field contains the server date
(month, date, and year) of the last
change to this record.
|
|
EDM-TIME-STAMP
Element: Time Stamp | Numeric 6 (hhmmss)
Contains the server time (hour, minute,
and second) when the record was last
changed.
|
|
EDM-USER-ID
Element: User Id | Alpha 10 (Lower Case)
Contains the user ID of the person who
last changed this record.
|
|
EDM-TOT-CLM-AMT-FL
Element: Tot Clm Amt Fl | Numeric 4
0000
0001 |
|
EDM-NON-IND-CL-AMT
Element: Non Ind Cl Amt | Signed 10.2
|
|
EDM-TRANS-YTD-WAGE
Element: Trans Ytd Wage | Signed 10.2
|
|
EDM-TRANS-YTD-TAX
Element: Trans Ytd Tax | Signed 10.2
|
|
EDM-TRANS-YEAR
Element: Trans Year | Numeric 4
|
|
EDM-CLAIM-CODE
Element: Claim Code | Alpha 3
Claim Code is used in tax credit
calculations by BSI Tax Factory Canada
A = Engage BSI Claim Code Lookup
E = Exempt from income tax only
X = Use TCA amt without inflation
0 = No Claim amount applied
1 = Claim Code Value 1
2 = Claim Code Value 2
3 = Claim Code Value 3
4 = Claim Code Value 4
5 = Claim Code Value 5
6 = Claim Code Value 6
7 = Claim Code Value 7
8 = Claim Code Value 8
9 = Claim Code Value 9
10 = Claim Code Value 10 |
|
EDM-JOIN-LEAVE-FLG
Element: Join Leave Flg | Alpha 1
|
|
