FieldType:varchar

From MintHCM Wiki

varchar
Name varchar
Db Type varchar
Default lenght 255
Is Complex No

Description

Fields of this type

FieldModule
accept status id@CandidatesCandidates
accept status id@EmployeesEmployees
accept status id@UsersUsers
accept status@CallsCalls
accept status@MeetingsMeetings
accomodations@DelegationsDelegations
address city@EmployeesEmployees
address city@FP Event LocationsLocations
address city@UsersUsers
address country@EmployeesEmployees
address country@FP Event LocationsLocations
address country@UsersUsers
address postalcode@EmployeesEmployees
address postalcode@FP Event LocationsLocations
address postalcode@UsersUsers
address state@EmployeesEmployees
address state@FP Event LocationsLocations
address state@UsersUsers
address street@EmployeesEmployees
address street@UsersUsers
address@FP Event LocationsLocations
alt address city@CandidatesCandidates
alt address city@personPerson
alt address country@CandidatesCandidates
alt address country@personPerson
alt address postalcode@CandidatesCandidates
alt address postalcode@personPerson
alt address state@CandidatesCandidates
alt address state@personPerson
alt address street 2@CandidatesCandidates
alt address street 2@personPerson
alt address street 3@CandidatesCandidates
alt address street 3@personPerson
alt address street@personPerson
assistant@CandidatesCandidates
assistant@personPerson
authenticate id@EmployeesEmployees
authenticate id@UsersUsers
bcc addrs names@EmailsEmails
capacity@FP Event LocationsLocations
cc addrs names@EmailsEmails
change log@DocumentRevisionsDocument Revisions
change log@SurveysSurveys
comments@WorkSchedulesWork Schedule
contact email@NotesNotes
contract name@DocumentsDocuments
contract status@DocumentsDocuments
created by name@EmployeesEmployees
created by name@UsersUsers
created by@EmailTemplatesEmail - Templates
creator@MeetingsMeetings
delegation id@DelegationsDelegations
department@CandidatesCandidates
department@EmployeesEmployees
department@UsersUsers
department@personPerson
dissatisfied text@SurveysSurveys
doc id@DocumentRevisionsDocument Revisions
doc id@DocumentsDocuments
doc url@DocumentRevisionsDocument Revisions
doc url@DocumentsDocuments
document id@DocumentRevisionsDocument Revisions
document name@DocumentRevisionsDocument Revisions
document name@DocumentsDocuments
document revision id@DocumentsDocuments
email1@CandidatesCandidates
email1@EmployeesEmployees
email1@UsersUsers
email1@personPerson
email2@CandidatesCandidates
email2@personPerson
employee status@EmployeesEmployees
employee status@UsersUsers
external id@MeetingsMeetings
file ext@DocumentRevisionsDocument Revisions
file mime type@DocumentRevisionsDocument Revisions
file mime type@NotesNotes
first name@CandidatesCandidates
first name@personPerson
folder type@EmailsEmails
folder@EmailsEmails
from addr name@EmailsEmails
from city@TransportationsTransportations
gsync id@MeetingsMeetings
host url@MeetingsMeetings
id@DocumentRevisionsDocument Revisions
imap keywords@EmailsEmails
inbound email record@EmailsEmails
intent@EmailsEmails
is imported@EmailsEmails
jjwg maps address c@MeetingsMeetings
jjwg maps address c@ProjectProject
jjwg maps geocode status c@MeetingsMeetings
jjwg maps geocode status c@ProjectProject
join url@MeetingsMeetings
last name@CandidatesCandidates
last name@personPerson
last rev created name@DocumentsDocuments
last rev mime type@DocumentsDocuments
latest revision id@DocumentRevisionsDocument Revisions
latest revision id@DocumentsDocuments
latest revision name@DocumentsDocuments
latest revision@DocumentRevisionsDocument Revisions
latest revision@DocumentsDocuments
link declined@FP eventsEvents
link@FP eventsEvents
linked id@DocumentsDocuments
location@MeetingsMeetings
mail sendtype@OutboundEmailAccountsOutbound Email Accounts
mail smtppass@OutboundEmailAccountsOutbound Email Accounts
mail smtpport@OutboundEmailAccountsOutbound Email Accounts
mail smtpserver@OutboundEmailAccountsOutbound Email Accounts
mail smtptype@OutboundEmailAccountsOutbound Email Accounts
mail smtpuser@OutboundEmailAccountsOutbound Email Accounts
message id@EmailsEmails
messenger id@EmployeesEmployees
messenger id@UsersUsers
modified by name@EmployeesEmployees
modified by name@UsersUsers
msgno@EmailsEmails
name@DelegationsDelegations
name@DocumentsDocuments
name@EmailTemplatesEmail - Templates
name@EmployeesEmployees
name@UsersUsers
neither text@SurveysSurveys
other transportation@TransportationsTransportations
outlook id@CallsCalls
outlook id@MeetingsMeetings
parent type@EmailsEmails
password@MeetingsMeetings
primary address city@CandidatesCandidates
primary address city@personPerson
primary address country@CandidatesCandidates
primary address country@personPerson
primary address postalcode@CandidatesCandidates
primary address postalcode@personPerson
primary address state@CandidatesCandidates
primary address state@personPerson
primary address street 2@CandidatesCandidates
primary address street 2@personPerson
primary address street 3@CandidatesCandidates
primary address street 3@personPerson
primary address street@personPerson
projecttask issue tracker@SpentTimeUsers Actual Effort
published@EmailTemplatesEmail - Templates
raw source@EmailsEmails
recurring source@CallsCalls
recurring source@MeetingsMeetings
related doc id@DocumentsDocuments
related doc rev id@DocumentsDocuments
related doc rev number@DocumentsDocuments
repeat dow@CallsCalls
repeat dow@MeetingsMeetings
repeat dow@WorkSchedulesWork Schedule
repeat pane@MeetingsMeetings
repeat pane@WorkSchedulesWork Schedule
reply to addr@EmailsEmails
reschedule count@CallsCalls
reschedule history@CallsCalls
revision@AOK KnowledgeBaseKnowledge Base
revision@DocumentRevisionsDocument Revisions
revision@DocumentsDocuments
satisfied text@SurveysSurveys
securitygroup noninherit id@EmployeesEmployees
securitygroup noninherit id@UsersUsers
selected revision filename@DocumentsDocuments
selected revision id@DocumentsDocuments
selected revision name@DocumentsDocuments
set accept links@CallsCalls
set accept links@MeetingsMeetings
skype@CandidatesCandidates
smtp from addr@OutboundEmailAccountsOutbound Email Accounts
smtp from name@OutboundEmailAccountsOutbound Email Accounts
status@DocumentsDocuments
subject@EmailTemplatesEmail - Templates
submit text@SurveysSurveys
time tracking pane@WorkSchedulesWork Schedule
title@CandidatesCandidates
title@EmployeesEmployees
title@UsersUsers
title@personPerson
to addrs names@EmailsEmails
to city@TransportationsTransportations
type@OutboundEmailAccountsOutbound Email Accounts
uid@EmailsEmails
user hash@EmployeesEmployees
user hash@UsersUsers
version@RecruitmentsRecruitments

Add new Field

Related Features

Mentioned in other articles