Issue 89: CWSP Contract report should only list active companies
Status:  Fixed
Owner: ----
Closed:  May 2011
Project Member Reported by bhe...@cristoreyny.org, Mar 11, 2011
There is a standard report called Contract Reports. There are a few issues with this report
1. The report shows work teams. 99% of the time, the contract is prepared by company. There are only two companies (85 total) where one company has two contracts
2. The list shows inactive companies. These companies that no longer hire a student should not appear on this report. 

Thanks
 
Mar 29, 2011
Project Member #1 dmbs...@gmail.com
Sorry, is this still an issue? I don't understand.
Status: New
Mar 29, 2011
Project Member #2 bhe...@cristoreyny.org
Yes. It lists all companies we ever had in system. B

On Tue, Mar 29, 2011 at 11:11 AM, <
student-worker-relational-database@googlecode.com> wrote:

-- 
Brian Heese
Director Corporate Work Study Program
Cristo Rey New York High School
112 E. 106th St.
New York NY 10029

(c) 646-345-1808 (Best way to call me)
(o) 212-996-7000 x 214
bheese@cristoreyny.org

Click here to see what our supervisors are saying about the students'
performance at work!<http://www.cristoreyny.org/index.php/workstudy/students-at-work>
May 9, 2011
Project Member #3 dmbs...@gmail.com
Oh now I see. That report was from the old boring file upload which has nothing to do with what you want (the new web based contracts). I've rewritten the report to use the new system. It will be on the next update (weekend).

Should we bother considering the old contracts? They are attached to work teams and not companies. Maybe this is dumb. Does it make sense to remove the old style, then allow users to manually upload a contract to a specific company? They would all be in the same place, manual uploads just wouldn't have the extra data such as number of students.

Thinking long term, should this type of thing be noted in SugarCRM? You could then run it against reports in CRM. Right now we don't even link companies between the two so this would have to be implemented first.
Status: Needs_Verified
May 10, 2011
Project Member #4 dmbs...@gmail.com
Marking Fixed. As mentioned open a new ticket if you want better CRM integration.
Status: Fixed