Lawson Insight Technical Documentation |
|
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 PR139 PR141 PR142
PR155 PR160 PR162 PR180 PR198 PR226
PR247 PR265 PR266 PR274 PR275 PR277
PR282 PR287 PR289 PR29.1 PR51.3 PR51.1
PR55.1 UK141 UK145 UK277 UK50.3 UK50.1
BN150 ETI2.1 HR00.1 HR01.1 LP130 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
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 PR261 PR262
PR270 PR276 PR278 PR279 PR50.2 PR84.1
UK13.1 UK201 UK202 PR418
UPDATED BY
BN305 BN66.1 ET530 HR11.1 HR11.2 HR511
PA02.1 PA100 PA102 PA115 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 PR140 PR189 PR195 PR197 PR300
PR36.1 PR45.1 PR560 PR80.1 PR82.1 PR85.1
PR86.1 PR89.1 UK560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PYM-COMPANY Numeric 4 BN66.1 PR140
Element: Company Hr PR189 PR195
PR560 PR80.1
PR82.1 PR89.1
UK560
PYM-EMPLOYEE Numeric 9 BN66.1 PR140
Element: Employee Contains the employee number. Each PR189 PR195
person employed by the company is PR560 PR80.1
assigned a unique number. The system PR82.1 PR89.1
uses the employee number to correlate UK560
all of the information related to that
person.
PYM-CHECK-ID Numeric 12 BN66.1 ET530
Element: Check Id Contains the payment identification PR140 PR189
number. The value of this field is PR195 PR560
determined by the Last Check ID field in PR80.1 PR82.1
the HR Company and Process Levels file PR85.1 PR89.1
for the bank account on which this UK560
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 ET530 PR197
Element: Status Contains the payment status. Records PR560 PR85.1
are created with a status of zero and UK560
are updated to a status of "9" by PR199
(Payroll Close).
0 = Created
9 = Closed
PYM-PROCESS-LEVEL Alpha 5 BN305 BN66.1
Element: Process Lev HrContains the employee's home process HR11.1 HR11.2
level at the time of payment. The HR511 PA02.1
employee's home process level, at the PA100 PA102
time the payment is created, is moved to PA115 PA13.1
this field. If you change an employee's PA13.2 PA502
home process level on HR11.1 (Employee) PA513 PA52.1
or by a personnel action, all open PA52.3 PA52.4
payments are updated to reflect the new PA52.5 PR110
home process level. PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR140 PR189
PR195 PR560
PR80.1 PR82.1
PR89.1 UK560
PYM-DEPARTMENT Alpha 5 BN305 BN66.1
Element: Department Contains the employee's home department HR11.1 HR11.2
at the time of payment creation. The HR511 PA02.1
employee's home department, at the time PA100 PA102
of payment creation, is moved to this PA115 PA13.1
field. If you change the home department PA13.2 PA502
on HR11.1 (Employee) or by a personnel PA513 PA52.1
action, all open payments and processed PA52.3 PA52.4
time records are updated to reflect the PA52.5 PR110
new home department. PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR140 PR189
PR195 PR560
PR80.1 PR82.1
PR89.1 UK560
PYM-BANK-CODE Alpha 4 BN66.1 PR140
Element: Bank Code Contains the bank code associated with PR189 PR195
the payment or adjustment. PR560 PR80.1
PR82.1 PR89.1
UK560
PYM-GROSS-PAY Signed 13.2 BN66.1 ET530
Element: Gross Pay Contains the gross payment amount. PR140 PR189
PR195 PR560
PR80.1 PR82.1
PR85.1 PR89.1
UK560
PYM-NET-PAY-AMT Signed 13.2 BN66.1 ET530
Element: Net Pay Amt Contains the net pay for the payment. PR140 PR189
Net Pay is gross pay reduced PR195 PR560
by all S (Employee Paid) deductions PR80.1 PR82.1
and increased by any A (Add-to-Net) PR85.1 PR89.1
deductions. UK560
PYM-DED-CYCLE-NBR Numeric 1 BN66.1 PR140
Element: Ded Cycle Nbr Contains the deduction cycle that was PR189 PR195
used when processing this payment. The PR560 PR80.1
Benefits system uses this field to track PR89.1 UK560
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) BN66.1 ET530
Element: Check Date Contains the payment date. PR140 PR189
PR195 PR560
PR80.1 PR82.1
PR85.1 PR86.1
PR89.1 UK560
PYM-PER-END-DATE Numeric 8 (yyyymmdd) BN66.1 ET530
Element: Per End Date Contains the payroll period ending date. PR140 PR189
PR195 PR560
PR80.1 PR82.1
PR89.1 UK560
PYM-CHECK-TYPE Alpha 1 BN66.1 ET530
Element: Check Type Contains the payment type. When you PR140 PR189
void a payment in PR85.1 (Bank Account PR195 PR560
Reconciliation) the original payment PR80.1 PR82.1
type is changed to R (Reversal). PR85.1 PR86.1
A = ACH PR89.1 UK560
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
PYM-CHECK-NET Signed 13.2 BN66.1 ET530
Element: Check Net Contains the actual amount for which a PR140 PR189
payment is created. ACH amounts are not PR195 PR560
included. PR80.1 PR82.1
PR85.1 PR86.1
PR89.1 UK560
PYM-CHECK-NBR Numeric 8 PR197 PR560
Element: Check Nbr Contains the payment number. When an PR80.1 PR86.1
Employee Payment file record is created UK560
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) ET530 PR197
Element: Date Stamp This field contains the server date PR560 PR85.1
(month, date, and year) of the last UK560
change to this record.
PYM-TIME-STAMP Numeric 6 (hhmmss) ET530 PR197
Element: Time Stamp Contains the server time (hour, minute, PR560 PR85.1
and second) when the record was last UK560
changed.
PYM-COUNTRY-CODE Alpha 2 BN66.1 PR140
Element: Country Code The country code. Required for VAT and PR189 PR195
intrastat reporting. Must be defined in PR560 PR80.1
IN01.1 (Country Maintenance). PR82.1 PR89.1
UK560
PYM-SECCLASS Derived
Element: Secclass
PYM-CURRENCY-CODE Alpha 5 BN66.1 PR140
Element: Currency Code This field contains the company base PR189 PR195
currency code established in Company PR560 PR80.1
(GL10.1 ). PR82.1 PR89.1
UK560
PYM-CURR-ND Numeric 1 BN66.1 PR140
Element: Acct Nd The number of decimals assigned to a PR189 PR195
particular account as determined by the PR560 PR80.1
account currency. PR82.1 PR89.1
UK560
PYM-PENS-SEQ-NBR Numeric 4 BN66.1 PR140
Element: Pens Seq Nbr PR189 PR195
PR560 PR80.1
PR82.1 PR89.1
UK560
PYM-NON-TXBL-REMUN Signed 13.2 BN66.1 ET530
Element: Non Txbl Remun PR140 PR189
PR195 PR560
PR80.1 PR82.1
PR89.1
PYM-OT-PLAN-CODE Alpha 4 BN66.1 PR140
Element: Ot Plan Code Identifies pay plan in effect for PR189 PR195
employee when PRDISTRIB record was PR80.1 PR82.1
created from PR197 (PRPRD). PR89.1 UK560
PYM-PERIOD-NBR Numeric 3 BN66.1 PR140
Element: Period Nbr PR189 PR195
PR80.1 PR82.1
PR89.1 UK560
PYM-PAYROLL-YEAR Numeric 4 BN66.1 PR140
Element: Payroll Year Contains the payroll year in which the PR189 PR195
allocation was taken. PR80.1 PR82.1
PR89.1 UK560
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 BN305 BN66.1
EMPLOYEE ET530 HR11.1
CHECK-ID HR11.2 HR170
HR511 HR70.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR125
PR13.1 PR13.5
PR13.6 PR13.8
PR139 PR140
...
PYMSET10 COMPANY KeyChange
PROCESS-LEVEL
EMPLOYEE
CHECK-ID
PYMSET11 COMPANY KeyChange, Subset
EMPLOYEE Where CHECK-NBR != Zeroes
CHECK-DATE*
CHECK-NBR*
CHECK-ID
PYMSET2 COMPANY KeyChange, Subset BN150 ET530
BANK-CODE Where STATUS = Zeroes ETI2.1 HR00.1
PROCESS-LEVEL HR01.1 LP130
CHECK-TYPE PR01.2 PR128
EMPLOYEE PR130 PR131
CHECK-ID PR132 PR134
PR136 PR141
PR160 PR189
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
...
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 BN66.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HCDL.1 HR170
...
PYMSET5 COMPANY KeyChange, Subset BN305 BN66.1
PROCESS-LEVEL Where STATUS = Zeroes HR11.1 HR11.2
EMPLOYEE HR511 PA02.1
CHECK-TYPE PA100 PA102
CHECK-ID PA115 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
PR132 PR139
PR140 PR141
PR142 PR160
...
PYMSET6 COMPANY KeyChange BN66.1 PR139
DATE-STAMP PR140 PR189
TIME-STAMP PR195 PR197
PROCESS-LEVEL PR80.1 PR89.1
EMPLOYEE
CHECK-TYPE
CHECK-ID
PYMSET7 COMPANY KeyChange HR00.1 HR01.1
COUNTRY-CODE PR418
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 UK560
CHECK-ID
PYMSET9 COMPANY KeyChange, Subset BN66.1 PR139
EMPLOYEE Where COUNTRY-CODE = "UK" PR140 PR189
PAYROLL-YEAR Or COUNTRY-CODE = "GB" PR195 PR80.1
OT-PLAN-CODE PR89.1
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
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
|