Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

It will exclude records where the STBIOS.ID_NUMBER = STBIOS.SOCIAL_SEC_NUMBER.

SQL Filter Example SQL query of what this process does behind the scenes (Sample WHERE CLAUSE):

WHERE (STBIOS.ID_NUMBER IN (SELECT HOHIST.ID_NUMBER FROM HOHIST WHERE HOHIST.CURRENT_SEMESTER = 201620 202520 AND HOHIST.BILLING_SITE IN (01)) OR

(STBIOS.ID_NUMBER IN (SELECT ID_NUMBER FROM STBIOS WHERE ADM_PROGRESS_CODE IN ('A','C','P','Y','AW','YW','PW','YR','PC') AND STBIOS.ADMISSIONS_ENT_SEM = 201620 202520 AND STBIOS.ADMISSIONS_SITE IN (01)))) AND ADM_PROGRESS_CODE NOT IN ('X')

...