2024-10-02 ADVX extract criteria

2 SQL files every night - retrieve ADV and updated list of advisors manually maintained

Found original code and loaded into TEST.

Need SQL for ADVX

The ADV SQL in Test is now pulling 726 people.

ADV = have access to petitions tab

ADVX = advisors who don’t have access to petitions, but can view DW

When nightly job fails, anyone we assign REGR to is reverted to ADV

Reg needs to identify where ADV will live so that Peter can add it to the SQL script.