CMCHANGE

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CHG-COMPANY
Element: Hr Company		Numeric 4
CHG-EMPLOYEE
Element: Employee		Numeric 9
CHG-POS-LEVEL
Element: Pos Level		Numeric 2
CHG-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
CHG-CHANGE-TYPE
Element: Change Type		Alpha 1

1 = Pay Rate Change
2 = Work Schedule Change
3 = Add Contract
4 = Term Assignment
5 = Schedule Override
6 = Position Change
CHG-WORK-SCHED
Element: Work Sched		Alpha 10
CHG-CONTRACT-YEAR
Element: Cw Contract Yr		Numeric 4
CHG-CONTRACT-NBR
Element: Seq Number		Numeric 6
CHG-POSITION
Element: Position		Alpha 12
CHG-HOLD-FLAG
Element: Cw Hold		Numeric 1

0 = Not on Hold
1 = On Hold
CHG-FTE
Element: Cw Fte		Signed 11.6
CHG-PAY-RATE
Element: Pay Rate		Signed 13.4
CHG-SALARY-CLASS
Element: Salary Class		Alpha 1

H = Hourly
S = Salaried
CHG-WORK-START-DT
Element: Start Date		Numeric 8 (yyyymmdd)
CHG-WORK-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
CHG-ANNUAL-UNITS
Element: Cw Annual Unit		Signed 18.6
CHG-PRIOR-VALUE
Element: Work Sched		Alpha 10
CHG-PAY-CYCLES
Element: Cw Pay Cycles		Numeric 3
CHG-SCHEDULE
Element: Schedule		Alpha 9
CHG-PAY-GRADE
Element: Pay Grade		Alpha 3
CHG-PAY-STEP
Element: Pay Step		Numeric 2
CHG-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
CHG-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
CHG-CREATE-USER-ID
Element: User		Alpha 10 (Lower Case)
CHG-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
CHG-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
CHG-USER-ID
Element: User		Alpha 10 (Lower Case)


CMCHANGE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CHGSET1 COMPANY
EMPLOYEE
POS-LEVEL
EFFECT-DATE
CHANGE-TYPE
WORK-SCHED
CONTRACT-YEAR
CONTRACT-NBR
CHGSET2 COMPANY
EMPLOYEE
POS-LEVEL
WORK-SCHED
CONTRACT-YEAR
CONTRACT-NBR
CHANGE-TYPE
EFFECT-DATE


CMCHANGE FILE RELATIONS


ONE TO ONE RELATIONS

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


CMCHANGE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Work Schedule HRWRKSCHD
CHG-COMPANY->WSC-COMPANY
CHG-WORK-SCHED->WSC-WORK-SCHED
  WSC-CONTRACT-YEAR
  WSC-EFFECT-DATE

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

Home
Contact Us



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