|
|
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 PR195 HR170 HR70.1 PR295 PR285
PR55.1 HR00.1 HR01.1 PBIP.1
UPDATED BY
AC542 PR197 PR198 PR300 PR70.1 PR82.1
PR82.2 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRD-COMPANY Numeric 4 AC542 PR197
Element: Company The company number represents an PR70.1 PR82.1
established company and is entered on PR82.2 PR85.1
all function codes.
PRD-EMPLOYEE Numeric 9 AC542 PR197
Element: Employee Contains the employee number. Each PR70.1 PR82.1
person employed by the company is PR82.2 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 AC542 PR197
Internal Check ID Contains the payment identification PR70.1 PR82.1
Number number. When the system creates a PR82.2 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 AC542 PR197
Object This is the object identifier. It is PR70.1 PR82.1
Identification used to relate commitments or posted PR82.2 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 AC542 PR198
Element: 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 AC542 PR197
Element: Process Level Contains the process level to which the PR82.1 PR82.2
amount is posted. PR85.1
PRD-DEPARTMENT Alpha 5 AC542 PR197
Element: Department Contains the department to which the PR82.1 PR82.2
amount is posted. PR85.1
PRD-RECORD-TYPE Alpha 1 AC542 PR197
Element: Record Type This field identifies the type of PR82.1 PR82.2
record defined. PR85.1
Valid values are:
S = Summary
D = Detail
1 = Error suspense
A = Deduction Accrual
C = Cash Accrual
E = Expense Accrual
PRD-CHECK-TYPE Alpha 1 AC542 PR197
Element: Payment Type Contains the payment type. PR70.1 PR82.1
A = ACH PR82.2 PR85.1
P = Partial ACH
S = System
J = Adjustment
R = Void Reversal
M = Manual
PRD-DST-ACCT-UNIT Alpha 15 AC542 PR197
Element: Accounting UniContains the general ledger accounting PR70.1 PR82.1
unit to which the amount is posted. PR82.2 PR85.1
PRD-DST-ACCOUNT Numeric 6 AC542 PR197
Element: Account Contains the general ledger account to PR70.1 PR82.1
which the amount is posted. PR82.2 PR85.1
PRD-DST-SUB-ACCT Numeric 4 AC542 PR197
Element: Subaccount Contains the general ledger subaccount PR70.1 PR82.1
to which the amount is posted. PR82.2 PR85.1
PRD-DIST-COMPANY Numeric 4 AC542 PR197
Element: Company Contains the company number to which a PR70.1 PR82.1
transaction is posted. A valid PR82.2 PR85.1
intercompany relationship must be
defined in the General Ledger system.
PRD-PCD-SEQ-NBR Numeric 4 AC542 PR197
Element: Pcd Seq Nbr Contains the sequence number for the PR82.1 PR82.2
distribution relative to the pay code. PR85.1
PRD-DED-CODE Alpha 4 AC542 PR197
Element: Deduction CodeContains the deduction associated with PR82.1 PR82.2
the distribution. The system uses this PR85.1
field to identify employee deduction
distributions and company-paid deduction
distributions.
PRD-HOURS Signed 7.2 AC542 PR197
Element: Hours Contains the hours associated with the PR82.1 PR82.2
distribution. PR85.1
PRD-DIST-AMT Signed 13.2 AC542 PR197
Element: Distribution AContains the amount to be posted. PR82.1 PR82.2
PR85.1
PRD-GL-DATE Numeric 8 (yyyymmdd) AC542 PR197
Element: Date Contains the general ledger posting PR82.1 PR82.2
date. PR85.1
PRD-JOB-CODE Alpha 9 AC542 PR197
Element: Job Code Contains the user-defined job code. PR82.1 PR82.2
PR85.1
PRD-RUN-DATE Numeric 8 (yyyymmdd) PR197 PR198
Element: Date Contains the date the transaction is
posted to the general ledger.
PRD-RUN-TIME Numeric 6 (hhmmss) PR197 PR198
Element: Sys Time Contains the time the transaction is
posted to the general ledger.
PRD-ACTIVITY Alpha 15 AC542 PR197
Element: Activity Activities are the processes or PR82.1 PR82.2
procedures that produce work. Cost PR85.1
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PRD-GLT-OBJ-ID Numeric 12 PR197 PR198
Object
Identification
PRD-ATN-OBJ-ID Numeric 12 PR197 PR198
Object PR82.1
Identification
PRD-POSITION Alpha 12 AC542 PR197
Element: Position Contains the user-defined code that PR82.1 PR82.2
represents a position in the company. PR85.1
PRD-ACCT-CATEGORY Alpha 5 AC542 PR197
Element: Account CategoAccount categories are groupings of PR82.1 PR82.2
costs, revenues, or a combination of PR85.1
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
Element: Full Acct 1
PRD-FULL-ACCT-2 Derived
Element: Full Acct 2
PRD-FULL-ACCT Derived
Element: Full Acct
PRD-CURRENCY-CODE Alpha 5 AC542 PR197
Element: Currency Code This field contains the company base PR82.1 PR85.1
currency code established in Company
(GL10.1 ).
PRD-CURR-ND Numeric 1 AC542 PR197
Account Currency PR82.1 PR85.1
Code
PRD-ERROR-TYPE Numeric 1 AC542 PR197
Element: Error Type 1 = Currency Error Exists PR70.1 PR85.1
0 = No Error Exists
PRD-CO-CURR-CD Alpha 5 AC542 PR197
Element: Co Curr Cd PR70.1 PR82.1
PR85.1
PRD-DST-CO-CURR-CD Alpha 5 AC542 PR197
Element: Dst Co Curr Cd PR70.1 PR82.1
PR85.1
PRD-CO-EXCH-RATE Signed 12.6 AC542 PR197
Element: Co Exch Rate PR70.1 PR82.1
PR85.1
PRD-DIST-EXCH-RATE Signed 12.6 AC542 PR197
Element: Dist Exch Rate PR70.1 PR82.1
PR85.1
PRD-MSG-NBR Numeric 3 Occurs 10 Times AC542 PR197
Element: Msg Nbr PR70.1 PR82.1
PR85.1
PRD-HM-PROC-LEVEL Alpha 5 AC542 PR197
Element: Hm Proc Level PR70.1 PR82.1
PR82.2 PR85.1
PRD-ATTEND-CODE Alpha 2 PR197
Element: Attendance CodA 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 AC542 PR197
Element: Ac191 Updated PR82.1 PR85.1
PRD-GARN-OBJ-ID Numeric 12 AC542 PR197
Element: Garn Obj Id PR82.1 PR85.1
PRD-SEGMENT-SEQ Numeric 12 AC542 PR197
Element: Segment Seq PR82.1 PR85.1
PRD-TR-DATE Numeric 8 (yyyymmdd) AC542 PR197
Element: Time Record Date PR82.1 PR85.1
PRD-PAY-UNITS Signed 7.2
Element: Pay Units
PRD-UNIT-MEASURE Alpha 12
Element: Unit Measure
PRDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRDSET1 COMPANY AC542 PR131
EMPLOYEE PR195 PR197
CHECK-ID PR198 PR300
OBJ-ID PR70.1 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 PR285 PR55.1
ACTIVITY Where ACTIVITY != Spaces
ATN-OBJ-ID
EMPLOYEE
OBJ-ID
PRDSET6 COMPANY KeyChange, Subset HR00.1 HR01.1
PROCESS-LEVEL Where STATUS = 9 PBIP.1 PR197
EMPLOYEE PR198
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
|
