CWCONTRACT – Contracts are used in K12 school districts to manage and track employee employment records and drive an employee's pay…

System
CW (CW)
Prefix
CCT
Primary key
COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, CONT-SEQ-NBR
Fields
95
Updated by
48 programs
Referenced by
135 programs

CWCONTRACT is the Contracts are used in K12 school districts to manage and track employee employment records and drive an employee's pay… table in Lawson CW (prefix CCT). It is indexed by COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, CONT-SEQ-NBR (CCTSET1); alternate indexes: CCTSET2, CCTSET3, CCTSET4, CCTSET5, CCTSET6, CCTSET7 and CCTSET8. It is related 1:1 to PRSYSTEM, PCODES, EMPLOYEE, PAEMPLOYEE, PRSAGDTL and HRWRKSCHD and 1:M to CWASSIGN, CWDISTRIB, CWCONTRULE, PAEMPPOS, CWEMPTRANS and PRPAYCODE. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 40 more and referenced by BN150, EXI2.1, EXI4.1, HR04.2, HR04.3, HR04.7, HR04.8, HR80.1 and 127 more. The table has 95 fields, 8 indexes and 13 documented relations.

About 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.

Fields (95)

Column = COBOL field name without the CCT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CCT-COMPANY PK
COMPANY		Numeric 4Identifies the HR company.—
#CCT-EMPLOYEE PK
EMPLOYEE		Numeric 9——
#CCT-CONTRACT-YEAR PK
CONTRACT_YEAR		Numeric 4Contains the Contract Year. A Contract is only allowed to be defined if a Contract Rule exists for that specific Contract Year.—
#CCT-POSITION PK
POSITION		Alpha 12The employee's position is the contract assignment. There is a 1 to 1 relationship from CWCONTRACT to PAEMPPOS.—
#CCT-CONT-SEQ-NBR PK
CONT_SEQ_NBR		Numeric 12——
#CCT-WORK-SCHED SET6
WORK_SCHED		Alpha 10The 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 SET2 SET7
EFFECT_DATE		Numeric 8 (yyyymmdd)Effective Date of PAEMPPOS position level record.—
#CCT-END-DATE
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
FULL_UNITS		Signed 18.6——
#CCT-FULL-AMT
FULL_AMT		Signed 18.6——
#CCT-PRORATED-UNITS
PRORATED_UNITS		Signed 18.6——
#CCT-PRORATED-AMT
PRORATED_AMT		Signed 18.6——
#CCT-SCHEDULE
SCHEDULE		Alpha 9PAEMPPOS 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
PAY_GRADE		Alpha 3PAEMPPOS 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
PAY_STEP		Numeric 2PAEMPPOS 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
PAY_RATE		Signed 13.4PAEMPPOS Pay Rate will default to contract and be displayed on the contract header. User may override this field value.—
#CCT-RIGHT
RIGHT		Alpha 10A 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 SET8
GROUP		Alpha 15A contract group is used for grouping contract records together for reporting purposes.—
#CCT-PAY-CODE
PAY_CODE		Alpha 4——
#CCT-PCD-SEQ-NBR
PCD_SEQ_NBR		Numeric 8——
#CCT-CHECK-GRP
CHECK_GRP		Alpha 1——
#CCT-PROCESS-GRP
PROCESS_GRP		Alpha 1——
#CCT-PAY-CYCLE
PAY_CYCLE		Alpha 1 Occurs 9 Times ×9X—
#CCT-TAX-FREQ-OVER
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
DATE_OVER_FLG		Numeric 1—
  • 1 No
  • 2 Yes
—
#CCT-PAY-PER-AMT
PAY_PER_AMT		Signed 18.6——
#CCT-YTD-PAID-WAGES
YTD_PAID_WAGES		Signed 18.6——
#CCT-YTD-DOCKED-WGS
YTD_DOCKED_WGS		Signed 18.6——
#CCT-WAGE-BALANCE
WAGE_BALANCE		Signed 18.6——
#CCT-YTD-PAID-UNITS
YTD_PAID_UNITS		Signed 18.6——
#CCT-YTD-DOCKED-UTS
YTD_DOCKED_UTS		Signed 18.6——
#CCT-UNITS-BALANCE
UNITS_BALANCE		Signed 18.6——
#CCT-UNITS-WORKED
UNITS_WORKED		Signed 18.6——
#CCT-RESERVE-BAL
RESERVE_BAL		Signed 18.6——
#CCT-RESERVE-UNITS
RESERVE_UNITS		Signed 18.6——
#CCT-CONT-PAYOUT
CONT_PAYOUT		Numeric 1—
  • 1 No
  • 2 Yes; Payout in Full
  • 3 Payout Reserve Only
—
#CCT-CONT-STATUS
CONT_STATUS		Numeric 1—
  • 0 Open
  • 3 Void
  • 9 Closed
—
#CCT-CONT-CLOSE-DT
CONT_CLOSE_DT		Numeric 8 (yyyymmdd)——
#CCT-USER-ALPHA-1
USER_ALPHA_1		Alpha 20 (Lower Case)——
#CCT-USER-ALPHA-2
USER_ALPHA_2		Alpha 20 (Lower Case)——
#CCT-USER-ALPHA-3
USER_ALPHA_3		Alpha 20 (Lower Case)——
#CCT-USER-ALPHA-4
USER_ALPHA_4		Alpha 20 (Lower Case)——
#CCT-USER-ALPHA-5
USER_ALPHA_5		Alpha 20 (Lower Case)——
#CCT-USER-ALPHA-6
USER_ALPHA_6		Alpha 20 (Lower Case)——
#CCT-USER-ALPHA-7
USER_ALPHA_7		Alpha 20 (Lower Case)——
#CCT-USER-ALPHA-8
USER_ALPHA_8		Alpha 20 (Lower Case)——
#CCT-USER-ALPHA-9
USER_ALPHA_9		Alpha 20 (Lower Case)——
#CCT-USER-ALPHA-10
USER_ALPHA_10		Alpha 20 (Lower Case)——
#CCT-USER-ALPHA-11
USER_ALPHA_11		Alpha 20 (Lower Case)——
#CCT-USER-ALPHA-12
USER_ALPHA_12		Alpha 20 (Lower Case)——
#CCT-USER-NUM-1
USER_NUM_1		Signed 18.6——
#CCT-USER-NUM-2
USER_NUM_2		Signed 18.6——
#CCT-USER-NUM-3
USER_NUM_3		Signed 18.6——
#CCT-USER-NUM-4
USER_NUM_4		Signed 18.6——
#CCT-USER-NUM-5
USER_NUM_5		Signed 18.6——
#CCT-USER-NUM-6
USER_NUM_6		Signed 18.6——
#CCT-USER-NUM-7
USER_NUM_7		Signed 18.6——
#CCT-USER-NUM-8
USER_NUM_8		Signed 18.6——
#CCT-USER-NUM-9
USER_NUM_9		Signed 18.6——
#CCT-USER-NUM-10
USER_NUM_10		Signed 18.6——
#CCT-USER-NUM-11
USER_NUM_11		Signed 18.6——
#CCT-USER-NUM-12
USER_NUM_12		Signed 18.6——
#CCT-USER-DATE-1
USER_DATE_1		Numeric 8 (yyyymmdd)——
#CCT-USER-DATE-2
USER_DATE_2		Numeric 8 (yyyymmdd)——
#CCT-USER-DATE-3
USER_DATE_3		Numeric 8 (yyyymmdd)——
#CCT-USER-DATE-4
USER_DATE_4		Numeric 8 (yyyymmdd)——
#CCT-USER-DATE-5
USER_DATE_5		Numeric 8 (yyyymmdd)——
#CCT-USER-DATE-6
USER_DATE_6		Numeric 8 (yyyymmdd)——
#CCT-USER-DATE-7
USER_DATE_7		Numeric 8 (yyyymmdd)——
#CCT-USER-DATE-8
USER_DATE_8		Numeric 8 (yyyymmdd)——
#CCT-USER-DATE-9
USER_DATE_9		Numeric 8 (yyyymmdd)——
#CCT-USER-DATE-10
USER_DATE_10		Numeric 8 (yyyymmdd)——
#CCT-USER-DATE-11
USER_DATE_11		Numeric 8 (yyyymmdd)——
#CCT-USER-DATE-12
USER_DATE_12		Numeric 8 (yyyymmdd)——
#CCT-CLOSE-DATE
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
DATE_STAMP		Numeric 8 (yyyymmdd)——
#CCT-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——
#CCT-USER-ID
USER_ID		Alpha 10 (Lower Case)——
#CCT-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
#CCT-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
#CCT-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
#CCT-FTE
FTE		Signed 11.6Contains the PAEMPPOS FTE.—
#CCT-DAY-PER-PY-PRD
DAY_PER_PY_PRD		Signed 18.6——
#CCT-ROLL-OVER
ROLL_OVER		Numeric 1—
  • 1 No
  • 2 Yes
—
#CCT-UNITS-REMAIN
UNITS_REMAIN		Signed 18.6——
#CCT-UNIT-TYPE
UNIT_TYPE		Numeric 1—
  • 1 Hours
  • 2 Days
—
#CCT-WORK-SCHD-CHG
WORK_SCHD_CHG		Numeric 1—
  • 1 No
  • 2 Yes
—
#CCT-PAY-CYCLES
PAY_CYCLES		Numeric 3——
#CCT-BEN-ELIG-FLAG
BEN_ELIG_FLAG		Numeric 1—
  • 1 No
  • 2 Yes
—
#CCT-PAY-CHG-IND
PAY_CHG_IND		Numeric 1—
  • 1 No
  • 2 Yes
—
#CCT-STOP-DT-OVR
STOP_DT_OVR		Numeric 1—
  • 1 No
  • 2 Yes
—
#CCT-PAY-CYC-OVR
PAY_CYC_OVR		Numeric 1—
  • 1 No
  • 2 Yes
—
#CCT-TOT-CONT-AMT
TOT_CONT_AMT		Signed 18.6——
#CCT-TOT-CONT-UNIT
TOT_CONT_UNIT		Signed 18.6——
#CCT-REMAIN-CYCLES
REMAIN_CYCLES		Numeric 3——

Indexes (8)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CCTSET1
  1. COMPANY
  2. EMPLOYEE
  3. CONTRACT-YEAR ↓
  4. POSITION
  5. CONT-SEQ-NBR ↓
PrimaryBN150, BN305, HR04.2, HR04.3, HR04.7, HR04.8, HR11.1, HR11.2 +22 more (list truncated in source)
CCTSET2
  1. COMPANY
  2. EMPLOYEE
  3. CONTRACT-YEAR ↓
  4. POSITION
  5. EFFECT-DATE ↓
  6. CONT-SEQ-NBR
BN150, BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source)
CCTSET3
  1. COMPANY
  2. CONTRACT-YEAR ↓
  3. EMPLOYEE
  4. POSITION
  5. CONT-SEQ-NBR ↓
—
CCTSET4
  1. COMPANY
  2. EMPLOYEE
  3. CONTRACT-YEAR ↓
  4. POSITION
  5. CONT-SEQ-NBR ↓
SubsetWhere (CLOSE-DATE != Zeroes)—
CCTSET5
  1. COMPANY
  2. EMPLOYEE
  3. CONTRACT-YEAR ↓
  4. POSITION
  5. CONT-SEQ-NBR ↓
SubsetWhere (CONT-STATUS = 9)—
CCTSET6
  1. COMPANY
  2. CONTRACT-YEAR
  3. WORK-SCHED
  4. EMPLOYEE
  5. POSITION
  6. CONT-SEQ-NBR
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
CCTSET7
  1. COMPANY
  2. EMPLOYEE
  3. POSITION
  4. EFFECT-DATE
  5. CONTRACT-YEAR
  6. CONT-SEQ-NBR
BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
CCTSET8
  1. COMPANY
  2. EMPLOYEE
  3. CONTRACT-YEAR
  4. GROUP
  5. POSITION
  6. CONT-SEQ-NBR
SubsetWhere (CONT-STATUS = Zeroes)BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMPCODESEMPLOYEEPAEMPLOYEEPRSAGDTLHRWRKSCHDCWASSIGNCWDISTRIBCWCONTRULEPAEMPPOSCWEMPTRANSPRPAYCODECWCONTRACT

One to one (7) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
CCT-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Contract GroupPCODESRequiredWhen (CCT-GROUP != Spaces)
"CG"→PCO-TYPE
CCT-GROUP→PCO-CODE
Contract RightPCODESRequiredWhen (CCT-RIGHT != Spaces)
"RR"→PCO-TYPE
CCT-RIGHT→PCO-CODE
EmployeeEMPLOYEERequired
CCT-COMPANY→EMP-COMPANY
CCT-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequired
CCT-COMPANY→PEM-COMPANY
CCT-EMPLOYEE→PEM-EMPLOYEE
Step And GradePRSAGDTLRequired
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 ScheduleHRWRKSCHDRequired
CCT-COMPANY→WSC-COMPANY
CCT-WORK-SCHED→WSC-WORK-SCHED
CCT-CONTRACT-YEAR→WSC-CONTRACT-YEAR
Zeroes→WSC-EFFECT-DATE

One to many (6) — child tables

RelationTableRulesConditionField map
AssignmentCWASSIGN
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 DistCWDISTRIB
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 RuleCWCONTRULE
CCT-COMPANY→CWC-COMPANY
CCT-GROUP→CWC-CONTRACT-GROUP
—→CWC-EFFECT-DATE
Emp PositionPAEMPPOS
CCT-COMPANY→PEP-COMPANY
CCT-EMPLOYEE→PEP-EMPLOYEE
CCT-POSITION→PEP-POSITION
CCT-EFFECT-DATE→PEP-EFFECT-DATE
—→PEP-POS-LEVEL
Emp TransCWEMPTRANSDelete 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 CodePRPAYCODE
CCT-COMPANY→PCD-COMPANY
CCT-PAY-CODE→PCD-PAY-CODE
—→PCD-PROCESS-LEVEL
—→PCD-JOB-CODE

Programs

Updated by (48)

Referenced by (135)