Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             COMPHIST FILE

                     Employee Compensation History

The Employee Compensation History file contains compensation and hours of
service by plan year for defined contribution and defined benefit plans.

PR199 (Payroll Close) updates this file for employees enrolled in defined
contribution and defined benefit benefits.

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN236
BN31.1    BN31.2    BN32.1    BN32.2    BN32.3    BN531
BS32.1    HR170     HR70.1    PR89.1    BN15.1

UPDATED BY

BN430     BN500     BN56.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CPH-COMPANY          Numeric 4                                   BN500   BN56.1
Company              Contains the company number.                PR197

CPH-EMPLOYEE         Numeric 9                                   BN500   BN56.1
Employee             Contains the employee number.               PR197

CPH-PLAN-TYPE        Alpha 2                                     BN500   BN56.1
Type                 Contains the type of benefit plan.          PR197
                     DB = Defined Benefit
                     DC = Defined Contribution

CPH-PLAN-CODE        Alpha 4                                     BN500   BN56.1
Plan                 This field is equal to the defined          PR197
                     contribution or defined benefit plan
                     code from the BENEFIT file
                     (BEN-PLAN-CODE).

CPH-PLAN-YEAR        Numeric 4                                   BN500   BN56.1
Plan Year            Contains the plan year for which            PR197
                     compensation and participation hours are
                     recorded.  It is based on the
                     PLN-START-DATE month and day.

CPH-COMP-AMOUNT      Signed 13.2                                 BN500   BN56.1
Compensation Amount  The employee compensation is defined as     PR197
                     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).

CPH-HOURS-SERV       Signed 7.2                                  BN500   BN56.1
Hours                Hours of Service is tracked by total        PR197
                     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).

                         COMPHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CPHSET1   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          PLAN-TYPE                                              BN105   BN236
          PLAN-CODE                                              BN31.1  BN31.2
          PLAN-YEAR                                              BN32.1  BN32.2
                                                                 BN32.3  BN430
                                                                 BN500   BN531
                                                                 BS32.1  HR170
                                                                 HR70.1  PR197
                                                                 PR89.1

CPHSET2   COMPANY                                                BN56.1
          EMPLOYEE
          PLAN-TYPE
          PLAN-CODE
          PLAN-YEAR*

CPHSET3   COMPANY       KeyChange                                BN15.1
          PLAN-TYPE
          PLAN-CODE
          PLAN-YEAR
          EMPLOYEE

                         COMPHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

                         COMPHIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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