18096 MS SQL Database Modification

Please review and provide completion date: I need to modify the enterprise database version I purchased from [login to view URL] You will need to build a mail merge program that will select the contacts from the scContacts Table, to include a contacts Info as selected, then you will need to perform a JOIN on the table. Also, there is no centralize HTML page that contains the links to the 5 products, since each product represents a job role in a scalable format. I want to be logged into more than one app, by only logging into one app. You need to copy the cookie setting lines from the [login to view URL] page of the apps so I am be automatically logged into them, then paste those cookie setting lines into the [login to view URL] of the app (softcontact) that will be the master login app. Also add the fields listed below along with a layout to accept the info online. Lets review: 1-mail merge should be a script that conforms with the surfhighway script 2-data filed listed below that need to be included, I need the database modified and a laytout to accept all the new fileds. 3- script needs to allow additional fields to the layout and database from the online interface 4-surfhighway enterprise is a modular database and has a login page for each script but uses one database, I need one centralize page to login to all here are all the logins Product URL: SoftContact [login to view URL] SoftContact Admin [login to view URL] ProjectSoft [login to view URL] ProjectSoft Admin [login to view URL] BillingTime [login to view URL] BillingTime Admin [login to view URL] BroadWalk [login to view URL] HelpCentric [login to view URL] HelpCentricExampleSites [login to view URL] helpCentricWorkQueues [login to view URL] AirTime [login to view URL] AirTimeAdmin [login to view URL] List of fields are in two formats for your convenience: Public/Private Record Manager Borrower Employer
Borrower Name
Borrower Current Address
Borrower New Address
Co-Bow Current Address
Borrower Current City
Borrower Current State
Borrower Current Zip

Country
ID/Status
Borrower Day Phone Borrower Fax Borrower Salutation
Last Meeting
Last Reach
Last Attempt
Letter Date
Borrower Title
Co-Bow Current State
Last Results
Referral Type
First Name
Last Name
Borrower Day Phone Ext.
Borrower Evening Phone Ext.
Co-Bow Current City
Co-Bow Day Phone Co-Bow Day Phone Ext.
Department
Record Creator
Owner
Borrower Pronoun
Borrower Evening Phone Borrower Cell Phone Closing Cost Discount
Borrower New City
Borrower New State
Borrower New Zip
Co-Bow Name
Co-Bow Salutation
Co-Bow Pronoun
Co-Bow Evening Phone Ext.
Co-Bow Evening Phone Co-Bow Cell Phone Co-Bow Fax Co-Bow E-Mail Address
Co-Bow Current Zip
Co-Bow New Address
Co-Bow New City
Co-Bow New State
Co-Bow New Zip
Co-Bow Title
Co-Bow Employer
Borrower SSN
Co-Bow SSN
Borrower DOB
Co-Bow DOB
Borrower Marital Status
Co-Bow Marital Status
Borrower Spouse Name
Co-Bow Spouse Name
Borrower Anniversary
Co-Bow Anniversary
Borrower Hobby/Interest
Co-Bow Hobby/Interest
Borrower Child 1 Name
Borrower Child 2 Name
Borrower Child 3 Name
Co-Bow Child 1 Name
Co-Bow Child 2 Name
Co-Bow Child 3 Name
Borrower Child 1 DOB
Borrower Child 2 DOB
Borrower Child 3 DOB
Co-Bow Child 1 DOB
Co-Bow Child 2 DOB
Co-Bow Child 3 DOB
Borrower Child 1 Sex
Borrower Child 2 Sex
Borrower Child 3 Sex
Co-Bow Child 1 Sex
Co-Bow Child 2 Sex
Co-Bow Child 3 Sex
Borrower Sex
Co-Bow Sex
Property Address
Property Age
Property Value
Property City
Property State
Property Zip
Appraiser Name
Mortgage Purpose
Loan Program
Loan Type
Loan Amount
Loan Term (Months)
Loan Rate Loan Payment
Loan Number
Loan Officer
Loan Officer Phone Loan Processor
Loan Processor Phone Closing LTV
Refi-Trigger Rate Loan Stage
Pre-Qual Date
Application Date
Loan Submission Date
Loan Approval Date
Closed Date
Property Sq Footage
Loan Officer Phone Ext
Loan Processor Phone Ext
Borrower Assistant Name
Borrower Assistant Phone Referral Last Rcvd On
Referrals YTD
Referrals Last Year
Borrower Empl Address
Co-Bow Empl Address
Borrower Empl City
Co-Bow Empl City
Co-Bow Employer State
Borrower Empl State
Borrower Empl Zip
Co-Bow Empl Zip
Borrower HR Mgr First Name
Co-Bow HR Mgr First Name
Borrower HR Mgr Last Name
Co-Bow HR Mgr Last Name
Borrower HR Mgr Phone Co-Bow HR Mgr Phone Borrower HR Mgr Ext
Co-Bow HR Mgr Ext
Co-Bow HR Mgr Addres
Borrower HR Mgr Address
Borrower HR Mgr City
Co-Bow HR Mgr City
Borrower HR Mgr State
Co-Bow HR Mgr State
Borrower HR Mgr Zip
Co-Bow HR Mgr Zip
Referral First Name
Referral Last Name
Referral Day Phone Referral Evening Phone Referral Phone Ext
Referral Cell Phone Referral Fax Referral E-Mail Address
Referral Address
Referral City
Referral State
Referral Zip
Selling Agent First Name
Selling Agent Last Name
Selling Agent Company
Selling Agent Address
Selling Agent City
Selling Agent State
Selling Agent Zip
Selling Agent Phone Selling Agent Ph Ext
Selling Agent Cell Phone Selling Agent Fax Selling Agent E-Mail Address
Listing Agent First Name
Listing Agent Last Name
Listing Agent Company
Listing Agent Address
Listing Agent City
Listing Agent State
Listing Agent Zip
Listing Agent Phone Listing Agent Ph Ext
Listing Agent Cell Phone Listing Agent Fax Listing Agent E-Mail Address
LA Sales Mgr First Name
LA Sales Mgr Last Name
LA Sales Mgr Company
LA Sales Mgr Address
LA Sales Mgr City
LA Sales Mgr State
LA Sales Mgr Zip
LA Sales Mgr Phone LA Sales Mgr Ph Ext
LA Sales Mgr Cell Phone LA Sales Mgr Fax LA Sales Mgr E-Mail Address
SA Sales Mgr First Name
SA Sales Mgr Last Name
SA Sales Mgr Company
SA Sales Mgr Address
SA Sales Mgr City
SA Sales Mgr State
SA Sales Mgr Zip
SA Sales Mgr Phone SA Sales Mgr Ph Ext
SA Sales Mgr Cell Phone SA Sales Mgr Fax SA Sales Mgr E-Mail Address
Sellers Attorney First Name
Sellers Attorney Last Name
Sellers Attorney Firm
Sellers Attorney Address
Sellers Attorney City
Sellers Attorney State
Sellers Attorney Zip
Sellers Attorney Phone Sellers Attorney Ph Ext
Sellers Attorney Cell Phone Sellers Attorney Fax Sellers Attorney E-Mail Address
Buyers Attorney First Name
Buyers Attorney Last Name
Buyers Attorney Firm
Buyers Attorney Address
Buyers Attorney City
Buyers Attorney State
Buyers Attorney Zip
Buyers Attorney Phone Buyers Attorney Ph Ext
Buyers Attorney Fax Buyers Attorney Cell Phone Buyers Attorney E-Mail Address
Seller First Name
Seller Last Name
Seller Phone Sellers Ph Ext
Seller Address
Seller City
Seller State
Seller Zip
Seller Fax Seller Cell Phone Seller E-Mail Address
Accountant First Name
Accountant Last Name
Accountant Phone Accountant Ph Ext
Accountant Address
Accountant City
Accountant State
Accountant Zip
Accountant Fax Accountant E-Mail Address
Accountant Cell Phone Borrower Assistant Phone Ext.
Create Date
Edit Date
Merge Date
E-mail Login
E-mail System
or this format if it is eaisier "Public/Private","Record Manager","Borrower Employer","Borrower Name","Borrower Current Address","Borrower New Address", "Co-Bow Current Address","Borrower Current City","Borrower Current State","Borrower Current Zip","Country","ID/Status", "Borrower Day Phone","Borrower Fax","Borrower Salutation","Last Meeting","Last Reach","Last Attempt","Letter Date", "Borrower Title","Co-Bow Current State","Last Results","Referral Type","First Name","Last Name", "Borrower Day Phone Ext.", "Borrower Evening Phone Ext.","Co-Bow Current City","Co-Bow Day Phone","Co-Bow Day Phone Ext.","Department", "Record Creator","Owner","Borrower Pronoun","Borrower Evening Phone","Borrower Cell Phone","Closing Cost Discount", "Borrower New City","Borrower New State","Borrower New Zip","Co-Bow Name","Co-Bow Salutation","Co-Bow Pronoun","Co-Bow Evening Phone Ext.","Co-Bow Evening Phone","Co-Bow Cell Phone","Co-Bow Fax","Co-Bow E-Mail Address","Co-Bow Current Zip","Co-Bow New Address","Co-Bow New City","Co-Bow New State","Co-Bow New Zip","Co-Bow Title","Co-Bow Employer","Borrower SSN","Co-Bow SSN","Borrower DOB","Co-Bow DOB","Borrower Marital Status","Co-Bow Marital Status","Borrower Spouse Name","Co-Bow Spouse Name","Borrower Anniversary","Co-Bow Anniversary","Borrower Hobby/Interest","Co-Bow Hobby/Interest","Borrower Child 1 Name","Borrower Child 2 Name","Borrower Child 3 Name","Co-Bow Child 1 Name","Co-Bow Child 2 Name","Co-Bow Child 3 Name","Borrower Child 1 DOB","Borrower Child 2 DOB","Borrower Child 3 DOB","Co-Bow Child 1 DOB","Co-Bow Child 2 DOB","Co-Bow Child 3 DOB","Borrower Child 1 Sex","Borrower Child 2 Sex","Borrower Child 3 Sex","Co-Bow Child 1 Sex","Co-Bow Child 2 Sex","Co-Bow Child 3 Sex","Borrower Sex","Co-Bow Sex","Property Address", "Property Age","Property Value","Property City","Property State","Property Zip","Appraiser Name","Mortgage Purpose", "Loan Program","Loan Type","Loan Amount","Loan Term (Months)","Loan Rate","Loan Payment","Loan Number","Loan Officer", "Loan Officer Phone","Loan Processor","Loan Processor Phone","Closing LTV","Refi-Trigger Rate","Loan Stage", "Pre-Qual Date","Application Date","Loan Submission Date","Loan Approval Date","Closed Date","Property Sq Footage", "Loan Officer Phone Ext","Loan Processor Phone Ext","Borrower Assistant Name","Borrower Assistant Phone", "Referral Last Rcvd On","Referrals YTD","Referrals Last Year","Borrower Empl Address","Co-Bow Empl Address", "Borrower Empl City","Co-Bow Empl City","Co-Bow Employer State","Borrower Empl State","Borrower Empl Zip", "Co-Bow Empl Zip","Borrower HR Mgr First Name","Co-Bow HR Mgr First Name","Borrower HR Mgr Last Name", "Co-Bow HR Mgr Last Name","Borrower HR Mgr Phone","Co-Bow HR Mgr Phone","Borrower HR Mgr Ext", "Co-Bow HR Mgr Ext","Co-Bow HR Mgr Addres","Borrower HR Mgr Address","Borrower HR Mgr City","Co-Bow HR Mgr City", "Borrower HR Mgr State","Co-Bow HR Mgr State","Borrower HR Mgr Zip","Co-Bow HR Mgr Zip","Referral First Name", "Referral Last Name","Referral Day Phone","Referral Evening Phone","Referral Phone Ext","Referral Cell Phone", "Referral Fax","Referral E-Mail Address","Referral Address","Referral City","Referral State","Referral Zip", "Selling Agent First Name","Selling Agent Last Name","Selling Agent Company","Selling Agent Address", "Selling Agent City","Selling Agent State","Selling Agent Zip","Selling Agent Phone","Selling Agent Ph Ext", "Selling Agent Cell Phone","Selling Agent Fax","Selling Agent E-Mail Address","Listing Agent First Name", "Listing Agent Last Name","Listing Agent Company","Listing Agent Address","Listing Agent City", "Listing Agent State","Listing Agent Zip","Listing Agent Phone","Listing Agent Ph Ext", "Listing Agent Cell Phone","Listing Agent Fax","Listing Agent E-Mail Address","LA Sales Mgr First Name", "LA Sales Mgr Last Name","LA Sales Mgr Company","LA Sales Mgr Address","LA Sales Mgr City","LA Sales Mgr State", "LA Sales Mgr Zip","LA Sales Mgr Phone","LA Sales Mgr Ph Ext","LA Sales Mgr Cell Phone","LA Sales Mgr Fax", "LA Sales Mgr E-Mail Address","SA Sales Mgr First Name","SA Sales Mgr Last Name","SA Sales Mgr Company", "SA Sales Mgr Address","SA Sales Mgr City","SA Sales Mgr State","SA Sales Mgr Zip","SA Sales Mgr Phone", "SA Sales Mgr Ph Ext","SA Sales Mgr Cell Phone","SA Sales Mgr Fax","SA Sales Mgr E-Mail Address", "Sellers Attorney First Name","Sellers Attorney Last Name","Sellers Attorney Firm", "Sellers Attorney Address","Sellers Attorney City","Sellers Attorney State","Sellers Attorney Zip", "Sellers Attorney Phone","Sellers Attorney Ph Ext","Sellers Attorney Cell Phone","Sellers Attorney Fax", "Sellers Attorney E-Mail Address","Buyers Attorney First Name","Buyers Attorney Last Name", "Buyers Attorney Firm","Buyers Attorney Address","Buyers Attorney City","Buyers Attorney State", "Buyers Attorney Zip","Buyers Attorney Phone","Buyers Attorney Ph Ext","Buyers Attorney Fax", "Buyers Attorney Cell Phone","Buyers Attorney E-Mail Address","Seller First Name", "Seller Last Name","Seller Phone","Sellers Ph Ext","Seller Address","Seller City", "Seller State","Seller Zip","Seller Fax","Seller Cell Phone","Seller E-Mail Address", "Accountant First Name","Accountant Last Name","Accountant Phone","Accountant Ph Ext", "Accountant Address","Accountant City","Accountant State","Accountant Zip","Accountant Fax", "Accountant E-Mail Address", "Accountant Cell Phone","Borrower Assistant Phone Ext.","Create Date","Edit Date","Merge Date", "E-mail Login","E-mail System