COMPHIST – Employee Compensation History

System: Benefits (BN)
Prefix: CPH
Primary key: COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, PLAN-YEAR
Fields: 13
Updated by: 4 programs
Referenced by: 30 programs

COMPHIST is the Employee Compensation History table in Lawson Benefits (prefix CPH). It is indexed by COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, PLAN-YEAR (CPHSET1); alternate indexes: CPHSET2 and CPHSET3. It is related 1:1 to BNCOMPANY, PRSYSTEM, EMPLOYEE, PAEMPLOYEE and PLAN and 1:M to BENEFIT. It is updated by BN430, BN556, BN56.1 and PR197 and referenced by BN100, BN101, BN102, BN103, BN105, BN15.1, BN236, BN31.1 and 22 more. The table has 13 fields, 3 indexes and 6 documented relations.

About COMPHIST

The Employee Compensation History file contains compensation and hours of service by plan year for defined contribution and defined benefit plans. PR197 (Payroll Close) updates this file for employees enrolled in defined contribution and defined benefit benefits.

Fields (13)

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

Field / column	Type	Description & values	Updated by
`CPH-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN556, BN56.1, PR197
`CPH-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number.	BN556, BN56.1, PR197
`CPH-PLAN-TYPE` PK PLAN_TYPE	Alpha 2	Contains the type of benefit plan. `DB` Defined Benefit `DC` Defined Contribution	BN556, BN56.1, PR197
`CPH-PLAN-CODE` PK PLAN_CODE	Alpha 4	This field is equal to the defined contribution or defined benefit plan code from the BENEFIT file (BEN-PLAN-CODE).	BN556, BN56.1, PR197
`CPH-PLAN-YEAR` PK PLAN_YEAR	Numeric 4	Contains the plan year for which compensation and participation hours are recorded. It is based on the PLN-START-DATE month and day.	BN556, BN56.1, PR197
`CPH-COMP-AMOUNT` COMP_AMOUNT	Signed 13.2	The employee compensation is defined as either the total pay or the definition of the base pay class in BN00.1 (Benefits Company). Each plan in BN16.1 (Defined Contribution Plan) and BN17.1 (Defined Benefit Plan) can be set up as either total or base pay (PLN-TOT-BASE-FLAG = "T" or "B"). Compensation is tracked in the Payroll system in the PAYWAGE file. The amount from the PYW-AMOUNT is updated into this field by PR199 (Payroll Close).	BN556, BN56.1, PR197
`CPH-HOURS-SERV` HOURS_SERV	Signed 7.2	Hours of Service is tracked by total hours or by base pay class defined in BN00.1 (Benefits Company). Each plan in BN16.1 (Defined Contribution Plan) and BN17.1 (Defined Benefit Plan) can be set up as either total or base pay (PLN-TOT-BASE-FLAG = "T" or "B"). Hours worked are tracked in the Payroll system in the PAYWAGE file. The amount from PYW-HOURS is updated into this field by PR199 (Payroll Close).	BN556, BN56.1, PR197
`CPH-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN556, BN56.1, PR197
`CPH-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN556, BN56.1, PR197
`CPH-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN556, BN56.1, PR197
`CPH-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN556, BN56.1, PR197
`CPH-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN556, BN56.1, PR197
`CPH-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN556, BN56.1, PR197

Indexes (3)

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

Index	Keys	Flags	Used in
`CPHSET1`	`COMPANY`, `EMPLOYEE`, `PLAN-TYPE`, `PLAN-CODE`, `PLAN-YEAR`	Primary	BN100, BN101, BN102, BN103, BN105, BN236, BN31.1, BN31.2 +22 more (list truncated in source)
`CPHSET2`	`COMPANY`, `EMPLOYEE`, `PLAN-TYPE`, `PLAN-CODE`, `PLAN-YEAR*`		BN56.1
`CPHSET3`	`COMPANY`, `PLAN-TYPE`, `PLAN-CODE`, `PLAN-YEAR`, `EMPLOYEE`	KeyChange	BN15.1

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Field map
Company	BNCOMPANY	Required	`CPH-COMPANY` → `BNC-COMPANY`
Company Name	PRSYSTEM	Required	`CPH-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required	`CPH-COMPANY` → `EMP-COMPANY`, `CPH-EMPLOYEE` → `EMP-EMPLOYEE`
Pa Employee	PAEMPLOYEE	Required	`CPH-COMPANY` → `PEM-COMPANY`, `CPH-EMPLOYEE` → `PEM-EMPLOYEE`
Plan	PLAN	Required	`CPH-COMPANY` → `PLN-COMPANY`, `CPH-PLAN-TYPE` → `PLN-PLAN-TYPE`, `CPH-PLAN-CODE` → `PLN-PLAN-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Benefit	BENEFIT	Delete Restricted		`CPH-COMPANY` → `BEN-COMPANY`, `CPH-EMPLOYEE` → `BEN-EMPLOYEE`, `CPH-PLAN-TYPE` → `BEN-PLAN-TYPE`, `CPH-PLAN-CODE` → `BEN-PLAN-CODE`, → `BEN-START-DATE`

Programs

Updated by (4)

BN430 Benefit Purge
BN556 Compensation History Upload
BN56.1 Compensation History
PR197 Payroll Close

Referenced by (30)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN15.1 Benefit Plan
BN236 Participation Report
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN531 Batch Benefit Enrollment
BN66.1 Estimated Pay Calculation
BS32.1 Web Enrollment Stop Benefits Update
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
PR140 Earnings and Deductions Calculation
PR189 Gross Up Calculation
PR195 Accrual Program
PR80.1 Manual Check
PR80.4 Manual Payment
PR89.1 Payment Modeling
PRAT.1 Alltax connection test
ZB10.1 Coverage Options Calculator
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add