ACCT_ID
NAME
ADDR
CITY
STATE
ZIP
DOLLAR_SIZE
CONTACT_FIRST
CONTACT_LAST
PHONE
FAX
1
Able Association
123 Axion Street
Albertown
NY
11444-4444
$50,000.00
Alison
Ableson
(209) 111-1111
(219) 111-2222
2
Briggs Bakery
123 Boggs Street
Brimstone
CT
11200-1234
$94,000.00
Barry
Berryman
(210) 111-1212
(210) 111-1213
3
Constant Carriers
31 Carmine Le
Carver
NJ
20111-1212
Carl
Compress
(202) 123-1222
(202) 123-1234
5
Eagle Engineers
Eagle Park
Edmonton
CT
11222-2313
$45,000.00
Eddie
Exeter
(210) 212-2233
(210) 143-2122
tblREQUEST
Page 1
REQUEST_NUM
ACCT_ID
REQ_DATE
EQUIP_TYPE
1
1
4/4/2012
furnace
2
1
4/5/2012
plumbing
3
1
4/1/2012
air conditioner
4
2
4/4/2012
roofing
7
2
4/4/2012
furnace
8
3
4/4/2012
9
4
4/1/2012
roofing
5
4/3/2012
freezer
1
4/2/2012
plumbing
2
4/5/2012
window
3
4/2/2012
furnace
tblREQUEST
Page 2
PROBLEM
PRICE
no heat
$0.00
can’t turn water off in 3rd floor kitchen
$0.00
air conditioner filter missing
$0.00
lead over store sign
$0.00
store too cold
$0.00
need to check for spring
$0.00
wind broke off shingles
$0.00
leaking a blue fluid
$0.00
faucet in storage room is leaking
$0.00
rock went thru plate glass
$0.00
pilot light is off
$0.00
NAME BIGCONTACT CITYSTATE ADDR CITY STATE ZIP CONTACT_FIRST CONTACT_LAST DOLLAR_SIZE PHONE
Able Association Alison Ableson Albertown, NY 123 Axion Street Albertown NY 11444-4444 Alison Ableson $50,000.00 (209) 111-1111
qryEQUIPMENT_FREQUENCY
Page 1
EQUIP_TYPE
EQUIPMENT TYPE FREQUENCY
roofing
4
plumbing
3
oven
3
2
windows
1
ACCT_ID
NAME
ADDR
CITY
STATE
ZIP
BIG_CITY
DOLLAR_SIZE
REQ_DATE
EQUIP_TYPE
CONTACT_FIRST
CONTACT_LAST
BIG_CONTACT
PROBLEM
1
Able Association
123 Axion Street
Albertown
NY
11444-4444
Albertown, NY 114444444
$50,000.00
4/1/2012
air conditioner
Alison
Ableson
Alison Ableson
air conditioner filter missing
1
Able Association
123 Axion Street
Albertown
NY
11444-4444
Albertown, NY 114444444
$50,000.00
4/2/2012
plumbing
Alison
Ableson
Alison Ableson
faucet in storage room is leaking
1
Able Association
123 Axion Street
Albertown
NY
11444-4444
Albertown, NY 114444444
$50,000.00
4/4/2012
furnace
Alison
Ableson
Alison Ableson
no heat
1
Able Association
123 Axion Street
Albertown
NY
11444-4444
Albertown, NY 114444444
$50,000.00
4/5/2012
plumbing
Alison
Ableson
Alison Ableson
can’t turn water off in 3rd floor kitchen
2
Briggs Bakery
123 Boggs Street
Brimstone
CT
11200-1234
Brimstone, CT 112001234
$94,000.00
4/3/2012
freezer
Barry
Berryman
Barry Berryman
freezer door stuck
2
Briggs Bakery
123 Boggs Street
Brimstone
CT
11200-1234
Brimstone, CT 112001234
$94,000.00
4/3/2012
oven
Barry
Berryman
Barry Berryman
oven overheating
2
Briggs Bakery
123 Boggs Street
Brimstone
CT
11200-1234
Brimstone, CT 112001234
$94,000.00
4/4/2012
furnace
Barry
Berryman
Barry Berryman
store too cold
ACCT_ID
1
NAME
Able Association
ADDRESS
123 Axion Street
ZIP
11444-444
DOLLAR_SIZE
$50,000
FIRST
Alison
LAST
Ableson
PHONE
(209) 111-111
FAX
(219) 111-2222
REQUEST
CITY:
Albertown
STATE
1
DATE
4/4/2012
EQUIPMENT TY
furnace
PROBLEM
no heat
EQUIPMENT TY
air conditioner
PROBLEM
air conditioner filter missing
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
14
DATE
4/2/2012
ACCT_ID
NAME
Briggs Bakery
ADDRESS
123 Boggs Street
ZIP
11200-123
DOLLAR_SIZE
$94,000
Barry
Berryman
PHONE
(210) 111-121
FAX
(210) 111-1213
CITY:
Brimstone
STATE
NY
REQUEST
4
DATE
4/4/2012
EQUIPMENT TY
roofing
PROBLEM
lead over store sign
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
5
DATE
4/3/2012
oven
PROBLEM
oven overheating
REP_ID
RESOLUTION
#Name?
6
DATE
EQUIPMENT TY
freezer
PROBLEM
freezer door stuck
$0.00
REP_ID
RESOLUTION
#Name?
7
DATE
EQUIPMENT TY
PROBLEM
store too cold
ACCT_ID
3
NAME
Constant Carriers
DOLLAR_SIZE
FIRST
Carl
LAST
REQUEST
CHARGE
REP_ID
RESOLUTION
#Name?
2
DATE
EQUIPMENT TY
plumbing
PROBLEM
can’t turn water off in 3rd floor kitchen
REP_ID
RESOLUTION
#Name?
3
DATE
8
DATE
4/4/2012
EQUIPMENT TY
air conditioner
PROBLEM
need to check for spring
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
16
DATE
4/5/2012
REQUEST
9
DATE
4/1/2012
EQUIPMENT TY
roofing
PROBLEM
wind broke off shingles
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
10
DATE
4/5/2012
EQUIPMENT TY
PROBLEM
sash is loose
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
DATE
PROBLEM
REP_ID
RESOLUTION
5
Eagle Engineers
Eagle Park
11222-231
Eddie
Exeter
(210) 212-223
(210) 143-2122
REQUEST
CITY:
STATE
DATE
EQUIPMENT TY
REP_ID
RESOLUTION
DATE
furnace
PROBLEM
pilot light is off
4
Darning Drapers
1234 Dante Ave
12345-684
(209) 123-432
(201) 123-4322
CITY:
STATE
11
DATE
4/2/2012
EQUIPMENT TY
oven
PROBLEM
temperature fluctuating
DATE
EQUIPMENT TY
REP_ID
RESOLUTION
1
DATE
4/4/2012
EQUIPMENT TY
furnace
PROBLEM
no heat
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
2
DATE
4/5/2012
EQUIPMENT TY
roofing
PROBLEM
lead over store sign
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
5
DATE
4/3/2012
EQUIPMENT TY
oven
PROBLEM
oven overheating
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
6
DATE
4/3/2012
EQUIPMENT TY
freezer
PROBLEM
freezer door stuck
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
7
DATE
4/4/2012
EQUIPMENT TY
furnace
PROBLEM
store too cold
RESOLUTION
8
DATE
EQUIPMENT TY
air conditioner
PROBLEM
need to check for spring
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
EQUIPMENT TY
roofing
PROBLEM
wind broke off shingles
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
10
DATE
4/5/2012
EQUIPMENT TY
window
PROBLEM
sash is loose
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
11
DATE
4/2/2012
EQUIPMENT TY
oven
PROBLEM
temperature fluctuating
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
12
DATE
4/3/2012
EQUIPMENT TY
freezer
PROBLEM
RESOLUTION
EQUIPMENT TY
PROBLEM
can’t turn water off in 3rd floor kitchen
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
3
DATE
EQUIPMENT TY
PROBLEM
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
14
DATE
4/2/2012
EQUIPMENT TY
plumbing
PROBLEM
faucet in storage room is leaking
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
15
DATE
4/5/2012
EQUIPMENT TY
window
PROBLEM
rock went thru plate glass
EQUIPMENT TY
oven
PROBLEM
smoke in room
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
19
DATE
4/5/2012
EQUIPMENT TY
PROBLEM
CHARGE
REP_ID
20
DATE
4/2/2012
EQUIPMENT TY
furnace
PROBLEM
pilot light is off
CHARGE
REP_ID
RESOLUTION
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
DATE
4/5/2012
roofing
check gutters
CHARGE
$0.00
REP_ID
RESOLUTION
#Name?
18
DATE
ACCOUNTS by VALUE
DOLLAR_SIZE
NAME
CONTACT
PHONE
ADDRESS
CITY STATE
ZIP
$200,000
Constant Carriers
Carl Compress
(202) 123
31 Carmine Le
Carver, NJ
20111-1212
Page 1 of 1
Eagle Engineers
Eddie Exeter
(210) 212
Eagle Park
Edmonton, CT
11222-2313
EQUIPMENT REPAIR FREQUENC
EQUIPMENT TYPE
FREQUENCY OF
REPAIR REQUESTS
roofing
4
plumbing
3
Page 1 of 1
3
2
REQUEST DATE
Sunday, April 1, 2012
Account Priority
$200,000
Constant Carriers
31 Carmine Le
20111-1212
Carver, NJ
plumbing
drains are clogged
Page 1 of 5
Able Association
123 Axion Street
11444-4444
air conditioner
air conditioner filter missing
REQUEST DATE
Monday, April 2, 2012
Account Priority
$200,000
Constant Carriers
31 Carmine Le
20111-1212
Carver, NJ
Page 2 of 5
Eagle Engineers
Eagle Park
11222-2313
REQUEST DATE
Tuesday, April 3, 2012
Account Priority
$94,000
Briggs Bakery
123 Boggs Street
11200-1234
Brimstone, CT
Page 3 of 5
Account Priority
$60,000
12345-6849
REQUEST DATE
Wednesday, April 4, 2012
Account Priority
$200,000
Constant Carriers
31 Carmine Le
20111-1212
Carver, NJ
Page 4 of 5
REQUEST DATE
Thursday, April 5, 2012
Account Priority
$200,000
Constant Carriers
31 Carmine Le
20111-1212
Carver, NJ
Page 5 of 5
Darning Drapers
1234 Dante Ave
12345-6849
Account Priority
$45,000
Eagle Engineers
Eagle Park
11222-2313