EMDEDMASTR – Employee Deduction

System: Payroll (PR)
Prefix: EDM
Primary key: COMPANY, EMPLOYEE, DED-CODE, SEQ-NBR
Fields: 109
Updated by: 137 programs
Referenced by: 26 programs

EMDEDMASTR is the Employee Deduction table in Lawson Payroll (prefix EDM). It is indexed by COMPANY, EMPLOYEE, DED-CODE, SEQ-NBR (EDMSET1); alternate indexes: EDMSET2, EDMSET3, EDMSET4, EDMSET5 and EDMSET6. It is related 1:1 to GLMASTER, PRSYSTEM, DEDCODE and EMPLOYEE and 1:M to PAYDEDUCTN, PREMDEDHST and QUARTDED. It is updated by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 and 129 more and referenced by BN15.1, BN231, BN51.2, HR170, HR211, HR70.1, HR93.5, PR02.1 and 18 more. The table has 109 fields, 6 indexes and 8 documented relations.

About EMDEDMASTR

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.

Fields (109)

Column = COBOL field name without the EDM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`EDM-COMPANY` PK COMPANY	Numeric 4	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-DED-CODE` PK DED_CODE	Alpha 4	Contains the user-defined value that represents a deduction.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-SEQ-NBR` PK 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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-DED-CYCLE` DED_CYCLE	Alpha 1 Occurs 9 Times ×9	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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-BALANCE-TYPE` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-BALANCE-AMT` BALANCE_AMT	Signed 18.2	Contains the balance amount for deductions that have a balance type.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-NEXT-AMOUNT` NEXT_AMOUNT	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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-DED-PRIORITY` DED_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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-EFFECT-DATE` 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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-END-DATE` 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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-ARREARS` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-PCT-MATCHED` 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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-MONTHLY-LIMIT` 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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-PAY-PRD-LIMIT` PAY_PRD_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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-PRIORITY-FLAG` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-ARREARS-FLAG` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-EFF-DATE-FLAG` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-END-DATE-FLAG` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-DED-CYC-FLAG` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-AMOUNT-FLAG` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-AMOUNT-2-FLAG` AMOUNT_2_FLAG	Alpha 1	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-MTH-LIMIT-FLAG` 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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-PRD-LIMIT-FLAG` PRD_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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-DED-ORDER` DED_ORDER	Numeric 3	Insures that the system processes withholding deductions first.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-RES-CODE` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-MARITAL-STATUS` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-EXEMPTIONS` EXEMPTIONS	Numeric 5	Contains the number of exemptions associated with the employee's tax deduction.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-EXEMPT-AMOUNT` EXEMPT_AMOUNT	Signed 9.2	Contains the exempt amount associated with the employee's tax deduction.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-CERT-CODE` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-PERS-EXEMPTS` PERS_EXEMPTS	Numeric 1	Contains the number of personal exemptions defined for the employee deduction.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-DEPEND-EXEMPTS` DEPEND_EXEMPTS	Numeric 5	Contains the number of dependent exemptions defined for the employee deduction.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-ADDL-EXEMPTS` ADDL_EXEMPTS	Numeric 5	Contains the number of additional exemptions defined for the employee deduction.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-ADDL-EXEMP-AMT` ADDL_EXEMP_AMT	Signed 9.2	Contains the additional exemption amount defined for the employee deduction.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-ADDL-TAX-CODE` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-ADDL-RATE` ADDL_RATE	Signed 7.4	Contains a value if the Addl Tax Code field value indicates a percent.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-ADDL-AMOUNT` ADDL_AMOUNT	Signed 9.2	Contains a value if the Addl Tax Code field value indicates an amount.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-FORMULA-NUMBER` 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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-FILING-STATUS` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-LEVY-EXEMPTS` 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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-LEVY-YEAR` 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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-ADDL-STD-DED` 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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-OBJ-ID` 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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-EXP-DIST-CO` EXP_DIST_CO	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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-EXP-ACCT-UNIT` EXP_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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-EXP-ACCOUNT` EXP_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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-EXP-SUB-ACCT` EXP_SUB_ACCT	Numeric 4	Contains the value from the Expense Subaccount field in the Deduction file. The value is stored in this file for efficiency purposes.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-ACR-DIST-CO` ACR_DIST_CO	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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-ACR-ACCT-UNIT` ACR_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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-ACR-ACCOUNT` ACR_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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-ACR-SUB-ACCT` ACR_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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-SUB-PRIORITY` SUB_PRIORITY	Numeric 2	Defines the order in which deductions are withheld within the same priority for an employee.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-GARN-OBJ-ID` 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.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-AMOUNT-2` AMOUNT_2	Signed 13.4	Used for calculation types 1 and 2.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-NET-CLAIM-AMT` NET_CLAIM_AMT	Signed 11.2	This field is used for Canada income taxes.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-PRESCRIBEDAREA` PRESCRIBEDAREA	Signed 11.2	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-STUDENT-PEN-EX` STUDENT_PEN_EX	Signed 9.2	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-TD1-FILING-DAT` TD1_FILING_DAT	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-TD1-ADJUST-DAT` TD1_ADJUST_DAT	Numeric 8 (yyyymmdd)	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-APPROVED-STOCK` APPROVED_STOCK	Signed 9.2	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-TAX-EXEMPT-FLG` TAX_EXEMPT_FLG	Alpha 1	— `N` No `Y` Yes; Exempt tax only `B` Yes; Exempt both tax and wages	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-CYC1` CYC1	Derived	—	—
`EDM-CYC2` CYC2	Derived	—	—
`EDM-CYC3` CYC3	Derived	—	—
`EDM-CYC4` CYC4	Derived	—	—
`EDM-CYC5` CYC5	Derived	—	—
`EDM-CYC6` CYC6	Derived	—	—
`EDM-CYC7` CYC7	Derived	—	—
`EDM-CYC8` CYC8	Derived	—	—
`EDM-CYC9` CYC9	Derived	—	—
`EDM-AUTH-TAX-CRED` AUTH_TAX_CRED	Signed 9.2	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-AUTH-TAX-DED` AUTH_TAX_DED	Signed 9.2	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-MARRIED-EQUIV` MARRIED_EQUIV	Alpha 1	— `N` No `Y` Yes	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-AGE-65-OVER` AGE_65_OVER	Alpha 1	— `N` No `Y` Yes	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-EMP-DISABILITY` EMP_DISABILITY	Alpha 1	— `N` No `Y` Yes	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-DEP-UNDER-18` DEP_UNDER_18	Numeric 2	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-DEP-DIS-OVR-17` DEP_DIS_OVR_17	Numeric 2	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-NI-CODE` NI_CODE	Alpha 1	—	—
`EDM-DIRECTOR` DIRECTOR	Alpha 1	—	—
`EDM-NI-CERT-ISSUED` NI_CERT_ISSUED	Numeric 8 (yyyymmdd)	—	—
`EDM-NI-CERT-NBR` NI_CERT_NBR	Alpha 10	—	—
`EDM-TAX-CODE` TAX_CODE	Alpha 10	This field contains a code representing specific tax information. This must be valid Tax Code.	—
`EDM-TAX-BASIS` TAX_BASIS	Alpha 1	—	—
`EDM-REF-WITHELD` REF_WITHELD	Alpha 1	—	—
`EDM-P46-ISSUED` P46_ISSUED	Alpha 1	—	—
`EDM-P46-ISSUE-DATE` P46_ISSUE_DATE	Numeric 8 (yyyymmdd)	—	—
`EDM-P45-ISSUED` P45_ISSUED	Alpha 1	—	—
`EDM-P45-ISSUE-DATE` P45_ISSUE_DATE	Numeric 8 (yyyymmdd)	—	—
`EDM-PAY-FREQUENCY` PAY_FREQUENCY	Numeric 1	—	—
`EDM-CONTRACTED-OUT` CONTRACTED_OUT	Alpha 1	—	—
`EDM-DFLT-TCA-FLAG` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-HM-PROC-LEVEL` HM_PROC_LEVEL	Alpha 5	This field contains the process level, which is the reporting hierarchy below company.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-EXCLUDE-AMT` EXCLUDE_AMT	Signed 13.4	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-EXCL-AMT-FLAG` EXCL_AMT_FLAG	Alpha 1	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	Contains the user ID of the person who last changed this record.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-USER-ID` USER_ID	Alpha 10 (Lower Case)	Contains the user ID of the person who last changed this record.	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-TOT-CLM-AMT-FL` TOT_CLM_AMT_FL	Numeric 4	0000 0001	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-NON-IND-CL-AMT` NON_IND_CL_AMT	Signed 10.2	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-TRANS-YTD-WAGE` TRANS_YTD_WAGE	Signed 10.2	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-TRANS-YTD-TAX` TRANS_YTD_TAX	Signed 10.2	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-TRANS-YEAR` TRANS_YEAR	Numeric 4	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-CLAIM-CODE` 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	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)
`EDM-JOIN-LEAVE-FLG` JOIN_LEAVE_FLG	Alpha 1	—	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +52 more (list truncated in source)

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`EDMSET1`	`COMPANY`, `EMPLOYEE`, `DED-CODE`, `SEQ-NBR`	Primary	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
`EDMSET2`	`COMPANY`, `DED-CODE`, `EMPLOYEE`, `SEQ-NBR`		BN100, BN101, BN102, BN103, BN105, BN145, BN15.1, BN245 +22 more (list truncated in source)
`EDMSET3`	`COMPANY`, `EMPLOYEE`, `DED-ORDER`, `DED-PRIORITY`, `SUB-PRIORITY`, `DED-CODE`, `SEQ-NBR`	KeyChange	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
`EDMSET4`	`OBJ-ID`	KeyChange	HR170, HR70.1, PR280
`EDMSET5`	`COMPANY`, `EMPLOYEE`, `DED-CODE`, `EFFECT-DATE*`, `SEQ-NBR`	KeyChange	ZH230, PR14.2, PR39.2, PR514, PR539, PR82.1
`EDMSET6`	`COMPANY`, `HM-PROC-LEVEL`, `EMPLOYEE`, `DED-CODE`, `SEQ-NBR`	KeyChange	BN150, BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR170, HR28.1 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

One to many (3) — child tables

Relation	Table	Rules	Field map
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`

Programs

Updated by (137)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN104 Frequency Table Update
BN105 Plan Update
BN145 Flex Dollars Calculation
BN150 Life Insurance Reportable Income
BN232 Benefits Statement
BN245 Benefit Election Form
BN260 Employee Benefit Extract
BN305 Highly Compensated Employees
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN320 Premium Report
BN331 HIPAA Certification Report
BN340 ADP and ACP Tests
BN430 Benefit Purge
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN65.1 Election Simulation
BN66.1 Estimated Pay Calculation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS10.1 Web Enrollment Current Benefit Inquiry
BS12.1 Web Enrollment Eligible New Plans
BS13.1 Web Enrollment Coverage Options
BS14.1 Web Enrollment Coverage Amounts
BS15.1 Web Enrollment Contribution Limits
BS32.1 Web Enrollment Stop Benefits Update
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR511 Employee Conversion
LP130 Absence Plan Payout
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR114 Create Linked Deduction
PR115 Deduction, Garnishment Fee, Pay Summary Grp Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR128 Offset Time Record Creation
PR13.1 Employee United States Taxes
PR13.2 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR14.1 Employee Deduction
PR14.2 Tax Withholding Lock-In
PR140 Earnings and Deductions Calculation
PR15.1 Deduction Speed Entry
PR15.2 Employee Deduction Speed Entry
PR160 Payment Print
PR180 Manual Payment Print
PR189 Gross Up Calculation
PR195 Accrual Program
PR197 Payroll Close
PR205 Deduction Listing
PR26.1 United States Employee Garnishment
PR26.2 United States Employee Garnishment Inquiry
PR29.1 Pension Payment Maintenance
PR30.2 Employee Automatic Time Record
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR39.1 One Time Deduction
PR39.2 One Time Deduction Speed
PR45.1 Error Processing
PR47.1 Canada Employee Garnishment
PR47.2 Canada Employee Garnishment Inquiry
PR512 Employee ACH Distribution Interface
PR514 Employee Deduction Master Load
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR539 One Time Deduction Load
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.2 Manual Payment Print
PR80.3 Manual Payment One Time Deduction
PR80.4 Manual Payment
PR82.1 Adjustment
PR85.1 Bank Account Reconciliation
PR89.1 Payment Modeling
PRAT.1 Alltax connection test
TA147 Canada Vacation Audit
UK102 Bonus Pay Update
ZB01.1 Years Of Service Calculation
ZB10.1 Coverage Options Calculator
ZB10.2 Get Benefit Eligibility Dates
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add
ZH510 Update PCP from ZPENDPCP

Referenced by (26)

BN15.1 Benefit Plan
BN231 Employee Benefit Report
BN51.2 Employee Benefit Detail
HR170 Human Resource Writer Report Request
HR211 Employee Listing
HR70.1 Human Resource Writer Inquiry
HR93.5 Employee Deduction Audit Inquiry
PR02.1 Deduction Class
PR05.1 Deduction
PR139 Arrears Automation
PR141 Payroll Register
PR214 Employee Deduction Listing
PR226 United States Employee Garnishment Listing
PR239 One Time Deduction Listing
PR240 T4-T4A Slips
PR241 T4-T4A XML
PR247 Canada Employee Garnishment Listing
PR260 Payment Detail Listing
PR261 Payment Detail Listing By Report Entity
PR277 Garnishment History Report
PR280 Deduction Audit Report
PR299 EFW2 File Creation
ZH230 PPH Big Bad Edit
ZP139 PPH Union Dues Calc
ZP555 HealthEquity Export Interface
ZP580 Foundation Contributions Iface