EMMain 
Default Table Name  EMMain 
Definition  
Employee Table
 

EMMain Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Employee(PK)    nvarchar(20)  NO  
Employee number.
 
HomeCompany    nvarchar(14)  NO  
Employee'sHome Company
 
LastName    nvarchar(50)  YES  
Employee's last name.
 
FirstName    nvarchar(25)  YES  
Employee's first name.
 
MiddleName    nvarchar(50)  YES  
Employee's middle name.
 
BillingPool    smallint  NO  
Reserved for future use.
 
SSN    nvarchar(11)  YES  
The employee's Social Security number.
 
Address1    nvarchar(50)  YES  
First line of the employee's address.
 
Address2    nvarchar(50)  YES  
Second line of the employee's address.
 
Address3    nvarchar(50)  YES  
Third line of the employee's address.
 
City    nvarchar(30)  YES  
Employee's city.
 
State    nvarchar(10)  YES  
Employee's state; populated from the CFGStates Table.
 
ZIP    nvarchar(10)  YES  
Employee's zip code.
 
Country    nvarchar(2)  YES  
Employee's country.
 
HomePhone    nvarchar(24)  YES  
The employee's home telephone number.
 
Fax    nvarchar(24)  YES  
The employee's fax number.
 
EMail    nvarchar(50)  YES  
The employee's e-mail address.
 
TKAdminLevel    varchar(1)  YES  
The employee's Time Administration level.
 
TKAdminEdit    varchar(1)  NO  
Variable indicating whether the employee can edit the timesheets of other users in the same Time group.
 
EKAdminLevel    varchar(1)  YES  
The employee's Expense Administration level.
 
EKAdminEdit    varchar(1)  NO  
Variable indicating whether this employee can edit the expense reports of other employees in the same Expense group.
 
Memo    nvarchar(4000)  YES  
Memo field for comments on the employee.
 
EmployeePhoto    nvarchar(255)  YES  
This column is obsolete.
 
Salutation    nvarchar(10)  YES  
The prefix to use with this employee's name.
 
Suffix    nvarchar(20)  YES  
The suffix to use with this employee's name.
 
Title    nvarchar(50)  YES  
The employee's job title.
 
ExportInd    varchar(1)  NO  
Reserved for future use.
 
WorkPhone    nvarchar(24)  YES  
The employee's work telephone number.
 
WorkPhoneExt    nvarchar(8)  YES  
The employee's work telephone number extension.
 
MobilePhone    nvarchar(24)  YES  
The employee's cell phone number.
 
AvailableForCRM    varchar(1)  NO  
Variable indicating whether the record is available to CRM users. The default value is Yes.
 
ReadyForApproval    varchar(1)  NO  
Variable indicating whether the record is available to Accounting users.
 
PreferredName    nvarchar(60)  YES  
The employee's preferred name, as entered on the general tab of the Employee Info Center.
 
HomePhoneFormat    nvarchar(24)  YES  
The number format to use for the HomePhone value.
 
FaxFormat    nvarchar(24)  YES  
The number format to use for the Fax value.
 
WorkPhoneFormat    nvarchar(24)  YES  
The number format to use for the WorkPhone value.
 
MobilePhoneFormat    nvarchar(24)  YES  
The number format to use for the MobilePhone value.
 
Language    varchar(10)  YES  
For internal use.
 
TargetRatio    decimal(19, 4)  NO  
The percentage of the employee's hours they are expected to charge to a project.
 
UtilizationRatio    decimal(19, 4)  NO  
The employee's Utilization Ratio, as entered on the Accounting tab.
 
ConsultantInd    varchar(1)  NO  
Variable indicating whether the employee is a consultant.
 
ClientVendorInd    varchar(1)  YES  
Flag indicating whether the Client/Vendor option is selected.
 
ClientID    varchar(32)  YES  
The internal identifier for the client selected.
 
Vendor    nvarchar(20)  YES  
If ConsultantInd in this table is Yes, the name of the vendor/consultant.
 
TalentUserID    nvarchar(40)  YES  
TalentUser ID
 
Location    nvarchar(10)  YES  
Location
 
TLInternalKey    nvarchar(40)  YES  
The internal ID for TrafficLIVE.
 
ProfessionalSuffix    nvarchar(255)  YES  
The professional title added at the end of the employee's name.
 
TalentModDate    datetime  YES  
The field that tracks changes to the mapped fields in Talent Management.
 
TLSyncModDate    datetime  YES 
 
KonaUsername    nvarchar(255)  YES 
 
KonaAccessToken    nvarchar(255)  YES 
 
KonaRefreshToken    nvarchar(255)  YES 
 
KonaUserID    int  NO 
 
ADA    varchar(1)  NO 
 
BirthDate    datetime  YES 
 
Gender    varchar(1)  YES 
 
MaritalStatus    varchar(1)  YES 
 
Ethnicity    nvarchar(10)  YES 
 
VisaType    nvarchar(10)  YES 
 
VisaCountry    nvarchar(2)  YES 
 
VisaNumber    nvarchar(40)  YES 
 
VisaExpDate    datetime  YES 
 
Disabled    varchar(1)  NO 
 
AlienNumber    nvarchar(40)  YES 
 
PassportCountry    nvarchar(2)  YES 
 
PassportNumber    nvarchar(40)  YES 
 
PassportExpDate    datetime  YES 
 
CitizenshipStatus    varchar(1)  YES 
 
I9Verification    varchar(1)  YES 
 
MailAddress1    nvarchar(50)  YES 
 
MailAddress2    nvarchar(50)  YES 
 
MailAddress3    nvarchar(50)  YES 
 
MailCity    nvarchar(30)  YES 
 
MailState    nvarchar(10)  YES 
 
MailZIP    nvarchar(10)  YES 
 
MailCountry    nvarchar(2)  YES 
 
HomeEmail    nvarchar(100)  YES 
 
PrimaryContact    nvarchar(100)  YES 
 
PrimaryContactPhone    nvarchar(24)  YES 
 
PrimaryContactRelationship    nvarchar(10)  YES 
 
SecondaryContact    nvarchar(100)  YES 
 
SecondaryContactPhone    nvarchar(24)  YES 
 
SecondaryContactRelationship    nvarchar(10)  YES 
 
VetStatus    varchar(1)  NO 
 
VetType    nvarchar(10)  YES 
 
SeparationDate    datetime  YES 
 
PrimaryContactPhoneFormat    nvarchar(24)  YES 
 
SecondaryContactPhoneFormat    nvarchar(24)  YES 
 
MailAddressSameAsHome    varchar(1)  NO 
 
CreateUser    nvarchar(20)  YES  
The username of the user creating this record.
 
CreateDate    datetime  YES  
The date and time when this record was created.
 
ModUser    nvarchar(20)  YES  
The username of the user logged in when this record was modified.
 
ModDate    datetime  YES  
The date and time when this record was modified.
 

EMMain Primary and Unique Keys 
Key Name  Key Type  Keys 
EMMainPK  PrimaryKey  Employee 

EMMain Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication