HRWRKDTL – Contains the detail for a work schedule or the K12 teacher contract work schedule.

System
Human Resources (HR)
Prefix
WSD
Primary key
COMPANY, WORK-SCHED, CONTRACT-YEAR, EFFECT-DATE, WORK-PERIOD, DATE
Fields
21
Updated by
3 programs
Referenced by
96 programs

HRWRKDTL is the Contains the detail for a work schedule or the K12 teacher contract work schedule. table in Lawson Human Resources (prefix WSD). It is indexed by COMPANY, WORK-SCHED, CONTRACT-YEAR, EFFECT-DATE, WORK-PERIOD, DATE (WSDSET1); alternate indexes: WSDSET2, WSDSET3, WSDSET4, WSDSET5 and WSDSET6. It is related 1:1 to PRSYSTEM and PCODES and 1:M to CWCONTRULE. It is updated by HR00.1, HR01.1 and HR21.1 and referenced by HR04.2, HR04.3, HR04.7, HR04.8, HR221, HR80.1, HR80.2, HR80.3 and 88 more. The table has 21 fields, 6 indexes and 3 documented relations.

About HRWRKDTL

Contains the detail for a work schedule or the K12 teacher contract work schedule.

Fields (21)

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

Field / columnTypeDescription & valuesUpdated by
WSD-COMPANY PK
COMPANY		Numeric 4—HR21.1
WSD-WORK-SCHED PK
WORK_SCHED		Alpha 10Code that is valid for the specified record type.HR21.1
WSD-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.HR21.1
WSD-WORK-PERIOD PK
WORK_PERIOD		Numeric 2—HR21.1
WSD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.HR21.1
WSD-WORK-DAYS
WORK_DAYS		Signed 6.4—HR21.1
WSD-NON-WORK-DAYS
NON_WORK_DAYS		Signed 6.4—HR21.1
WSD-OTHER-DAYS
OTHER_DAYS		Signed 6.4—HR21.1
WSD-PRD-TOT-DAYS
PRD_TOT_DAYS		Derived——
WSD-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
WSD-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR21.1
WSD-USER-ID
USER_ID		Alpha 10 (Lower Case)—HR21.1
WSD-CONTRACT-YEAR PK
CONTRACT_YEAR		Numeric 4Identifies the Contract Year. A Contract is only allowed to be defined if a Contract Rule exists for that specific Contract Year.—
WSD-DATE PK
DATE		Numeric 8 (yyyymmdd)This looks at the Work Schedule Start Date and End date. First Record is equal to the specfied Start Date and the Last Record is equal to the End Date. This field is only valid for K12.—
WSD-DAY-CODE
DAY_CODE		Alpha 10User defined PCODE that describes the type of work day. This value may be a weekend, paid, or unpaid day. This field is only valid for K12.—
WSD-REMAIN-DAYS
REMAIN_DAYS		Signed 18.6This is a system calculated field. Remaining Days is equal to the Annual Units defined in the HRWRKSCHD less Contract Work Days.—
WSD-CNT-WRK-DAYS
CNT_WRK_DAYS		Signed 18.6This is a system calculated field. Work Days looks at the Dates Worked defined in HRWRKSCHD and the Day Type Codes with PN and PW status defined on the PCODE. This field is only valid for K12.—
WSD-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
WSD-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
WSD-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
WSD-PAY-CODE
PAY_CODE		Alpha 4——

Indexes (6)

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

IndexKeysFlagsConditionUsed in
WSDSET1COMPANY, WORK-SCHED, CONTRACT-YEAR, EFFECT-DATE, WORK-PERIOD, DATEPrimaryHR00.1, HR01.1
WSDSET2COMPANY, WORK-SCHED, EFFECT-DATE*, CONTRACT-YEAR*, WORK-PERIOD, DATESubsetWhere (CONTRACT-YEAR = Zeroes)HR21.1, HR221
WSDSET3COMPANY, WORK-SCHED, CONTRACT-YEAR*, WORK-PERIOD*, DATESubsetWhere (CONTRACT-YEAR = Zeroes)—
WSDSET4COMPANY, WORK-SCHED, CONTRACT-YEAR*, EFFECT-DATE*, WORK-PERIOD, DATESubsetWhere (CONTRACT-YEAR != Zeroes)HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)
WSDSET5COMPANY, WORK-SCHED, CONTRACT-YEAR, EFFECT-DATE, WORK-PERIOD, DATESubsetWhere (CONTRACT-YEAR != Zeroes)—
WSDSET6COMPANY, CONTRACT-YEAR*, WORK-SCHED, EFFECT-DATE*, WORK-PERIOD, DATESubsetWhere (CONTRACT-YEAR != Zeroes)—

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredWSD-COMPANY → PRS-COMPANY (PRSSET1), Spaces → PRS-PROCESS-LEVEL
Day CodePCODESRequired"DC" → PCO-TYPE, WSD-DAY-CODE → PCO-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
Contract RuleCWCONTRULEWSD-COMPANY → CWC-COMPANY, → CWC-CONTRACT-GROUP, → CWC-EFFECT-DATE

Programs

Updated by (3)

Referenced by (96)