ezaccesstm - let's operate support · additional “internal reports” written in...

EZaccessTM

version 5.0

PRD Reports Guide

© 2001 Personic, Inc.

i

• • • •••

© 2001 Personic, Inc. All rights reserved.Version 2: January 25, 2001

Information in this document is subject to change without notice. The software described in this document is furnished under a license agreement or nondisclosure agreement. The software may be used or copied only in accordance with the terms of those agreements.

The names of companies, products, people, characters, and/or data mentioned in this document are fictitious and are in no way intended to represent any real individual, company, product, or event, unless otherwise noted. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use, without the written permission of Personic, Inc.

Personic, Inc.1000 Marina Boulevard, Fifth FloorBrisbane, CA 94005U.S.A.

Personic Workflow, EZaccess, and EPIC are trademarks of Personic, Inc. in the U.S.A. and other countries. Microsoft and Windows are registered trademarks of Microsoft Corporation. Other product and company names mentioned in this document may be the trademarks of their respective owners.

iii

• • • •••

Contents

Contents

Chapter 1: Personic Reporting Roadmap................ 11.1 Personic Enterprise Reporting: Overview ................................. 1

1.1.1 Current System: Crystal and Internal Reports............................................ 11.1.2 New System: Personic Enterprise Reporting (PER)...................................... 2

1.2 Migration to PER ......................................................................... 2

1.3 Personic Data Dictionary ............................................................ 3

1.3.1 Overview.................................................................................................. 3

Chapter 2: Specifications and Sample Reports....... 52.1 Introduction................................................................................. 5

2.1 Overview..................................................................................................... 5

2.2 Reports Conversion Chart........................................................... 5

2.3 Reports......................................................................................... 6

2.3.1 List of Reports .......................................................................................... 62.3.2 Specifications and Sample Reports ........................................................... 7

Appendix: Reports Conversion Chart ................. 149

1.1 Personic Enterprise Reporting: Overview 1

• • • •••

Chapter 1

Personic Reporting

• • • • • •Roadmap

1.1 Personic Enterprise Reporting: Overview

1.1.1 Current System: Crystal and Internal ReportsEZaccess and Personic Workflow both currently run a set of Crystal Reports in client/server mode. Each application is installed with approximately 25 standard Crystal Reports and Personic Workflow has approximately 100 additional “internal reports” written in PowerBuilder.

The Crystal Reports are distributed as Crystal Report files that either are located on the server or can be copied to the client workstation for improved performance. They are run directly from EZaccess and Personic Workflow by using the free Crystal run-time engine. These reports run against a Crystal dictionary, which has lead to various performance and customization problems.

EZaccess 5.0 PRD Reports Guide

2 2001 Personic, Inc.

• • ••••

The Crystal Reports also generate significant network traffic each time a report is run because most of the data being processed is transferred to the workstation for processing and display.

The internal reports are distributed in PowerBuilder’s PBDs, which are located on each client workstation; these compiled reports can be run only from within the applications and can not be customized. The reports run directly against the database.

1.1.2 New System: Personic Enterprise Reporting (PER)Personic is replacing the current reporting mechanism with the Personic Enterprise Reporting (PER) system, which uses the Personic Reporting Dictionary (PRD). The PRD is a set of database views and stored functions that have been optimized for ease and efficiency of reporting. The PRD is currently all dynamic but will be expanded later to include static summary tables that are generated overnight to enhance performance and provide historic analysis capability.

1.2 Migration to PERThe existing Crystal Reports have been rewritten to use the PRD. These reports will be distributed with the standard applications and are also available as modules that can be installed separately for existing sites. The PRD is or will be available for EZaccess 4.1.2, EZaccess 5.0, Personic Workflow 1.1.2, Personic Workflow 2.0.x, and Personic Workflow 2.1.x.

The existing Crystal Reports bundled with EZaccess and Personic Workflow have been replaced with new versions rewritten to use the PRD. The use of these simplified Crystal Reports written against the PRD provides significant improvement in the following areas:

• Performance: As much processing as possible is done by the database server.

• Accuracy: Reports are greatly simplified, which allows for a modular QA cycle.

• Reliability: Reports are much less dependent on the reporting tool version.

1.3 Personic Data Dictionary 3

• • • •••

Chapter 1: Personic Reporting Roadmap

• Customization: The PRD provides a user-friendly interface to the Personic database.

• Support is available for multiple schemas.

1.3 Personic Data Dictionary

1.3.1 OverviewThe Crystal Data Dictionary will be replaced with the Oracle view-based Data Dictionary, and all existing and future standard reports will be written against the PRD. The design and structure of the PRD are detailed in the following documents:

• PRD Installation Guide (in the EZaccess 5.0 PRD Guide)

• PRD Technical Reference (in the EZaccess 5.0 PRD Guide)

• EZaccess 5.0 Personic Reporting Dictionary

2.1 Introduction 5

• • • •••

Chapter 2

Specifications and Sample

• • • • • •Reports

2.1 Introduction

2.1 OverviewThe previous reports were based on the Personic Crystal Reports Dictionary (CRD). The new reports are based on the Personic Reporting Dictionary (PRD), which is made up mainly of database views and stored procedures.

This chapter contains graphic samples of the reports available for EZaccess 4.1.2 and 5.0.

This document is written for administrators, report writers, users and for Personic internal training.

2.2 Reports Conversion ChartFor information on the conversion of old EZaccess reports and the new PRD reports, see the Appendix, “Specifications and Sample Reports.”



• • ••••

2.3 Reports

2.3.1 List of ReportsReport Description

AvDuPcCo Average Duration of Placement By Company

CandPlace Candidate Placement by Recruiter

CandTerm Candidate Termination by Recruiter

AcSumRc Company Activity Summary by Recruiter

AcSumSa Company Activity Summary by Salesperson

DTFJobOr Days to Fill Job Order Positions by Company

OJOCnSum-AcAc Job Order Activity Counts by Company [AcAc]

OJOCnSum-JOJO Job Order Activity Counts by Company [JO/JO]

OJOASuCo-JOAc Job Order Activity Detail By Company [JO/Ac]

OJOASuRc-JOAc Job Order Activity Detail By Recruiter [JO/Ac]

OJOASuSa-JOAc Job Order Activity Detail By Salesperson [JO/Ac]

OJOASuCo-AcAc Job Order Activity Detail By Company [Ac/Ac]

OJOASuRc-AcAc Job Order Activity Detail By Recruiter [Ac/Ac]

OJOASuSa-AcAc Job Order Activity Detail By Salesperson [Ac/Ac]

JoAcRaRc-AcAc Job Order Activity Ratios (Sendouts, Interviews, Placements) By Recruiter [Ac/Ac]

JoAcRaSa-AcAc Job Order Activity Ratios (Sendouts, Interviews, Placements) By Salesperson [Ac/Ac]

JoAcRaRc-JOJO Job Order Activity Ratios (Sendouts, Interviews, Placements) By Recruiter [JO/JO]

JoAcRaSa-JOJO Job Order Activity Ratios (Sendouts, Interviews, Placements) By Salesperson [JO/JO]

TOJOSuCo-JOJO Job Order Activity Summary by Company [JO/JO]

TJOSumCo-AcAc Job Order Activity Summary by Company [Ac/Ac]

2.3 Reports 7

• • • •••

Chapter 2: Specifications and Sample Reports

2.3.2 Specifications and Sample ReportsThe following pages contain the specifications and samples of the reports.

TJOSumRc-AcAc Job Order Activity Summary by Recruiter [Ac/Ac]

TJOSumSa-AcAc Job Order Activity Summary by Salesperson [Ac/Ac]

TJOSumCo-JOJO Job Order Activity Summary by Company [JO/JO]

TJOSumRc-JOJO Job Order Activity Summary by Recruiter [JO/JO]

TJOSumSa-JOJO Job Order Activity Summary by Salesperson [JO/JO]

JODtlIt Job Order Interview Detail by Company

JODtlSn Job Order Sendout Detail by Company

JODtlTr Job Order Tracking Detail by Company

PlnDtlSt Planner Activity Detail by Status

PlnDtlTp Planner Activity Detail by Type

PlnSumSt Planner Activity Summary by Status

PlnSumTp Planner Activity Summary by Type

RcActSum-AcAc Recruiter Activity Summary

SaActSum-AcAc Salesperson Activity Summary

UsActSum-AcAc User Activity Summary [Ac/Ac]

Report Description

EZaccess Report Specification Average Duration of Placement by Company

______________________________________________________________________________

______________________________________________________________________________

Average Duration of Placement by Company

Specification

Title Average Duration of Placement by CompanyReport FileAvDuPcCo.rpt

Reporting ToolCrystal Reports

Tool Version7/8

Report Versionn/a

Purpose Calculate the days taken for all placements and the average for days taken across a joborder, sort by company and job order.

Data Driven By Job ordersData Source PRD dictionary view DV_CANDIDATE_PLACEMENTSelection Criteria Codedinto View

All job orders that are in the system with PLACEMENT_STATUS_TYPE = ‘H’ (Placed) areselected.

Selection Criteria Codedinto Report

None

Sort Criteria Sort level 1 – Group by BUSINESS_NAMESort level 2 – Group by JOB_ORDER

Effective Date Report is from the live job order data between the user-specified start date and enddate.

Layout See following graphic.Breaks and Subtotals Page break and subtotal on Business_Name.

Subtotals to include:Average duration of placement for each company

Grand total is the average (mean) duration of placement for all companies.

EZaccess Report Specification Average Duration of Placement by Company

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_TAKENEnd Date If specified, job order will be selected if ?End_Date <= DATE_TAKENUser If specified, job order will be selected if ?User = RECRUITERPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a

Displayed Values: Descriptions

Label Displayed InformationCompany From BUSINESS_NAME.Job Order From JOB_ORDER.Pos From POSITIONS.Job Title From POSITION_TITLE_DESC.Manager From MANAGER_NAME_LF.Recruiter From RECRUITER_FULL_NAME.Date Taken From DATE_TAKEN.Candidate From NAME_LF.Start Date From START_DATE.End Date From END_DATE.Duration (Days) From Duration (END_DATE – START_DATE) (inclusive).

Notes

Job Order Manager

Company:

CandidateDateTaken

Personic, Inc. EZaccess

RecruiterJob TitlePos StartDate

EndDate

TELECOM INDUSTRIESDuration(Days)

Average Duration of Placement by CompanySelection: Job Orders with Date Taken between 6/1/98 and 12/31/98

12/18/98SPEAR,CHARISSETECHNICAL SUPPORTTELECOM1 1 Smith, JenniferABRAHAM,NEIL 3/29/99 5/7/01 770ABRAHAM,NEIL 3/29/99 5/7/01 770ABRAHAM,NEIL 3/29/99 5/7/01 770ABRAHAM,NEIL 3/29/99 5/7/01 770ABRAHAM,NEIL 3/29/99 5/7/01 770

12/18/98SPEAR,CHARISSEMANUFACTURINGTELECOM2 5 Smith, JenniferVETO,SARA 12/21/98 2/19/99 60VETO,SARA 12/21/98 2/19/99 60VETO,SARA 12/21/98 2/19/99 60VETO,SARA 12/21/98 2/19/99 60VETO,SARA 12/21/98 2/19/99 60URSUA,ANABELLE12/20/98 3/4/99 74URSUA,ANABELLE12/20/98 3/4/99 74URSUA,ANABELLE12/20/98 3/4/99 74URSUA,ANABELLE12/20/98 3/4/99 74URSUA,ANABELLE12/20/98 3/4/99 74

Average Duration of Placement for TELECOM INDUSTRIES = 301 days

Date 8/31/00 5:51:54PMPrinted By JOHN Page 1 of 2Report: AvDuPcCo View: dv_candidate_placement

Personic, Inc. EZaccessAverage Duration of Placement by CompanySelection: Job Orders with Date Taken between 6/1/98 and 12/31/98

Average Duration of Placement for All Companies = 301 days

Date 8/31/00 5:51:54PMPrinted By JOHN Page 2 of 2Report: AvDuPcCo View: dv_candidate_placement

EZaccess Report Specification Candidate Placement by Recruiter

______________________________________________________________________________

______________________________________________________________________________

Candidate Placement by Recruiter

Specification

Title Candidate Placement by RecruiterReport FileCandPlace.rpt


Tool Version7/8

Report Versionn/a

Purpose Candidate placement detail including start/end dates, pay/bill rates, and gross margins.Sorted by recruiter and candidate.


All job orders that have placements at status Hired; that is, PLACEMENT_STATUS_TYPE= ‘H’


None

Sort Criteria Sort level 1 – Group by RECRUITERSort level 2 – Sort by Candidate


Layout See following graphic.Breaks and Subtotals Page break and subtotal on Recruiter.

Subtotals to include:Count of candidates placedGross margin in currency and percentage

Grand total of the candidates placed and total gross margin in currency andpercentage for all recruiters at end of report.

EZaccess Report Specification Candidate Placement by Recruiter

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= START_DATEEnd Date If specified, job order will be selected if ?End_Date <= START_DATEUser If specified, job order will be selected if ?User = RECRUITERPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationRecruiter From RECRUITER_FULL_NAME.Candidate From NAME_LF.Company From BUSINESS_NAME.Job Title From POSITION_TITLE_DESC.Sales From SALESPERSON_1_FULL_NAME.Start Dt. From START_DATE.End Dt. From END_DATE.Freq / Pay / Bill From Freq_Pay_Bill (PAYMENT_FREQUENCY / PAY_RATE / BILL RATE).Gross $(%) From M$D (BILL_RATE – PAY_RATE).

From M%D ((100*(BILL_RATE – PAY_RATE)) / BILL_RATE).

Notes

Candidate

Candidate Placement by RecruiterSelection: Job Orders with Placement Start Dates between 9/1/95 and 9/1/00 Assigned to JENNIFER


Recruiter:

Company Job Title Start Dt. Freq / Pay / Bill Gross $(%)Sales End Dt.

Smith, Jennifer

TELECOM INDUSTRIESABRAHAM,NEIL H / 50.00 / 75.00TECHNICAL SUPPORT 3/29/99 5/7/01 $25.00 (33%)Woodfield, JerryTELECOM INDUSTRIESURSUA,ANABELLE H / 68.00 / 75.00MANUFACTURING 12/20/98 3/4/99 $7.00 (9%)Woodfield, JerryTELECOM INDUSTRIESVETO,SARA H / 63.00 / 70.00MANUFACTURING 12/21/98 2/19/99 $7.00 (10%)Woodfield, Jerry

Candidates Placed by Smith, Jennifer = 3, Gross Margin = $39.00 (18%)

Date 9/1/00 2:27:13PMPrinted By JOHN Page 1 of 2Report: CandPlace View: dv_candidate_placement

Candidate Placement by RecruiterSelection: Job Orders with Placement Start Dates between 9/1/95 and 9/1/00 Assigned to JENNIFER


Total Candidates Placed = 3, Total Gross Margin = $39.00 (18%)

Date 9/1/00 2:27:13PMPrinted By JOHN Page 2 of 2Report: CandPlace View: dv_candidate_placement

EZaccess Report Specification Candidate Termination by Recruiter

______________________________________________________________________________

______________________________________________________________________________

Candidate Termination by Recruiter

Specification

Title Candidate Termination by RecruiterReport FileCandTerm.rpt


Tool Version7/8

Report Versionn/a

Purpose Candidate termination detail including start/end dates, pay/bill rates, and grossmargins. Sorted by recruiter and candidate.




None

Sort Criteria Sort level 1 – Group by RECRUITERSort level 2 – Sort by candidate



Subtotals to include:Count of candidates placedGross margin in currency and percentage

Grand total of the candidates placed and total gross margin in currency andpercentage for all recruiters at end of report.

EZaccess Report Specification Candidate Termination by Recruiter

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if termination placement record ?Start_Date >=

END_DATEEnd Date If specified, job order will be selected if termination placement record ?End_Date <=

END_DATEUser If specified, job order will be selected if ?User = RECRUITERPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationRecruiter From RECRUITER_FULL_NAME.Candidate From NAME_LF.Company From BUSINESS_NAME.Job Title From POSITION_TITLE_DESC.Sales From SALESPERSON_1_FULL_NAME.Start Dt. From START_DATE.End Dt. From END_DATE.Freq / Pay / Bill From Freq_Pay_Bill (PAYMENT_FREQUENCY / PAY_RATE / BILL_RATE).Gross $(%) From M$D (BILL_RATE – PAY_RATE).

From M%D ((100*(BILL_RATE – PAY_RATE)) / BILL_RATE).

Notes

Candidate

Candidate Termination by RecruiterSelection: Job Orders with Placement End Dates between 9/1/95 and 9/1/00 Assigned to JENNIFER


Recruiter:

Company Job Title Start Dt. Freq / Pay / Bill Gross $(%)Sales End Dt.

Smith, Jennifer

TELECOM INDUSTRIESURSUA,ANABELLE H / 68.00 / 75.00MANUFACTURING 12/20/98 3/4/99 $7.00 (9%)Woodfield, JerryTELECOM INDUSTRIESVETO,SARA H / 63.00 / 70.00MANUFACTURING 12/21/98 2/19/99 $7.00 (10%)Woodfield, Jerry

Candidates Placed by Smith, Jennifer = 2, Gross Margin = $14.00 (10%)

Date 9/1/00 2:41:04PMPrinted By JOHN Page 1 of 2Report: CandTerm View: dv_candidate_placement

Candidate Termination by RecruiterSelection: Job Orders with Placement End Dates between 9/1/95 and 9/1/00 Assigned to JENNIFER


Total Candidates Placed = 2, Total Gross Margin = $14.00 (10%)

Date 9/1/00 2:41:04PMPrinted By JOHN Page 2 of 2Report: CandTerm View: dv_candidate_placement

EZaccess Report Specification Company Activity Summary by Recruiter

______________________________________________________________________________

______________________________________________________________________________

Company Activity Summary by Recruiter

Specification

Title Company Activity Summary by RecruiterReport FileAcSumRc.rpt


Tool Version7/8

Report Versionn/a

Purpose Count Tracking, Sendout, Interview, and Placement records for open job orders, sort byrecruiter and company.

Data Driven By Open Job ordersData Source PRD dictionary view DV_ACTIVITY_SUMMARYSelection Criteria Codedinto View

All job orders that are in the system as of the run date are selected.


CLOSED_FLG = "N"

Sort Criteria Sort level 1 – Group by RecruiterSort level 2 – Group by Business_Name

Effective Date Report is from the live job order data as of the run date.


Subtotals to include:Count of all Tracking recordsCount of all Sendout recordsCount of all Interview recordsCount of all Placement records

Grand totals (as above) for all recruiters at end of report.

EZaccess Report Specification Company Activity Summary by Recruiter

______________________________________________________________________________

______________________________________________________________________________

Parameters


Displayed Values: DescriptionsLabel Displayed InformationRecruiter From RECRUITER_FULL_NAME.Business From BUSINESS_NAME.Manager From MANAGER_NAME_LF.Tracking The number of Tracking records, from TRACKING_SUM.Sendouts The number of Sendout records, from SENDOUT_SUM.Intervws The number of Interview records, from INTERVIEW_SUM.Placemts The number of Placement records, from PLACEMENT_SUM.

Notes

Business Manager

Recruiter: Smith, Jennifer

Tracking Sendouts Intervws Placemts

Personic, Inc. Company Activity Summary by RecruiterSelection: Open Job Orders with Date Taken between

8/31/95 and 8/31/00 Assigned to JENNIFER

EZaccess

TELECOM INDUSTRIES SPEAR,CHARISSE 7 3 2 2

7Total Activities for Smith, Jennifer 3 2 2

Date 8/31/00Printed By JOHN Page 1 of 2Report: AcSumRc View: dv_activity_summary


Personic, Inc. Company Activity Summary by RecruiterSelection: Open Job Orders with Date Taken between


EZaccess

7 3 2 2Grand Totals:

Date 8/31/00Printed By JOHN Page 2 of 2Report: AcSumRc View: dv_activity_summary

EZaccess Report Specification Company Activity Summary by Salesperson

______________________________________________________________________________

______________________________________________________________________________

Company Activity Summary by Salesperson

Specification

Title Company Activity Summary by SalespersonReport FileAcSumSa.rpt


Tool Version7/8

Report Versionn/a

Purpose Count Tracking, Sendout, Interview, and Placement records for open job orders, sort bysalesperson and company.

Data Driven By Open Job ordersData Source PRD dictionary view DV_ACTIVITY_SUMMARYSelection Criteria Codedinto View



CLOSED_FLG = “N”

Sort Criteria Sort level 1 – Group by SalespersonSort level 2 – Group by Business_Name

Effective Date Report is from the live job order data as of the run date.Layout See following graphic.Breaks and Subtotals Page break and subtotal on salesperson.

Subtotals to include:Count of all tracking recordsCount of all sendout recordsCount of all interview recordsCount of all placement records

Grand total (as above) for all salespersons at end of report.

EZaccess Report Specification Company Activity Summary by Salesperson

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_TAKENEnd Date If specified, job order will be selected if ?End_Date <= DATE_TAKENUser If specified, job order will be selected if ?User = TAKEN_BYPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationSalesperson From SALESPERSON_FULL_NAME.Business From BUSINESS_NAME.

Manager From MANAGER_NAME_LF.Tracking The number of Tracking records, from TRACKING_SUM.Sendouts The number of Sendout records, from SENDOUT_SUM.Intervws The number of Interview records, from INTERVIEW_SUM.Placemts The number of Placement records, from PLACEMENT_SUM.

Notes

Business Manager

Salesperson: Woodfield, Jerry


Personic, Inc. EZaccessCompany Activity Summary by SalespersonSelection: Open Job Orders with Date Taken between 1/1/98

and 12/31/98

AMERICA ON LINE DOLITTLE,JIMMY 2 2 4 1

HEWLETT PACKARD KUMAR,JOGESH 1 1 1 1

TELECOM INDUSTRIES SPEAR,CHARISSE 6 2 2 2

9Total Activities for Woodfield, Jerry 5 7 4

Date 8/31/00Printed By JOHN Page 1 of 2Report: AcSumSa View: dv_activity_summary


Personic, Inc. EZaccessCompany Activity Summary by SalespersonSelection: Open Job Orders with Date Taken between 1/1/98

and 12/31/98


Date 8/31/00Printed By JOHN Page 2 of 2Report: AcSumSa View: dv_activity_summary

EZaccess Report Specification Days to Fill Job Order Positions by Company

______________________________________________________________________________

______________________________________________________________________________

Days to Fill Job Order Positions by Company

Specification

Title Days to Fill Job Order Positions by CompanyReport FileDTFJobOr.rpt


Tool Version7/8

Report Versionn/a

Purpose Count the days taken to fill job orders.Data Driven By Job ordersData Source PRD dictionary view DV_CANDIDATE_PLACEMENTSelection Criteria Codedinto View



None

Sort Criteria Sort level 1 – Group by JOB ORDEREffective Date Report is from the live job order data between the user-specified start date and end

date.Layout See following graphic.Breaks and Subtotals No page break. Subtotal on Job Order.

Subtotals to include:Average days to fill for job order

Grand totals of all job orders, placements, and average days to fill for all positions atend of report.

EZaccess Report Specification Days to Fill Job Order Positions by Company

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationJob Order From JOB_ORDER.Job Title From POSITION_TITLE_DESC.Company From BUSINESS_NAME.Manager From MANAGER_NAME_LF.Recruiter From RECRUITER_FULL_NAME.Taken By From TAKEN_BY_FULL_NAME.Date Taken From DATE_TAKEN.Pos From POSITIONS.Snd From CNT_SENDOUT.Date Filled From START_DATE.Days to Fill From DAYS_TO_FILL.Candidate From NAME_LF.

Notes

Job Order Manager Candidate

Days to Fill Job Order Positions by CompanySelection: Job Orders with Date Taken between 9/1/95 and 9/1/00

DateTaken


RecruiterCompanyJob Title PosDateFilled

Daysto FillSnd

Taken By

1/3/99LAGASSE,MERRILLALLIED SIGNALIT PROFESSIONALALLIED2 61- JERRY5/12/99 129 ALLEN,MICHAEL

Average Days to Fill for ALLIED2 = 129

1/3/98DOLITTLE,JIMMYAMERICA ON LINETECHNICAL SUPPORTAOL1 22- JERRY5/10/99 492 BARR,GRACE

Average Days to Fill for AOL1 = 492

1/3/99PERKINS,JACKBELL ATLANTICNETWORK ENGINEERBELL1 11- JERRY5/26/99 143 BATHULA,NAVEEN

Average Days to Fill for BELL1 = 143

2/5/99BURNS,LOUISINTELWEBSITE DEVELOPERINTEL1 51- JERRY2/15/99 10 ABBOTT,JOHN

Average Days to Fill for INTEL1 = 10

12/18/98SPEAR,CHARISSETELECOM INDUSTRIESTECHNICAL SUPPORTTELECOM1 31Smith, Jennifer Smith, Jennifer3/29/99 101 ABRAHAM,NEIL

Average Days to Fill for TELECOM1 = 101

12/18/98SPEAR,CHARISSETELECOM INDUSTRIESMANUFACTURINGTELECOM2 25Smith, Jennifer Smith, Jennifer12/20/98 2 URSUA,ANABELLE12/21/98 3 VETO,SARA

Average Days to Fill for TELECOM2 = 3

Date 9/1/00 2:49:56PMPrinted By JOHN Page 1 of 2Report: DTFJobOr View: dv_candidate_placement

Note: Average Days to Fill may be negative if placement start dates are blank

Grand Totals

Days to Fill Job Order Positions by CompanySelection: Job Orders with Date Taken between 9/1/95 and 9/1/00


Total Number of Job Orders = 7

Average Days to Fill for All Positions = 126

Total Number of Placements = 7

Date 9/1/00 2:49:56PMPrinted By JOHN Page 2 of 2Report: DTFJobOr View: dv_candidate_placement

Note: Average Days to Fill may be negative if placement start dates are blank

EZaccess Report Specification Job Order Activity Counts by Company [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Counts by Company [Ac/Ac]

Specification

Title Job Order Activity Counts by Company [Ac/Ac]Report FileOJOCnSum-AcAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Count the positions needed, all the records in Sendout activity, grouped by company.Data Driven By Job ordersData Source PRD dictionary view DV_ACTIVITY_SUMMARY_DLYSelection Criteria Codedinto View



None

Sort Criteria Sort level 1 – Group by BUSINESS_NAMEEffective Date Report is from the live job order data as of the run date.Layout See following graphic.Breaks and Subtotals Page break and subtotal on Business_Name.

Subtotals to includeCount of positions neededCount of all the Sendout records

Grand total for all companies at end of report (same items counted as in subtotals).

EZaccess Report Specification Job Order Activity Counts by Company [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= ACTIVITY_DATEEnd Date If specified, job order will be selected if ?End_Date <= ACTIVITY_DATEUser If specified, job order will be selected if ?User = ACTIVITY_USERPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationCompany From BUSINESS_NAME.Job Order From JOB_ORDER.Job Title From POSITION_TITLE_DESC.Dt. Taken From DATE_TAKEN.Manager From MANAGER_NAME_LF.Recruiter From RECRUITER_FULL_NAME.Sales From SALESPERSON_FULL_NAME.Needed From POSITIONS.Send From CNT_SENDOUT.

Notes

Job Order Manager

Company:

Needed Send

Job Order Activity Counts by Company [Ac/Ac]Selection: Job Orders with Date Taken between 9/5/95 and 9/5/00

with Recruiter or Salesperson = JENNIFER

Dt. Taken Sales


RecruiterJob Title

TELECOM INDUSTRIES

Smith, JenniferSPEAR,CHARISSE8/9/00DATABASE ADMINISTRATOR1 1Woodfield, Jerry 1Smith, JenniferSPEAR,CHARISSE12/18/98MANUFACTURINGTELECOM2 5Woodfield, Jerry 0

Totals for TELECOM INDUSTRIES 16

Date 9/5/00 5:29:47PMPrinted By JOHN Page 1 of 2Report: OJOCnSum-AcAc View: dv_activity_summary_dly

Needed Send

Job Order Activity Counts by Company [Ac/Ac]Selection: Job Orders with Date Taken between 9/5/95 and 9/5/00

with Recruiter or Salesperson = JENNIFER


Grand Totals: 16

Date 9/5/00 5:29:47PMPrinted By JOHN Page 2 of 2Report: OJOCnSum-AcAc View: dv_activity_summary_dly

EZaccess Report Specification Job Order Activity Counts by Company [JO/JO]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Counts by Company [JO/JO]

Specification

Title Job Order Activity Counts by Company [JO/JO]Report FileOJOCnSum-JOJO.rpt


Tool Version7/8

Report Versionn/a

Purpose Count the positions needed, all the records in Sendout activity, grouped by company.Data Driven By Job ordersData Source PRD dictionary view DV_ACTIVITY_SUMMARYSelection Criteria Codedinto View



CLOSED_FLG = "N"


Subtotals to includeCount of positions neededCount of all the Sendout records


EZaccess Report Specification Job Order Activity Counts by Company [JO/JO]

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_TAKENEnd Date If specified, job order will be selected if ?End_Date <= DATE_TAKENUser If specified, job order will be selected if ?User = RECRUITER or SALESPERSONPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationCompany From BUSINESS_NAME.Job Order From JOB_ORDER.Job Title From POSITION_TITLE_DESC.Dt. Taken From DATE_TAKEN.Manager From MANAGER_NAME_LF.Recruiter From RECRUITER_FULL_NAME.Sales From SALESPERSON_FULL_NAME.Needed From POSITIONS.Send From CNT_SEND.

Notes

Job Order Manager

Company:

Needed Send

Job Order Activity Counts by Company [JO/JO]Selection: Open Job Orders with Date Taken between 6/6/98 and 9/5/00

with Recruiter or Salesperson = JERRY

Dt. Taken Sales

TELECOM INDUSTRIES


RecruiterJob Title1 8/9/00 SPEAR,CHARISSE 1DATABASE ADMINISTRATOR 1Smith, Jennifer Woodfield, JerryTELECOM2 12/18/98 SPEAR,CHARISSE 2MANUFACTURING 5Smith, Jennifer Woodfield, Jerry2 8/9/00 SPEAR,CHARISSE 0PROJECT MANAGER 1Smith, Jennifer Woodfield, Jerry3 8/9/00 SPEAR,CHARISSE 0WEBSITE DEVELOPER 1Smith, Jennifer Woodfield, Jerry

Totals for TELECOM INDUSTRIES 38

Date 9/5/00 5:38:57PMPrinted By JOHN Page 1 of 2Report: OJOCnSum-JOJO View: dv_activity_summary

Needed Send

Job Order Activity Counts by Company [JO/JO]Selection: Open Job Orders with Date Taken between 6/6/98 and 9/5/00

with Recruiter or Salesperson = JERRY


38Grand Totals:

Date 9/5/00 5:38:57PMPrinted By JOHN Page 2 of 2Report: OJOCnSum-JOJO View: dv_activity_summary

EZaccess Report Specification Job Order Activity Detail by Company [JO/Ac]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Detail by Company [JO/Ac]

Specification

Title Job Order Activity Detail by Company [JO/Ac]Report FileOJOASuCo- JOAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the Tracking, Sendout, Interview, and Placement activity details of job orders,including comments grouped by activity type along with job order details, grouped byjob order and company.

Data Driven By Job ordersData Source PRD dictionary view DV_JOB_ORDER_ACTIVITYSelection Criteria Codedinto View



CLOSED_FLG = "N"

Sort Criteria Sort level 1 – Group by BUSINESS_NAMESort level 2 – Group by JOB_ORDERSort level 3 – Group by ACTIVITY_TYPE


Layout See following graphic.Breaks and Subtotals Page break on Business_Name. No subtotals.

EZaccess Report Specification Job Order Activity Detail by Company [JO/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_OF_ACTIVITYEnd Date If specified, job order will be selected if ?End_Date <= DATE_OF_ACTIVITYUser If specified, job order will be selected if ?User = RECRUITER or SALESPERSONPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationCompany From BUSINESS_NAME.Activity Date From DATE_OF_ACTIVITY.Candidate From CANDIDATE_NAME_LF.Status From ACTIVITY_STATUS_DESC.Comments From ACTIVITY_COMMENTS.

Notes

Company:

Job Order Activity Detail by Company [JO/Ac]Selection: Open Job Orders with Activities Occurring between 9/5/95 and 12/31/98


TELECOM INDUSTRIES

Activity Date Candidate Status Comments

TELECOM2 12/18/98 SPEAR,CHARISSE

Job OrderDateTaken Priority Manager Salesperson Recruiter Pos. Filled Start Duration

RateHigh/Low

5 2 12/4/98 3 MONTHSHIGH $10.00/8.00Smith, JenniferWoodfield, Jerry

TRACKING for Job Order TELECOM2

11/23/98 PHONE CALLURSUA,ANABELLE INTERVIEW SET FOR TECOM11/24/98 APPOINTMENTURSUA,ANABELLE HIRED AT TECOM11/20/98 LEFT MESSAGEURSUA,ANABELLE L/M RE OPENING AT TECOM12/15/98 LEFT MESSAGEVETO,SARA [12/15/98 EZLIVE]

l/M RE ASSMBLER JOB AT TECOM12/15/98 IN-HOUSE INTERVIEWVETO,SARA [12/15/98 EZLIVE]

AVAILABLE SUMIT TO TECOM12/21/98 PHONE CALL Called to make sure Charisse is happy with anabell and sara. She will need

3 more after the 1st of the year. Happy Holidays....

SENDOUT for Job Order TELECOM2

11/20/98 EMAILEDURSUA,ANABELLE Anabelle's resume is a perfect fit for this position, and I'm expecting thatCharisse will want to meet with her in person later this week.

11/30/98 EMAILEDVETO,SARA Sara's resume is not very well suited for this position, but after speakingwith her in person, it seems as though her experience is stronger than herresume seems to be... I will really have to "sell her skills" to Charisse inorder to get an interview scheduled.

INTERVIEW for Job Order TELECOM2

12/7/98 OFFER NEGOTIATIONURSUA,ANABELLE Anabelle is already considering an offer with another company, so ifCharisse wants to hire her to work at Tecom Industries, they will have tomove fast.

12/2/98 3RD INTERVIEWVETO,SARA I told Sara to make sure that she brings a hard copy of her resume and atleast three references (with their name, address, email, and phone numberincluded)

PLACEMENT for Job Order TELECOM2

Date 9/5/00 4:09:10PMPrinted By JOHN Page 1 of 2Report: OJOASuCo-JOAc View: dv_job_order_activity

Company:

Job Order Activity Detail by Company [JO/Ac]Selection: Open Job Orders with Activities Occurring between 9/5/95 and 12/31/98


TELECOM INDUSTRIES


PLACEMENT for Job Order TELECOM2 (Continued)

12/20/98 PLACEDURSUA,ANABELLE Anabelle didn't seem very excited about starting her new position. I willmake sure to follow-up with Charisse to make sure that things are workingout O.K.

12/21/98 PLACEDVETO,SARA Sara said she would be willing to work up to 10 hours of overtime per week,if needed.

Date 9/5/00 4:09:10PMPrinted By JOHN Page 2 of 2Report: OJOASuCo-JOAc View: dv_job_order_activity

EZaccess Report Specification Job Order Activity Detail by Recruiter [JO/Ac]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Detail by Recruiter [JO/Ac]

Specification

Title Job Order Activity Detail by Recruiter [JO/Ac]Report FileOJOASuRc-JOAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the Tracking, Sendout, Interview, and Placement activity details of job orders,including comments grouped by activity type, along with job order details grouped byjob order and recruiter.




CLOSED_FLG = "N"

Sort Criteria Sort level 1 – Group by RECRUITERSort level 2 – Group by JOB_ORDERSort level 3 – Group by ACTIVITY_TYPE


Layout See following graphic.Breaks and Subtotals Page break on Recruiter. No subtotals.

EZaccess Report Specification Job Order Activity Detail by Recruiter [JO/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_OF_ACTIVITYEnd Date If specified, job order will be selected if ?End_Date <= DATE_OF_ACTIVITYUser If specified, job order will be selected if ?User = RECRUITERPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationRecruiter From RECRUITER_FULL_NAME.Activity Date From DATE_OF_ACTIVITY.Candidate From CANDIDATE_NAME_LF.Status From ACTIVITY_STATUS_DESC.Comments From ACTIVITY_COMMENTS.

Notes


Job Order Activity Detail by Recruiter [JO/Ac]Selection: Open Job Orders with Activities Occurring between 9/5/95 and 12/31/98




Job OrderDateTaken Priority Manager Salesperson Pos. Filled Start Duration

RateHigh/Low

5 2 12/4/98 3 MONTHSHIGH $10.00/8.00TELECOM INDUSTRIES

Company

Woodfield, Jerry

TRACKING for Job Order TELECOM211/23/98 PHONE CALLURSUA,ANABELLE INTERVIEW SET FOR TECOM

11/24/98 APPOINTMENTURSUA,ANABELLE HIRED AT TECOM

11/20/98 LEFT MESSAGEURSUA,ANABELLE L/M RE OPENING AT TECOM

12/15/98 LEFT MESSAGEVETO,SARA [12/15/98 EZLIVE] l/M RE ASSMBLER JOB AT TECOM

12/15/98 IN-HOUSE INTERVIEWVETO,SARA [12/15/98 EZLIVE] AVAILABLE SUMIT TO TECOM

12/21/98 PHONE CALL Called to make sure Charisse is happy with anabell and sara. She willneed 3 more after the 1st of the year. Happy Holidays....

SENDOUT for Job Order TELECOM211/20/98 EMAILEDURSUA,ANABELLE Anabelle's resume is a perfect fit for this position, and I'm expecting that

Charisse will want to meet with her in person later this week.11/30/98 EMAILEDVETO,SARA Sara's resume is not very well suited for this position, but after speaking

with her in person, it seems as though her experience is stronger than herresume seems to be... I will really have to "sell her skills" to Charisse inorder to get an interview scheduled.

INTERVIEW for Job Order TELECOM212/7/98 OFFER NEGOTIATIONURSUA,ANABELLE Anabelle is already considering an offer with another company, so if

Charisse wants to hire her to work at Tecom Industries, they will have tomove fast.

12/2/98 3RD INTERVIEWVETO,SARA I told Sara to make sure that she brings a hard copy of her resume and atleast three references (with their name, address, email, and phonenumber included)


Date 9/5/00 4:43:33PMPrinted By JOHN Page 1 of 2Report:OJOASuRc-JOAc

View: dv_job_order_activity


Job Order Activity Detail by Recruiter [JO/Ac]Selection: Open Job Orders with Activities Occurring between 9/5/95 and 12/31/98



PLACEMENT for Job Order TELECOM2 (Continued)12/20/98 PLACEDURSUA,ANABELLE Anabelle didn't seem very excited about starting her new position. I will

make sure to follow-up with Charisse to make sure that things areworking out O.K.

12/21/98 PLACEDVETO,SARA Sara said she would be willing to work up to 10 hours of overtime perweek, if needed.

Date 9/5/00 4:43:33PMPrinted By JOHN Page 2 of 2Report:OJOASuRc-JOAc


EZaccess Report Specification Job Order Activity Detail by Salesperson [JO/Ac]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Detail by Salesperson [JO/Ac]

Specification

Title Job Order Activity Detail by Salesperson [JO/Ac]Report FileOJOASuSa-JOAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the Tracking, Sendout, Interview, and Placement activity details of job orders,including comments grouped by activity type, along with job order details grouped byjob order and salesperson.




CLOSED_FLG = "N"

Sort Criteria Sort level 1 – Group by SALESPERSONSort level 2 – Group by JOB_ORDERSort level 3 – Group by ACTIVITY_TYPE

Effective Date Report is from the live job order data between the user- specified start date and enddate.

Layout See following graphic.Breaks and Subtotals Page break on Salesperson. No subtotals.

EZaccess Report Specification Job Order Activity Detail by Salesperson [JO/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_OF_ACTIVITYEnd Date If specified, job order will be selected if ?End_Date <= DATE_OF_ACTIVITYUser If specified, job order will be selected if ?User = TAKEN_BYPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a

Displayed Values Descriptions

Label Displayed InformationSalesperson From SALESPERSON_FULL_NAME.Activity Date From DATE_OF_ACTIVITY.Candidate From CANDIDATE_NAME_LF.Status From ACTIVITY_STATUS_DESC.Comments From ACTIVITY_COMMENTS.

Notes


Job Order Activity Detail by Salesperson [JO/Ac]Selection: Open Job Orders with Activities Occurring between 9/5/95 and 12/31/98




Job OrderDateTaken Priority Manager Pos. Filled Start Duration

RateHigh/Low


Company Recruiter

Smith, Jennifer

TRACKING for Job Order TELECOM211/23/98 PHONE CALLURSUA,ANABELLE INTERVIEW SET FOR TECOM11/24/98 APPOINTMENTURSUA,ANABELLE HIRED AT TECOM11/20/98 LEFT MESSAGEURSUA,ANABELLE L/M RE OPENING AT TECOM12/15/98 LEFT MESSAGEVETO,SARA [12/15/98 EZLIVE]


AVAILABLE SUMIT TO TECOM12/21/98 PHONE CALL Called to make sure Charisse is happy with anabell and sara. She will

need 3 more after the 1st of the year. Happy Holidays....






12/2/98 3RD INTERVIEWVETO,SARA I told Sara to make sure that she brings a hard copy of her resume and atleast three references (with their name, address, email, and phonenumber included)


Date 9/5/00 5:02:15PMPrinted By JOHN Page 1 of 2Report: OJOASuSa-JOAc View: dv_job_order_activity


Job Order Activity Detail by Salesperson [JO/Ac]Selection: Open Job Orders with Activities Occurring between 9/5/95 and 12/31/98



PLACEMENT for Job Order TELECOM2 (Continued)12/20/98 PLACEDURSUA,ANABELLE Anabelle didn't seem very excited about starting her new position. I will

make sure to follow-up with Charisse to make sure that things areworking out O.K.

12/21/98 PLACEDVETO,SARA Sara said she would be willing to work up to 10 hours of overtime perweek, if needed.

Date 9/5/00 5:02:15PMPrinted By JOHN Page 2 of 2Report: OJOASuSa-JOAc View: dv_job_order_activity

EZaccess Report Specification Job Order Activity Detail by Company [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Detail by Company [Ac/Ac]

Specification

Title Job Order Activity Detail by Company [Ac/Ac]Report FileOJOASuCo- AcAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the Tracking, Sendout, Interview, and Placement activity details of job ordersincluding comments grouped by activity type, along with job order details, grouped byjob order and company.




None

Sort Criteria Sort level 1 – Group by BUSINESS_NAMESort level 2 – Group by JOB_ORDERSort level 3 – Group by ACTIVITY_TYPE


Layout See following graphic.Breaks and Subtotals Page break on Business_Name. No subtotals.

EZaccess Report Specification Job Order Activity Detail by Company [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_OF_ACTIVITYEnd Date If specified, job order will be selected if ?End_Date <= DATE_OF_ACTIVITYUser If specified, job order will be selected if ?User = ACTIVITY_USERPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationCompany From BUSINESS_NAME.Activity Date From DATE_OF_ACTIVITY.Candidate From CANDIDATE_NAME_LF.Status From ACTIVITY_STATUS_DESC.Comments From ACTIVITY_COMMENTS.

Notes

Company:

Job Order Activity Detail by Company [Ac/Ac]Selection: Job Orders with Activities Occurring between 9/5/95 and 12/31/98


TELECOM INDUSTRIES



Job OrderDateTaken Priority Manager Salesperson Recruiter Pos. Filled Start Duration

RateHigh/Low

5 2 12/4/98 3 MONTHSHIGH $10.00/8.00Smith, JenniferWoodfield, Jerry

TRACKING for Job Order TELECOM2

11/23/98 PHONE CALLURSUA,ANABELLE INTERVIEW SET FOR TECOM11/24/98 APPOINTMENTURSUA,ANABELLE HIRED AT TECOM11/20/98 LEFT MESSAGEURSUA,ANABELLE L/M RE OPENING AT TECOM12/15/98 LEFT MESSAGEVETO,SARA [12/15/98 EZLIVE]


AVAILABLE SUMIT TO TECOM12/21/98 PHONE CALL Called to make sure Charisse is happy with anabell and sara. She will need

3 more after the 1st of the year. Happy Holidays....






12/2/98 3RD INTERVIEWVETO,SARA I told Sara to make sure that she brings a hard copy of her resume and atleast three references (with their name, address, email, and phone numberincluded)


Date 9/5/00 3:59:36PMPrinted By JOHN Page 1 of 2Report:OJOASuCo-AcAc


Company:

Job Order Activity Detail by Company [Ac/Ac]Selection: Job Orders with Activities Occurring between 9/5/95 and 12/31/98


TELECOM INDUSTRIES


PLACEMENT for Job Order TELECOM2 (Continued)

12/20/98 PLACEDURSUA,ANABELLE Anabelle didn't seem very excited about starting her new position. I willmake sure to follow-up with Charisse to make sure that things are workingout O.K.

12/21/98 PLACEDVETO,SARA Sara said she would be willing to work up to 10 hours of overtime per week,if needed.

Date 9/5/00 3:59:36PMPrinted By JOHN Page 2 of 2Report:OJOASuCo-AcAc


EZaccess Report Specification Job Order Activity Detail by Recruiter [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Detail by Recruiter [Ac/Ac]

Specification

Title Job Order Activity Detail by Recruiter [Ac/Ac]Report FileOJOASuRc-AcAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the Tracking, Sendout, Interview, and Placement activity details of job orders,including comments grouped by activity type, along with job order details grouped byjob order and recruiter.




ACTIVITY_USER_TYPE in ["B", "R"]

Sort Criteria Sort level 1 – Group by RECRUITERSort level 2 – Group by JOB_ORDERSort level 3 – Group by ACTIVITY_TYPE


Layout See following graphic.Breaks and Subtotals Page break on Recruiter. No subtotals.

EZaccess Report Specification Job Order Activity Detail by Recruiter [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationRecruiter From RECRUITER_FULL_NAME.Activity Date From DATE_OF_ACTIVITY.Candidate From CANDIDATE_NAME_LF.Status From ACTIVITY_STATUS_DESC.Comments From ACTIVITY_COMMENTS.

Notes


Job Order Activity Detail by Recruiter [Ac/Ac]Selection: Job Orders with Activities Occurring between 9/5/95 and 9/5/00 by JENNIFER



1 8/9/00 SPEAR,CHARISSE


RateHigh/Low

1 0 9/25/00HIGH $80.00/65.00TELECOM INDUSTRIES

Company

Woodfield, Jerry

TRACKING for Job Order 18/9/00 PHONE CALLCABELLA,MARK

SENDOUT for Job Order 18/9/00 EMAILEDCABELLA,MARK



RateHigh/Low


Company

Woodfield, Jerry

PLACEMENT for Job Order TELECOM212/21/98 PLACEDVETO,SARA Sara said she would be willing to work up to 10 hours of overtime per

week, if needed.

Date 9/5/00 4:33:16PMPrinted By JOHN Page 1 of 1Report: OJOASuRc-AcAc View: dv_job_order_activity

EZaccess Report Specification Job Order Activity Detail by Salesperson [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Detail by Salesperson [Ac/Ac]

Specification

Title Job Order Activity Detail by Salesperson [Ac/Ac]Report FileOJOASuSa-AcAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the Tracking, Sendout, Interview, and Placement activity details of job orders,including comments grouped by activity type, along with job order details grouped byjob order and salesperson.




ACTIVITY_USER_TYPE in ["S", "B"]

Sort Criteria Sort level 1 – Group by SALESPERSONSort level 2 – Group by JOB_ORDERSort level 3 – Group by ACTIVITY_TYPE


Layout See following graphic.Breaks and Subtotals Page break on Salesperson. No subtotals.

EZaccess Report Specification Job Order Activity Detail by Salesperson [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationSalesperson From SALESPERSON_FULL_NAME.Activity Date From DATE_OF_ACTIVITY.Candidate From CANDIDATE_NAME_LF.Status From ACTIVITY_STATUS_DESC.Comments From ACTIVITY_COMMENTS.

Notes


Job Order Activity Detail by Salesperson [Ac/Ac]Selection: Job Orders with Activities Occurring between 9/5/95 and 9/5/00 by JENNIFER



1 8/9/00 SPEAR,CHARISSE


RateHigh/Low

1 0 9/25/00HIGH $80.00/65.00TELECOM INDUSTRIES

Company Recruiter

Smith, Jennifer

TRACKING for Job Order 18/9/00 PHONE CALLCABELLA,MARK

SENDOUT for Job Order 18/9/00 EMAILEDCABELLA,MARK



RateHigh/Low


Company Recruiter

Smith, Jennifer

PLACEMENT for Job Order TELECOM212/21/98 PLACEDVETO,SARA Sara said she would be willing to work up to 10 hours of overtime per

week, if needed.

Date 9/5/00 4:56:03PMPrinted By JOHN Page 1 of 1Report: OJOASuSa-AcAc View: dv_job_order_activity

EZaccess Report Specification Job Order Activity Ratios (Sendouts, Interviews, Placements) by Recruiter [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Ratios (Sendouts, Interviews,Placements) by Recruiter [Ac/Ac]

Specification

Title Job Order Activity Ratios (Sendouts, Interviews, Placements) by Recuriter[Ac/Ac]

Report FileJOAcRaRc-AcAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Count Sendout, Interview, and Placement records for all open job orders; calculateratios: placement to sendout, interview to sendout, placement to interview ratios.Sort by recruiter.

Data Driven By Job ordersData Source PRD dictionary view DV_ACTIVITY_SUMMARY_DLYSelection Criteria Codedinto View



ACTIVITY_USER_TYPE in ["R", "B"]

Sort Criteria Sort level 1 – Group by RECRUITEREffective Date Report is from the live job order data as of the run date.Layout See following screen shot.Breaks and Subtotals Page break and subtotal on Recruiter.

Subtotals to include:Count of all Sendout recordsCount of all Interview recordsCount of all Placement recordsPlacement to Sendout ratioInterview to Sendout ratioPlacement to Interview ratio

Grand totals (as above) for all recruiters at end of report

EZaccess Report Specification Job Order Activity Ratios (Sendouts, Interviews, Placements) by Recruiter [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationRecruiter From RECRUITER_FULL_NAME.Job Order From JOB_ORDER.Status From JOB_ORDER_STATUS_DESC.Dt. Taken From DATE_TAKEN.Position From POSITION_TITLE_DESC.Manager From MANAGER_NAME_LF.Send From CNT_SENDOUT.Intvw From CNT_INTERVIEW.Place From CNT_PLACEMENT.Place / Send From Place_Send_Ratio ((CNT_PLACE / CNT_SEND) * 100).Intvw / Send From Intv_Send_Ratio ((CNT_INTVW / CNT_SEND) * 100).Place / Intvw From Place_Intv_Ratio ((CNT_PLACE / CNT_INTVW) * 100).

Notes

Job Order Manager

Recruiter:

Send Intvw Place

Personic, Inc. Job Order Activity Ratios (Sendouts, Interviews, Placements) by Recruiter [Ac/Ac]Selection: Job Orders with Activity Dates between

9/5/95 and 9/5/00

Dt. TakenStatus Position Place /Send

Intvw /Send

Place /Intvw

Ratios

EZaccess

Counts

Smith, Jennifer

1 SPEAR,CHARISSEDATABASE ADMINISTRATOR8/9/00 12:00:00AMCONTRACT 1 0 0 %0 %0 %0ALLIED2 LAGASSE,MERRILLIT PROFESSIONAL1/3/99 12:00:00AMCONTRACT 6 1 1 %17 %17 %100AOL1 DOLITTLE,JIMMYTECHNICAL SUPPORT1/3/98 12:00:00AMCONTRACT 2 4 1 %50 %200 %25BELL1 PERKINS,JACKNETWORK ENGINEER1/3/99 12:00:00AMCONTRACT 1 2 1 %100 %200 %50COMPSCI1 CANTON,WILLIAMPROGRAMMER1/3/99 12:00:00AMCONTRACT 1 1 0 %0 %100 %0FIRSTUSA3 HARRISON,EDWARDPROGRAMMER1/3/99 12:00:00AMCONTRACT 5 2 0 %0 %40 %0GTE3 ROSSMAN,JENNIFERTECHNICAL WRITING1/3/99 12:00:00AMCONTRACT 0 0 0 %0 %0 %0HP1 KUMAR,JOGESHHARDWARE ENGINEER1/3/98 12:00:00AMCONTRACT 0 0 0 %0 %0 %0INTEL1 BURNS,LOUISWEBSITE DEVELOPER2/5/99 12:00:00AMHOURLY TEMP 5 7 1 %20 %140 %14ORACLE1 ELLISON,LARRYDATABASE ADMINISTRATOR4/6/99 12:00:00AMCONTRACT 2 2 1 %50 %100 %50TELECOM1 SPEAR,CHARISSETECHNICAL SUPPORT12/18/98 12:00:00AMON HOLD 3 4 1 %33 %133 %25TELECOM2 SPEAR,CHARISSEMANUFACTURING12/18/98 12:00:00AMON HOLD 2 2 2 %100 %100 %100

Total Activities for Smith, Jennifer %29 %89 %3228 25 8

Date 9/5/00 11:42:52AMPrinted By JOHN Page 1 of 2Report: JoAcRaRc-AcAc View: dv_activity_summary_dly

Send Intvw Place

Personic, Inc. Job Order Activity Ratios (Sendouts, Interviews, Placements) by Recruiter [Ac/Ac]Selection: Job Orders with Activity Dates between

9/5/95 and 9/5/00

Place /Send

Intvw /Send

Place /Intvw

Ratios

EZaccess

Counts

Smith, Jennifer

%29 %89 %32Grand Totals: 28 25 8

Date 9/5/00 11:42:52AMPrinted By JOHN Page 2 of 2Report: JoAcRaRc-AcAc View: dv_activity_summary_dly

EZaccess Report Specification Job Order Activity Ratios (Sendouts, Interviews, Placements) by Salesperson [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Ratios (Sendouts, Interviews, Placements)by Salesperson [Ac/Ac]

Specification

Title Job Order Activity Ratios (Sendouts, Interviews, Placements) by Salesperson[Ac/Ac]

Report FileJOAcRaSa-AcAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Count Sendout, Interview, and Placement records for all open job orders, calculateratios: placement to sendout, interview to sendout, placement to interview ratios.Group and sort by salesperson.





Sort Criteria Sort level 1 – Group by SALESPERSONEffective Date Report is from the live job order data as of the run date.Layout See following graphic.Breaks and Subtotals Page break and subtotal on Salesperson.


Grand totals (as above) for all salespersons at end of report

EZaccess Report Specification Job Order Activity Ratios (Sendouts, Interviews, Placements) by Salesperson [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationSalesperson From SALESPERSON_FULL_NAME.Job Order From JOB_ORDER.Status From JOB_ORDER_STATUS_DESC.Dt. Taken From DATE_TAKEN.Position From POSITION_TITLE_DESC.Manager From MANAGER_NAME_LF.Send From CNT_SENDOUT.Intvw From CNT_INTERVIEW.Place From CNT_PLACEMENT.Place / Send From Place_Send_Ratio ((CNT_PLACE / CNT_SEND) * 100).Intvw / Send From Intv_Send_Ratio ((CNT_INTVW / CNT_SEND) * 100).Place / Intvw From Place_Intv_Ratio ((CNT_PLACE / CNT_INTVW) * 100).

Notes

Job Order Manager

Salesperson:

Send Intvw Place

Personic, Inc. Job Order Activity Ratios (Sendouts, Interviews, Placements) by Salesperson [Ac/Ac]Selection: Job Orders with Activity Dates between

9/5/95 and 9/5/00 For JENNIFER


Intvw /Send

Place /Intvw

Ratios

EZaccess

Counts

Woodfield, Jerry

1 CONTRACT 8/9/00 12:00:00AMDATABASE ADMINISTRATOR SPEAR,CHARISSE 1 0 0 %0 %0 %0TELECOM2 ON HOLD 12/18/98 12:00:00AMMANUFACTURING SPEAR,CHARISSE 0 0 1 %0 %0 %0

Total Activities for Woodfield, Jerry %100 %0 %01 0 1

Date 9/5/00 2:46:19PMPrinted By JOHN Page 1 of 2Report: JoAcRaSa-AcAc View: dv_activity_summary_dly

Send Intvw Place

Personic, Inc. Job Order Activity Ratios (Sendouts, Interviews, Placements) by Salesperson [Ac/Ac]Selection: Job Orders with Activity Dates between

9/5/95 and 9/5/00 For JENNIFER

Place /Send

Intvw /Send

Place /Intvw

Ratios

EZaccess

Counts

%100 %0 %0Grand Totals: 1 0 1

Date 9/5/00 2:46:19PMPrinted By JOHN Page 2 of 2Report: JoAcRaSa-AcAc View: dv_activity_summary_dly

EZaccess Report Specification Job Order Activity Ratios (Sendouts, Interviews, Placements) by Recruiter [JO/JO]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Ratios (Sendouts, Interviews,Placements) by Recruiter [JO/JO]

Specification

Title Job Order Activity Ratios (Sendouts, Interviews, Placements) by Recuriter[JO/JO]

Report FileJOAcRaRc-JOJO.rpt


Tool Version7/8

Report Versionn/a

Purpose Count Sendout, Interview, and Placement records for all open job orders, calculateratios: placement to sendout, interview to sendout, placement to interview ratios.Sort by recruiter.

Data Driven By Job ordersData Source PRD dictionary view DV_ACTIVITY_SUMMARYSelection Criteria Codedinto View



CLOSED_FLG = "N"

Sort Criteria Sort level 1 – Group by RECRUITEREffective Date Report is from the live job order data as of the run date.Layout See following graphic.Breaks and Subtotals Page break and subtotal on Recruiter.


Grand totals (as above) for all recruiters at end of report

EZaccess Report Specification Job Order Activity Ratios (Sendouts, Interviews, Placements) by Recruiter [JO/JO]

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationRecruiter From RECRUITER_FULL_NAME.Job Order From JOB_ORDER.Status From JOB_ORDER_STATUS_DESC.Dt. Taken From DATE_TAKEN.Position From POSITION_TITLE_DESC.Manager From MANAGER_NAME_LF.Send From CNT_SEND.Intvw From CNT_INTVW.Place From CNT_PLACE.Place / Send From Place_Send_Ratio ((CNT_PLACE / CNT_SEND) * 100).Intvw / Send From Intv_Send_Ratio ((CNT_INTVW / CNT_SEND) * 100).Place / Intvw From Place_Intv_Ratio ((CNT_PLACE / CNT_INTVW) * 100).

Notes

Job Order Manager

Recruiter:

Send Intvw Place

Personic, Inc. Job Order Activity Ratios (Sendouts, Interviews, Placements) by Recruiter [JO/JO]Selection: Open Job Orders with Date Taken between



Intvw /Send

Place /Intvw

Ratios

EZaccess

Counts

Smith, Jennifer

INTEL1 HOURLY TEMP 2/5/99 BURNS,LOUIS 5 17WEBSITE DEVELOPER %20 %140 %14ORACLE1 CONTRACT 4/6/99 ELLISON,LARRY 2 12DATABASE ADMINISTRATOR %50 %100 %50GTE3 CONTRACT 1/3/99 ROSSMAN,JENNIFER 1 01TECHNICAL WRITING %0 %100 %0FIRSTUSA3 CONTRACT 1/3/99 HARRISON,EDWARD 5 02PROGRAMMER %0 %40 %0COMPSCI1 CONTRACT 1/3/99 CANTON,WILLIAM 1 01PROGRAMMER %0 %100 %0TELECOM2 ON HOLD 12/18/98 SPEAR,CHARISSE 2 22MANUFACTURING %100 %100 %1001 CONTRACT 8/9/00 SPEAR,CHARISSE 1 00DATABASE ADMINISTRATOR %0 %0 %0AOL1 CONTRACT 1/3/98 DOLITTLE,JIMMY 2 14TECHNICAL SUPPORT %50 %200 %252 CONTRACT TO HIRE8/9/00 SPEAR,CHARISSE 0 00PROJECT MANAGER %0 %0 %03 DIRECT HIRE 8/9/00 SPEAR,CHARISSE 0 00WEBSITE DEVELOPER %0 %0 %0HP1 CONTRACT 1/3/98 KUMAR,JOGESH 1 11HARDWARE ENGINEER %100 %100 %100

Total Activities for Smith, Jennifer 20 20 6 %30 %100 %30

Date 9/5/00 2:43:28PMPrinted By JOHN Page 1 of 2Report: JoAcRaRc-JOJO View: dv_activity_summary

Send Intvw Place

Personic, Inc. Job Order Activity Ratios (Sendouts, Interviews, Placements) by Recruiter [JO/JO]Selection: Open Job Orders with Date Taken between


Place /Send

Intvw /Send

Place /Intvw

Ratios

EZaccess

Counts

20 20 6 %30 %100 %30Grand Totals:

Date 9/5/00 2:43:28PMPrinted By JOHN Page 2 of 2Report: JoAcRaRc-JOJO View: dv_activity_summary

EZaccess Report Specification Job Order Activity Ratios (Sendouts, Interviews, Placements) by Salesperson [JO/JO]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Ratios (Sendouts, Interviews,Placements) by Salesperson [JO/JO]

Specification

Title Job Order Activity Ratios (Sendouts, Interviews, Placements) by Salesperson[JO/JO]

Report FileJOAcRaSa-JOJO.rpt


Tool Version7/8

Report Versionn/a

Purpose Count Sendout, Interview, and Placement records for all open job orders, calculateratios: placement to sendout, interview to sendout, placement to interview ratios.Group and sort by salesperson.



Effective Date Report is from the live job order data as of the run date.Layout See following graphic.Breaks and Subtotals Page break and subtotal on Salesperson.

Subtotals to include:Count of all sendout recordsCount of all interview recordsCount of all placement recordsPlacement to Sendout ratioInterview to Sendout ratioPlacement to Interview ratio

Grand totals (as above) for all salespersons at end of report

EZaccess Report Specification Job Order Activity Ratios (Sendouts, Interviews, Placements) by Salesperson [JO/JO]

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_TAKENEnd Date If specified, job order will be selected if ?End_Date <= DATE_TAKENUser If specified, job order will be selected if ?User = SALESPERSONPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationSalesperson From SALESPERSON_FULL_NAME.Job Order From JOB_ORDER.Dt. Taken From DATE_TAKEN.Position From POSITION_TITLE_DESC.Manager From MANAGER_NAME_LF.Send From CNT_SEND.Intvw From CNT_INTVW.Place From CNT_PLACE.Place / Send From Place_Send_Ratio ((CNT_PLACE / CNT_SEND) * 100).Intvw / Send From Intv_Send_Ratio ((CNT_INTVW / CNT_SEND) * 100).Place / Intvw From Place_Intv_Ratio ((CNT_PLACE / CNT_INTVW) * 100).

Notes

Job Order Manager

Salesperson:

Send Intvw Place

Personic, Inc. Job Order Activity Ratios (Sendouts, Interviews, Placements) by Salesperson [JO/JO]Selection: Open Job Orders with Date Taken between

9/5/95 and 12/31/98


Intvw /Send

Place /Intvw

Ratios

EZaccess

Counts

Woodfield, Jerry

TELECOM2 ON HOLD 12/18/98 SPEAR,CHARISSE 2 22MANUFACTURING %100 %100 %100HP1 CONTRACT 1/3/98 KUMAR,JOGESH 1 11HARDWARE ENGINEER %100 %100 %100AOL1 CONTRACT 1/3/98 DOLITTLE,JIMMY 2 14TECHNICAL SUPPORT %50 %200 %25

Total Activities for Woodfield, Jerry 5 7 4 %80 %140 %57

Date 9/5/00 3:10:46PMPrinted By JOHN Page 1 of 2Report: JoAcRaSa-JOJO View: dv_activity_summary

Send Intvw Place

Personic, Inc. Job Order Activity Ratios (Sendouts, Interviews, Placements) by Salesperson [JO/JO]Selection: Open Job Orders with Date Taken between

9/5/95 and 12/31/98

Place /Send

Intvw /Send

Place /Intvw

Ratios

EZaccess

Counts

5 7 4 %80 %140 %57Grand Totals:

Date 9/5/00 3:10:46PMPrinted By JOHN Page 2 of 2Report: JoAcRaSa-JOJO View: dv_activity_summary

EZaccess Report Specification Job Order Activity Summary by Company [JO/JO]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Summary by Company [JO/JO]

Specification

Title Job Order Activity Summary by Company [JO/JO]Report FileTOJOSuCo-JOJO.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the total summary of open job orders including the count of records in Tracking,Sendout, Interview, and Placement activities, grouped by company.


All open job orders that are in the system as of the run date are selected.


CLOSED_FLG = "N"


Subtotals to include:Count of all the tracking recordsCount of all the sendout recordsCount of all the interview recordsCount of all the placement records



______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_TAKENEnd Date If specified, job order will be selected if ?End_Date <= DATE_TAKENUser If specified, job order will be selected if ?User = RECRUITER or TAKEN_BYPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationCompany From BUSINESS_NAME.Job Order From JOB_ORDER.Status From JOB_ORDER_STATUS_DESC.Date Taken From DATE_TAKEN.Priority From JOB_ORDER_PRIORITY_DESC.Manager From MANAGER_NAME_LF.Sales From SALESPERSON_FULL_NAME.Recruiter From RECRUITER_FULL_NAME.Track From CNT_TRACK.Send From CNT_SEND.Int From CNT_INTVW.Place From CNT_PLACE.

Notes

Job Order Manager

Company: TELECOM INDUSTRIES

Track Send Int Place

Job Order Activity Summary by Company [JO/JO]Selection: Open Job Orders with Date Taken between 6/6/98 and 12/31/98

DateTakenStatus Priority


RecruiterSales

TELECOM2 ON HOLD 12/18/98 SPEAR,CHARISSE 6 2 22HIGH Smith, JenniferWoodfield, Jerry

Total Activities for TELECOM INDUSTRIES 6 2 2 2

Date 9/6/00 12:04:01PMPrinted By JOHN Page 1 of 2Report: TOJOSuCo-JOJO View: dv_activity_summary


Job Order Activity Summary by Company [JO/JO]Selection: Open Job Orders with Date Taken between 6/6/98 and 12/31/98



Date 9/6/00 12:04:01PMPrinted By JOHN Page 2 of 2Report: TOJOSuCo-JOJO View: dv_activity_summary

EZaccess Report Specification Job Order Activity Summary by Company [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Summary by Company [Ac/Ac]

Specification

Title Job Order Activity Summary by Company [Ac/Ac]Report FileTJOSumCo-AcAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the total job order summary including the count of records in Tracking, Sendout,Interview, and Placement activities, grouped by company.




None

Sort Criteria Sort level 1 – Group by BUSINESS_NAMEEffective Date Report is from the live job order data between the user-specified start date and end

date.Layout See following graphic.Breaks and Subtotals Page break and subtotal on Business_Name.

Subtotals to includeCount of all the Tracking recordsCount of all the Sendout recordsCount of all the Interview recordsCount of all the Placement records


EZaccess Report Specification Job Order Activity Summary by Company [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationCompany From BUSINESS_NAME.Job Order From JOB_ORDER.Status From JOB_ORDER_STATUS_DESC.Date Taken From DATE_TAKEN.Priority From JOB_ORDER_PRIORITY_DESC.Manager From MANAGER_NAME_LF.Salesperson From SALESPERSON_FULL_NAME.Recruiter From RECRUITER_FULL_NAME.Track From CNT_TRACKING.Send From CNT_SENDOUT.Int From CNT_INTERVIEW.Place From CNT_PLACEMENT.

Notes

Job Order Manager

Company:


Job Order Activity Summary by Company [Ac/Ac]Selection: Job Orders with Activity Dates between 9/6/95 and 9/6/00 For JENNIFER



RecruiterSalesperson

TELECOM INDUSTRIES

1 CONTRACT 8/9/00 12:00:00AMHIGH SPEAR,CHARISSE Woodfield, Jerry Smith, Jennifer 1 1 0 0TELECOM2 ON HOLD 12/18/98 12:00:00AMHIGH SPEAR,CHARISSE Woodfield, Jerry Smith, Jennifer 0 0 0 1


Date 9/6/00 10:44:58AMPrinted By JOHN Page 1 of 2Report: TJOSumCo-AcAc View: dv_activity_summary_dly


Job Order Activity Summary by Company [Ac/Ac]Selection: Job Orders with Activity Dates between 9/6/95 and 9/6/00 For JENNIFER


Grand Totals: 1 1 0 1

Date 9/6/00 10:44:58AMPrinted By JOHN Page 2 of 2Report: TJOSumCo-AcAc View: dv_activity_summary_dly

EZaccess Report Specification Job Order Activity Summary by Recruiter [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Summary by Recruiter [Ac/Ac]

Specification

Title Job Order Activity Summary by Recruiter [Ac/Ac]Report FileTJOSumRc-AcAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the total job order summary including the count of records in Tracking, Sendout,Interview, and Placement activities, grouped by recruiter.




ACTIVITY_USER_TYPE in ["R", "B"]

Sort Criteria Sort level 1 – Group by RECRUITEREffective Date Report is from the live job order data between the user-specified start date and end

date.Layout See following graphic.Breaks and Subtotals Page break and subtotal on Recruiter.


Grand total for all recruiters at end of report (same items counted as in subtotals).

EZaccess Report Specification Job Order Activity Summary by Recruiter [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationRecruiter From RECRUITER_FULL_NAME.Job Order From JOB_ORDER.Status From JOB_ORDER_STATUS_DESC.Date Taken From DATE_TAKEN.Priority From JOB_ORDER_PRIORITY_DESC.Company From BUSINESS_NAME.Manager From MANAGER_NAME_LF.Taken By From TAKEN_BY_FULL_NAME.Track From CNT_TRACKING.Send From CNT_SENDOUT.Int From CNT_INTERVIEW.Place From CNT_PLACEMENT.

Notes

Job Order Manager



Job Order Activity Summary by Recruiter [Ac/Ac]Selection: Job Orders with Activity Dates between 9/6/95 and 9/6/00



Taken ByCompany

1 CONTRACT 8/9/00 12:00:00AMHIGH TELECOM INDUSTRIESSPEAR,CHARISSE Smith, Jennifer 1 1 0 0ALLIED2 CONTRACT 1/3/99 12:00:00AMHIGH ALLIED SIGNAL LAGASSE,MERRILL Smith, Jennifer 96 6 1 1AOL1 CONTRACT 1/3/98 12:00:00AMHIGH AMERICA ON LINEDOLITTLE,JIMMY Smith, Jennifer 2 2 4 1BELL1 CONTRACT 1/3/99 12:00:00AMHIGH BELL ATLANTIC PERKINS,JACK Smith, Jennifer 1 1 2 1COMPSCI1 CONTRACT 1/3/99 12:00:00AMHIGH COMPUTER SCIENCES CORP.CANTON,WILLIAM Smith, Jennifer 1 1 1 0FIRSTUSA3 CONTRACT 1/3/99 12:00:00AMHIGH FIRST USA BANK HARRISON,EDWARD Smith, Jennifer 2 5 2 0GTE3 CONTRACT 1/3/99 12:00:00AMHIGH GTE GOVERNMENT SYSTEMSROSSMAN,JENNIFER Smith, Jennifer 1 0 0 0HP1 CONTRACT 1/3/98 12:00:00AMHIGH HEWLETT PACKARDKUMAR,JOGESH Smith, Jennifer 1 0 0 0INTEL1 HOURLY TEMP 2/5/99 12:00:00AMHIGH INTEL BURNS,LOUIS Smith, Jennifer 11 5 7 1ORACLE1 CONTRACT 4/6/99 12:00:00AMHIGH ORACLE CORPORATIONELLISON,LARRY Smith, Jennifer 0 2 2 1TELECOM1 ON HOLD 12/18/98 12:00:00AMHIGH TELECOM INDUSTRIESSPEAR,CHARISSE Smith, Jennifer 3 3 4 1TELECOM2 ON HOLD 12/18/98 12:00:00AMHIGH TELECOM INDUSTRIESSPEAR,CHARISSE Smith, Jennifer 6 2 2 2

Total Activities for Smith, Jennifer 125 28 25 8

Date 9/6/00 11:03:05AMPrinted By Page 1 of 2Report: TJOSumRc-AcAc View: dv_activity_summary_dly


Job Order Activity Summary by Recruiter [Ac/Ac]Selection: Job Orders with Activity Dates between 9/6/95 and 9/6/00



Date 9/6/00 11:03:05AMPrinted By Page 2 of 2Report: TJOSumRc-AcAc View: dv_activity_summary_dly

EZaccess Report Specification Job Order Activity Summary by Salesperson [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Summary by Salesperson [Ac/Ac]

Specification

Title Job Order Activity Summary by Salesperson [Ac/Ac]Report FileTJOSumSa-AcAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the total job order summary including the count of records in Tracking, Sendout,Interview, and Placement activities, grouped by salesperson.





Sort Criteria Sort level 1 – Group by SALESPERSONEffective Date Report is from the live job order data between the user-specified start date and end

date.Layout See following graphic.Breaks and Subtotals Page break and subtotal on Salesperson.


Grand total for all salespersons at end of report (same items counted as in subtotals).

EZaccess Report Specification Job Order Activity Summary by Salesperson [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationSalesperson From SALESPERSON_FULL_NAME.Job Order From JOB_ORDER.Status From JOB_ORDER_STATUS_DESC.Date Taken From DATE_TAKEN.Priority From JOB_ORDER_PRIORITY_DESC.Company From BUSINESS_NAME.Manager From MANAGER_NAME_LF.Recruiter From RECRUITER_FULL_NAME.Track From CNT_TRACKING.Send From CNT_SENDOUT.Int From CNT_INTERVIEW.Place From CNT_PLACEMENT.

Notes

Job Order Manager



Job Order Activity Summary by Salesperson [Ac/Ac]Selection: Job Orders with Activity Dates between 9/6/95 and 12/31/98



RecruiterCompany

TELECOM2 ON HOLD 12/18/98 12:00:00AMHIGH TELECOM INDUSTRIESSPEAR,CHARISSE Smith, Jennifer 26 2 2

Total Activities for Woodfield, Jerry 6 2 2 2

Date 9/6/00 11:30:53AMPrinted By JOHN Page 1 of 2Report: TJOSumSa-AcAc View: dv_activity_summary_dly


Job Order Activity Summary by Salesperson [Ac/Ac]Selection: Job Orders with Activity Dates between 9/6/95 and 12/31/98



Date 9/6/00 11:30:53AMPrinted By JOHN Page 2 of 2Report: TJOSumSa-AcAc View: dv_activity_summary_dly


______________________________________________________________________________

______________________________________________________________________________


Specification

Title Job Order Activity Summary by Company [JO/JO]Report FileTJOSumCo-JOJO.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the total job order summary including the count of records in Tracking, Sendout,Interview, and Placement activities, grouped by company.




None

Sort Criteria Sort level 1 – Group by BUSINESS_NAMEEffective Date Report is from the live job order data between the user-specified start date and end

date.Layout See following graphic.Breaks and Subtotals Page break and subtotal on Business_Name.

Subtotals to include:Count of all the Tracking recordsCount of all the Sendout recordsCount of all the Interview recordsCount of all the Placement records



______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_TAKENEnd Date If specified, job order will be selected if ?End_Date <= DATE_TAKENUser If specified, job order will be selected if ?User = RECRUITER or TAKEN_BYPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationCompany From BUSINESS_NAME.Job Order From JOB_ORDER.Status From JOB_ORDER_STATUS_DESC.Date Taken From DATE_TAKEN.Priority From JOB_ORDER_PRIORITY_DESC.Manager From MANAGER_NAME_LF.Salesperson From SALESPERSON_FULL_NAME.Recruiter From RECRUITER_FULL_NAME.Track From CNT_TRACK.Send From CNT_SEND.Int From CNT_INTVW.Place From CNT_PLACE.

Notes

Job Order Manager

Company:


Job Order Activity Summary by Company [JO/JO]Selection: Job Orders with Date Taken between 6/6/98 and 12/31/98



Recruiter

TELECOM INDUSTRIES

Salesperson

TELECOM1 ON HOLD 12/18/98 SPEAR,CHARISSE 3 3 14HIGH Smith, JenniferWoodfield, JerryTELECOM2 ON HOLD 12/18/98 SPEAR,CHARISSE 6 2 22HIGH Smith, JenniferWoodfield, Jerry


Date 9/6/00 10:55:26AMPrinted By JOHN Page 1 of 2Report: TJOSumCo-JOJO View: dv_activity_summary


Job Order Activity Summary by Company [JO/JO]Selection: Job Orders with Date Taken between 6/6/98 and 12/31/98



Date 9/6/00 10:55:26AMPrinted By JOHN Page 2 of 2Report: TJOSumCo-JOJO View: dv_activity_summary

EZaccess Report Specification Job Order Activity Summary by Recruiter [JO/JO]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Summary by Recruiter [JO/JO]

Specification

Title Job Order Activity Summary by Recruiter [JO/JO]Report FileTJOSumRc-JOJO.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the total job order summary including the count of records in Tracking, Sendout,Interview, and Placement activities, grouped by recruiter.




None


date.Layout See following graphic.Breaks and Subtotals Page break and subtotal on Recruiter.


Grand total for all recruiters at end of report (same items counted as in subtotals).

EZaccess Report Specification Job Order Activity Summary by Recruiter [JO/JO]

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationRecruiter From RECRUITER_FULL_NAME.Job Order From JOB_ORDER.Status From JOB_ORDER_STATUS_DESC.Date Taken From DATE_TAKEN.Priority From JOB_ORDER_PRIORITY_DESC.Company From BUSINESS_NAME.Manager From MANAGER_NAME_LF.Taken By From TAKEN_BY_FULL_NAME.Track From CNT_TRACK.Send From CNT_SEND.Int From CNT_INTVW.Place From CNT_PLACE.

Notes

Job Order Manager



Job Order Activity Summary by Recruiter [JO/JO]Selection: Job Orders with Date Taken between 9/6/95 and 9/6/00



Taken ByCompany

BELL1 CONTRACT 1/3/99 PERKINS,JACK 1 1 12BELL ATLANTICHIGH Smith, JenniferINTEL1 HOURLY TEMP 2/5/99 BURNS,LOUIS 11 5 17INTELHIGH Smith, JenniferORACLE1 CONTRACT 4/6/99 ELLISON,LARRY 0 2 12ORACLE CORPORATIONHIGH Smith, JenniferGTE3 CONTRACT 1/3/99 ROSSMAN,JENNIFER 1 1 01GTE GOVERNMENT SYSTEMSHIGH Smith, JenniferFIRSTUSA3 CONTRACT 1/3/99 HARRISON,EDWARD 2 5 02FIRST USA BANKHIGH Smith, JenniferALLIED2 CONTRACT 1/3/99 LAGASSE,MERRILL 96 6 11ALLIED SIGNALHIGH Smith, JenniferCOMPSCI1 CONTRACT 1/3/99 CANTON,WILLIAM 1 1 01COMPUTER SCIENCES CORP.HIGH Smith, JenniferTELECOM1 ON HOLD 12/18/98 SPEAR,CHARISSE 3 3 14TELECOM INDUSTRIESHIGH Smith, JenniferTELECOM2 ON HOLD 12/18/98 SPEAR,CHARISSE 6 2 22TELECOM INDUSTRIESHIGH Smith, JenniferAOL1 CONTRACT 1/3/98 DOLITTLE,JIMMY 2 2 14AMERICA ON LINEHIGH Smith, Jennifer1 CONTRACT 8/9/00 SPEAR,CHARISSE 1 1 00TELECOM INDUSTRIESHIGH Smith, Jennifer2 CONTRACT TO HIRE8/9/00 SPEAR,CHARISSE 0 0 00TELECOM INDUSTRIESHIGH Smith, Jennifer3 DIRECT HIRE 8/9/00 SPEAR,CHARISSE 0 0 00TELECOM INDUSTRIESHIGH Smith, JenniferHP1 CONTRACT 1/3/98 KUMAR,JOGESH 1 1 11HEWLETT PACKARDHIGH Smith, Jennifer

Total Activities for Smith, Jennifer 125 30 27 9

Date 9/6/00 11:09:56AMPrinted By JOHN Page 1 of 2Report: TJOSumRc-JOJO View: dv_activity_summary


Job Order Activity Summary by Recruiter [JO/JO]Selection: Job Orders with Date Taken between 9/6/95 and 9/6/00



Date 9/6/00 11:09:56AMPrinted By JOHN Page 2 of 2Report: TJOSumRc-JOJO View: dv_activity_summary

EZaccess Report Specification Job Order Activity Summary by Salesperson [JO/JO]

______________________________________________________________________________

______________________________________________________________________________

Job Order Activity Summary by Salesperson [JO/JO]

Specification

Title Job Order Activity Summary by Salesperson [JO/JO]Report FileTJOSumSa-JOJO.rpt


Tool Version7/8

Report Versionn/a

Purpose Show the total job order summary including the count of records in Tracking, Sendout,Interview, and Placement activities, grouped by salesperson.




None


date.Layout See following graphic.Breaks and Subtotals Page break and subtotal on Salesperson.


Grand total for all salespersons at end of report (same items counted as in subtotals).

EZaccess Report Specification Job Order Activity Summary by Salesperson [JO/JO]

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_TAKENEnd Date If specified, job order will be selected if ?End_Date <= DATE_TAKENUser If specified, job order will be selected if ?User = SALESPERSONPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationSalesperson From SALESPERSON_FULL_NAME.Job Order From JOB_ORDER.Status From JOB_ORDER_STATUS_DESC.Date Taken From DATE_TAKEN.Priority From JOB_ORDER_PRIORITY_DESC.Company From BUSINESS_NAME.Manager From MANAGER_NAME_LF.Recruiter From RECRUITER_FULL_NAME.Track From CNT_TRACK.Send From CNT_SEND.Int From CNT_INTVW.Place From CNT_PLACE.

Notes

Job Order Manager



Job Order Activity Summary by Salesperson [JO/JO]Selection: Job Orders with Date Taken between 9/6/95 and 12/31/98



RecruiterCompany

TELECOM1 ON HOLD 12/18/98 SPEAR,CHARISSE 3 3 14TELECOM INDUSTRIESHIGH Smith, JenniferTELECOM2 ON HOLD 12/18/98 SPEAR,CHARISSE 6 2 22TELECOM INDUSTRIESHIGH Smith, JenniferHP1 CONTRACT 1/3/98 KUMAR,JOGESH 1 1 11HEWLETT PACKARDHIGH Smith, JenniferAOL1 CONTRACT 1/3/98 DOLITTLE,JIMMY 2 2 14AMERICA ON LINEHIGH Smith, Jennifer

Total Activities for Woodfield, Jerry 12 8 11 5

Date 9/6/00 11:38:57AMPrinted By JOHN Page 1 of 2Report: TJOSumSa-JOJO View: dv_activity_summary


Job Order Activity Summary by Salesperson [JO/JO]Selection: Job Orders with Date Taken between 9/6/95 and 12/31/98



Date 9/6/00 11:38:57AMPrinted By JOHN Page 2 of 2Report: TJOSumSa-JOJO View: dv_activity_summary

EZaccess Report Specification Job Order Interview Detail by Company

______________________________________________________________________________

______________________________________________________________________________

Job Order Interview Detail by Company

Specification

Title Job Order Interview Detail by CompanyReport FileJODtlIt.rpt


Tool Version7/8

Report Versionn/a

Purpose Display open job order and interview details including comments, sorted company, andjob order.

Selection Criteria Codedinto View



CLOSED_FLG = "N"




Subtotals to include:Total number of interviews for company

Grand total of interviews for all companies at end of report.

EZaccess Report Specification Job Order Interview Detail by Company

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_OF_INTERVIEWEnd Date If specified, job order will be selected if ?End_Date <= DATE_OF_INTERVIEWUser If specified, job order will be selected if ?User = RECRUITERPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationCompany From BUSINESS_NAME.Job Order From JOB_ORDER.Date Taken From DATE_TAKEN.Jot Title From POSITION_TITLE_DESC.Manager From MANAGER_NAME_LF.Recruiter From RECRUITER_FULL_NAME.Sales From SALESPERSON_FULL_NAME.Int Status From INTERVIEW_STATUS_DESC.Int Date From DATE_OF_INTERVIEW.comments From INTERVIEW_COMMENTS.

Notes

Job Order

Company:

Candidate Int Status

Job Order Interview Detail by CompanySelection: Interviews Occurring between 9/5/95 and 12/31/98 for Open Job Orders

DateTaken SalesJob Title


Recruiter

TELECOM INDUSTRIESInt Date

<---------------------comments------------------->Manager

TELECOM2 SPEAR,CHARISSEMANUFACTURING12/18/98 Smith, Jennifer Woodfield, JerryURSUA,ANABELLE OFFER NEGOTIATION12/7/98

Anabelle is already considering an offer with anothercompany, so if Charisse wants to hire her to work atTecom Industries, they will have to move fast.

VETO,SARA 3RD INTERVIEW12/2/98I told Sara to make sure that she brings a hard copy ofher resume and at least three references (with theirname, address, email, and phone number included)

Total Interviews for TELECOM INDUSTRIES = 2

Date 9/5/00 3:25:30PMPrinted By JOHN Page 1 of 2Report: JODtlIt View: dv_job_order_interview

Job Order Interview Detail by CompanySelection: Interviews Occurring between 9/5/95 and 12/31/98 for Open Job Orders


Grand Total Number of Interviews = 2

Date 9/5/00 3:25:30PMPrinted By JOHN Page 2 of 2Report: JODtlIt View: dv_job_order_interview

EZaccess Report Specification Job Order Sendout Detail by Company

______________________________________________________________________________

______________________________________________________________________________

Job Order Sendout Detail by Company

Specification

Title Job Order Sendout Detail by CompanyReport FileJODtlSn.rpt


Tool Version7/8

Report Versionn/a

Purpose Display open job order and sendout details including comments. Sorted by companyand job order.

Data Driven By Job ordersData Source PRD dictionary view DV_JOB_ORDER_SENDOUTSelection Criteria Codedinto View



CLOSED_FLG = "N"




Subtotals to includeTotal number of sendouts for company

Grand total of sendouts for all companies at end of report.

EZaccess Report Specification Job Order Sendout Detail by Company

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_SENTEnd Date If specified, job order will be selected if ?End_Date <= DATE_SENTUser If specified, job order will be selected if ?User = RECRUITERPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationCompany From BUSINESS_NAME.Job Order From JOB_ORDER.Date Taken From DATE_TAKEN.Job Title From POSITION_TITLE_DESC.Manager From MANAGER_NAME_LF.Recruiter From RECRUITER_FULL_NAME.Sales From SALESPERSON_FULL_NAME.Candidate Name From CANDIDATE_NAME_LF.Send Date From DATE_SENT.Comments From SENDOUT_COMMENTS.

Notes

Job Order Manager

Company:

Candidate Name

Job Order Sendout Detail by CompanySelection: Sendouts Occurring between 9/5/95 and 12/31/98 for Open Job Orders

DateTaken SalesJob Title


Recruiter Send Date

TELECOM INDUSTRIES

<---------------------comments-------------------->

SPEAR,CHARISSEMANUFACTURING12/18/98TELECOM2 Smith, Jennifer Woodfield, JerryURSUA,ANABELLE 11/20/98

Anabelle's resume is a perfect fit for this position, andI'm expecting that Charisse will want to meet with herin person later this week.

VETO,SARA 11/30/98Sara's resume is not very well suited for this position,but after speaking with her in person, it seems asthough her experience is stronger than her resumeseems to be... I will really have to "sell her skills" toCharisse in order to get an interview scheduled.

Total Sendouts for TELECOM INDUSTRIES = 2

Date 9/5/00 3:40:48PMPrinted By JOHN Page 1 of 2Report: JODtlSn View: dv_job_order_sendout

Job Order Sendout Detail by CompanySelection: Sendouts Occurring between 9/5/95 and 12/31/98 for Open Job Orders


Grand Total Number of Sendouts = 2

Date 9/5/00 3:40:48PMPrinted By JOHN Page 2 of 2Report: JODtlSn View: dv_job_order_sendout

EZaccess Report Specification Job Order Tracking Detail by Company

______________________________________________________________________________

______________________________________________________________________________

Job Order Tracking Detail by Company

Specification

Title Job Order Tracking Detail by CompanyReport FileJODtlTr.rpt


Tool Version7/8

Report Versionn/a

Purpose Display open job order and tracking activity details including comments. Sorted bycompany and job order.

Data Driven By Job ordersData Source PRD dictionary view DV_JOB_ORDER_TRACKINGSelection Criteria Codedinto View



CLOSED_FLG = "N"




Subtotals to includeTotal number of Tracking records for company

Grand totals of job orders and Tracking records for all companies at end of report.

EZaccess Report Specification Job Order Tracking Detail by Company

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= DATE_OF_EVENTEnd Date If specified, job order will be selected if ?End_Date <= DATE_OF_EVENTUser If specified, job order will be selected if ?User = RECRUITERPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationCompany From BUSINESS_NAME.Job Order From JOB_ORDER.Date Taken From DATE_TAKEN.Job Title From POSITION_TITLE_DESC.Manager From MANAGER_NAME_LF.Recruiter From RECRUITER_FULL_NAME.Candidate Name From CANDIDATE_NAME_LF.Track Status From TRACKING_STATUS_DESC.Track Date From DATE_OF_EVENT.Comments From TRACKING_COMMENTS.

Notes

Job Order Manager

Company:

Candidate Name Track Status

Job Order Tracking Detail by CompanySelection: Tracking Occurring between 9/5/95 and 12/31/98 for Open Job Orders

DateTaken Job Title


Recruiter Track Date

TELECOM INDUSTRIES

<-------------------------------comments------------------------------>

SPEAR,CHARISSEMANUFACTURING12/18/98TELECOM2 Smith, JenniferURSUA,ANABELLE LEFT MESSAGE 11/20/98

L/M RE OPENING AT TECOMURSUA,ANABELLE PHONE CALL 11/23/98

INTERVIEW SET FOR TECOMURSUA,ANABELLE APPOINTMENT 11/24/98

HIRED AT TECOMVETO,SARA LEFT MESSAGE 12/15/98

[12/15/98 EZLIVE] l/M RE ASSMBLER JOB AT TECOM

VETO,SARA IN-HOUSE INTERVIEW 12/15/98[12/15/98 EZLIVE] AVAILABLE SUMIT TO TECOM

PHONE CALL 12/21/98Called to make sure Charisse is happy with anabell and sara. She willneed 3 more after the 1st of the year. Happy Holidays....

Total Tracking Records for TELECOM INDUSTRIES = 6

Date 9/5/00 3:49:02PMPrinted By JOHN Page 1 of 2Report: JODtltr View: dv_job_order_tracking

Job Order Tracking Detail by CompanySelection: Tracking Occurring between 9/5/95 and 12/31/98 for Open Job Orders


Grand Total Number of Tracking Records = 6

Grand Total Number of Job Orders = 1

Date 9/5/00 3:49:02PMPrinted By JOHN Page 2 of 2Report: JODtltr View: dv_job_order_tracking

EZaccess Report Specification Planner Activity Detail by Status

______________________________________________________________________________

______________________________________________________________________________

Planner Activity Detail by Status

Specification

Title Planner Activity Detail by StatusReport FilePlnDtlSt.rpt


Tool Version7/8

Report Versionn/a

Purpose Shows all Planner activity details including status type, contact and candidate details,and disposition. Sort by Status.

Data Driven By Job ordersData Source PRD dictionary view DV_PLANNERSelection Criteria Codedinto View



None

Sort Criteria Sort level 1 – Group by Tracking_User_Name_FlSort level 2 – Group by Planner_Status_Desc

Effective Date Report is from the live job order data as of the run date.Layout See following graphic.Breaks and Subtotals Page break on Tracking_User_Name_Fl.

EZaccess Report Specification Planner Activity Detail by Status

______________________________________________________________________________

______________________________________________________________________________

Parameters

Parameter DetailStart Date If specified, job order will be selected if ?Start_Date >= TRACKING_DATE_ENTEREDEnd Date If specified, job order will be selected if ?End_Date <= TRACKING_DATE_ENTEREDUser If specified, job order will be selected if ?User = TRACKING_USER_NAMEPrinted By If specified, user name is included in the page footerOutput n/aReport Specific 1 n/aReport Specific 2 n/a


Label Displayed InformationUser Name From TRACKING_USER_NAME_FL.STATUS From PLANNER_STATUS_DESC.Type From PLANNER_TRACKING_TYPE.Date From TRACKING_DATE_ENTERED.ContactName From CONTACT_NAME_LF.Company From CONTACT_COMPANY_COMPANY_NAME.Wk From CONTACT_WORK_PHONE.AboutName From ABOUT_NAME_LF.Company From ABOUT_COMPANY_COMPANY_NAME.Wk Phone From ABOUT_WORK_PHONE.Disposition From PLANNER_DISPOSITION_DESC.

Notes

User Name: Stanford, Greg

Company/Wk Phone Disposition

Personic, Inc. Planner Activity Detail by StatusSelection: All Planner Activity Entered between 9/11/95 and 9/11/00 for GREG

EZaccess

STATUS / Type Date Name

ContactName Company/Wk Phone

About

ATTEMPTCOLD CALL 9/11/00 BLEVINS,BERNARDMOTOROLA

(602) 560-4000 RASCON,JACOB

(626) 979-2357

COMPLETELEFT MESSAGE 12/21/98 SPEAR,CHARISSE TELECOM INDUSTRIES

(818) 341-4010 Ext 546VETO,SARA TELECOM INDUSTRIES

(818) 380-1111 Ext 345IN-HOUSE INTERVIEW12/21/98 SPEAR,CHARISSE TELECOM INDUSTRIES


(818) 380-1111 Ext 345LEFT MESSAGE 12/23/98 BENNETT,ADRIENEFIDELITY

(617) 874-6482 BAYLESS,JENNIFERALLIED SIGNAL

(879) 543-3287 FILLED

DISPOSEDCOLD CALL 9/7/00 ARAGON,JAMES

(415) 864-6051 ROSSMAN,JENNIFERGTE GOVERNMENT SYSTEMS

(817) 650-6000

MOVEDMEETING 9/7/00 BENNETT,ADRIENEFIDELITY

(617) 874-6482 DALIA,KATE HEWLETT PACKARD

(503) 653-8462

OPENMEETING 9/11/00 ZOLOTAREV,YURI

() - THOMAS,JAMES TELECOM INDUSTRIES

(818) 341-4010 Ext 543APPOINTMENT 9/7/00 ADAMS,WILLIAM COCA-COLA

(770) 446-3921 Ext 43BAYLESS,JENNIFERALLIED SIGNAL

(879) 543-3287

Date 9/11/004:09:57PM

Printed By JOHN Page 1 of 1Report: PlnDtlSt View: dv_planner

EZaccess Report Specification Planner Activity Detail by Type

______________________________________________________________________________

______________________________________________________________________________

Planner Activity Detail by Type

Specification

Title Planner Activity Detail by TypeReport FilePlnDtlTp.rpt


Tool Version7/8

Report Versionn/a

Purpose Shows all planner activity details including tracking type, contact & candidate detailsand disposition. Sort by Tracking type.




None

Sort Criteria Sort level 1 – Group by Tracking_User_Name_FlSort level 2 – Group by Planner_Tracking_Type

Effective Date Report is from the live job order data as of the run date.Layout See following graphic.Breaks and Subtotals Page break on Tracking_User_Name_Fl.

EZaccess Report Specification Planner Activity Detail by Type

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationUser Name From TRACKING_USER_NAME_FL.TYPE From PLANNER_TRACKING_TYPE.Status From PLANNER_STATUS_DESC.Date From TRACKING_DATE_ENTERED.ContactName From TRACKING_USER_NAME_FL.Company From CONTACT_COMPANY_COMPANY_NAME.Wk From CONTACT_WORK_PHONE.AboutName From ABOUT_NAME_LF.Company From ABOUT_COMPANY_COMPANY_NAME.Wk Phone From ABOUT_WORK_PHONE.Disposition From PLANNER_DISPOSITION_DESC.

Notes

User Name: Stanford, Greg

Company/Wk Phone Disposition

Personic, Inc. Planner Activity Detail by TypeSelection: All Planner Activity Entered between 9/11/95 and 9/11/00 for GREG

EZaccess

TYPE / Status Date Name

ContactName Company/Wk Phone

About

APPOINTMENTOPEN 9/7/00 Stanford, Greg COCA-COLA

(770) 446-3921 Ext 43BAYLESS,JENNIFERALLIED SIGNAL

(879) 543-3287

COLD CALLATTEMPT 9/11/00 Stanford, Greg MOTOROLA

(602) 560-4000 RASCON,JACOB

(626) 979-2357 DISPOSED 9/7/00 Stanford, Greg

(415) 864-6051 ROSSMAN,JENNIFERGTE GOVERNMENT SYSTEMS

(817) 650-6000

IN-HOUSE INTERVIEWCOMPLETE 12/21/98 Stanford, Greg TELECOM INDUSTRIES


(818) 380-1111 Ext 345

LEFT MESSAGECOMPLETE 12/21/98 Stanford, Greg TELECOM INDUSTRIES


(818) 380-1111 Ext 345COMPLETE 12/23/98 Stanford, Greg FIDELITY

(617) 874-6482 BAYLESS,JENNIFERALLIED SIGNAL

(879) 543-3287 FILLED

MEETINGOPEN 9/11/00 Stanford, Greg

() - THOMAS,JAMES TELECOM INDUSTRIES

(818) 341-4010 Ext 543MOVED 9/7/00 Stanford, Greg FIDELITY

(617) 874-6482 DALIA,KATE HEWLETT PACKARD

(503) 653-8462

Date 9/11/004:11:26PM

Printed By JOHN Page 1 of 1Report: PlnDtlTp View: dv_planner

EZaccess Report Specification Planner Activity Summary by Status

______________________________________________________________________________

______________________________________________________________________________

Planner Activity Summary by Status

Specification

Title Planner Activity Summary by StatusReport FilePlnSumSt.rpt


Tool Version7/8

Report Versionn/a

Purpose Shows planner activity summary including user name, tracking type and count. Sort byStatus.




None

Sort Criteria Sort level 1 – Group by Tracking_User_Name_FlSort level 2 – Group by Planner_Status_Desc

Effective Date Report is from the live job order data as of the run date.Layout See following graphic.Breaks and Subtotals No page break. Subtotal on Tracking_User_Name_Fl.

Subtotals to include:Total with status OPENTotal with status ATTEMPTTotal with status MESSAGETotal with status COMPLETETotal with status DISPOSEDTotal with status MOVED

Grand total for all statuses at end of report (same items counted as in subtotals).

EZaccess Report Specification Planner Activity Summary by Status

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationUser Name From TRACKING_USER_NAME_FL.Open From sum of OPEN_FLAG.Attempts From sum of ATTEMPT_FLAG.Messages From sum of MESSAGE_FLAG.Complete From sum of COMPLETE_FLAG.Disposed From sum of DISPOSED_FLAG.Moved From sum of MOVED_FLAG.

Notes

User Name Attempts Messages Complete Disposed Moved

Personic, Inc. Planner Activity Summary by StatusSelection: All Planner Activity Entered between 9/11/95 and 9/11/00

EZaccess

Open

0 0 1 118 1 2EZLIVE

2 1 0 3 1 1Stanford, Greg

Grand Totals: 2 1 1 121 2 3

Date 9/11/00Printed By JOHN Page 1 of 1Report: PlnSumSt View: dv_planner

EZaccess Report Specification Planner Activity Summary by Type

______________________________________________________________________________

______________________________________________________________________________

Planner Activity Summary by Type

Specification

Title Planner Activity Summary by TypeReport FilePlnSumTp.rpt


Tool Version7/8

Report Versionn/a

Purpose Shows Planner activity summary including user name, tracking type, and count. Sort byTracking type.




None

Sort Criteria Sort level 1 – Group by Tracking_User_Name_FlSort level 2 – Group by Planner_Tracking_Type

Effective Date Report is from the live job order data as of the run date.Layout See following graphic.Breaks and Subtotals No page break. Subtotal on Tracking_User_Name_Fl.

EZaccess Report Specification Planner Activity Summary by Type

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationUser Name From TRACKING_USER_NAME_FL.Type From PLANNER_TRACKING_TYPE.Count From count of TRACKING_DATE_ENTERED.

Notes

User Name

Personic, Inc. Planner Activity Summary by TypeSelection: All Planner Activity Entered between 9/11/95 and 9/11/00

EZaccess

CountType

EZLIVEAPPOINTMENT 1FAX 2IN-HOUSE INTERVIEW 7LEFT MESSAGE 96LETTER SENT 1LUNCH 2MEETING 1PHONE CALL 12

Total Activities for EZLIVE = 122

Stanford, GregAPPOINTMENT 1COLD CALL 2IN-HOUSE INTERVIEW 1LEFT MESSAGE 2MEETING 2

Total Activities for Stanford, Greg = 8

Date 9/11/00Printed By JOHN Page 1 of 1Report: PlnSumTp View: dv_planner

EZaccess Report Specification Recruiter Activity Summary [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Recruiter Activity Summary [Ac/Ac]

Specification

Title Recruiter Activity Summary [Ac/Ac]Report FileRcActSum-AcAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Count job orders entered, Tracking, Sendout, Interview, and Placement records;calculate ratios: sendout to tracking, interview to sendout, placement to sendout, andplacement to interview for each recruiter.

Data Driven By Job ordersData Source PRD dictionary view DV_ACT_CNT_REC_DLYSelection Criteria Codedinto View



USER_TYPE in ["B", "R"]


date.Layout See following graphic.Breaks and Subtotals No page break.

Totals to include:Count of job orders enteredCount of Tracking recordsCount of Sendout recordsCount of Interview recordsCount of Placement recordsSendout to Tracking ratioInterview to Sendout ratioPlacement to Sendout ratioPlacement to Interview ratio

EZaccess Report Specification Recruiter Activity Summary [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationRecruiter From ACTIVITY_USER_FULL_NAME.Job Orders Entered From CNT_JOB_ORDER_ENTERED.Tracking From CNT_TRACKING.Sendouts From CNT_SENDOUT.Interviews From CNT_INTERVIEW.Placements From CNT_PLACEMENT.Sendout/Tracking From Sendout_Tracking

(SUM(CNT_SENDOUT)/SUM (CNT_TRACKING))*100.Interview/Sendout From Interview_Sendout

(SUM(CNT_INTERVIEW)/SUM (CNT_SENDOUT))*100.Placement/Sendout From Placement_Sendout

(SUM(CNT_PLACEMENT)/SUM (CNT_SENDOUT))*100.Placement/Interview From Placement_Interview

(SUM(CNT_PLACEMENT)/SUM (CNT_INTERVIEW))*100.

Notes

Personic, Inc. Recruiter Activity Summary [Ac/Ac]Selection: Activity Date between 9/6/95 and 9/6/00

EZaccess

Recruiter Job OrdersEntered Tracking Sendouts Interviews Placements Sendout/

TrackingPlacement/Sendout

Interview/Sendout

Placement/Interview

Counts Ratios

%3 %93 %26 %28EZLIVE 0 1,054 27 25 7

%100 %0 %100 %0Smith, Jennifer 14 1 1 0 1

%0 %0 %0 %0Stanford, Greg 0 2 0 0 0

Total Activities %3 %89 %29 %3214 1,057 28 25 8

Report: RcActSum-AcAc View: dv_act_cnt_rec_dly Printed By JOHN Date 9/6/0010:18:30AM

Page 1 of 1

EZaccess Report Specification Salesperson Activity Summary [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Salesperson Activity Summary [Ac/Ac]

Specification

Title Salesperson Activity Summary [Ac/Ac]Report FileSaActSum-AcAc.rpt


Tool Version7/8

Report Versionn/a

Purpose Count job orders entered; Tracking, Sendout, Interview, and Placement records;calculate ratios: sendout to tracking, interview to sendout, placement to sendout andplacement to interview for each salesperson.




USER_TYPE in ["B", "S"]



Totals to includeCount of job orders enteredCount of Tracking recordsCount of Sendout recordsCount of Interview recordsCount of Placement recordsSendout to Tracking ratioInterview to Sendout ratioPlacement to Sendout ratioPlacement to Interview ratio

EZaccess Report Specification Salesperson Activity Summary [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters



Label Displayed InformationSalesperson From ACTIVITY_USER_FULL_NAME.Job Orders Entered From CNT_JOB_ORDER_ENTERED.Tracking From CNT_TRACKING.Sendouts From CNT_SENDOUT.Interviews From CNT_INTERVIEW.Placements From CNT_PLACEMENT.Sendout/Tracking From Sendout_Tracking





Notes

Personic, Inc. Salesperson Activity Summary [Ac/Ac]Selection: Activity Date between 9/6/95 and 9/6/00

EZaccess

Salesperson Job OrdersEntered Tracking Sendouts Interviews Placements Sendout/


Interview/Sendout

Placement/Interview

Counts Ratios

%3 %93 %26 %28EZLIVE 0 1,054 27 25 7

%100 %0 %100 %0Smith, Jennifer 14 1 1 0 1

%0 %0 %0 %0Stanford, Greg 0 2 0 0 0

Total Activities %3 %89 %29 %3214 1,057 28 25 8

Report: SaActSum-AcAc View: dv_act_cnt_rec_dly Printed By JOHN Date 9/6/0010:29:53AM

Page 1 of 1

EZaccess Report Specification User Activity Summary [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

User Activity Summary [Ac/Ac]

Specification

Title User Activity Summary [Ac/Ac]Report FileAcSumRc.rpt


Tool Version7/8

Report Versionn/a

Purpose Count job orders entered; Tracking, Sendout, Interview, and Placement records;calculate ratios: sendout to tracking, interview to sendout, placement to sendout, andplacement to interview for each user.




USER_TYPE in ["B", "R", "S"]

Sort Criteria Sort level 1 – Group by ACTIVITY USER FULL NAMEEffective Date Report is from the live job order data between the user-specified start date and end


Subtotals to includeCount of job orders enteredCount of Tracking recordsCount of Sendout recordsCount of Interview recordsCount of Placement recordsSendout to Tracking ratioInterview to Sendout ratioPlacement to Sendout ratioPlacement to Interview ratio

Grand totals (as above) for all users at end of report.

EZaccess Report Specification User Activity Summary [Ac/Ac]

______________________________________________________________________________

______________________________________________________________________________

Parameters


Displayed Values: DescriptionsLabel Displayed InformationUser Name From ACTIVITY_USER_FULL_NAME.Job Orders Entered From CNT_JOB_ORDER_ENTERED.Tracking From CNT_TRACKING.Sendouts From CNT_SENDOUT.Interviews From CNT_INTERVIEW.Placements From CNT_PLACEMENT.Sendout/Tracking From Sendout_Tracking





Notes

Personic, Inc. User Activity Summary [Ac/Ac]Selection: Activity Date between 1/8/94 and 1/8/01

EZaccess

User Name Job OrdersEntered Tracking Sendouts Interviews Placements Sendout/


Interview/Sendout

Placement/Interview

Counts Ratios

%3 %93 %30 %32EZLIVE 1,051 27 25 817

%0 %100 %100 %100NULL 0 1 1 11

%0 %0 %0 %0Salesperson, Maris 1 0 0 01

%0 %0 %0 %0Smith, Jennifer 0 0 0 02

%0 %0 %0 %0Stanford, Greg 8 0 0 01

%0 %0 %0 %0Woodfield, Jerry 0 0 0 02

Total Activities %3 %93 %32 %351,060 28 26 924

Report: UsActSum-AcAc View: dv_act_cnt_rec_dly Printed By JOHN Date 1/8/011:12:54PM

Page 1 of 1

149

• • • •••

Appendix

Reports Conversion

• • • • • •Chart

The following table shows the conversion from previous EZaccess reports to the new PRD reports.

PRD Report Title PRD File PRD View JO Stat

Group By Filter User Filter Date First Version

Previous Title (CRD or Internal/PB)

CRD File Notes

Average Duration of Placement By Company

AvDuPcCo dv_candidate_placement

A jobo.business jobo.recruiter jobo.date_taken 412 Average Duration of Placement By Company

AvgDPcCo

Candidate Placement by Recruiter

CandPlace dv_candidate_placement

A jobo.recruiter jobo.recruiter place.start_date 412 Candidate Placement

CanPcRep Removed Status, Home Phone, and Type



• • ••••

Candidate Termination by Recruiter

CandTerm dv_candidate_placement

A jobo.recruiter jobo.recruiter place.end_date 412 New Report n/a

Company Activity Summary by Recruiter

AcSumRc dv_activity_ summary

O jobo.recruiter jobo.recruiter jobo.date_taken 412 Activity Summary by Recruiter

ActSumRc Removed field #Job Order (manager reqn count)

Company Activity Summary by Salesperson

AcSumSa dv_activity_ summary

O jobo.taken_by jobo.taken_by jobo.date_taken 412 Activity Summary by Salesperson

ActSumSa As above

Days to Fill Job Order Positions by Company

DTFJobOr dv_candidate_placement

A jobo.business jobo.recruiter jobo.date_taken 412 Days to Fill Job Order Positions

Taken By was removed but is being put back in

Job Order Activity Counts by Company [AcAc]

OJOCnSum-AcAc

dv_activity_ summary_dly

A jobo.business activity_user (type S, R, B)

activity_date 412 New Report n/a

Job Order Activity Counts by Company [Jo/JO]

OJOCnSum-JOJO

dv_activity_ summary

O jobo.business jobo.recruiter OR jobo.taken_by

jobo.date_taken 412 Open Job Order Count Summary

OJOCnSum

Job Order Activity Detail By Company [Ac/Ac]

OJOASuCo-AcAc

dv_job_order_activity

O jobo.business activity_user (type S, R, B)

date_of_activity 412 Open Job Order Activity Summary by Company

OJOASuCo Report was detail but incorrectly named Summary




CRD File Notes

151

• • • •••

Appendix: Reports Conversion Chart

Job Order Activity Detail By Company [JO/Ac]

OJOASuCo-JOAc



date_of_activity 412 Open Job Order Activity Summary by Company

OJOASuCo Report was detail but incorrectly named Summary

Job Order Activity Detail By Recruiter [Ac/Ac]

OJOASuRc-AcAc


O activity_user (type R, B)

activity_user (type R, B)

date_of_activity 412 Open Job Order Activity Summary by Recruiter

OJOASuRc As above

Job Order Activity Detail By Recruiter [JO/Ac]

OJOASuRc-JOAc


O jobo.recruiter jobo.recruiter date_of_activity 412 Open Job Order Activity Summary by Recruiter

OJOASuRc As above

Job Order Activity Detail By Salesperson [Ac/Ac]

OJOASuSa-AcAc


O activity_user (type S, B)

activity_user (type S, B)

date_of_activity 412 Open Job Order Activity Summary by Salesperson

OJOASuSa As above

Job Order Activity Detail By Salesperson [JO/Ac]

OJOASuSa-JOAc


O jobo.taken_by jobo.taken_by date_of_activity 412 Open Job Order Activity Summary by Salesperson

OJOASuSa As above

Job Order Activity Ratios (Sendouts, Interviews, Placements) By Recruiter [Ac/Ac]

JoAcRaRc-AcAc


A activity_user (type R, B)






CRD File Notes



• • ••••

Job Order Activity Ratios (Sendouts, Interviews, Placements) By Recruiter [JO/JO]

JoAcRaRc-JOJO


O jobo.recruiter jobo.recruiter jobo.date_taken 412 Job Order Ratio of Interviews to Sendouts by Recruiter,Job Order Ratio of Placements to Interviews by Recruiter,Job Order Ratio of Placements to Sendouts by Recruiter

RaSnItRc,RaItPcRc,RaSnPcRc

Three reports consolidated into one; Company removed

Job Order Activity Ratios (Sendouts, Interviews, Placements) By Salesperson [Ac/Ac]

JoAcRaSa-AcAc


A activity_user (type S, B)



Job Order Activity Ratios (Sendouts, Interviews, Placements) By Salesperson [JO/JO]

JoAcRaSa-JOJO


O jobo.taken_by jobo.taken_by jobo.date_taken 412 Job Order Ratio of Interviews to Sendouts by Salesperson,Job Order Ratio of Placements to Interviews by Salesperson,Job Order Ratio of Placements to Sendouts by Salesperson

RaSnItSa,RaItPcSa,RaSnPcSa

Three reports consolidated into one; Company removed

Job Order Activity Summary by Company [Ac/Ac]

TJOSumCo-AcAc


A jobo.business activity_user (type S, R, B)



TOJOSuCo-JOJO



jobo.date_taken 412 Total Open Job Order Summary by Company

TOJOSuCo Removed Taken By field




CRD File Notes

153

• • • •••

Appendix: Reports Conversion Chart


TJOSumCo-JOJO


A jobo.business jobo.recruiter OR jobo.taken_by

jobo.date_taken 412 Total Job Order Summary by Company

TJOSumCo Removed Taken By field

Job Order Activity Summary by Recruiter [Ac/Ac]

TJOSumRc-AcAc





Job Order Activity Summary by Recruiter [JO/JO]

TJOSumRc-JOJO


A jobo.recruiter jobo.recruiter jobo.date_taken 412 Total Job Order Summary by Recruiter

TJOSumRc Removed Taken By field

Job Order Activity Summary by Salesperson [Ac/Ac]

TJOSumSa-AcAc





Job Order Activity Summary by Salesperson [JO/JO]

TJOSumSa-JOJO


A jobo.taken_by jobo.taken_by jobo.date_taken 412 Total Job Order Summary by Salesperson

TJOSumSa Removed Taken By field

Job Order Interview Detail by Company

JODtlIt dv_job_order_interview

O jobo.business jobo.recruiter Int.date_of_ interview

412 Job Order Interview Summary

JOSumIt Detail report was incorrectly named Summary; Status, Taken By, and Date Entered removed; Date Range is on activity date instead of date taken

Job Order Sendout Detail by Company

JODtlSn dv_job_order_sendout

O jobo.business jobo.recruiter Send.date_sent 412 Job Order Sendout Summary

JOSumSn As above




CRD File Notes



• • ••••

Job Order Tracking Detail by Company

JODtlTr dv_job_order_tracking

O jobo.business jobo.recruiter Track.date_of_event

412 Job Order Tracking Summary

JOSumtr As above

Planner Activity Detail by Status

PlnDtlSt dv_planner A tracking_user tracking_user tracking_date_entered

500 New Report n/a

Planner Activity Detail by Type

PlnDtlTp dv_planner A tracking_user tracking_user tracking_date_entered

500 New Report n/a

Planner Activity Summary by Status

PlnSumSt dv_planner A tracking_user tracking_user tracking_date_entered

500 New Report n/a

Planner Activity Summary by Type

PlnSumTp dv_planner A tracking_user tracking_user tracking_date_entered

500 New Report n/a

Recruiter Activity Summary

RcActSum-AcAc

dv_act_cnt_ rec_dly




Salesperson Activity Summary

SaActSum-AcAc

dv_act_cnt_ rec_dly







CRD File Notes

ezaccesstm - let's operate support · additional “internal reports” written in...

Documents