CMCONTRACT

REFERENCED BY
BN150 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR15.1 HR515 HR54.1 HRS1.1 HRSC.1
LT11.5 LT13.5 PR521 EXI2.1 EXI4.1 LP130
PA113 PA54.1 PR128 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 PR36.4 PR37.1 PR45.1 PR529 PR530
PR560 PR582 PR80.1 PR80.4 PR82.1 UK102
TA147


UPDATED BY
BN305 HR11.1 HR11.2 HR11.4 HR28.1 HR511
LT101 LT111 ZH510 PA02.1 PA100 PA102
PA115 PA13.1 PA13.2 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PR110 PR113 PR12.6
PR120 PR13.1 PR13.5 PR13.6 PR13.8 PR13.9
PR30.2 PR512

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CNR-COMPANY
Element: Company Hr
Numeric 4
CNR-EMPLOYEE
Element: Employee
Numeric 9
CNR-CONTRACT-NBR
Element: Seq Number
Numeric 6
CNR-WORK-SCHED
Element: Code
Alpha 10
CNR-CONTRACT-YEAR
Element: Cw Contract Yr
Numeric 4
CNR-CONTRACT-GROUP
Element: Group
Alpha 15
CNR-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
CNR-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
CNR-START-DT-OVR
Element: Cw Dte Ovr Flg
Numeric 1

0 = No
1 = Yes
CNR-END-DT-OVR
Element: Cw Dte Ovr Flg
Numeric 1

0 = No
1 = Yes
CNR-STATUS
Element: Cw Cont Status
Numeric 1

0 = Open
3 = Void
9 = Closed
CNR-CLOSE-DATE
Element: Close Date
Numeric 8 (yyyymmdd)
CNR-PAYOUT
Element: Cont Payout
Numeric 1

0 = No
1 = Payout in Full
2 = Payout Reserve only
3 = Payout Summer Deferral
CNR-NBR-PAY-CYCLES
Element: Cw Pay Cycles
Numeric 3
CNR-PAY-CYC-OVR
Element: Override Flg
Numeric 1
CNR-FULL-AMT
Element: Cw Full Amt
Signed 18.6
CNR-FULL-UNITS
Element: Cw Full Units
Signed 18.6
CNR-EST-CNR-AMT
Element: Cw Full Amt
Signed 18.6
CNR-BENEFIT-SAL
Element: Flag
Alpha 1 Occurs 5 Times
CNR-RIGHT
Element: Right
Alpha 10
CNR-CHECK-GRP
Element: Check Grp
Alpha 1
CNR-PROCESS-GRP
Element: Process Grp
Alpha 1
CNR-TAX-FREQ-OVER
Element: Tax Freq Over
Numeric 3

001 = Weekly
002 = Biweekly
003 = Semi-Monthly
004 = Monthly
005 = Daily
006 = Quarterly
007 = Semi-Annual
008 = Annual
009 = 9 Month Academic Monthly
010 = 10 Month Academic Monthly
CNR-PAY-CYCLE
Element: Pay Cycle
Alpha 1 Occurs 9 Times
CNR-YTD-PAID-WAGES
Element: Cw Ytd Paid Wg
Signed 18.6
CNR-YTD-PAID-UNITS
Element: Cw Ytd Paid Ut
Signed 18.6
CNR-YTD-DOCKED-WGS
Element: Cw Ytd Dock Wg
Signed 18.6
CNR-YTD-DOCKED-UTS
Element: Cw Ytd Dock Ut
Signed 18.6
CNR-WAGE-BALANCE
Element: Cw Wage Balanc
Signed 18.6
CNR-UNITS-BALANCE
Element: Cw Unit Balan
Signed 18.6
CNR-RESERVE-BAL
Element: Cw Res Bal
Signed 18.6
CNR-RESERVE-UNITS
Element: Cw Res Units
Signed 18.6
CNR-UNITS-WORKED
Element: Cw Units Wrkd
Signed 18.6
CNR-UNITS-REMAIN
Element: Units Remain
Signed 18.6
CNR-EP-RESV-PAYOUT
Element: Cont Payout
Numeric 1

0 = No
1 = Lump Sum
2 = By Pay Cycle
CNR-EP-CHECK-GRP
Element: Check Grp
Alpha 1
CNR-EP-PROCESS-GRP
Element: Process Grp
Alpha 1
CNR-UNIT-TYPE
Element: Cw Unit Type
Numeric 1

1 = Hours
2 = Days
3 = Zero Annual Units
CNR-BEN-ELIG-FLAG
Element: Ben Elig Flag
Numeric 1
CNR-CES-STATUS
Element: Cw Status
Numeric 1

0 = Open
9 = Closed
CNR-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
CNR-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
CNR-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
CNR-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
CNR-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
CNR-USER-ID
Element: User
Alpha 10 (Lower Case)
CNR-LATE-STEP-DOWN
Element: Flag Num
Numeric 1

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

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

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

0 = No
1 = Yes
CNR-YTD-SUMR-DEFRL
Element: Cw Ytd Paid Wg
Signed 18.6
CNR-HRH-OBJ-ID
Element: Obj Id
Numeric 12
CNR-YTD-UNTS-DEFRL
Element: Cw Ytd Paid Ut
Signed 18.6


CMCONTRACT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CNRSET1 COMPANY
EMPLOYEE
CONTRACT-NBR*
...
BN150 BN305
HAP3.1 HCRE.1
HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
HR11.4 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
PR521 ZH510
EXI2.1 EXI4.1
LP130 PA02.1
PA100 PA102
CNRSET2 COMPANY
CONTRACT-YEAR*
EMPLOYEE
CONTRACT-NBR*
CNRSET3 COMPANY
CONTRACT-YEAR
WORK-SCHED
EMPLOYEE
CONTRACT-NBR


CMCONTRACT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
CNR-COMPANY->PRS-COMPANY (PRSSET1)
Spaces->PRS-PROCESS-LEVEL
Contract Group PCODES Required
When (CNR-CONTRACT-GROUP !=Spaces )
"CG"->PCO-TYPE
CNR-CONTRACT-GROUP->PCO-CODE
Contract Right PCODES Required
When (CNR-RIGHT !=Spaces )
"RR"->PCO-TYPE
CNR-RIGHT->PCO-CODE
Employee EMPLOYEE Required
CNR-COMPANY->EMP-COMPANY
CNR-EMPLOYEE->EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
CNR-COMPANY->PEM-COMPANY
CNR-EMPLOYEE->PEM-EMPLOYEE
Work Schedule HRWRKSCHD Required
CNR-COMPANY->WSC-COMPANY
CNR-WORK-SCHED->WSC-WORK-SCHED
CNR-CONTRACT-YEAR->WSC-CONTRACT-YEAR
Zeroes->WSC-EFFECT-DATE


CMCONTRACT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Assignments CMASSIGN Delete Cascades
CNR-COMPANY->CAS-COMPANY
CNR-EMPLOYEE->CAS-EMPLOYEE
CNR-CONTRACT-NBR->CAS-CONTRACT-NBR
  CAS-SEGMENT-NBR
Contract Rule CMCONTRULE
CNR-COMPANY->CRU-COMPANY
CNR-CONTRACT-GROUP->CRU-CONTRACT-GROUP
  CRU-EFFECT-DATE


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

Home
Contact Us



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