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
|