Need to generate fictitious phone bill files

Create six months of billsfor every person in the data files - MIT, Daisy Troop, Choir, and Apartment Building)

[Note: 80% of numbers called should be in 617 or 480 area code

20% of numbers called should be randomly generated for any area code:

http://www.nanpa.com/npa/AllNPAs_620.zip is the North American Numbering Plan Administration database of valid codes]

(Date:

(June 1, 2006 - December 31, 2006))

(Field Names:

(Customer Info:

Subject phone number

Name (First, MI, Last)

Street Address

City

State

Zip

SSN last 4

Other tel numbers)

(Phone call Info:

Date

Time

Duration

Number Called))