clsImportEmployee Properties

Project Template: Absence (internal project) projectnumber. clsImportProjecteProjectType

Project Template: Absence projectnumber. clsImportProjecteProjectType

Accounting Cost Rate: First cost rate for the internal service charge modul

Accounting Cost Rate: Second cost rate for the internal service charge modul

Accounting Cost Rate: Third cost rate for the internal service charge modul

Accounting Cost Rate: Fourth cost rate for the internal service charge modul

Accounting Cost Rate: Currency for the internal service charge rates. Use ISO Currency code

AccMode of the User

Company Address Block

Company Address Building

AddressName3

Salutation Like "Dear Sir John Doe"

AdressMemo

[Mandatory] Business Unit of the employee (1:1 for fixed employees, 1:n for freelancers). See dimension clsImportSetupBusinessUnits for details.

Link to employee calendar. Link to the Calendar Table

Last change date. Filled automatically

NVARCHAR(4) Last change user ID. Filled automatically

Company Address City

Responsible Cost Centre (Company Business Unit) (Cost Centre)

Responsible Cost Center dimenson 2

Responsible Cost Center dimenson 3

Responsible Cost Center dimenson 4

Responsible Cost Center dimenson 5

Responsible Cost Objektive (Company Business Unit) (field not used)

Costprice per hour for project planning and internal service charges. (Sales prices is defined in the sales contract position)

Second cost rate. Is only used when CostRateType = MainBusinessUnitOtherThanOthers

Please use PoliticalCostRatesType instead. Normaly an employee will have only one cost rate for all business units he/she is working for.

Company Address Country

Company AddressCounty

Check to create automatically a user in MARIProject

Cerditor (BusinessPartner) for travel expense processing (CompanyID from Business Unit)

Business Partner for the Company Credit Card used by the employee

Business Partner for the second Company Credit Card used by the employee

Business Partner for the third Company Credit Card used by the employee

Date of birth

Beginning date in the company

Linked Business Partner for Debitor processes

Email

Responsible manager for this employee. Link to an existing employee in the database

Memo field for the employee

NVARCHAR(50) Copount Name: FirstName LastName. When this field is empty, it is calculated based on "FirstNameFamilyName".

Unique Employee ID to be formatted based on the settings of MARIProject Example "E200".

You can generate a new employee number using the function sGetNewEmployeeNumber.

2nd Responsible manager for this employee. Link to an existing employee in the database

[Mandatory] Each employee can be either a regular employee or a free lancer. See clsImportEmployeeeEmployeeStatus.

ExchangeSyncMode

NVARCHAR(50) External Key of the employee. used by MARITimeTouch and RFID Reader. PDA Key

Employee Surname

Company Fax

Employees First Name

Project Template: Flextime projectnumber. clsImportProjecteProjectType

Functiontext e.g. Groupleader

Reference to the Employee Group 1. Link to MPGruppen WHERE GruppenArt=10001 EmployeeGroup

Reference to the Employee Group 2. Link to MPGruppen WHERE GruppenArt=10006 EmployeeGroup2

Reference to the Employee Group 3. Link to MPGruppen WHERE GruppenArt=10007 EmployeeGroup3

Project Template: Illness project. clsImportProjecteProjectType

Leaving Date

LocationID

NVARCHAR(50) Name for assortment. User "Name, Surname" or "Surname, Name". When this field is empty it is calculated based on "FamilyName, FirstName.

Mobile

OutOfOfficeStatus

OutOfOfficeSubstitute eMail address

OutOfOfficeText information for the approval

re- /set the overtime start value in hours for the given ValidFrom period.

internal company id for payroll export

Active employee number in the payroll accounting export

Please use PayrollEmplNo instead. Active employee number in the payroll accounting export.

Please use EmployeeStatus instead. [Mandatory] Each employee can be either a regular employee or a free lancer. See clsImportEmployeeePersonalType and clsImportEmployeeeEmployeeStatus.

Company Phone

The picture can be transfered via a byte array instead of a PictureFileName.

Linking a file name, will load this file into the database. The file content has to be accessable from the import process.

The picture content is stored in: View: MARIPictures : : Table: MPBilder

PictureID (for the import only existing key in table MPBilder supported.

0 to 100 (if aplicable over 100).How far may this employee be taken into account (Planned working time * Planning capacity/100) = Planable hours

Normaly an employee will have only one cost rate for all business units he/she is working for. See clsImportEmployeeeCostRateType.

Date of the createn of the dataset. Filled automatically

PrivateFax

Private Phone

Project Template: Rounding project. clsImportProjecteProjectType

Title like "Mr., Mrs..."

Project Template: Special Leave projectnumber. clsImportProjecteProjectType

Project Template: Projectnumber of the standard employee project. clsImportProjecteProjectType

Can be used to store the first standard service to the employee

Company Address State Code (NY=New York State)

Company AddressStreet

Company Street Number

Please use Salutation instead. Title like "Mr., Mrs..."

TravelExpensesRule specially set, overwriting employee business unit setting.

Project Template: Unpaid absence projectnumber. clsImportProjecteProjectType

NVARCHAR(4)4 character user initials. This field is used for the link between employee and user. It will be created automatically

Used, whenn CreateUser is true

The selected user groups of the user (flag set)

NVARCHAR(4) Identification code of the user. Internal ID, created automatically

User Level. See clsImportEmployeeeUserLevel for details.

UserName for the newley created user

Used, whenn CreateUser is true

Please use UserCode instead. 4 character user initials. This field is used for the link between employee and user. It will be created automatically.

Used, whenn CreateUser is true

Vacation Periode 2016001 (not necessary. Filled by the VacationCalendarYear

The year of the vacation 2016

Please use VacationCompensationCurrYear. Vacation compensation for special vacations. Property will stay for compatibility only.

Vacation compensation for special vacations

Please use VacationEntitlementCurrYear instead. Entry of Vacation Entitlment. Property will stay for compatibility only.

Entry of Vacation Entitlment

Please use VacationSpecialLeave. Carry over from the previous year.

Remaining Vacation Days

Project Template: Vacation project. clsImportProjecteProjectType

Carry over from the previous year. (Property name is wrong, but used for the carry over).

Period in the time organisation of MARIProject employee master (Period+Organisation). Format: 2016012 YYYYMMM

Please use property ValidFrom instead. Period in the time organisation of MARIProject 2016012 YYYYMMM

Company Address Zip-Code