Practice - Users /

YN 0.0 0.0 1000 1 1 N Y 5000 Y - 2007/04/20 14:09:23.197 RxWorks MSACCESS ODBC RxWorks -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 User OutputY Table inputSelect User FieldsY OpenVPMS User Output OpenVPMSLoaderPlugin Y 1 none OpenVPMSCODECODE<security.user>usernamefalsefalseCODE<security.user>passwordfalsefalseNAME<security.user>namefalsefalseACTIVE<security.user>activefalsefalseCATEGORY<security.user>classifications[0]true<lookup.userType>code=$valuefalsefalsetrue1000 678 137 Y Select User Fields SelectValues Y 1 none User CODE -2 -2 User Id NAME -2 -2 Password PASSWORD -2 -2 Consulting Vet VET -2 -2 Deactivated STATUS -2 -2 247 137 Y Table input TableInput Y 1 none RxWorks SELECT * FROM [USER] 0 N N 90 135 Y Transform Users ScriptValueMod Y 1 none