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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PFH-COMPANY PK
COMPANY		Numeric 4—PR160, PR180, PR560, PR582, PR80.2, PR82.1
#PFH-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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 12Contains 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 SET2
PAYROLL_YEAR		Numeric 4Contains the payroll year in which the allocation was taken.PR160, PR180, PR560, PR582, PR80.2, PR82.1, PR85.1

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PFHSET1
  1. COMPANY
  2. EMPLOYEE
  3. CHECK-ID
  4. PENS-SEQ-NBR
  5. FUNDING-SOURCE
PrimaryBN66.1, PR140, PR189, PR195, PR197, PR29.1, PR300, PR529 +8 more
PFHSET2
  1. COMPANY
  2. EMPLOYEE
  3. PAYROLL-YEAR
  4. FUNDING-SOURCE
  5. CHECK-ID
  6. PENS-SEQ-NBR
PR160, PR180, PR80.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMEMPLOYEEPRPENPAYPRCHECKPRPENFSRCH

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PFH-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PFH-COMPANY→EMP-COMPANY
PFH-EMPLOYEE→EMP-EMPLOYEE
Pens PaymentPRPENPAYNot Required
PFH-COMPANY→PNP-COMPANY
PFH-EMPLOYEE→PNP-EMPLOYEE
PFH-PENS-SEQ-NBR→PNP-PENS-SEQ-NBR
PrcheckPRCHECKNot 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)

Referenced by (1)