PRPENHIST – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PNH
Primary key
COMPANY, EMPLOYEE, CHECK-ID, PENS-SEQ-NBR
Fields
25
Updated by
18 programs
Referenced by
1 program

PRPENHIST is a Lawson Payroll table (prefix PNH); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, CHECK-ID, PENS-SEQ-NBR (PNHSET1); alternate indexes: PNHSET2. It is related 1:1 to PRSYSTEM, EMPLOYEE, PAYMASTR 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 25 fields, 2 indexes and 4 documented relations.

About PRPENHIST

No description in the Lawson data dictionary.

Fields (25)

Column = COBOL field name without the PNH- 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
#PNH-COMPANY PK
COMPANY		Numeric 4—PR160, PR180, PR560, PR582, PR80.2, PR82.1
#PNH-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
#PNH-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
#PNH-PENS-SEQ-NBR PK
PENS_SEQ_NBR		Numeric 4—PR160, PR180, PR560, PR582, PR80.2, PR82.1
#PNH-PENS-DIST-TYPE
PENS_DIST_TYPE		Numeric 2—
  • 01 Partial; Hardship
  • 02 Partial; Non-hardship
  • 03 Partial; Rollover to IRA
  • 04 Total; Non-rollover
  • 05 Total Rollover to IRA
  • 06 Total rollover to qual plan
  • 07 Periodic; > 10 years
  • 08 Periodic; < 10 years
  • 09 Periodic; < 10 years; Roll IRA
  • 10 Periodic; Tax not determined
  • 11 Periodic; W-2
  • 12 Lump sum payment; W-2
  • 13 Retro-payment
  • 14 Retro-payment; Rollover to IRA
  • 15 Loan issued
  • 16 Dividend
  • 17 Minimum distribution
  • 18 Excess deferrals
  • 19 Non-spousal death benefit
  • 20 Periodic non-res alien; 1042S
  • 21 Lump sum NRA; 1042S
  • 22 Periodic; 480.6
  • 23 Lump sum; 480.6
  • 24 Retro; W-2
PR160, PR180, PR560, PR582, PR80.2, PR82.1
#PNH-PENS-DIST-CODE
PENS_DIST_CODE		Alpha 1—
  • 1 Early distrib; No exception
  • 2 Early distrib; With exception
  • 3 Disability
  • 4 Death benefit
  • 5 Prohibited transaction
  • 6 Section 1035 exchange
  • 7 Normal distribution
  • 8 Excess contrib;Taxable curr yr
  • 9 PS 58 costs
  • A Qualified for 5/10yr averaging
  • D Exs cntrb;Txb in pri yr;Pri yr
  • E Excess annual addtns; Sec 415
  • G Direct rollover to IRA
  • H R-over to qual plan/tax sh ann
  • L Loan default
  • P Excess contrib;Txbl prior year
PR160, PR180, PR560, PR582, PR80.2, PR82.1
#PNH-PENS-DST-CODE2
PENS_DST_CODE2		Alpha 1—
  • A Qualified for 5/10yr averaging
  • D Exs cntrb;Txb in pri yr;Pri yr
  • G Direct rollover to IRA
  • H R-over to qual plan/tax sh ann
  • P Excess contrib;Txbl prior year
PR160, PR180, PR560, PR582, PR80.2, PR82.1
#PNH-TAX-CATEGORY
TAX_CATEGORY		Numeric 2—
  • 00 Regular
  • 70 Periodic
  • 71 Non-periodic;Not elig rollover
  • 72 Eligible for rollover
PR160, PR180, PR560, PR80.2
#PNH-ADDL-FED-TAX
ADDL_FED_TAX		Signed 9.2—PR160, PR180, PR560, PR80.2
#PNH-PERC-TOT-DIST
PERC_TOT_DIST		Numeric 3—PR160, PR180, PR560, PR582, PR80.2, PR82.1
#PNH-PAYABLE-TO
PAYABLE_TO		Alpha 38 (Lower Case)—PR160, PR180, PR560, PR80.2
#PNH-FBO-NAME
FBO_NAME		Alpha 38 (Lower Case)—PR160, PR180, PR560, PR80.2
#PNH-ADDR1
ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.PR160, PR180, PR560, PR80.2
#PNH-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.PR160, PR180, PR560, PR80.2
#PNH-ADDR3
ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.PR160, PR180, PR560, PR80.2
#PNH-ADDR4
ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.PR160, PR180, PR560, PR80.2
#PNH-CITY
CITY		Alpha 58 (Lower Case)This field contains the city of the address.PR160, PR180, PR560, PR80.2
#PNH-STATE
STATE		Alpha 2This field contains the two-character state code of the address.PR160, PR180, PR560, PR80.2
#PNH-POSTAL-CODE
POSTAL_CODE		Alpha 10 (Lower Case)This field contains the postal code.PR160, PR180, PR560, PR80.2
#PNH-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).PR160, PR180, PR560, PR80.2
#PNH-ROLLOVER-ACCT
ROLLOVER_ACCT		Alpha 17—PR160, PR180, PR560, PR80.2
#PNH-MISCELLANEOUS
MISCELLANEOUS		Alpha 6—PR160, PR180, PR560, PR80.2
#PNH-MISCELLANEOUS2
MISCELLANEOUS2		Alpha 6—PR160, PR180, PR560, PR80.2
#PNH-WIRE-IND
WIRE_IND		Numeric 1—
  • 1 Foreign
  • 2 Domestic
PR160, PR180, PR560, PR80.2
#PNH-CA-EFT
CA_EFT		Alpha 1—
  • N No
  • Y Yes
PR160, PR180, PR560, PR80.2

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
PNHSET1
  1. COMPANY
  2. EMPLOYEE
  3. CHECK-ID
  4. PENS-SEQ-NBR
PrimaryBN66.1, PR140, PR160, PR180, PR189, PR195, PR197, PR29.1 +11 more
PNHSET2
  1. COMPANY
  2. EMPLOYEE
  3. PENS-SEQ-NBR ↓
  4. CHECK-ID
PR29.1, PR529, PR560, PR582, PR82.1

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PNH-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PNH-COMPANY→EMP-COMPANY
PNH-EMPLOYEE→EMP-EMPLOYEE
PaymastrPAYMASTRNot Required
PNH-COMPANY→PYM-COMPANY
PNH-EMPLOYEE→PYM-EMPLOYEE
PNH-CHECK-ID→PYM-CHECK-ID
PrcheckPRCHECKNot Required
PNH-COMPANY→PCH-COMPANY
PNH-EMPLOYEE→PCH-EMPLOYEE
PNH-PENS-SEQ-NBR→PCH-PENS-SEQ-NBR
PNH-CHECK-ID→PCH-CHECK-ID

Programs

Updated by (18)

Referenced by (1)