CMCONTRULE

UPDATED BY
BN150 BN305 HR11.1 HR11.2 HR511 PR521
EXI2.1 EXI4.1 LP130 LP140 PA02.1 PA100
PA102 PA115 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR120 PR128 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR130 PR131 PR132 PR134 PR135
PR136 PR137 PR189 PR29.1 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
PR37.1 PR45.1 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 UK102 UK560 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
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)


CMCONTRULE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRUSET1 COMPANY
CONTRACT-GROUP
EFFECT-DATE*
...
BN150 BN305
HR11.1 HR11.2
HR511 PR521
EXI2.1 EXI4.1
LP130 LP140
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.8
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

File created: Wed Jun 08 20:48:30 2016

Home
Contact Us



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