sched = Tblpersonalsched.new(:schedulecode => 'VACATION',:personalid => '2',:paid => 'False',:officeid => '2')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MATERNITY LEAVE',:personalid => '3',:paid => 'False',:officeid => '2')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'SICK/MEDICAL',:personalid => '4',:paid => 'False',:officeid => '2')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OTHER',:personalid => '10',:paid => 'False',:officeid => '2')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION/PAID',:personalid => '29',:paid => 'True',:officeid => '9994')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION',:personalid => '30',:paid => 'False',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MATERNITY LEAVE',:personalid => '31',:paid => 'True',:officeid => '9994')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'SICK/MEDICAL',:personalid => '32',:paid => 'True',:officeid => '9994')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'FLOATING HOL',:personalid => '33',:paid => 'True',:officeid => '9994')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'BEREAVEMENT',:personalid => '34',:paid => 'True',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TRAINING',:personalid => '35',:paid => 'True',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'ONE ON ONE',:personalid => '36',:paid => 'True',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OTHER',:personalid => '37',:paid => 'False',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'PTO',:personalid => '38',:paid => 'True',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION/UNPAID',:personalid => '39',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'SICK/MEDICAL/UNPAID',:personalid => '41',:paid => 'True',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'HOLIDAY',:personalid => '42',:paid => 'True',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'BEREAVEMENT',:personalid => '43',:paid => 'True',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TRAINING',:personalid => '44',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'LUNCH',:personalid => '45',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION/PAID',:personalid => '46',:paid => 'True',:officeid => '10')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION',:personalid => '47',:paid => 'False',:officeid => '10')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MATERNITY LEAVE',:personalid => '48',:paid => 'True',:officeid => '10')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'SICK/MEDICAL',:personalid => '49',:paid => 'True',:officeid => '10')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'FLOATING HOL',:personalid => '50',:paid => 'True',:officeid => '10')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'BEREAVEMENT',:personalid => '51',:paid => 'True',:officeid => '10')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TRAINING',:personalid => '52',:paid => 'True',:officeid => '10')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OTHER',:personalid => '53',:paid => 'False',:officeid => '10')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION',:personalid => '63',:paid => 'False',:officeid => '6')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MATERNITY LEAVE',:personalid => '64',:paid => 'False',:officeid => '6')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'SICK/MEDICAL',:personalid => '65',:paid => 'False',:officeid => '6')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OTHER',:personalid => '66',:paid => 'False',:officeid => '6')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION/PAID',:personalid => '67',:paid => 'True',:officeid => '5')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION',:personalid => '68',:paid => 'False',:officeid => '5')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MATERNITY LEAVE',:personalid => '69',:paid => 'True',:officeid => '5')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'SICK/MEDICAL',:personalid => '70',:paid => 'True',:officeid => '5')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'FLOATING HOL',:personalid => '71',:paid => 'True',:officeid => '5')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'BEREAVEMENT',:personalid => '72',:paid => 'True',:officeid => '5')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TRAINING',:personalid => '73',:paid => 'True',:officeid => '5')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'ONE ON ONE',:personalid => '74',:paid => 'True',:officeid => '5')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OTHER',:personalid => '75',:paid => 'False',:officeid => '5')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION/PAID',:personalid => '76',:paid => 'True',:officeid => '7')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION',:personalid => '77',:paid => 'False',:officeid => '7')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MATERNITY LEAVE',:personalid => '78',:paid => 'True',:officeid => '7')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'SICK/MEDICAL',:personalid => '79',:paid => 'True',:officeid => '7')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'FLOATING HOL',:personalid => '80',:paid => 'True',:officeid => '7')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'BEREAVEMENT',:personalid => '81',:paid => 'True',:officeid => '7')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TRAINING',:personalid => '82',:paid => 'True',:officeid => '7')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'ONE ON ONE',:personalid => '83',:paid => 'True',:officeid => '7')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OTHER',:personalid => '84',:paid => 'False',:officeid => '7')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION/PAID',:personalid => '85',:paid => 'True',:officeid => '8')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION',:personalid => '86',:paid => 'False',:officeid => '8')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MATERNITY LEAVE',:personalid => '87',:paid => 'True',:officeid => '8')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'SICK/MEDICAL',:personalid => '88',:paid => 'True',:officeid => '8')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'FLOATING HOL',:personalid => '89',:paid => 'True',:officeid => '8')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'BEREAVEMENT',:personalid => '90',:paid => 'True',:officeid => '8')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TRAINING',:personalid => '91',:paid => 'True',:officeid => '8')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'ONE ON ONE',:personalid => '92',:paid => 'True',:officeid => '8')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OFF SITE',:personalid => '93',:paid => 'False',:officeid => '8')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TIME ADJUST',:personalid => '94',:paid => 'True',:officeid => '9999')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'CANCELLED',:personalid => '95',:paid => 'False',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MEETING',:personalid => '96',:paid => 'False',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MEETING',:personalid => '97',:paid => 'False',:officeid => '2')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MEETING',:personalid => '98',:paid => 'False',:officeid => '5')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MEETING',:personalid => '99',:paid => 'False',:officeid => '6')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MEETING',:personalid => '100',:paid => 'False',:officeid => '7')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MEETING',:personalid => '101',:paid => 'False',:officeid => '8')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MEETING',:personalid => '102',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MEETING',:personalid => '103',:paid => 'False',:officeid => '10')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MEETING',:personalid => '105',:paid => 'False',:officeid => '13')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION/PAID',:personalid => '106',:paid => 'True',:officeid => '99915')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION',:personalid => '107',:paid => 'False',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MATERNITY LEAVE',:personalid => '108',:paid => 'True',:officeid => '99915')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'SICK/MEDICAL',:personalid => '109',:paid => 'True',:officeid => '99915')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'FLOATING HOL',:personalid => '110',:paid => 'True',:officeid => '99915')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'BEREAVEMENT',:personalid => '111',:paid => 'True',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TRAINING',:personalid => '112',:paid => 'True',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'ONE ON ONE',:personalid => '113',:paid => 'True',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OTHER',:personalid => '114',:paid => 'False',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION/PAID [AB/RC]',:personalid => '115',:paid => 'True',:officeid => '99915')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION [AB/RC]',:personalid => '116',:paid => 'False',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MATERNITY LEAVE [AB/RC]',:personalid => '117',:paid => 'True',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'SICK/MEDICAL [AB/RC]',:personalid => '118',:paid => 'True',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'FLOATING HOL [AB/RC]',:personalid => '119',:paid => 'True',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'BEREAVEMENT [AB/RC]',:personalid => '120',:paid => 'True',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TRAINING [AB/RC]',:personalid => '121',:paid => 'True',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'ONE ON ONE [AB/RC]',:personalid => '122',:paid => 'True',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OTHER [AB/RC]',:personalid => '123',:paid => 'False',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TIME ADJUST',:personalid => '124',:paid => 'True',:officeid => '999')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'CANCELLED',:personalid => '125',:paid => 'False',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MEETING',:personalid => '126',:paid => 'False',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MEETING [AB/RC]',:personalid => '127',:paid => 'False',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'PERSONAL APPT',:personalid => '128',:paid => 'False',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'PERSONAL APPT',:personalid => '129',:paid => 'False',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OFFICE TIME',:personalid => '130',:paid => 'True',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OFFICE TIME',:personalid => '131',:paid => 'True',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MENTORING',:personalid => '132',:paid => 'True',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MENTORING',:personalid => '133',:paid => 'True',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'PTO',:personalid => '134',:paid => 'True',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'PTO',:personalid => '135',:paid => 'True',:officeid => '15')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'HOLIDAY',:personalid => '136',:paid => 'True',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TRAVEL',:personalid => '137',:paid => 'True',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'UNAVAILABLE',:personalid => '138',:paid => 'False',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'CALL TO CHECK',:personalid => '139',:paid => 'False',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'NIC',:personalid => '140',:paid => 'False',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'CMP',:personalid => '141',:paid => 'False',:officeid => '4')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'COMMUNITY AVAILABLE',:personalid => '142',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'CI TRAVEL TIME',:personalid => '143',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'FMLA/PTO',:personalid => '144',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'FMLA/NO PTO',:personalid => '145',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MENTORING',:personalid => '146',:paid => 'True',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OFFICE TIME',:personalid => '147',:paid => 'True')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OFFICE TIME',:personalid => '148',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'ONE ON ONE',:personalid => '149',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OTHER',:personalid => '150',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'PERSONAL APPT',:personalid => '151',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TRAVEL',:personalid => '152',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'UNAVAILABLE',:personalid => '153',:paid => 'False',:officeid => '9')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'VACATION',:personalid => '155',:paid => 'False',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'BEREAVEMENT',:personalid => '156',:paid => 'True',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TRAINING',:personalid => '157',:paid => 'True',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'ONE ON ONE',:personalid => '158',:paid => 'True',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OTHER',:personalid => '159',:paid => 'False',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'CANCELLED',:personalid => '160',:paid => 'False',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MEETING',:personalid => '161',:paid => 'False',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'PERSONAL APPT',:personalid => '162',:paid => 'False',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'OFFICE TIME',:personalid => '163',:paid => 'True',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'MENTORING',:personalid => '164',:paid => 'True',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'PTO',:personalid => '165',:paid => 'True',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'HOLIDAY',:personalid => '166',:paid => 'True',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'TRAVEL',:personalid => '167',:paid => 'True',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'UNAVAILABLE',:personalid => '168',:paid => 'False',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'CALL TO CHECK',:personalid => '169',:paid => 'False',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'NIC',:personalid => '170',:paid => 'False',:officeid => '16')
sched.save

sched = Tblpersonalsched.new(:schedulecode => 'CMP',:personalid => '171',:paid => 'False',:officeid => '16')
sched.save

puts "DB DATA IMPORT SUCCESSFUL for tblPersonalSched"
