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
HR170 HR70.1 HS17.1 PR125 PR139 PR142
PR155 PR162 PR170 PR192 PR198 PR226
PR247 PR265 PR266 PR271 PR274 PR275
PR277 PR282 PR287 PR289 PR29.1 PR55.1
PR50.2 ZP296 BN150 HR00.1 HR01.1 PR521
EXI2.1 EXI4.1 LP130 PR01.2 PR128 PR131
PR132 PR134 PR135 PR136 PR137 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
PR37.1 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 BS10.1 BS12.1 BS13.1
BS14.1 BS15.1 BS32.1 ZB10.1 ZB31.1 ZB31.2
ZB32.1 ZB32.2 ZB32.3 HCDL.1 ZH568 PA594
PR188 PR260 PR270 PR276 PR278 PR279
PR51.1 PR84.1 ZP551 ZP554 ZP555 ZP552
ZP557 ZP559 PR418


UPDATED BY
BN305 BN66.1 HR11.1 HR11.2 HR11.4 HR28.1
HR511 LT101 LT111 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 PR140 PR189 PR195 PR197 PR30.2
PR300 PR36.1 PR36.4 PR45.1 PR512 PR560
PR582 PR80.1 PR80.4 PR80.2 PR82.1 PR85.1
PR86.1 PR89.1 PRAT.1 PR141 PR160 PR180
PR292 PA495 PR261 PR262

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
PRAT.1
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
PRAT.1
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 PRAT.1
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
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
HR11.4 HR28.1
HR511 LT101
LT111 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
PR512 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
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
HR11.4 HR28.1
HR511 LT101
LT111 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
PR512 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
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
PRAT.1
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 PRAT.1
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 PRAT.1
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
PRAT.1
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
PRAT.1
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
PRAT.1
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
PRAT.1
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
PRAT.1
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
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
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
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
PRAT.1
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
PRAT.1
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
PRAT.1
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
PRAT.1
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
PRAT.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
PR80.1 PR80.4
PR89.1 PRAT.1
PYM-PERIOD-NBR
Element: Period Nbr		Numeric 3
For Future Development Use
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 PRAT.1
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 PRAT.1
PYM-INTERFACE-FLAG
Element: Status		Numeric 1
PR197


PAYMASTR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PYMSET1 COMPANY
EMPLOYEE
CHECK-ID
...
BN305 BN66.1
HR11.1 HR11.2
HR11.4 HR170
HR28.1 HR511
HR70.1 HS17.1
LT101 LT111
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
PYMSET10 COMPANY
PROCESS-LEVEL
EMPLOYEE
CHECK-ID
KeyChange
PYMSET11 COMPANY
EMPLOYEE
CHECK-DATE*
CHECK-NBR*
CHECK-ID
KeyChange, Subset
WhereCHECK-NBR !=Zeroes
PR50.2 ZP296
PYMSET12 COMPANY
PAYROLL-YEAR
OT-PLAN-CODE
PER-END-DATE
EMPLOYEE
CHECK-ID
PR141
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 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 PR35.5
PYMSET3 COMPANY
INTERFACE-FLAG
PROCESS-LEVEL
EMPLOYEE
CHECK-ID
KeyChange, Subset
WhereSTATUS =9
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
BS10.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
PYMSET5 COMPANY
PROCESS-LEVEL
EMPLOYEE
CHECK-TYPE
CHECK-ID
KeyChange, Subset
WhereSTATUS =Zeroes
...
BN305 BN66.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 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
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 PRAT.1
ZP552 ZP554
ZP557 ZP559
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 PRAT.1
PYMSET8 COMPANY
EMPLOYEE
PENS-SEQ-NBR
CHECK-ID
KeyChange, Subset
WherePENS-SEQ-NBR !=Zeroes
PR29.1 PR529
PR560 PR582
PR82.1
PYMSET9 COMPANY
EMPLOYEE
PAYROLL-YEAR
OT-PLAN-CODE
PERIOD-NBR
CHECK-ID
KeyChange, Subset
WhereCOUNTRY-CODE ="UK"
OrCOUNTRY-CODE ="GB"
OrCOUNTRY-CODE ="IN"


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 (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
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 02:30:29 2016

Home
Contact Us



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