Practice - Users
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
-
2007/04/20 14:09:23.197
Quickvet
MSACCESS
ODBC
Quickvet
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER-1
STREAM_RESULTSY
USE_POOLINGN
Select User FieldsTransform UsersY Transform UsersOpenVPMS UserY Table inputSelect User FieldsY
OpenVPMS User
OpenVPMSLoaderPlugin
Y
1
none
OpenVPMSIDUSERNAME<security.user>usernamefalsefalsePASSWORD<security.user>passwordfalsefalseNAME<security.user>namefalsefalseACTIVE<security.user>activefalsefalseVET<security.user>classifications[0]true<lookup.userType>code=$valuefalsefalsetrue1000
632
138
Y
Select User Fields
SelectValues
Y
1
none
Employee No
ID
-2
-2
First Name
FIRSTNAME
-2
-2
Last Name
SURNAME
-2
-2
User Name
USERNAME
-2
-2
Password
PASSWORD
-2
-2
370
138
Y
Transform Users
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var ACTIVE = true
var VET = "CLINICIAN"
var NAME = FIRSTNAME.getString() + " " + SURNAME.getString()
ACTIVE
ACTIVE
Boolean
-1
-1
VET
VET
String
-1
-1
NAME
NAME
String
-1
-1
498
139
Y
Table input
TableInput
Y
1
none
Quickvet
SELECT
[Employee No]
, [First Name]
, [Last Name]
, [Social Security No]
, [User Name]
, Password
, Address
, City
, State
, Zip
, [Phone 1]
, [Phone 2]
, [Service Date]
, Title
, [Job Description]
, Authority
, [Hourly Wage]
, [Daily Wage]
, [Weekly Wage]
, [Monthly Wage]
, [Yearly Wage]
, Commission
, [Pay Period]
, Exemptions
, Married
, [Withholding Federal]
, [Withholding State]
, [Work Permit Required]
, [Work Permit Obtained]
, [Work Permit Date]
, [Health Insurance Withheld]
, [Pension Withheld]
, Comments
, [Payroll Comments]
, [On Payroll]
, [Health Insurance]
, [Health Insurance Provider]
, [Payroll Account]
, [Additional Withholding]
, [Additional WH Comment]
, [Additional Withholding 1]
, [Additional WH Comment 1]
, [Employer Paid Health Ins]
, [Employer Paid Pension]
, Dental
, [Dental Provider]
, [Dental Insurance]
, [Employer Dental Ins]
, [Tax File Number]
, Employed
, Student
, [Commission Taxed]
, [Commission Insurance]
, [Preference 1]
, [Preference 2]
, [Preference 3]
, [Preference 4]
, [Preference 5]
, [Dollar 1]
, [Dollar 2]
, [Dollar 3]
, [Date 1]
, [Date 2]
, [Date 3]
, Judgement
, [Judge Percent]
, [Judge Dollar]
, [Additional Withholding 2]
, [Additional WH 2 Comment]
, [State Exemptions]
, [State Status]
, Account
FROM Worker
0
N
N
243
142
Y