Attached are the meeting notes.  We didn't call role, so Frank may have missed an agency or two.  Many thanks to Frank Magliocco from Allegheny for recording the meeting notes!

Attached are the notes from the March 11th, 2010 ENUG full membership conference call.

Do you track your Applicant and Resident Language spoken and read to determine the translation and interpretation needs? If yes, what reports are you using?

What report do you use to track the numbe of active applications?

What type of Race/Ethnicity report have you created?

Attached is a Crystal Report similar to the LIB timesheet.  This one accepts a start date and end date and is structured for bi-weekly payroll.  It displays leave codes and GL accounts for each employee.  It works for Elite/PDS Payroll version 2.4 and may also work for version 3.2.  You will need to use the Set Location feature in Crystal for your environment.

The .sql files should be installed as a stored procedure.  Once the procedure is in place, the Crystal Report will need to be pointed at your SQL Server with appropriate login credentials.  The report should work fine after that with no further modification.

--Function to get a count of how many times a report is generated
 
CREATE FUNCTION [dbo].[usf_EliteReportCount] (@ReportPK int)
RETURNS NUMERIC
AS
BEGIN
 
DECLARE @ReportCount NUMERIC
SET @ReportCount = (SELECT  COUNT(dbo.osReportJob.PK)
FROM         dbo.osReportJob WITH (NOLOCK) INNER JOIN
dbo.osReport WITH (NOLOCK) ON dbo.osReportJob.fkosReport = dbo.osReport.PK INNER JOIN
dbo.osProgram WITH (NOLOCK) ON dbo.osReport.PK = dbo.osProgram.fkosReport

Members lising as of August 2009

This scrpit will locate all the attachments in Elite and return all the fields needed for cleanup.  IE Desktop - personal file location.   Hope this is helpful.
Becky - Cincinnati