CMCONTRULE

REFERENCED BY
BN150 BN305 HR11.1 HR11.2 HR11.4 HR28.1
HR511 LT101 LT111 PR521 ZH510 EXI2.1
EXI4.1 LP130 PA02.1 PA100 PA102 PA115
PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PR110 PR113 PR12.6 PR120
PR128 PR13.1 PR13.5 PR13.6 PR13.8 PR13.9
PR131 PR132 PR134 PR135 PR136 PR137
PR189 PR29.1 PR30.2 PR32.1 PR32.2 PR33.1
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR36.1 PR36.4
PR37.1 PR45.1 PR512 PR529 PR530 PR560
PR582 PR80.1 PR80.4 PR82.1 UK102 TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRU-COMPANY
Element: Company Hr		Numeric 4
CRU-CONTRACT-GROUP
Element: Group		Alpha 15
CRU-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
CRU-PAID-CODE
Element: Day Code		Alpha 10
CRU-UNPAID-CODE
Element: Day Code		Alpha 10
CRU-WEEKEND-CODE
Element: Day Code		Alpha 10
CRU-CONTRACT-PAY
Element: Pay Class		Alpha 3
CRU-DOCKING-PAY
Element: Pay Class		Alpha 3
CRU-BENEFIT-PAY
Element: Pay Class		Alpha 3
CRU-BENEFIT-SALARY
Element: Flag		Alpha 1 Occurs 5 Times
CRU-PAY-CYCLE
Element: Pay Cycle		Alpha 1 Occurs 9 Times
CRU-TR-CREATION
Element: Flag Num		Numeric 1

1 = Paid by Pay Cycle
2 = Paid by Work Period
3 = Earned + Res by Pay Cycle
4 = Earned Work Per + Res Pay Cyc
5 = Daily Earned + Res by Pay Cyc
CRU-BEF-FIRST-CYC
Element: Flag Num		Numeric 1

1 = No Reserve
2 = All in Reserve
CRU-LATE-START-DT
Element: Flag Num		Numeric 1

1 = Pay Actual
2 = Normal Payout
3 = All in Reserve
CRU-REGULAR
Element: Pay Code		Alpha 4
CRU-RESERVE
Element: Pay Code		Alpha 4
CRU-RETRO-REG
Element: Pay Code		Alpha 4
CRU-RETRO-RES
Element: Pay Code		Alpha 4
CRU-ROUND-METH-UNT
Element: Cw Method		Numeric 1

0 = None
1 = Normal
2 = High
3 = Low
CRU-ROUND-TO-UNIT
Element: Cw Round To		Signed 18.6
CRU-ROUND-METH-DOL
Element: Cw Method		Numeric 1

0 = None
1 = Normal
2 = High
3 = Low
CRU-ROUND-TO-DOL
Element: Cw Round To		Signed 18.6
CRU-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
CRU-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
CRU-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
CRU-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
CRU-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
CRU-USER-ID
Element: User Id		Alpha 10 (Lower Case)
CRU-LATE-STEP-DOWN
Element: Flag Num		Numeric 1

0 = No
1 = Yes
CRU-EQUALIZE-WAGE
Element: Flag Num		Numeric 1

0 = No
1 = Yes; No Adjustment
2 = Yes; With Adjustment
CRU-TRUNCATE-AMT
Element: Flag Num		Numeric 1

0 = No
1 = Yes
CRU-TOLERANCE-AMT
Element: Cw Round To		Signed 18.6
CRU-WITHHOLD-RES
Element: Flag Num		Numeric 1

0 = No
1 = Yes


CMCONTRULE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRUSET1 COMPANY
CONTRACT-GROUP
EFFECT-DATE*
...
BN150 BN305
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 PR521
ZH510 EXI2.1
EXI4.1 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
CRUSET2 COMPANY
CONTRACT-GROUP
EFFECT-DATE
CRUSET3 COMPANY
EFFECT-DATE*
CONTRACT-GROUP


CMCONTRULE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
CRU-COMPANY->PRS-COMPANY (PRSSET1)
Spaces->PRS-PROCESS-LEVEL
Contract Pay PAYCLASS Required
CRU-COMPANY->PCL-COMPANY
CRU-CONTRACT-PAY->PCL-PAY-CLASS
Docking Pay PAYCLASS Required
When (CRU-DOCKING-PAY !=Spaces )
CRU-COMPANY->PCL-COMPANY
CRU-DOCKING-PAY->PCL-PAY-CLASS
Paid Day Code PCODES Required
"DC"->PCO-TYPE
CRU-PAID-CODE->PCO-CODE
Unpd Day Code PCODES Required
"DC"->PCO-TYPE
CRU-UNPAID-CODE->PCO-CODE
Wknd Day Code PCODES Required
"DC"->PCO-TYPE
CRU-WEEKEND-CODE->PCO-CODE


CMCONTRULE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Regular PRPAYCODE Required
CRU-COMPANY->PCD-COMPANY
CRU-REGULAR->PCD-PAY-CODE
  PCD-PROCESS-LEVEL
  PCD-JOB-CODE
Reserve PRPAYCODE Required
When (CRU-RESERVE !=Spaces )
CRU-COMPANY->PCD-COMPANY
CRU-RESERVE->PCD-PAY-CODE
  PCD-PROCESS-LEVEL
  PCD-JOB-CODE
Retro Reg PRPAYCODE Required
When CRU-RETRO-REG !=Spaces
CRU-COMPANY->PCD-COMPANY
CRU-RETRO-REG->PCD-PAY-CODE
  PCD-PROCESS-LEVEL
  PCD-JOB-CODE
Retro Res PRPAYCODE Required
When CRU-RETRO-RES !=Spaces
CRU-COMPANY->PCD-COMPANY
CRU-RETRO-RES->PCD-PAY-CODE
  PCD-PROCESS-LEVEL
  PCD-JOB-CODE

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

Home
Contact Us



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