For each of the 4 tabs in the attached excel file I need the information to be populated from the created database and be able to be downloaded into excel.
It is important that a user has the option of running the reports by assignment date in which case the website will check the as of date and subtract the number of days that have elapsed from the report date from the as of date. A user could want to run the report from the discharge date then the website will calculate the difference between the discharge dates and the report date in forming the calculations for the tabs.
Files will contain variousFC's and Pt Types. We should have a mechanism to consolidate the many financial classes into a couple with a mapping tool. For example, if a,b,c,d,e,f,g,h,i,j financial classes appeared in a file, we need a way that says for every file applied to project 1 if accounts are received with a financial class a or b or c map to financial class 1. If d,e,f,g,h are received map to 2. Similarily for the pt type. If we receive multiple we need to be able to map to specific fc's.