CMCONTRULE

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*
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: Thu Jun 09 11:12:09 2016

Home
Contact Us



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