|
|
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
PA495 PR131 PR195 HR170 HR70.1 PR295
PR285 PR55.1 HR00.1 HR01.1 PA82.1
UPDATED BY
ET530 PR197 PR198 PR300 PR70.1 PR82.1
PR82.2 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRD-COMPANY Numeric 4 ET530 PR197
Element: Company Hr PR70.1 PR82.1
PR82.2 PR85.1
PRD-EMPLOYEE Numeric 9 ET530 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 ET530 PR197
Element: Check Id Contains the payment identification PR70.1 PR82.1
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 ET530 PR197
Element: Obj Id This is the object identifier. It is PR70.1 PR82.1
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 ET530 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 ET530 PR197
Element: Process Lev HrContains the process level to which the PR82.1 PR82.2
amount is posted. PR85.1
PRD-DEPARTMENT Alpha 5 ET530 PR197
Element: Department Contains the department to which the PR82.1 PR82.2
amount is posted. PR85.1
PRD-RECORD-TYPE Alpha 1 ET530 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 ET530 PR197
Element: Check 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 ET530 PR197
Element: Acct Unit Contains the general ledger accounting PR70.1 PR82.1
unit to which the amount is posted. PR82.2 PR85.1
PRD-DST-ACCOUNT Numeric 6 ET530 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 ET530 PR197
Element: Sub Acct Contains the general ledger subaccount PR70.1 PR82.1
to which the amount is posted. PR82.2 PR85.1
PRD-DIST-COMPANY Numeric 4 ET530 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 ET530 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 ET530 PR197
Element: Ded Code Contains 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 ET530 PR197
Element: Hours Contains the hours associated with the PR82.1 PR82.2
distribution. PR85.1
PRD-DIST-AMT Signed 13.2 ET530 PR197
Element: Dist Amt Contains the amount to be posted. PR82.1 PR82.2
PR85.1
PRD-GL-DATE Numeric 8 (yyyymmdd) ET530 PR197
Element: Gl Date Contains the general ledger posting PR82.1 PR82.2
date. PR85.1
PRD-JOB-CODE Alpha 9 ET530 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: Run 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 ET530 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
Element: Obj Id This is the object identifier. It is PR85.1
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-ATN-OBJ-ID Numeric 12 PR197 PR198
Element: Obj Id This is the object identifier. It is PR82.1
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-POSITION Alpha 12 ET530 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 ET530 PR197
Element: Acct Category Account 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.
Valid account category types are:
cost
revenue
accrual
pass thru
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 ET530 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 ET530 PR197
Element: Acct Nd The number of decimals assigned to a PR82.1 PR85.1
particular account as determined by the
account currency.
PRD-ERROR-TYPE Numeric 1 ET530 PR197
Element: Error Type 1 = Currency Error Exists PR70.1 PR85.1
0 = No Error Exists
PRD-CO-CURR-CD Alpha 5 ET530 PR197
Element: Co Curr Cd PR70.1 PR82.1
PR85.1
PRD-DST-CO-CURR-CD Alpha 5 ET530 PR197
Element: Dst Co Curr Cd PR70.1 PR82.1
PR85.1
PRD-CO-EXCH-RATE Signed 14.7 ET530 PR197
Element: Co Exch Rate PR70.1 PR82.1
PR85.1
PRD-DIST-EXCH-RATE Signed 14.7 ET530 PR197
Element: Dist Exch Rate PR70.1 PR82.1
PR85.1
PRD-MSG-NBR Numeric 3 Occurs 10 Times ET530 PR197
Element: Msg Nbr PR70.1 PR82.1
PR85.1
PRD-HM-PROC-LEVEL Alpha 5 ET530 PR197
Element: Process Lev Hr PR70.1 PR82.1
PR82.2 PR85.1
PRD-ATTEND-CODE Alpha 2 PR197
Element: Attend 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 ET530 PR197
Element: Ac191 Updated PR82.1 PR85.1
PRD-GARN-OBJ-ID Numeric 12 ET530 PR197
Element: Garn Obj Id PR82.1 PR85.1
PRD-SEGMENT-SEQ Numeric 12 ET530 PR197
Element: Segment Seq PR82.1 PR85.1
PRD-TR-DATE Numeric 8 (yyyymmdd) ET530 PR197
Element: Tr Date PR82.1 PR85.1
PRD-PER-END-DATE Numeric 8 (yyyymmdd) PR197 PR82.1
Element: Per End Date Identifies period end date in
distribution record; used during PR198
to relieve salary encumbrance
commitments for pay period (updated from
TIMERECORD.PER-END-DATE).
PRD-PAY-UNITS Signed 7.2 PR197 PR82.1
Element: Pay Units PR82.2
PRD-UNIT-MEASURE Alpha 12 PR197 PR82.1
Element: Unit Measure PR82.2
PRD-OT-PLAN-CODE Alpha 4 PR197
Element: Ot Plan Code Identifies pay plan in effect for
employee when PRDISTRIB record was
created from PR197 (PRPRD).
PRD-GM-ADJ-TYPE Alpha 1
Element: Gm Adj Type Identifies labor cost transfer
adjustment type for PRDISTRIB adjustment
records created by GM170.
R = Reversing Entry
A = Adjusting Entry
PRD-GMI-OBJ-ID-1 Numeric 12
Element: Obj Id 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 Numeric 12
Element: Obj Id 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 Numeric 12 PR197
Element: Obj Id 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.
PRDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRDSET1 COMPANY ET530 PA495
EMPLOYEE PR131 PR195
CHECK-ID PR197 PR198
OBJ-ID PR300 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
GLT-OBJ-ID
DST-ACCT-UNIT
DST-ACCOUNT
DST-SUB-ACCT
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 PA82.1 PR198
EMPLOYEE
GL-DATE
CHECK-ID
OBJ-ID
PRDSET7 COMPANY KeyChange, Subset PA82.1
POSITION Where POSITION != Spaces
GL-DATE
EMPLOYEE
CHECK-ID
OBJ-ID
PRDSET8 COMPANY KeyChange
HM-PROC-LEVEL
EMPLOYEE
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
Actrans ACTRANS Not Required
PRD-ATN-OBJ-ID -> ATN-OBJ-ID
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
Gmlabdist GMLABDIST Not Required
PRD-GML-OBJ-ID -> GML-OBJ-ID
Gmretdist1 GMRETDIST Not Required
PRD-GMI-OBJ-ID-1 -> GMI-OBJ-ID
Gmretdist2 GMRETDIST Not Required
PRD-GMI-OBJ-ID-2 -> GMI-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
|
