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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#WSC-COMPANY PKCOMPANY | Numeric 4 | — | HR21.1 |
#WSC-WORK-SCHED PKWORK_SCHED | Alpha 10 | Work 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 PKEFFECT_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-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the Work Schedule description. | HR21.1 |
#WSC-TOT-DAYSTOT_DAYS | Signed 10.4 | — | HR21.1 |
#WSC-DATE-STAMPDATE_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-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | HR21.1 |
#WSC-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | HR21.1 |
#WSC-CONTRACT-YEAR PKCONTRACT_YEAR | Numeric 4 | Identifies 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-STATUSSTATUS | Numeric 1 | performed). 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).
| — |
#WSC-START-DATESTART_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-DATEEND_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-DTWORK_START_DT | Numeric 8 (yyyymmdd) | — | — |
#WSC-WORK-END-DATEWORK_END_DATE | Numeric 8 (yyyymmdd) | — | — |
#WSC-TOT-HRS-PR-DAYTOT_HRS_PR_DAY | Signed 18.6 | This is the standard hours per day on the Calendar to calculate the daily rate from hourly rate. | — |
#WSC-ANNUAL-UNITSANNUAL_UNITS | Signed 18.6 | This 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-TYPEUNIT_TYPE | Numeric 1 | This categorizes the value in the Annual Units Field. This could be either Hours or Day Unit Type.
| — |
#WSC-WORK-SCHD-CHGWORK_SCHD_CHG | Numeric 1 | —
| — |
#WSC-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | — | — |
#WSC-CREATE-TIMECREATE_TIME | Numeric 6 (hhmmss) | — | — |
#WSC-CREATE-USERCREATE_USER | Alpha 10 (Lower Case) | — | — |
#WSC-TAX-FREQ-OVERTAX_FREQ_OVER | Numeric 3 | —
| — |
#WSC-PAY-PLAN SET5PAY_PLAN | Alpha 4 | — | — |
#WSC-PAY-CYCLESPAY_CYCLES | Numeric 3 | — | — |
#WSC-FIRST-PAY-DTFIRST_PAY_DT | Numeric 8 (yyyymmdd) | — | — |
#WSC-WORK-CYCLESWORK_CYCLES | Numeric 3 | — | — |
#WSC-WRK-SCHD-PROGMWRK_SCHD_PROGM | Alpha 2 | — | — |
Indexes (7)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
WSCSET1 |
| Primary | BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR00.1 +22 more (list truncated in source) | |
WSCSET2 |
| Subset | Where (CONTRACT-YEAR = Zeroes) | BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source) |
WSCSET3 |
| Subset | Where (CONTRACT-YEAR = Zeroes) | — |
WSCSET4 |
| Subset | Where (CONTRACT-YEAR != Zeroes) | BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source) |
WSCSET5 |
| Subset | Where (CONTRACT-YEAR != Zeroes) | — |
WSCSET6 |
| Subset | Where (CONTRACT-YEAR != Zeroes) | — |
WSCSET7 |
| Subset | Where (STATUS = 9) | — |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM | Required |
|
One to many (10) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Assignment | CWASSIGN | Valid When (WSC-CONTRACT-YEAR != Zeroes) |
| |||||||||||||||||||||||||
| Cmchange | CMCHANGE | Valid When (WSC-CONTRACT-YEAR != Zeroes) |
| |||||||||||||||||||||||||
| Cmcont Rule | CMCONTRULE |
| ||||||||||||||||||||||||||
| Contract Rule | CWCONTRULE |
| ||||||||||||||||||||||||||
| Cwchange | CWCHANGE | Valid When (WSC-CONTRACT-YEAR != Zeroes) |
| |||||||||||||||||||||||||
| Emp Cmcontract | CMCONTRACT | Valid When (WSC-CONTRACT-YEAR != Zeroes) |
| |||||||||||||||||||||||||
| Emp Contract | CWCONTRACT | Valid When (WSC-CONTRACT-YEAR != Zeroes) |
| |||||||||||||||||||||||||
| Employee | PATHFIND | Valid When (WSC-CONTRACT-YEAR = Zeroes) |
| |||||||||||||||||||||||||
| Pay Plan | PROVERTIME |
| ||||||||||||||||||||||||||
| Work Dtl | HRWRKDTL |
|
Programs
Updated by (3)
Referenced by (89)
- BN305 Highly Compensated Employees
- HAP3.1 Applicant Option 4 Selection Invoke
- HCRE.1 Action Reason Code Selects
- HEP4.1 Employee Option 4 Selection Invoke
- HPOS.1 Position Selection Invoke
- HPQC.1 Prqcentgrp Select Invoke
- HPRS.1 Process Level Select Invoke
- HR11.1 Employee
- HR11.2 Compensation Analysis
- HR11.4 Employee Assignment Inquiry
- HR15.1 User Fields
- HR155 Employee Group Update
- HR156 Employee Group Company Update
- HR170 Human Resource Writer Report Request
- HR221 Work Schedule Report
- HR28.1 Employee Ethnicity
- HR51.2 Employee Interface Data
- HR51.8 WFM Interface Data
- HR511 Employee Conversion
- HR515 User Field Conversion
- HR52.2 Talent Management Interface Data
- HR54.1 Employee History Correction
- HR55.2 Employee Groups By Employees
- HR70.1 Human Resource Writer Inquiry
- HRS1.1 Select Control
- HRSC.1 Select Control
- HWSC.1 Work Schedule Selection Invoke
- LP100 Employee Absence Plan Update
- LP101 Mass Absence Plan Add
- LT101 HRM Receiver Update
- LT11.5 HRM User Field Interface
- LT111 HRM Receiver Update
- LT13.5 HRM User Field Interface History
- PA02.1 Position
- PA100 Action Update
- PA102 Position Update
- PA103 Mass Position Changes
- PA113 Retroactive History Update
- PA115 Employee Purge
- PA13.1 Multiple Positions and Jobs
- PA13.2 Multiple Position and Job History
- PA16.1 Company Property
- PA20.1 Education
- PA202 Position Listing
- PA21.1 Competencies
- PA22.1 Certifications
- PA24.1 Relocation
- PA242 Requisition Listing
- PA27.1 Contracts
- PA272 Budget and Assigned Resource Listing
- PA28.1 Applicant Ethnicity
- PA31.1 Applicant
- PA31.3 LTM Applicant Data
- PA34.1 Applicant Education
- PA35.1 Applicant Competencies
- PA36.1 Applicant Certification
- PA38.1 Applicant Relocation
- PA42.1 Requisition
- PA42.3 Requisition Approval Override
- PA502 Position Conversion
- PA513 Position and Job Conversion
- PA52.1 Individual Action
- PA52.3 Mass Action
- PA52.4 Hire an Applicant
- PA52.5 Position and Job Action
- PA520 Employee and Applicant Code Conversion
- PA53.1 Personnel Action Workflow Override
- PA531 Applicant Conversion
- PA532 Code, Requisitions Exports
- PA535 e-Recruiting Requisition Conversion
- PA54.1 Personnel Action History Correction
- PA66.3 Employee Action Detail
- PR110 Step And Grade Audit
- PR113 United States Tax Deduction Update
- PR12.6 Employee Automatic Deposit
- PR120 Mass Pay Update
- PR13.1 Employee United States Taxes
- PR13.5 Employee Canada Taxes
- PR13.6 Employee Canada Taxes
- PR13.8 U.S. Tax Deduction Errors
- PR13.9 Employee Additional Tax Details
- PR30.2 Employee Automatic Time Record
- PR512 Employee ACH Distribution Interface
- TR21.1 Employee Training History
- TR22.1 Session Completion
- TR26.1 Employee Training Competency Maintenance
- TR500 Training Conversion
- ZH156 Employee Group Company Update
- ZH510 Update PCP from ZPENDPCP