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
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PYM-COMPANY Element: Company Hr | Numeric 4 |
|
||||||||||||||
| 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. |
|
||||||||||||||
| 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. |
|
||||||||||||||
| 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 |
|
||||||||||||||
| 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. |
|||||||||||||||
| 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. |
|||||||||||||||
| PYM-BANK-CODE Element: Bank Code | Alpha 4 Contains the bank code associated with the payment or adjustment. |
|
||||||||||||||
| PYM-GROSS-PAY Element: Gross Pay | Signed 13.2 Contains the gross payment amount. |
|
||||||||||||||
| 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. |
|
||||||||||||||
| 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). |
|
||||||||||||||
| PYM-CHECK-DATE Element: Check Date | Numeric 8 (yyyymmdd) Contains the payment date. |
|
||||||||||||||
| PYM-PER-END-DATE Element: Per End Date | Numeric 8 (yyyymmdd) Contains the payroll period ending date. |
|
||||||||||||||
| 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 |
|
||||||||||||||
| PYM-CHECK-NET Element: Check Net | Signed 13.2 Contains the actual amount for which a payment is created. ACH amounts are not included. |
|
||||||||||||||
| 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. |
|
||||||||||||||
| 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. |
|
||||||||||||||
| PYM-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||
| 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). |
|
||||||||||||||
| 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 ). |
|
||||||||||||||
| PYM-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||
| PYM-PENS-SEQ-NBR Element: Pens Seq Nbr | Numeric 4 |
|
||||||||||||||
| PYM-NON-TXBL-REMUN Element: Non Txbl Remun | Signed 13.2 |
|
||||||||||||||
| 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). |
|
||||||||||||||
| PYM-PERIOD-NBR Element: Period Nbr | Numeric 3 For Future Development Use |
|
||||||||||||||
| PYM-PAYROLL-YEAR Element: Payroll Year | Numeric 4 For Future Development Use |
|
||||||||||||||
| 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 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PYMSET1 |
COMPANY EMPLOYEE CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||||||||
| PYMSET10 |
COMPANY PROCESS-LEVEL EMPLOYEE CHECK-ID |
|
|||||||||||||||||||||||||||||||||||||||||||
| PYMSET11 |
COMPANY EMPLOYEE CHECK-DATE* CHECK-NBR* CHECK-ID |
|
|||||||||||||||||||||||||||||||||||||||||||
| PYMSET2 |
COMPANY BANK-CODE PROCESS-LEVEL CHECK-TYPE EMPLOYEE CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||||||||
| PYMSET4 |
COMPANY EMPLOYEE CHECK-DATE CHECK-NBR CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||||||||
| PYMSET5 |
COMPANY PROCESS-LEVEL EMPLOYEE CHECK-TYPE CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||||||||
| PYMSET6 |
COMPANY DATE-STAMP TIME-STAMP PROCESS-LEVEL EMPLOYEE CHECK-TYPE CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||||||||
| PYMSET7 |
COMPANY COUNTRY-CODE PROCESS-LEVEL EMPLOYEE CHECK-TYPE CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||||||||
| PYMSET8 |
COMPANY EMPLOYEE PENS-SEQ-NBR CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||||||||
| PYMSET9 |
COMPANY EMPLOYEE PAYROLL-YEAR OT-PLAN-CODE PERIOD-NBR CHECK-ID |
|
| ||||||||||||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bank Account | BANKACCT |
Required
| |||||||||||||||
| Bank Code | BANKFILE |
Required
| |||||||||||||||
| Company | PRSYSTEM |
Required
| |||||||||||||||
| Cucodes | CUCODES |
Not Required
| |||||||||||||||
| Department | DEPTCODE |
Required
| |||||||||||||||
| Employee | EMPLOYEE |
Required
| |||||||||||||||
| Pr1099rhst | PR1099RHST |
Not Required
| |||||||||||||||
| Prcheck | PRCHECK |
Not Required
| |||||||||||||||
| Process Level | PRSYSTEM |
Required
| |||||||||||||||
| Prpenpay | PRPENPAY |
Not Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ach Distribs | EMPACHDIST |
Delete Cascades
| ||||||||||||||||||||||||||||||
| Adjustments | PRTRDADJ |
| ||||||||||||||||||||||||||||||
| Deductions | PAYDEDUCTN |
| ||||||||||||||||||||||||||||||
| Prdistrib | PRDISTRIB |
Delete Cascades
| ||||||||||||||||||||||||||||||
| Time Records | TIMERECORD |
| ||||||||||||||||||||||||||||||
| Wage | PRTIME |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.