Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

COMPHIST


                             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
BN66.1    BS32.1    HR170     HR70.1    PR140     PR189
PR195     PR80.1    PR89.1    BN15.1

UPDATED BY

BN430     BN56.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CPH-COMPANY            Numeric 4                                 BN56.1  PR197
Element: Company Hr    Contains the company number.

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

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

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

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

CPH-COMP-AMOUNT        Signed 13.2                               BN56.1  PR197
Element: Comp Amount   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).

CPH-HOURS-SERV         Signed 7.2                                BN56.1  PR197
Element: Hours Serv    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).

                         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
                                                                 BN531   BN66.1
                                                                 BS32.1  HR170
                                                                 HR70.1  PR140
                                                                 PR189   PR195
                                                                 PR197   PR80.1
                                                                 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