HRWRKSCHD – Contains the parent record for a work schedule or is the parent record for a K12 teacher contract work schedule.

System
Human Resources (HR)
Prefix
WSC
Primary key
COMPANY, WORK-SCHED, CONTRACT-YEAR, EFFECT-DATE
Fields
27
Updated by
3 programs
Referenced by
89 programs

HRWRKSCHD is the Contains the parent record for a work schedule or is the parent record for a K12 teacher contract work schedule. table in Lawson Human Resources (prefix WSC). It is indexed by COMPANY, WORK-SCHED, CONTRACT-YEAR, EFFECT-DATE (WSCSET1); alternate indexes: WSCSET2, WSCSET3, WSCSET4, WSCSET5, WSCSET6 and WSCSET7. It is related 1:1 to PRSYSTEM and 1:M to CWASSIGN, CMCHANGE, CMCONTRULE, CWCONTRULE, CWCHANGE, CMCONTRACT, CWCONTRACT, PATHFIND and 2 more. It is updated by HR00.1, HR01.1 and HR21.1 and referenced by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 81 more. The table has 27 fields, 7 indexes and 11 documented relations.

About HRWRKSCHD

Contains the parent record for a work schedule or is the parent record for a K12 teacher contract work schedule. If effective date is not zeroes, the record is a normal work schedule. If fiscal year is not zeroes, the record is a K12 teacher contract work schedule. The K12 teacher contract work schedule determines the days worked to determine how a teacher is paid.

Fields (27)

Column = COBOL field name without the WSC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
WSC-COMPANY PK
COMPANY		Numeric 4—HR21.1
WSC-WORK-SCHED PK
WORK_SCHED		Alpha 10Work Schedules are assigned to an employee (HR11.1). A non K12 user defines Work Schedules on the HR21.1 program. A K12 user defines Work Schedules on the CW01.1 program and assign this value to a position to default to the employee contract assignment record. K12 Work Schedules are used to determine the number of work days to payout teacher contracts.HR21.1
WSC-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created. This date is only populated for Work Schedules defined on the HR21.1 program that does not include K12 Teacher Work Schedules.HR21.1
WSC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the Work Schedule description.HR21.1
WSC-TOT-DAYS
TOT_DAYS		Signed 10.4—HR21.1
WSC-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HR21.1
WSC-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR21.1
WSC-USER-ID
USER_ID		Alpha 10 (Lower Case)—HR21.1
WSC-CONTRACT-YEAR PK
CONTRACT_YEAR		Numeric 4Identifies the Contract Year. A K12 Teacher Work Schedule is only allowed to be defined if a Contract Rule exists for that specific Contract Year.—
WSC-STATUS
STATUS		Numeric 1performed). 2=Generated (when Calendar Detail records are added). 3=Finalized Balance (when calendar header is in balance with the detail records paid days. "Finalized Balance" screen function is performed). 4=Unfinalized (when "Unfinalized" screen function is performed).
  • 1 Created (when "Add" screen function is
  • 0 Open
  • 9 Closed
—
WSC-START-DATE
START_DATE		Numeric 8 (yyyymmdd)This pertains to the Calendar End Date that will default as the Contract End Date on the Contract Record.—
WSC-END-DATE
END_DATE		Numeric 8 (yyyymmdd)This pertains to the Calendar End Date that will default as the Contract End Date on the Contract Record.—
WSC-WORK-START-DT
WORK_START_DT		Numeric 8 (yyyymmdd)——
WSC-WORK-END-DATE
WORK_END_DATE		Numeric 8 (yyyymmdd)——
WSC-TOT-HRS-PR-DAY
TOT_HRS_PR_DAY		Signed 18.6This is the standard hours per day on the Calendar to calculate the daily rate from hourly rate.—
WSC-ANNUAL-UNITS
ANNUAL_UNITS		Signed 18.6This pertains to the annual Worked Hours or Days by an employee. Work Schedule Detail uses this field as the basis in calculating Remaining Days Worked.—
WSC-UNIT-TYPE
UNIT_TYPE		Numeric 1This categorizes the value in the Annual Units Field. This could be either Hours or Day Unit Type.
  • 1 Hours
  • 2 Days
—
WSC-WORK-SCHD-CHG
WORK_SCHD_CHG		Numeric 1—
  • 1 No
  • 2 Yes
—
WSC-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
WSC-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
WSC-CREATE-USER
CREATE_USER		Alpha 10 (Lower Case)——
WSC-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
—
WSC-PAY-PLAN
PAY_PLAN		Alpha 4——
WSC-PAY-CYCLES
PAY_CYCLES		Numeric 3——
WSC-FIRST-PAY-DT
FIRST_PAY_DT		Numeric 8 (yyyymmdd)——
WSC-WORK-CYCLES
WORK_CYCLES		Numeric 3——
WSC-WRK-SCHD-PROGM
WRK_SCHD_PROGM		Alpha 2——

Indexes (7)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
WSCSET1COMPANY, WORK-SCHED, CONTRACT-YEAR*, EFFECT-DATE*PrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR00.1 +22 more (list truncated in source)
WSCSET2COMPANY, WORK-SCHED, EFFECT-DATE*, CONTRACT-YEAR*SubsetWhere (CONTRACT-YEAR = Zeroes)BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
WSCSET3COMPANY, WORK-SCHED, EFFECT-DATE, CONTRACT-YEARSubsetWhere (CONTRACT-YEAR = Zeroes)—
WSCSET4COMPANY, WORK-SCHED, CONTRACT-YEAR*, EFFECT-DATE*SubsetWhere (CONTRACT-YEAR != Zeroes)BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
WSCSET5COMPANY, WORK-SCHED, CONTRACT-YEAR, EFFECT-DATE, PAY-PLANSubsetWhere (CONTRACT-YEAR != Zeroes)—
WSCSET6COMPANY, CONTRACT-YEAR*, WORK-SCHED, EFFECT-DATE*SubsetWhere (CONTRACT-YEAR != Zeroes)—
WSCSET7COMPANY, WORK-SCHED, CONTRACT-YEAR*, EFFECT-DATE*SubsetWhere (STATUS = 9)—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredWSC-COMPANY → PRS-COMPANY (PRSSET1), Spaces → PRS-PROCESS-LEVEL

One to many (10) — child tables

RelationTableRulesConditionField map
AssignmentCWASSIGNValid When (WSC-CONTRACT-YEAR != Zeroes)WSC-COMPANY → CWA-COMPANY, WSC-CONTRACT-YEAR → CWA-CONTRACT-YEAR, → CWA-EMPLOYEE, → CWA-POSITION, → CWA-ASG-EFFECT-DTE, → CWA-PCD-SEQ-NBR
CmchangeCMCHANGEValid When (WSC-CONTRACT-YEAR != Zeroes)WSC-COMPANY → CHG-COMPANY, Zeroes → CHG-EMPLOYEE, Zeroes → CHG-POS-LEVEL, WSC-WORK-SCHED → CHG-WORK-SCHED, → CHG-CONTRACT-YEAR, → CHG-CONTRACT-NBR, → CHG-CHANGE-TYPE, → CHG-EFFECT-DATE
Cmcont RuleCMCONTRULEWSC-COMPANY → CRU-COMPANY, → CRU-CONTRACT-GROUP, → CRU-EFFECT-DATE
Contract RuleCWCONTRULEWSC-COMPANY → CWC-COMPANY, → CWC-CONTRACT-GROUP, → CWC-EFFECT-DATE
CwchangeCWCHANGEValid When (WSC-CONTRACT-YEAR != Zeroes)WSC-COMPANY → CCH-COMPANY, Zeroes → CCH-EMPLOYEE, Spaces → CCH-POSITION, WSC-WORK-SCHED → CCH-WORK-SCHED, → CCH-EFFECT-DATE, → CCH-CHANGE-TYPE
Emp CmcontractCMCONTRACTValid When (WSC-CONTRACT-YEAR != Zeroes)WSC-COMPANY → CNR-COMPANY, WSC-CONTRACT-YEAR → CNR-CONTRACT-YEAR, WSC-WORK-SCHED → CNR-WORK-SCHED, → CNR-EMPLOYEE, → CNR-CONTRACT-NBR
Emp ContractCWCONTRACTValid When (WSC-CONTRACT-YEAR != Zeroes)WSC-COMPANY → CCT-COMPANY, WSC-CONTRACT-YEAR → CCT-CONTRACT-YEAR, WSC-WORK-SCHED → CCT-WORK-SCHED, → CCT-EMPLOYEE, → CCT-POSITION, → CCT-CONT-SEQ-NBR
EmployeePATHFINDValid When (WSC-CONTRACT-YEAR = Zeroes)WSC-COMPANY → PTF-COMPANY, 293 → PTF-FLD-NBR, WSC-WORK-SCHED → PTF-FLD-VALUE, → PTF-EMPLOYEE, → PTF-POS-LEVEL
Pay PlanPROVERTIMEWSC-COMPANY → PRO-COMPANY, WSC-PAY-PLAN → PRO-PLAN-CODE, → PRO-EFFECT-DATE
Work DtlHRWRKDTLWSC-COMPANY → WSD-COMPANY, WSC-WORK-SCHED → WSD-WORK-SCHED, WSC-CONTRACT-YEAR → WSD-CONTRACT-YEAR, WSC-EFFECT-DATE → WSD-EFFECT-DATE, → WSD-WORK-PERIOD, → WSD-DATE

Programs

Updated by (3)

Referenced by (89)