# Professonal Database Construction - well payed

**URL:** <https://forum.kirupa.com/t/professonal-database-construction-well-payed/50184>\
**Category:** hiring\
**Created:** [April 30, 2004, 12:53am UTC](https://forum.kirupa.com/t/professonal-database-construction-well-payed/50184 "2004-04-30T00:53:40Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ryall](https://avatars.discourse-cdn.com/v4/letter/r/53a042/32.png) [@Ryall](https://forum.kirupa.com/u/Ryall)\
**Post date:** [April 30, 2004, 12:53am UTC](https://forum.kirupa.com/t/professonal-database-construction-well-payed/50184/1 "2004-04-30T00:53:40Z")

</div>

All work must be of professional quality! And must be completed in a timely manner. If you are interested contact me ASAP at:

[rwalsh@grafikdesigns.com](mailto:rwalsh@grafikdesigns.com)

Here is an outline of the project…

CENTRUM ONLINE PROJECT DATABASE

IDEA: Create an online database accessible by login with restrictive access to certain parts of the information, that will maintain and report traffic, unit, contract, customer and construction information.

TIMEFRAME: We are looking at an immediate need for this technology. The sooner it is put into use, the better. We have 2 projects opening in 3 weeks, and would like to put them in a database as soon as possible, as to reduce redundant work.

COST: We are looking to dedicate around $30,000.

TECHNOLOGIES APPLIED: We like the way a system functions under the following framework, but would be open to other suggestions: Microsoft .NET framework ([ASP.NET](http://ASP.NET), [VB.NET](http://VB.NET)), Microsoft SQL Server, COM, COM, Windows 2000 Advanced Server, Microsoft Internet Information Server (IIS), XML, XSLT, AT&T Frame Relay.

INFORMATIONAL NEEDS FOR THIS PROJECT:  
WEB ACCESS  
DATABASE  
Unit Information  
Traffic Information  
Contract Information  
Customer Information  
Construction Information  
CONTRACT GENERATION  
REPORTS  
QUERIES

GENERAL OUTLINE OF WHAT IS NEEDED-

WEB ACCESS  
a. Access by Web Browser  
The Database needs to be accessible by web browser, from any location.  
b. Login Restrictions  
Need to have restricted access to this information as it is very sensitive  
c. Restricted Access to Certain Information  
Not everybody is to have full access to all information. Permissions will vary person to person.

DATABASE (The following is a list of the information we would need to track)  
d. Unit Information

1. Unit Number
2. Unit Pricing
3. Square footage
4. Outdoor square footage
5. Ownership Percentage
6. Assesments
7. Taxes
8. Floor
9. Floorplan
10. View
11. 
# Bedrooms
12. 
# Bathrooms
13. 
# Family Room
14. 
# Den
15. Finish Level
16. Amenities
17. Parking Space(s)  
a. Building
18. Floorplan Upgrade
19. Storage Space

e. Traffic Information

1. Date of Visit
2. Name(s)
3. Address
4. Street
5. City
6. State
7. Zip
8. Phone
9. Home
10. Work
11. Email address
12. Demographics
13. Source
14. Bedrooms
15. Move date
16. Price Range
17. Ownership

f. Contract Information

1. Customer
2. Name
3. Address
4. Phone  
a. Fax
5. Email
6. SSN
7. Unit #
8. Amenities purchased (Parking/Storage/Floorplan)
9. Space #
10. Location
11. Price
12. Milestones/Dates
13. Contract date
14. Contract approval date
15. Attorney approval date
16. Mortgage contingency date
17. Drop dead date
18. Estimate closing date
19. Actual closing date
20. Broker
21. Broker name
22. Broker Agency
23. Agency address
24. Agency phone/fax/email
25. Broker MLS#
26. Agency MLS#
27. Broker Commission rate
28. Broker incentives received
29. Attorney
30. Attorney name
31. Attorney address
32. Attorney phone/fax/email
33. Monies
34. Deposit  
a. Amount due  
b. Amount received   
c. Date received
35. Installment(s)  
a. Amount due  
b. Amount received   
c. Date due   
d. Date received
36. Promssory Note  
a. Amount due  
b. Amount received   
c. Date due   
d. Date received
37. House Salesperson(s)
38. Name(s)
39. Credits
40. Upgrades at close  
a. Monetary amount   
b. Specific items (W/D, balcony…)
41. Employee credit
42. Referral credit
43. Recessions
44. Unit
45. Customer
46. Date
47. Reason

g. Construction Information (TBD)

1. Milestones
2. Selections

CONTRACTS  
h. Contract Generation (fills in merge fields from the legal contract)  
i. Including Riders

REPORTS  
j. Sales Summary

1. Traffic by source
2. Contract Activity for the last 7 days
3. Contracts prior
4. Contracts written
5. Contracts rescinded
6. Total contracts
7. Contract by type
8. Reservations outstanding (#/$)
9. Contracts under review (#/$)
10. Contracts binding (#/$)
11. Total units purchased (#/$)
12. Total garages purchased (#/$)
13. Total both unit and garage price (#/$)
14. Total Units
15. Units Sold (#)
16. Units Unsold (#)
17. Breakdown by Bedroom
18. Total (#/$/%)
19. Sold (#/$/%)
20. Available (#/$/%)
21. Breakdown by View
22. Total (#/$/%)
23. Sold (#/$/%)
24. Available (#/$/%)
25. Breakdown by Floorplan
26. Total (#/$/%)
27. Sold (#/$/%)
28. Available (#/$/%)
29. Breakdown by phase/building
30. Total (#/$/%)
31. Sold (#/$/%)
32. Available (#/$/%)
33. Note field

k. Sales Report (TBD)

l. Customer Report (TBD)

m. Traffic Report

1. Traffic from past week
2. Date
3. Name
4. Address
5. Phone
6. House salesperson
7. Rating
8. Source
9. Price range
10. Bedrooms needed
11. Comments

n. Letters

1. Thank you card (traffic)
2. Contract to Attorney
3. Congrats/Contract to Buyer
4. Memo to Attorney
5. Memo to Bank
6. Earnest Money request to BuyeR

o. MISC. reports to be determined at later date.

QUERIES  
p. Need the ability to select any criteria and view it online.
