Employee Payment Distribution

This file tracks the general ledger account information in more detail than the GL Transaction File because it creates the account distributions for each employee payment, whereas the GL Transaction File creates records by account for all payments in a cycle. Creation of records in this file is optional based on the selection you make in HR00.1 (Company). The system creates two kinds of payroll distribution records, company distributions and employee distributions. Company distributions include one company clearing account record for each general ledger date (even if the amount is zero), and an error suspense account record. The system creates employee distributions for employee deductions, company deductions, and pay. PR199 (Payroll Close) is the primary program that updates this file.

REFERENCED BY

PA495	PR131	PR195	HR170	HR70.1	PR285
PR55.1	HR00.1	HR01.1

UPDATED BY

PR197	PR198	PR300	PR582	PR70.1	PR82.1
PR82.2	PR85.1	PR295	PA82.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
PRD-COMPANY Element: Company Hr	Numeric 4	PR197 PR582 PR70.1 PR82.1 PR82.2 PR85.1
PRD-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.	PR197 PR582 PR70.1 PR82.1 PR82.2 PR85.1
PRD-CHECK-ID Element: Check Id	Numeric 12 Contains the payment identification number. When the system creates a distribution, the Employee Payment Master payment identification number moves to this field to serve as the link between the Employee Payment Master file record and the Employee Payment Distribution file record.	PR197 PR582 PR70.1 PR82.1 PR82.2 PR85.1
PRD-OBJ-ID Element: Obj Id	Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	PR197 PR582 PR70.1 PR82.1 PR82.2 PR85.1
PRD-STATUS Element: Status	Numeric 1 Contains the distribution status. The system creates adjustments and reversals with a status of zero. When you run PR199 (Payroll Close), the status changes to nine. Records created by PR199 are created with a status of nine. 0 = Open 1 = Updated 9 = Closed	PR197 PR198 PR85.1
PRD-PROCESS-LEVEL Element: Process Lev Hr	Alpha 5 Contains the process level to which the amount is posted.	PR197 PR582 PR82.1 PR82.2 PR85.1
PRD-DEPARTMENT Element: Department	Alpha 5 Contains the department to which the amount is posted.	PR197 PR582 PR82.1 PR82.2 PR85.1
PRD-RECORD-TYPE Element: Record Type	Alpha 1 This field identifies the type of record defined. Valid values are: S = Summary D = Detail 1 = Error suspense A = Deduction Accrual C = Cash Accrual E = Expense Accrual	PR197 PR582 PR82.1 PR82.2 PR85.1
PRD-CHECK-TYPE Element: Check Type	Alpha 1 Contains the payment type. A = ACH P = Partial ACH S = System J = Adjustment R = Void Reversal M = Manual C = Contract	PR197 PR582 PR70.1 PR82.1 PR82.2 PR85.1
PRD-DST-ACCT-UNIT Element: Acct Unit	Alpha 15 Contains the general ledger accounting unit to which the amount is posted.	PR197 PR582 PR70.1 PR82.1 PR82.2 PR85.1
PRD-DST-ACCOUNT Element: Account	Numeric 6 Contains the general ledger account to which the amount is posted.	PR197 PR582 PR70.1 PR82.1 PR82.2 PR85.1
PRD-DST-SUB-ACCT Element: Sub Acct	Numeric 4 Contains the general ledger subaccount to which the amount is posted.	PR197 PR582 PR70.1 PR82.1 PR82.2 PR85.1
PRD-DIST-COMPANY Element: Company	Numeric 4 Contains the company number to which a transaction is posted. A valid intercompany relationship must be defined in the General Ledger system.	PR197 PR582 PR70.1 PR82.1 PR82.2 PR85.1
PRD-PCD-SEQ-NBR Element: Pcd Seq Nbr	Numeric 8 Contains the sequence number for the distribution relative to the pay code.	PR197 PR582 PR82.1 PR82.2 PR85.1
PRD-DED-CODE Element: Ded Code	Alpha 4 Contains the deduction associated with the distribution. The system uses this field to identify employee deduction distributions and company-paid deduction distributions.	PR197 PR582 PR82.1 PR82.2 PR85.1
PRD-HOURS Element: Hours	Signed 7.2 Contains the hours associated with the distribution.	PR197 PR582 PR82.1 PR82.2 PR85.1
PRD-DIST-AMT Element: Dist Amt	Signed 13.2 Contains the amount to be posted.	PR197 PR582 PR82.1 PR82.2 PR85.1
PRD-GL-DATE Element: Gl Date	Numeric 8 (yyyymmdd) Contains the general ledger posting date.	PR197 PR582 PR82.1 PR82.2 PR85.1
PRD-JOB-CODE Element: Job Code	Alpha 9 Contains the user-defined job code.	PR197 PR582 PR82.1 PR82.2 PR85.1
PRD-RUN-DATE Element: Run Date	Numeric 8 (yyyymmdd) Contains the date the transaction is posted to the general ledger.	PR197 PR198
PRD-RUN-TIME Element: Sys Time	Numeric 6 (hhmmss) Contains the time the transaction is posted to the general ledger.	PR197 PR198
PRD-ACTIVITY Element: Activity	Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	PR197 PR582 PR82.1 PR82.2 PR85.1
PRD-GLT-OBJ-ID Element: Obj Id	Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	PR197 PR198 PR82.1 PR85.1
PRD-ATN-OBJ-ID Element: Obj Id	Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	PR197 PR198 PR582 PR82.1
PRD-POSITION Element: Position	Alpha 12 Contains the user-defined code that represents a position in the company.	PR197 PR582 PR82.1 PR82.2 PR85.1
PRD-ACCT-CATEGORY Element: Acct Category	Alpha 5 Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	PR197 PR582 PR82.1 PR82.2 PR85.1
PRD-FULL-ACCT-1 Element: Full Acct 1	Derived
PRD-FULL-ACCT-2 Element: Full Acct 2	Derived
PRD-FULL-ACCT Element: Full Acct	Derived
PRD-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).	PR197 PR582 PR82.1 PR85.1
PRD-CURR-ND Element: Acct Nd	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.	PR197 PR582 PR82.1 PR85.1
PRD-ERROR-TYPE Element: Error Type	Numeric 1 1 = Currency Error Exists 0 = No Error Exists	PR197 PR70.1 PR85.1
PRD-CO-CURR-CD Element: Co Curr Cd	Alpha 5	PR197 PR582 PR70.1 PR82.1 PR85.1
PRD-DST-CO-CURR-CD Element: Dst Co Curr Cd	Alpha 5	PR197 PR582 PR70.1 PR82.1 PR85.1
PRD-CO-EXCH-RATE Element: Co Exch Rate	Signed 14.7	PR197 PR582 PR70.1 PR82.1 PR85.1
PRD-DIST-EXCH-RATE Element: Dist Exch Rate	Signed 14.7	PR197 PR582 PR70.1 PR82.1 PR85.1
PRD-MSG-NBR Element: Msg Nbr	Numeric 3 Occurs 10 Times	PR197 PR582 PR70.1 PR82.1 PR85.1
PRD-HM-PROC-LEVEL Element: Process Lev Hr	Alpha 5	PR197 PR582 PR70.1 PR82.1 PR82.2 PR85.1
PRD-ATTEND-CODE Element: Attend Code	Alpha 2 A user-defined alphanumeric code that represents a reason for an employee's absence or hours worked. Examples of attendance codes are, sick, vacation, overtime, on the job injury, snow day, tardy, left early, and so on. Validated in the Attendance Code file.	PR197
PRD-AC-UPDATED Element: Ac191 Updated	Alpha 1	PR197 PR582 PR82.1 PR85.1
PRD-GARN-OBJ-ID Element: Garn Obj Id	Numeric 12	PR197 PR582 PR82.1 PR85.1
PRD-SEGMENT-SEQ Element: Segment Seq	Numeric 12	PR197 PR582 PR82.1 PR85.1
PRD-TR-DATE Element: Tr Date	Numeric 8 (yyyymmdd)	PR197 PR582 PR82.1 PR85.1
PRD-PER-END-DATE Element: Per End Date	Numeric 8 (yyyymmdd) Identifies period end date in distribution record; used during PR198 to relieve salary encumbrance commitments for pay period (updated from TIMERECORD.PER-END-DATE).	PR197 PR82.1
PRD-PAY-UNITS Element: Pay Units	Signed 7.2	PR197 PR82.1 PR82.2
PRD-UNIT-MEASURE Element: Unit Measure	Alpha 12	PR197 PR82.1 PR82.2
PRD-OT-PLAN-CODE Element: Ot Plan Code	Alpha 4 Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD).	PR197
PRD-GM-ADJ-TYPE Element: Gm Adj Type	Alpha 1 Identifies labor cost transfer adjustment type for PRDISTRIB adjustment records created by GM170. R = Reversing Entry A = Adjusting Entry
PRD-GMI-OBJ-ID-1 Element: Obj Id	Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
PRD-GMI-OBJ-ID-2 Element: Obj Id	Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
PRD-GML-OBJ-ID Element: Obj Id	Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	PR197
PRD-EXP-RPT-NBR Element: Invoice	Alpha 22	PR197
PRD-REC-TYPE Element: Seq Nbr	Numeric 4	PR197

PRDISTRIB FILE INDEX

PRDISTRIB FILE RELATIONS

ONE TO ONE RELATIONS

PRDISTRIB FILE RELATIONS

ONE TO MANY RELATIONS

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