PRDISTRIB FILE
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
PR131 HR170 HR70.1 PR295 PR55.1
UPDATED BY
PR195 PR197 PR198 PR300 PR70.1 PR82.1
PR82.2 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRD-COMPANY Numeric 4 PR197 PR70.1
Company The company number represents an PR82.1 PR82.2
established company and is entered on PR85.1
all function codes.
PRD-EMPLOYEE Numeric 9 PR197 PR70.1
Employee Contains the employee number. Each PR82.1 PR82.2
person employed by the company is PR85.1
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PRD-CHECK-ID Numeric 12 PR197 PR70.1
Internal Check ID Contains the payment identification PR82.1 PR82.2
Number number. When the system creates a PR85.1
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.
PRD-OBJ-ID Numeric 12 PR197 PR70.1
Object This is the object identifier. It is PR82.1 PR82.2
Identification used to relate commitments or posted PR85.1
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-STATUS Numeric 1 PR198 PR82.1
Status Contains the distribution status. The PR85.1
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
9 = Closed
PRD-PROCESS-LEVEL Alpha 5 PR197 PR82.1
Process Level Contains the process level to which the PR82.2 PR85.1
amount is posted.
PRD-DEPARTMENT Alpha 5 PR197 PR82.1
Department Contains the department to which the PR82.2 PR85.1
amount is posted.
PRD-RECORD-TYPE Alpha 1 PR197 PR82.1
Record Type This field identifies the type of PR82.2 PR85.1
record defined.
Valid values are:
S = Summary
D = Detail
1 = Error suspense
A = Deduction Accrual
C = Cash Accrual
E = Expense Accrual
PRD-CHECK-TYPE Alpha 1 PR197 PR70.1
Payment Type Contains the payment type. PR82.1 PR82.2
A = ACH PR85.1
P = Partial ACH
S = System
J = Adjustment
R = Void Reversal
M = Manual
PRD-DST-ACCT-UNIT Alpha 15 PR197 PR70.1
Distribution Contains the general ledger accounting PR82.1 PR82.2
Accounting Unit unit to which the amount is posted. PR85.1
PRD-DST-ACCOUNT Numeric 6 PR197 PR70.1
Distribution Contains the general ledger account to PR82.1 PR82.2
Account Number which the amount is posted. PR85.1
PRD-DST-SUB-ACCT Numeric 4 PR197 PR70.1
Distribution Contains the general ledger subaccount PR82.1 PR82.2
Subaccount Number to which the amount is posted. PR85.1
PRD-DIST-COMPANY Numeric 4 PR197 PR70.1
Distribution Company Contains the company number to which a PR82.1 PR82.2
transaction is posted. A valid PR85.1
intercompany relationship must be
defined in the General Ledger system.
PRD-PCD-SEQ-NBR Numeric 4 PR197 PR82.1
Pcd Seq Nbr Contains the sequence number for the PR82.2 PR85.1
distribution relative to the pay code.
PRD-DED-CODE Alpha 4 PR197 PR82.1
Deduction Code Contains the deduction associated with PR82.2 PR85.1
the distribution. The system uses this
field to identify employee deduction
distributions and company-paid deduction
distributions.
PRD-HOURS Signed 7.2 PR197 PR82.1
Hours Contains the hours associated with the PR82.2 PR85.1
distribution.
PRD-DIST-AMT Signed 13.2 PR197 PR82.1
Distribution Amount Contains the amount to be posted. PR82.2 PR85.1
PRD-GL-DATE Numeric 8 (yyyymmdd) PR197 PR82.1
General Ledger Date Contains the general ledger posting PR82.2 PR85.1
date.
PRD-JOB-CODE Alpha 9 PR197 PR82.1
Job Code Contains the user-defined job code. PR82.2 PR85.1
PRD-RUN-DATE Numeric 8 (yyyymmdd) PR197 PR198
Program Run Date Contains the date the transaction is
posted to the general ledger.
PRD-RUN-TIME Numeric 6 (hhmmss) PR197 PR198
Program Run Time Contains the time the transaction is
posted to the general ledger.
PRD-ACTIVITY Alpha 15 PR197 PR82.1
Activity Activities are the processes or PR82.2 PR85.1
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PRD-GLT-OBJ-ID Numeric 12 PR198
Subsystem GL This is a subsystem GL interface
Interface ID identification number. It is used for
Drill Around purposes.
PRD-ATN-OBJ-ID Numeric 12 PR197 PR198
Atn Object ID The system-defined object id
representing the Activity Management
commitment.
PRD-POSITION Alpha 12 PR197 PR82.1
Position Contains the user-defined code that PR82.2 PR85.1
represents a position in the company.
PRD-ACCT-CATEGORY Alpha 5 PR197 PR82.1
Account Category Account categories are groupings of PR82.2 PR85.1
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.
PRD-FULL-ACCT-1 Derived
Full Acct 1
PRD-FULL-ACCT-2 Derived
Full Acct 2
PRD-FULL-ACCT Derived
Full Acct
PRD-CURRENCY-CODE Alpha 5 PR197 PR82.1
Currency Code This field contains the company base PR85.1
currency code established in Company
(GL10.1 ).
PRD-CURR-ND Numeric 1 PR197 PR82.1
Currency Number of Represents the number of decimals PR85.1
Decimals defined for the currency of the object.
PRD-ERROR-TYPE Numeric 1 PR197 PR82.1
Error Type 1 = Currency Error Exists PR85.1
0 = No Error Exists
PRD-CO-CURR-CD Alpha 5 PR197 PR70.1
Co Curr Cd PR82.1 PR85.1
PRD-DST-CO-CURR-CD Alpha 5 PR197 PR70.1
Dst Co Curr Cd PR82.1 PR85.1
PRD-CO-EXCH-RATE Signed 12.6 PR197 PR70.1
Co Exch Rate PR82.1 PR85.1
PRD-DIST-EXCH-RATE Signed 12.6 PR197 PR70.1
Dist Exch Rate PR82.1 PR85.1
PRD-MSG-NBR Numeric 3 Occurs 10 Times PR197 PR70.1
Msg Nbr PR82.1 PR85.1
PRD-HM-PROC-LEVEL Alpha 5 PR197 PR70.1
Hm Proc Level PR82.1 PR85.1
PRD-ATTEND-CODE Alpha 2 PR197
Attendance Code 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.
PRD-AC-UPDATED Alpha 1 PR197 PR82.1
Ac Updated Indicates the completion of AC530 for PR85.1
Activity Management commitments.
PRD-GARN-OBJ-ID Numeric 12 PR197 PR82.1
Garn Obj Id PR85.1
PRD-SEGMENT-SEQ Numeric 12 PR197 PR82.1
Segment Seq PR85.1
PRD-TR-DATE Numeric 8 (yyyymmdd) PR197 PR82.1
Time Record Date PR85.1
PRDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRDSET1 COMPANY PR131 PR195
EMPLOYEE PR197 PR198
CHECK-ID PR300 PR70.1
OBJ-ID PR82.1 PR82.2
PR85.1
PRDSET2 COMPANY KeyChange HR170 HR70.1
EMPLOYEE PR295 PR300
GL-DATE
CHECK-ID
OBJ-ID
PRDSET3 DIST-COMPANY KeyChange
DST-ACCT-UNIT
DST-ACCOUNT
DST-SUB-ACCT
GLT-OBJ-ID
OBJ-ID
PRDSET4 COMPANY KeyChange PR198 PR70.1
STATUS
ERROR-TYPE
HM-PROC-LEVEL
DIST-COMPANY
DST-ACCT-UNIT
DST-ACCOUNT
DST-SUB-ACCT
GL-DATE
EMPLOYEE
CHECK-ID
OBJ-ID
PRDSET5 COMPANY KeyChange, Subset PR55.1
ACTIVITY Where ACTIVITY != Spaces
ATN-OBJ-ID
EMPLOYEE
OBJ-ID
PRDSET6 COMPANY KeyChange, Subset PR198
PROCESS-LEVEL Where STATUS = 9
EMPLOYEE
GL-DATE
CHECK-ID
OBJ-ID
PRDISTRIB FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Category ACACCTCAT Required
When PRD-ACCT-CATEGORY != Spaces
PRD-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Activity ACACTIVITY Required
When PRD-ACTIVITY != Spaces
PRD-ACTIVITY -> ACV-ACTIVITY
Company PRSYSTEM Required
PRD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Ded Code DEDCODE Required
When PRD-DED-CODE != Spaces
PRD-COMPANY -> DDC-COMPANY
PRD-DED-CODE -> DDC-DED-CODE
Department DEPTCODE Required
When PRD-DEPARTMENT != Spaces
PRD-COMPANY -> DPT-COMPANY
PRD-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
PRD-DEPARTMENT -> DPT-DEPARTMENT
Dist Company GLSYSTEM Required
When PRD-DIST-COMPANY != Zeroes
PRD-DIST-COMPANY -> GLS-COMPANY
Dst Account GLMASTER Required
PRD-DIST-COMPANY -> GLM-COMPANY
PRD-DST-ACCT-UNIT -> GLM-ACCT-UNIT
PRD-DST-ACCOUNT -> GLM-ACCOUNT
PRD-DST-SUB-ACCT -> GLM-SUB-ACCOUNT
Employee EMPLOYEE Required
When PRD-EMPLOYEE != Zeroes
PRD-COMPANY -> EMP-COMPANY
PRD-EMPLOYEE -> EMP-EMPLOYEE
Gltrans GLTRANS Required
When PRD-GLT-OBJ-ID != Zeroes
PRD-GLT-OBJ-ID -> GLT-OBJ-ID
Job Code JOBCODE Required
When PRD-JOB-CODE != Spaces
PRD-COMPANY -> JBC-COMPANY
PRD-JOB-CODE -> JBC-JOB-CODE
Pay Code PRPAYCODE Required
When PRD-PCD-SEQ-NBR != Zeroes
PRD-COMPANY -> PCD-COMPANY
PRD-PCD-SEQ-NBR -> PCD-SEQ-NBR
Paymastr PAYMASTR Required
PRD-COMPANY -> PYM-COMPANY
PRD-EMPLOYEE -> PYM-EMPLOYEE
PRD-CHECK-ID -> PYM-CHECK-ID
Process Level PRSYSTEM Required
PRD-COMPANY -> PRS-COMPANY
PRD-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
PRDISTRIB FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When PRD-POSITION != Spaces
PRD-COMPANY -> POS-COMPANY
PRD-POSITION -> POS-POSITION
POS-EFFECT-DATE
Sltrans SLTRANS
PRD-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|
