Hi Friends,

Even as I launch this today ( my 80th Birthday ), I realize that there is yet so much to say and do.

There is just no time to look back, no time to wonder,"Will anyone read these pages?"

With regards,
Hemen Parekh
27 June 2013

Wednesday, 27 June 2007

FUNCTION-KEYWORDS-TEMP

27 June 2007

FUNCTION-KEYWORDS-TEMP 


Date properties












FUNCTIONKEYWORDDOUBLEREFINED

FUNCTIONKEYWORDREFINED 












GRFUNCTIONLIST 














GRPERSONBASIC 
















IT FUNCTIONLIST 















IT KEYWORDLIST 














IT KEYWORDMATCHES 










KEYWORDMATCHAES 





TEMP FUNCTION KEYWORD DOUBLE REFINED









TEMPKEYWORDMATCHES 






TEMPKEYWORDSMATCHESDONE 
















Hemen Parekh

Monday, 25 June 2007

RESUME

25 June 2007

RESUME

CONFIGTABLE 


COLUMN NAME
DATA TYPE
LENGTH
CONFIGNAME
varchar
50
CONFIGVALUE
numeric
NULL
CONFIGACTUAL
numeric
NULL
CONFIGDATE
datetime
NULL

 

CONSULTANT ROLE MASTER

 

COLUMN NAME
DATA TYPE
LENGTH
ROLEID
int
NULL
ROLENM
nvarchar
255
CONSULTANT
nvarchar
50
COMPLETED
nvarchar
50

 

CONSULTANTMASTER

 

COLUMN NAME
DATA TYPE
LENGTH
PKID
numeric
NULL
Username
varchar
50
Password
varchar
50
InUse
char
10

 

DESIGNATION LIST

 

COLUMN NAME
DATA TYPE
LENGTH
ID
int
NULL
DNAME
nvarchar
255
STATUS
varchar
1

 

DESIGNATION LIST TWO

 

COLUMN NAME
DATA TYPE
LENGTH
FID
int
NULL
FNAME
nvarchar
255
STATUS
varchar
1

 

DESIGNATION MASTER

 

COLUMN NAME
DATA TYPE
LENGTH
ID
int
NULL
DNAME
varchar
500

 

DT PROPERTIES 

 

COLUMN NAME
DATA TYPE
LENGTH
id
int
NULL
objectid
int
NULL
property
varchar
64
value
varchar
255
uvalue
nvarchar
255
lvalue
image
2147483647
version
int
NULL

 

JOBADVT

 

COLUMN NAME
DATA TYPE
LENGTH
ADVTID
varchar
50
ADVTSOURCE
varchar
50
DESIGNATIONNM
varchar
150
COMPANYNM
varchar
150
CITYNM
varchar
500
MINEXP
decimal
NULL
MAXEXP
decimal
NULL
LEVELNM
varchar
100
JOBPOSTEDDT
datetime
NULL
EMAIL
varchar
100
JOBFULLADVT
text
2147483647
JOBFULLADVTPLAIN
text
2147483647
FUNCTIONID
decimal
NULL

 

KEYWORD LIST 

 

COLUMN NAME
DATA TYPE
LENGTH
ID
numeric
NULL
KEYWORD
varchar
500
WEIGHT
numeric
NULL

 

KEYWORD LIST TWO 

 

COLUMN NAME
DATA TYPE
LENGTH
ID
numeric
NULL
KEYWORD
varchar
500
WEIGHT
numeric
NULL

 

MONCATEGORY

 

COLUMN NAME
DATA TYPE
LENGTH
CATEGORYID
int
NULL
CATEGORYNM
varchar
50

 

 MONCATEGORYROLE

 

COLUMN NAME
DATA TYPE
LENGTH
CATEGORYID
int
NULL
ROLEID
int
NULL
ROLENM
varchar
50

 

MONDEGREE

 

COLUMN NAME
DATA TYPE
LENGTH
DEGREEID
int
NULL
DEGREENM
varchar
50
SPECIALID
varchar
250

 

 MONDEGREESPCIAL

COLUMN NAME
DATA TYPE
LENGTH
DEGREEID
int
NULL
DEGREESPECIALID
int
NULL
DEGREESPECIALNM
varchar
50

 

MONDEGREESPECIALMAPPING

 

COLUMN NAME
DATA TYPE
LENGTH
DEGREEID
int
NULL
DEGREESPECIALID
int
NULL

 

  MONINDUSTRY

  

COLUMN NAME
DATA TYPE
LENGTH
INDUSTRYID
int
NULL
INDUSTRYNM
varchar
50

 

MONLOCATION

 

COLUMN NAME
DATA TYPE
LENGTH
LOCATIONID
int
NULL
LOCATIONNM
varchar
50

 

MONRESUME


COLUMN NAME
DATA TYPE
LENGTH
PKID
numeric
NULL
PROCESSID
numeric
NULL
EMAILID
varchar
75
RESUMEHTML
text
2147483647
RESUMETEXT
text
2147483647
PROCESSDATE
datetime
NULL

 

MONRESUMERANGE

 

COLUMN NAME
DATA TYPE
LENGTH
RANGEID
int
NULL
RANGENM
varchar
50

 

MONSEARCH

 

COLUMN NAME
DATA TYPE
LENGTH
PKID
numeric
NULL
SEARCHNAME
varchar
500
KEYWORDNAMES
varchar
500
MINEXP
varchar
5
MAXEXP
varchar
5
MINSAL
varchar
50
MAXSAL
varchar
50
INDUSTRYIDS
varchar
500
LOCATIONIDS
varchar
500
CATEGORYIDS
varchar
500
ROLEIDS
varchar
500
DEGREEIDS
varchar
500
DEGREESPECIALIDS
varchar
500
IIMS
bit
NULL
IITS
bit
NULL
TOP_UNIVERSITY
bit
NULL
TOP_BUSINESS
bit
NULL
TOP_ENGG
bit
NULL
RESUMERANGEIDS
varchar
500
COMPANYNAMES
varchar
500
PROCESSED
char
1
EMAIL_ID
varchar
75
SEARCHDATE
datetime
NULL

 

MONSENDMAIL1

 

COLUMN NAME
DATA TYPE
LENGTH
MAILID
decimal
NULL
RESUMEID
decimal
NULL
PROCESSID
decimal
NULL
CANDNAME
text
2147483647
CLIENTNAME
text
2147483647
CLIENTPROFILE
text
2147483647
JOBPROFILE
text
2147483647
CANDPROFILE
text
2147483647
POSITIONTYPE
varchar
1
WORKHRS
varchar
1
SENDDATE
datetime
NULL
SENDERNAME
varchar
50
SENDEREMAILID
varchar
50
STATUS
varchar
50
UPDATESTATUS
varchar
50
UPDATEDATE
datetime
NULL
DESIGNATION
varchar
70

 

MONSENTMAILSMASTER

 

COLUMN NAME
DATA TYPE
LENGTH
MAILID
decimal
NULL
RESUMEID
decimal
NULL
PROCESSID
decimal
NULL
CANDNAME
text
2147483647
CLIENTNAME
text
2147483647
CLIENTPROFILE
text
2147483647
JOBPROFILE
text
2147483647
CANDPROFILE
text
2147483647
POSITIONTYPE
varchar
1
WORKHRS
varchar
1
SENDDATE
datetime
NULL
SENDERNAME
varchar
50
SENDEREMAILID
varchar
50
STATUS
varchar
50
UPDATESTATUS
varchar
50
UPDATEDATE
datetime
NULL
DESIGNATION
varchar
70

 

MONUPDATESEARCH

 

COLUMN NAME
DATA TYPE
LENGTH
MONSEARCHID
decimal
NULL
SEARCHNAME
varchar
500
KEYWORDNAMES
varchar
500
MINEXP
varchar
5
MAXEXP
varchar
5
MINSAL
varchar
50
MAXSAL
varchar
50
INDUSTRYIDS
varchar
500
LOCATIONIDS
varchar
500
CATEGORYIDS
varchar
500
ROLEIDS
varchar
500
DEGREEIDS
varchar
500
DEGREESPECIALIDS
varchar
500
IIMS
bit
NULL
IITS
bit
NULL
TOP_UNIVERSITY
bit
NULL
TOP_BUSINESS
bit
NULL
TOP_ENGG
bit
NULL
RESUMERANGEIDS
varchar
500
COMPANYNAMES
varchar
500
PROCESSED
char
1
EMAIL_ID
varchar
75
SEARCHDATE
datetime
NULL
UPDATEDATE
datetime
NULL

 

OFFLINE RESUMES MATCH INDEX

 

COLUMN NAME
DATA TYPE
LENGTH
PKID
numeric
NULL
DESIGID
numeric
NULL
RESUMEHTML
text
2147483647
MATCH_INDEX
numeric
NULL
FILEPATH
varchar
500
EMAIL
varchar
150

 

OFFLINE RESUMES MATCH INDEX TWO

 

COLUMN NAME
DATA TYPE
LENGTH
PKID
numeric
NULL
DESIGID
numeric
NULL
RESUMEHTML
text
2147483647
MATCH_INDEX
numeric
NULL
FILEPATH
varchar
500
EMAIL
varchar
150

 

SENIOREXECUTIVEDETAILS

 

COLUMN NAME
DATA TYPE
LENGTH
PKID
numeric
NULL
FIRSTNAME
varchar
50
LASTNAME
varchar
50
CURRENTLOCATION
varchar
50
DATEOFBIRTH
Date time
NULL
AGE
numeric
NULL
TOTALEXPERIENCE
numeric
NULL
ROLE
varchar
50
CURRENTEMPLOYER
varchar
50
SALARY
numeric
NULL
DEGREE1
varchar
50
DEGREE2
varchar
50
DEGREE3
varchar
50
DEGREE4
varchar
50
EMAIL
varchar
50
RESIDENCEPHONE
numeric
NULL
MOBILE
varchar
50
CONSULTANTEMAIL
varchar
50
COMMENTS
varchar
50
ENTERDATE
Date time
NULL
UPDATEDATED
Date time
NULL

 

TEMP DESIGNATIONS

 

COLUMN NAME
DATA TYPE
LENGTH
designationnm
varchar
150

 

USERLIST

 

COLUMN NAME
DATA TYPE
LENGTH
PKID
numeric
NULL
EMAILID
varchar
70
USERPASSWORD
varchar
70
PROCESSDATE
datetime
NULL
RESUMENUMER
numeric
NULL

 


Hemen Parekh