CMCONTRACT

REFERENCED BY
BN150 PR521 EXI2.1 EXI4.1 LP130 LP140
PR128 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


UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR15.1 HR511 HR515
HR54.1 HRS1.1 HRSC.1 PA02.1 PA100 PA102
PA113 PA115 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PA54.1 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9

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
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)


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
HR15.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PR521 EXI2.1
EXI4.1 LP130
LP140 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA502 PA513
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
Empsched CMEMPSCHD Delete Cascades
CNR-COMPANY->CES-COMPANY
CNR-EMPLOYEE->CES-EMPLOYEE
CNR-CONTRACT-NBR->CES-CONTRACT-NBR
  CES-WORK-SCHED
  CES-DATE
User Fields CMUSERFLD Delete Cascades
CNR-COMPANY->CMU-COMPANY
CNR-EMPLOYEE->CMU-EMPLOYEE
CNR-CONTRACT-NBR->CMU-CONTRACT-NBR
"1"->CMU-SEGMENT-TYPE
Zeroes->CMU-SEGMENT-NBR
  CMU-USR-FLD-TYPE
  CMU-USR-FLD-SEQ

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

Home
Contact Us



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