Employee Compensation History
The Employee Compensation History file contains compensation and hours of service by plan year for defined contribution and defined benefit plans. PR197 (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 | ZB10.1 | ZB31.1 | ZB31.2 | ZB32.1 |
ZB32.2 | ZB32.3 | HR170 | HR70.1 | PR140 | PR189 |
PR195 | PR80.1 | PR80.4 | PR89.1 | PRAT.1 | BN15.1 |
BN430 | BN556 | BN56.1 | PR197 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
CPH-COMPANY Element: Company Hr | Numeric 4 Contains the company number. |
|
||||
CPH-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. |
|
||||
CPH-PLAN-TYPE Element: Plan Type | Alpha 2 Contains the type of benefit plan. DB = Defined Benefit DC = Defined Contribution |
|
||||
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). |
|
||||
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. |
|
||||
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). |
|
||||
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). |
|
||||
CPH-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||||
CPH-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||
CPH-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
||||
CPH-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||||
CPH-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||
CPH-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CPHSET1 |
COMPANY EMPLOYEE PLAN-TYPE PLAN-CODE PLAN-YEAR |
|
| ||||||||||||||||||||||||||||||||||||
CPHSET2 |
COMPANY EMPLOYEE PLAN-TYPE PLAN-CODE PLAN-YEAR* |
|
| ||||||||||||||||||||||||||||||||||||
CPHSET3 |
COMPANY PLAN-TYPE PLAN-CODE PLAN-YEAR EMPLOYEE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Company | BNCOMPANY |
Required
| |||||||||
Company Name | PRSYSTEM |
Required
| |||||||||
Employee | EMPLOYEE |
Required
| |||||||||
Pa Employee | PAEMPLOYEE |
Required
| |||||||||
Plan | PLAN |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Benefit | BENEFIT |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.