Customer - Appointments
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
-
2007/06/03 14:32:03.666
Quickvet
MSACCESS
ODBC
Quickvet
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
PORT_NUMBER
-1
STREAM_RESULTS
Y
USE_POOLING
N
Filter rowsSelect valuesY Filter rowsDummy (do nothing)Y Select valuesAdd sequenceY Table inputAdd constantsY Add constantsFilter rowsY
Add sequence
Sequence
Y
1
none
APPOINTID
N
SEQ_
Y
1
1
9999999
550
112
Y
Dummy (do nothing)
Dummy
Y
1
none
356
226
Y
Filter rows
FilterRows
N
1
none
Select values
Dummy (do nothing)
N
DATE
>=
constantDate2008/01/01 00:00:00.000-1-1N
353
113
Y
Select values
SelectValues
Y
1
none
SCHEDULE
-2
-2
AccountNumber
CLIENTID
-2
-2
PetNumbers
PATIENTID
-2
-2
DATE
-2
-2
TIME
-2
-2
Reason
-2
-2
Duration
-2
-2
Information
-2
-2
445
110
Y
Table input
TableInput
Y
1
none
Quickvet
SELECT
[Appt No]
, Client
, Pet
, Reason
, Duration
, Information
, AccountNumber
, PetNumbers
, [DATE]
, [TIME]
FROM Sched_1
0
N
N
129
113
Y
Add constants
Constant
Y
1
none
SCHEDULE
String
1
-1
-1
254
112
Y