|
|
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 PR141 PR142 PR155
PR160 PR162 PR180 PR198 PR226 PR247
PR265 PR275 PR277 PR289 PR29.1 PR51.3
PR51.1 PR55.1 UK141 UK145 UK277 UK50.3
UK50.1 TP135 BN150 HR00.1 HR01.1 PBIP.1
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 BN305 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
PR270 PR276 PR278 PR418 PR50.2 PR84.1
UK201 UK202 TP140
UPDATED BY
HR11.1 HR11.2 HR511 PA02.1 PA100 PA102
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 PR197 PR300 PR36.1
PR45.1 PR560 PR82.1 PR85.1 PR86.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PYM-COMPANY Numeric 4 PR560 PR82.1
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PYM-EMPLOYEE Numeric 9 PR560 PR82.1
Element: Employee 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.
PYM-CHECK-ID Numeric 12 PR560 PR82.1
Internal Check ID Contains the payment identification PR85.1
Number 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.
PYM-STATUS Numeric 1 PR197 PR560
Element: Status Contains the payment status. Records 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 HR11.1 HR11.2
Element: Process Lev HrContains 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 PR110 PR113
payments are updated to reflect the new PR120 PR13.1
home process level. PR13.5 PR13.6
PR13.8 PR560
PR82.1
PYM-DEPARTMENT Alpha 5 HR11.1 HR11.2
Element: Department Contains the employee's home department HR511 PA02.1
at the time of payment creation. The PA100 PA102
employee's home department, at the time PA502 PA52.1
of payment creation, is moved to this PA52.3 PA52.4
field. If you change the home department PA52.5 PR110
on HR11.1 (Employee) or by a personnel PR113 PR120
action, all open payments and processed PR13.1 PR13.5
time records are updated to reflect the PR13.6 PR13.8
new home department. PR560 PR82.1
PYM-BANK-CODE Alpha 4 PR560 PR82.1
Element: Bank Code Contains the bank code associated with
the payment or adjustment.
PYM-GROSS-PAY Signed 13.2 PR560 PR82.1
Element: Gross Pay Contains the gross payment amount. PR85.1
PYM-NET-PAY-AMT Signed 13.2 PR560 PR82.1
Element: Net Pay Amt Contains the net pay for the payment. PR85.1
Net Pay is gross pay reduced
by all S (Employee Paid) deductions
and increased by any A (Add-to-Net)
deductions.
PYM-DED-CYCLE-NBR Numeric 1 PR560
Element: Ded Cycle Nbr 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).
PYM-CHECK-DATE Numeric 8 (yyyymmdd) PR560 PR82.1
Element: Payment Date Contains the payment date. PR85.1 PR86.1
PYM-PER-END-DATE Numeric 8 (yyyymmdd) PR560 PR82.1
Element: Period End DatContains the payroll period ending date. PR85.1
PYM-CHECK-TYPE Alpha 1 PR560 PR82.1
Element: Payment Type Contains the payment type. When you PR85.1 PR86.1
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
PYM-CHECK-NET Signed 13.2 PR560 PR82.1
Element: Net Payment AmContains the actual amount for which a PR85.1 PR86.1
payment is created. ACH amounts are not
included.
PYM-CHECK-NBR Numeric 8 PR197 PR560
Element: Payment NumberContains the payment number. When an PR86.1
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.
PYM-DATE-STAMP Numeric 8 (yyyymmdd) PR197 PR560
Element: Date Stamp This field contains the server date PR85.1
(month, date, and year) of the last
change to this record.
PYM-TIME-STAMP Numeric 6 (hhmmss) PR197 PR560
Element: Time Stamp Contains the server time (hour, minute, PR85.1
and second) when the record was last
changed.
PYM-COUNTRY-CODE Alpha 2 PR560 PR82.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PYM-SECCLASS Derived
Element: Secclass
PYM-CURRENCY-CODE Alpha 5 PR560 PR82.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PYM-CURR-ND Numeric 1 PR560 PR82.1
Account Currency Represents the number of decimals
Code defined for the currency of the object.
PYM-PENS-SEQ-NBR Numeric 4 PR560 PR82.1
Element: Pens Seq Nbr
PYM-NON-TXBL-REMUN Signed 13.2 PR560 PR82.1
Element: Non Txbl Remun
PYM-OT-PLAN-CODE Alpha 4
Element: Ot Plan Code Identifies pay plan in effect for
employee when PRDISTRIB record was
created from PR197 (PRPRD).
PYM-PERIOD-NBR Numeric 3
Element: Period Nbr
PYM-PAYROLL-YEAR Numeric 4
Element: Current PayrolContains the payroll year in which the
allocation was taken.
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 HR11.1 HR11.2
EMPLOYEE HR170 HR511
CHECK-ID HR70.1 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR125 PR13.1
PR13.5 PR13.6
PR13.8 PR141
PR142 PR155
PR160 PR162
PR180 PR197
PR198 PR226
...
PYMSET10 COMPANY KeyChange
PROCESS-LEVEL
EMPLOYEE
CHECK-ID
PYMSET2 COMPANY KeyChange, Subset BN150 HR00.1
BANK-CODE Where STATUS = Zeroes HR01.1 PBIP.1
PROCESS-LEVEL PR01.2 PR128
CHECK-TYPE PR130 PR131
EMPLOYEE PR132 PR134
CHECK-ID PR136 PR141
PR160 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 PR45.1
PR529 PR530
...
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 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HCDL.1
HR170 HR70.1
...
PYMSET5 COMPANY KeyChange, Subset HR11.1 HR11.2
PROCESS-LEVEL Where STATUS = Zeroes HR511 PA02.1
EMPLOYEE PA100 PA102
CHECK-TYPE PA13.1 PA13.2
CHECK-ID PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR132
PR141 PR142
PR160 PR180
PR197 PR36.1
PR82.1 PR82.2
...
PYMSET6 COMPANY KeyChange PR197
DATE-STAMP
TIME-STAMP
PROCESS-LEVEL
EMPLOYEE
CHECK-TYPE
CHECK-ID
PYMSET7 COMPANY KeyChange HR00.1 HR01.1
COUNTRY-CODE PBIP.1 PR197
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
CHECK-ID
PYMSET9 COMPANY KeyChange, Subset
EMPLOYEE Where COUNTRY-CODE = "UK"
PAYROLL-YEAR Or COUNTRY-CODE = "GB"
OT-PLAN-CODE
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 (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 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
|
