This file contains employee contract YTD Paid and Wage Balances by pay period for Employee Contract Base and Supplemental Assignment payouts. The CW197 program will calculate and store these balances.
UPDATED BY

BN305	HR11.1	HR11.2	HR511	PA02.1	PA100
PA102	PA115	PA13.1	PA13.2	PA502	PA513
PA52.1	PA52.3	PA52.4	PA52.5	PR110	PR113
PR120	PR13.1	PR13.5	PR13.6	PR13.8	PR13.9

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CCE-COMPANY Element: Company Hr	Numeric 4 Identifies the HR Company.
CCE-EMPLOYEE Element: Employee	Numeric 9 Contains the employee number.
CCE-CONTRACT-YEAR Element: Cw Contract Yr	Numeric 4 Identifies the Contract Year. A Contract is only allowed to be defined if a Contract Rule exists for that specific Contract Year.
CCE-POSITION Element: Position	Alpha 12 Identifies the contract position assignment to update transactional detail earnings, docking, paid, and reserve balances.
CCE-CONT-SEQ-NBR Element: Cw Cont Seq No	Numeric 12 Identifies the contract assignment segment record to update transactional detail earnings, docking, paid, and reserve balances.
CCE-TRANS-SEQ-NBR Element: Cw Tran Seq No	Numeric 12 A transaction seq nbr is assigned per PRTIME record being stored in this detail transaction file.
CCE-CHECK-ID Element: Check Id	Numeric 12 Check Id is used as the link between payroll and employee contract assignment segments used for drilling purposes.
CCE-PAY-START-DATE Element: Pay Start Date	Numeric 8 (yyyymmdd) Pay Period Start Date based on the pay period closed by the PR197 payroll close program.
CCE-PAY-END-DATE Element: Pay End Date	Numeric 8 (yyyymmdd) Pay Period End Date based on the pay period closed by the PR197 payroll close program.
CCE-PCD-SEQ-NBR Element: Pcd Seq Nbr	Numeric 4 The Pay Code is assigned a Pcd Seq Nbr. This is related to the time record from PRTIME.
CCE-EARNED-WAGES Element: Cw Earned Wg	Signed 18.6 Earned wages per pay period. Computed by CW197.
CCE-EARNED-UNITS Element: Cw Earned Ut	Signed 18.6 Earned units per pay period. Computed by CW197.
CCE-DOCKED-WAGES Element: Cw Dock Wages	Signed 18.6 This is the amount to be taken off the contract amount as a result of employees' leave of absence. Computed by CW197.
CCE-DOCKED-UNITS Element: Cw Dock Units	Signed 18.6 This is the units to be taken off the units to be worked as a result of employees' leave of absence. Computed by CW197.
CCE-PAID-WAGES Element: Cw Paid Wages	Signed 18.6 Paid Wages per pay period (Earned Wages + Reserve Wages). Computed by the CW197
CCE-PAID-UNITS Element: Cw Paid Units	Signed 18.6 Paid Units per pay period (Earned Units + Reserve Units). Computed by the CW197
CCE-RESERVE-WAGES Element: Cw Res Wage	Signed 18.6 Reserve Wages per pay period (Paid Wages + Earned Wages). Computed by the CW197
CCE-RESERVE-UNITS Element: Cw Res Units	Signed 18.6 CW197 updates the YTD reserve unit balance.
CCE-CREATE-DATE Element: Date Stamp	Numeric 8 (yyyymmdd) This is the date that this record was added to the table.
CCE-CREATE-TIME Element: Time Stamp	Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed.
CCE-CREATE-USER-ID Element: User	Alpha 10 (Lower Case) Contains the User Id of the person that last changed this record.
CCE-CHECK-NBR Element: Check Nbr	Numeric 8
CCE-CHECK-DATE Element: Check Date	Numeric 8 (yyyymmdd)

CWEMPTRANS FILE INDEX

CWEMPTRANS FILE RELATIONS

ONE TO ONE RELATIONS

CWEMPTRANS FILE RELATIONS

ONE TO MANY RELATIONS

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