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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PNHSET1COMPANY, EMPLOYEE, CHECK-ID, PENS-SEQ-NBRPrimaryBN66.1, PR140, PR160, PR180, PR189, PR195, PR197, PR29.1 +11 more
PNHSET2COMPANY, EMPLOYEE, PENS-SEQ-NBR*, CHECK-IDPR29.1, PR529, PR560, PR582, PR82.1

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPNH-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredPNH-COMPANY → EMP-COMPANY, PNH-EMPLOYEE → EMP-EMPLOYEE
PaymastrPAYMASTRNot RequiredPNH-COMPANY → PYM-COMPANY, PNH-EMPLOYEE → PYM-EMPLOYEE, PNH-CHECK-ID → PYM-CHECK-ID
PrcheckPRCHECKNot RequiredPNH-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)