PAYMASTR

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
BN100 BN101 BN102 BN103 BN105 BN145
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 ZB10.1 ZB31.1 ZB31.2
ZB32.1 ZB32.2 ZB32.3 HCDL.1 HS17.1 PA495
PA594 MR551 PR192 PR198 PR226 PR247
PR261 PR262 PR266 PR271 PR277 PR278
PR287 PR289 PR55.1 UK201 UK202 UK277
ZP296 ZP551 ZP552 ZP553 ZP555 ZP557
ZP559 ZP574 ZP576 ZP577 PR125 PR155
PR162 PR265 PR01.2


UPDATED BY
BN150 BN232 BN300 BN305 BN330 BN340
BN345 BN66.1 HR00.1 HR01.1 HR11.1 HR11.2
HR170 HR28.1 HR511 HR70.1 LT101 PR521
ZH510 ZH568 EXI2.1 EXI4.1 LP130 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR12.6 PR120 PR128 PR13.1 PR13.5
PR13.6 PR13.8 PR13.9 PR130 PR131 PR132
PR134 PR135 PR136 PR137 PR139 PR140
PR141 PR142 PR160 PR180 PR188 PR189
PR195 PR197 PR260 PR270 PR274 PR275
PR276 PR279 PR282 PR29.1 PR30.2 PR300
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR35.9 PR36.1 PR37.1 PR418 PR45.1 PR50.2
PR51.1 PR529 PR530 PR560 PR582 PR80.1
PR80.2 PR80.4 PR82.1 PR82.2 PR84.1 PR85.1
PR86.1 PR89.1 UK102 UK13.1 UK141 UK145
UK50.1 UK560 ZP530 ZP550 ZP554 TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PYM-COMPANY
Element: Company Hr
Numeric 4
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
UK560
PYM-EMPLOYEE
Element: Employee
Numeric 9
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.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
UK560
PYM-CHECK-ID
Element: Check Id
Numeric 12
Contains 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
PR82.1 PR85.1
PR89.1 UK560
PYM-STATUS
Element: Status
Numeric 1
Contains 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 UK560
PYM-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
Contains 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
HR28.1 HR511
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR140 PR189
PR195 PR30.2
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
UK560 ZH510
PYM-DEPARTMENT
Element: Department
Alpha 5
Contains 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
HR28.1 HR511
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR140 PR189
PR195 PR30.2
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
UK560 ZH510
PYM-BANK-CODE
Element: Bank Code
Alpha 4
Contains the bank code associated with the payment or adjustment.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
UK560
PYM-GROSS-PAY
Element: Gross Pay
Signed 13.2
Contains the gross payment amount.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 UK560
PYM-NET-PAY-AMT
Element: Net Pay Amt
Signed 13.2
Contains 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
PR82.1 PR85.1
PR89.1 UK560
PYM-DED-CYCLE-NBR
Element: Ded Cycle Nbr
Numeric 1
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).
BN66.1 PR140
PR189 PR195
PR560 PR80.1
PR80.4 PR89.1
UK560
PYM-CHECK-DATE
Element: Check Date
Numeric 8 (yyyymmdd)
Contains the payment date.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR86.1 PR89.1
UK560
PYM-PER-END-DATE
Element: Per End Date
Numeric 8 (yyyymmdd)
Contains the payroll period ending date.
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
UK560
PYM-CHECK-TYPE
Element: Check Type
Alpha 1
Contains 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
PR82.1 PR85.1
PR86.1 PR89.1
UK560
PYM-CHECK-NET
Element: Check Net
Signed 13.2
Contains 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
PR82.1 PR85.1
PR86.1 PR89.1
UK560
PYM-CHECK-NBR
Element: Check Nbr
Numeric 8
Contains 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 UK560
PYM-DATE-STAMP
Element: 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 UK560
PYM-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PR197 PR560
PR85.1 UK560
PYM-COUNTRY-CODE
Element: Country Code
Alpha 2
The 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
PR82.1 PR89.1
UK560
PYM-SECCLASS
Element: Secclass
Derived
PYM-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
UK560
PYM-CURR-ND
Element: Acct Nd
Numeric 1
The 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
PR82.1 PR89.1
UK560
PYM-PENS-SEQ-NBR
Element: Pens Seq Nbr
Numeric 4
BN66.1 PR140
PR189 PR195
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
UK560
PYM-NON-TXBL-REMUN
Element: Non Txbl Remun
Signed 13.2
BN66.1 PR140
PR189 PR195
PR560 PR80.1
PR80.4 PR82.1
PR85.1 PR89.1
PYM-OT-PLAN-CODE
Element: Ot Plan Code
Alpha 4
Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD).
BN66.1 PR140
PR189 PR195
PR582 PR80.1
PR80.4 PR82.1
PR89.1 UK560
PYM-PERIOD-NBR
Element: Period Nbr
Numeric 3
For Future Development Use
BN66.1 PR140
PR189 PR195
PR582 PR80.1
PR80.4 PR82.1
PR89.1 UK560
PYM-PAYROLL-YEAR
Element: Payroll Year
Numeric 4
For Future Development Use
BN66.1 PR140
PR189 PR195
PR582 PR80.1
PR80.4 PR82.1
PR89.1 UK560
PYM-GM-ADJ-FLAG
Element: Gm Adj Flag
Numeric 1
Indicates if adjustment records were created by GM170.
0 = Not Created by GM
1 = Created by GM
PYM-PRINT-RCPT
Element: Print Rcpt
Alpha 1
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1


PAYMASTR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PYMSET1 COMPANY
EMPLOYEE
CHECK-ID
...
BN305 BN66.1
HR11.1 HR11.2
HR170 HR28.1
HR511 HR70.1
HS17.1 LT101
ZH510 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR125
PR13.1 PR13.5
PYMSET10 COMPANY
PROCESS-LEVEL
EMPLOYEE
CHECK-ID
KeyChange
PYMSET11 COMPANY
EMPLOYEE
CHECK-DATE*
CHECK-NBR*
CHECK-ID
KeyChange, Subset
WhereCHECK-NBR !=Zeroes
ZP296
PYMSET2 COMPANY
BANK-CODE
PROCESS-LEVEL
CHECK-TYPE
EMPLOYEE
CHECK-ID
KeyChange, Subset
WhereSTATUS =Zeroes
...
BN150 HR00.1
HR01.1 PR521
EXI2.1 EXI4.1
LP130 PR01.2
PR128 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR141 PR160
PR189 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PYMSET4 COMPANY
EMPLOYEE
CHECK-DATE
CHECK-NBR
CHECK-ID
KeyChange
...
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 BN66.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ZB10.1 ZB31.1
PYMSET5 COMPANY
PROCESS-LEVEL
EMPLOYEE
CHECK-TYPE
CHECK-ID
KeyChange, Subset
WhereSTATUS =Zeroes
...
BN305 BN66.1
HR11.1 HR11.2
HR28.1 HR511
LT101 ZH510
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR132
PYMSET6 COMPANY
DATE-STAMP
TIME-STAMP
PROCESS-LEVEL
EMPLOYEE
CHECK-TYPE
CHECK-ID
KeyChange
BN66.1 PR139
PR140 PR189
PR195 PR197
PR80.1 PR80.4
PR89.1 ZP552
ZP553 ZP554
ZP557 ZP559
ZP574 ZP576
ZP577
PYMSET7 COMPANY
COUNTRY-CODE
PROCESS-LEVEL
EMPLOYEE
CHECK-TYPE
CHECK-ID
KeyChange
BN66.1 HR00.1
HR01.1 PR139
PR140 PR189
PR195 PR418
PR80.1 PR80.4
PR89.1
PYMSET8 COMPANY
EMPLOYEE
PENS-SEQ-NBR
CHECK-ID
KeyChange, Subset
WherePENS-SEQ-NBR !=Zeroes
PR29.1 PR529
PR560 PR582
PR82.1 UK560
PYMSET9 COMPANY
EMPLOYEE
PAYROLL-YEAR
OT-PLAN-CODE
PERIOD-NBR
CHECK-ID
KeyChange, Subset
WhereCOUNTRY-CODE ="UK"
OrCOUNTRY-CODE ="GB"
BN66.1 PR139
PR140 PR189
PR195 PR80.1
PR80.4 PR89.1


PAYMASTR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:27:08 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.