PR_25 P/R Benefit Schedule File Ii (PR_25BenfitSchedII) Level: 4.40 Record Type: 1 Benefit Schedule File 08/28/2009 File Type: Direct Key Size: 2 Rec Len: 1270 Min Len: 86 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Benefit Schedule Code . . . . . . . . . BenefitScheduleCode . . . . . Uppercase *(1,2) (V) Accrue On Paid Hours Only . . . . . AccrueOnPaidHoursOnlyVacation Yes/No (3,1) (V) Check Entry Numbers To Accrue . . . CheckEntryNoToAccrueVacation. Uppercase (4,9) (V) Deduction Periods To Accrue . . . . DedPeriodsToAccrueVacation. . Uppercase (13,5) (V) Accrual Method (F/T). . . . . . . . AccrualMethodVacation . . . . Uppercase (18,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (19,12) (S) Accrue On Paid Hours Only . . . . . AccrueOnPaidHoursOnlySick . . Yes/No (31,1) (S) Check Entry Numbers To Accrue . . . CheckEntryNbersToAccrueSick . Uppercase (32,9) (S) Deduction Periods To Accrue . . . . DeductionPeriodsToAccrueSick. Uppercase (41,5) (S) Accrual Method (F/T). . . . . . . . AccrualMethodSick . . . . . . Uppercase (46,1) (O) Accrue On Paid Hours Only . . . . . AccrueOnPaidHoursOnlyOther. . Yes/No (47,1) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (48,12) (O) Check Entry Numbers To Accrue . . . CheckEntryNbersToAccrueOther. Uppercase (60,9) (O) Deduction Periods To Accrue . . . . DeductionPeriodsToAccrueOther Uppercase (69,5) (O) Accrual Method (F/T). . . . . . . . AccrualMethodOther. . . . . . Uppercase (74,1) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (75,12) Accrual Rate. . . . . . . . . . . . . . AccrualRateVacation . . . . . Number [0] 2.7 Delay Period After Hire (Days). . . . . DelayPerAfterHireVacation . . Number [1] 3.0 Elig Wait After Accrual (Months). . . . EligWaitAfterAccrualVacation. Number [2] 2.0 Elig Wait After Hire (Months) . . . . . EligWaitAfterHireVacation . . Number [3] 2.0 Max Hours Per Check To Accrue On. . . . MaxHrsPerChkToAccrueVacation. Number [4] 9.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [5] 0. Table Breakpoint 1 Vacation . . . . . . TableBreakpoint1Vacation. . . Number [6] 4.0 Table Breakpoint 2 Vacation . . . . . . TableBreakpoint2Vacation. . . Number [7] 4.0 Table Breakpoint 3 Vacation . . . . . . TableBreakpoint3Vacation. . . Number [8] 4.0 Table Breakpoint 4 Vacation . . . . . . TableBreakpoint4Vacation. . . Number [9] 4.0 Table Breakpoint 5 Vacation . . . . . . TableBreakpoint5Vacation. . . Number [10] 4.0 Table Breakpoint 6 Vacation . . . . . . TableBreakpoint6Vacation. . . Number [11] 4.0 Table Breakpoint 7 Vacation . . . . . . TableBreakpoint7Vacation. . . Number [12] 4.0 Table Breakpoint 8 Vacation . . . . . . TableBreakpoint8Vacation. . . Number [13] 4.0 Table Breakpoint 9 Vacation . . . . . . TableBreakpoint9Vacation. . . Number [14] 4.0 Table Breakpoint 10 Vacation. . . . . . TableBreakpoint10Vacation . . Number [15] 4.0 Table Breakpoint 11 Vacation. . . . . . TableBreakpoint11Vacation . . Number [16] 4.0 Table Breakpoint 12 Vacation. . . . . . TableBreakpoint12Vacation . . Number [17] 4.0 Table Breakpoint 13 Vacation. . . . . . TableBreakpoint13Vacation . . Number [18] 4.0 Table Breakpoint 14 Vacation. . . . . . TableBreakpoint14Vacation . . Number [19] 4.0 Table Breakpoint 15 Vacation. . . . . . TableBreakpoint15Vacation . . Number [20] 4.0 Table Breakpoint 16 Vacation. . . . . . TableBreakpoint16Vacation . . Number [21] 4.0 Table Breakpoint 17 Vacation. . . . . . TableBreakpoint17Vacation . . Number [22] 4.0 Table Breakpoint 18 Vacation. . . . . . TableBreakpoint18Vacation . . Number [23] 4.0 Table Breakpoint 19 Vacation. . . . . . TableBreakpoint19Vacation . . Number [24] 4.0 Table Breakpoint 20 Vacation. . . . . . TableBreakpoint20Vacation . . Number [25] 4.0 Table Accrual Rate 1 Vacation . . . . . TableAccrualRate1Vacation . . Number [26] 2.7 Table Accrual Rate 2 Vacation . . . . . TableAccrualRate2Vacation . . Number [27] 2.7 Table Accrual Rate 3 Vacation . . . . . TableAccrualRate3Vacation . . Number [28] 2.7 Table Accrual Rate 4 Vacation . . . . . TableAccrualRate4Vacation . . Number [29] 2.7 Table Accrual Rate 5 Vacation . . . . . TableAccrualRate5Vacation . . Number [30] 2.7 Table Accrual Rate 6 Vacation . . . . . TableAccrualRate6Vacation . . Number [31] 2.7 Table Accrual Rate 7 Vacation . . . . . TableAccrualRate7Vacation . . Number [32] 2.7 Table Accrual Rate 8 Vacation . . . . . TableAccrualRate8Vacation . . Number [33] 2.7 Table Accrual Rate 9 Vacation . . . . . TableAccrualRate9Vacation . . Number [34] 2.7 Table Accrual Rate 10 Vacation. . . . . TableAccrualRate10Vacation. . Number [35] 2.7 Table Accrual Rate 11 Vacation. . . . . TableAccrualRate11Vacation. . Number [36] 2.7 Table Accrual Rate 12 Vacation. . . . . TableAccrualRate12Vacation. . Number [37] 2.7 Table Accrual Rate 13 Vacation. . . . . TableAccrualRate13Vacation. . Number [38] 2.7 Table Accrual Rate 14 Vacation. . . . . TableAccrualRate14Vacation. . Number [39] 2.7 Table Accrual Rate 15 Vacation. . . . . TableAccrualRate15Vacation. . Number [40] 2.7 Table Accrual Rate 16 Vacation. . . . . TableAccrualRate16Vacation. . Number [41] 2.7 Table Accrual Rate 17 Vacation. . . . . TableAccrualRate17Vacation. . Number [42] 2.7 Table Accrual Rate 18 Vacation. . . . . TableAccrualRate18Vacation. . Number [43] 2.7 Table Accrual Rate 19 Vacation. . . . . TableAccrualRate19Vacation. . Number [44] 2.7 Table Accrual Rate 20 Vacation. . . . . TableAccrualRate20Vacation. . Number [45] 2.7 Accrual Rate Sick . . . . . . . . . . . AccrualRateSICK . . . . . . . Number [46] 2.7 Delay Period After Hire Sick (Days) . . DelayPeriodAfterHireSick. . . Number [47] 3.0 Eligable Wait After Accrual Sick (MonthsEligWaitAfterAccrualSick. . . Number [48] 2.0 Eligable Wait After Hire Sick (Months). EligWaitAfterHireSick . . . . Number [49] 2.0 Max Hours Per Check To Accrue Sick. . . MaxHrsPerCheckToAccrueSick. . Number [50] 9.2 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [51] 0. Table Breakpoint1 Sick. . . . . . . . . TableBreakpoint1Sick. . . . . Number [52] 4.0 Table Breakpoint2 Sick. . . . . . . . . TableBreakpoint2Sick. . . . . Number [53] 4.0 Table Breakpoint3 Sick. . . . . . . . . TableBreakpoint3Sick. . . . . Number [54] 4.0 Table Breakpoint4 Sick. . . . . . . . . TableBreakpoint4Sick. . . . . Number [55] 4.0 Table Breakpoint5 Sick. . . . . . . . . TableBreakpoint5Sick. . . . . Number [56] 4.0 Table Breakpoint6 Sick. . . . . . . . . TableBreakpoint6Sick. . . . . Number [57] 4.0 Table Breakpoint7 Sick. . . . . . . . . TableBreakpoint7Sick. . . . . Number [58] 4.0 Table Breakpoint8 Sick. . . . . . . . . TableBreakpoint8Sick. . . . . Number [59] 4.0 Table Breakpoint9 Sick. . . . . . . . . TableBreakpoint9Sick. . . . . Number [60] 4.0 Table Breakpoint10 Sick . . . . . . . . TableBreakpoint10Sick . . . . Number [61] 4.0 Table Breakpoint11 Sick . . . . . . . . TableBreakpoint11Sick . . . . Number [62] 4.0 Table Breakpoint12 Sick . . . . . . . . TableBreakpoint12Sick . . . . Number [63] 4.0 Table Breakpoint13 Sick . . . . . . . . TableBreakpoint13Sick . . . . Number [64] 4.0 Table Breakpoint14 Sick . . . . . . . . TableBreakpoint14Sick . . . . Number [65] 4.0 Table Breakpoint15 Sick . . . . . . . . TableBreakpoint15Sick . . . . Number [66] 4.0 Table Breakpoint16 Sick . . . . . . . . TableBreakpoint16Sick . . . . Number [67] 4.0 Table Breakpoint17 Sick . . . . . . . . TableBreakpoint17Sick . . . . Number [68] 4.0 Table Breakpoint18 Sick . . . . . . . . TableBreakpoint18Sick . . . . Number [69] 4.0 Table Breakpoint19 Sick . . . . . . . . TableBreakpoint19Sick . . . . Number [70] 4.0 Table Breakpoint20 Sick . . . . . . . . TableBreakpoint20Sick . . . . Number [71] 4.0 Table Accrual Rate 1 Sick . . . . . . . TableAccrualRate1Sick . . . . Number [72] 2.7 Table Accrual Rate 2 Sick . . . . . . . TableAccrualRate2Sick . . . . Number [73] 2.7 Table Accrual Rate 3 Sick . . . . . . . TableAccrualRate3Sick . . . . Number [74] 2.7 Table Accrual Rate 4 Sick . . . . . . . TableAccrualRate4Sick . . . . Number [75] 2.7 Table Accrual Rate 5 Sick . . . . . . . TableAccrualRate5Sick . . . . Number [76] 2.7 Table Accrual Rate 6 Sick . . . . . . . TableAccrualRate6Sick . . . . Number [77] 2.7 Table Accrual Rate 7 Sick . . . . . . . TableAccrualRate7Sick . . . . Number [78] 2.7 Table Accrual Rate 8 Sick . . . . . . . TableAccrualRate8Sick . . . . Number [79] 2.7 Table Accrual Rate 9 Sick . . . . . . . TableAccrualRate9Sick . . . . Number [80] 2.7 Table Accrual Rate 10 Sick. . . . . . . TableAccrualRate10Sick. . . . Number [81] 2.7 Table Accrual Rate 11 Sick. . . . . . . TableAccrualRate11Sick. . . . Number [82] 2.7 Table Accrual Rate 12 Sick. . . . . . . TableAccrualRate12Sick. . . . Number [83] 2.7 Table Accrual Rate 13 Sick. . . . . . . TableAccrualRate13Sick. . . . Number [84] 2.7 Table Accrual Rate 14 Sick. . . . . . . TableAccrualRate14Sick. . . . Number [85] 2.7 Table Accrual Rate 15 Sick. . . . . . . TableAccrualRate15Sick. . . . Number [86] 2.7 Table Accrual Rate 16 Sick. . . . . . . TableAccrualRate16Sick. . . . Number [87] 2.7 Table Accrual Rate 17 Sick. . . . . . . TableAccrualRate17Sick. . . . Number [88] 2.7 Table Accrual Rate 18 Sick. . . . . . . TableAccrualRate18Sick. . . . Number [89] 2.7 Table Accrual Rate 19 Sick. . . . . . . TableAccrualRate19Sick. . . . Number [90] 2.7 Table Accrual Rate 20 Sick. . . . . . . TableAccrualRate20Sick. . . . Number [91] 2.7 Accrual Rate Other. . . . . . . . . . . AccrualRateOther. . . . . . . Number [92] 2.7 Delay Period After Hire Other (Days). . DelayPeriodAfterHireOther . . Number [93] 3.0 Eligable Wait After Accrual Other (MonthEligWaitAfterAccrualOther . . Number [94] 2.0 Eligable Wait After Hire Other (Months) EligWaitAfterHireOther. . . . Number [95] 2.0 Max Hours Per Check to Accrue Other . . MaxHrsPerChkToAccrueOther . . Number [96] 9.2 Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [97] 0. Table Breakpoint 1 Other. . . . . . . . TableBreakpoint1Other . . . . Number [98] 4.0 Table Breakpoint 2 Other. . . . . . . . TableBreakpoint2Other . . . . Number [99] 4.0 Table Breakpoint 3 Other. . . . . . . . TableBreakpoint3Other . . . . Number [100] 4.0 Table Breakpoint 4 Other. . . . . . . . TableBreakpoint4Other . . . . Number [101] 4.0 Table Breakpoint 5 Other. . . . . . . . TableBreakpoint5Other . . . . Number [102] 4.0 Table Breakpoint 6 Other. . . . . . . . TableBreakpoint6Other . . . . Number [103] 4.0 Table Breakpoint 7 Other. . . . . . . . TableBreakpoint7Other . . . . Number [104] 4.0 Table Breakpoint 8 Other. . . . . . . . TableBreakpoint8Other . . . . Number [105] 4.0 Table Breakpoint 9 Other. . . . . . . . TableBreakpoint9Other . . . . Number [106] 4.0 Table Breakpoint 10 Other . . . . . . . TableBreakpoint10Other. . . . Number [107] 4.0 Table Breakpoint 11 Other . . . . . . . TableBreakpoint11Other. . . . Number [108] 4.0 Table Breakpoint 12 Other . . . . . . . TableBreakpoint12Other. . . . Number [109] 4.0 Table Breakpoint 13 Other . . . . . . . TableBreakpoint13Other. . . . Number [110] 4.0 Table Breakpoint 14 Other . . . . . . . TableBreakpoint14Other. . . . Number [111] 4.0 Table Breakpoint 15 Other . . . . . . . TableBreakpoint15Other. . . . Number [112] 4.0 Table Breakpoint 16 Other . . . . . . . TableBreakpoint16Other. . . . Number [113] 4.0 Table Breakpoint 17 Other . . . . . . . TableBreakpoint17Other. . . . Number [114] 4.0 Table Breakpoint 18 Other . . . . . . . TableBreakpoint18Other. . . . Number [115] 4.0 Table Breakpoint 19 Other . . . . . . . TableBreakpoint19Other. . . . Number [116] 4.0 Table Breakpoint 20 Other . . . . . . . TableBreakpoint20Other. . . . Number [117] 4.0 Table Accrual Rate 1 Other. . . . . . . TableAccrualRate1Other. . . . Number [118] 2.7 Table Accrual Rate 2 Other. . . . . . . TableAccrualRate2Other. . . . Number [119] 2.7 Table Accrual Rate 3 Other. . . . . . . TableAccrualRate3Other. . . . Number [120] 2.7 Table Accrual Rate 4 Other. . . . . . . TableAccrualRate4Other. . . . Number [121] 2.7 Table Accrual Rate 5 Other. . . . . . . TableAccrualRate5Other. . . . Number [122] 2.7 Table Accrual Rate 6 Other. . . . . . . TableAccrualRate6Other. . . . Number [123] 2.7 Table Accrual Rate 7 Other. . . . . . . TableAccrualRate7Other. . . . Number [124] 2.7 Table Accrual Rate 8 Other. . . . . . . TableAccrualRate8Other. . . . Number [125] 2.7 Table Accrual Rate 9 Other. . . . . . . TableAccrualRate9Other. . . . Number [126] 2.7 Table Accrual Rate 10 Other . . . . . . TableAccrualRate10Other . . . Number [127] 2.7 Table Accrual Rate 11 Other . . . . . . TableAccrualRate11Other . . . Number [128] 2.7 Table Accrual Rate 12 Other . . . . . . TableAccrualRate12Other . . . Number [129] 2.7 Table Accrual Rate 13 Other . . . . . . TableAccrualRate13Other . . . Number [130] 2.7 Table Accrual Rate 14 Other . . . . . . TableAccrualRate14Other . . . Number [131] 2.7 Table Accrual Rate 15 Other . . . . . . TableAccrualRate15Other . . . Number [132] 2.7 Table Accrual Rate 16 Other . . . . . . TableAccrualRate16Other . . . Number [133] 2.7 Table Accrual Rate 17 Other . . . . . . TableAccrualRate17Other . . . Number [134] 2.7 Table Accrual Rate 18 Other . . . . . . TableAccrualRate18Other . . . Number [135] 2.7 Table Accrual Rate 19 Other . . . . . . TableAccrualRate19Other . . . Number [136] 2.7 Table Accrual Rate 20 Other . . . . . . TableAccrualRate20Other . . . Number [137] 2.7 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [138] 0. ________ Total Bytes 1358