Share via

Employees

  • Article

Use this list to maintain basic information about employees.

column datatype Display Name Hidden Required Sealed PK FK
ID Counter ID False False True yes  
ContentTypeId ContentTypeId ContentTypeID True False True    
ContentType Text ContentType False False False    
Title Text LastName False True True    
Modified DateTime Modified False False True    
Created DateTime Created False False True    
Author User CreatedBy False False True    
Editor User ModifiedBy False False True    
_HasCopyDestinations Boolean HasCopyDestinations True False True    
_CopySource Text CopySource True False True    
owshiddenversion Integer owshiddenversion True False True    
WorkflowVersion Integer WorkflowVersion True False False    
_UIVersion Integer UIVersion True False False    
_UIVersionString Text Version False False False    
Attachments Attachments Attachments False False True    
_ModerationStatus ModStat ApprovalStatus True False True    
_ModerationComments Note ApproverComments True False True    
Edit Computed Edit False False True    
LinkTitleNoMenu Computed Title False False False    
LinkFilenameNoMenu     False False False    
LinkTitle Computed Title False False False    
LinkTitleNoMenu     False False False    
_EditMenuTableStart     False False False    
LinkTitleNoMenu     False False False    
_EditMenuTableEnd     False False False    
SelectTitle Computed Select True False True    
InstanceID Integer InstanceID True False True    
Order Number Order True False True    
GUID Guid GUID True False True    
WorkflowInstanceID Guid WorkflowInstanceID True False False    
FileRef Lookup URLPath True False False   Docs.FullUrl
FileDirRef Lookup Path True False False   Docs.DirName
Last_x0020_Modified Lookup Modified True False False   Docs.TimeLastModified
Created_x0020_Date Lookup Created True False False   Docs.TimeCreated
FSObjType Lookup ItemType True False False   Docs.FSType
PermMask Computed EffectivePermissionsMask True False False    
FileLeafRef File Name True False False    
UniqueId Lookup UniqueId True False False   Docs.UniqueId
ProgId Lookup ProgId True False False   Docs.ProgId
ScopeId Lookup ScopeId True False False   Docs.ScopeId
File_x0020_Type Text FileType True False False    
HTML_x0020_File_x0020_Type Computed HTMLFileType True False False    
_EditMenuTableStart Computed EditMenuTableStart True False False    
ServerUrl     False False False    
FileDirRef     False False False    
PermMask     False False False    
_EditMenuTableEnd Computed EditMenuTableEnd True False False    
LinkFilenameNoMenu Computed Name True False False    
ServerUrl     False False False    
PermMask     False False False    
LinkFilename Computed Name True False False    
LinkFilenameNoMenu     False False False    
_EditMenuTableStart     False False False    
LinkFilenameNoMenu     False False False    
_EditMenuTableEnd     False False False    
DocIcon Computed Type False False False    
ServerUrl Computed ServerRelativeURL True False False    
EncodedAbsUrl Computed EncodedAbsoluteURL True False False    
BaseName Computed FileName True False False    
MetaInfo Lookup PropertyBag True False False   Docs.MetaInfo
_Level Integer Level True False False    
_IsCurrentVersion Boolean IsCurrentVersion True False False    
FirstName Text FirstName False False True    
FullName Computed FullName False False True    
JobTitle Text JobTitle False False True    
Image URL Image False False True    
Parttime Boolean Part-time False False True    
Email Text E-mailAddress False False True    
AltEmail Text Alt.E-mailAddress False False True    
OfficePhone Text OfficePhone False False True    
HomePhone Text HomePhone False False True    
EmergencyContactNa Text EmergencyContactName False False True    
EmergencyRelationship Text EmergencyRelationship False False True    
EmergencyAddress Text EmergencyAddress False False True    
EmergencyPhone Text EmergencyPhone False False True    
MobilePhone Text MobilePhone False False True    
FaxNumber Text FaxNumber False False True    
WorkAddress Text WorkAddress False False True    
WorkCity Text WorkCity False False True    
WorkState Text WorkState False False True    
WorkZip Text WorkZip False False True    
WorkCountry Text WorkCountry/Region False False True    
Notes Note Notes False False True    
_MSIWS_SampleData Boolean _MSIWS_SampleData True False True