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