CWEMPTRANS

REFERENCED BY
BN305 HR11.1 HR11.2 HR11.4 HR28.1 HR511
LT101 LT111 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 PR512

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CCE-COMPANY
Element: Company Hr		Numeric 4
CCE-EMPLOYEE
Element: Employee		Numeric 9
CCE-CONTRACT-YEAR
Element: Cw Contract Yr		Numeric 4
CCE-POSITION
Element: Position		Alpha 12
CCE-CONT-SEQ-NBR
Element: Cw Cont Seq No		Numeric 12
CCE-TRANS-SEQ-NBR
Element: Cw Tran Seq No		Numeric 12
CCE-CHECK-ID
Element: Check Id		Numeric 12
CCE-PAY-START-DATE
Element: Pay Start Date		Numeric 8 (yyyymmdd)
CCE-PAY-END-DATE
Element: Pay End Date		Numeric 8 (yyyymmdd)
CCE-PCD-SEQ-NBR
Element: Pcd Seq Nbr		Numeric 8
CCE-EARNED-WAGES
Element: Cw Earned Wg		Signed 18.6
CCE-EARNED-UNITS
Element: Cw Earned Ut		Signed 18.6
CCE-DOCKED-WAGES
Element: Cw Dock Wages		Signed 18.6
CCE-DOCKED-UNITS
Element: Cw Dock Units		Signed 18.6
CCE-PAID-WAGES
Element: Cw Paid Wages		Signed 18.6
CCE-PAID-UNITS
Element: Cw Paid Units		Signed 18.6
CCE-RESERVE-WAGES
Element: Cw Res Wage		Signed 18.6
CCE-RESERVE-UNITS
Element: Cw Res Units		Signed 18.6
CCE-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
CCE-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
CCE-CREATE-USER-ID
Element: User		Alpha 10 (Lower Case)
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 HR11.4
HR28.1 HR511
LT101 LT111
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
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 02:12:43 2016

Home
Contact Us



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