ONETMDED – Payroll One-time Deduction

System
Payroll (PR)
Prefix
OTD
Primary key
COMPANY, EMPLOYEE, DED-CODE, EDM-SEQ-NBR, SEQ-NBR
Fields
26
Updated by
53 programs
Referenced by
78 programs

ONETMDED is the Payroll One-time Deduction table in Lawson Payroll (prefix OTD). It is indexed by COMPANY, EMPLOYEE, DED-CODE, EDM-SEQ-NBR, SEQ-NBR (OTDSET1); alternate indexes: OTDSET2, OTDSET3 and OTDSET4. It is related 1:1 to PRSYSTEM, DEDCODE and EMPLOYEE. It is updated by BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 and 45 more and referenced by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 and 70 more. The table has 26 fields, 4 indexes and 4 documented relations.

About ONETMDED

This file has two purposes in the Payroll system. PR140 (Earnings and Deductions Calculation) uses this file to create arrears deductions when the system cannot take an employee deduction in a payroll cycle. Secondly, you can create Payroll One-time Deduction file records in PR39.1 (One Time Deduction). If an Employee Deduction file record does not exist when you add a one-time deduction, PR39.1 (One Time Deduction) creates one. One-time deductions follow a status flow similar to time records (see the Status field in the Payroll One-time Deduction file). After PR140 (Earnings and Deductions Calculation) takes a Payroll One-time Deduction file record, PR199 (Payroll Close) deletes the deduction.

Fields (26)

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

Field / columnTypeDescription & valuesUpdated by
OTD-COMPANY PK
COMPANY		Numeric 4—BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +6 more
OTD-EMPLOYEE PK
EMPLOYEE		Numeric 9Valid in the Employee file.BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +6 more
OTD-DED-CODE PK
DED_CODE		Alpha 4Valid in the Deduction file.BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +6 more
OTD-EDM-SEQ-NBR PK
EDM_SEQ_NBR		Numeric 4Contains an automatically assigned number to keep records unique.BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +6 more
OTD-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains the one-time deduction sequence number. The value in this field is automatically sequenced based on the value in the Last Deduction Sequence Nbr field in the Employee file.BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +6 more
OTD-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5Contains the employee's process level. The value in this field defaults from the Process Level field in the Employee file. When you update processed one-time deductions the system uses the value in this field to set the PR140 (Earnings and Deductions Calculation) run flag to spaces for this process level. When you run PR199 (Payroll Close) by process level, the system uses the value in this field to determine if the one-time deduction should be updated during the run.BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +38 more
OTD-DED-AMT
DED_AMT		Signed 13.2Contains the deduction amount entered in PR39.1 (One Time Deduction) or calculated by PR140 (Earnings and Deductions Calculation).BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +6 more
OTD-EFFECT-DATE
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the effective date of the one-time deduction. For the system to take the deduction, the value in this field must be equal or less than the payment date entered in PR140 (Earnings and Deductions Calculation).BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +6 more
OTD-DED-TYPE
DED_TYPE		Alpha 1Contains the deduction type. System created arrears deductions G (Garnishment) and W (Withholding) cannot be maintained by PR39.1 (One Time Deduction). PR999 (Payroll Year End Close) deletes system- created Withholding type records.
  • G Garnishment
  • T Tax
BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +6 more
OTD-DED-PRIORITY
DED_PRIORITY		Numeric 1Contains the deduction priority. The value in the Ded Priority field in the Deduction file defaults to this file for arrears deductions and one-time deductions that have not been overridden in PR39.1 (One Time Deduction). The system uses the value in this field to determine the order in which one-time deductions are taken.BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +6 more
OTD-RECORD-TYPE
RECORD_TYPE		Alpha 1Contains the record type created by PR140 (Earnings and Deductions Calculation). PR140 changes type S (System) records to T (Taken) if the deduction is created and taken by PR140 in the same run. PR199 (Payroll Close) sets system created records to A (Arrears). " " = User Entered (Blank)
  • A Payment Arrears
  • S System Temporary
  • T Temp Taken
  • N No Payment Arrears
  • M Manual Selected Blank
  • X Manual Selected Arrears
  • Z Manual Selected No Pmt Arrears
BN66.1, PR139, PR140, PR189, PR195, PR197, PR539, PR80.1 +5 more
OTD-STATUS
STATUS		Numeric 1Contains the status of the one-time deduction. A Future status record cannot be taken by PR140 (Earnings and Deductions Calculation) until it is changed to Current status by PR38.1 (Time Card Selection). A Current status record is taken in the next PR140 run. If a Processed record is changed, the run flag is set to spaces and the employee's time records are set to Error status. This forces you to rerun PR140.
  • 1 Future
  • 2 Current
  • 4 Processed
BN66.1, PR137, PR139, PR140, PR189, PR195, PR197, PR36.1 +12 more
OTD-CHECK-GRP
CHECK_GRP		Alpha 1Contains the check group with which the deduction is associated. PR140 (Earnings and Deductions Calculation) uses the value in this field to determine if the one-time deduction is included in the group.BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +6 more
OTD-CHECK-DESC
CHECK_DESC		Alpha 8 (Lower Case)Contains the payment description defined in PR39.1 (One Time Deduction) that overrides the payment description defined for the deduction. For one-time arrears and one-time deductions with no override payment description, the system uses the description in the Payment Description field in the Deduction file.BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +6 more
OTD-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN66.1, PR140, PR189, PR195, PR39.1, PR39.2, PR539, PR80.1 +4 more
OTD-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN66.1, PR140, PR189, PR195, PR39.1, PR39.2, PR539, PR80.1 +4 more
OTD-BEN-PLAN-TYPE
BEN_PLAN_TYPE		Alpha 2—PR39.1, PR539, PR80.3
OTD-BEN-PLAN-CODE
BEN_PLAN_CODE		Alpha 4—PR39.1, PR539, PR80.3
OTD-BEN-START-DATE
BEN_START_DATE		Numeric 8 (yyyymmdd)—PR39.1, PR539, PR80.3
OTD-CHECK-ID
CHECK_ID		Numeric 12Contains the payment identification number (unique payment identifier used in tracking payment information).BN66.1, PR139, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1 +1 more
OTD-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +5 more
OTD-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +5 more
OTD-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)Contains the user ID of the person who last changed this record.BN66.1, PR139, PR140, PR189, PR195, PR39.1, PR39.2, PR539 +5 more
OTD-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +43 more
OTD-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +43 more
OTD-USER-ID
USER_ID		Alpha 10 (Lower Case)Contains the user ID of the person who last changed this record.BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +43 more

Indexes (4)

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

IndexKeysFlagsConditionUsed in
OTDSET1COMPANY, EMPLOYEE, DED-CODE, EDM-SEQ-NBR, SEQ-NBRPrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
OTDSET2COMPANY, EMPLOYEE, EFFECT-DATE, DED-CODE, EDM-SEQ-NBR, SEQ-NBRKeyChange, SubsetWhere STATUS = 1PR38.1
OTDSET3COMPANY, EMPLOYEE, EFFECT-DATE, DED-PRIORITY, DED-CODE, EDM-SEQ-NBR, SEQ-NBRKeyChange, SubsetWhere STATUS = 2BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
OTDSET4COMPANY, PROCESS-LEVEL, EMPLOYEE, DED-CODE, EDM-SEQ-NBR, SEQ-NBRKeyChangePR160, PR180, PR239, PR80.2, PR999

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredOTD-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Deduction CodeDEDCODERequiredOTD-COMPANY → DDC-COMPANY, OTD-DED-CODE → DDC-DED-CODE
EmployeeEMPLOYEERequiredOTD-COMPANY → EMP-COMPANY, OTD-EMPLOYEE → EMP-EMPLOYEE
Process LevelPRSYSTEMRequiredWhen OTD-PROCESS-LEVEL != SpacesOTD-COMPANY → PRS-COMPANY, OTD-PROCESS-LEVEL → PRS-PROCESS-LEVEL

Programs

Updated by (53)

Referenced by (78)