PRPENFSRCH – No description in the Lawson data dictionary

System: Payroll (PR)
Prefix: PFH
Primary key: COMPANY, EMPLOYEE, CHECK-ID, PENS-SEQ-NBR, FUNDING-SOURCE
Fields: 7
Updated by: 18 programs
Referenced by: 1 program

PRPENFSRCH is a Lawson Payroll table (prefix PFH); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, CHECK-ID, PENS-SEQ-NBR, FUNDING-SOURCE (PFHSET1); alternate indexes: PFHSET2. It is related 1:1 to PRSYSTEM, EMPLOYEE, PRPENPAY and PRCHECK. It is updated by BN66.1, PR140, PR160, PR180, PR189, PR195, PR29.1, PR300 and 10 more and referenced by PR197. The table has 7 fields, 2 indexes and 4 documented relations.

About PRPENFSRCH

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the PFH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PFH-COMPANY` PK COMPANY	Numeric 4	—	PR160, PR180, PR560, PR582, PR80.2, PR82.1
`PFH-EMPLOYEE` PK 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.	PR160, PR180, PR560, PR582, PR80.2, PR82.1
`PFH-CHECK-ID` PK CHECK_ID	Numeric 12	Contains the payment identification number (unique payment identifier used in tracking payment information).	PR160, PR180, PR560, PR582, PR80.2, PR82.1, PR85.1
`PFH-PENS-SEQ-NBR` PK PENS_SEQ_NBR	Numeric 4	—	PR160, PR180, PR560, PR582, PR80.2, PR82.1
`PFH-FUNDING-SOURCE` PK FUNDING_SOURCE	Alpha 6	—	PR160, PR180, PR560, PR582, PR80.2, PR82.1
`PFH-FUND-AMOUNT` FUND_AMOUNT	Signed 11.2	—	PR160, PR180, PR560, PR582, PR80.2, PR82.1, PR85.1
`PFH-PAYROLL-YEAR` PAYROLL_YEAR	Numeric 4	Contains the payroll year in which the allocation was taken.	PR160, PR180, PR560, PR582, PR80.2, PR82.1, PR85.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PFHSET1`	`COMPANY`, `EMPLOYEE`, `CHECK-ID`, `PENS-SEQ-NBR`, `FUNDING-SOURCE`	Primary		BN66.1, PR140, PR189, PR195, PR197, PR29.1, PR300, PR529 +8 more
`PFHSET2`	`COMPANY`, `EMPLOYEE`, `PAYROLL-YEAR`, `FUNDING-SOURCE`, `CHECK-ID`, `PENS-SEQ-NBR`			PR160, PR180, PR80.2

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Company	PRSYSTEM	Required	`PFH-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required	`PFH-COMPANY` → `EMP-COMPANY`, `PFH-EMPLOYEE` → `EMP-EMPLOYEE`
Pens Payment	PRPENPAY	Not Required	`PFH-COMPANY` → `PNP-COMPANY`, `PFH-EMPLOYEE` → `PNP-EMPLOYEE`, `PFH-PENS-SEQ-NBR` → `PNP-PENS-SEQ-NBR`
Prcheck	PRCHECK	Not Required	`PFH-COMPANY` → `PCH-COMPANY`, `PFH-EMPLOYEE` → `PCH-EMPLOYEE`, `PFH-PENS-SEQ-NBR` → `PCH-PENS-SEQ-NBR`, `PFH-CHECK-ID` → `PCH-CHECK-ID`

Programs

Updated by (18)

BN66.1 Estimated Pay Calculation
PR140 Earnings and Deductions Calculation
PR160 Payment Print
PR180 Manual Payment Print
PR189 Gross Up Calculation
PR195 Accrual Program
PR29.1 Pension Payment Maintenance
PR300 History Purge
PR529 Pension Payroll Conversion
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.2 Manual Payment Print
PR80.4 Manual Payment
PR82.1 Adjustment
PR85.1 Bank Account Reconciliation
PR89.1 Payment Modeling
PRAT.1 Alltax connection test

Referenced by (1)

PR197 Payroll Close