CWCHANGE

This file contains Pay Rate change type records for employee position changes to pay related fields, Work Schedule change type records for employee contract work schedule changes to date and annual unit fields, and Add New Contract change type records for employee position work schedule changes. The Employee Contract Update (CW100 program) will create new contract segments for Pay Rate change type records and will update existing contract segments for Work Schedule change type records. The Employee Contract Mass Add (CW101 program) will create new employee contracts for Add New Contract change type records.
UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR15.1 HR511 HR515
HR54.1 HRS1.1 HRSC.1 PA02.1 PA100 PA102
PA113 PA115 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PA54.1 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CCH-COMPANY
Element: Hr Company
Numeric 4
Identifies the HR Company.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-POSITION
Element: Position
Alpha 12
Contains the position (PA13.1) of the employee contract assignment that was updated for Pay Rate change type record.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the date of the PAEMPPOS pay related change. This date will be the PAEMPPOS Effective Date when the new contract segment is created.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-CHANGE-TYPE
Element: Change Type
Alpha 1
Contains the type of change to process for an employee contract update. A Pay Rate change will create or update existing contract segments based on the employee's position effective date. A Work Schedule change will update all existing contract segments in effect for the contract year. An Add Contract change will create an initial contract assignment master or stop an existing contract assignment master and create a new contract assignment master for the new position or work schedule. A Term Contract is for automation of updates to the employee base contract when the position is used on a contract and the position level is ended or the employee is terminated.
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 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-HOLD-FLAG
Element: Cw Hold
Numeric 1
Enables a contract change record to be put on hold so CW100 will not process the change.
0 = Not on Hold
1 = On Hold
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-FTE
Element: Cw Fte
Signed 11.6
Updated with PAEMPPOS FTE for Pay Rate change type records.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-PAY-RATE
Element: Pay Rate
Signed 13.4
Updated with PAEMPPOS Pay Rate for Pay Rate change type records.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-SCHEDULE
Element: Schedule
Alpha 9
Updated with PAEMPPOS Schedule for Pay Rate change type records.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-PAY-GRADE
Element: Pay Grade
Alpha 3
Updated with PAEMPPOS Pay Grade for Pay Rate Change type records.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-PAY-STEP
Element: Pay Step
Numeric 2
Updated with PAEMPPOS Pay Step for Pay Rate change type records.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-WORK-START-DT
Element: Start Date
Numeric 8 (yyyymmdd)
Updated with HRWRKSCHD Work Start Dt for Work Schedule change type records.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-WORK-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
Updated with HRWRKSCHD Work End Date for Work Schedule change type records.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-ANNUAL-UNITS
Element: Cw Annual Unit
Signed 18.6
Updated with HRWRKSCHD Annual Units for Work Schedule change type records.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) when this record was created.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
This field contains the server time (hour, minute, and second) when this record was created.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
This field contains the User ID of the person or batch program that created this record.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
This field contains the server time (hour, minute, and second) when the record was last changed.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-USER-ID
Element: User
Alpha 10 (Lower Case)
This field contains the user ID of the person that last changed this record.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-WORK-SCHED
Element: Work Sched
Alpha 10
The Work Schedule that has been updated on CW01 neeeds to be stored to determine what employee contract to update by the CW100 program for Work Schedule changes. The Work Schedule will also be stored for Pay Rate and Add Contract change type records to be used in the creation of new contract segment records.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-PRIOR-VALUE
Element: Work Sched
Alpha 10
This holds the previous value of the work schedule for the employee's position and is stored for an Add Contract change type record. CW101 will use this value to determine what contract assignment master record to end when a new contract assignment master record is created when processing the Add Contract change type record.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
CCH-PAY-CYCLES
Element: Cw Pay Cycles
Numeric 3
Contains the Work Schedule's Number of Pay Cycles value that employee contract assignments will be updated for Work Schedule change type records by the CW100 program.


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 HR15.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110


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: Wed Jun 08 20:48:30 2016

Home
Contact Us



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