HRWRKDTL

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

REFERENCED BY
HR221 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


UPDATED BY
HR21.1 HR00.1 HR01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WSD-COMPANY
Element: Company Hr
Numeric 4
HR21.1
WSD-WORK-SCHED
Element: Code
Alpha 10
Code that is valid for the specified record type.
HR21.1
WSD-EFFECT-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
HR21.1
WSD-WORK-PERIOD
Element: Work Period
Numeric 2
HR21.1
WSD-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
HR21.1
WSD-WORK-DAYS
Element: Ws Days
Signed 6.4
HR21.1
WSD-NON-WORK-DAYS
Element: Ws Days
Signed 6.4
HR21.1
WSD-OTHER-DAYS
Element: Ws Days
Signed 6.4
HR21.1
WSD-PRD-TOT-DAYS
Element: Prd Tot Days
Derived
WSD-DATE-STAMP
Element: 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
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HR21.1
WSD-USER-ID
Element: User
Alpha 10 (Lower Case)
HR21.1
WSD-CONTRACT-YEAR
Element: Cw Contract Yr
Numeric 4
Identifies the Contract Year. A Contract is only allowed to be defined if a Contract Rule exists for that specific Contract Year.
WSD-DATE
Element: Cw 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
Element: Day Code
Alpha 10
User 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
Element: Cw Remain Days
Signed 18.6
This 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
Element: Cw Work Days
Signed 18.6
This 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
Element: Date Stamp
Numeric 8 (yyyymmdd)
WSD-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
WSD-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
WSD-PAY-CODE
Element: Pay Code
Alpha 4


HRWRKDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WSDSET1 COMPANY
WORK-SCHED
CONTRACT-YEAR
EFFECT-DATE
WORK-PERIOD
DATE
HR00.1 HR01.1
WSDSET2 COMPANY
WORK-SCHED
EFFECT-DATE*
CONTRACT-YEAR*
WORK-PERIOD
DATE
Subset
Where(CONTRACT-YEAR =Zeroes)
HR21.1 HR221
WSDSET3 COMPANY
WORK-SCHED
CONTRACT-YEAR*
WORK-PERIOD*
DATE
Subset
Where(CONTRACT-YEAR =Zeroes)
WSDSET4 COMPANY
WORK-SCHED
CONTRACT-YEAR*
EFFECT-DATE*
WORK-PERIOD
DATE
Subset
Where(CONTRACT-YEAR !=Zeroes)
...
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
WSDSET5 COMPANY
WORK-SCHED
CONTRACT-YEAR
EFFECT-DATE
WORK-PERIOD
DATE
Subset
Where(CONTRACT-YEAR !=Zeroes)
WSDSET6 COMPANY
CONTRACT-YEAR*
WORK-SCHED
EFFECT-DATE*
WORK-PERIOD
DATE
Subset
Where(CONTRACT-YEAR !=Zeroes)


HRWRKDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
WSD-COMPANY->PRS-COMPANY (PRSSET1)
Spaces->PRS-PROCESS-LEVEL
Day Code PCODES Required
"DC"->PCO-TYPE
WSD-DAY-CODE->PCO-CODE


HRWRKDTL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Contract Rule CWCONTRULE
WSD-COMPANY->CWC-COMPANY
  CWC-CONTRACT-GROUP
  CWC-EFFECT-DATE


File created: Thu Jun 09 02:16:24 2016

Home
Contact Us



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