PAYMASTR – Employee Payment Master

System
Payroll (PR)
Prefix
PYM
Primary key
COMPANY, EMPLOYEE, CHECK-ID
Fields
29
Updated by
58 programs
Referenced by
111 programs

PAYMASTR is the Employee Payment Master table in Lawson Payroll (prefix PYM). It is indexed by COMPANY, EMPLOYEE, CHECK-ID (PYMSET1); alternate indexes: PYMSET10, PYMSET11, PYMSET12, PYMSET2, PYMSET3, PYMSET4, PYMSET5, PYMSET6 and 3 more. It is related 1:1 to BANKACCT, BANKFILE, PRSYSTEM, CUCODES, DEPTCODE, EMPLOYEE, PR1099RHST, PRCHECK and 1 more and 1:M to EMPACHDIST, PRTRDADJ, PAYDEDUCTN, PRDISTRIB, TIMERECORD and PRTIME. It is updated by BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 and 50 more and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN150, BN232 and 103 more. The table has 29 fields, 12 indexes and 16 documented relations.

About PAYMASTR

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.

Fields (29)

Column = COBOL field name without the PYM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PYM-COMPANY PK
COMPANY		Numeric 4—BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
#PYM-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
#PYM-CHECK-ID PK
CHECK_ID		Numeric 12Contains the payment identification 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.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +4 more
#PYM-STATUS
STATUS		Numeric 1Contains the payment status. Records are created with a status of zero and are updated to a status of "9" by PR199 (Payroll Close).
  • 0 Created
  • 9 Closed
PR197, PR560, PR85.1
#PYM-PROCESS-LEVEL SET10 SET2 SET3 SET5 SET6 SET7
PROCESS_LEVEL		Alpha 5Contains the employee's home process level at the time of payment. The employee's home process level, at the time the payment is created, is moved to this field. If you change an employee's home process level on HR11.1 (Employee) or by a personnel action, all open payments are updated to reflect the new home process level.BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +35 more
#PYM-DEPARTMENT
DEPARTMENT		Alpha 5Contains the employee's home department at the time of payment creation. The employee's home department, at the time of payment creation, is moved to this field. If you change the home department on HR11.1 (Employee) or by a personnel action, all open payments and processed time records are updated to reflect the new home department.BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +35 more
#PYM-BANK-CODE SET2
BANK_CODE		Alpha 4Contains the bank code associated with the payment or adjustment.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
#PYM-GROSS-PAY
GROSS_PAY		Signed 13.2Contains the gross payment amount.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +4 more
#PYM-NET-PAY-AMT
NET_PAY_AMT		Signed 13.2Contains the net pay for the payment. Net Pay is gross pay reduced by all S (Employee Paid) deductions and increased by any A (Add-to-Net) deductions.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +4 more
#PYM-DED-CYCLE-NBR
DED_CYCLE_NBR		Numeric 1Contains 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).BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR89.1 +1 more
#PYM-CHECK-DATE SET11 SET4
CHECK_DATE		Numeric 8 (yyyymmdd)Contains the payment date.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +5 more
#PYM-PER-END-DATE SET12
PER_END_DATE		Numeric 8 (yyyymmdd)Contains the payroll period ending date.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
#PYM-CHECK-TYPE SET2 SET5 SET6 SET7
CHECK_TYPE		Alpha 1Contains the payment type. When you 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
  • D Gross Up Direct Deposit
  • B Gross Up Both System and DD
  • C Contract
  • H Manual Direct Deposit
BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +5 more
#PYM-CHECK-NET
CHECK_NET		Signed 13.2Contains the actual amount for which a payment is created. ACH amounts are not included.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +5 more
#PYM-CHECK-NBR SET11 SET4
CHECK_NBR		Numeric 8Contains the payment number. When an 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.PR197, PR560, PR80.1, PR80.4, PR86.1
#PYM-DATE-STAMP SET6
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PR197, PR560, PR85.1
#PYM-TIME-STAMP SET6
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PR197, PR560, PR85.1
#PYM-COUNTRY-CODE SET7
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
#PYM-SECCLASS
SECCLASS		Derived——
#PYM-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
#PYM-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, PR560, PR582, PR80.1, PR80.4 +3 more
#PYM-PENS-SEQ-NBR SET8
PENS_SEQ_NBR		Numeric 4—BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
#PYM-NON-TXBL-REMUN
NON_TXBL_REMUN		Signed 13.2—BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR82.1 +3 more
#PYM-OT-PLAN-CODE SET12 SET9
OT_PLAN_CODE		Alpha 4Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD).BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#PYM-PERIOD-NBR SET9
PERIOD_NBR		Numeric 3For Future Development Use—
#PYM-PAYROLL-YEAR SET12 SET9
PAYROLL_YEAR		Numeric 4For Future Development UseBN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +2 more
#PYM-GM-ADJ-FLAG
GM_ADJ_FLAG		Numeric 1Indicates if adjustment records were created by GM170.
  • 0 Not Created by GM
  • 1 Created by GM
—
#PYM-PRINT-RCPT
PRINT_RCPT		Alpha 1—BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#PYM-INTERFACE-FLAG SET3
INTERFACE_FLAG		Numeric 1—PR197

Indexes (12)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PYMSET1
  1. COMPANY
  2. EMPLOYEE
  3. CHECK-ID
PrimaryBN305, BN66.1, HR11.1, HR11.2, HR11.4, HR170, HR28.1, HR511 +22 more (list truncated in source)
PYMSET10
  1. COMPANY
  2. PROCESS-LEVEL
  3. EMPLOYEE
  4. CHECK-ID
KeyChange—
PYMSET11
  1. COMPANY
  2. EMPLOYEE
  3. CHECK-DATE ↓
  4. CHECK-NBR ↓
  5. CHECK-ID
KeyChange, SubsetWhere CHECK-NBR != ZeroesPR50.2, ZP296
PYMSET12
  1. COMPANY
  2. PAYROLL-YEAR
  3. OT-PLAN-CODE
  4. PER-END-DATE
  5. EMPLOYEE
  6. CHECK-ID
PR141
PYMSET2
  1. COMPANY
  2. BANK-CODE
  3. PROCESS-LEVEL
  4. CHECK-TYPE
  5. EMPLOYEE
  6. CHECK-ID
KeyChange, SubsetWhere STATUS = ZeroesBN150, HR00.1, HR01.1, PR521, EXI2.1, EXI4.1, LP130, PR01.2 +22 more (list truncated in source)
PYMSET3
  1. COMPANY
  2. INTERFACE-FLAG
  3. PROCESS-LEVEL
  4. EMPLOYEE
  5. CHECK-ID
KeyChange, SubsetWhere STATUS = 9—
PYMSET4
  1. COMPANY
  2. EMPLOYEE
  3. CHECK-DATE
  4. CHECK-NBR
  5. CHECK-ID
KeyChangeBN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source)
PYMSET5
  1. COMPANY
  2. PROCESS-LEVEL
  3. EMPLOYEE
  4. CHECK-TYPE
  5. CHECK-ID
KeyChange, SubsetWhere STATUS = ZeroesBN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +22 more (list truncated in source)
PYMSET6
  1. COMPANY
  2. DATE-STAMP
  3. TIME-STAMP
  4. PROCESS-LEVEL
  5. EMPLOYEE
  6. CHECK-TYPE
  7. CHECK-ID
KeyChangeBN66.1, PR139, PR140, PR189, PR195, PR197, PR80.1, PR80.4 +6 more
PYMSET7
  1. COMPANY
  2. COUNTRY-CODE
  3. PROCESS-LEVEL
  4. EMPLOYEE
  5. CHECK-TYPE
  6. CHECK-ID
KeyChangeBN66.1, HR00.1, HR01.1, PR139, PR140, PR189, PR195, PR418 +4 more
PYMSET8
  1. COMPANY
  2. EMPLOYEE
  3. PENS-SEQ-NBR
  4. CHECK-ID
KeyChange, SubsetWhere PENS-SEQ-NBR != ZeroesPR29.1, PR529, PR560, PR582, PR82.1
PYMSET9
  1. COMPANY
  2. EMPLOYEE
  3. PAYROLL-YEAR
  4. OT-PLAN-CODE
  5. PERIOD-NBR
  6. CHECK-ID
KeyChange, SubsetWhere COUNTRY-CODE = "UK" Or COUNTRY-CODE = "GB" Or COUNTRY-CODE = "IN"—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BANKACCTBANKFILEPRSYSTEMCUCODESDEPTCODEEMPLOYEEPR1099RHSTPRCHECKPRPENPAYEMPACHDISTPRTRDADJPAYDEDUCTNPRDISTRIBTIMERECORDPRTIMEPAYMASTR

One to one (10) — lookups and parents

RelationTableRulesConditionField map
Bank AccountBANKACCTRequired
BFL-BNK-ACCT-NBR→BAC-BNK-ACCT-NBR (BACSET1)
Bank CodeBANKFILERequired
PYM-COMPANY→BFL-COMPANY
PYM-BANK-CODE→BFL-BANK-CODE
CompanyPRSYSTEMRequired
PYM-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CucodesCUCODESNot Required
PYM-CURRENCY-CODE→CUC-CURRENCY-CODE
DepartmentDEPTCODERequiredWhen PYM-DEPARTMENT != Spaces
PYM-COMPANY→DPT-COMPANY
PYM-PROCESS-LEVEL→DPT-PROCESS-LEVEL
PYM-DEPARTMENT→DPT-DEPARTMENT
EmployeeEMPLOYEERequired
PYM-COMPANY→EMP-COMPANY
PYM-EMPLOYEE→EMP-EMPLOYEE
Pr1099rhstPR1099RHSTNot Required
PYM-COMPANY→PHR-COMPANY
PYM-EMPLOYEE→PHR-EMPLOYEE
PYM-CHECK-ID→PHR-CHECK-ID
PYM-PENS-SEQ-NBR→PHR-PENS-SEQ-NBR
PrcheckPRCHECKNot Required
PYM-COMPANY→PCH-COMPANY
PYM-CHECK-ID→PCH-CHECK-ID
Process LevelPRSYSTEMRequired
PYM-COMPANY→PRS-COMPANY
PYM-PROCESS-LEVEL→PRS-PROCESS-LEVEL
PrpenpayPRPENPAYNot Required
PYM-COMPANY→PNP-COMPANY
PYM-EMPLOYEE→PNP-EMPLOYEE
PYM-PENS-SEQ-NBR→PNP-PENS-SEQ-NBR

One to many (6) — child tables

RelationTableRulesConditionField map
Ach DistribsEMPACHDISTDelete Cascades
PYM-COMPANY→ACD-COMPANY
PYM-EMPLOYEE→ACD-EMPLOYEE
PYM-CHECK-ID→ACD-CHECK-ID
—→ACD-ACH-DIST-NBR
AdjustmentsPRTRDADJ
PYM-COMPANY→PTA-COMPANY
PYM-EMPLOYEE→PTA-EMPLOYEE
PYM-CHECK-ID→PTA-ORIG-CHECK-ID
—→PTA-TIME-SEQ
DeductionsPAYDEDUCTN
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
PrdistribPRDISTRIBDelete Cascades
PYM-COMPANY→PRD-COMPANY
PYM-EMPLOYEE→PRD-EMPLOYEE
PYM-CHECK-ID→PRD-CHECK-ID
—→PRD-OBJ-ID
Time RecordsTIMERECORD
PYM-COMPANY→TRD-COMPANY
PYM-EMPLOYEE→TRD-EMPLOYEE
PYM-CHECK-ID→TRD-CHECK-ID
—→TRD-PAY-SUM-GRP
—→TRD-TIME-SEQ
WagePRTIMEDelete Cascades
PYM-COMPANY→PRT-COMPANY
PYM-EMPLOYEE→PRT-EMPLOYEE
PYM-CHECK-ID→PRT-CHECK-ID
—→PRT-PAY-SUM-GRP
—→PRT-TIME-SEQ

Programs

Updated by (58)

Referenced by (111)