GetClientsByFirstVisit()

Description

Returns information for clients that have a first visit date during the specified date range.

GetClientsByFirstVisit(StartDate AS Date, EndDate AS Date, IncludeDeleted AS Boolean)

Return Value

XML String

Parameters

StartDate = Start date for the records to return.
EndDate = End date for the records to return.
IncludeDeleted = Select to include deleted records in the results.

Remarks

XML String has the following structure:

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.
cPostSort	String	5	Postal sort code.
lNonDeliv	Boolean	1	Indicates whether the address is non-deliverable.
cArea	String	4	Area code for home phone.
cHomePhone	String	8	Home phone.
cBusArea	String	4	Area code for business phone.
cBusPhone	String	8	Business phone.
cExtension	String	5	Business extension.
dFirstVisit	Date	8	First visit date.
dLastVisit	Date	8	Last visit date.
nNumVisits	Integer	4	Total number of visits.
iPrimeEmp	Integer	4	Primary Employee Id. Foreign key to Employee iId.
nAge	Decimal	3,0	Client age.
dBday	Date	8	Client date of birth.
lChildren	Boolean	1	Indicates whether the client has children.
lMarried	Boolean	1	Indicates whether the client is married.
IPrimaryRes	Boolean	1	Indicates whether the client is the primary resident at their address.
dAnniv	Date	8	Anniversary date.
nSex	Decimal	1,0	Client gender. 1 = Male 2 = Female
lNoChecks	Boolean	1	Indicates whether the client has children.
lNoMail	Boolean	1	Indicates whether the client wants to receive mailings.
lInActive	Boolean	1	Indicates whether the client is inactive.
dDateDel	Date	8	Date deleted.
lDispNote	Boolean	1	Indicates whether the client's notes display when you view their profile.
lConfirm	Boolean	1	Indicates whether the client receives appointment confirmations.
ICategoryId	Integer	4	Not used.
iGId	Integer	4	Not used.
iGuestId	Integer	4	Id for the client in the property management system.
cRoomNum	String	8	Room number for the client in the property management system.
tCreated	DateTime	8	Date/time created.
iPoints	Integer	4	Current number of points for client.
lAllowPoints	Boolean	1	Indicates whether client can accrue points.
lDispNoteAppt	Boolean	1	Indicates whether the client's notes display when you view their appointments.
cConfSequence	String	7	Appointment confirmation sequence. A = Auto-Confirm C = Cell E = Email F = Fax H = Home S = SMS W = Work
lDispUDFreg	Boolean	1	Indicates whether entries in user defined fields display on the Register in Millennium.
lDispUDFAppt	Boolean	1	Indicates whether entries in user defined fields display on the Appointment Book in Millennium.
tChanged	DateTime	8	Date/time last changed.
iCreatedBy	Integer	4	Id of the Employee who created the client record.
lNoEmail	Boolean	1	Indicates if no email address is on file for the client.
lSMSBlast	Boolean	1
lWasGlobal	Boolean	1
lRestricted	Boolean	1	Indicates whether access to the client record is restricted.
iPatientId	Integer	4	Patient Id.