GetEmployeeInfo()

Field

Type

Length

Description

iId

Integer

4

Primary Key - Unique Identifier.

iLocationId

Integer

4

Not used.

cLastName

String

20

Client last name.

cFirstName

String

15

Client first name.

cAddress1

String

40

Address (Line 1).

cAddress2

String

40

Address (Line 2).

cCity

String

25

City.

cState

String

3

State.

cZip

String

10

Zip code.

cCode

String

10

Identifying code for the employee.

lAllowAppts

Boolean

1

Indicates whether the employee appears in the Appointment Book.

cSocial

String

9

Social security number.

lMarried

Boolean

1

Indicates whether the employee is married.

nSex

Decimal

1,0

Gender.

1 = Male

2 = Female

nAge

Decimal

1,0

Age.

dBirthday

Date

8

Date of birth.

dAnnivDay

Date

8

Anniversary date.

cEmail

String

40

Email address.

cArea

String

4

Home area code.

cPhone

String

8

Home phone.

cCellArea

String

4

Cell area code.

cCellPhone

String

8

Cell phone.

cAutopage

String

10

Auto-page number.

dStartDate

Date

8

Start date.

dTermDate

Date

8

Termination date.

gPicture

Not Used.

mNotes

String

Employee notes.

nLevel

Decimal

1,0

Service level.

dPictureDate

Date

8

Upload date for the employee's picture.

cEmgContact

String

30

Emergency contact name.

cEmgArea

String

3

Emergency contact area code.

cEmgPhone

String

7

Emergency contact phone.

lInactive

Boolean

1

Indicates whether the employee is inactive.

dDateDel

Date

8

Date deleted.

lShowTips

Boolean

1

Indicates whether the employee displays on the Tips screen.

lShowSched

Boolean

1

Indicates whether the employee displays on the Schedules screen.

lPunchIn

Boolean

1

Indicates whether the employee must punch-in.

nSequence

Decimal

5,0

Order in which employees appear in the Appointment Book.

nBakColor

Integer

4

The background color for the header of the employee column in the Appointment Book.

nForeColor

Integer

4

The text color for the header of the employee column in the Appointment Book.

nApptMask

Decimal

1,0

iResourceId

Integer

4

Employee Default Resource iId.  Foreign key to Resource iId.

lBookOnline

Boolean

1

Indicates whether appointments can be booked online for this employee.

lLimitHours

Boolean

1

Indicates whether the hours are limited.

lSun

Boolean

1

Indicates whether you can book appointments online on Sunday with this employee. Only used when lLimitHours is TRUE.

cSunStart

String

4

Start time of when appointments can be booked online on Sunday.

cSunEnd

String

4

End time of when appointments can be booked online on Sunday.

lMon

Boolean

1

Indicates whether you can book appointments online on Monday with this employee. Only used when lLimitHours is TRUE.

cMonStart

String

4

Start time of when appointments can be booked online on Monday.

cMonEnd

String

4

End time of when appointments can be booked online on Monday.

lTue

Boolean

1

Indicates whether you can book appointments online on Tuesday with this employee. Only used when lLimitHours is TRUE.

cTueStart

String

4

Start time of when appointments can be booked online on Tuesday.

cTueEnd

String

4

End time of when appointments can be booked online on Tuesday.

lWed

Boolean

1

Indicates whether you can book appointments online on Wednesday with this employee. Only used when lLimitHours is TRUE.

cWedStart

String

4

Start time of when appointments can be booked online on Wednesday.

cWedEnd

String

4

End time of when appointments can be booked online on Wednesday.

lThu

Boolean

1

Indicates whether you can book appointments online on Thursday with this employee. Only used when lLimitHours is TRUE.

cThuStart

String

4

Start time of when appointments can be booked online on Thursday.

cThuEnd

String

4

End time of when appointments can be booked online on Thursday.

lFri

Boolean

1

Indicates whether you can book appointments online on Friday with this employee. Only used when lLimitHours is TRUE.

cFriStart

String

4

Start time of when appointments can be booked online on Friday.

cFriEnd

String

4

End time of when appointments can be booked online on Friday.

lSat

Boolean

1

Indicates whether you can book appointments online on Saturday with this employee. Only used when lLimitHours is TRUE.

cSatStart

String

4

Start time of when appointments can be booked online on Saturday.

cSatEnd

String

4

End time of when appointments can be booked online on Saturday.

lLimitServs

Boolean

1

Indicates if only a limited number of services can be booked online for this employee.

lIgnorePre

Boolean

1

If TRUE, the employee's clients do not receive pre-book discounts.

lIgnoreOnline

Boolean

1

If TRUE, the employee’s clients do not receive discounts for booking online.

iGId

Integer

4

Employee Global Id.

cMaskText

String

20

Masking text displayed in the Appointment Book.

nMaskLen

Decimal

6,3

Length of the mask in Appointment Book.

iResourceId2

Integer

4

Second Employee Default Resource iId.  Foreign Key to Resource iId.

lMaskBookable

Boolean

1

Indicates whether the masking represents a non-bookable time. 

TRUE = Masking represents a bookable time

FALSE = Masking represents a non-bookable time.

cEmpNumber

String

4

Employee number.

iCellCarrier

Integer

4

Id of the employee's cell phone carrier.

lShowReg

Boolean

1

Indicates whether the employee is available for selection on the Register screen.

lShowRegOther

Boolean

1

Indicates whether the employee is available for selection on windows accessible from the Register screen.