CHECK-HEALTH-OF-IT-KEYWORDS

16 Jul 2007

CHECK-HEALTH-OF-IT-KEYWORDS

THIS PROJECT WAS CREATED TO LOOK INTO THE HEALTH OF THE KEYWORDS.

DATABASE: ACCESS

D:\sourabh\projects\VBPROJECTS\check-health-of-it-keywords\check\GRlist.mdb

THIS IS THE TABLE STRUCTURE

THE DATABASE IS CREATED WITH THE HELP OF SQL DATA EXPORT FEATURE

MODULES

1. DISPLAY THE KEYWORDS

2. CALCULATE KEYWORDS AND CREATE HTML

3. VIEW THE HTML

1. DISPLAY THE KEYWORDS

THIS MODULE IS A SIMPLE DISPLAY OF ALL THE FUNCTIONS AND THEIR KEYWORDS, WITH FREQUENCIES

2. CALCULATE KEYWORDS AND CREATE HTML

THIS MODULE IS TOWARDS CREATING HTML FILES OF THE SPECIFIC FUNCTIONS, WITH THEIR FREQUENCIES.

THE BUTTON “get all functions without percentage” IS CREATED TO PRODUCE HTML FILES WITHOUT THE FREQUENCIES BREAKUP

THE SECOND BUTTON “get all functions WITH percentage” GIVES THE POWER IN THE HANDS OF THE USER TO DECIDE OPN THE CUTOFF.

IF THE USER TYPES 5 AS CUTOFF IN THE TEXTBOX AND THE PRESSES THE BUTTON THEN THE HTML FILES WILL BE GENMERATED WITH 5 AS BEING THE CUTOFF AND ALL THE OTHER ENTRIES WILL BE HIGHLIGHTED IN RED.

AS SHOWN IN THE LAST IMAGE.

Hemen Parekh

FUNCTION-KEYWORDS-TEMP

27 June 2007

FUNCTION-KEYWORDS-TEMP 

Date properties

FUNCTIONKEYWORDDOUBLEREFINED

FUNCTIONKEYWORDREFINED 

GRFUNCTIONLIST 

GRPERSONBASIC 

IT FUNCTIONLIST 

IT KEYWORDLIST 

IT KEYWORDMATCHES 

KEYWORDMATCHAES 

KEYWORDMATCHAESDONE 

TEMP FUNCTION KEYWORD DOUBLE REFINED

TEMPKEYWORDMATCHES 

TEMPKEYWORDSMATCHESDONE 

Hemen Parekh

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