ORDER EXECUTION SYSTEM - SUPER MENU

Venkat

14-06-01

Order Execution System

Last week you had given to me

• Printouts of 82 output statements

I had returned these with my remarks. Along with that, I had also sent my personal copy of REQUIREMENT CATALOGUE V 1.1 (Signed by me on 8-11-2000).

Here too, on a no. of output statements, I had made remarks, after comparing these with the print-outs.

You have forwarded both (photo-copies) to Japan (Applitech).

NOW, with this note, I enclose:

• A chart (4 pages) "Our Customer Flight Deck Instruments"

In this I have tried to analyse all 82 output statements along different dimensions. This Bird's Eye View should help us, in case, we want to delete/

add any statements in future

• SUPER-MENU

I felt that the 82 output statements should be re-organised / re-grouped in some logical manner, which makes it easy to locate / look-up any of these.

The first thing I noticed about these statements was that

Some were giving only past statistics. I called these "HISTORICAL" statements.

A study of these would reveal "trends" & provide very useful "insights" and help us take long-term "strategic decisions", in terms of

• What should be our "focus"?
• Where should we "concentrate"?
• Which areas, need more resources?
• etc. etc.

Rest of the statements, were required to be referred to for executing ORDERS ON HAND.

These statements provided "Operational

Control", by monitoring status / tracking each activity etc.

These statements tell us, where we are (in respect of each SON) and what next we needed to do, to execute each order expeditiously.

All consultants would need to refer to these statements, frequently, for deciding upon

• what is pending in Client's COURT?
• " " Candidate's "?
• " " Our "?
• Who needs to do WHAT & WHEN?

Using this division / logic, I created two charts

• Report # 100 - Historical Statements
• " # 101 - Operation Control.

Both these statements, are in the form of - a MATRIX / TABULATION.

Like our "Magic-Cube Search" (on the website), Applitech should create / put-up these charts, as a part of a SUPER-MENU.

ALL that a Consultant need to do, is to click on the (Statement Number / s) desired CELL and Presto!

That statement opens-up on the Computer Screen.

As simple as that. Hassle-free search!!

Please convince Applitech to do this (Highly desirable because of its simplicity).

At the same time, I have also prepared a TRADITIONAL MENU

Where, one can click and drill-down into Sub-menus. This is obvious & needs no explanation.

I have also developed a Sub-menu, centred around KEYWORDS (3.0). One never knows what "word" will come to mind in the first instance! We should have a system, where a consultant can approach a particular, statement in several ways: (All roads lead to Mecca!)

After internal discussions amongst all consultants, you may want to

form-up / finalize the SUPER MENU and MATRIX / CHARTS and then forward to Applitech to implement in OES.

In the charts, wherever, I have marked "?", I have felt that such a output statement would be desirable. However, as Operating personnel, you should decide what you want - and when (maybe OEs V. 2.0?) you want such statements.

Please feel free to phone me / ask me for clarifications.

You should target to send our final requirement to Applitech by Saturday (16$^{th}$).

If you feel necessary, you may plan a visit to Ahmedabad (after fixing-up in advance with Japan) to explain everything in person.

With regards

[Signature/Initials]

cc = Nirmit.

OUR CUSTOMER FLIGHT-DECK INSTRUMENTS

(See "Customer Revolution" by Patricia Seybold)

13-6-01

Report No.	Statement Name	Type	Centred Around	Concerns
		History (Statistics)	Operation Control	Client/order
1	S. B. Summary (Monthly)
2	" " (URL)
3	" " (Period)
4	" " (Vacancy)
5	" " (Function)
---	---	---	---	---
6	" " (Ind.)
7	" " (Client)
8	" " (Consultant)
9	INQUIRY (Period)
10	" " (Consultant)
---	---	---	---	---
11	" " (Ind.)
12	" " (Func)
13	" " (Vacancy)
14	" " (City)
15	" " (Country)
---	---	---	---	---
16	" (Remaining)-Consultant
17	" (Failed) - "
18	" (Status) - "
19	PROPOSAL
20	Sales Order
---	---	---	---	---
21	Project Plan
22	Project Variance
23	Pending Order (Chrono)
24	" " C. Client)
25	" " (Vacancy)

 

Report No.	Statement Name	Type	Centred Around	Concerns
		History (Statistics)	Operation Control	Client/order
26	Pending Order (Consul/Billing value)
27	" " (Client/chrono)
28	" " (Client/Consultant)
29	" " (Client/Position)
30	" " (Client/Billing value)
---	---	---	---	---
31	" " (Period/Industry)
32	" " (Period/Function)
33	" " (Period/Position)
34	Pending Order Lead (Consul.)
35	Resumes to Send (Order)
---	---	---	---	---
36	Resumes Already Sent (Order)
37	Onetime Statement (Consult.)
38	" " (Client)
39	List - Prospect. Candi. (Order)
40	Advt. Details (Client/Period)
---	---	---	---	---
41	Advt. Response (Client/Period)
42	" " (Media/Period)
43	Int. Calls Sent out (order)
44	Int. Schedule (" ")
45	Int. Held (Client)
---	---	---	---	---
46	Int. Held Summary
47	Follow-up details (Order/Client)
48	w.r.t. Candidate (. Period)
49	Exp. Dt. of Joining (Client)
50	Comp. Details (order)

---

📄 Scan_0008.jpg (3/4)

Report No.	Statement Name	Type	Centred Around	Concerns
		History (Statistics)	Operation Control	Client/order
51	Comp. data to be recd. (order)
52	Compen. Format
53	Invoice Format
54	Final Invoice Summary (Client)
55	" " (Consultant)
---	---	---	---	---
56	" " (Period)
57	" " (Date)
58	" " (Consultant)
59	OOP. Invoice C. Client
60	OOP - Total
---	---	---	---	---
61	Client List (Billing/Period)
62	" " (Func)
63	" " (Industry)
64	" " (to Position)
65	Janam Kundali (Client)
---	---	---	---	---
66	Janam Kundali (Candidate)
67	Exec. Placed (Ind.)
68	" " (Func)
69	" " (Position)
70	" " (Client)
---	---	---	---	---
71	" " (Joining Date)
72	" " (Ann. Salary)
73	" " (Period)
74	Orders Executed (Ind.)
75	" " (Func.)

 

Report No.	Statement Name	Type	Centred Around	Concerns
		History (Statistics)	Operation Control	Client/order
76	Orders Executed (Position)
77	" " (Ind. wise Details)
78	" " (Fun. wise " ")
79	" " (Posi. wise " ")
80	" " (Total/Period)
---	---	---	---	---
81	Outstanding (Client)
82	" " (Consultant)

 

SUPER-MENU

1.0	HISTORY
2.0	OPERATIONS
3.0	KEYWORDS
4.0	MATRIX

 

1.0 HISTORY

1.01	Advertisements
1.02	Executives Placed
1.03	Inquiries
1.04	Invoices
1.05	Orders Executed
1.06	Order Value
1.07	Shopping Basket

 

1.01 Advertisements

Report No.	Statement Name
40	Clientwise Details
41	Clientwise Response
42	Mediawise Response

 

1.02 Executives Placed

Report No.	Statement Name
67	Summary - Ind. wise
68	" - Function wise
69	" - Position wise
70	" - Client wise
71	" - Joining Date wise
72	" - Compensation Wise
73	" - Consolidated

 

1.03 Inquiries

Report No.	Statement Name
09	Consolidated
10	Consultant-wise
11	Industry-wise
12	Function-wise
13	Position-wise
14	City-wise
15	Country-wise

 

1.04 Invoices

Report No.	Statement Name
54	Summary - Client wise
55	" - Consultant wise
56	" - Month wise
57	" - Date wise
58	" - Consultant wise
59	OOP - Client wise
60	OOP - Overall

 

1.05 Orders Executed

Report No.	Statement Name
74	Summary - Ind. wise
75	" - Function wise
76	" - Position wise
77	Details - Ind. wise
78	" - Function wise
79	" - Position wise
80	CONSOLIDATED

 

1.06 Order Value

Report No.	Statement Name
61	Which CLIENT gave how much MONEY?
62	" FUNCTION " " " ?
63	" INDUSTRY " " " ?
64	" POSITION " " " ?

 

1.07 Shopping Baskets

Report No.	Statement Name
01	Summary - Monthwise
02	" - URL Wise
03	" - Period Wise
04	" - Position Wise
05	" - Function Wise
06	" - Industry Wise
07	" - Client Wise
08	" - Consultant Wise

 

2.0 OPERATIONS

2.01	Follow-up / Candidates
2.02	Follow-up / General
2.03	Follow-up / Interviews
2.04	Inquiries
2.05	Project
2.06	Pending Orders
2.07	Resumes
2.08	Outstandings

 

2.01 Follow-Up / Candidates

Report No.	Statement Name
35	Whose resumes are yet to be sent against a SON?
36	Whose resumes have already been sent against a SON?
39	Who (all) are shortlisted against a SON? (Prospective Candidates)
66	Janam-kundali (Candidate)

 

2.02 Follow-Up / General

Report No.	Statement Name
47	Activities to be followed - Orderwise
48	PEN to be followed
49	Who joins WHEN? - Clientwise
50	Salary-data received - Orderwise
51	Salary-data yet to get - Orderwise

 

2.03 Follow-Up / Interviews

Report No.	Statement Name
43	Call-letters / SON wise
44	Schedules / SON wise
45	Summary - Client wise
46	Summary - Overall

 

2.04 Inquiries

Report No.	Statement Name
16	Remaining to Respond (Consultant-wise)
17	Failed to Convert (Consultant-wise)
18	Status (Consultant-wise)

 

2.05 Project

Report No.	Statement Name
19	Proposal
20	Sales Order
21	Project Plan (for a SON)
22	Project Variance ( " )

 

2.06 Pending Orders

Report No.	Statement Name
CONSULTANT - WISE
23	Chronological
24	Client-wise
25	Position-wise
26	Billing-wise
34	Load
CLIENT - WISE
27	Chronological
28	Consultant-wise
29	Position-wise
30	Billing-wise
PERIOD - WISE
31	Industry-wise
32	Function-wise
33	Position-wise
?	Overall - Consolidated

 

2.07 Resumes

Report No.	Statement Name
35	Remaining to be sent (Order-wise)
36	Already Sent (Order-wise)
37	Oneline Statement (for Consultant)
38	Oneline Statement (for Client)
39	Details of Prospective-Clients.

 

2.08 Outstandings

Report No.	Statement Name
81	Outstandings - Clientwise
82	Outstandings - Consultantwise

 

3.0 KEYWORDS

3.01	Consultant
3.02	Client
3.03	Function
3.04	Industry
3.05	Position (Vacancy)

 

3.01 Consultant

Report No.	Statement Name
08	Shopping Basket - Periodwise
10	Inquiries - Periodwise
16	Inquiries - Yet to be attended
17	Inquiries - Failed to convert
18	Inquiry Status - Overall
23	Pending Orders - Chronological
24	" " " - Client Wise
25	" " " - Position Wise
26	" " " - Billing Value Wise
28	" " " - For a given client
34	Load (on a consultant)
37	Oneline statement
55	Invoices / Final Payment Summary (M)
58	Invoices / " " (Period)
82	Outstanding - Consultant Wise

 

3.02 Client

Report No.	Statement Name
27	Pending Order - Chronological
29	" " - Position Wise
30	" " - Bill Value Wise
35	Resumes remaining to be sent (Orderwise)
36	Resumes already sent (Orderwise)
38	Oneline Statement (Orderwise?)
39	Details of Prospective Candidates (Orderwise?)
40	Advt. Details
41	Advt. Response
43	Interview - Calls sent (Orderwise)
44	Interview - Schedule ( " )
45	Interviews Held ( " )
49	Expected date of joining ( " )
50	Salary-details already received
51	Salary-details to be received
54	Invoice Summary - Final Payment
59	Out-of-Pocket Expense
65	Janam-Kundli
70	Executives Placed
81	Outstandings.

 

3.03 Function

Report No.	Statement Name
05	Shopping Baskets
12	List of Inquiries
32	Pending Order Status
62	Current List on Order Value
68	Executives Placed - Summary
75	Orders Executed - Summary
78	Order Executed - Details

 

3.04 Industry

Report No.	Statement Name
06	Shopping Basket - Summary
11	List of Inquiries
31	Pending Order Status
63	Client List on Order Value
67	Executives Placed
74	Orders Executed - Summary
77	Orders Executed - Details.

 

3.05 Position (Vacancy) Designation

Report No.	Statement Name
04	Shopping Baskets (Position - Period)
13	List of Inquiries (" ")
25	Pending Orders (Position - Consultant)
29	Pending Orders (Position - Client)
33	Pending Orders (Position - Period)
64	Client List on Order (Vacancy - wise)
69	Executives Placed Summary (" ")
76	Analysis of Orders Executed Summary (Position-wise)

 

4.0 MATRIX

4.01	Historical Statements Matrix
4.02	Operational Control Statements Matrix

 

4.01 Historical Statements Matrix

Historical	100	7 topics X 12 Keywords
Statements
Matrix

 

$\text{ORDER EXECUTION SYSTEM} / \text{HISTORICAL STATEMENTS}$

(statistics to reveal trends/help take long-term strategic decisions)

Report NO. 100

Topic	Broker-up Wise	Consultant	Client	Industry	Function	Desig. Level / Posit. Name	URL	Media	Date / Month / Period	City/Country	Compensation	Consolidated/ Overall Summary
Shopping Basket		08	07	06	05	04	02		01, 03
Inquiry.		10		11	12	13				14, 15		09
Advt.			40, 41					42				$\times$
Invoices		55, 58 (Period)	54, 59						56 (Mon), 57 (Date)		60
Order Value	?		61	63	62	64						?
Execs. Placed	?		70	67	68	69			71 (Joining Date)		72	73
Orders Executed	?			74 (Sum), 77 (Details)	75 (Sum), 78 (Details)	76 (Sum), 79 (Details)			?			80

 

4.02 Operational Control Statements Matrix

Operational Control	101	11 topics X 10 Keywords
Statements
Matrix

 

$\text{ORDER EXECUTION SYSTEM} / \text{OPERATIONAL - CONTROL STATEMENTS}$

Report NO. 101

WISE	Consultant	Client	Candidate	Industry	Function	Desig. / Position	Date / Month / Period	Billing	SON	Consolidated / Overall
1 INQUIRIES - Remaining - Failed	16, 17, 18									? ? ?
2 Outstandings	82	81								?
3 Interview call sent out									43	$\times$
4 Interview schedule									44	$\times$
5 Interviews Held summary		45					46		?	$\times$
6 Follow-up		49, 48							47, 49, 50, 51, 35, 36, 37, 38, 39	$\times$
7 Pending Orders - consultant wise	34	24				25	23	26		?
8 Pending Orders - client wise	28					29	27	30		$\times$
9 Pending Orders - period wise				31	32	33				$\times$
10 RESUMES	37	38	39						35, 36, 39	$\times$
11 Project									19, 20, 21, 22	$\times$

 

$\text{Minutes of Meeting}$

Attended by: - Mr. Hemant Parekh, Mr. Mayle, Tapan, Mr. Tapan, Yogesh, Sudhakar.

1. Cyril will make a View in their database and will give OES read rights to OES User.

Following fields should be involved in View.

• OES P.K. - ASSIGNMENT ID.
• PEN
• NAME OF CANDIDATE
• ORGANIZATION (current) Dept 1/2/3
• DESIGNATION (current) EDO9 1/2/3.
• EDUCATIONAL QUALIFICATION (1, 2, 3)
• [PAST COMPANY DETAILS] - Corporate Name - Designation - Working since - Years - Months
• AGE - DOB.
• CITY - Location
• SOURCE
• PHONE (R)
• PHONE (O)
• MOBILE No.
1. Cyril will display Assignment Id to the user who is making search. Cyril user needs to remembers Assignment ID when user comes to OES system he/she must enter Assignment ID to fetch selected candidates from Cyril.
2. OES will put one field ASSIGNMENT ID (Number 6, 0) to candidate using Screen.

(3) PEN NO. will be Number (10, 0).

(4) 3P consultants will give up Logo.

(5) OES will need SOURCE (from which site mail is coming) in mails for Shopping Basket.

(6) There will be break in Consultant wise, then Client wise along with provided in Reports.

(7) Another view for PEN (Relates to Separate info)

(8) Standardisation in table names & table space.

(9) db space will start with OE-

(10) How many db space can/be created in Oracle 8.1 (Mail to Mr. Mayle).

(11) No. of tables allowed / per db space in Oracle 8.1.

(12) Standardized Table (for correspondence)

* UNIQUE Correspondence Serial No. $\text{NN} \ 6100$

* DATE of letter : MM DATE

* Subject : Null Varchar (3)

* Client code : Null Varchar (3)

* Address To : Null.

* SON : Varchar (3)

* USER ID : " 4

* Few Keywords : MM BLOB

* File : PGM

* Forced Closure Date :

* Serial No. to be printed on objects.

 

Page-1

Times New Roman - size 12

A4 - Letter

1 inch - Left side

3 inch - Top

0.75 inch - Right

1.2 inch - Bottom

MENU
12 options
- None of the above.

• ADD
• VIEW
• CHANGE - Forcessal closure?
• DELETE - Forcessal DELET.

Date	S. No.
	Date

• Standardised letters need to be given by 3P Consult -
• Reports will be breaked by
• Company wise
• Division "
• Branch "
• Consultant "
• Client "

[Signature/Initial]

Reports will be printed A4 (normal)

If width is more than it will be printed if 1 and half A4.

• SOH from SOM to SOH need to be included.
• Filteration criteria for Reports

FOR APPLITECH

YOGESH DAT-

yogesh...

 

14-06-01

Venkat

Order Execution System

Last week you had given to me

Printouts of 82 Output statements

I had returned these with my remarks. Along with that, I had also sent my personal copy of REQUIREMENT CATALOGUE V 1.1 (Signed by me on 8-11-2000).

Here too, on a no. of output statements, I had made remarks, after comparing these with the print-outs.

You have forwarded both (photo-copies) to Tapan (Appltech).

NOW, with this note, I enclose:

A chart (4 pages)

"Our Customer Flight Deck Instruments"

In this, I have tried to analyse all 82 output statements along different dimensions. This "Bird's Eye View" should help us, in case, we want to delete/

add any statements in future.

SUPER-MENU

I felt that the 82 output statements should be re-organised/re-grouped in some logical manner, which makes it easy to locate/look-up any of these.

The first thing I noticed about these statements was that

$\to$ Some were giving only past statistics. I called these "HISTORICAL" statements.

A study of these, would reveal "trends" & provide very useful "insights" and help us to take long-term strategic decisions, in terms of

• What should be our focus?
• Where should we "concentrate"?
• Which areas, need more resources?

etc. etc.

$\to$ Rest of the statements, were required to be referred to for executing ORDERS ON HAND.

These statements provided "Operational

Control", by monitoring status/tracking each activity etc.

These statements tell us, where we are (in respect of each SONs) and what next we needed to do, to execute each order expeditiously.

All consultants would need to refer to these statements, frequently, for deciding upon

• what is pending in Client's COURT?
• " " Candidate's " ?
• " " Our " ?
• Who needs to do WHAT & WHEN?

Using this division/logic, I created two charts.

• Report # 100 - Historical Statements
• " # 101 - Operation Control

Both these statements are in the form of a MATRIX / TABULATION.

Like our "Magic-Cube Search" (on the website), Applitech should create/put up these charts, as a part of a SUPER-MENU.

All that a Consultant need to do, is to click on the (Statement Number/s) and Presto!

That Statement opens-up on the computer-screen.

As Simple as that. Hassle-free search!!

Please convince Applitech to do this (Highly desirable because of its simplicity).

At the same time, I have also prepared a TRADITIONAL MENU

Where, one can click and drill-down into sub-menus. This is obvious & needs no explanation.

I have also developed a Sub-menu, centred around KEYWORDS (3.0). One never knows what "word" will come to mind in the first instance! We should have a system, where a Consultant can approach a particular statement from several "ways". (All roads lead to Mecca!)

After internal discussions amongst all consultants, you may want to

form-up / finalize the SUPER MENU and MATRIX CHARTS and then forward to Applitech to implement in OES.

In the charts, wherever, I have marked "?" I have felt that such a output statement would be desirable. However, as Operating personnel, you should decide what you want - and when (maybe OES V. 2.0 ?) you want such statements.

Please feel free to phone me/ask-me for clarifications.

You should target to send our final requirement to Applitech by Saturday (16th).

If you feel necessary, you may plan a visit to Ahmedabad (after fixing-up in advance with Tapan), to explain everything in person.

With regards,

[Signature]

cc: Nismit.

(See "CUSTOMER FLIGHT-DECK" INSTRUMENTS by Patricia Seybold) 13-6-01

Report No.	Statement Name	Type	Centred Around	Concerns
		History (Statistics)	Operation Control	Client
1	S. B. Summary (monthly)
2	" (CURL)
3	" (Period)
4	" (Vacancy)
5	" (Function)
6	" (Ind.)
7	" (Client)
8	" (Consultant)
9	INQUIRY --- (Period)
10	" (Consultant)
11	" (Ind.)
12	" (Func)
13	" (Vacancy)
14	" (City)
15	" (Country)
16	? (Remaining) - Consultant
17	? (Failure) - "
18	? (Status) - "
19	PROPOSAL
20	Sales Order
21	Project Plan
22	Project Variance
23	Pending Order (chrono)
24	" " c Client
25	" " (Vacancy)

 

13/6/01

Report No.	Statement Name	Type	Centred Around	Concerns
		History (Statistics)	Operation Control	Client
26	Pending Order (Consul/Billing value)
27	" " (client/chrono)
28	" " (client/consultant)
29	" " (client/Position)
30	" " (Client/Billing value)
31	" " (Period/Industry)
32	" " (Period/Function)
33	" " (Period/Position)
34	Pending Order Load (Consult)
35	Resumes To Send (order)
36	Resumes Already Sent (order)
37	One line Statement (Consult)
38	" " (Client)
39	List - Prospect-Candt (order)
40	Advt. Details (client/Period)
41	Advt. Response (Client/Period)
42	" " (Media/Period)
43	Int. calls Sent out (orders)
44	Int. Schedule (" ")
45	Int. Held (Client)
46	Int. Held Summary
47	Follow-Up Details (order/Client)
48	" " with Candidate (Period)
49	Expt. dt. of Joining (Client)
50	Comp. Details (order)

 

Report No.	Statement Name	Type	Centred Around	Concerns
		History (Statistics)	Operation Control	Client
51	Comp. Data to be recd (order)
52	Compen. Format
53	Invoice Format
54	Final Invoice Summary (Client)
55	" " (Consultant)
56	" " (Period)
57	" " (Date)
58	" " (Consultant)
59	OOP Invoice (client)
60	OOP Total
61	Client list (Billing/Period)
62	" " (Func)
63	" " (Industry)
64	" " (Position)
65	Janam Kundli (Client)
66	Janam Kundli (Candidate)
67	Expns. Placed (Indi.)
68	" " (Func)
69	" " (Position)
70	" " (Client)
71	" " (Joining Date)
72	" " (Annl. Salary)
73	" " (Period)
74	Orders Executed (Indi.)
75	" " (Func)

 

Report No.	Statement Name	Type	Centred Around	Concerns
		History (Statistics)	Operation Control	Client
76	Orders Executed (Position)
77	" (Industry wise Details)
78	" (Func-wise ")
79	" (Posi-wise ")
80	" (Total/Period)
81	Outstanding (Client)
82	" (Consultant)

 

SUPER-MENU

1.0	HISTORY
2.0	OPERATIONS
3.0	KEYWORDS
4.0	MATRIX

 

1.0	HISTORY	1.01	Advertisements
		1.02	Executives Placed
		1.03	Inquiries
		1.04	Invoices
		1.05	Orders Executed
		1.06	Order Value
		1.07	Shopping Basket

 

1.01	Advertisements	40	Clientwise Details
		41	Clientwise Response
		42	Mediawise Response

 

1.02	Executives Placed	67	Summary - Ind-Wise
		68	" - Function Wise
		69	" - Position Wise
		70	" - Client Wise
		71	" - Joining Date Wise
		72	" - Compensation Wise
		73	" - Consolidated

 

1.03	Inquiries	09	Consolidated
		10	Consultant-Wise
		11	Industry-Wise
		12	Function - Wise
		13	Position - Wise
		14	City - Wise
		15	Country-Wise

 

1.04	Invoices	54	Summary - Client wise
		55	" - Consultant wise
		56	" - Month wise
		57	" - Date wise
		58	" - Consultant Wise
		59	OOP - Client wise
		60	OOP - Overall

 

1.05	Orders Executed	74	Summary - Ind-Wise
		75	" - Function Wise
		76	" - Position Wise
		77	Details - Ind - Wise
		78	" - Function Wise
		79	" - Position Wise
		80	CONSOLIDATED

 

1.06	Order Value	61	Which CLIENT gave how much MONEY?
		62	" FUNCTION "
		63	" INDUSTRY "
		64	" POSITION "

 

1.07	Shopping Baskets	02	Summary - Month wise
		03	" - URL Wise
		04	" - Period Wise
		05	" - Position Wise
		06	" - Function Wise
		07	" - Industry Wise
		08	" - Client Wise
		09	" - Consultant Wise

 

2.0	OPERATIONS	2.01	Follow-Up / Candidates
		2.02	Follow-Up / General
		2.03	Follow-Up / Interviews
		2.04	Inquiries
		2.05	Project
		2.06	Pending Orders
		2.07	Resumes
		2.08	Outstandings

 

2.01	Follow-Up/Candidates	35	Whose resumes are yet to be sent against a SON?
		36	Whose resumes have already been sent against a SON?
		39	Who (all) are shortlisted against a SON? (Prospective Candidates)
		66	Janam-Kundli (Candidate)

 

2.02	Follow-Up/General	47	Activities to be followed - Order wise
		48	PEN to be followed - "
		49	Who joins When? - client wise
		50	Salary-data received - Order wise
		51	Salary-data yet to get - Order wise

 

2.03	Follow-Up/Interviews	43	Call-letters/SON wise
		44	Schedules/SON wise
		45	Summary - Client wise
		46	Summary - Overall

 

2.04	Inquiries	16	Remaining to Respond (Consultant wise)
		17	Failed to Convert (Consultant wise)
		18	Status (Consultant wise)

 

2.05	Project	19	Proposal
		20	Sales Order
		21	Project Plan (for a SON)
		22	Project Variance ( " )

 

2.06	Pending Orders	CONSULTANT-WISE
		23
		24
		25
		26
		34
		CLIENT-WISE
		27
		28
		29
		30
		PERIOD-WISE
		31
		32
		33
		?

 

2.07	Resumes	35	Remaining to be Sent (Order wise)
		36	Already Sent (Order-wise)
		37	One line Statement (for Consultant)
		38	One line Statement (for Client)
		39	Details of Prospective - Clients

 

2.08	Outstandings	81	Outstandings - Client wise
		82	Outstandings - Consultant wise

 

3.0	KEYWORDS	3.01	Consultant
		3.02	Client
		3.03	Function
		3.04	Industry
		3.05	Position (Vacancy)

 

3.01	Consultant	08	Shopping Basket - Period wise
		10	Inquiries - Period wise
		16	Inquiries - Yet to be attended
		17	Inquiries - Failed to convert
		18	Inquiry Status - overall
		23	Pending Orders - chronological
		24	" " - client wise
		25	" " - Position wise
		26	" " - Billing value wise
		28	" " - For a given client
		34	Load (on a consultant)
		37	One line statement
		55	Invoices/Final Payment Summary (M)
		58	Invoices/ " " (Period)
		82	Outstanding - Consultant wise

 

3.02	Client	27	Pending Order - chronological
		29	" " - Position wise
		30	" " - Bill value wise
		35	Resumes remaining to be sent (order wise)
		36	Resumes already sent (order wise)
		38	One line Statement (order wise ?)
		39	Details of Prospective Candidates (order wise ?)
		40	Advt - Details
		41	Advt - Response
		43	Interview - Calls sent (order wise)
		44	Interview - Schedule ( " )
		45	Interviews Held ( " )
		49	Expected date of joining ( " )
		50	Salary-details already received
		51	Salary-details to be received
		54	Invoice Summary - Final payment
		59	Out-of-Pocket Expense
		65	Janam-Kundli
		70	Executives Placed
		81	Outstandings

 

3.03	Function	05	Shopping Baskets
		12	List of Enquiries
		32	Pending Order Status
		62	Current List on order value
		68	Executives Placed - Summary
		75	Orders Executed - Summary
		78	Order Executed - Details

 

3.04	Industry	06	Shopping Basket - Summary
		11	List of Inquiries
		31	Pending Order Status
		63	Client List on Order Value
		67	Executives Placed - Summary
		74	Orders Executed - Summary
		77	Orders Executed - Details.

 

3.05	Position (Vacancy)/Designation	04	Shopping Baskets (Position - Period)
		13	List of Inquiries ( " )
		25	Pending Orders (Position - Consultant)
		29	Pending Orders (Position - Client)
		33	Pending Orders (Position - Period)
		64	Client List on Order (Vacancy - wise)
		69	Executives Placed Summary ( " )
		76	Analysis of Orders Executed Summary (Position - wise)

 

4.0	MATRIX	4.01	Historical Statements Matrix
		4.02	Operational Control Statements Matrix

 

4.01	Historical Statements Matrix	100	7 topics X 12 Keywords

 

ORDER EXECUTION SYSTEM / HISTORICAL STATEMENTS

REPORT NO $\to$ 100

(statistics to reveal trends/help take long term strategic decisions)

TOPIC	WISE	Consultant	Client	Industry	Function	Desig./Posi. Name	URL	Media	Date/Month/Period	City/Country	Overall/Consoli. Summary
Shopping Basket		08	07	06	05	04	02		01	03
Inquiry.		10		11	12	13				14	15
Advt.			40					42
			41
Invoices		55 (Mon)	54						56 (Mon)
		58 (Period)	59						57 (Date)
Order Value		?	61	63	62	64					?
Execs. Placed		?	70	67	68	69			71 (Joining Date)		72
Orders Executed		?		74 (Sum)	75 (Sum)	76 (Sum)		?
				77 (Details)	78 (Details)	79 (Details)

 

4.02	Operational Control Statements Matrix	101	11 topics X 10 Keywords

 

ORDER EXECUTION SYSTEM / OPERATIONAL - CONTROL STATEMENTS

REPORT NO $\to$ 101

	WISE	Consultant	Client	Candit-date	Industry	Function	Desig./Position	Date/Month/Period	SON	Billing	Consolidated/Overall
1	INQUIRIES - Remaining / Failed / Status	16									?
		17									?
		18									?
2	Outstandings	82	81								?
3	Interview-call sent out										43
4	Interview schedule										44
5	Interviews Held summary	45						46			?
6	Follow-up		49	48					47	39
									50	56
									51	55
7	Pending Orders - Consultant wise	23	24				25	27		26	?
8	- Client wise	28					29			30
9	- Period wise				31	32	33
10	RESUMES	37	38						35	39
									36
11	Project								21
									22

 

Minutes of Meeting

Attended by: - Mr. Hemant Parekh, Mr. Magl? | Tapan, Yogesh, Sudhakar

1. Cybil will make View in their database and will give OES rights to OES User.

(Following fields should be involved in View

• ASSIGNMENT ID
• PEN
• NAME OF CANDIDATE
• ORGANIZATION (Current)
• DESIGNATION (Current)
• EDUCATIONAL QUALIFICATION (1, 2, 3)
• PAST COMPANY DETAILS (Corporate Name, Designation)
• AGE/DOB
• CITY
• SOURCE (Location)
• PHONE (R)
• PHONE (O)
• MOBILE No.
1. Cybil will display Assignment ID to the users who is making search in Cybil. Users needs to remembers Assignment ID. When user comes to OES system, he/she must enter Assignment ID to fetch selected candidates from Cybil.
2. OES will put one field ASSIGNMENT ID (Number 6, 0) in Candidate Listing Screen.

3. PEN No. will be Number (10, 0) in OES.
4. 3P consultants will give org logo st. $\leftarrow$ (Logo needed for 3P consultant letters)
5. OES will need SOURCE (from which site mail is coming) in mails for shopping
6. There will be break in Consultant wise, Client wise along with provided in Report.
7. Another view for PEN (Reports to separate db Separate table)
8. Standardisation in table names & table space.
9. $\text{db space will start with OE in 3P}$. (OE in OES stands for Order Execution)
10. How many db space can be created in Oracle 8i? (Mail to Mr. Nagle)
11. No. of tables allowed / per db space in Oracle 8i.
12. Standardized Table (for correspondence)

UNIQUE - Correspondence Serial No.	MM (6)
Date of Letter	MM (Date)
Subject	MM (4)
Client Code	Varchar (3)
Address To	MM (4)
SON	"
USER ID	"
Few keywords	"
File	MM (BLOB)
PEN	MM (4)
Forced Closure - Date
Serial No. of PEN to be printed on all letters.

 

• Times New Roman - Size 12
• A4 - Letter.
• 1 inch - left side
• 3 inch - top
• 0.75 inch - Right
• 1.2 inch - bottom.

MENU
12 options
- None of the above.

• ADD
• VIEW
• CHANGE - Forcessal closure
• DELETE - Forcessal DELET.

Date	S. No.
SON.	Date

• Standardized letters need to be given by 3P Consult -
• Reports will be breaked by
• Company wise
• Division "
• Branch "
• Consultant "
• Client "

• Reports will be printed A4 (normal)
• If width is more then it will be printed if 1 and half A4.
• SON from SOM to SON need to be included
• Filteration criteria for Reports

FOR APPLITECH

YOGESH DAT -

yogesh...