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
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
WSC-COMPANY Element: Company Hr | Numeric 4 Identifies the HR Company. |
|
||
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. |
|
||
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. |
|
||
WSC-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the Work Schedule description. |
|
||
WSC-TOT-DAYS Element: Tot Days | Signed 10.4 |
|
||
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. |
|
||
WSC-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||
WSC-USER-ID Element: User | Alpha 10 (Lower Case) Contains the User Id of the person that last changed this record. |
|
||
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) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
WSCSET1 |
COMPANY WORK-SCHED CONTRACT-YEAR* EFFECT-DATE* |
|
||||||||||||||
WSCSET2 |
COMPANY WORK-SCHED EFFECT-DATE* CONTRACT-YEAR* |
|
||||||||||||||
WSCSET3 |
COMPANY WORK-SCHED EFFECT-DATE CONTRACT-YEAR |
|
||||||||||||||
WSCSET4 |
COMPANY WORK-SCHED CONTRACT-YEAR* EFFECT-DATE* |
|
||||||||||||||
WSCSET5 |
COMPANY WORK-SCHED CONTRACT-YEAR EFFECT-DATE PAY-PLAN |
|
||||||||||||||
WSCSET6 |
COMPANY CONTRACT-YEAR* WORK-SCHED EFFECT-DATE* |
|
||||||||||||||
WSCSET7 |
COMPANY WORK-SCHED CONTRACT-YEAR* EFFECT-DATE* |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Assignment | CWASSIGN |
| ||||||||||||||||||||||||
Contract Rule | CWCONTRULE |
| ||||||||||||||||||||||||
Cwchange | CWCHANGE |
| ||||||||||||||||||||||||
Emp Contract | CWCONTRACT |
| ||||||||||||||||||||||||
Employee | PATHFIND |
| ||||||||||||||||||||||||
Pay Plan | PROVERTIME |
| ||||||||||||||||||||||||
Work Dtl | HRWRKDTL |
|
All trademarks and registered trademarks are the property of their
respective owners.