This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
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
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
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
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
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
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
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
REQUEST
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
11
DATE
4/2/2012
EQUIPMENT TY
oven
PROBLEM
temperature fluctuating
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
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
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
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
EQUIPMENT REPAIR FREQUENC
EQUIPMENT TYPE
FREQUENCY OF
REPAIR REQUESTS
roofing
4
plumbing
3
Page 1 of 1
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
REQUEST DATE
Monday, April 2, 2012
Account Priority
$200,000
Constant Carriers
31 Carmine Le
20111-1212
Carver, NJ
Page 2 of 5
REQUEST DATE
Tuesday, April 3, 2012
Account Priority
$94,000
Briggs Bakery
123 Boggs Street
11200-1234
Brimstone, CT
Page 3 of 5
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
Trusted by Thousands of
Students
Here are what students say about us.
Resources
Company
Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.