|
|
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 HR170 HR70.1 PR295 PR285
PR55.1 HR00.1 HR01.1 PA82.1 PBIP.1
UPDATED BY
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
Element: Company Hr Identifies the AP company if the PR82.1 PR82.2
resource type = V. Identifies the HR PR85.1
company if the resource type = E. It is
blank for type A, P or Q resources.
PRD-EMPLOYEE Numeric 9 PR197 PR70.1
Element: 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 PR85.1
Element: Status 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
9 = Closed
PRD-PROCESS-LEVEL Alpha 5 PR197 PR82.1
Element: Process Lev HrContains the process level to which the PR82.2 PR85.1
amount is posted.
PRD-DEPARTMENT Alpha 5 PR197 PR82.1
Element: Department Contains the department to which the PR82.2 PR85.1
amount is posted.
PRD-RECORD-TYPE Alpha 1 PR197 PR82.1
Element: 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
Element: 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
Element: Accounting UniContains the general ledger accounting PR82.1 PR82.2
unit to which the amount is posted. PR85.1
PRD-DST-ACCOUNT Numeric 6 PR197 PR70.1
Element: Account Contains the general ledger account to PR82.1 PR82.2
which the amount is posted. PR85.1
PRD-DST-SUB-ACCT Numeric 4 PR197 PR70.1
Element: Subaccount Contains the general ledger subaccount PR82.1 PR82.2
to which the amount is posted. PR85.1
PRD-DIST-COMPANY Numeric 4 PR197 PR70.1
Element: 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
Element: 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
Element: Deduction CodeContains 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
Element: Hours Contains the hours associated with the PR82.2 PR85.1
distribution.
PRD-DIST-AMT Signed 13.2 PR197 PR82.1
Element: Distribution AContains the amount to be posted. PR82.2 PR85.1
PRD-GL-DATE Numeric 8 (yyyymmdd) PR197 PR82.1
Element: General LedgerContains the general ledger posting PR82.2 PR85.1
date.
PRD-JOB-CODE Alpha 9 PR197 PR82.1
Element: Job Code Contains the user-defined job code. PR82.2 PR85.1
PRD-RUN-DATE Numeric 8 (yyyymmdd) PR197 PR198
Element: Program Run DaContains 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 PR197 PR82.1
Element: 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 PR197 PR198
Object This is a subsystem GL interface
Identification identification number. It is used for
Drill Around purposes.
PRD-ATN-OBJ-ID Numeric 12 PR197 PR198
Object The system-defined object id PR82.1
Identification representing the Activity Management
commitment.
PRD-POSITION Alpha 12 PR197 PR82.1
Element: 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
Element: Account CategoAccount 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.
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 PR197 PR82.1
Element: 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
Account Currency Represents the number of decimals PR85.1
Code defined for the currency of the object.
PRD-ERROR-TYPE Numeric 1 PR197 PR70.1
Element: Error Type 1 = Currency Error Exists PR85.1
0 = No Error Exists
PRD-CO-CURR-CD Alpha 5 PR197 PR70.1
Element: Co Curr Cd PR82.1 PR85.1
PRD-DST-CO-CURR-CD Alpha 5 PR197 PR70.1
Element: Dst Co Curr Cd PR82.1 PR85.1
PRD-CO-EXCH-RATE Signed 14.7 PR197 PR70.1
Element: Co Exch Rate PR82.1 PR85.1
PRD-DIST-EXCH-RATE Signed 14.7 PR197 PR70.1
Element: Dist Exch Rate PR82.1 PR85.1
PRD-MSG-NBR Numeric 3 Occurs 10 Times PR197 PR70.1
Element: Msg Nbr PR82.1 PR85.1
PRD-HM-PROC-LEVEL Alpha 5 PR197 PR70.1
Element: Process Lev HrContains the employee's home process PR82.1 PR82.2
level. 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 PR197 PR82.1
Element: Ac191 Updated Indicates the completion of AC530 for PR85.1
Activity Management commitments.
PRD-GARN-OBJ-ID Numeric 12 PR197 PR82.1
Element: Garn Obj Id PR85.1
PRD-SEGMENT-SEQ Numeric 12 PR197 PR82.1
Element: Segment Seq PR85.1
PRD-TR-DATE Numeric 8 (yyyymmdd) PR197 PR82.1
Element: Time Record Date PR85.1
PRD-PER-END-DATE Numeric 8 (yyyymmdd) PR197
Element: Period End DatIdentifies 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
Object
Identification
PRD-GMI-OBJ-ID-2 Numeric 12
Object
Identification
PRDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRDSET1 COMPANY PA495 PR131
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 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 PBIP.1
EMPLOYEE PR197 PR198
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
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
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
|
