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 PR140 PR80.1 PR89.1
BN15.1
UPDATED BY
BN430 BN500 BN56.1 PR199
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CPH-COMPANY Numeric 4 BN500 BN56.1
Company Contains the company number. PR199
CPH-EMPLOYEE Numeric 9 BN500 BN56.1
Employee Contains the employee number. PR199
CPH-PLAN-TYPE Alpha 2 BN500 BN56.1
Type Contains the type of benefit plan. PR199
DB = Defined Benefit
DC = Defined Contribution
CPH-PLAN-CODE Alpha 4 BN500 BN56.1
Plan This field is equal to the defined PR199
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 PR199
compensation and participation hours are
recorded. It is based on the
PLN-START-DATE month and day.
CPH-COMP-AMOUNT Signed 11.2 BN500 BN56.1
Compensation Amount The employee compensation is defined as PR199
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 PR199
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 PR140
PR199 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
|