|
|
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 PR285 PR55.1
UPDATED BY
PR150 PR195 PR199 PR300 PR82.1 PR82.2
PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRD-COMPANY Numeric 4 PR199 PR82.1
Company The company number represents an PR82.2 PR85.1
established company and is entered on
all function codes.
PRD-EMPLOYEE Numeric 9 PR199 PR82.1
Employee Contains the employee number. Each PR82.2 PR85.1
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.
PRD-CHECK-ID Numeric 12 PR199 PR82.1
Internal Check ID Contains the payment identification PR82.2 PR85.1
Number 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.
PRD-OBJ-ID Numeric 12 PR199 PR82.1
Object This is the object identifier. It is PR82.2 PR85.1
Identification 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-STATUS Numeric 1 PR150 PR195
Status Contains the distribution status. The PR199 PR82.1
system creates adjustments and reversals PR85.1
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 = Created in PR82, PR85, or PR87
9 = Closed
PRD-PROCESS-LEVEL Alpha 5 PR199 PR82.1
Process Level Contains the process level to which the PR82.2 PR85.1
amount is posted.
PRD-DEPARTMENT Alpha 5 PR199 PR82.1
Department Contains the department to which the PR82.2 PR85.1
amount is posted.
PRD-RECORD-TYPE Alpha 1 PR199 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 PR199 PR82.1
Payment Type Contains the payment type. PR82.2 PR85.1
A = ACH
P = Partial ACH
S = System
J = Adjustment
R = Void Reversal
PRD-DST-ACCT-UNIT Alpha 15 PR199 PR82.1
Distribution Contains the general ledger accounting PR82.2 PR85.1
Accounting Unit unit to which the amount is posted.
PRD-DST-ACCOUNT Numeric 6 PR199 PR82.1
Distribution Contains the general ledger account to PR82.2 PR85.1
Account Number which the amount is posted.
PRD-DST-SUB-ACCT Numeric 4 PR199 PR82.1
Distribution Contains the general ledger subaccount PR82.2 PR85.1
Subaccount Number to which the amount is posted.
PRD-DIST-COMPANY Numeric 4 PR199 PR82.1
Distribution Company Contains the company number to which a PR82.2 PR85.1
transaction is posted. A valid
intercompany relationship must be
defined in the General Ledger system.
PRD-PCD-SEQ-NBR Numeric 4 PR199 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 PR199 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 PR199 PR82.1
Hours Contains the hours associated with the PR82.2 PR85.1
distribution.
PRD-DIST-AMT Signed 11.2 PR199 PR82.1
Distribution Amount Contains the amount to be posted. PR82.2 PR85.1
PRD-GL-DATE Numeric 8 (yyyymmdd) PR199 PR82.1
General Ledger Date Contains the general ledger posting PR82.2 PR85.1
date.
PRD-JOB-CODE Alpha 9 PR199 PR82.1
Job Code Contains the user-defined job code. PR82.2 PR85.1
PRD-RUN-DATE Numeric 8 (yyyymmdd) PR150 PR195
Program Run Date Contains the date the transaction is PR199 PR82.1
posted to the general ledger. PR85.1
PRD-RUN-TIME Numeric 6 (hhmmss) PR150 PR195
Program Run Time Contains the time the transaction is PR199 PR82.1
posted to the general ledger. PR85.1
PRD-ACTIVITY Alpha 15 PR199 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. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
PRD-GLT-OBJ-ID Numeric 12 PR199
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 PR199
AC System Object ID The system-defined object id
(Sales) representing the Activity Management
committment.
PRD-POSITION Alpha 12 PR199 PR82.1
Position Contains the user-defined code that PR82.2 PR85.1
represents a position in the company.
PRD-ACCT-CATEGORY Alpha 5 PR199 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
PRDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRDSET1 COMPANY PR131 PR150
EMPLOYEE PR195 PR199
CHECK-ID PR300 PR82.1
OBJ-ID 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
PRDSET5 COMPANY KeyChange, Subset PR285 PR55.1
ACTIVITY Where ACTIVITY != Spaces
ATN-OBJ-ID
EMPLOYEE
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
|