Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAYMASTR


                             PAYMASTR FILE

                        Employee Payment Master

This file is the driving file of the payroll cycle programs. PR140 (Earnings
and Deductions Calculation) creates one system Employee Payment Master file
record for all Employee Time Cards file records with like check groups. PR80.1
(Manual Payment) creates manual Employee Payment Master file records. The
other PR80 series programs create other types of Employee Payment Master file
records. PR160 (Payment Print) creates one Employee Payment file record for
every Employee Payment Master file record produced by PR140 (Earnings and
Deductions Calculation). When you close a payroll cycle, the system rolls the
information from the Employee Payment Master file record into the Quarterly
Wage file.

REFERENCED BY

HR170     HR70.1    PR125     PR141     PR142     PR155
PR160     PR162     PR180     PR198     PR226     PR247
PR265     PR275     PR277     PR289     PR29.1    PR51.3
PR51.1    PR55.1    UK141     UK145     UK277     UK50.3
UK50.1    TP135     BN150     HR00.1    HR01.1    PBIP.1
PR01.2    PR128     PR130     PR131     PR132     PR134
PR136     PR32.2    PR33.2    PR33.3    PR35.1    PR35.2
PR35.3    PR35.4    PR35.5    PR35.6    PR35.8    PR35.9
PR529     PR530     UK102     TA147     BN100     BN101
BN102     BN103     BN105     BN145     BN232     BN245
BN300     BN305     BN31.1    BN31.2    BN32.1    BN32.2
BN32.3    BN330     BN340     BN345     BN45.1    BN531
BN65.1    BN71.1    BN72.1    BS13.1    BS14.1    BS15.1
BS32.1    HCDL.1    PA495     PA594     PR188     PR260
PR270     PR276     PR278     PR418     PR50.2    PR84.1
UK201     UK202     TP140

UPDATED BY

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     PR13.1
PR13.5    PR13.6    PR13.8    PR197     PR300     PR36.1
PR45.1    PR560     PR82.1    PR85.1    PR86.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PYM-COMPANY            Numeric 4                                 PR560   PR82.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PYM-EMPLOYEE           Numeric 9                                 PR560   PR82.1
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PYM-CHECK-ID           Numeric 12                                PR560   PR82.1
Internal Check ID      Contains the payment identification       PR85.1
Number                 number. The value of this field is
                       determined by the Last Check ID field in
                       the HR Company and Process Levels file
                       for the bank account on which this
                       payment is drawn.

                       This field, along with the bank account
                       number, serves as the link to the
                       Employee Payment Hours/Wages file,
                       Employee Payment Deductions file,
                       Employee ACH Distribution file,
                       Employee Payment file, and Employee
                       Payment Distribution file records
                       associated with this payment.

PYM-STATUS             Numeric 1                                 PR197   PR560
Element: Status        Contains the payment status. Records      PR85.1
                       are created with a status of zero and
                       are updated to a status of "9" by PR199
                       (Payroll Close).
                       0 = Created
                       9 = Closed

PYM-PROCESS-LEVEL      Alpha 5                                   HR11.1  HR11.2
Element: Process Lev HrContains the employee's home process      HR511   PA02.1
                       level at the time of payment. The         PA100   PA102
                       employee's home process level, at the     PA13.1  PA13.2
                       time the payment is created, is moved to  PA502   PA513
                       this field. If you change an employee's   PA52.1  PA52.3
                       home process level on HR11.1 (Employee)   PA52.4  PA52.5
                       or by a personnel action, all open        PR110   PR113
                       payments are updated to reflect the new   PR120   PR13.1
                       home process level.                       PR13.5  PR13.6
                                                                 PR13.8  PR560
                                                                 PR82.1

PYM-DEPARTMENT         Alpha 5                                   HR11.1  HR11.2
Element: Department    Contains the employee's home department   HR511   PA02.1
                       at the time of payment creation. The      PA100   PA102
                       employee's home department, at the time   PA502   PA52.1
                       of payment creation, is moved to this     PA52.3  PA52.4
                       field. If you change the home department  PA52.5  PR110
                       on HR11.1 (Employee) or by a personnel    PR113   PR120
                       action, all open payments and processed   PR13.1  PR13.5
                       time records are updated to reflect the   PR13.6  PR13.8
                       new home department.                      PR560   PR82.1

PYM-BANK-CODE          Alpha 4                                   PR560   PR82.1
Element: Bank Code     Contains the bank code associated with
                       the payment or adjustment.

PYM-GROSS-PAY          Signed 13.2                               PR560   PR82.1
Element: Gross Pay     Contains the gross payment amount.        PR85.1

PYM-NET-PAY-AMT        Signed 13.2                               PR560   PR82.1
Element: Net Pay Amt   Contains the net pay for the payment.     PR85.1
                       Net Pay is gross pay reduced
                       by all S (Employee Paid) deductions
                       and increased by any A (Add-to-Net)
                       deductions.

PYM-DED-CYCLE-NBR      Numeric 1                                 PR560
Element: Ded Cycle Nbr Contains the deduction cycle that was
                       used when processing this payment. The
                       Benefits system uses this field to track
                       the number of cycles left in a flex year
                       for an employee. The number of cycles
                       left is tracked in the Employee Flexible
                       Dollars file record with the calculation
                       taking place in PR199 (Payroll Close).

PYM-CHECK-DATE         Numeric 8  (yyyymmdd)                     PR560   PR82.1
Element: Payment Date  Contains the payment date.                PR85.1  PR86.1

PYM-PER-END-DATE       Numeric 8  (yyyymmdd)                     PR560   PR82.1
Element: Period End DatContains the payroll period ending date.  PR85.1

PYM-CHECK-TYPE         Alpha 1                                   PR560   PR82.1
Element: Payment Type  Contains the payment type. When you       PR85.1  PR86.1
                       void a payment in PR85.1 (Bank Account
                       Reconciliation) the original payment
                       type is changed to R (Reversal).
                       A = ACH
                       J = Adjustment
                       M = Manual
                       P = Partial ACH
                       R = Reversal
                       S = System
                       V = Partial Void
                       G = Gross Up

PYM-CHECK-NET          Signed 13.2                               PR560   PR82.1
Element: Net Payment AmContains the actual amount for which a    PR85.1  PR86.1
                       payment is created. ACH amounts are not
                       included.

PYM-CHECK-NBR          Numeric 8                                 PR197   PR560
Element: Payment NumberContains the payment number. When an      PR86.1
                       Employee Payment file record is created
                       for a payment, the payment  number is
                       stored in this field. The system
                       maintains history associated with the
                       payment number even if the Employee
                       Payment file record is deleted.

PYM-DATE-STAMP         Numeric 8  (yyyymmdd)                     PR197   PR560
Element: Date Stamp    This field contains the server date       PR85.1
                       (month, date, and year) of the last
                       change to this record.

PYM-TIME-STAMP         Numeric 6  (hhmmss)                       PR197   PR560
Element: Time Stamp    Contains the server time (hour, minute,   PR85.1
                       and second) when the record was last
                       changed.

PYM-COUNTRY-CODE       Alpha 2                                   PR560   PR82.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

PYM-SECCLASS           Derived
Element: Secclass

PYM-CURRENCY-CODE      Alpha 5                                   PR560   PR82.1
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

PYM-CURR-ND            Numeric 1                                 PR560   PR82.1
Account Currency       Represents the number of decimals
Code                   defined for the currency of the object.

PYM-PENS-SEQ-NBR       Numeric 4                                 PR560   PR82.1
Element: Pens Seq Nbr

PYM-NON-TXBL-REMUN     Signed 13.2                               PR560   PR82.1
Element: Non Txbl Remun

PYM-OT-PLAN-CODE       Alpha 4
Element: Ot Plan Code  Identifies pay plan in effect for
                       employee when PRDISTRIB record was
                       created from PR197 (PRPRD).

PYM-PERIOD-NBR         Numeric 3
Element: Period Nbr

PYM-PAYROLL-YEAR       Numeric 4
Element: Current PayrolContains the payroll year in which the
                       allocation was taken.

PYM-GM-ADJ-FLAG        Numeric 1
Element: Gm Adj Flag   Indicates if adjustment records were
                       created by GM170.
                       0 = Not Created by GM
                       1 = Created by GM

                         PAYMASTR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PYMSET1   COMPANY                                                HR11.1  HR11.2
          EMPLOYEE                                               HR170   HR511
          CHECK-ID                                               HR70.1  PA02.1
                                                                 PA100   PA102
                                                                 PA502   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR125   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR141
                                                                 PR142   PR155
                                                                 PR160   PR162
                                                                 PR180   PR197
                                                                 PR198   PR226
                                                                 ...

PYMSET10  COMPANY       KeyChange
          PROCESS-LEVEL
          EMPLOYEE
          CHECK-ID

PYMSET2   COMPANY       KeyChange, Subset                        BN150   HR00.1
          BANK-CODE     Where STATUS = Zeroes                    HR01.1  PBIP.1
          PROCESS-LEVEL                                          PR01.2  PR128
          CHECK-TYPE                                             PR130   PR131
          EMPLOYEE                                               PR132   PR134
          CHECK-ID                                               PR136   PR141
                                                                 PR160   PR197
                                                                 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  PR45.1
                                                                 PR529   PR530
                                                                 ...

PYMSET4   COMPANY       KeyChange                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          CHECK-DATE                                             BN105   BN145
          CHECK-NBR                                              BN232   BN245
          CHECK-ID                                               BN300   BN305
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN330
                                                                 BN340   BN345
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HCDL.1
                                                                 HR170   HR70.1
                                                                 ...

PYMSET5   COMPANY       KeyChange, Subset                        HR11.1  HR11.2
          PROCESS-LEVEL Where STATUS = Zeroes                    HR511   PA02.1
          EMPLOYEE                                               PA100   PA102
          CHECK-TYPE                                             PA13.1  PA13.2
          CHECK-ID                                               PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR132
                                                                 PR141   PR142
                                                                 PR160   PR180
                                                                 PR197   PR36.1
                                                                 PR82.1  PR82.2
                                                                 ...

PYMSET6   COMPANY       KeyChange                                PR197
          DATE-STAMP
          TIME-STAMP
          PROCESS-LEVEL
          EMPLOYEE
          CHECK-TYPE
          CHECK-ID

PYMSET7   COMPANY       KeyChange                                HR00.1  HR01.1
          COUNTRY-CODE                                           PBIP.1  PR197
          PROCESS-LEVEL
          EMPLOYEE
          CHECK-TYPE
          CHECK-ID

PYMSET8   COMPANY       KeyChange, Subset                        PR29.1  PR529
          EMPLOYEE      Where PENS-SEQ-NBR != Zeroes             PR560   PR82.1
          PENS-SEQ-NBR
          CHECK-ID

PYMSET9   COMPANY       KeyChange, Subset
          EMPLOYEE      Where COUNTRY-CODE = "UK"
          PAYROLL-YEAR  Or    COUNTRY-CODE = "GB"
          OT-PLAN-CODE
          PERIOD-NBR
          CHECK-ID

                         PAYMASTR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bank Account   BANKACCT     Required

                            BFL-BNK-ACCT-NBR     -> BAC-BNK-ACCT-NBR  (BACSET1)

Bank Code      BANKFILE     Required

                            PYM-COMPANY          -> BFL-COMPANY
                            PYM-BANK-CODE        -> BFL-BANK-CODE

Company        PRSYSTEM     Required

                            PYM-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Cucodes        CUCODES      Not Required

                            PYM-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Department     DEPTCODE     Required
                            When PYM-DEPARTMENT != Spaces

                            PYM-COMPANY          -> DPT-COMPANY
                            PYM-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            PYM-DEPARTMENT       -> DPT-DEPARTMENT

Employee       EMPLOYEE     Required

                            PYM-COMPANY          -> EMP-COMPANY
                            PYM-EMPLOYEE         -> EMP-EMPLOYEE

Pr1099rhst     PR1099RHST   Not Required

                            PYM-COMPANY          -> PHR-COMPANY
                            PYM-EMPLOYEE         -> PHR-EMPLOYEE
                            PYM-CHECK-ID         -> PHR-CHECK-ID
                            PYM-PENS-SEQ-NBR     -> PHR-PENS-SEQ-NBR

Prcheck        PRCHECK      Not Required

                            PYM-COMPANY          -> PCH-COMPANY
                            PYM-CHECK-ID         -> PCH-CHECK-ID

Process Level  PRSYSTEM     Required

                            PYM-COMPANY          -> PRS-COMPANY
                            PYM-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

Prpenpay       PRPENPAY     Not Required

                            PYM-COMPANY          -> PNP-COMPANY
                            PYM-EMPLOYEE         -> PNP-EMPLOYEE
                            PYM-PENS-SEQ-NBR     -> PNP-PENS-SEQ-NBR

                         PAYMASTR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ach Distribs   EMPACHDIST   Delete Cascades

                            PYM-COMPANY          -> ACD-COMPANY
                            PYM-EMPLOYEE         -> ACD-EMPLOYEE
                            PYM-CHECK-ID         -> ACD-CHECK-ID
                                                    ACD-ACH-DIST-NBR

Adjustments    PRTRDADJ

                            PYM-COMPANY          -> PTA-COMPANY
                            PYM-EMPLOYEE         -> PTA-EMPLOYEE
                            PYM-CHECK-ID         -> PTA-ORIG-CHECK-ID
                                                    PTA-TIME-SEQ

Deductions     PAYDEDUCTN

                            PYM-COMPANY          -> PYD-COMPANY
                            PYM-EMPLOYEE         -> PYD-EMPLOYEE
                            PYM-CHECK-ID         -> PYD-CHECK-ID
                                                    PYD-DED-CODE
                                                    PYD-EDM-SEQ-NBR
                                                    PYD-REPORT-ENTITY
                                                    PYD-BUS-NBR-GRP
                                                    PYD-QC-ENT-NBR-GRP
                                                    PYD-PROCESS-LEVEL
                                                    PYD-WORK-STATE

Prdistrib      PRDISTRIB    Delete Cascades

                            PYM-COMPANY          -> PRD-COMPANY
                            PYM-EMPLOYEE         -> PRD-EMPLOYEE
                            PYM-CHECK-ID         -> PRD-CHECK-ID
                                                    PRD-OBJ-ID

Time Records   TIMERECORD

                            PYM-COMPANY          -> TRD-COMPANY
                            PYM-EMPLOYEE         -> TRD-EMPLOYEE
                            PYM-CHECK-ID         -> TRD-CHECK-ID
                                                    TRD-PAY-SUM-GRP
                                                    TRD-TIME-SEQ

Wage           PRTIME       Delete Cascades

                            PYM-COMPANY          -> PRT-COMPANY
                            PYM-EMPLOYEE         -> PRT-EMPLOYEE
                            PYM-CHECK-ID         -> PRT-CHECK-ID
                                                    PRT-PAY-SUM-GRP
                                                    PRT-TIME-SEQ