Skip to Main Content

Knowledge base

Knowledge Base
Knowledge Base - Select Applicants missing 1 or more documents on ANWABAPP
by Alice Moore
01/14/2011 (Software)


 

Leanah needs reminded how to list those applicants who are missing a specific or 1 or more documents from the ANWABAPP request track.

 There was an old ticket from 2006 ( http://www.wabash.edu/ua/ticketview.cfm?tid=19721&key=501466 ) that attempted this but but this ticket has a better solution

 

1/20/10 11:35AM AM --

How to list applicants that are missing 1 (or more) documents
==================================================================
 
to start with a savedlist of APPLICANTS and the queries below all start in COREQ with no selection based on application status.  Since there is not a computed column in COREQ to select based on app stat, you must do the following:

GET.LIST your list of incompletes
SELECT APPLICANTS SAVING W04.APP.COREQ.ANWABAPP
SELECT COREQ
at this point you are probably going to a list of ids not found, these are most likely the rg 8 kids that don't have ANWABAPP so you'll have to do them separatly(see way below in blue). Just press return until you get to the > prompt.
391 records selected to list 0.

The following record ids do not exist:
0412227*ANWABAPP
0412235*ANWABAPP
BLA BLA BLA...

>

At this point (B/C you have already selected based on the term and request track name) you can skip the first select below and go directly to the

SELECT COREQ WITH W04.COREQ.NUM.MISSING EQ 1 (CHANGE IF NEEDED)
LIST COREQ ID.SUP BY.EXP COREQ.CC.CODE COREQ.ID BREAK.ON  COREQ.CC.CODE WHEN COREQ.CC.STATUS = ' TOTAL COUNTER

You might want to add W04.COREQ.REGION W04.COREQ.LFM.NAME to the end of your query if you want to know who the people are by name.  It would look like this:

LIST COREQ ID.SUP BY.EXP COREQ.CC.CODE COREQ.ID BREAK.ON  COREQ.CC.CODE WHEN COREQ.CC.STATUS = ' W04.COREQ.REGION W04.COREQ.LFM.NAME TOTAL COUNTER

          Corres
          Recv'd
Person ID Codes... COUNTER. RG Name...............................

  0407695 ARQCT           1 12 Campbell, Ryan L.
  0409119 ARQCT           1 12 Ahler, Jacob Austin
  0410090 ARQCT           1 12 Alarcon, Kristian Eduardo
          ******** --------
          ARQCT           3

If you only want the people with a particular code as the only missing one, do this (the only difference is the WHEN ASD in the LIST statement):

LIST COREQ ID.SUP BY.EXP COREQ.CC.CODE COREQ.ID BREAK.ON  COREQ.CC.CODE
 WHEN ASD (COREQ.CC.STATUS = ';COREQ.CC.CODE = 'ARQCR') W04.COREQ.REGION W04.COREQ.LFM.NAME TOTAL COUNTER

===============================================


FYI: out of the 486 Incompletes 93 are rg 8 and 2 others from rg 6 &  7 do not have an ANWABAPP assigned to them.  To find the non-rg 8 guys with no track:

 GET.LIST your list of incompletes
 SELECT APPLICANTS WITH W04.APP.REGION NE '8'
>SELECT APPLICANTS SAVING W04.APP.COREQ.ANWABAPP

393 records selected to list 0.

>SELECT COREQ

391 records selected to list 0.

The following record ids do not exist:
0412227*ANWABAPP  ---------------------> these are your guys.
0410838*ANWABAPP---------------------> these are your guys.
> cls


To process the RG 8 guys (because they have a different COREQ track):

GET.LIST your list of incompletes
SELECT APPLICANTS WITH W04.APP.REGION EQ '8'
SELECT APPLICANTS SAVING W04.APP.COREQ.ANWABAPP8
SELECT COREQ
SELECT COREQ WITH W04.COREQ.NUM.MISSING EQ 1
LIST COREQ ID.SUP BY.EXP COREQ.CC.CODE COREQ.ID BREAK.ON  COREQ.CC.CODE WHEN COREQ.CC.STATUS = ' TOTAL COUNTER

======================================================

TO find those that were missing documents as of a particular date:

For example documents missing as of 1/5/11

Starting with your list of COREQ ids:

LIST COREQ ID.SUP BY.EXP COREQ.CC.CODE COREQ.ID BREAK.ON  COREQ.CC.CODE WHEN ASD(COREQ.CC.STATUS NE ""; COREQ.CC.DATE GE '1/5/11') OR COREQ.CC.STATUS EQ ""  TOTAL COUNTER DET.SUP

iF you want to see the detail:

LIST COREQ ID.SUP BY.EXP COREQ.CC.CODE COREQ.ID BREAK.ON  COREQ.CC.CODE WHEN ASD(COREQ.CC.STATUS NE ""; COREQ.CC.DATE GE '1/5/11') OR COREQ.CC.STATUS EQ "" COREQ.CC.STATUS COREQ.CC.DATE TOTAL COUNTER