HRWRKDTL

Contains the detail for a work schedule or the K12 teacher contract work schedule. For a K12 Teacher Work Schedule, each Date record is associated with a PCODE that determines whether the day is counted as a paid day, non paid day, or weekend day. Paid Days are used to determine the number of work days used in calculating the employee contract assignment payouts. When a Work Schedule detail record is created, the PCODE values will default to the dates for the Contract Rule defined for the company.
UPDATED BY
HR00.1 HR01.1 HR04.2 HR04.3 HR04.7 HR04.8
HR21.1 HR221 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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WSD-COMPANY
Element: Company Hr
Numeric 4
Identifies the HR Company.
HR21.1
WSD-WORK-SCHED
Element: Code
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 workdays to payout teacher contracts.
HR21.1
WSD-EFFECT-DATE
Element: 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 the K12 Teach Work Schedules.
HR21.1
WSD-WORK-PERIOD
Element: Work Period
Numeric 2
Work Period associated with a detail HR21.1 Work Schedule record. Not valid for a K12 Teacher Work Schedule.
HR21.1
WSD-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the Work Schedule description.
HR21.1
WSD-WORK-DAYS
Element: Ws Days
Signed 6.4
Number of work days in the work period for the HR21.2 record. Not valid for a K12 Teacher Work Schedule.
HR21.1
WSD-NON-WORK-DAYS
Element: Ws Days
Signed 6.4
Number of non working days in a work period associated with a HR21.2 record. Not valid for a K12 Teacher Work Schedule.
HR21.1
WSD-OTHER-DAYS
Element: Ws Days
Signed 6.4
Number of Other Days in a work period associated with a HR21.2 record. Not valide for a K12 Teacher Work Schedule.
HR21.1
WSD-PRD-TOT-DAYS
Element: Prd Tot Days
Derived
Number of total work days in a work period associated with a HR21.1 record. Not valid for a K12 Teacher Work Schedule.
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)
Contains the User Id of the person that last changed this record.
HR21.1
WSD-CONTRACT-YEAR
Element: Cw Contract Yr
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.
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. This field is only valid for K12.
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)
This is the date that this record was initally added to the table.
WSD-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was initially added to the system.
WSD-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the User Id of the person that initally added this record.


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 11:15:02 2016

Home
Contact Us



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