COMPHIST

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
BN236 BN66.1 PR140 PR189 PR195 PR80.1
PR80.4 PR89.1


UPDATED BY
BN430 BN556 BN56.1 PR197 BN100 BN101
BN102 BN103 BN105 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN531 BS32.1 HR170 HR70.1
BN15.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CPH-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
BN556 BN56.1
PR197
CPH-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number.
BN556 BN56.1
PR197
CPH-PLAN-TYPE
Element: Plan Type
Alpha 2
Contains the type of benefit plan.
DB = Defined Benefit
DC = Defined Contribution
BN556 BN56.1
PR197
CPH-PLAN-CODE
Element: 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
Element: 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
Element: 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
Element: 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


COMPHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CPHSET1 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
PLAN-YEAR
BN100 BN101
BN102 BN103
BN105 BN236
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN430
BN531 BN556
BN66.1 BS32.1
HR170 HR70.1
PR140 PR189
PR195 PR197
PR80.1 PR80.4
PR89.1
CPHSET2 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
PLAN-YEAR*
BN56.1
CPHSET3 COMPANY
PLAN-TYPE
PLAN-CODE
PLAN-YEAR
EMPLOYEE
KeyChange
BN15.1


COMPHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:48:07 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.