CWCHANGE

Employee Contract Change Audit
UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR11.4 HR15.1 HR28.1
HR511 HR515 HR54.1 HRS1.1 HRSC.1 LT101
LT11.5 LT111 LT13.5 ZH510 PA02.1 PA100
PA102 PA113 PA115 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PA54.1
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
CCH-COMPANY
Element: Hr Company		Numeric 4
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-EMPLOYEE
Element: Employee		Numeric 9
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-POSITION
Element: Position		Alpha 12
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-CHANGE-TYPE
Element: Change Type		Alpha 1

1 = Pay Rate Change
2 = Work Schedule Change
3 = Add Contract
4 = Term Contract
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-HOLD-FLAG
Element: Cw Hold		Numeric 1

0 = Not on Hold
1 = On Hold
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-FTE
Element: Cw Fte		Signed 11.6
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-PAY-RATE
Element: Pay Rate		Signed 13.4
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-SCHEDULE
Element: Schedule		Alpha 9
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-PAY-GRADE
Element: Pay Grade		Alpha 3
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-PAY-STEP
Element: Pay Step		Numeric 2
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-WORK-START-DT
Element: Start Date		Numeric 8 (yyyymmdd)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-WORK-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-ANNUAL-UNITS
Element: Cw Annual Unit		Signed 18.6
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-CREATE-USER-ID
Element: User		Alpha 10 (Lower Case)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-USER-ID
Element: User		Alpha 10 (Lower Case)
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-WORK-SCHED
Element: Work Sched		Alpha 10
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-PRIOR-VALUE
Element: Work Sched		Alpha 10
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR512
ZH510
CCH-PAY-CYCLES
Element: Cw Pay Cycles		Numeric 3


CWCHANGE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CCHSET1 COMPANY
EMPLOYEE
POSITION
WORK-SCHED
EFFECT-DATE
CHANGE-TYPE
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 ZH510
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502


CWCHANGE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
CCH-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When (CCH-EMPLOYEE !=Zeroes )
CCH-COMPANY->EMP-COMPANY
CCH-EMPLOYEE->EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
When (CCH-EMPLOYEE !=Zeroes )
CCH-COMPANY->PEM-COMPANY
CCH-EMPLOYEE->PEM-EMPLOYEE


CWCHANGE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Assignment CWASSIGN
CCH-COMPANY->CWA-COMPANY
CCH-EMPLOYEE->CWA-EMPLOYEE
  CWA-CONTRACT-YEAR
  CWA-POSITION
  CWA-ASG-EFFECT-DTE
  CWA-PCD-SEQ-NBR
Emp Contract CWCONTRACT Required
When (CCH-EMPLOYEE !=Zeroes )
CCH-COMPANY->CCT-COMPANY
CCH-EMPLOYEE->CCT-EMPLOYEE
  CCT-CONTRACT-YEAR
  CCT-POSITION
  CCT-CONT-SEQ-NBR
Paemppos PAEMPPOS Required
When (CCH-EMPLOYEE !=Zeroes )
CCH-COMPANY->PEP-COMPANY
CCH-EMPLOYEE->PEP-EMPLOYEE
CCH-POSITION->PEP-POSITION
  PEP-EFFECT-DATE
  PEP-POS-LEVEL
Work Schedule HRWRKSCHD
CCH-COMPANY->WSC-COMPANY
CCH-WORK-SCHED->WSC-WORK-SCHED
  WSC-CONTRACT-YEAR
  WSC-EFFECT-DATE

File created: Thu Jun 09 02:12:41 2016

Home
Contact Us



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