Closed

Update MySQL database and web interface

This project was awarded to omtechnologies for $450 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$250 - $750 USD
Total Bids
27
Project Description

There have been the following changes to the ISSR table:

-added an additional field to the right of "ISSR_SIC_CD" (which appears on the Public Company screen of the MySQL database as "SIC Code") called "ISSR_IND_SCTR_NM." This field should be added with the same type of partial completion text box above it to the public company screen to the right of "SIC Code" and be labeled "SIC Description." This field should also appear in the "Company Details" sub-screen underneath "SIC Code."

-populated 4 fields to the right of ISSR_FYE; 1) ISSR_LRG_ACCLRTD_FLR_IN, 2) ISSR_ACCLRTD_FLR_IND, 3) ISSR_SML_RPTG_CPNY_IN, and 4) ISSR_WLL_KNWN_SND_ISSR_IN. These are true/false indicators that should be shown in the "view details" sub-screen of the Public Company screen underneath the "Fiscal Year End" field in the "Company Details" box..

-I removed one of the address fields so now there are only 3, but you will need to combine the address fields as you did before for the new issuers (see next point).

-There are several hundred new issuers that will need to be added but of course all of the IDs stay the same for the old ones - I assigned IDs to the new ones.

I also removed the "ISSR_ACTV_INDCTR field from the ISSR table but this wasn't being used in the MySQL database.

Much of the data in the ACCTG_FIRM_CLIENT table has been updated and there are new records in this table as well. I added a field for AUD_OPN_DT_4 but you do not need to add a new field, just update the data in the first three AUD-OPN fields.

The ACCT_FIRM table has been appended.

Also, I've adding a new table for fee data (ACCT_FIRM_FEES). The fee data is keyed to the ACCT_FIRM_CLIENT_ID field in the ACCT_FIRM_CLIENT table. I would like to have a new box labeled "Audit Fee Details" and include the data from this table for each of the ACCTG_FIRM_CLIENT relationships (the data isn't yet complete, so some companies will be blank but that's OK; I'll add the data later).

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online