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 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: Type Contains the type of benefit plan.
DB = Defined Benefit
DC = Defined Contribution
CPH-PLAN-CODE Alpha 4 BN56.1 PR197
Element: Plan 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: Compensation AThe 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 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 BS32.1
HR170 HR70.1
PR197
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
|
