This file holds the key information on how a company administers an employee's contract. Each contract rule record is defined by Company and Effect Date and holds information for generating contract time records, contract payout calculations, default pay codes for the time records, pay classes for contract reporting, default day codes assigned to the work schedule date records to indicate paid and non-paid days, a tolerance amount allowed for a payout, and rounding methods for the contract full and prorated amounts.
UPDATED BY

BN150	BN305	HR00.1	HR01.1	HR04.2	HR04.3
HR04.7	HR04.8	HR11.1	HR11.2	HR511	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	PR521
EXI2.1	EXI4.1	LP130	LP140	PA02.1	PA100
PA102	PA115	PA13.1	PA13.2	PA502	PA513
PA52.1	PA52.3	PA52.4	PA52.5	PR110	PR113
PR120	PR128	PR13.1	PR13.5	PR13.6	PR13.8
PR13.9	PR130	PR131	PR132	PR134	PR135
PR136	PR137	PR189	PR29.1	PR32.1	PR32.2
PR33.1	PR33.2	PR33.3	PR35.1	PR35.2	PR35.3
PR35.4	PR35.5	PR35.6	PR35.8	PR35.9	PR36.1
PR37.1	PR45.1	PR529	PR530	PR560	PR582
PR80.1	PR80.4	PR82.1	UK102	UK560	TA147

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CWC-COMPANY Element: Company Hr	Numeric 4 Identifies the HR Company.
CWC-EFFECT-DATE Element: Cw Effect Date	Numeric 8 (yyyymmdd) The date the Contract Rule record is in effect. Effective Dates allow users to keep a historical record or changes to the contract rules and allow timing of future changes.
CWC-PAID-CODE Element: Cw Day Code	Alpha 10 Day Code that is used for paid days in the work schedule detail that is automatically generated.
CWC-UNPAID-CODE Element: Cw Day Code	Alpha 10 Day Type Code that is used for unpaid days in the work schedule detail that is generated.
CWC-WEEKEND-CODE Element: Cw Day Code	Alpha 10 Day Type Code that is used for weekend days in the work schedule detail that is generated.
CWC-CONTRACT-PAY Element: Pay Class	Alpha 3 Pay Class used to track and report total contract payout amounts
CWC-DOCKING-PAY Element: Pay Class	Alpha 3 Pay Class used to track and report total contract docking payout amounts.
CWC-PAY-CYCLE Element: Cw Pay Cycle	Alpha 1 Occurs 9 Times Option is to enter X in the field. User must select at least 1 of the pay cycles. These Pay Cycle values will default to the Contract Base Assignment at the time the record is manually added on CW13. The CW130 contract payout program uses the pay cycle value to determine whether to create a time record for the contract payout based on a specific pay cycle selected on the batch job parameters.
CWC-ROUND-METH-UNT Element: Cw Method	Numeric 1 Contains the Rounding Units Method. If no rounding is done, the Round To Units needs to be blank. Rounding is only valid for total full and prorated contract units. 0 = None 1 = Normal 2 = High 3 = Low
CWC-ROUND-TO-UNIT Element: Cw Round To	Signed 18.6 Round to unit amount that is only valid when Units Method is not =0.
CWC-ROUND-METH-DOL Element: Cw Method	Numeric 1 Rounding Dollars Method. If no rounding is done, the Round To Dollars needs to be blank. Rounding is only valid for total full and prorated contract amounts. 0 = None 1 = Normal 2 = High 3 = Low
CWC-ROUND-TO-DOL Element: Cw Round To	Signed 18.6 Round to dollars amount that is only valid when Dollar Method is not =0
CWC-TR-CREATION Element: Cw Tr Creation	Numeric 1 Contains the rule for how many time records will be generated by the CW130 program for the contract payout. Option 1 will create one time record per pay period based on the potential earnings determined by the contract Prorated Amount divided by the number of pay cycles. Option 2 will create two time records per pay period for the earned wages (determined by the number of work days from the work schedule) and the reserve balance (determined by the difference between the paid and earned wages). Option 3 will create two time records per work period to allow the PR132 program to calculate the FLSA overtime. Option 4 will create daily earned time records for each worked day in a pay period and 1 reserve time record by pay period. 1 = Paid by Pay Period 2 = Earned + Reserve by Pay Period 3 = Earned + Reserve by Wrk Period 4 = Daily Earned + Res by Pay Per 5 = Daily Earned + Daily Reserve
CWC-PAY-PER-CALC Element: Cw Pay Per Cal	Numeric 1 User is required to indicate the method of calculating the contract payout amounts. Option 1- Will create the pay period paid amount based on the Remaining Wages/ Remaining Pay Cycles. Option 2- Will create the pay period paid amount based on the Full Amount/ Full Pay Cycles and will continue pay out until the money runs out. 1 = Remain Wages/Remain Pay Period 2 = Full Amount/Full Pay Periods
CWC-TOLERANCE-AMT Element: Cw Tolerance	Signed 18.6 Contract payouts per pay period cannot be less than this tolerance amount. CW130 will check this amount and produce a warning message so the user has the option to payout the remaining contract amount or monitor the next time record that is generated and delete this time record that would be less than the tolerance amount that is allowed.
CWC-REGULAR Element: Pay Code	Alpha 4 For Time Record Generation Rule Option 1, the Regular Pay Code wages are the total paid amount per pay period. Option 2 or 3, the Regular Pay Code wages are based on actual days worked determined by the employee's work schedule. This pay code will default to the employee contract base assignment record when it is added.
CWC-RESERVE Element: Pay Code	Alpha 4 Pay Code used for reserve time record for contract payouts. This field is only required when the Time Record Generation Rule= 2 or 3 when two time records will be generated based on the Earned and Reserve wages. The total of these two time records is the total paid amount per pay period.
CWC-ADJUSTMENT Element: Pay Code	Alpha 4 Pay Code used for an adjustment time record. The CW130 program will automatically generate an Adjustment Pay Code when a contract is paying out on multiple segments due to a pay rate change. A negative adjustment amount will be generated and linked to the new segment in order to back out a portion of the total paid amount that was already paid out and tracked on the old segment reserve time record.
CWC-PAYOUT Element: Pay Code	Alpha 4
CWC-DATE-STAMP Element: Date Stamp	Numeric 8 (yyyymmdd) Contains the date (month, day, and year) that changes were made to this record.
CWC-TIME-STAMP Element: Time Stamp	Numeric 6 (hhmmss) Contains the time (hours, minute, and second) the change was made to this record.
CWC-USER-ID Element: User	Alpha 10 (Lower Case) This field contains the user id of the person who last changed this record.
CWC-CREATE-DATE Element: Date Stamp	Numeric 8 (yyyymmdd) This is the date that this record was initially added to the table.
CWC-CREATE-TIME Element: Time Stamp	Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed.
CWC-CREATE-USER-ID Element: User	Alpha 10 (Lower Case) Contains the User Id of the person that last changed this record.
CWC-CONTRACT-GROUP Element: Group	Alpha 15
CWC-RESV-FIRST-PAY Element: Resv First Pay	Alpha 1 1 = No 2 = Yes
CWC-WEB-AVAILABLE Element: Web Available	Alpha 1 1 = No 2 = Yes

CWCONTRULE FILE INDEX

CWCONTRULE FILE RELATIONS

ONE TO ONE RELATIONS

CWCONTRULE FILE RELATIONS

ONE TO MANY RELATIONS

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