25 June 2007

INTERVIEW-QUESTIONS

AI_FUNCTION_SUBCATEGORY_MAPPER

COLUMN_NAME	DATA_TYPE	LENGTH
FID	numeric	Null
FNAME	varchar	500
SID	numeric	Null
SNAME	varchar	500

AIBASE

COLUMN_NAME	DATA_TYPE	LENGTH
PKID	numeric	Null
FUNCTIONS	varchar	500
FUNCTIONURL	varchar	500
VALIDITY	varchar	1

 

AIPRIMARYFUNCTIONS 

COLUMN_NAME	DATA_TYPE	LENGTH
ID	numeric	Null
FUNCTIONNAME	varchar	500
FUNCTIONURL	varchar	500

AIQUESTIONS

COLUMN_NAME	DATA_TYPE	LENGTH
FID	numeric	Null
SID	numeric	Null
TID	numeric	Null
TNAME	varchar	500
QID	numeric	Null
QUESTION	varchar	500
UPDATED	varchar	1

AISECONDRYFUNCTIONS

COLUMN_NAME	DATA_TYPE	LENGTH
FUNCTIONID	numeric	Null
FUNCTIONNAME	varchar	500
SUBCATEGORYID	numeric	Null
SUBCATEGORY	varchar	500
SUBCATEGORYURL	varchar	500

AITERTIORYFUNCTIONS

COLUMN_NAME	DATA_TYPE	LENGTH
FID	numeric	Null
SID	numeric	Null
SNAME	varchar	500
TERTIORYFNID	numeric	Null
TERTIORYFN	varchar	500
TERTIORYFNURL	varchar	500

DTPROPERTIES

COLUMN_NAME	DATA_TYPE	LENGTH
id	int	Null
objectid	int	Null
property	varchar	64
value	varchar	255
unvalued	nvarchar	255
value	image	2147483647
version	int	Null

GRFUNCTIONLIST

COLUMN_NAME	DATA_TYPE	LENGTH
FUNCTIONID	decimal	Null
FUNCTIONNM	varchar	100
ENTERDT	datetime	Null
COMPANYCD	varchar	10
INUSE	char	1

GRKEYWORDLIST

COLUMN_NAME	DATA_TYPE	LENGTH
KEYWORDNM	varchar	120
COUNTER	decimal	Null

IT-FUNCTIONLIST

COLUMN_NAME	DATA_TYPE	LENGTH
ID	int	Null
FUNCTIONNAME	varchar	500

 

 IT-HIGHLIGHTED-KEYWORDS

COLUMN_NAME	DATA_TYPE	LENGTH
FID	int	Null
KEYWORD	varchar	500
WEIGHT	int	Null

IT-KEYWORDS-EXCEL

COLUMN_NAME	DATA_TYPE	LENGTH
FID	numeric	Null
KEYWORD	varchar	500
WEIGHT	numeric	Null
SELECTED	varchar	1

JOBADVT

COLUMN_NAME	DATA_TYPE	LENGTH
ADVTID	varchar	50
ADVTSOURCE	varchar	50
DESIGNATIONNM	varchar	150
COMPANYNM	varchar	150
CITYNM	varchar	500
MINEXP	numeric	Null
MAXEXP	numeric	Null
LEVELNM	varchar	100
JOBPOSTEDDT	datetime	Null
EMAIL	varchar	100
JOBFULLADVT	text	2147483647
JOBFULLADVTPLAIN	text	2147483647
FUNCTIONID	numeric	Null

JOBDESCERRORS

COLUMN_NAME	DATA_TYPE	LENGTH
ERRORS	varchar	500
TYPE	varchar	50

JOBDESCRIPTION

COLUMN_NAME	DATA_TYPE	LENGTH
JOBID	numeric	Null
JOBMAINTITLE	varchar	500
JOBMAINALTERNATIVE	varchar	500
JOBTITLE	varchar	500
JOBALTERNATIVE	varchar	500
JOBDESC	text	2147483647

MONRESUME

COLUMN_NAME	DATA_TYPE	LENGTH
PKID	decimal	Null
PROCESSID	decimal	Null
EMAILID	varchar	75
RESUMEHTML	text	2147483647
RESUMETEXT	text	2147483647
PROCESSDATE	datetime	Null

RESULTS

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

SOFTSKILLSMASTER

COLUMN_NAME	DATA_TYPE	LENGTH
ID	int	Null
LINKS	nvarchar	255
NAME	nvarchar	255
SOFTSKILL	nvarchar	1

SOFTSKILLSQUESTIONS

COLUMN_NAME	DATA_TYPE	LENGTH
CATID	smallint	Null
QID	smallint	Null
QUESTION	next	1073741823

Hemen Parekh