PRDISTRIB

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
PR295 PR285 PA82.1


UPDATED BY
HR00.1 HR01.1 HR170 HR70.1 PA495 PR131
PR195 PR197 PR198 PR300 PR55.1 PR582
PR70.1 PR82.1 PR82.2 PR85.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRD-COMPANY
Element: Company Hr
Numeric 4
PR197 PR582
PR70.1 PR82.1
PR82.2 PR85.1
PRD-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number. Each 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.
PR197 PR582
PR70.1 PR82.1
PR82.2 PR85.1
PRD-CHECK-ID
Element: Check Id
Numeric 12
Contains the payment identification 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.
PR197 PR582
PR70.1 PR82.1
PR82.2 PR85.1
PRD-OBJ-ID
Element: Obj Id
Numeric 12
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.
PR197 PR582
PR70.1 PR82.1
PR82.2 PR85.1
PRD-STATUS
Element: Status
Numeric 1
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
1 = Updated
9 = Closed
PR197 PR198
PR85.1
PRD-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
Contains the process level to which the amount is posted.
PR197 PR582
PR82.1 PR82.2
PR85.1
PRD-DEPARTMENT
Element: Department
Alpha 5
Contains the department to which the amount is posted.
PR197 PR582
PR82.1 PR82.2
PR85.1
PRD-RECORD-TYPE
Element: Record Type
Alpha 1
This field identifies the type of record defined. Valid values are: S = Summary D = Detail
1 = Error suspense
A = Deduction Accrual
C = Cash Accrual
E = Expense Accrual
PR197 PR582
PR82.1 PR82.2
PR85.1
PRD-CHECK-TYPE
Element: Check Type
Alpha 1
Contains the payment type.
A = ACH
P = Partial ACH
S = System
J = Adjustment
R = Void Reversal
M = Manual
C = Contract
PR197 PR582
PR70.1 PR82.1
PR82.2 PR85.1
PRD-DST-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the general ledger accounting unit to which the amount is posted.
PR197 PR582
PR70.1 PR82.1
PR82.2 PR85.1
PRD-DST-ACCOUNT
Element: Account
Numeric 6
Contains the general ledger account to which the amount is posted.
PR197 PR582
PR70.1 PR82.1
PR82.2 PR85.1
PRD-DST-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the general ledger subaccount to which the amount is posted.
PR197 PR582
PR70.1 PR82.1
PR82.2 PR85.1
PRD-DIST-COMPANY
Element: Company
Numeric 4
Contains the company number to which a transaction is posted. A valid intercompany relationship must be defined in the General Ledger system.
PR197 PR582
PR70.1 PR82.1
PR82.2 PR85.1
PRD-PCD-SEQ-NBR
Element: Pcd Seq Nbr
Numeric 4
Contains the sequence number for the distribution relative to the pay code.
PR197 PR582
PR82.1 PR82.2
PR85.1
PRD-DED-CODE
Element: Ded Code
Alpha 4
Contains the deduction associated with the distribution. The system uses this field to identify employee deduction distributions and company-paid deduction distributions.
PR197 PR582
PR82.1 PR82.2
PR85.1
PRD-HOURS
Element: Hours
Signed 7.2
Contains the hours associated with the distribution.
PR197 PR582
PR82.1 PR82.2
PR85.1
PRD-DIST-AMT
Element: Dist Amt
Signed 13.2
Contains the amount to be posted.
PR197 PR582
PR82.1 PR82.2
PR85.1
PRD-GL-DATE
Element: Gl Date
Numeric 8 (yyyymmdd)
Contains the general ledger posting date.
PR197 PR582
PR82.1 PR82.2
PR85.1
PRD-JOB-CODE
Element: Job Code
Alpha 9
Contains the user-defined job code.
PR197 PR582
PR82.1 PR82.2
PR85.1
PRD-RUN-DATE
Element: Run Date
Numeric 8 (yyyymmdd)
Contains the date the transaction is posted to the general ledger.
PR197 PR198
PRD-RUN-TIME
Element: Sys Time
Numeric 6 (hhmmss)
Contains the time the transaction is posted to the general ledger.
PR197 PR198
PRD-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
PR197 PR582
PR82.1 PR82.2
PR85.1
PRD-GLT-OBJ-ID
Element: Obj Id
Numeric 12
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.
PR197 PR198
PR82.1 PR85.1
PRD-ATN-OBJ-ID
Element: Obj Id
Numeric 12
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.
PR197 PR198
PR582 PR82.1
PRD-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company.
PR197 PR582
PR82.1 PR82.2
PR85.1
PRD-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account categories are groupings of 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
PR197 PR582
PR82.1 PR82.2
PR85.1
PRD-FULL-ACCT-1
Element: Full Acct 1
Derived
PRD-FULL-ACCT-2
Element: Full Acct 2
Derived
PRD-FULL-ACCT
Element: Full Acct
Derived
PRD-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
PR197 PR582
PR82.1 PR85.1
PRD-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PR197 PR582
PR82.1 PR85.1
PRD-ERROR-TYPE
Element: Error Type
Numeric 1

1 = Currency Error Exists
0 = No Error Exists
PR197 PR70.1
PR85.1
PRD-CO-CURR-CD
Element: Co Curr Cd
Alpha 5
PR197 PR582
PR70.1 PR82.1
PR85.1
PRD-DST-CO-CURR-CD
Element: Dst Co Curr Cd
Alpha 5
PR197 PR582
PR70.1 PR82.1
PR85.1
PRD-CO-EXCH-RATE
Element: Co Exch Rate
Signed 14.7
PR197 PR582
PR70.1 PR82.1
PR85.1
PRD-DIST-EXCH-RATE
Element: Dist Exch Rate
Signed 14.7
PR197 PR582
PR70.1 PR82.1
PR85.1
PRD-MSG-NBR
Element: Msg Nbr
Numeric 3 Occurs 10 Times
PR197 PR582
PR70.1 PR82.1
PR85.1
PRD-HM-PROC-LEVEL
Element: Process Lev Hr
Alpha 5
PR197 PR582
PR70.1 PR82.1
PR82.2 PR85.1
PRD-ATTEND-CODE
Element: Attend Code
Alpha 2
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.
PR197
PRD-AC-UPDATED
Element: Ac191 Updated
Alpha 1
PR197 PR582
PR82.1 PR85.1
PRD-GARN-OBJ-ID
Element: Garn Obj Id
Numeric 12
PR197 PR582
PR82.1 PR85.1
PRD-SEGMENT-SEQ
Element: Segment Seq
Numeric 12
PR197 PR582
PR82.1 PR85.1
PRD-TR-DATE
Element: Tr Date
Numeric 8 (yyyymmdd)
PR197 PR582
PR82.1 PR85.1
PRD-PER-END-DATE
Element: Per End Date
Numeric 8 (yyyymmdd)
Identifies period end date in distribution record; used during PR198 to relieve salary encumbrance commitments for pay period (updated from TIMERECORD.PER-END-DATE).
PR197 PR82.1
PRD-PAY-UNITS
Element: Pay Units
Signed 7.2
PR197 PR82.1
PR82.2
PRD-UNIT-MEASURE
Element: Unit Measure
Alpha 12
PR197 PR82.1
PR82.2
PRD-OT-PLAN-CODE
Element: Ot Plan Code
Alpha 4
Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD).
PR197
PRD-GM-ADJ-TYPE
Element: Gm Adj Type
Alpha 1
Identifies labor cost transfer adjustment type for PRDISTRIB adjustment records created by GM170.
R = Reversing Entry
A = Adjusting Entry
PRD-GMI-OBJ-ID-1
Element: Obj Id
Numeric 12
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
Element: Obj Id
Numeric 12
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
Element: Obj Id
Numeric 12
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.
PR197


PRDISTRIB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRDSET1 COMPANY
EMPLOYEE
CHECK-ID
OBJ-ID
PA495 PR131
PR195 PR197
PR198 PR295
PR582 PR70.1
PR82.1 PR82.2
PR85.1
PRDSET2 COMPANY
EMPLOYEE
GL-DATE
CHECK-ID
OBJ-ID
KeyChange
HR170 HR70.1
PR300
PRDSET3 DIST-COMPANY
GLT-OBJ-ID
DST-ACCT-UNIT
DST-ACCOUNT
DST-SUB-ACCT
OBJ-ID
KeyChange
PRDSET4 COMPANY
STATUS
ERROR-TYPE
HM-PROC-LEVEL
DIST-COMPANY
DST-ACCT-UNIT
DST-ACCOUNT
DST-SUB-ACCT
GL-DATE
EMPLOYEE
CHECK-ID
OBJ-ID
KeyChange
PR198 PR70.1
PRDSET5 COMPANY
ACTIVITY
ATN-OBJ-ID
EMPLOYEE
OBJ-ID
KeyChange, Subset
WhereACTIVITY !=Spaces
PR285 PR55.1
PRDSET6 COMPANY
PROCESS-LEVEL
EMPLOYEE
GL-DATE
CHECK-ID
OBJ-ID
KeyChange, Subset
WhereSTATUS =9
HR00.1 HR01.1
PA82.1 PR198
PR295
PRDSET7 COMPANY
POSITION
GL-DATE
EMPLOYEE
CHECK-ID
OBJ-ID
KeyChange, Subset
WherePOSITION !=Spaces
PA82.1
PRDSET8 COMPANY
HM-PROC-LEVEL
EMPLOYEE
CHECK-ID
OBJ-ID
KeyChange


PRDISTRIB FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Glnames GLNAMES Required
PRD-DIST-COMPANY->GLN-COMPANY
PRD-DST-ACCT-UNIT->GLN-ACCT-UNIT
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
NAME
RELATED 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


File created: Thu Jun 09 11:27:12 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.