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 PR141 PR142 PR150 PR155
PR160 PR162 PR180 PR226 PR265 PR275
PR277 PR289 PR55.1 HR00.1 HR01.1 PBIP.1
PR01.2 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 HCOP.1
PR139 PR195 PR260 PR270 PR276 PR278
PR294 PR50.2 PR51.1 PR89.1 PR132
UPDATED BY
BN500 HR11.1 HR511 PA02.1 PA100 PA102
PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PR13.1 PR140 PR199 PR300
PR36.1 PR45.1 PR560 PR80.1 PR82.1 PR85.1
PR86.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PYM-COMPANY Numeric 4 BN500 PR140
Company The company number represents an PR560 PR80.1
established company and is entered on PR82.1
all function codes.
PYM-EMPLOYEE Numeric 9 BN500 PR140
Employee Contains the employee number. Each PR560 PR80.1
person employed by the company is PR82.1
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 BN500 PR140
Internal Check ID Contains the payment identification PR560 PR80.1
Number number. The value of this field is PR82.1 PR85.1
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 BN500 PR199
Status Contains the payment status. Records PR560 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 BN500 HR11.1
Process Level Contains 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 PR13.1 PR140
payments are updated to reflect the new PR560 PR80.1
home process level. PR82.1
PYM-DEPARTMENT Alpha 5 BN500 PR140
Department Contains the employee's home department PR560 PR80.1
at the time of payment creation. The PR82.1
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.
PYM-BANK-CODE Alpha 4 BN500 PR140
Bank Code Contains the bank code associated with PR560 PR80.1
the payment or adjustment. PR82.1
PYM-GROSS-PAY Signed 11.2 BN500 PR140
Gross Pay Contains the gross payment amount. PR560 PR80.1
PR82.1 PR85.1
PYM-NET-PAY-AMT Signed 11.2 PR140 PR560
Net Pay Amt Contains the net pay for the payment. PR80.1 PR82.1
Net Pay is gross pay reduced PR85.1
by all S (Employee Paid) deductions
and increased by any A (Add-to-Net)
deductions.
PYM-DED-CYCLE-NBR Numeric 1 BN500 PR560
Ded Cycle Nbr Contains the deduction cycle that was PR80.1
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) BN500 PR140
Payment Date Contains the payment date. PR560 PR80.1
PR82.1 PR85.1
PR86.1
PYM-PER-END-DATE Numeric 8 (yyyymmdd) BN500 PR140
Period End Date Contains the payroll period ending date. PR560 PR80.1
PR82.1 PR85.1
PYM-CHECK-TYPE Alpha 1 BN500 PR140
Payment Type Contains the payment type. When you PR560 PR80.1
void a payment in PR85.1 (Bank Account PR82.1 PR85.1
Reconciliation) the original payment PR86.1
type is changed to R (Reversal).
A = ACH
J = Adjustment
M = Manual
P = Partial ACH
R = Reversal
S = System
V = Partial Void
PYM-CHECK-NET Signed 11.2 PR140 PR560
Net Payment Amount Contains the actual amount for which a PR80.1 PR82.1
payment is created. ACH amounts are not PR85.1 PR86.1
included.
PYM-CHECK-NBR Numeric 8 BN500 PR199
Payment Number Contains the payment number. When an PR560 PR80.1
Employee Payment file record is created PR86.1
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) PR199 PR560
Date Stamp Contains the server date (month, date,
and year) of the last change to this
record.
PYM-TIME-STAMP Numeric 6 (hhmmss) PR199 PR560
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PYM-SECCLASS Derived
Secclass
PAYMASTR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PYMSET1 COMPANY HR11.1 HR170
EMPLOYEE HR511 HR70.1
CHECK-ID PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1 PR140
PR141 PR142
PR150 PR155
PR160 PR162
PR180 PR199
PR226 PR265
PR275 PR277
PR289 PR300
PR45.1 PR55.1
...
PYMSET2 COMPANY KeyChange, Subset HR00.1 HR01.1
BANK-CODE Where STATUS = Zeroes PBIP.1 PR01.2
PROCESS-LEVEL PR141 PR160
CHECK-TYPE PR199
EMPLOYEE
CHECK-ID
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
HCOP.1 HR170
...
PYMSET5 COMPANY KeyChange, Subset BN500 BN66.1
PROCESS-LEVEL Where STATUS = Zeroes HR11.1 HR511
EMPLOYEE PA02.1 PA100
CHECK-TYPE PA102 PA13.1
CHECK-ID PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PR132 PR139
PR140 PR141
PR142 PR150
PR160 PR180
PR195 PR199
PR36.1 PR80.1
PR80.2 PR82.1
...
PYMSET6 COMPANY KeyChange PR199
DATE-STAMP
TIME-STAMP
PROCESS-LEVEL
EMPLOYEE
CHECK-TYPE
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
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
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
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
Deductions PAYDEDUCTN Delete Cascades
PYM-COMPANY -> PYD-COMPANY
PYM-EMPLOYEE -> PYD-EMPLOYEE
PYM-CHECK-ID -> PYD-CHECK-ID
PYD-DED-CODE
PYD-EDM-SEQ-NBR
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
|