CMCONTRACT

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

Home
Contact Us



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