Date 3/24/2009

These are the items discussed for database and website update.  We will go over these with the Chair of the database committee and the GM and make sure we do not miss anything.

1) Look at the two year training date and let it go out to 25 months.  It will be a hard field instead of a calculated field.  The check will be no greater than 25 out and no less than a month out. (Review at next meeting)

Override for 1A, 2A, 3A, P and P - Hide 5A(Done 5A - not sure on Override)

2) Master allocation and sub allocations.  System will provide for allocation numbers to refer back to a master allocation number.  Pool transmittals will be used to add the new allocations for companies that have multiple locations under one Repair station certificate.  We will also look at this for companies that are too large to get an audit accomplished by one auditor.  Will interface with Rex Graft on particulars. (In work - database work complete - need standards for the running during allocation)

3)  Look to change the text fields used for comments and change to memo fields.  We need to make sure that all of the fields are changed.  Not sure if there will be an unintended problems. (Issue in database -errors during testing of change to memo fields - in review)

4) Remove A449 from Pool transmittal put email address on form, where the upper a449 is currently located. (Unclear of removal of A449 - we added for a reason, is this now obsolete?)

5) Test pool usage and make sure of the functionality of each process.  Have an email broadcast on Pool and schedule transmittals.(Done in test database)

6)  For audit transmittal emails - see where the company name gets pulled from.

7) Examine move and combine on Pool Transmittals. (unclear if this is a problem or by design)

8)  Per Jim look to change the language of Last Entry Date to Last Audit Date(Done)

9)  Submit button on My unprocessed audits.(Done)

10)  Get the 2A Allocation into the system. (Done)

11) Remove the drop downs on the auditor form - leads to confusion.(Done)

12) Reallocate form - put schedule trans button on it that fills in the allocation number and the member id / auditor.  Gene currently uses the Supplier Flag 2 to mark them manually.

13)  New way of members to get P and P and other files.  I created a link to the database system on 3/24/2009 for testing.  Uses the same username and password for each user. (Done)

14) Send out a pdf form once an UPAUD is performed to the email listed on the Audit transmittal.  It will be a questioneer that is to be sent back to a TBD email address.

15)  Recheck all form sizes.(Done)

16)  Work with Vinny on the online membership area - can it be linked to a member transmittal.  May also be able to put this code on the database server and removed one level of indirection.

17)  Change Page to Cell Phone on Member form. (Done)

18)  Add to manual how to create pdf's for any report.(Gene and Christy need to add)

19)  Have a database backup available for training purposes.(Done)

ARSS -------------------------------------------------------------------------------------

1)  Make the repair station section database identical to the Air Carriers.(Done)

2) Test membership transmittal (Need to test)

3)  Work toward a standard mail out audit form that can be send back in PDF form to a central depository much like the ACS certs. (In Work)