SQL Extract Logic: agent_users

File Name: Agent_Users.csv

This SQL extract lists agent portal users (alongwith their organization) for whom the following conditions are met:

• the agent portal account is enabled
• who have logged in at least once
• who have logged in at least once in the current calendar year, relative to the date of fetching the SQL extract
• their agent organization belongs to one of the following groups:

           - 'ALFA'

           - 'ATG'

           - 'CARIB'

           - 'CHAMPION'

           - 'CROWNVAN'

           - 'GBL'

           - 'GERSON RELO'

           - 'GRABEL'

           - 'LINKS'

           - 'MAXJ'

           - 'MIG'

           - 'MUDANZAS'

           - 'OCEA'

           - 'ONEGROUP'

           - 'SANTAFE'

           - 'TRAF'

           - 'UGR ASIA'

           - 'WRITER'

           OR

           their agent organization is one among the following organizations:

           - 'A&TEAM s.r.o.'

         - 'Bernardt Verhuizingen B.V.'

         - 'High Relocation Worldwide, Inc.'

         - 'Hong Kong Transpack Co, Ltd'

         - 'Inter Express Transport A/S'

         - 'Intermovers (Malaysia) Sdn. Bhd.'

         - 'KMS Van Lines, Inc./Royal Moving & Sto.'

         - 'Logpro Indoexpress'

         - 'Rocargo Logistics Services B.V.'

         - 'Schneider Demenagement S.A'

         - 'Stevens International'

         - 'Stevens Moving & Storage - Saginaw'

         - 'Aspire Mobility'

         - 'Van Rooijen'

• their agent organization has 'Approved' status