./0000775000102300010230000000000010765652142011171 5ustar00korekore00000000000000ABOUT0000666000102300010230000000155410766360662011644 0ustar00korekore00000000000000This application is a recruiting/job posting application built with the web2py framework, intended to provide both students and recruiters with a forum to post resume and position information within a controlled environment. Recruiters on the site possess the ability to add and maintain their company profiles and a listing of job openings for that company, defining the distribution of those postings to anyone who access the website (public) or just to registered users on the site(Restricted). Additionally, recruiters can monitor their job postings to see the information of those applicants that have applied for one of their positions Applicants/students on the site possess the ability to add and maintain resume information, review company profiles and job postings, search through the job postings using keyword search, and ultimately to apply for a position.LICENSE0000666000102300010230000000322610765651737012057 0ustar00korekore00000000000000Copyright (C) 2008 Kenneth J. Ore, Michael Pozzi, Scott Santarromana All Rights Reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: 1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. 2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. 3. Neither the names Kenneth J. Ore, Michael Pozzi, Scott Santarromana, nor the names of its contributors may be used to endorse or promote products derived from this software without prior written permission. For written permission, please contact ken_ore@hotmail.com, mjpozzi1@yahoo.com, and scott.santarromana@gmail.com. THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL CLARKWARE CONSULTING OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. __init__.py0000666000102300010230000000000010765652142013135 0ustar00korekore00000000000000cache/0000775000102300010230000000000010765652142012077 5ustar00korekore00000000000000cache/cache.lock0000666000102300010230000000000010756307737014013 0ustar00korekore00000000000000controllers/0000775000102300010230000000000010765652142013402 5ustar00korekore00000000000000controllers/appadmin.py0000666000102300010230000001244010765652142015550 0ustar00korekore00000000000000########################################################### ### make sure administrator is on localhost ############################################################ import os from gluon.contenttype import contenttype from gluon.fileutils import check_credentials if request.env.remote_addr!=request.env.http_host.split(':')[0]: raise HTTP(400) if not check_credentials(request): redirect('/admin') response.view='appadmin.html' response.menu=[['design',False,'/admin/default/design/%s' % request.application], ['db',False,'/%s/%s/index' % (request.application, request.controller)], ['state',False,'/%s/%s/state' % (request.application, request.controller)]] ########################################################### ### list all tables in database ############################################################ def index(): import types as _types _dbs={} for _key,_value in globals().items(): if isinstance(_value,SQLDB): tables=_dbs[_key]=[] for _tablename in _value.tables: tables.append((_key,_tablename)) return dict(dbs=_dbs) ########################################################### ### insert a new record ############################################################ def insert(): try: dbname=request.args[0] db=eval(dbname) table=request.args[1] form=SQLFORM(db[table]) except: redirect(URL(r=request,f='index')) if form.accepts(request.vars,session): response.flash='new record inserted' return dict(form=form) ########################################################### ### list all records in table and insert new record ############################################################ def download(): filename=request.args[0] response.headers['Content-Type']=contenttype(filename) return open(os.path.join(request.folder,'uploads/','%s' % filename),'rb').read() def csv(): import gluon.contenttype, csv, cStringIO response.headers['Content-Type']=gluon.contenttype.contenttype('.csv') try: dbname=request.vars.dbname db=eval(dbname) records=db(request.vars.query).select() except: redirect(URL(r=request,f='index')) s=cStringIO.StringIO() writer = csv.writer(s) writer.writerow(records.colnames) c=range(len(records.colnames)) for i in range(len(records)): writer.writerow([records.response[i][j] for j in c]) ### FILL HERE return s.getvalue() def import_csv(table,file): import csv reader = csv.reader(file) colnames=None for line in reader: if not colnames: colnames=[x[x.find('.')+1:] for x in line] c=[i for i in range(len(line)) if colnames[i]!='id'] else: items=[(colnames[i],line[i]) for i in c] table.insert(**dict(items)) def select(): try: dbname=request.args[0] db=eval(dbname) if not request.vars.query: table=request.args[1] query='%s.id>0' % table else: query=request.vars.query except: redirect(URL(r=request,f='index')) if request.vars.csvfile!=None: try: import_csv(db[table],request.vars.csvfile.file) response.flash='data uploaded' except: response.flash='unable to parse csv file' if request.vars.delete_all and request.vars.delete_all_sure=='yes': try: db(query).delete() response.flash='records deleted' except: response.flash='invalid SQL FILTER' elif request.vars.update_string: try: env=dict(db=db,query=query) exec('db(query).update('+request.vars.update_string+')') in env response.flash='records updated' except: response.flash='invalid SQL FILTER or UPDATE STRING' if request.vars.start: start=int(request.vars.start) else: start=0 limitby=(start,start+100) try: records=db(query).select(limitby=limitby) except: response.flash='invalid SQL FILTER' return dict(records='no records',nrecords=0,query=query,start=0) linkto=URL(r=request,f='update/%s'% (dbname)) upload=URL(r=request,f='download') return dict(start=start,query=query,\ nrecords=len(records),\ records=SQLTABLE(records,linkto,upload,_class='sortable')) ########################################################### ### edit delete one record ############################################################ def update(): try: dbname=request.args[0] db=eval(dbname) table=request.args[1] except: redirect(URL(r=request,f='index')) try: id=int(request.args[2]) record=db(db[table].id==id).select()[0] except: redirect(URL(r=request,f='select/%s/%s'%(dbname,table))) form=SQLFORM(db[table],record,deletable=True, linkto=URL(r=request,f='select/'+dbname), upload=URL(r=request,f='download/')) if form.accepts(request.vars,session): response.flash='done!' redirect(URL(r=request,f='select/%s/%s'%(dbname,table))) return dict(form=form) ########################################################### ### get global variables ############################################################ def state(): return dict(state=request.env) controllers/default.py0000666000102300010230000000113010765652142015375 0ustar00korekore00000000000000def index(): if session.authorized: postings=db(db.positions.access!='Private').select(db.positions.ALL,orderby=~db.positions.timestamp) appls=db(db.applicants.access!='Private').select(db.applicants.ALL,orderby=~db.applicants.updated) else: postings=db(db.positions.access=='Public').select(db.positions.ALL,orderby=~db.positions.timestamp) appls=db(db.applicants.access=='Public').select(db.applicants.ALL,orderby=~db.applicants.updated) return dict(postings=postings,appls=appls) def post(): return dict(message="no post page yet...this is a stub")controllers/identity.py0000666000102300010230000002251110765652142015610 0ustar00korekore00000000000000import md5, random def login(): response.flash='Please enter your login information, or register.' form=FORM(TABLE(TR("Email:",INPUT(_name="email",requires=IS_NOT_EMPTY())), TR("Password:",INPUT(_name="password",_type='password', requires=[IS_NOT_EMPTY(),CRYPT()])), TR("",INPUT(_type="submit",_value="login")))) if form.accepts(request.vars,session): r=db(db.user.email==form.vars.email)\ (db.user.password==form.vars.password)\ (db.user.verification=='')\ .select() if len(r)>0: session.user_type=r[0].user_type session.user_id=r[0].id session.username=r[0].email session.authorized=True session.flash='You are logged in, %s' % session.username redirect(URL(r=request,c='default',f='index')) else: response.flash='Invalid login' elif form.errors: response.flash='Invalid login' link1=A('register',_href=URL(r=request,f='register')) link2=A('forgot password',_href=URL(r=request,f='retrieve')) return dict(form=form, link1=link1, link2=link2) def logout(): session.authorized=False session.user_id=0 session.username="Anonymous" session.flash="Logged out" redirect(URL(r=request,c='default',f='index')) def askwhichregister(): return dict() def registerapplicant(): import random, md5 response.flash='Please enter your information in order to register.' form=FORM(TABLE( TR("Email:",\ INPUT(_name="email",requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'user.email')])),\ TR("Password:",\ INPUT(_name="password",_type='password',requires=[IS_NOT_EMPTY(),CRYPT()])),\ TR("Password (again):",\ INPUT(_name="password2",_type='password',requires=[IS_NOT_EMPTY(),CRYPT()])),\ TR("Name:",\ INPUT(_name="name",requires=[IS_NOT_EMPTY()])),\ TR("Phone:",\ INPUT(_name="phone",requires=[IS_NOT_EMPTY()])),\ TR("",INPUT(_type="submit",_value="register")) ) ) if form.accepts(request.vars,session) and \ form.vars.password==form.vars.password2: key=md5.new(str(random.randint(0,9999))).hexdigest() id=db.user.insert(name=form.vars.name, email=form.vars.email, password=form.vars.password,phone=form.vars.phone, verification=key,user_type="Applicant") db.applicants.insert(user_id=id, applicant_name=form.vars.name, email=form.vars.email, phone=form.vars.phone) r=db(db.user.id==id)\ (db.user.verification==key)\ .select() if len(r)==0: raise HTTP(400,'page does not exist') r[0].update_record(verification='') session.authorized=True session.user_id=r[0].id session.username=r[0].name if r[0].password=='': response.flash='You must change your password' elif form.vars.password!=form.vars.password2: form.errors.password2='passwords do not match' response.flash="Form error" else: session.flash='registration complete and you are now logged in' redirect(URL(r=request,c='default',f='index')) elif form.errors: response.flash='Invalid login' return dict(form=form) def registerrecruiter(): import random, md5 response.flash='Please enter your information in order to register.' form=FORM(TABLE( TR("Email:",\ INPUT(_name="email",requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'user.email')])),\ TR("Password:",\ INPUT(_name="password",_type='password',requires=[IS_NOT_EMPTY(),CRYPT()])),\ TR("Password (again):",\ INPUT(_name="password2",_type='password',requires=[IS_NOT_EMPTY(),CRYPT()])),\ TR("Name:",\ INPUT(_name="name",requires=[IS_NOT_EMPTY()])),\ TR("Phone:",\ INPUT(_name="phone",requires=[IS_NOT_EMPTY()])),\ TR("",INPUT(_type="submit",_value="register")) ) ) if form.accepts(request.vars,session) and \ form.vars.password==form.vars.password2: key=md5.new(str(random.randint(0,9999))).hexdigest() id=db.user.insert(name=form.vars.name,email=form.vars.email, password=form.vars.password,phone=form.vars.phone, verification=key,user_type="Recruiter") r=db(db.user.id==id)\ (db.user.verification==key)\ .select() if len(r)==0: raise HTTP(400,'page does not exist') r[0].update_record(verification='') session.authorized=True session.user_id=r[0].id session.username=r[0].name if r[0].password=='': response.flash='You must change your password' elif form.vars.password!=form.vars.password2: form.errors.password2='passwords do not match' response.flash="Form error" else: session.flash='registration complete and you are now logged in' redirect(URL(r=request,c='default',f='index')) elif form.errors: response.flash='Invalid login' return dict(form=form) def registeradministrator(): import random, md5 response.flash='Please enter your information in order to register.' form=FORM(TABLE( TR("Email:",\ INPUT(_name="email",requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'user.email')])),\ TR("Password:",\ INPUT(_name="password",_type='password',requires=[IS_NOT_EMPTY(),CRYPT()])),\ TR("Password (again):",\ INPUT(_name="password2",_type='password',requires=[IS_NOT_EMPTY(),CRYPT()])),\ TR("Name:",\ INPUT(_name="name",requires=[IS_NOT_EMPTY()])),\ TR("Phone:",\ INPUT(_name="phone",requires=[IS_NOT_EMPTY()])),\ TR("",INPUT(_type="submit",_value="register")) ) ) if form.accepts(request.vars,session) and \ form.vars.password==form.vars.password2: key=md5.new(str(random.randint(0,9999))).hexdigest() id=db.user.insert(name=form.vars.name, email=form.vars.email, password=form.vars.password,phone=form.vars.phone, verification=key,user_type="Administrator") r=db(db.user.id==id)\ (db.user.verification==key)\ .select() if len(r)==0: raise HTTP(400,'page does not exist') r[0].update_record(verification='') session.authorized=True session.user_id=r[0].id session.username=r[0].name if r[0].password=='': response.flash='You must change your password' elif form.vars.password!=form.vars.password2: form.errors.password2='passwords do not match' response.flash="Form error" else: session.flash='registration complete and you are now logged in' redirect(URL(r=request,c='default',f='index')) elif form.errors: response.flash='Invalid login' return dict(form=form) def retrieve(): form=FORM(TABLE(TR("Username:",INPUT(_name="email",requires=[IS_NOT_EMPTY(),IS_IN_DB(db,'user.email')])), TR("",INPUT(_type="submit",_value="retrieve")))) if form.accepts(request.vars,session): r=db(db.user.email==form.vars.email).select() if len(r): key=md5.new(str(random.randint(0,9999))).hexdigest() id=r[0].id r[0].update_record(password='',verification=key) message="To change your password visit: http://%s/%s/identity/verify?id=%s&key=%s"%(request.env.http_host,request.application,id,key) try: email(EMAIL_SENDER,form.vars.email,'registration',message) redirect(URL(r=request,f='login')) response.flash="We sent you an email" except: print message response.flash="Internal error, we are unable to send the email" else: form.errors.email='email not in database' response.flash="Form error" return dict(form=form) def change_password(): if not session.authorized: redirect(URL(r=request,f='login')) form=FORM(TABLE(TR("Password:",INPUT(_name="password",requires=[IS_NOT_EMPTY(),CRYPT()])), TR("Password (again):",INPUT(_name="password2",requires=[IS_NOT_EMPTY(),CRYPT()])), TR("",INPUT(_type="submit",_value="register")))) if form.accepts(request.vars,session) and \ form.vars.password==form.vars.password2: db(db.user.id==session.user_id).update(password=form.vars.password) response.flash='password updated' elif form.vars.password!=form.vars.password2: form.errors.passwords2='passwords do not match' response.flash="Form error" return dict(form=form)controllers/jobs.py0000666000102300010230000002425610765652142014724 0ustar00korekore00000000000000# try something like def index(): redirect(URL(r=request,c='default',f='index')) def view(): response.flash = "Welcome to the jobs section!" if session.authorized: postings=db(db.positions.access!='Private').select(db.positions.ALL,orderby=~db.positions.timestamp) # return dict(postings=postings) else: postings=db(db.positions.access=='Public').select(db.positions.ALL,orderby=~db.positions.timestamp) return dict(postings=postings) def post(): return dict(message="Show form for posting a job here.") def viewcompany(): response.flash = "Select companies from the lower right." try: page_id=int(request.args[0]) except: page_id=1 this_page=db(db.company.id==page_id).select(db.company.ALL,orderby=db.company.company_name)[0] pages=db().select(db.company.ALL,orderby=db.company.company_name) if session.authorized: postings=db((db.positions.company_name==this_page.company_name)&(db.positions.access!='Private')).select(db.positions.ALL,orderby=~db.positions.timestamp) else: postings=db((db.positions.company_name==this_page.company_name)&(db.positions.access=='Public')).select(db.positions.ALL,orderby=~db.positions.timestamp) return dict(pages=pages,this_page=this_page,postings=postings) def viewcatlist(): response.flash = "Select categories from the lower right." try: page_id=int(request.args[0]) except: page_id=1 this_page=db(db.categories.id==page_id).select(db.categories.ALL,orderby=db.categories.cat_name)[0] pages=db().select(db.categories.ALL,orderby=db.categories.cat_name) if session.authorized: postings=db((db.positions.category==this_page.cat_name)&(db.positions.access!='Private')).select(db.positions.ALL,orderby=~db.positions.timestamp) else: postings=db((db.positions.category==this_page.cat_name)&(db.positions.access=='Public')).select(db.positions.ALL,orderby=~db.positions.timestamp) # postings=db(db.positions.category==this_page.cat_name).select(db.positions.ALL,orderby=~db.positions.timestamp) return dict(pages=pages,this_page=this_page,postings=postings) def newcompany(): response.flash="Creating a company!" if not(session.user_type=='Recruiter' or session.user_type=='Administrator'): session.flash='insufficient security to add a company' redirect(URL(r=request,c='default',f='index')) myform=SQLFORM(db.company,_method='POST') if myform.accepts(request.vars): session.flash='changes accepted' redirect(URL(r=request,f='viewcompany')) if myform.errors: session.flash='invalid form' return dict(form=myform) def editcompany(): response.flash="Creating / updating an existing company!" try: page_id=int(request.args[0]) except: session.flash='invalid request' redirect(URL(r=request,c='default',f='index')) this_page=db(db.company.id==page_id).select()[0] if int(this_page.owner)!=int(session.user_id) and session.user_type!='Administrator': session.flash='insufficient security to edit company' redirect(URL(r=request,c='default',f='index')) myform=SQLFORM(db.company,this_page,_method='GET') if myform.accepts(request.vars): session.flash='changes accepted' redirect(URL(r=request,f='viewcompany',args=[this_page.id])) if myform.errors: session.flash='invalid form' return dict(page=this_page,form=myform) def viewpost(): # response.flash="Viewing a job posting!" try: page_id=int(request.args[0]) except: page_id=1 # Note, no security validation here for the posting, in theory you shouldn't have gotten the link unless # you were authorized, probably something to discuss this_page=db(db.positions.id==page_id).select(db.positions.ALL,orderby=db.positions.timestamp)[0] pages=db().select(db.company.ALL,orderby=db.company.company_name) return dict(pages=pages,this_page=this_page) def newpost(): response.flash='Creating a job posting!' if not(session.user_type=='Recruiter' or session.user_type=='Administrator'): session.flash='insufficient security to add a job posting' redirect(URL(r=request,c='default',f='index')) myform=SQLFORM(db.positions,_method='POST') if myform.accepts(request.vars): session.flash='changes accepted' redirect(URL(r=request,f='viewpost')) if myform.errors: session.flash='invalid form' return dict(form=myform) def editpost(): response.flash='Creating / editing a job posting!' try: page_id=int(request.args[0]) except: session.flash='invalid request' redirect(URL(r=request,c='default',f='index')) this_page=db(db.positions.id==page_id).select()[0] if int(this_page.owner)!=int(session.user_id) and session.user_type!='Administrator': session.flash='insufficient security to edit job posting' redirect(URL(r=request,c='default',f='index')) myform=SQLFORM(db.positions,this_page,_method='GET') if myform.accepts(request.vars): session.flash='changes accepted' redirect(URL(r=request,f='viewpost')) if myform.errors: session.flash='invalid form' return dict(page=this_page,form=myform) def newcat(): # if db((db.user.id==session.user_id)&(db.user.user_type=='Administrator')).select(db.user.authorized): # db.categories.insert(cat_name='') # last_page=db(db.categories.id>=0).select(orderby=~db.categories.id)[0] # redirect(URL(r=request,f='editcat',args=[last_page.id])) # else: # session.flash='insufficient security to add category' # redirect(URL(r=request,c='default',f='index')) response.flash="Creating a category!" if db((db.user.id==session.user_id)&(db.user.user_type=='Administrator')).select(db.user.authorized): myform=SQLFORM(db.categories,_method='POST') if myform.accepts(request.vars): session.flash='changes accepted' redirect(URL(r=request,f='viewcat')) if myform.errors: response.flash='invalid form' return dict(form=myform) else: session.flash='insufficient security to edit category' redirect(URL(r=request,c='default',f='index')) def viewcat(): response.flash="Viewing a category!" try: page_id=int(request.args[0]) except: page_id=1 this_page=db(db.categories.id==page_id).select()[0] pages=db().select(db.categories.ALL,orderby=db.categories.cat_name) #applicant_id=db(db.applicants.user_id==session.user_id).select()[0].id return dict(pages=pages,this_page=this_page) def editcat(): response.flash="Creating / editing a category!" if db((db.user.id==session.user_id)&(db.user.user_type=='Administrator')).select(db.user.authorized): try: page_id=int(request.args[0]) except: page_id=1 this_page=db(db.categories.id==page_id).select()[0] myform=SQLFORM(db.categories,this_page,_method='GET') if myform.accepts(request.vars): session.flash='changes accepted' redirect(URL(r=request,f='viewcat',args=[this_page.id])) if myform.errors: response.flash='invalid form' return dict(page=this_page,form=myform) else: session.flash='insufficient security to edit category' redirect(URL(r=request,c='default',f='index')) def keysearch(): # response.flash='Please enter a keyword search term.' form=FORM(TABLE(TR("Keyword:",INPUT(_name="keyword",requires=IS_NOT_EMPTY())), TR("",INPUT(_type="submit",_value="search")))) if form.accepts(request.vars,session): session.flash='Here are your search results.' redirect(URL(r=request,f='results',args=[form.vars.keyword])) else: session.flash='No results found! Try a different keyword.' return dict(form=form) def results(): response.flash='Here are the results of your search term.' try: searchterm=request.args[0] except: session.flash='Invalid Search Term' redirect(URL(r=request,f='keysearch')) try: if session.authorized: this_page=db((db.positions.description.like('%'+searchterm+'%'))&(db.positions.access!='Private')).select(db.positions.ALL,orderby=db.positions.timestamp)[0] pages=db((db.positions.description.like('%'+searchterm+'%'))&(db.positions.access!='Private')).select(db.positions.ALL,orderby=db.positions.timestamp) else: this_page=db((db.positions.description.like('%'+searchterm+'%'))&(db.positions.access=='Public')).select(db.positions.ALL,orderby=db.positions.timestamp)[0] pages=db((db.positions.description.like('%'+searchterm+'%'))&(db.positions.access=='Public')).select(db.positions.ALL,orderby=db.positions.timestamp) return dict(pages=pages,this_page=this_page) except: session.flash='Search Criteria Failed to Match Any Postings' redirect(URL(r=request,f='keysearch')) def appliedtopost(): response.flash='Applicants for this position.' try: page_id=int(request.args[0]) except: session.flash='Invalid Position ID' redirect(URL(r=request,c='default',f='index')) try: this_page=db(db.positions.id==page_id).select(db.positions.ALL,orderby=db.positions.timestamp)[0] appls=db(db.applied_for.position_id==page_id).select(db.applied_for.ALL,orderby=~db.applied_for.applied) # appls=db(db.applicants.id==appllink.applicant).select(db.applicants.ALL) return dict(this_page=this_page,appls=appls) except: session.flash='No one applied to position' redirect(URL(r=request,f='viewpost',args=[page_id])) def apply(): session.flash='Thank you for applying.' try: page_id=int(request.args[0]) except: session.flash='Invalid Position ID' redirect(URL(r=request,c='default',f='index')) # try: pos=db(db.positions.id==page_id).select(db.positions.ALL)[0] appl=db(db.applicants.user_id==session.user_id).select(db.applicants.ALL)[0] db.applied_for.insert(position_id=pos.id,applicant=appl.id,applicant_name=appl.applicant_name,applied=now) redirect(URL(r=request,f=viewpost,args=[page_id])) # except: # session.flash='Invalid Applicant or Position ID' # redirect(URL(r=request,c='default',f='index'))controllers/resumes.py0000666000102300010230000001314010765652142015440 0ustar00korekore00000000000000exception_id=db(db.applicants.id>=0).select(db.applicants.user_id)[0] ########################### ### DEFAULT CONTROLLERS ### ########################### def index(): redirect(URL(r=request,f='default/index')) # Show resumes for current identity's authorization level def view(): if session.user_type=='Administrator' or session.user_type=='Recruiter': response.flash='Welcome to the resume section! (Viewing all resumes)' resumelist=db().select(db.resumes.ALL) applicant_id=exception_id else: response.flash='Welcome to the resume section! (You are logged in as an applicant. Listing restricted to your own resumes.)' resumelist=db(db.resumes.user_id==session.user_id).select() applicant_id=db(db.applicants.user_id==session.user_id).select()[0].id return dict(resumelist=resumelist,applicant_id=applicant_id) # Show form to allow current user to submit a resume def post(): db.resumes.insert(user_id=session.user_id) new_resume=db(db.resumes.id>=0).select(orderby=~db.resumes.id)[0] redirect(URL(r=request,f='editresume',args=[new_resume.id])) def editresume(): response.flash='Creating / updating a resume!' try: resume_id=int(request.args[0]) except: resume_id=exception_id thisresume=db(db.resumes.id==resume_id).select()[0] thisapplicant=db(db.applicants.user_id==thisresume.user_id).select()[0] editform=SQLFORM(db.resumes,thisresume,_method='GET') if editform.accepts(request.vars): session.flash='changes accepted' redirect(URL(r=request,f='viewresume',args=[thisresume.id])) if editform.errors: response.flash='invalid form' return dict(thisapplicant=thisapplicant,thisresume=thisresume,editform=editform,applicant_id=thisapplicant.id) # Only show resumes for the current user def viewresume(): if session.user_type=='Administrator' or session.user_type=='Recruiter': response.flash='Viewing applicant resume!' else: response.flash='Viewing your resume!' try: page_id=int(request.args[0]) except: page_id=exception_id thisresume=db(db.resumes.id==page_id).select(db.resumes.ALL,orderby=db.resumes.updated)[0] if session.user_type=='Administrator' or session.user_type=='Recruiter': resumelist=db().select(db.resumes.ALL) applicant_id=exception_id else: resumelist=db(db.resumes.user_id==thisresume.user_id).select() applicant_id=db(db.applicants.user_id==session.user_id).select()[0].id return dict(thisresume=thisresume,resumelist=resumelist,applicant_id=applicant_id) ###################################### ### APPLICANT CONTROLLER FUNCTIONS ### ###################################### # Returns a list of all applicants def viewapplicants(): response.flash='Listing all applicants!' applicantlist=db().select(db.applicants.ALL) return dict(applicantlist=applicantlist) # Show information for current applicant def viewapplicant(): response.flash='Viewing applicant info!' try: user_id=int(request.args[0]) except: user_id=exception_page_id thisapplicant=db(db.applicants.id==user_id).select()[0] applicantlist=applicantlist=db().select(db.applicants.ALL) return dict(thisapplicant=thisapplicant,applicantlist=applicantlist) # Edit information for current applicant def editapplicant(): response.flash='Editing your personal information!' try: user_id=int(request.args[0]) except: user_d=exception_id thisapplicant=db(db.applicants.id==user_id).select()[0] editform=SQLFORM(db.applicants,thisapplicant,_method='GET') if editform.accepts(request.vars): session.flash='changes accepted' redirect(URL(r=request,f='view')) if editform.errors: response.flash='invalid form' return dict(thisapplicant=thisapplicant,editform=editform) ######################## ### SEARCH FUNCTIONS ### ######################## def keysearch(): response.flash='Please enter a keyword search term.' form=FORM(TABLE(TR("Keyword:",INPUT(_name="keyword",requires=IS_NOT_EMPTY())), TR("",INPUT(_type="submit",_value="search")))) if form.accepts(request.vars,session): session.flash='Here are your search results.' redirect(URL(r=request,f='results',args=[form.vars.keyword])) else: session.flash='No results found! Try a different keyword.' return dict(form=form) def results(): response.flash='Here are the results of your search term.' try: searchterm=request.args[0] response.flash='Here are the results for your search term: ' + searchterm except: session.flash='Invalid Search Term' redirect(URL(r=request,f='keysearch')) try: if session.authorized: this_page=db((db.resumes.body.like('%'+searchterm+'%'))&(db.resumes.access!='Private')).select(db.resumes.ALL,orderby=db.resumes.updated)[0] pages=db((db.resumes.body.like('%'+searchterm+'%'))&(db.resumes.access!='Private')).select(db.resumes.ALL,orderby=db.resumes.updated) else: this_page=db((db.resumes.description.like('%'+searchterm+'%'))&(db.resumes.access=='Public')).select(db.resumes.ALL,orderby=db.resumes.updated)[0] pages=db((db.resumes.description.like('%'+searchterm+'%'))&(db.resumes.access=='Public')).select(db.resumes.ALL,orderby=db.resumes.updated) applicant_id=db(db.applicants.user_id==session.user_id).select()[0].id return dict(pages=pages,this_page=this_page,applicant_id=applicant_id) except: session.flash='Search Criteria Failed to Match Any Postings' redirect(URL(r=request,f='keysearch'))databases/0000775000102300010230000000000010765652142012763 5ustar00korekore00000000000000databases/db.db0000666000102300010230000022200010765607105013654 0ustar00korekore00000000000000SQLite format 3@ "B öûö ûCû= ‚òæºÖǰ“£‚ #applied_for!applicants resumes=user company positions!categories state| countryï `v Ÿ3Ý`@ #3  'New CompanyNew Company Profile1KentuckyUnited States5{ w/ 'Coca-ColaSelling sugar water for more years than you can countAtlanta278821 CocaCola AvenueGeorgiaUnited States6T '9 'TestOwnerCodeTo test the Owner CodeChicago606061034IllinoisUnited States6j #m 'Better WorkPlease work on the new Company Posting re-directWork476741 WorkIndianaUnited States6 }#+ 'PozziCoLooking for something, anything, to be in business aboutOrland Park60462123 Main StreetIllinoisUnited States6T '3 !'Sharper ImageWe're going down!!!Image989891 SharpWashingtonUnited States4g ‚M#' !'GoogleWe know everything, because we've completely catalogued and indexed the entire world. Yes, I know what you're thinking right now, and no, you can't have any.Googlopolis909941 Google LaneCaliforniaUnited States2 5- !'MicrosoftEvil empire intent on taking over the world, or at least, that's what we used to be.Redmond909091 Bill Gates WayCaliforniaUnited States1 fÐ|81ExecutiveExecutive Division,+?Testing Cat SecTesting Category Security-RFinanceAll things Finance and Accounting And maybe a little audit mixed in.]ITInformation Technology Is awesome!!!!û;û:  + ¸Á8+‚ ƒctablepositionspositionsCREATE TABLE positions( id INTEGER PRIMARY KEY AUTOINCREMENT, title CHAR(32), category CHAR(32), description TEXT, timestamp TIMESTAMP, restricted CHAR(1), public CHAR(1) , company_name CHAR(32), access CHAR(32), owner CHAR(32))!!WtablecategoriescategoriesCREATE TABLE categories( id INTEGER PRIMARY KEY AUTOINCREMENT, cat_name CHAR(32), cat_descr TEXT )tƒ?tablecompanycompanyCREATE TABLE company( id INTEGER PRIMARY KEY AUTOINCREMENT, company_name CHAR(32), profile TEXT , city CHAR(32), zip CHAR(32), address1 CHAR(32), address2 CHAR(32), state CHAR(32), country CHAR(32), owner CHAR(32))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)sƒItableuseruserCREATE TABLE user( id INTEGER PRIMARY KEY AUTOINCREMENT, name CHAR(32), email CHAR(32), user_type CHAR(32), password CHAR(32), verification CHAR(32) , phone_country_code CHAR(32), phone CHAR(32), authorized CHAR(32)) ™:¦Y¶:y'+ %53Teresa Seguso501 Hampton Dr.LakeviewKY409901502-555-9223Teresa@Seguso.Seguso2008-03-01 01:17:48USAPublico+ %+3Amy Smith123 Main Streej # %/3stud255th streetchicagoIL606041555-555-5555stud2@stud2.stud22008-03-10 17:51:21USAPublic16q1  %E3Scott SantarromanaChicagoIL1555-555-5555scott.santarromana@gmail.com2008-03-09 04:17:09AFGPublic9>%3MP41555-555-5555MP42008-03-09 11:37:34Public11>%3MP21555-555-5555MP22008-03-09 09:25:28Public101%E3Scott SantaH )3student15551212stud@stud.stud2008-03-10 17:24:06Public15 ¦yM9y=##‚Atableapplied_forapplied_for CREATE TABLE applied_for( id INTEGER PRIMARY KEY AUTOINCREMENT, position_id CHAR(32), applicant CHAR(32), applied TIMESTAMP , applicant_name CHAR(32))‚j!!…tableapplicantsapplicants CREATE TABLE applicants( id INTEGER PRIMARY KEY AUTOINCREMENT, applicant_name CHAR(32), address1 CHAR(32), address2 CHAR(32), city CHAR(32), state CHAR(32), zip CHAR(32), phone_country_code CHAR(32), phone CHAR(32), email CHAR(32), resume TEXT, updated TIMESTAMP , country CHAR(32), access CHAR(32), user_id CHAR(32))§##‚tableapplied_forapplied_for CREATE TABLE applied_for( id INTEGER PRIMARY KEY AUTOINCREMENT, position_id CHAR(32), applicant CHAR(32), applied TIMESTAMP )077tableposition_requirementsposition_requirementsCREATE TABLE position_requirements( id INTEGER PRIMARY KEY AUTOINCREMENT, position_id CHAR(32), requirement CHAR(32) ) µßµ[[[[¨XOC3positions.title Java Architect applicants.applicant_name 2008-03-09 09:49:47OC3positions.title Java Architect applicants.applicant_name 2008-03-09 09:49:17¬OC3¥31082008-03-09 11:51:33MP4„O3Cpositions.title Java Architect 112008-03-09 11:44:11applicants.applicant_name +O3Cpositions.title Java Architect 112008-03-09 11:42:17applicants.applicant_name ÒO3Cpositions.title Java Architect 112008-03-09 11:41:56applicants.applicant_name yO3Cpositions.title Java Architect 11200(3%2092008-03-09 12:19:05Test Student31082008-03-09 11:51:56MP4 äûöðêäc: _0#19ûöñëåßÙÓÍÇÁ»µ¯©£—‘‹…ysmga[UOIC=718Ši7ŠA6Š5‰v4‰N3‰$2ˆ|1ˆW0ˆ0/ˆ.‡b-‡:,‡+†k*†H)†!(…z'…R&…+%…$„Z#„1"„ !ƒd ƒ=ƒ‚l‚D‚sJ#|R) a9ÜgaU ƒtableresumesresumes!TLSEast Timor=1DOMDominican Republic<DMADominica;DJIDjibouti:DNKDenmark9)CZECzech Republic 8CYPCyprus 7CUBCuba6HRVCroatia5'CIVCote D'Ivoire4!CRICosta Rica3%COKCook Islands%2ICODCongo, The Democratic Republic 1COGCongo .nÚÉ·§—‰wTG7( üíÛͼ•zkX4%õÖÀ®›yiWE7(úæÓ²Œn 5MDAMoldova, Republic of# EFSMMicronesia, Federated States MEXMexico MYTMayotte MUSMauritius!MRTMauritania!MTQMartinique-MHLMarshall Islands MLTMalta MLIMaliMDVMaldivesMYSMalaysia MWIMalawi!MDGMadagascar MACMacao~!LUXLuxembourg}LTULithuania|'LIELiechtenstein{9LBYLibyan Arab JamahiriyazLBRLiberiayLSOLesothoxLBNLebanon wLVALatvia"vCLAOLao People's Democratic Repu!KGZKyrgyzstan tKWTKuwaits1KORKorea, Republic of%rIPRKKorea, Democratic People's RepqKIRKiribati pKENKenyaoKAZKazakstan nJORJordan mJPNJapanlJAMJamaica kITAItaly jISRIsraeliIRLIreland hIRQIraq!gAIRNIran (Islamic Republic Of)fIDNIndonesia eINDIndiadISLIcelandcHUNHungarybHKGHong KongaHNDHonduras$`GVATHoly See (Vatican City State) -pðÞʹ¥”ƒteP2óäÓÅ­‹{m[L$úèÚų£‘|m\K/ êÕ²£p:7STPSao Tome and Principe9!SMRSan Marino 8WSMSamoa 7?SPMSaint Pierre and Miquelon6#LCASaint Lucia57KNASaint Kitts and Nevis4%SHNSaint Helena 3RWARwanda21RUSRussian Federation1ROURomania0REUReunion /QATQatar.#PRIPuerto Rico-PRTPortugal ,POLPoland+PCNPitcairn*#PHLPhilippines )PERPeru(PRYParaguay'-PNGPapua New Guinea &PANPanama%%IPSEPalestinian Territory, Occupie $PLWPalau#PAKPakistan "OMNOman !NORNorway =MNPNorthern Mariana Islands)NFKNorfolk Island NIUNiueNGANigeria NERNigerNICNicaragua#NZLNew Zealand'NCLNew Caledonia5ANTNetherlands Antilles#NLDNetherlands NPLNepal NRUNauruNAMNamibiaMMRMyanmar!MOZMozambiqueMARMorocco!MSRMontserratMNGMongolia MCOMonaco )lêÙůœŠx_N8)ïȹ§‡tdO1úÔ´£”wfV@ëÛʬ”}lcURYUruguayb'USAUnited Statesa)GBRUnited Kingdom`5AREUnited Arab Emirates_UKRUkraine ^UGAUganda ]?UMIUS Minor Outlying Islands \TUVTuvalu[=TCATurks and Caicos IslandsZ%TKMTurkmenistan YTURTurkeyXTUNTunisiaW3TTOTrinidad and Tobago VTONTongaUTKLTokelau TTGOTogoSTHAThailand#RETZATanzania, United Republic ofQ!TJKTajikistan P?TWNTaiwan, Province of ChinaO5SYRSyrian Arab RepublicN#CHESwitzerland MSWESwedenLSWZSwazilandK9SJMSvalbard and Jan MayenJSURSuriname ISDNSudan$HGSGSSth Georgia & Sth Sandwich Is$GGVCTSt Vincent and the GrenadinesFLKASri Lanka EESPSpainD%ZAFSouth AfricaCSOMSomaliaB+SLBSolomon IslandsASVNSlovenia@SVKSlovakia?SGPSingapore>%SLESierra Leone=!SYCSeychelles<SENSenegal;%SAUSaudi Arabia õìÛȶ”uR:+õoZWEZimbabwe nZMBZambiam!YUGYugoslavia lYEMYemenk)ESHWestern Sahara j?WLFWallis and Futuna Islandsi7VIRVirgin Islands (U.S.)h=VGBVirgin Islands (British)gVNMViet NamfVENVenezuelaeVUTVanuatud!UZBUzbekistan )fëÕÁ©—}hM=( øé¿®—‚o\J9%øÝƲœ‡uaM:üÛ¿®šf)'NLD1679Ambt Montfort(#NLD0142Ambt Delden'BRAAMAmazonas&BRAAPAmapa%)NLD0741Alphen En Riel$3NLD0484Alphen Aan Den Rijn!#;FRA04Alpes de Haute Provence"+FRA06Alpes Maritimes!ESP04Almeria NLD0034AlmereNLD0141AlmeloFRA03AllierNLD0361AlkmaarNLD0483AlkemadeESP03Alicante#ITAALAlessandria'NLD0613Albrandswaard%NLD0482AlblasserdamCANABAlbertaESP02AlbaceteESP01AlavaUSAAKAlaskaBRAALAlagoasUSAALAlabamaJPN05Akita-KenNLD0360AkerslootFRA02Aisne(ICHLAGAisen del Gral. C.I. del Campo FRA01Ain JPN23Aichi-Ken )MEXAGSAguascalientes ITAAGAgrigento BRAACAcre'NLD0059AchtkarspelenNLD0305Abcoude%NLD0739Aarle-RixtelCHEAGAargau!NLD0648AardenburgNLD0197AaltenNLD0358AalsmeerNLD0738Aalburg )vëÑ­–~fN7%üëØ½¦“}hRA+éÏ·¦”bO;*óß̶•vR3USAAEArmed Forces EuropeQ7USAAAArmed Forces AmericasPIRLARMAGHArmaghOGBRARMArmaghNUSAARArkansasMUSAAZArizonaLFRA09AriegeKITAARArezzoJGBRARDArdsIFRA08ArdennesHFRA07ArdecheG+NLD0885Arcen En VeldenFCHLARAraucaniaEVENARAraguaDVENAPApureC!NLD0003AppingedamB)CHEAIAppenzell I.R.A)CHEARAppenzell A.R.@NLD0200Apeldoorn?ITAAOAosta>!JPN02Aomori-Ken=CHN92Aomen<!VENANAnzoategui;BELANAntwerpen:IRLANTRIMAntrim9GBRANTAntrim8#CHLANAntofagasta7'NLD0366Anna Paulowna6NLD0105Anloo5CHN34Anhui4NLD0199Angerlo3NLD0364Andijk2ITAANAncona1NLD0363Amsterdam0!NLD0362Amstelveen/!NLD0198Ammerzoden.!NLD0307Amersfoort-NLD0306Amerongen",9USA$UASAmerican Samoa Federal+)USAASAmerican Samoa*NLD0060Ameland *fàÈ´›ˆueQ>.ìÖò …r_B1ïм¦ydK;(ýçл©|f|NLD0888Beek (L){NLD0005Bedumz%GBRBEDSBedfordshireyDEUBYBayernxNLD0144Bathmenw#CHEBSBasel-Stadtv!CHEBLBasel-LanduFRA67Bas RhintNLD0203BarneveldsVENBABarinasrITABABariq#NLD0489BarendrechtpESP08BarcelonaoGBRBNBBanbridgen!GBRBLYBallymoneymGBRBLABallymenalESP07Balearesk/NLD0745Bakel En Milheezej3MEXBCSBaja California Sur i7MEXBCNBaja California NortehBRABABahiag/DEUBWBaden WurttembergfESP06BadajozeNLD0308Baarnd'NLD0744Baarle-NassaucNLD0650AxelbESP05AvilaaFRA12Aveyron`NLD0143Avereest_ITAAVAvellino^/AUSACTAustl. Cap. Terr.]FRA11Aude\FRA10Aube[CHLATAtacamaZESP33AsturiasYITAATAstiXNLD0743AstenWNLD0106AssenV'ITAAPAscoli PicenoUNLD0202ArnhemT!NLD0649ArnemuidenS5USAAPArmed Forces Pacific 'cæÐ»¦’}hR7#øçδ ‡nQ;' é̳œ‰xaN6óàdz’{c#NLD0495Bleiswijk"NLD0376Blaricum!1NLD0754Bladel En Netersel CHLBBBio-Bio!NLD0585BinnenmaasITABIBiella(ICANZZBeyond the limits of any Prov.NLD0375BeverwijkNLD0209BeuningenNLD0753BestNLD0568BernisseCHEBEBernDEUBEBerlinNLD0752BerlicumGBRBERKSBerkshire)NLD0751Berkel-Enschot3NLD0493Berkel En Rodenrijs'NLD0492BergschenhoekNLD0207BerghNLD0749Bergeyk)NLD0748Bergen Op Zoom!NLD0893Bergen (L) !NLD0373Bergen Nh ITABGBergamo #NLD0491Bergambacht !NLD0372Bennebroek BOLBEBeniITABNBeneventoNLD0206BemmelITABLBelluno%NLD0007BellingweddeNLD0890BelfeldGBRBFSBelfastNLD0107BeilenCHN11BeijingNLD0889BeeselNLD8730Beernem~NLD0370Beemster}%NLD0746Beek En Donk 'læË²‰u^J4íÙízeP8$ ÷ã˵ ‰lR6ñÍ®šlJNLD0312BunnikI%ARGBABuenos AiresHNLD0759BudelG+GBRBUCKSBuckinghamshire!F;BELBCBrussels-Capital RegionENLD0899BrunssumDNLD0213BrummenCNLD0657BruinisseB'NLD0656BrouwershavenA#NLD0898Broekhuizen@-CANBCBritish Columbia?GBRBRISTBristol>ITABRBrindisi=NLD0501Brielle<NLD0311Breukelen;ITABSBrescia:DEUHBBremen9#NLD0194Brederwiede8NLD0758Breda7#DEUBRBrandenburg6NLD0212Brakel5NLD0757Boxtel4NLD0756Boxmeer3-FRA13Bouches du Rhone2NLD0499Boskoop1NLD0654Borsele0NLD0147Borne/NLD0897Born.NLD0108Borger-)GBRBORDERBorders Region,NLD0211Borculo+ITABZBolzano*NLD0064Bolsward)ITABOBologna(VENBOBolivar'NLD0755Boekel&!NLD0497Bodegraven%%NLD0055Boarnsterhim$#NLD0377Bloemendaal )açÓÀ«—…pY?* õÞȵt_H-êÒ¼¨’}kN<(ûæÈ· ŠtasITACHChietirJPN12Chiba-KenqMEXCHPSChiapaspGBRCHESCheshireoFRA18Chern/FRA17Charente MaritimemFRA16Charentel!GBRCHL ISChannel IskARGCHChacojNLD0760ChaamiESP51Ceutah)GBRCENTCentral RegiongBRACECearafIRLCAVANCavaneITACZCatanzarodITACTCataniacARGCTCatamarcabNLD0383Castricuma#GBRCSRCastlereagh`ESP12Castellon_ITACECaserta^'GBRCFKCarrickfergus]IRLCARLOWCarlow\VENCACarabobo[+ARGCFCapital Federal"Z9NLD0502Capelle Aan Den IjsselYFRA15CantalXESP39CantabriaW!ITACBCampobassoVMEXCAMPCampecheU)GBRCAMBSCambridgeshireTFRA14CalvadosS'ITACLCaltanissettaR!USACACaliforniaQITACACagliariPESP11CadizOESP10CaceresNNLD0381BussumMESP09BurgosLNLD0214BurenK!NLD0313Bunschoten *wèÒ¿¨{fO8  õà˺¢‹vbN;#øæÍ¹£‰t]I6õáɳ¡w‚NLD0148Dalfsen‚NLD0110Dalen‚ITACNCuneo‚GBRCUMBCumbria‚NLD0216Culemborg‚NLD1684Cuijk‚ESP16Cuenca‚ITAKRCrotone‚#NLD0611Cromstrijen‚FRA23Creuse‚ITACRCremona‚GBRCGVCraigavon‚NLD0314Cothen‚'FRA22Cotes d'Armor‚FRA21Cote d'Or‚ITACSCosenza‚ %FRA2ACorse du Sud‚ FRA20Corse‚ !ARGCRCorrientes‚ FRA19Correze‚ GBRCNWLLCornwall‚IRLCORKCork‚ESP14Cordoba‚ARGCOCordoba‚CHLCOCoquimbo‚GBRCKTCookstown‚#USACTConnecticut‚ITACOComo‚USACOColorado‚MEXCOLIColimaGBRCLRColeraine~VENCOCojedes}NLD0109Coevorden|!BOLCOCochabamba{MEXCOAHCoahuilazGBRCLWYDClwydyIRLCLAREClarex#ESP13Ciudad Realw!BOLCHChuquisacavARGCBChubutuCHN50ChongqingtMEXCHIHChihuahua 'YæÐº£†p[G0ýçηŠu`H1óÚÁ«–oW?ä̵œ†nY‚DNLD0766Dongen‚CIRLDNEGALDonegal‚BNLD0660Domburg‚A!NLD0222Doetinchem‚@NLD0221Doesburg‚?NLD0220Dodewaard‚>-MEXDFDistrito Federal‚=-BRADFDistrito Federal‚<5USADCDistrict of Columbia‚;NLD0504Dirksland‚:NLD0219Dinxperlo$‚9=NLD0764Dinteloord En Prinsenlan‚8NLD0111Diever‚7NLD0763Diessen‚6!NLD0152Diepenveen‚5!NLD0151Diepenheim‚4NLD0384Diemen‚3NLD0218Didam‚2GBRDEVONDevon‚1NLD0150Deventer‚0#FRA79Deux Serves‚/NLD0762Deurne‚.IRLDERRYDerry‚-GBRDRYDerry‚,!GBRDERBYDerbyshire‚+NLD0149Denekamp‚*!NLD0400Den Helder‚)NLD0159Den Ham‚(!NLD0768Den Dungen‚''VENDADelta Amacuro‚&NLD0010Delfzijl‚%NLD0503Delft‚$USADEDelaware‚#NLD0135De Wijk‚")NLD0736De Ronde Venen‚!NLD1663De Marne‚ NLD0552De Lier‚NLD0310De Bilt‚#NLD0065Dantumadeel (bæÒ½¥Ž|jW<ðÛÆ¯—‚ZC.íØ¯“€jN<(üçÒ¼¥wb‚lNLD0230Elburg‚kNLD0772Eindhoven‚jNLD0905Eijsden‚iNLD0229Eibergen‚hJPN38Ehime-Ken‚gNLD0357Egmond‚fNLD0770Eersel‚eNLD1651Eemsmond‚dNLD0317Eemnes‚cNLD0113Eelde‚bNLD0228Ede‚a'NLD0385Edam-Volendam‚`NLD0227Echteld‚_NLD0902Echt‚^#GBRE.SUSXEast Sussex&‚]=GBRE YORKEast Riding of Yorkshire‚\GBRDYFEDDyfed‚[NLD0112Dwingeloo‚ZNLD0769Dussen‚YGBRDURDurham‚XMEXDGODurango‚WGBRDGNDungannon%‚VAGBRD&GDumfries & Galloway Region‚UNLD0226Duiven‚TNLD0662Duiveland‚SIRLDUBLINDublin‚RNLD0225Druten‚QNLD0767Drunen‚PNLD0303Dronten‚OFRA26Drome!‚N7NLD0316Driebergen-Rijsenburg‚M%NLD0498Drechterland‚LIRLDOWNDown‚KGBRDOWDown‚JFRA25Doubs‚IGBRDORSETDorset‚HNLD0505Dordrecht‚GFRA24Dordogne‚FNLD0315Doorn‚E#NLD0058Dongeradeel ([íÙÁ°™‚p[H-婘lU;êЫ•mZG3ìÙë‘r[ƒIRLGALWAYGalwayƒ-NLD0653Gaasterlan-Sleatƒ'JPN07Fukushima-Kenƒ#JPN40Fukuoka-KenƒJPN18Fukui-KenƒCHN35FujianƒITAFRFrosinoneƒ CHEFRFreiburgƒ 'NLD0070Franekeradeelƒ ARGFOFormosaƒ ITAFOForli'ƒ ITAFGFoggiaƒUSAFLFloridaƒITAFIFirenzeƒFRA29Finistere"ƒ9NLD0778Fijnaart En Heijningenƒ#GBRFIFEFife Regionƒ)NLD0068FerwerderadeelƒITAFEFerraraƒ3BRAFNFernando de NoronhaƒIRLFERMANFermanagh‚GBRFERFermanagh‚~VENFAFalcon‚}%FRA28Eure et Loir‚|FRA27Eure‚{!NLD0777Etten-Leur ‚z9FRA99Etranger (Hors France)‚y-MEXEMEXEstado de Mexico‚xFRA91Essonne‚wGBRESSEXEssex‚v)BRAESEspirito Santo‚uNLD0776Esch‚tNLD0233Ermelo‚sNLD0232Epe‚r!ARGEREntre Rios‚qNLD0153Enschede‚pITAENEnna‚oNLD0388Enkhuizen‚nNLD0114Emmen‚mNLD0231Elst )cîÝÆ¨wbM4 öáκ§–zeP3 ìÓÀ®™†nZD0úÛÁ­–‚cƒ=)GBRGT LONGreater Londonƒ<NLD0786Graveƒ;!CHEGRGraubundenƒ:ESP18Granadaƒ9#NLD0157Gramsbergenƒ8+GBRGRAMPGrampian Regionƒ7'NLD0365Graft-De Rijpƒ6#NLD0693Graafstroomƒ5NLD0513Goudaƒ4NLD0239Gorsselƒ3ITAGOGoriziaƒ2NLD0512Gorinchemƒ1NLD0156Goorƒ0NLD0785Goirleƒ/BRAGOGoiasƒ.NLD0664Goesƒ-!NLD0511Goedereedeƒ,+GBRGLOUCSGloucestershireƒ+CHEGLGlarusƒ*FRA33Girondeƒ))NLD0784Gilze En Rijenƒ(JPN21Gifu-Kenƒ'NLD0116Gietenƒ&'NLD0689Giessenlandenƒ%FRA32Gersƒ$ESP17Geronaƒ#USAGAGeorgiaƒ"ITAGEGenovaƒ!NLD0907Gennepƒ CHEGEGenfƒ!NLD0154GenemuidenƒNLD0238Gendtƒ!NLD0237GendringenƒNLD0782GemertƒNLD0906GeleenƒNLD0781Geldropƒ%NLD0236Geldermalsenƒ+NLD0779GeertruidenbergƒNLD0115GasselteƒFRA30GardƒCHN62Gansu 'WÝǯ—~iN6 òÚİœ†p\G1ñ׬…hS@(ûâɤŠoWƒdNLD0072Harlingenƒc%NLD0395Harenkarspelƒb#NLD0017Haren (Gr.)"ƒa9NLD0523Hardinxveld-Giessendamƒ`!NLD0243Harderwijkƒ_!NLD0160Hardenbergƒ^GBRHANTSHampshireƒ]DEUHHHamburgƒ\NLD0789Halsterenƒ[CHN46HainanƒZNLD0914HaelenƒY)NLD0394Haarlemmermeer$ƒX=NLD0393Haarlemmerliede En SpaarƒWNLD0392HaarlemƒVNLD0788HaarenƒU#NLD0158HaaksbergenƒTGBRGWYNDGwyneddƒSGBRGWENTGwentƒRFRA973GuyaneƒQJPN10Gunma-KenƒPNLD0913GulpenƒOCHN52GuizhouƒNESP20GuipuzcoaƒMMEXGROGuerreroƒLVENGUGuaricoƒKCHN45GuangxiƒJCHN44GuangdongƒI!MEXGTOGuanajuatoƒH%USA$UGUGuam FederalƒGUSAGUGuamƒF!FRA971GuadeloupeƒE#ESP19GuadalajaraƒD%NLD0912GrubbenvorstƒCITAGRGrossetoƒB!NLD0015GrootegastƒANLD0014Groningenƒ@NLD0241Groesbeekƒ?NLD0240Groenlo ƒ>1GBRGT MANGreater Manchester 'néÓ¾¨v^F+úáÈ­—„r^K3íÒ¶œ†q]D/ìϹ¢n„ 3NLD0531Hendrik-Ido-Ambacht„ CHN41Henan„ NLD0795Helvoirt„NLD0794Helmond„)NLD0530Hellevoetsluis„#NLD0163Hellendoorn„NLD0918Helden„NLD0162Heino„NLD0399Heiloo„%CHN23Heilongjiang„NLD0793Heeze„NLD0791HeeschƒNLD0917Heerlenƒ~#NLD0526Heerjansdamƒ}'NLD0398Heerhugowaardƒ|%NLD0247Heerewaardenƒ{!NLD0074HeerenveenƒzNLD0246HeerdeƒyNLD0397HeemstedeƒxNLD0396HeemskerkƒwNLD1937HeelƒvNLD0245HedelƒuCHN13HebeiƒtUSAHIHawaiiƒsNLD0117Havelteƒr)FRA92Hauts de Seineƒq%FRA05Hautes Alpesƒp%FRA87Haute Vienneƒo%FRA74Haute Savoieƒn#FRA70Haute Saoneƒm)FRA65Haute Pyreneesƒl#FRA52Haute Marneƒk#FRA43Haute Loireƒj'FRA31Haute Garonneƒi#FRA2BHaute CorseƒhFRA68Haut RhinƒgNLD0244HattemƒfNLD0161HasseltƒeNLD0318Harmelen &XéͲždQ9#øßʪ“x`F-îÒ¹–rK3ýéÔ¯œƒmX„1NLD0406Huizen„0NLD0255Huissen„/!NLD0803Huijbergen„.ESP22Huesca„-ESP21Huelva„,CHN42Hubei„+NLD0321Houten„*NLD0923Horst„)NLD0405Hoorn„(3NLD0018Hoogezand-Sappemeer„'NLD0118Hoogeveen$„&=NLD0800Hoogeloon,Hapert En Cast!„%7NLD0802Hooge En Lage Zwaluwe „$5NLD0801Hooge En Lage Mierde„#!NLD0675Hontenisse„"-HKGHHong Kong Island„!NLD0165Holten„ JPN01Hokkaido„NLD0799Hoeven„!NLD0253Hoevelaken„'JPN34Hiroshima-Ken„NLD0402Hilversum„%NLD0798Hilvarenbeek„NLD0534Hillegom„+GBRHIGHLDHighland Region„MEXHGOHidalgo„!NLD0920Heythuysen„NLD0797Heusden„NLD0252Heumen„NLD0251Heteren„NLD0063Het Bildt„DEUHEHessen„'GBRHERTSHertfordshire„'GBRHFORDHerefordshire„FRA34Herault„%NLD0164Hengelo (Ov)„ 'NLD0248Hengelo (Gld)„ !BELHEHenegouwen )`ì̺¥weM2üçÓ¿­’o[B)ñÛÁ°›‡saO=,úÒ»¡Œs`„ZUSAKSKansas„Y%JPN14Kanagawa-Ken„XNLD0166Kampen„W'JPN46Kagoshima-Ken„V!JPN37Kagawa-Ken%„UCUSAK0KY-Kenton County Tiered Tax„T5USAK1KY-Hazard Tiered Tax„SFRA39Jura„RCHEJUJura„QARGJUJujuy„PMYSJHJohor„OCHN22Jilin„NCHN36Jiangxi„MCHN32Jiangsu„LMEXJALJalisco„KESP23Jaen„J#NLD0645Jacobswoude„IJPN03Iwate-Ken„H+GBRIOSIsles of Scilly„G'GBRIOWIsle of Wight„F#GBRIOMIsle of Man„E%JPN17Ishikawa-Ken„DITAISIsernia„CFRA38Isere„BUSAIAIowa„A)FRA37Indre et Loire„@FRA36Indre„?USAINIndiana„>ITAIMImperia„=USAILIllinois„<+FRA35Ille et Vilaine„;#NLD0353Ijsselstein„:%NLD0191Ijsselmuiden„9NLD0195Ijsselham„8USAIDIdaho„7#JPN08Ibaraki-Ken„6JPN28Hyogo-Ken„5NLD0925Hunsel„4CHN43Hunan„3/NLD0256Hummelo En Keppel„2NLD0677Hulst )iêÔ­š…nWB-þåθ˜€iV1íׯš…o\B,éѹ¤“|i…GBRLRNLarne…NLD0417Laren Nh…VENLALara…IRLLAOISLaois„NLD0416Langedijk„~NLD0325Langbroek„}NLD0415Landsmeer„|NLD0882Landgraaf„{FRA40Landes„zNLD1685Landerd„y!GBRLANCSLancashire„xMYSLBLabuan„wITASPLa Spezia„vESP26La Rioja„uARGLRLa Rioja„tBOLLPLa Paz„sARGLPLa Pampa„rESP15La Coruna„qITAAQL' Aquila„pJPN26Kyoto-Fu„o%JPN43Kumamoto-Ken"„n9NLD0542Krimpen Aan Den Ijssel„mHKGKKowloon„lNLD0682Kortgene„kNLD0588Korendijk„j/NLD0079Kollumerland C.A.„iJPN39Kochi-Ken„hNLD0804Klundert„gIRLKLKENYKilkenny„fIRLKLDAREKildare„eNLD0258Kesteren„dNLD0929Kessel„cIRLKERRYKerry„bNLD0257Kerkwijk„aNLD0928Kerkrade„`USAKYKentucky„_GBRKENTKent„^MYSKTKelantan„]MYSKDKedah„\NLD0537Katwijk„[NLD0678Kapelle (eéÖIJŸŠt^E' ôÛÀ©’xgT>)ÿãÍ·¡Šs]I0ÿçÒ¾«Žze…+NLD0262Lochem…*ITALILivorno…))NLD0140Littenseradiel…(NLD0808Lith…'NLD0553Lisse…&GBRLSBLisburn…%NLD0733Lingewaal…$%GBRLINCSLincolnshire…#NLD0418Limmen…"IRLLIMRCKLimerick…!BELLILimburg… GBRLMVLimavady…NLD0694Liesveld…NLD0807Lieshout…NLD0261Lienden…NLD0806Liempde…NLD1673Liemeer…'NLD0260Lichtenvoorde'…GCHLLOLib. Gral. Bernardo O'Higgins…CHN21Liaoning…NLD0327Leusden…ESP25Lerida…ESP24Leon…#NLD0082Lemsterland…NLD0995Lelystad…IRLLTRIMLeitrim…%NLD0548Leidschendam…!NLD0547Leiderdorp…NLD0546Leiden…)GBRLEICSLeicestershire… +NLD0081Leeuwarderadeel… !NLD0080Leeuwarden… NLD0326Leersum… NLD0545Leerdam… NLD0805Leende…NLD0022Leek…ITALCLecco…ITALELecce…ITALTLatina…!ESP35Las Palmas '[ïÚÁ¯’fK2ðÛ˰“}hUC2! ñÞ¾¡„gJ-óÖ¹¡v[…R%NLD0334Maartensdijk…QNLD0333Maarssen…PNLD0332Maarn…ONLD0811Maarheeze…N-USAZ3MD 60% local tax…M-USAZ4MD 58% local tax…L-USAZBMD 56% local tax…K-USAZ5MD 55% local tax…J-USAZ6MD 50% local tax…I-USAZAMD 48% local tax…H-USAZ7MD 40% local tax…G-USAZ9MD 35% local tax…F-USAZ8MD 20% local tax…E3USAZCMD 2.65 % local tax…DCHELULuzern…C#NLD0810Luyksgestel…BBELLXLuxemburg…ABELLULuik…@ESP27Lugo…?ITALULucca…>FRA48Lozere…=IRLLOUTHLouth…<USALALouisiana…;)GBRLOTHLothian Region…:)FRA47Lot et Garonne …9FRA46Lot…8NLD0168Losser…7CHLLLLos Lagos…6NLD0024Loppersum…5NLD0331Lopik…4!NLD0330Loosdrecht…3%NLD0809Loon Op Zand…2IRLLNGFRDLongford…1FRA45Loiret…0-FRA44Loire Atlantique…/FRA42Loire….%FRA41Loir et Cher…-NLD0329Loenen…,ITALOLodi (\çй¡ŠrYD$æÍ» zeQ<$ õãË·¢vcK,ñÞÉ´‘y\…z)NLD0993Meerlo-Wanssum…yNLD0420Medemblik …x9DEUMVMecklenburg Vorpommern…wIRLMEATHMeath…vFRA985Mayotte…uIRLMAYOMayo…tFRA53Mayenne…sNLD0264Maurik…rCHLMUMaule…q1BRAMSMato Grosso do Sul…p#BRAMTMato Grosso…oITAMTMatera…n'USAMAMassachusetts…mITAMSMassa…lUSAMDMaryland…kNLD0025Marum…j!FRA972Martinique…iFRA51Marne…hNLD0169Markelo…g!NLD0686Mariekerke…fNLD0936Margraten…eBRAMAMaranhao…dITAMNMantova…cCANMBManitoba…bFRA50Manche…aESP29Malaga…`)FRA49Maine et Loire…_USAMEMaine…^#GBRMFTMagherafelt(…]ICHLMAMagallanes y Antartica Chilena…\ESP28Madrid…[/NLD0812Made En Drimmelen…ZITAMCMacerata…Y!NLD0935Maastricht…XNLD0556Maassluis…WNLD0555Maasland…VNLD0263Maasdriel…UNLD1671Maasdonk…TNLD0934Maasbree…S!NLD0933Maasbracht 'léÔÁ­‘}cN;  íÛÆ®w\?&ýêȤ‹uaL4ïÜï–€l†!USAMTMontana† NLD0562Monster†IRLMONGHNMonaghan†VENMOMonagas†!NLD0816Moergestel†ITAMOModena†%JPN45Miyazaki-Ken†!JPN04Miyagi-Ken†USAMOMissouri†#USAMSMississippi†ARGMIMisiones†VENMIMiranda†USAMNMinnesota†%BRAMGMinas Gerais!†7NLD0265Millingen Aan De Rijn†3NLD0815Mill En Sint Hubert†ITAMIMilano†NLD0814Mierlo†JPN24Mie-Ken†GBRMDDSXMiddlesex† )NLD0688Middenschouwen† %NLD0559Middelharnis† !NLD0687Middelburg† 'GBRM GLAMMid Glamorgan† MEXMICHMichoacan†USAMIMichigan†FRA55Meuse†1FRA54Meurthe et Moselle†ITAMEMessina†!GBRMERSYDMerseyside†VENMEMerida†NLD0119Meppel†#NLD1987Menterwolde†ARGMZMendoza…'NLD0083Menaldumadeel…~ESP52Melilla…}MYSMLMelaka…|NLD0941Meijel…{NLD0938Meerssen 'nèȯš…q^I6ñØÆ³žŠu`>'úâÆ°š†sY?(ôÙÄ¥Œn†H/CANNLNewfoundland (NL)†G%CANNFNewfoundland†F1USAZ1New York, New York†EUSANYNew York†D+HKGNNew Territories†C+AUSNSWNew South Wales†B!USANMNew Mexico†A!USANJNew Jersey†@'USANHNew Hampshire†?'CANNBNew Brunswick†>USANVNevada†=ARGNQNeuquen†<CHENENeuenburg†;CHN15Neimenggu†:+MYSNSNegeri Sembilan†9NLD0304Neerijnen†8NLD0266Neede†7!NLD0946Nederweert†6NLD0643Nederlek†53NLD0426Nederhorst Den Berg†4USANENebraska†3MEXNAYNayarit†2ESP31Navarra†1JPN29Nara-Ken†0ITANANapoli†/BELNANamen†.%JPN42Nagasaki-Ken†-!JPN20Nagano-Ken†,NLD0425Naarden†+NLD0565Naaldwijk†*ESP30Murcia†)NLD0424Muiden†(GBRMYLMoyle†'FRA57Moselle†&MEXMORMorelos†%FRA56Morbihan†$!NLD0563Moordrecht†#/NLD0944Mook En Middelaar†"NLD0335Montfoort #iâȲ˜‚eF(èж£‹t]G0ûÝŧ_G4èȧˆi†k)GBRNTHUMBNorthumberland†j1AUSNTNorthern Territory†i-GBRNHANTSNorthamptonshire†h+GBRN YORKNorth Yorkshire†g!GBRNDNNorth Down†f%USANDNorth Dakota†e)USANCNorth Carolina†dNLD0120Norg†cGBRNORFLKNorfolk†b3DEUNWNordrhein Westfalen†aFRA59Nord†`NLD0577Nootdorp†_+NLD0576Noordwijkerhout†^NLD0575Noordwijk†]+NLD0171Noordoostpolder†\1NLD0529Noorder-Koggenland†[CHN64Ningxia†ZNLD0268Nijmegen†YNLD0267Nijkerk†XNLD0121Nijeveen†WNLD0104Nijefurd†V#JPN15Niigata-Ken†UFRA58Nievre†T#NLD0170Nieuwleusen†SNLD0569Nieuwkoop$†R=NLD0567Nieuwerkerk Aan Den Ijss†Q!NLD0356Nieuwegein†P+NLD0818Nieuw-Vossemeer†O-NLD0571Nieuw-Lekkerland†N)NLD0817Nieuw-Ginneken†MNLD0412Niedorp†L'DEUNINiedersachsen†KCHENWNidwalden†J%GBRNTANewtownabbey†I-GBRNYMNewry and Mourne &gÞ¿Ÿ‡tM3êÓÁ®‡s_J5ôÝ̳ž†nYA)ïÕÁ¥~g‡NLD0692Oostburg$‡=NLD0825Oost-,West-En Middelbeer‡+BELOVOost Vlaanderen‡CANONOntario‡ #NLD0881Onderbanken‡ NLD0175Ommen‡ GBROMHOmagh‡ NLD0174Olst‡ NLD0173Oldenzaal‡NLD0269Oldebroek‡USAOKOklahoma‡#JPN47Okinawa-Ken‡#JPN33Okayama-Ken‡JPN44Oita-Ken‡!NLD0824Oisterwijk‡FRA60Oise‡NLD0823Oirschot‡USAOHOhio†IRLOFFALYOffaly†~!NLD0579Oegstgeest†}NLD0122Odoorn†|CHEOWObwalden†{NLD0429Obdam†zMEXOAXOaxaca$†yAUSAO1OR-Multnomah Co Income Tax†xNLD0951Nuth†wITANUNuoro†vNLD0302Nunspeet†u%CANNUNunavut (NU)†t%CANNNNunavut (NN)†s!MEXNLNuevo Leon†r'VENNENueva Esparta$†q=NLD0820Nuenen,Gerwen En Nederwe†pITANONovara†o#CANNSNova Scotia†n1FRA988Nouvelle Caledonie†m+GBRNOTTSNottinghamshire†l7CANNTNorthwest Territories )jãʰ‘zbM4!ùâÑ¿ª˜~\?& óÛÁ®›†r`F5!üêоª•|j‡:MYSPRPerak‡9%USAPAPennsylvania‡8NLD0765Pekela‡7NLD0124Peize‡6ITAPVPavia‡5'FRA62Pas de Calais‡4ITAPRParma‡3FRA75Paris‡2BRAPRParana‡1BRAPBParaiba‡0BRAPAPara‡/#NLD0590Papendrecht‡.BOLPAPando‡-ITAPAPalermo‡,ESP34Palencia‡+MYSPHPahang‡*ITAPDPadova‡)#GBROXONOxfordshire‡(NLD0589Oudewater‡'NLD0644Ouderkerk‡&%NLD0437Ouder-Amstel‡%!NLD0830Oudenbosch‡$)NLD0584Oud-Beijerland‡#3NLD0831Oud En Nieuw Gastel‡"#NLD0829Ossendrecht‡!NLD0828Oss‡ JPN27Osaka-Fu‡BOLOROruro‡FRA61Orne‡GBRORKOrkney Is‡ITAOROristano‡ESP32Orense‡USAOROregon‡!NLD0086Opsterland‡NLD0432Opmeer‡NLD0176Ootmarsum‡NLD0431Oostzaan‡-NLD0085Ooststellingwerf‡#NLD0580Oostflakkee‡!NLD0826Oosterhout‡)NLD0123Oosterhesselen (jíÖ¯›†t\K7ÿéÒ¾«–„cI5ûâʶ¡‰hH4! òת—ƒj‡b!NLD0835Ravenstein‡aITARARavenna‡`ITARGRagusa‡_NLD0834Raamsdonk‡^NLD0177Raalte‡]%MEXQROOQuintana Roo‡\MEXQROQueretaro‡[!AUSQLDQueensland‡ZCANQCQuebec‡YCHN63Qinghai‡X3FRA66Pyrenees Orientales‡W5FRA64Pyrenees Atlantiques‡V#FRA63Puy de Dome‡UNLD0273Putten‡TNLD0833Putte‡SNLD0439Purmerend‡R%MYSPGPulau Pinang‡Q3USA$UPRPuerto Rico Federal‡P#USAPRPuerto Rico‡OMEXPUEPuebla‡N#NLD0832Prinsenbeek‡M5CANPEPrince Edward Island‡LITAPOPrato‡KGBRPOWYSPowys‡JBOLPOPotosi‡IITAPZPotenza‡H!VENPOPortuguesa‡GITAPNPordenone‡F!ESP36Pontevedra‡E3FRA987Polynesie Francaise‡DITAPTPistoia‡CITAPIPisa‡BNLD0594Pijnacker‡ABRAPIPiaui‡@ITAPCPiacenza‡?ITAPEPescara‡>ITAPSPesaro‡=ITAPGPerugia‡<!BRAPEPernambuco‡;MYSPLPerlis &aéʪ‰pVA)ÿêι Žu]K3èÒ´¡cM2ïÒ¾­˜uaˆBRARRRoraima ˆ5NLD0838Roosendaal En NispenˆBRARORondoniaˆITARMRomaˆNLD0126Roldeˆ)NLD1670Roggel En NeerˆNLD0957RoermondˆNLD1669RoerdalenˆNLD0125Roden‡)BRARJRio do Janeiro‡~ARGRNRio Negro‡}/BRARSRio Grande Do Sul‡|3BRARNRio Grande Do Norte‡{ITARNRimini‡z+NLD0603Rijswijk (Z.H.)‡yNLD0178Rijssen‡x!NLD0841Rijsbergen‡wNLD1672Rijnwoude‡v#NLD0196Rijnwaarden‡uNLD0602Rijnsburg‡tITARIRieti‡sNLD0837Riethoven‡r!NLD0597Ridderkerk‡qFRA69Rhone‡p%USARIRhode Island‡oNLD0340Rhenen‡n+DEURPRheinland Pfalz‡mNLD0275Rheden‡lNLD0836Reusel‡kFRA974Reunion‡jNLD0339Renswoude‡iNLD0274Renkum‡h#NLD0703Reimerswaal‡g!NLD1661Reiderland‡f5CHLRMRegion Metropolitana‡e3ITAREReggio Nell' Emilia‡d1ITARCReggio Di Calabria‡cNLD0595Reeuwijk (fæÏº¢w_I4îÙdz˜ƒ]E/ ôßè‘zeE/íÒ¹¥Œyfˆ0ITASVSavonaˆ/FRA73Savoieˆ.!NLD0604Sassenheimˆ-ITASSSassariˆ,%CANSKSaskatchewanˆ+%NLD0704Sas Van Gentˆ*FRA72Sartheˆ)MYSSRSarawakˆ()FRA71Saone et Loireˆ'BRASPSao Pauloˆ&3ARGSESantiago del Esteroˆ%ARGSFSanta Feˆ$!BOLSCSanta Cruzˆ#!ARGSCSanta Cruzˆ")BRASCSanta Catarinaˆ!)MEXSLPSan Luis Potosˆ ARGSLSan LuisˆARGSJSan JuanˆARGSASaltaˆITASASalernoˆESP37Salamancaˆ#JPN11Saitama-Ken#ˆ=FRA975Saint Pierre et MiquelonˆJPN41Saga-Kenˆ)DEUSTSachsen AnhaltˆDEUSNSachsenˆMYSSBSabahˆDEUSLSaarlandˆNLD0278RuurloˆGBRRUTLNDRutlandˆ!NLD0128RuinerwoldˆNLD0127RuinenˆNLD0840RucphenˆNLD0277RozendaalˆNLD0600Rozenburgˆ ITARORovigoˆ NLD0599Rotterdamˆ NLD0276Rossumˆ NLD0839Rosmalenˆ IRLROSCMNRoscommon '[êÓ¼¡ŠlT=#êк§“x]B-ïÛlV>% öä˶šx[ˆW)NLD0846Sint OedenrodeˆV3NLD0845Sint MichielsgestelˆU'NLD1691Sint AnthonisˆTMEXSINSinaloaˆS!NLD0965SimpelveldˆRITASISienaˆQCHN51SichuanˆP!GBRSHROPSShropshireˆO%JPN22Shizuoka-KenˆN#JPN32Shimane-KenˆMJPN25Shiga-KenˆL#GBRSHETShetland IsˆKCHN14ShanxiˆJCHN31ShanghaiˆICHN37ShandongˆH#CHESHShaffhausenˆGCHN61ShaanxiˆFESP41SevillaˆENLD0964SevenumˆDBRASESergipeˆCMYSSLSelangorˆB)FRA77Seine et MarneˆA)FRA93Seine St Denisˆ@)FRA76Seine Maritimeˆ?ESP40Segoviaˆ>CHESZSchwyzˆ=NLD0444Schoorlˆ<#NLD0608Schoonhovenˆ;#NLD0129Schoonebeekˆ:1DEUSHSchleswig Holsteinˆ9#NLD0607Schipluidenˆ8NLD0962Schinnenˆ7NLD0844Schijndelˆ6+NLD0088Schiermonnikoogˆ5NLD0606Schiedamˆ4%NLD0279Scherpenzeelˆ3NLD0458Schermerˆ2NLD0039Scheemdaˆ1NLD0441Schagen %ká̶œˆoZA-ûçÓ½§}`L8& ïÖ¶–|_H' óÕ·Ÿ…kˆ|#NLD0851Steenbergenˆ{#NLD0532Stede BroecˆzNLD0180Staphorstˆy+NLD0850Standdaarbuitenˆx'GBRSTAFFSStaffordshireˆw#NLD0037Stadskanaalˆv#NLD0179Stad Deldenˆu5ESP38Sta.Cruz de Tenerifeˆt!CHESGSt. Gallenˆs)NLD0849Sprang-Capelleˆr#NLD0612Spijkenisseˆq+GBRSYORKSSouth Yorkshireˆp+GBRS GLAMSouth Glamorganˆo%USASDSouth Dakotaˆn)USASCSouth Carolinaˆm+AUSSASouth AustraliaˆlESP42SoriaˆkMEXSONSonoraˆjITASOSondrioˆi)NLD0848Son En BreugelˆhFRA80SommeˆgGBRSOMERSomersetˆfNLD0847SomerenˆeCHESOSolothurnˆdNLD0342SoestˆcNLD0091SneekˆbNLD0131Smildeˆa)NLD0090Smallingerlandˆ`NLD0713Sluisˆ_!NLD0040Slochterenˆ^IRLSLIGOSligoˆ]!NLD0610Sliedrechtˆ\NLD0130Sleenˆ[#NLD0051SkarsterlanˆZNLD0968SittardˆYITASRSiracusaˆX-NLD0712Sint Philipsland (fçÏ»¥jTB+ýçÒ¾«’~iVE)ýàʳ‡t[C1æË¸¥Œzf‰$NLD0448Texel‰#USATXTexas‰"!NLD0854Teteringen‰!CHETITessin‰ ESP44Teruel‰%NLD0093Terschelling‰7FRA90Territoire de Belfort&‰CFRA984Terres Australes Francaises‰ITATRTerni‰NLD0715Terneuzen‰!NLD0853Terheijden‰ITATETeramo‰NLD0480Ter Aar‰USATNTennessee‰NLD0009Ten Boer‰NLD0976Tegelen‰)GBRTAYSTayside Region‰AUSTASTasmania‰ESP43Tarragona‰+FRA82Tarn et Garonne‰FRA81Tarn‰BOLTATarija‰CHLTATarapaca‰ ITATATaranto‰ !MEXTAMPTamaulipas‰ CHN71Taiwan‰ VENTATachira‰ MEXTABTabasco‰NLD0975Swalmen‰NLD0974Susteren‰GBRSURREYSurrey‰GBRSUFFKSuffolk‰VENSUSucre‰NLD0617Strijen ‰1GBRSTRATHStrathclyde Region‰NLD0973Stramproy‰GBRSTBStrabaneˆNLD0971Steinˆ~NLD0181Steenwijkˆ}!NLD0280Steenderen *pë×홆iS9" ôÚŲŸ‡p\F3 öÞʱšzcP9'ùéׯ°œ‡p‰N!FRA95Val d'Oise‰MFRA84Vaculuse‰LNLD0981Vaals‰KNLD0344Utrecht‰JUSAUTUtah‰INLD0184Urk ‰HCHEURUri‰GNLD0451Uithoorn‰FNLD0450Uitgeest‰EITAUDUdine‰DNLD0857Udenhout‰CNLD0856Uden‰BNLD0282Ubbergen‰A/NLD0737Tytsjerksteradiel‰@IRLTYRONETyrone‰?#GBRT&WTyne & Wear‰>ARGTUTucuman‰=NLD0183Tubbergen‰<VENTRTrujillo‰;ITATSTrieste‰:ITATVTreviso‰9ITATNTrento‰8MYSTRTrengganu‰7ITATPTrapani‰6!JPN16Toyama-Ken‰5#JPN31Tottori-Ken‰4ITATOTorino‰3ESP45Toledo‰2JPN13Tokyo-To‰1'JPN36Tokushima-Ken‰0#JPN09Tochigi-Ken‰/BRATOTocantins‰.MEXTLAXTlaxcala‰-IRLTPPRRYTipperary‰,NLD0855Tilburg‰+-ARGTFTierra del Fuego‰*NLD0281Tiel‰)CHN12Tianjin‰(DEUTHThuringen‰'CHETGThurgau‰&NLD0977Thorn‰%NLD0716Tholen (ZçѼœzaF/õ߯²…p]I1òÝÈ´¡zeK7!òײ‰uZ‰v)BELVBVlaams Brabant‰uESP48Vizcaya‰tITAVTViterbo‰sUSAVAVirginia"‰r9USA$UVIVirgin Islands Federal‰q)USAVIVirgin Islands‰p'NLD0863Vierlingsbeek‰oFRA86Vienne‰nAUSVICVictoria‰mITAVIVicenza‰l'ITAVVVibo Valentia‰kNLD0620Vianen$‰j=NLD0862Vessem,Wintelre En Knegs‰iITAVRVerona‰hUSAVTVermont‰gITAVCVercelli‰fITAVBVerbania‰eMEXVERVeracruz‰dNLD0984Venray‰cNLD0983Venlo‰bNLD0454Venhuizen‰aITAVEVenezia‰`FRA85Vendee‰_NLD0453Velsen‰^NLD0861Veldhoven‰]NLD0860Veghel‰\NLD0717Veere‰[!NLD0345Veenendaal‰ZNLD0047Veendam‰YITAVAVarese ‰XFRA83Var‰W!CHLVAValparaiso‰V!ESP47Valladolid‰U%NLD0858Valkenswaard‰T!NLD0720Valkenisse‰S3NLD0994Valkenburg A/D Geul‰R/NLD0619Valkenburg (Z.H.)‰QESP46Valencia‰PNLD0283Valburg‰O%FRA94Val de Marne (]æÍ·˜kR>%÷Ýȳ Œr^L7ìÓº§‰s[>'úàǯ˜„p]ŠNLD0292WehlŠNLD0457WeespŠNLD0988WeertŠNLD0188WeerseloŠNLD0852WaterlandŠ!NLD0630WateringenŠIRLWTRFRDWaterfordŠNLD0629WassenaarŠNLD0869WaspikŠ!USAWAWashingtonŠ%GBRWARWKSWarwickshireŠNLD0291WarnsveldŠNLD0628WarmondŠ-FRA986Wallis et FutunaŠCHEVSWallisŠ%JPN30Wakayama-KenŠ!NLD0289WageningenŠ #NLD0627WaddinxveenŠ NLD0867WaalwijkŠ 'BELWBWaals BrabantŠ NLD0866WaalreŠ CHEVDWaadtŠNLD0865VughtŠ#NLD0186VriezenveenŠNLD0133VriesŠFRA88VosgesŠNLD0286VordenŠNLD0285VoorstŠ#NLD0626VoorschotenŠNLD0625VoorhoutŠNLD0624Voorburg‰!NLD0986Voerendaal‰~NLD0623Vlist‰}!NLD0718Vlissingen‰|NLD0864Vlijmen‰{NLD0096Vlieland‰z-NLD0347Vleuten-De Meern‰yNLD0132Vledder‰x!NLD0048Vlagtwedde‰w#NLD0622Vlaardingen #[èίqU;àÇ­qT: çζžˆpT>* éзž‰o[ŠANLD0295WischŠ@#NLD0294WinterswijkŠ?NLD0053WinsumŠ>!NLD0052WinschotenŠ=GBRWILTSWiltshireŠ<!NLD0872WillemstadŠ;3MYSWPWilayah PersekutuanŠ:1NLD0352Wijk Bij DuurstedeŠ9NLD0190WijheŠ8NLD0296WijchenŠ7'NLD0463WieringermeerŠ6NLD0462WieringenŠ5NLD0189WierdenŠ4IRLWCKLOWWicklowŠ3IRLWXFORDWexfordŠ2!NLD0614WestvoorneŠ1-NLD0098WeststellingwerfŠ0IRLWSTMTHWestmeathŠ/#NLD0726WestkapelleŠ.#NLD0293WestervoortŠ-)NLD0725WesterschouwenŠ,'GBRW ISLSWestern IslesŠ+/AUSWAWestern AustraliaŠ*#NLD0871WesterhovenŠ)!NLD0134WesterborkŠ(/NLD0558Wester-KoggenlandŠ')GBRWYORKSWest YorkshireŠ&+BELWVWest VlaanderenŠ%'USAWVWest VirginiaŠ$#GBRW SUSXWest SussexŠ#'GBRWSTMIDWest MidlandsŠ"/NLD0668West Maas En WaalŠ!)GBRW GLAMWest GlamorganŠ #NLD0459WervershoofŠNLD0870Werkendam (nêл¡‹vZA(üâİš…rY?%óá̺§’{dK8  õßÈ´ŸˆnŠi#NLD0878ZevenbergenŠhNLD0299ZevenaarŠgNLD0298ZelhemŠfNLD0355ZeistŠeNLD0050ZeewoldeŠdNLD0478ZeevangŠcNLD0707ZederikŠbESP50ZaragozaŠaNLD0473ZandvoortŠ`ESP49ZamoraŠ_!NLD0297ZaltbommelŠ^MEXZACZacatecasŠ]NLD0479ZaanstadŠ\FRA78YvelinesŠ[CHN53YunnanŠZCANYTYukonŠYMEXYUCYucatanŠXFRA89YonneŠW/USAZ2Yonkers, New YorkŠVVENYAYaracuyŠU'JPN19Yamanashi-KenŠT'JPN35Yamaguchi-KenŠS%JPN06Yamagata-KenŠRCHN54XizangŠQCHN65XinjiangŠPCHN91XianggangŠOUSAWYWyomingŠN+NLD0683WymbritseradielŠM#NLD0710WunseradielŠLNLD0875WouwŠK!NLD0874WoudrichemŠJ!NLD0351WoudenbergŠI!NLD0880WormerlandŠH)GBRWORWorcestershireŠGNLD0466WognumŠFNLD0632WoerdenŠE#NLD0873WoensdrechtŠDNLD0990WittemŠC#NLD0727WissenkerkeŠBUSAWIWisconsin 9ÚÅ­™€fV/èÖÀ­—~hN9Š|NLD0193ZwolleŠ{#NLD0642ZwijndrechtŠzNLD0138ZweelooŠy!NLD0192ZwartsluisŠxNLD0301ZutphenŠwCHEZHZurichŠvNLD0879ZundertŠuVENZUZuliaŠtNLD0137ZuidwoldeŠsNLD0136ZuidlarenŠrNLD0056Zuidhorn$Šq=NLD0996Zuidelijke Ijsselmeerpol ŠpCHEZGZugŠo#NLD0638ZoeterwoudeŠn!NLD0637ZoetermeerŠmNLD0476ZijpeŠlNLD0732ZierikzeeŠkCHN33Zhejiang#Šj;NLD1666Zevenhuizen-Moerkapelle F{)kÃFÒ  1 3#!Secret Job PostingITAvailable only to registered users on the site. And it works!2008-02-26 11:44:31Better WorkRestricted6F 3!OwnerCodeFinanceTester2008-02-28 19:42:54PozziCoRestricted6& !W3!Top SecretFinanceIf you tell anyone about this job posting, we will hunt you down. We're Google, we can find anyone. 2008-02-28 19:35:18GoogleRestricted6% ![3MoneyMakerFinanceNeeded to post a job to Finance This is it I know, need to be more creative on these stupid posts2008-02-25 20:45:05PozziCoPublic6; /3Company PurchaserITResponsible for buying other companies, making their owners rich, and then destroying any remaining value in the company.2008-02-25 20:22:45MicrosoftPublic1P A3Test JobsITReally Awesome Opportunity2008-02-25 20:13:53GooglePublic2 )3ERP SpecialistITLooking for an applicant who lives, breathes, sleeps and dreams ERP2008-02-24 14:41:55MicrosoftPublic1 g“ÞgFFFFFFF˜# 32008-03-09 01:43:13Private4e# 32008-03-09 01:43:05Private42# 32008-03-09 01:40:06Private4ÿ# 32008-03-09 01:39:46Private4Ì# 32008-03-09 01:39:13Private4™# 32008-03-09u 3#CEOExecutiveWe need someone, anyone, to come in and guide the company2008-03-09 12:09:29Better WorkPublic62 )]3#!Java ArchitectFinanceThe Java Architect is responsible for getting the CFO all of the coffee he needs to get through the day!2008-02-29 17:50:45Better WorkRestricted6‚j 3„U3#Senior Java AnalystITBuild Java Apps Must have worked with Java for 45 years. java Java JAVA I need to add more to this description in an effort to get it long enough to see if the first 100 character limit display will work as coded within the view. Do you think this is long enough? Yeah, probably.2008-02-29 17:45:37Better WorkPublic6 x¡`;qL(Âx'A‘uƒ31Computer Programmer ResumeRichard Anderson 1234, West 67 Street, Carlisle, MA 01741, (123)-456 7890. Objective A challenging position as #= 32008-03-11 17:57:09Public4#< 32008-03-11 17:52:44Public5?; )3stud2's resumedo stuffstuff2008-03-10 17:51:56Public16#: 32008-03-10 17:16:01Public4"9 32008-03-10 17:09:09Public#8 32008-03-09 14:40:33Public9"7 -G-3web2py developer15 years of experience with web2py, I was an expert before the application was even developedweb2py expert 2008-03-09 09:26:56Public10#6 32008-03-09 09:23:01Public8#5 32008-03-09 07:20:37Public9?4 )!3Another ResumeMore stuffmore2008-03-09 07:17:16Public9]3 1%E3Scott's 1st ResumeDoing stuff.stuff programming web2py'ing2008-03-09 05:35:48Public9 œÌ—Déž[ô¨4èœOS, Solaris, SCCS. Employment History 2000 - Present Engineer Arteck Industries, Scranton, PA Worked on product planJ M %MP4MP4Applicant96e814dc4f7f2fa179d6d8f82d3b7e2f1555-555-5555TrueJ M %MP2MP2Applicante7e417b5fd5de0693bf7dd10c0b8c54f1555-555-5555Truer 1EM %Scott Santarromanascott.santarromana@gmail.comApplicant21f63c6e971cd913a9c147e8652ca6591555-555-5555TrueJ M %MP1MP1Applicant9601d479a63f5b8b475646581fc1bc101555-555-5555Truee %7M %MichaelPozziMikePozzi@hotmail.comApplicantc90a918b859bd1e56cf99af6246b128e1555-555-5555TrueA 'M MPMPAdministratorc90a918b859bd1e56cf99af6246b128e11TrueI #M recrec@rec.recRecruiter0b2c082c00e002a2f571cbe3406442391555TrueY /'M adminadmin@admin.adminAdministrator21232f297a57a5a743894a0e4a801fc315551212TrueQ )M ken1ken1@ken1.ken1Applicantd4e4832675533a8540712c04a600439f15551212True3 M mike18126e7bd3f84b3f3e4df094def5b7de1True2 M kenf632fa6f8c3d5f551c5df867588381ab1Truee study at Oxford University. Pursued the M.Phil in Social Sciences. Gene Landis Award for Outstanding Teaching 1995 & 1997: Selected by the student body of York College. Experience 1999 - Present Assistant Professor, Sociology - University of Pittsburgh, Pittsburgh, PA Taught such notable courses as "Intro to Sociology", "Sociology of Inequality", and "The McDonaldization of Society". 1995 - 1998 Lecturer, York College, York, PA Education Ph.D, Sociology, 1994 Penn State University, State College, PA Specialization: Global inequality, sociology of marriage M.Phil, Social Sciences, 1990 Oxford College, Oxford, UK B.A. Sociology, Literature 1988 Cornell University Ithaca, NY Selected Publications "Building More Prisons: Retribution or Rehabilitation?", American Journal of Sociology. Worthington Press, June 1995 "Big Mac Nation", published in The Globalization Reader. Bretton-Woods Press. August, 1997.sociology, marriage, professor, rhodes, 2008-03-01 01:03:08Publicchelor of Engineering (Electronics and Power). Operating Systems/Languages - MS-DOS, Systems Operation - .NET Framework - Visual Basic 6.0 - C++, Programming - Solaris 7.0. - Windows 95/98/NT 4.0/2000/XP - UNIX, Shell Script Programming Experience Web Tech, Ashville, NC Software Engineer, 1998 - Present Developing web based applications and sites. Followed ISO 9000: 2001 Standards for complete lifecycle of projects in all applications and sites. Version One Software, Charlotte, NC Production Consultant, 1995 - 1998 Responsible for Team co-ordination for the project and delivery of the project. Built web-based applications in ASP, which involved a Search application, User registration and session management and a product catalogue. Built C/S based Banking application in Visual Basic. Education University of North Carolina, Chapel Hill, NC B.S., Computer Science, 1994software, asp, javascript, iis, esm, karrox, c-dac, c++, solaris, windows, unix2008-03-01 01:06:31Public ÙÙ[Šw A‘uƒ31Computer Programmer ResumeRichard Anderson 1234, West 67 Street, Carlisle, MA 01741, (123)-456 7890. Objective A challenging position as a Software Engineer and possibility of career growth. Keywords UNIX, C, C++, Visual Basic, M68000 Development, DEC, VAX, System Servers, SGI, Intel 8086 Assembler, VMS, Pascal, LISP, FORTRAN, Basic, Macro-II. ClearCas=‹ -• ]32Professor ResumeDavid Warren 1823 Stackhouse Ln. Akron, OH 44301 David@Warren.Warren Home (817) 555-0021 Office (817) 555-9010 __________________ Objective A tenure track position in a well estabilished sociology department, which will allow for adequate time and funding to be directed toward research. Summary of Achievements Rhodes Scholar 1988 - 1990: Awarded two years of post-graduat> ’’Œy -—y+33Developer ResumeMiranda Atkins 709 West Orleans St. Ashville, NC 28814 (914) 555-0919 matkins@earthlink.net __________________ Objective To obtain a job as a software developer for company specializing in consumer software. Highlights - Proficient in Visual Basic, ASP, Java Script, VB Script and various Web Technologies. - Experienced in Web Application Development & Site Designing, - Microsoft Certified Professional (IIS 4.0). - Enterprise Systems Management (ESM) training on Sun Solaris 7.0 - Certified in Hardware and Windows NT Networking (KarROX). - Diploma in Advanced Computing (C-DAC) & Ba?nEœg‚+31Computer Programmer Resume 2Richard Anderson 1234, West 67 Street, Carlisle, MA 01741, (H >FGDEHI?A@>=grammer position within a dynamic organisation EXPERIENCE: Braintree Computer Services Providers Inc., Boston, MA 1999 - 2002 Computer Programmer Provided advanced service to clients, ensuring excellent applications design and programming. Created and migrated all database objects through various development, testing, and production environments. Resolved relational database problems using IBM and BMC utilities. Maintained, developed, analysed, and tested programs using Cobol, JCL, and ISPF. Provided maintenance and support to business clients. Maintained, developed, analysed, and tested inventory, traffic, logistics, and merchandising applications using Cobol, DB2 Universal Database, JCL, and ISPF/TSO within production/team retail environment. Performed computer operator responsibilities during the LPAR file maintenance project using MVS, JCL, Zeke and CA7. Assisted full time computer operators with tape backups and problem resolutio 9£Gë•9|/MM%stud2stud2@stud2.stuZ /M %stud2stud2@stud2.stud2Applicantc91ef9377233978d6a30efb51096a70d1555-555-5555TrueT )M studentstud@stud.studApplicantb9ac0988cdd72928bc964d81d5858bb715551212TrueZ /M %Scottscott.scott@scottRecruiter21f63c6e971cd913a9c147e8652ca6591555-555-5555TrueZ /M %Scottscott@scott.scottRecruiter21f63c6e971cd913a9c147e8652ca6591555-555-5555True[ %#M %Test StudentTestStudentApplicant6ba89ab41823af9b65ea5d233031b9f81999-999-9999Trueresent Managed a twelve member team that designed and implemented universal high speed Gigabit ATM switch fabrics for high speed ALX product line. Responsibilities included hardware design and product verification. Also responsible for EMC/EMI/RFI standards, compliance and testing. Responsible for product support for manufacturing and field service operations. JLC Design, Utica, NY Mechanical Engineer, 1994 - 1998 Responsible for designing products and concepts under non-disclosure agreements for clients on cross-functional design teams which include Sr. Mechanical, Electrical, and Product Designers. Responsibilities included plastics part design with 3D solid and surface models in Pro/Engineer, concept development, product strategy, and presentation preparation. Education Houston University, Houston, TX B.S., Mechanical Engineering, 1994 References Available upon request. gigabit, emc, emi, rfi, concept development, product strategy, presentation preparation2008-03-01 01:11:46Public §ƒ_H312008-03-09 01:02:03Public$312008-03-09 03:59:45PublicnEU399NewResumeResume Body would go in hereWinner Awesome Java CEO Potential2008-03-02 10:34:55Public/¢3q35Programmer ResumeTeresa Seguso * 501 Hampton Dr. * Lakeview, KY * 40990 * (502) 555-9223 Summary of Qualifications Eight years of experience in programming, system development and system administration. Extensive UNIX background. ComprehensiF‹X G• ;34Mechanical Engineering ResumeAmy Smith 123 Main Street Atlanta, Georgia 30339 Home: (555) 555-1234 Cell: (555) 555-1235 asmith@sample~resume.com Objective Challenging and rewarding upper-level position in a growth-oriented organization, which offers diverse job responsibility in mechanical engineering and will fully utilize both my technical and managerial abilities. Employment History Sprint Corporation, Syracuse, NY Project Manager, 1998 - PDGve knowledge of personal computer software, hardware and peripherals. Well-versed in delivering technical presentations. Outstanding analytical skills, Seasoned Internet user. Programming Languages C/C++, Pascal, Empress 4GL, SQL, Embedded SQL, FORTRAN, Perl, BASIC Platforms IRIS workstayion, MS DOS, MS Windows, Interactive 386 UNIX, Macintosh, VAX Work Experience Programmer/Analyst, New WorldSystem, Whitehall, NY (July 1993-current) Enhance and support a relational database application used by the U.S. Government. Handled software develoment, database administration, system administration, future requirements planning, PC hardware/software support, user support and daily operations. Implemented major improvements in automation of administrative and operational procedures, including distributed-database updates and data integrity checks, data transmission processes, managerial status reports and data backup, which allows programmers more time to work on upgrade and development tasks. reduced clients operating and maintenance costs by porting code from mainframe to code on microcomputer systems. Worked with Interactive UNIX and a variety of other languages and platforms to complete project. Programmer/Designer, Lincoln Research Center, Sun City, FL (May 1988-July 1993) Investigated new fuselage design techniques for advanced aircraft design using computational fluid dynamics and unstructured-mesh computer modeling of aircraft geometries. Conducted a space vehicle packaging study using specialized CAD software and computational hypersonicaerodynamic models. Worked as part of a research team studying turboprop configurations in a low-speed wind tunnel, which led to improved aircraft design and performance. Upgraded and corrected a sonic-boom prediction program, which provided more accurate measurements and information. Education B.S. in Aeronautics, Massachusetts Institute of Technology, May 1988, Cum Laudeunix, pascal, fortran, perl, basic, windos, MS DOS2008-03-01 01:18:58PublicI123)-456 7890. OBJECTIVE: Seeking a Computer Programmer position within a dynamic organisation EXPERIENCE: Braintree Computer Services Providers Inc., Boston, MA 1999 - 2002 Computer Programmer Provided advanced service to clients, ensuring excellent applications design and programming. Created and migrated all database objects through various development, testing, and production environments. Resolved relational database problems using IBM and BMC utilities. Maintained, developed, analysed, and tested programs using Cobol, JCL, and ISPF. Provided maintenance and support to business clients. Maintained, developed, analysed, and tested inventory, traffic, logistics, and merchandising applications using Cobol, DB2 Universal Database, JCL, and ISPF/TSO within production/team retail environment. Performed computer operator responsibilities during the LPAR file maintenance project using MVS, JCL, Zeke and CA7. Assisted full time computer operators with tape backups and problem resolution. 1997 - 1999 Computer Programmer Design, programme and maintain company business applications. Define new application programmes and determine solutions. Install software on System 36. Provided programming support and maintenance to programme users. EDUCATION: University of Massachusetts (U-Mass), Boston, MA 1993 - 1997 Masters in Computer Science TECHNICAL COMPETENCIES: Software: VSAM, MS OFFICE, CMS, DATAEXPERT and PANVALET / Hardware: IBM 3090, IBM 36, IBM 370/145/155 Systems: OS-MFT, OS-VS, DOS, DOS-VM, Windows 95, Windows 3.1, and MVS. Languages: COBOL, FOCUS, FOXPRO, VISUAL BASIC, MICROSOFT, DATAPOINT, and ASSEMBLER. ADDITIONAL INFORMATION: Hobbies include Water sports, , Horse riding ,Sailing and Yogacobol, jcl, ispf, mvs, jcl, zeke, ca7, vsam, ms office, cms, dataexpert, panvalet, focus, foxpro, visual basic, microsoft, datapoint, assembler2008-03-01 01:08:04Privatedatabases/f6db3e6e66dc0b6aea6b47a87ef29c1f_applicants.table0000666000102300010230000000076410766561234023176 0ustar00korekore00000000000000(dp1 S'city' p2 S'CHAR(32)' p3 sS'updated' p4 S'TIMESTAMP' p5 sS'user_id' p6 S'CHAR(32)' p7 sS'zip' p8 S'CHAR(32)' p9 sS'resume' p10 S'TEXT' p11 sS'address1' p12 S'CHAR(32)' p13 sS'address2' p14 S'CHAR(32)' p15 sS'phone_country_code' p16 S'CHAR(32)' p17 sS'id' p18 S'INTEGER PRIMARY KEY AUTOINCREMENT' p19 sS'access' p20 S'CHAR(32)' p21 sS'phone' p22 S'CHAR(32)' p23 sS'state' p24 S'CHAR(32)' p25 sS'country' p26 S'CHAR(32)' p27 sS'email' p28 S'CHAR(32)' p29 sS'applicant_name' p30 S'CHAR(32)' p31 s.databases/f6db3e6e66dc0b6aea6b47a87ef29c1f_applied_for.table0000666000102300010230000000032510765006113023302 0ustar00korekore00000000000000(dp1 S'position_id' p2 S'CHAR(32)' p3 sS'applied' p4 S'TIMESTAMP' p5 sS'applicant' p6 S'CHAR(32)' p7 sS'id' p8 S'INTEGER PRIMARY KEY AUTOINCREMENT' p9 sS'applicant_name' p10 S'CHAR(32)' p11 s.databases/f6db3e6e66dc0b6aea6b47a87ef29c1f_categories.table0000666000102300010230000000020010756330166023143 0ustar00korekore00000000000000(dp1 S'id' p2 S'INTEGER PRIMARY KEY AUTOINCREMENT' p3 sS'cat_name' p4 S'CHAR(32)' p5 sS'cat_descr' p6 S'TEXT' p7 s.databases/f6db3e6e66dc0b6aea6b47a87ef29c1f_company.table0000666000102300010230000000051210766561234022475 0ustar00korekore00000000000000(dp1 S'profile' p2 S'TEXT' p3 sS'city' p4 S'CHAR(32)' p5 sS'zip' p6 S'CHAR(32)' p7 sS'address1' p8 S'CHAR(32)' p9 sS'address2' p10 S'CHAR(32)' p11 sS'state' p12 S'CHAR(32)' p13 sS'company_name' p14 S'CHAR(32)' p15 sS'country' p16 S'CHAR(32)' p17 sS'owner' p18 S'CHAR(32)' p19 sS'id' p20 S'INTEGER PRIMARY KEY AUTOINCREMENT' p21 s.databases/f6db3e6e66dc0b6aea6b47a87ef29c1f_country.table0000666000102300010230000000021310760353030022513 0ustar00korekore00000000000000(dp1 S'country_name' p2 S'CHAR(32)' p3 sS'id' p4 S'INTEGER PRIMARY KEY AUTOINCREMENT' p5 sS'country_code' p6 S'CHAR(32)' p7 s.databases/f6db3e6e66dc0b6aea6b47a87ef29c1f_position_requirements.table0000666000102300010230000000021110756330167025470 0ustar00korekore00000000000000(dp1 S'position_id' p2 S'CHAR(32)' p3 sS'requirement' p4 S'CHAR(32)' p5 sS'id' p6 S'INTEGER PRIMARY KEY AUTOINCREMENT' p7 s.databases/f6db3e6e66dc0b6aea6b47a87ef29c1f_positions.table0000666000102300010230000000052610766561234023063 0ustar00korekore00000000000000(dp1 S'category' p2 S'CHAR(32)' p3 sS'description' p4 S'TEXT' p5 sS'title' p6 S'CHAR(32)' p7 sS'timestamp' p8 S'TIMESTAMP' p9 sS'public' p10 S'CHAR(1)' p11 sS'access' p12 S'CHAR(32)' p13 sS'company_name' p14 S'CHAR(32)' p15 sS'restricted' p16 S'CHAR(1)' p17 sS'owner' p18 S'CHAR(32)' p19 sS'id' p20 S'INTEGER PRIMARY KEY AUTOINCREMENT' p21 s.databases/f6db3e6e66dc0b6aea6b47a87ef29c1f_referrals.table0000666000102300010230000000025410756330167023015 0ustar00korekore00000000000000(dp1 S'applicant' p2 S'CHAR(32)' p3 sS'user_id' p4 S'CHAR(32)' p5 sS'id' p6 S'INTEGER PRIMARY KEY AUTOINCREMENT' p7 sS'date_referred' p8 S'TIMESTAMP' p9 s.databases/f6db3e6e66dc0b6aea6b47a87ef29c1f_resumes.table0000666000102300010230000000041310766561234022512 0ustar00korekore00000000000000(dp1 S'body' p2 S'TEXT' p3 sS'updated' p4 S'TIMESTAMP' p5 sS'user_id' p6 S'CHAR(32)' p7 sS'title' p8 S'CHAR(32)' p9 sS'applicant_id' p10 S'CHAR(32)' p11 sS'access' p12 S'CHAR(32)' p13 sS'keywords' p14 S'TEXT' p15 sS'id' p16 S'INTEGER PRIMARY KEY AUTOINCREMENT' p17 s.databases/f6db3e6e66dc0b6aea6b47a87ef29c1f_state.table0000666000102300010230000000025610760353030022137 0ustar00korekore00000000000000(dp1 S'state_code' p2 S'CHAR(32)' p3 sS'id' p4 S'INTEGER PRIMARY KEY AUTOINCREMENT' p5 sS'country_code' p6 S'CHAR(32)' p7 sS'state_name' p8 S'CHAR(32)' p9 s.databases/f6db3e6e66dc0b6aea6b47a87ef29c1f_user.table0000666000102300010230000000054610760353030021777 0ustar00korekore00000000000000(dp1 S'name' p2 S'CHAR(32)' p3 sS'phone_country_code' p4 S'CHAR(32)' p5 sS'user_type' p6 S'CHAR(32)' p7 sS'id' p8 S'INTEGER PRIMARY KEY AUTOINCREMENT' p9 sS'phone' p10 S'CHAR(32)' p11 sS'verification' p12 S'CHAR(32)' p13 sS'password' p14 S'CHAR(32)' p15 sS'email' p16 S'CHAR(32)' p17 sS'authorized' p18 S'CHAR(32)' p19 s.databases/sql.log0000666000102300010230000000766410765006113014273 0ustar00korekore00000000000000timestamp: 2008-02-18T10:21:10.531000 CREATE TABLE user( id INTEGER PRIMARY KEY AUTOINCREMENT, name CHAR(32), email CHAR(32), user_type CHAR(32), password CHAR(32), verification CHAR(32) ); success! timestamp: 2008-02-18T10:21:10.640000 CREATE TABLE company( id INTEGER PRIMARY KEY AUTOINCREMENT, company_name CHAR(32), profile TEXT ); success! timestamp: 2008-02-18T10:21:10.7