CWEMPTRANS

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 HR28.1 HR511 LT101
ZH510 PA02.1 PA100 PA102 PA115 PA13.1
PA13.2 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PR110 PR113 PR12.6 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR30.2

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CCESET1 COMPANY
EMPLOYEE
CONTRACT-YEAR*
POSITION
CONT-SEQ-NBR*
TRANS-SEQ-NBR*
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
ZH510 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2
CCESET2 COMPANY
EMPLOYEE
CONTRACT-YEAR
POSITION
PAY-END-DATE
CONT-SEQ-NBR
TRANS-SEQ-NBR
CCESET3 COMPANY
CONTRACT-YEAR*
EMPLOYEE
POSITION
PAY-END-DATE*
CONT-SEQ-NBR*
TRANS-SEQ-NBR*
Subset
Where(CONT-SEQ-NBR !=Zeroes)
CCESET4 COMPANY
CONTRACT-YEAR
EMPLOYEE
CHECK-ID
POSITION
TRANS-SEQ-NBR
CCESET5 COMPANY
CONTRACT-YEAR
EMPLOYEE
CHECK-DATE*
CHECK-NBR
POSITION
TRANS-SEQ-NBR


CWEMPTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
CCE-COMPANY->PRS-COMPANY (PRSSET1)
Spaces->PRS-PROCESS-LEVEL
Emp Contract CWCONTRACT Required
CCE-COMPANY->CCT-COMPANY
CCE-EMPLOYEE->CCT-EMPLOYEE
CCE-CONTRACT-YEAR->CCT-CONTRACT-YEAR
CCE-POSITION->CCT-POSITION
CCE-CONT-SEQ-NBR->CCT-CONT-SEQ-NBR
Employee EMPLOYEE Required
CCE-COMPANY->EMP-COMPANY
CCE-EMPLOYEE->EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
CCE-COMPANY->PEM-COMPANY
CCE-EMPLOYEE->PEM-EMPLOYEE


CWEMPTRANS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Assignment CWASSIGN
CCE-COMPANY->CWA-COMPANY
CCE-CONTRACT-YEAR->CWA-CONTRACT-YEAR
CCE-EMPLOYEE->CWA-EMPLOYEE
CCE-POSITION->CWA-POSITION
  CWA-ASG-EFFECT-DTE
  CWA-PCD-SEQ-NBR
Time Record PRTIME
CCE-COMPANY->PRT-COMPANY
CCE-EMPLOYEE->PRT-EMPLOYEE
CCE-PAY-END-DATE->PRT-PER-END-DATE
CCE-CHECK-ID->PRT-CHECK-ID
  PRT-TIME-SEQ


File created: Thu Jun 09 11:12:12 2016

Home
Contact Us



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