GetUDFQuestions()

Field

Type

Length

Description

iId

Integer

4

Primary Key - Unique Identifier.

mQuestion

String

Question.

iSortOrder

Integer

4

Sort order of question.  Used internally within Millennium.

dDateDel

DateTime

8

Date UDF question was deleted.

iGId

Integer

4

Global Id for the question record.

mToolTip

String

Tooltip message for the question.

lPromptInReg

Boolean

1

Indicates whether the question displays on the Register when searching for a client.

lPromptInAppt

Boolean

1

Indicates whether the question displays on the Appointment Book when searching for a client.

lSearchable

Boolean

1

Indicates whether the question is searchable.

cShortcut

String

2

This is the prefix you need to type into the client search box within Millennium if you want to search this field.  

- Must be 2 numbers or letters and 3rd character must be equal sign (=).

- Only utilized from within Millennium and you must have lSearchable enabled.