CWCONTRACT

Contracts are used in K12 school districts to manage and track employee employment records and drive an employee's pay for the contract year.

REFERENCED BY
BN150 HR04.2 HR04.3 HR04.7 HR04.8 HR80.1
HR80.2 HR80.3 HR80.4 HR80.5 HR80.6 HR80.7
HR80.8 HR80.9 HR81.1 HR81.2 HR81.3 HR81.4
HR81.5 HR81.6 HR81.7 HR81.8 HR81.9 HR82.1
HR82.2 HR82.3 HR82.4 HR82.5 HR82.6 HR82.7
HR82.8 HR82.9 HR83.1 HR83.2 HR83.3 HR83.4
HR83.5 HR83.6 HR83.7 HR83.8 HR83.9 HR84.1
HR84.2 HR84.3 HR84.4 HR84.5 HR84.6 HR84.7
HR84.8 HR84.9 HR85.1 HR85.2 HR85.3 HR85.4
HR85.5 HR85.6 HR85.7 HR85.8 HR86.1 HR86.2
HR86.3 HR86.4 HR86.5 HR86.6 HR86.7 HR86.8
HR86.9 HR87.1 HR87.2 HR87.3 HR87.4 HR87.5
HR87.6 HR87.7 HR87.8 HR87.9 HR88.1 HR88.2
HR88.3 HR88.4 HR88.5 HR88.6 HR88.7 HR89.1
HR89.2 HR89.3 HR89.4 HR89.5 HR89.6 HR89.7
HR89.8 HR89.9 HR91.7 HR92.1 HR92.2 HR92.3
PR521 EXI2.1 EXI4.1 LP130 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
PR20.4 PR30.2 PR512 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 PA113 PA54.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CCT-COMPANY
Element: Company Hr		Numeric 4
Identifies the HR company.
CCT-EMPLOYEE
Element: Employee		Numeric 9
CCT-CONTRACT-YEAR
Element: Cw Contract Yr		Numeric 4
Contains the Contract Year. A Contract is only allowed to be defined if a Contract Rule exists for that specific Contract Year.
CCT-POSITION
Element: Position		Alpha 12
The employee's position is the contract assignment. There is a 1 to 1 relationship from CWCONTRACT to PAEMPPOS.
CCT-CONT-SEQ-NBR
Element: Cw Cont Seq No		Numeric 12
CCT-WORK-SCHED
Element: Code		Alpha 10
The employee's calendar defined in HRWRKSCHD that defines the contract dates for the employee's work schedule and determines how often and how much the employee is paid.
CCT-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
Effective Date of PAEMPPOS position level record.
CCT-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
Date will default from the Work Sched Code as the Contract End Date and will be displayed on the Contract Header.
CCT-FULL-UNITS
Element: Cw Full Units		Signed 18.6
CCT-FULL-AMT
Element: Cw Full Amt		Signed 18.6
CCT-PRORATED-UNITS
Element: Cw Prorate Unt		Signed 18.6
CCT-PRORATED-AMT
Element: Cw Prorated Am		Signed 18.6
CCT-SCHEDULE
Element: Schedule		Alpha 9
PAEMPPOS schedule will default to contract and be displayed on the contract header. User may override the schedule and select the Lock Flag to pay out on old schedule rates.
CCT-PAY-GRADE
Element: Pay Grade		Alpha 3
PAEMPPOS Grade will default to contract and be displayed on the contract header. User may override the Grade for the Schedule and select the Lock Flag to pay out on old schedule rate.
CCT-PAY-STEP
Element: Pay Step		Numeric 2
PAEMPPOS Step will default to contract and be displayed on the contract header. User may override the Step from the Schedule and select the Lock Flag to pay out on old schedule rate.
CCT-PAY-RATE
Element: Pay Rate		Signed 13.4
PAEMPPOS Pay Rate will default to contract and be displayed on the contract header. User may override this field value.
CCT-RIGHT
Element: Right		Alpha 10
A contract right is defined as a user defined PCODE and may be assigned to an employee's contract record. Rights are used to identify what contracts need to be reviewed and an example would be short term contract, permit holder, or long-term substitute.
CCT-GROUP
Element: Group		Alpha 15
A contract group is used for grouping contract records together for reporting purposes.
CCT-PAY-CODE
Element: Pay Code		Alpha 4
CCT-PCD-SEQ-NBR
Element: Pcd Seq Nbr		Numeric 8
CCT-CHECK-GRP
Element: Check Grp		Alpha 1
CCT-PROCESS-GRP
Element: Process Grp		Alpha 1
CCT-PAY-CYCLE
Element: Cw Pay Cycle		Alpha 1 Occurs 9 Times

X
CCT-TAX-FREQ-OVER
Element: Tax Freq Over		Numeric 3

001 = Weekly
002 = Biweekly
003 = Semi-monthly
004 = Monthly
005 = Daily
006 = Quarterly
007 = Semi-annually
008 = Annually
009 = 9 Month Academic Monthly
010 = 10 Month Academic Monthly
CCT-DATE-OVER-FLG
Element: Cw Dte Ovr Flg		Numeric 1

1 = No
2 = Yes
CCT-PAY-PER-AMT
Element: Cw Pay Per Amt		Signed 18.6
CCT-YTD-PAID-WAGES
Element: Cw Ytd Paid Wg		Signed 18.6
CCT-YTD-DOCKED-WGS
Element: Cw Ytd Dock Wg		Signed 18.6
CCT-WAGE-BALANCE
Element: Cw Wage Balanc		Signed 18.6
CCT-YTD-PAID-UNITS
Element: Cw Ytd Paid Ut		Signed 18.6
CCT-YTD-DOCKED-UTS
Element: Cw Ytd Dock Ut		Signed 18.6
CCT-UNITS-BALANCE
Element: Cw Unit Balan		Signed 18.6
CCT-UNITS-WORKED
Element: Cw Units Wrkd		Signed 18.6
CCT-RESERVE-BAL
Element: Cw Res Bal		Signed 18.6
CCT-RESERVE-UNITS
Element: Cw Res Units		Signed 18.6
CCT-CONT-PAYOUT
Element: Cont Payout		Numeric 1

1 = No
2 = Yes; Payout in Full
3 = Payout Reserve Only
CCT-CONT-STATUS
Element: Cw Cont Status		Numeric 1

0 = Open
3 = Void
9 = Closed
CCT-CONT-CLOSE-DT
Element: Cont Close Dt		Numeric 8 (yyyymmdd)
CCT-USER-ALPHA-1
Element: Cw User Alpha		Alpha 20 (Lower Case)
CCT-USER-ALPHA-2
Element: Cw User Alpha		Alpha 20 (Lower Case)
CCT-USER-ALPHA-3
Element: Cw User Alpha		Alpha 20 (Lower Case)
CCT-USER-ALPHA-4
Element: Cw User Alpha		Alpha 20 (Lower Case)
CCT-USER-ALPHA-5
Element: Cw User Alpha		Alpha 20 (Lower Case)
CCT-USER-ALPHA-6
Element: Cw User Alpha		Alpha 20 (Lower Case)
CCT-USER-ALPHA-7
Element: Cw User Alpha		Alpha 20 (Lower Case)
CCT-USER-ALPHA-8
Element: Cw User Alpha		Alpha 20 (Lower Case)
CCT-USER-ALPHA-9
Element: Cw User Alpha		Alpha 20 (Lower Case)
CCT-USER-ALPHA-10
Element: Cw User Alpha		Alpha 20 (Lower Case)
CCT-USER-ALPHA-11
Element: Cw User Alpha		Alpha 20 (Lower Case)
CCT-USER-ALPHA-12
Element: Cw User Alpha		Alpha 20 (Lower Case)
CCT-USER-NUM-1
Element: Cw Amount		Signed 18.6
CCT-USER-NUM-2
Element: Cw Amount		Signed 18.6
CCT-USER-NUM-3
Element: Cw Amount		Signed 18.6
CCT-USER-NUM-4
Element: Cw Amount		Signed 18.6
CCT-USER-NUM-5
Element: Cw Amount		Signed 18.6
CCT-USER-NUM-6
Element: Cw Amount		Signed 18.6
CCT-USER-NUM-7
Element: Cw Amount		Signed 18.6
CCT-USER-NUM-8
Element: Cw Amount		Signed 18.6
CCT-USER-NUM-9
Element: Cw Amount		Signed 18.6
CCT-USER-NUM-10
Element: Cw Amount		Signed 18.6
CCT-USER-NUM-11
Element: Cw Amount		Signed 18.6
CCT-USER-NUM-12
Element: Cw Amount		Signed 18.6
CCT-USER-DATE-1
Element: Cw Date		Numeric 8 (yyyymmdd)
CCT-USER-DATE-2
Element: Cw Date		Numeric 8 (yyyymmdd)
CCT-USER-DATE-3
Element: Cw Date		Numeric 8 (yyyymmdd)
CCT-USER-DATE-4
Element: Cw Date		Numeric 8 (yyyymmdd)
CCT-USER-DATE-5
Element: Cw Date		Numeric 8 (yyyymmdd)
CCT-USER-DATE-6
Element: Cw Date		Numeric 8 (yyyymmdd)
CCT-USER-DATE-7
Element: Cw Date		Numeric 8 (yyyymmdd)
CCT-USER-DATE-8
Element: Cw Date		Numeric 8 (yyyymmdd)
CCT-USER-DATE-9
Element: Cw Date		Numeric 8 (yyyymmdd)
CCT-USER-DATE-10
Element: Cw Date		Numeric 8 (yyyymmdd)
CCT-USER-DATE-11
Element: Cw Date		Numeric 8 (yyyymmdd)
CCT-USER-DATE-12
Element: Cw Date		Numeric 8 (yyyymmdd)
CCT-CLOSE-DATE
Element: Close Date		Numeric 8 (yyyymmdd)
Contains the Last Run Date of the CW197 program based on the system date. CW197 will only update the contract YTD Wage Amounts and/or units for PRTIME records with a PRT-PER-END-DATE > Close Date.
CCT-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
CCT-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
CCT-USER-ID
Element: User		Alpha 10 (Lower Case)
CCT-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
CCT-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
CCT-CREATE-USER-ID
Element: User		Alpha 10 (Lower Case)
CCT-FTE
Element: Cw Fte		Signed 11.6
Contains the PAEMPPOS FTE.
CCT-DAY-PER-PY-PRD
Element: Day Per Py Prd		Signed 18.6
CCT-ROLL-OVER
Element: Roll Over Flg		Numeric 1

1 = No
2 = Yes
CCT-UNITS-REMAIN
Element: Units Remain		Signed 18.6
CCT-UNIT-TYPE
Element: Cw Unit Type		Numeric 1

1 = Hours
2 = Days
CCT-WORK-SCHD-CHG
Element: Work Schd Chg		Numeric 1

1 = No
2 = Yes
CCT-PAY-CYCLES
Element: Cw Pay Cycles		Numeric 3
CCT-BEN-ELIG-FLAG
Element: Ben Elig Flag		Numeric 1

1 = No
2 = Yes
CCT-PAY-CHG-IND
Element: Pay Chg Ind		Numeric 1

1 = No
2 = Yes
CCT-STOP-DT-OVR
Element: Override Flg		Numeric 1

1 = No
2 = Yes
CCT-PAY-CYC-OVR
Element: Override Flg		Numeric 1

1 = No
2 = Yes
CCT-TOT-CONT-AMT
Element: Tot Cont Amt		Signed 18.6
CCT-TOT-CONT-UNIT
Element: Tot Cont Unit		Signed 18.6
CCT-REMAIN-CYCLES
Element: Cw Pay Cycles		Numeric 3


CWCONTRACT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CCTSET1 COMPANY
EMPLOYEE
CONTRACT-YEAR*
POSITION
CONT-SEQ-NBR*
...
BN150 BN305
HR04.2 HR04.3
HR04.7 HR04.8
HR11.1 HR11.2
HR11.4 HR28.1
HR511 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
CCTSET2 COMPANY
EMPLOYEE
CONTRACT-YEAR*
POSITION
EFFECT-DATE*
CONT-SEQ-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
CCTSET3 COMPANY
CONTRACT-YEAR*
EMPLOYEE
POSITION
CONT-SEQ-NBR*
CCTSET4 COMPANY
EMPLOYEE
CONTRACT-YEAR*
POSITION
CONT-SEQ-NBR*
Subset
Where(CLOSE-DATE !=Zeroes)
CCTSET5 COMPANY
EMPLOYEE
CONTRACT-YEAR*
POSITION
CONT-SEQ-NBR*
Subset
Where(CONT-STATUS =9)
CCTSET6 COMPANY
CONTRACT-YEAR
WORK-SCHED
EMPLOYEE
POSITION
CONT-SEQ-NBR
...
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
CCTSET7 COMPANY
EMPLOYEE
POSITION
EFFECT-DATE
CONTRACT-YEAR
CONT-SEQ-NBR
...
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 ZH510
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
CCTSET8 COMPANY
EMPLOYEE
CONTRACT-YEAR
GROUP
POSITION
CONT-SEQ-NBR
Subset
Where(CONT-STATUS =Zeroes)
...
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 ZH510
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502


CWCONTRACT FILE RELATIONS


ONE TO ONE RELATIONS

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


CWCONTRACT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Assignment CWASSIGN
CCT-COMPANY->CWA-COMPANY
CCT-CONTRACT-YEAR->CWA-CONTRACT-YEAR
CCT-EMPLOYEE->CWA-EMPLOYEE
  CWA-POSITION
  CWA-ASG-EFFECT-DTE
  CWA-PCD-SEQ-NBR
Cont Dist CWDISTRIB
CCT-COMPANY->CWD-COMPANY
CCT-EMPLOYEE->CWD-EMPLOYEE
CCT-CONTRACT-YEAR->CWD-CONTRACT-YEAR
CCT-POSITION->CWD-POSITION
CCT-CONT-SEQ-NBR->CWD-CONT-SEQ-NBR
  CWD-PAY-CODE
  CWD-GL-EFFECT-DATE
  CWD-GL-SEQ-NBR
Contract Rule CWCONTRULE
CCT-COMPANY->CWC-COMPANY
CCT-GROUP->CWC-CONTRACT-GROUP
  CWC-EFFECT-DATE
Emp Position PAEMPPOS
CCT-COMPANY->PEP-COMPANY
CCT-EMPLOYEE->PEP-EMPLOYEE
CCT-POSITION->PEP-POSITION
CCT-EFFECT-DATE->PEP-EFFECT-DATE
  PEP-POS-LEVEL
Emp Trans CWEMPTRANS Delete Cascades
CCT-COMPANY->CCE-COMPANY
CCT-EMPLOYEE->CCE-EMPLOYEE
CCT-CONTRACT-YEAR->CCE-CONTRACT-YEAR
CCT-POSITION->CCE-POSITION
CCT-CONT-SEQ-NBR->CCE-CONT-SEQ-NBR
  CCE-TRANS-SEQ-NBR
Pay Code PRPAYCODE
CCT-COMPANY->PCD-COMPANY
CCT-PAY-CODE->PCD-PAY-CODE
  PCD-PROCESS-LEVEL
  PCD-JOB-CODE

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

Home
Contact Us



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