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.
UPDATED BY
HR21.1 BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1
HPQC.1 HPRS.1 HR00.1 HR01.1 HR11.1 HR11.2
HR15.1 HR155 HR156 HR170 HR511 HR515
HR54.1 HR55.2 HR70.1 HRS1.1 HRSC.1 HWSC.1
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 PA31.1 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 PR120 PR13.1 PR13.5
PR13.6 PR13.8 PR13.9 HR221 HR51.2 HR51.8

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WSC-COMPANY
Element: Company Hr
Numeric 4
Identifies the HR Company.
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)
Contains the User Id of the person that last changed this record.
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
0-Open (when "Add" screen function is performed) 9-Closed (when Work Schedule header is in balance with the detail records paid days.
0 = Open
9 = Closed
WSC-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
This pertains to the Contract Start Date that will default as the Contract Start Date on the Contract Record.
WSC-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
This pertains to the Contract End Date that will default as the Contract End Date on the Contract Record.
WSC-WORK-START-DT
Element: Start Date
Numeric 8 (yyyymmdd)
This date determines the Work Start and End Dates to be used to calculate work days for payouts that will default to Contract.
WSC-WORK-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
This date will determine the Work Start and End range used to calculate work days for payout that will default to Contract.
WSC-TOT-HRS-PR-DAY
Element: Cw Hrs Pr Day
Signed 18.6
This is the standard hours per day on the Work Schedule 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 the number of Work Days and 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
Set the flag to a 'Yes' when a change is performed on the CW01 that is tied to an employee. CW100 will look for these records to update employee contract records and then will reset the flag. CW130 will not create a time record for a contract flagged as 'Yes'.
1 = No
2 = Yes
WSC-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
This is the date that this record was added to the table.
WSC-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
WSC-CREATE-USER
Element: User
Alpha 10 (Lower Case)
Contains the User Id of the person that last changed this record.
WSC-TAX-FREQ-OVER
Element: Tax Freq Over
Numeric 3
The value of this field defaults to employee contracts based on the Work Schedule assigned to each contract. Flag indicates if the amount should be taxed on a basis other than the pay frequency of the employee. This frequency value is passed to BSI to calculate the correct tax amount.
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
The Pay Plan needs to link with the Work Schedule in order to calculate the appropriate number of pay cycles.
WSC-PAY-CYCLES
Element: Cw Pay Cycles
Numeric 3
The Pay Cycles will work in conjunction with the Pay Frequency field on the Work Schedule to properly calculate Employee Payouts.
WSC-FIRST-PAY-DT
Element: Date
Numeric 8 (yyyymmdd)


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 HR15.1
HR155 HR156
HR170 HR511
HR515 HR54.1
HR55.2 HR70.1
HRS1.1 HRSC.1
HWSC.1 LP100
LP101 PA02.1
PA100 PA102
PA103 PA113
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 HR15.1
HR170 HR21.1
HR221 HR51.2
HR51.8 HR511
HR515 HR54.1
HR70.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA272 PA502
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 HR15.1
HR21.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
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
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 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: Wed Jun 08 20:49:10 2016

Home
Contact Us



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