Consultants, Abhi, Vinay, Sanjeev
COMMEENTS
· Only
following fields are "Mandatory"
. Last Name
. First Name
. Current Company Name
. Current actual Designation
All the rest of the fields are "OPTIONAL"
· Barring
"Last Name" & "First Name" & "DOB" all fields
should be "EDITABLE".
However, we must clearly lay down
.
"Who" can edit
. If more than one person can edit, should we
record the name of the person who edited & when?
. If only one person is authorized to edit,
how should info. be sent to him/her?
· Even
the FIRST - TIME ENTRY, will / may be done by
.
Different Persons, at
. Different points of time.
Should any attempt be made to capture
. Who
made that "first" entry?
. When ?
. From
what source ?
. In what
Context ?
(i.e.
for which assignment)
So that, in case of doubt, next person
"accessing / viewing" this database, could go back and ask the person
who made the ORIGINAL entry ?
· Obviously,
there are many "fields" which must not be "edited", once
(originally) entered - although once / additional data can be "added"
eg.
. Past
Companies worked for
.
Membership held
. Edu.
Qualifications etc.
So, it is absolutely essential to define at the
outset itself
. What
fields are mandatory
. What
fields you can edit/ overwrite
. What
fields you cannot edit/ overwrite
. What
you can ADD additional data
. What
fields must be "free text"
. What
fields should/ must have "dropdowns"/ Radio - buttons.
· Let
not 97 (or whatever number of) fields intimidate you !
These (many)
are only "provisions" and to forward the very first and to forward
the very first sheet to a client, a consultant would only need,
. Name of
Candidate
. Name of
Current Employer
. Current
Designation
(- may be
picked up from a newspaper/ magazine/ directly/ tv broadcast etc. etc.)
Only when a client gives us feedback (as to which
candidates he is interested in and who we should get in touch to find out, if
he/ she is interested in our client's position and if yes, obtain resume /
conduct prelim. interview), then only,
. The
work of filling - up some more "fields" starts.
. And, I
presume, a constant would, even at this stage, fill - in ONLY those fields,
which he/ she would need to CONSTRUCT the "EXCEL" sheet dynamically.
. Abhi
has promised that a consultant can construct a UNIQUE excel sheet, by selecting
. Any
no. of "fields"
.
Arranged in any "order"
. 97
fields could give us "Millions" of permutations / combinations of
excel sheets ! - Practically unlimited options, created dynamically !!
