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.

REFERENCED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR11.4 HR15.1 HR155
HR156 HR170 HR28.1 HR511 HR515 HR54.1
HR55.2 HR70.1 HRS1.1 HRSC.1 HWSC.1 LT101
LT11.5 LT111 LT13.5 ZH156 ZH510 LP100
LP101 PA02.1 PA100 PA102 PA103 PA113
PA115 PA13.1 PA13.2 PA16.1 PA20.1 PA202
PA21.1 PA22.1 PA24.1 PA242 PA27.1 PA272
PA28.1 PA31.1 PA31.3 PA34.1 PA35.1 PA36.1
PA38.1 PA42.1 PA42.3 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PA520 PA53.1 PA531
PA532 PA535 PA54.1 PA66.3 TR21.1 TR22.1
TR26.1 TR500 PR110 PR113 PR12.6 PR120
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 PR30.2
PR512 HR221 HR51.2 HR51.8 HR52.2


UPDATED BY
HR21.1 HR00.1 HR01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WSC-COMPANY
Element: Company Hr
Numeric 4
HR21.1
WSC-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 work days to payout teacher contracts.
HR21.1
WSC-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 K12 Teacher Work Schedules.
HR21.1
WSC-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the Work Schedule description.
HR21.1
WSC-TOT-DAYS
Element: Tot Days
Signed 10.4
HR21.1
WSC-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
WSC-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HR21.1
WSC-USER-ID
Element: User
Alpha 10 (Lower Case)
HR21.1
WSC-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.
WSC-STATUS
Element: Cw Status
Numeric 1
1=Created (when "Add" screen function is 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).
0 = Open
9 = Closed
WSC-START-DATE
Element: 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
Element: 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
Element: Start Date
Numeric 8 (yyyymmdd)
WSC-WORK-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
WSC-TOT-HRS-PR-DAY
Element: Cw 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-UNITS
Element: Cw Annual Unit
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-TYPE
Element: Cw Unit Type
Numeric 1
This 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
Element: Cw Schd Change
Numeric 1

1 = No
2 = Yes
WSC-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
WSC-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
WSC-CREATE-USER
Element: User
Alpha 10 (Lower Case)
WSC-TAX-FREQ-OVER
Element: 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
Element: Ot Plan Code
Alpha 4
WSC-PAY-CYCLES
Element: Cw Pay Cycles
Numeric 3
WSC-FIRST-PAY-DT
Element: Date
Numeric 8 (yyyymmdd)
WSC-WORK-CYCLES
Element: Cw Pay Cycles
Numeric 3
WSC-WRK-SCHD-PROGM
Element: System Cd
Alpha 2


HRWRKSCHD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WSCSET1 COMPANY
WORK-SCHED
CONTRACT-YEAR*
EFFECT-DATE*
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR00.1
HR01.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HR156 HR170
HR28.1 HR511
HR515 HR54.1
HR55.2 HR70.1
HRS1.1 HRSC.1
HWSC.1 LT101
LT11.5 LT111
LT13.5 ZH156
WSCSET2 COMPANY
WORK-SCHED
EFFECT-DATE*
CONTRACT-YEAR*
Subset
Where(CONTRACT-YEAR =Zeroes)
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR170
HR21.1 HR221
HR28.1 HR51.2
HR51.8 HR511
HR515 HR52.2
HR54.1 HR70.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
ZH510 PA02.1
WSCSET3 COMPANY
WORK-SCHED
EFFECT-DATE
CONTRACT-YEAR
Subset
Where(CONTRACT-YEAR =Zeroes)
WSCSET4 COMPANY
WORK-SCHED
CONTRACT-YEAR*
EFFECT-DATE*
Subset
Where(CONTRACT-YEAR !=Zeroes)
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR15.1 HR21.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
ZH510 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
WSCSET5 COMPANY
WORK-SCHED
CONTRACT-YEAR
EFFECT-DATE
PAY-PLAN
Subset
Where(CONTRACT-YEAR !=Zeroes)
WSCSET6 COMPANY
CONTRACT-YEAR*
WORK-SCHED
EFFECT-DATE*
Subset
Where(CONTRACT-YEAR !=Zeroes)
WSCSET7 COMPANY
WORK-SCHED
CONTRACT-YEAR*
EFFECT-DATE*
Subset
Where(STATUS =9)


HRWRKSCHD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
WSC-COMPANY->PRS-COMPANY (PRSSET1)
Spaces->PRS-PROCESS-LEVEL


HRWRKSCHD FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Assignment CWASSIGN
Valid 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
Cmchange CMCHANGE
Valid 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 Rule CMCONTRULE
WSC-COMPANY->CRU-COMPANY
  CRU-CONTRACT-GROUP
  CRU-EFFECT-DATE
Contract Rule CWCONTRULE
WSC-COMPANY->CWC-COMPANY
  CWC-CONTRACT-GROUP
  CWC-EFFECT-DATE
Cwchange CWCHANGE
Valid 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 Cmcontract CMCONTRACT
Valid 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 Contract CWCONTRACT
Valid 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
Employee PATHFIND
Valid 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 Plan PROVERTIME
WSC-COMPANY->PRO-COMPANY
WSC-PAY-PLAN->PRO-PLAN-CODE
  PRO-EFFECT-DATE
Work Dtl HRWRKDTL
WSC-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


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

Home
Contact Us



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