#113 Changes to spRptDailyCount...

[Anonymous]

Make the following changes for the TK Daily Count
Report for next semester, accessible via the web:

- Change it from a stored procedure to a multi-tables
function, fnRptDailyCount(SiteNo).

- Include the following old columns: SiteNo, DOW,
Date, Session Count, User Count, Other Count, Other
Note.

- Add the following new columns if possible: WkNo
(need to look up start date of semester, remember the
SCE trimester exception), Usage Minutes (for raw time
logged from the RawTimeCache table).

- Ultimately the TKManager also want Non-Credit Hrs.
(for adjusted non-credit hours generated), but that
may not be possible if non-credit hours didn't get
calculated until end of term.

[Co Ho]

Logged In: YES
user_id=19972

Got this from John...

If I got non-credit hours at the end of each term, that
would suffice. They aren't needed weekly or daily. Thanks.