Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ONETMDED


                             ONETMDED FILE

                       Payroll One-time Deduction

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.

REFERENCED BY

AC541     AC542     BN100     BN101     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    PR05.1    PR128     PR130     PR131     PR132
PR134     PR136     PR14.1    PR15.1    PR15.2    PR205
PR214     PR239     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    PR47.1    PR47.2    PR514
PR529     PR530     PR560     PR82.1    UK102     UK47.1
UK47.2    UK560     TA147     UK120

UPDATED BY

BN66.1    HR11.1    HR11.2    HR511     HR650     PA02.1
PA100     PA102     PA13.1    PA13.2    PA502     PA513
PA52.1    PA52.3    PA52.4    PA52.5    PR110     PR113
PR120     PR13.1    PR13.5    PR13.6    PR13.8    PR137
PR139     PR140     PR189     PR195     PR197     PR36.1
PR38.1    PR39.1    PR39.2    PR45.1    PR80.1    PR80.3
PR89.1    PR999     PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OTD-COMPANY            Numeric 4                                 BN66.1  PR139
Element: Company       The company number represents an          PR140   PR189
                       established company and is entered on     PR195   PR39.1
                       all function codes.                       PR39.2  PR80.1
                                                                 PR80.3  PR89.1

OTD-EMPLOYEE           Numeric 9                                 BN66.1  PR139
Element: Employee      Valid in the Employee file.               PR140   PR189
                                                                 PR195   PR39.1
                                                                 PR39.2  PR80.1
                                                                 PR80.3  PR89.1

OTD-DED-CODE           Alpha 4                                   BN66.1  PR139
Element: Deduction CodeValid in the Deduction file.              PR140   PR189
                                                                 PR195   PR39.1
                                                                 PR39.2  PR80.1
                                                                 PR80.3  PR89.1

OTD-EDM-SEQ-NBR        Numeric 4                                 BN66.1  PR139
Emp Deduction          Contains an automatically assigned        PR140   PR189
Sequence Number        number to keep records unique.            PR195   PR39.1
                                                                 PR39.2  PR80.1
                                                                 PR80.3  PR89.1

OTD-SEQ-NBR            Numeric 4                                 BN66.1  PR139
Element: Sequence NumbeContains the one-time deduction           PR140   PR189
                       sequence number. The value in this field  PR195   PR39.1
                       is automatically sequenced based on the   PR39.2  PR80.1
                       value in the Last Deduction Sequence Nbr  PR80.3  PR89.1
                       field in the Employee file.

OTD-PROCESS-LEVEL      Alpha 5                                   BN66.1  HR11.1
Element: Process Level Contains the employee's process level.    HR11.2  HR511
                       The value in this field defaults from     HR650   PA02.1
                       the Process Level field in the Employee   PA100   PA102
                       file. When you update processed one-time  PA13.1  PA13.2
                       deductions the system uses the value in   PA502   PA513
                       this field to set the PR140 (Earnings     PA52.1  PA52.3
                       and Deductions Calculation) run flag to   PA52.4  PA52.5
                       spaces for this process level.            PR110   PR113
                                                                 PR120   PR13.1
                       When you run PR199 (Payroll Close) by     PR13.5  PR13.6
                       process level, the system uses the value  PR13.8  PR139
                       in this field to determine if the         PR140   PR189
                       one-time deduction should be updated      PR195   PR39.1
                       during the run.                           PR39.2  PR80.1
                                                                 PR80.3  PR89.1

OTD-DED-AMT            Signed 13.2                               BN66.1  PR139
Element: Deduction AmouContains the deduction amount entered     PR140   PR189
                       in PR39.1 (One Time Deduction) or         PR195   PR39.1
                       calculated by PR140 (Earnings and         PR39.2  PR80.1
                       Deductions Calculation).                  PR80.3  PR89.1

OTD-EFFECT-DATE        Numeric 8  (yyyymmdd)                     BN66.1  PR139
Element: Date          Contains the effective date of the        PR140   PR189
                       one-time deduction. For the system to     PR195   PR39.1
                       take the deduction, the value in this     PR39.2  PR80.1
                       field must be equal or less than the      PR80.3  PR89.1
                       payment date entered in PR140 (Earnings
                       and Deductions Calculation).

OTD-DED-TYPE           Alpha 1                                   BN66.1  PR139
Element: Deduction TypeContains the deduction type. System       PR140   PR189
                       created arrears deductions G              PR195   PR39.1
                       (Garnishment) and W (Withholding) cannot  PR39.2  PR80.1
                       be maintained by PR39.1 (One Time         PR80.3  PR89.1
                       Deduction). PR999 (Payroll Year End
                       Close) deletes system- created
                       Withholding type records.
                       G = Garnishment
                       T = Tax

OTD-DED-PRIORITY       Numeric 1                                 BN66.1  PR139
Element: Deduction PrioContains the deduction priority. The      PR140   PR189
                       value in the Ded Priority field in the    PR195   PR39.1
                       Deduction file defaults to this file for  PR39.2  PR80.1
                       arrears deductions and one-time           PR80.3  PR89.1
                       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.

OTD-RECORD-TYPE        Alpha 1                                   BN66.1  PR139
Element: Record Type   Contains the record type created by       PR140   PR189
                       PR140 (Earnings and Deductions            PR195   PR197
                       Calculation).                             PR80.1  PR80.3
                                                                 PR89.1
                       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).
                       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
                       " " = User Entered (Blank)

OTD-STATUS             Numeric 1                                 BN66.1  PR137
Element: Status        Contains the status of the one-time       PR139   PR140
                       deduction. A Future status record cannot  PR189   PR195
                       be taken by PR140 (Earnings and           PR197   PR36.1
                       Deductions Calculation) until it is       PR38.1  PR39.1
                       changed to Current status by PR38.1       PR39.2  PR45.1
                       (Time Card Selection). A Current status   PR80.1  PR80.3
                       record is taken in the next PR140 run.    PR89.1
                       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

OTD-CHECK-GRP          Alpha 1                                   BN66.1  PR139
Element: Payment Group Contains the check group with which the   PR140   PR189
                       deduction is associated. PR140 (Earnings  PR195   PR39.1
                       and Deductions Calculation) uses the      PR39.2  PR80.1
                       value in this field to determine if the   PR80.3  PR89.1
                       one-time deduction is included in the
                       group.

OTD-CHECK-DESC         Alpha 8  (Lower Case)                     BN66.1  PR139
Element: Payment DescriContains the payment description          PR140   PR189
                       defined in PR39.1 (One Time Deduction)    PR195   PR39.1
                       that overrides the payment description    PR39.2  PR80.1
                       defined for the deduction.                PR80.3  PR89.1

                       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.

OTD-CURRENCY-CODE      Alpha 5                                   BN66.1  PR140
Element: Currency Code This field contains the company base      PR189   PR195
                       currency code established in Company      PR39.1  PR39.2
                       (GL10.1 ).                                PR80.1  PR80.3
                                                                 PR89.1

OTD-CURR-ND            Numeric 1                                 BN66.1  PR140
Account Currency                                                 PR189   PR195
Code                                                             PR39.1  PR39.2
                                                                 PR80.1  PR80.3
                                                                 PR89.1

OTD-BEN-PLAN-TYPE      Alpha 2                                   PR39.1  PR80.3
Element: Ben Plan Type

OTD-BEN-PLAN-CODE      Alpha 4                                   PR39.1  PR80.3
Element: Ben Plan Code

OTD-BEN-START-DATE     Numeric 8  (yyyymmdd)                     PR39.1  PR80.3
Element: Ben Start Date

OTD-CHECK-ID           Numeric 12                                BN66.1  PR139
Internal Check ID      Contains the payment identification       PR140   PR189
Number                 number (unique payment identifier used    PR195   PR80.1
                       in tracking payment information).         PR89.1

                         ONETMDED FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OTDSET1   COMPANY                                                AC541   AC542
          EMPLOYEE                                               BN100   BN101
          DED-CODE                                               BN102   BN103
          EDM-SEQ-NBR                                            BN104   BN105
          SEQ-NBR                                                BN145   BN150
                                                                 BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN45.1  BN531
                                                                 BN65.1  BN66.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 HR11.1  HR11.2
                                                                 HR511   HR650
                                                                 ...

OTDSET2   COMPANY       KeyChange, Subset                        PR38.1
          EMPLOYEE      Where STATUS = 1
          EFFECT-DATE
          DED-CODE
          EDM-SEQ-NBR
          SEQ-NBR

OTDSET3   COMPANY       KeyChange, Subset                        BN66.1  PR140
          EMPLOYEE      Where STATUS = 2                         PR189   PR195
          EFFECT-DATE                                            PR80.1  PR89.1
          DED-PRIORITY
          DED-CODE
          EDM-SEQ-NBR
          SEQ-NBR

OTDSET4   COMPANY       KeyChange                                PR239   PR999
          PROCESS-LEVEL
          EMPLOYEE
          DED-CODE
          EDM-SEQ-NBR
          SEQ-NBR

OTDSET5   COMPANY       KeyChange
          DED-CODE
          EMPLOYEE
          EDM-SEQ-NBR
          SEQ-NBR

OTDSET6   COMPANY       Subset
          EMPLOYEE      Where BEN-PLAN-TYPE != Spaces
          BEN-START-DATE
          BEN-PLAN-TYPE
          BEN-PLAN-CODE
          DED-CODE
          EDM-SEQ-NBR
          SEQ-NBR

                         ONETMDED FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            OTD-COMPANY          -> PRS-COMPANY  (PRSSET1)
                            Spaces               -> PRS-PROCESS-LEVEL

Deduction Code DEDCODE      Required

                            OTD-COMPANY          -> DDC-COMPANY
                            OTD-DED-CODE         -> DDC-DED-CODE

Employee       EMPLOYEE     Required

                            OTD-COMPANY          -> EMP-COMPANY
                            OTD-EMPLOYEE         -> EMP-EMPLOYEE

Process Level  PRSYSTEM     Required
                            When OTD-PROCESS-LEVEL != Spaces

                            OTD-COMPANY          -> PRS-COMPANY
                            OTD-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL