Skip to Main Content

Knowledge base

Knowledge Base
Knowledge Base - Queries for ENT address
by Alice Moore
06/22/2011 (Software)


 

Need query to find those without an ENT address or with multiple ENT addresses

 

To find those with an ENT on a current address AND on a former address: (so they have 2 codes)

SELECT APPLICANTS WITH W04.APP.START.TERM EQ '11/FA' WITH W04.CUR.APPL.STATUS EQ 'DP'

SELECT PERSON WITH ADDR.TYPE = 'ENT' AND FORMER.ADDR.TYPE = 'ENT'

LIST APPLICANTS W04.APP.NAME.LFM

·        Now call up the person on ADSU to verify and fix

·        In this particular case you will see that they kept the former address when it was just a correction  ARGHHHHH! When are people going to learn?  I think this needs pointed out before you delete the former address.

 

To find those with no ENT address at all (former or current) you really need to do a couple of SELECTS:

SELECT APPLICANTS WITH W04.APP.START.TERM EQ '11/FA' WITH W04.CUR.APPL.STATUS EQ 'DP'

SELECT PERSON WITH EVERY FORMER.ADDR.TYPE NE 'ENT'

289 records selected to list 0.

·        -->this tells you that 289 do not have any former address with an ENT (which means 11 does) ‘q’ below to find the 11 if you want to know

 

Now find those with no ENT on a current address:

>SELECT PERSON WITH EVERY ADDR.TYPE NE ENT

 

No data retrieved from current (S)SELECT statement.

·        -->this tells you that all 289 have ENT on a current address

 

To find those with ENT type on a FORMER address:

SELECT APPLICANTS WITH W04.APP.START.TERM EQ '11/FA' WITH W04.CUR.APPL.STATUS EQ 'DP'

SELECT PERSON WITH FORMER.ADDR.TYPE EQ 'ENT'

LIST APPLICANTS W04.APP.NAME.LFM