Fall Merit Simulation Pop Update Run Controls

POPUP_FALL_MRT_R2P_RESET

Screenshot:


Query:

  • POPUP_FALL_MRT_R2P_RESET_QRY

Query Details:

SELECT A.EMPLID
  FROM PS_SCCPU_STDNT_BND A, PS_STDNT_AID_ATRBT B
  WHERE ( A.EMPLID = B.EMPLID
     AND B.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 B3_2 WHERE  B3_2.SELECTOR_NUM=1136 AND B.AID_YEAR=B3_2.RANGE_FROM_04 AND B3_2.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
     AND B.PROCESSING_STATUS = '3')

POPUP_FALL_MRT_VAR_FIRSTTIME

Screenshot:


Query:

  • POPUP_FALL_MRT_VAR_FIRSTTM_QRY

Query Details:

SELECT A.EMPLID
  FROM PS_SCCPU_STDNT_BND A, PS_STDNT_AID_ATRBT B
  WHERE ( A.EMPLID = B.EMPLID
     AND B.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 B3_2 WHERE  B3_2.SELECTOR_NUM=1136 AND B.AID_YEAR=B3_2.RANGE_FROM_04 AND B3_2.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
     AND B.AID_APP_STATUS <> 'C'
     AND B.SCHOLARSHIP_STATUS <> 'E'
     AND (( A.EMPLID IN (SELECT C.EMPLID
  FROM PS_ADM_APPL_PROG C, PS_ADM_MAINT_SCTY C1, PS_ADM_APPL_DATA D, PS_ADM_APPL_SCTY D1
  WHERE C.EMPLID = C1.EMPLID
    AND C.ACAD_CAREER = C1.ACAD_CAREER
    AND C.STDNT_CAR_NBR = C1.STDNT_CAR_NBR
    AND C.ADM_APPL_NBR = C1.ADM_APPL_NBR
    AND C.APPL_PROG_NBR = C1.APPL_PROG_NBR
    AND C1.OPRCLASS = 'HCPPALL'
    AND C1.OPRID = '702050948'
    AND D.EMPLID = D1.EMPLID
    AND D.ACAD_CAREER = D1.ACAD_CAREER
    AND D.ADM_APPL_NBR = D1.ADM_APPL_NBR
    AND D1.OPRCLASS = 'HCPPALL'
    AND D1.OPRID = '702050948'
    AND ( C.EFFDT =
        (SELECT MAX(C_ED.EFFDT) FROM PS_ADM_APPL_PROG C_ED
        WHERE C.EMPLID = C_ED.EMPLID
          AND C.ACAD_CAREER = C_ED.ACAD_CAREER
          AND C.STDNT_CAR_NBR = C_ED.STDNT_CAR_NBR
          AND C.ADM_APPL_NBR = C_ED.ADM_APPL_NBR
          AND C.APPL_PROG_NBR = C_ED.APPL_PROG_NBR
          AND C_ED.EFFDT <= SYSDATE)
    AND C.EFFSEQ =
        (SELECT MAX(C_ES.EFFSEQ) FROM PS_ADM_APPL_PROG C_ES
        WHERE C.EMPLID = C_ES.EMPLID
          AND C.ACAD_CAREER = C_ES.ACAD_CAREER
          AND C.STDNT_CAR_NBR = C_ES.STDNT_CAR_NBR
          AND C.ADM_APPL_NBR = C_ES.ADM_APPL_NBR
          AND C.APPL_PROG_NBR = C_ES.APPL_PROG_NBR
          AND C.EFFDT = C_ES.EFFDT)
     AND C.EMPLID = D.EMPLID
     AND C.ACAD_CAREER = D.ACAD_CAREER
     AND C.STDNT_CAR_NBR = D.STDNT_CAR_NBR
     AND C.ADM_APPL_NBR = D.ADM_APPL_NBR
     AND C.ACAD_CAREER = 'UGRD'
     AND C.INSTITUTION = 'UOD01'
     AND C.PROG_STATUS IN ('AC','AD','PM')
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 C3_8 WHERE  C3_8.SELECTOR_NUM=1140 AND C.ADMIT_TERM=C3_8.RANGE_FROM_04 AND C3_8.TREE_NODE_NUM BETWEEN 1999908446 AND 1999938963)
     AND D.ADMIT_TYPE IN ('FF','FR') ))
     AND A.EMPLID IN (SELECT E.COMMON_ID
  FROM PS_COMMUNICATION E
  WHERE E.INSTITUTION = 'UOD01'
     AND E.SCC_LETTER_CD = 'UFA'
     AND E.COMM_DT >= SYSDATE-180
     AND E.COMM_DT <= SYSDATE))
     OR A.EMPLID IN (SELECT F.EMPLID
  FROM PS_STDNT_PKG_VAR F
  WHERE F.AID_YEAR = B.AID_YEAR
     AND F.VARIABLE_CHAR1 = 'FALL FIRSTTIME MERIT'
     AND F.VARIABLE_CHAR2 = 'REEVALUATE')))

POPUP_FALL_MRT_VAR_TRANSFER

Screenshot:


Query:

  • POPUP_FALL_MRT_VAR_TRANSFR_QRY

Query Details:

SELECT A.EMPLID
  FROM PS_SCCPU_STDNT_BND A, PS_STDNT_AID_ATRBT B
  WHERE ( A.EMPLID = B.EMPLID
     AND B.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 B3_2 WHERE  B3_2.SELECTOR_NUM=1136 AND B.AID_YEAR=B3_2.RANGE_FROM_04 AND B3_2.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
     AND B.AID_APP_STATUS <> 'C'
     AND B.SCHOLARSHIP_STATUS <> 'E'
     AND (( A.EMPLID IN (SELECT C.EMPLID
  FROM PS_ADM_APPL_PROG C, PS_ADM_MAINT_SCTY C1, PS_ADM_APPL_DATA D, PS_ADM_APPL_SCTY D1
  WHERE C.EMPLID = C1.EMPLID
    AND C.ACAD_CAREER = C1.ACAD_CAREER
    AND C.STDNT_CAR_NBR = C1.STDNT_CAR_NBR
    AND C.ADM_APPL_NBR = C1.ADM_APPL_NBR
    AND C.APPL_PROG_NBR = C1.APPL_PROG_NBR
    AND C1.OPRCLASS = 'HCPPALL'
    AND C1.OPRID = '702050948'
    AND D.EMPLID = D1.EMPLID
    AND D.ACAD_CAREER = D1.ACAD_CAREER
    AND D.ADM_APPL_NBR = D1.ADM_APPL_NBR
    AND D1.OPRCLASS = 'HCPPALL'
    AND D1.OPRID = '702050948'
    AND ( C.EFFDT =
        (SELECT MAX(C_ED.EFFDT) FROM PS_ADM_APPL_PROG C_ED
        WHERE C.EMPLID = C_ED.EMPLID
          AND C.ACAD_CAREER = C_ED.ACAD_CAREER
          AND C.STDNT_CAR_NBR = C_ED.STDNT_CAR_NBR
          AND C.ADM_APPL_NBR = C_ED.ADM_APPL_NBR
          AND C.APPL_PROG_NBR = C_ED.APPL_PROG_NBR
          AND C_ED.EFFDT <= SYSDATE)
    AND C.EFFSEQ =
        (SELECT MAX(C_ES.EFFSEQ) FROM PS_ADM_APPL_PROG C_ES
        WHERE C.EMPLID = C_ES.EMPLID
          AND C.ACAD_CAREER = C_ES.ACAD_CAREER
          AND C.STDNT_CAR_NBR = C_ES.STDNT_CAR_NBR
          AND C.ADM_APPL_NBR = C_ES.ADM_APPL_NBR
          AND C.APPL_PROG_NBR = C_ES.APPL_PROG_NBR
          AND C.EFFDT = C_ES.EFFDT)
     AND C.EMPLID = D.EMPLID
     AND C.ACAD_CAREER = D.ACAD_CAREER
     AND C.STDNT_CAR_NBR = D.STDNT_CAR_NBR
     AND C.ADM_APPL_NBR = D.ADM_APPL_NBR
     AND C.ACAD_CAREER = 'UGRD'
     AND C.INSTITUTION = 'UOD01'
     AND C.PROG_STATUS IN ('AC','AD','PM')
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 C3_8 WHERE  C3_8.SELECTOR_NUM=1140 AND C.ADMIT_TERM=C3_8.RANGE_FROM_04 AND C3_8.TREE_NODE_NUM BETWEEN 1999908446 AND 1999938963)
     AND D.ADMIT_TYPE IN ('FT','TR') ))
     AND A.EMPLID IN (SELECT E.COMMON_ID
  FROM PS_COMMUNICATION E
  WHERE E.INSTITUTION = 'UOD01'
     AND E.SCC_LETTER_CD = 'UTA'
     AND E.COMM_DT >= SYSDATE-180
     AND E.COMM_DT <= SYSDATE))
     OR A.EMPLID IN (SELECT F.EMPLID
  FROM PS_STDNT_PKG_VAR F
  WHERE F.AID_YEAR = B.AID_YEAR
     AND F.VARIABLE_CHAR1 = 'FALL TRANSFER MERIT'
     AND F.VARIABLE_CHAR2 = 'REEVALUATE')))

POPUP_FALL_MRT_VAR_ASSOC

Screenshot:


Query:

  • POPUP_FALL_MRT_VAR_ASSOC_QRY

Query Details:

SELECT A.EMPLID
  FROM PS_SCCPU_STDNT_BND A, PS_STDNT_AID_ATRBT B
  WHERE ( A.EMPLID = B.EMPLID
     AND B.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 B3_2 WHERE  B3_2.SELECTOR_NUM=1136 AND B.AID_YEAR=B3_2.RANGE_FROM_04 AND B3_2.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
     AND A.EMPLID IN (SELECT C.EMPLID
  FROM PS_STDNT_PKG_VAR C
  WHERE C.INSTITUTION = 'UOD01'
     AND C.ACAD_CAREER = 'UGRD'
     AND C.AID_YEAR = B.AID_YEAR
     AND C.VARIABLE_CHAR3 = 'INITIATED')
     AND A.EMPLID IN (SELECT D.EMPLID
  FROM PS_ADM_APPL_PROG D, PS_ADM_MAINT_SCTY D1
  WHERE D.EMPLID = D1.EMPLID
    AND D.ACAD_CAREER = D1.ACAD_CAREER
    AND D.STDNT_CAR_NBR = D1.STDNT_CAR_NBR
    AND D.ADM_APPL_NBR = D1.ADM_APPL_NBR
    AND D.APPL_PROG_NBR = D1.APPL_PROG_NBR
    AND D1.OPRCLASS = 'HCPPALL'
    AND D1.OPRID = '702050948'
    AND ( D.EFFDT =
        (SELECT MAX(D_ED.EFFDT) FROM PS_ADM_APPL_PROG D_ED
        WHERE D.EMPLID = D_ED.EMPLID
          AND D.ACAD_CAREER = D_ED.ACAD_CAREER
          AND D.STDNT_CAR_NBR = D_ED.STDNT_CAR_NBR
          AND D.ADM_APPL_NBR = D_ED.ADM_APPL_NBR
          AND D.APPL_PROG_NBR = D_ED.APPL_PROG_NBR
          AND D_ED.EFFDT <= SYSDATE)
    AND D.EFFSEQ =
        (SELECT MAX(D_ES.EFFSEQ) FROM PS_ADM_APPL_PROG D_ES
        WHERE D.EMPLID = D_ES.EMPLID
          AND D.ACAD_CAREER = D_ES.ACAD_CAREER
          AND D.STDNT_CAR_NBR = D_ES.STDNT_CAR_NBR
          AND D.ADM_APPL_NBR = D_ES.ADM_APPL_NBR
          AND D.APPL_PROG_NBR = D_ES.APPL_PROG_NBR
          AND D.EFFDT = D_ES.EFFDT)
     AND D.ACAD_CAREER = 'UGRD'
     AND D.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 D3_3 WHERE  D3_3.SELECTOR_NUM=1140 AND D.ADMIT_TERM=D3_3.RANGE_FROM_04 AND D3_3.TREE_NODE_NUM BETWEEN 1999908446 AND 1999938963)
     AND D.PROG_STATUS IN ('AC','AD','PM')
     AND D.ACAD_PROG LIKE '%-A%' )))

POPUP_FALL_MRT_VAR_SWUJ

Screenshot:


Query:

  • POPUP_FALL_MRT_VAR_SWUJ_QRY

Query Details:

SELECT A.EMPLID
  FROM PS_SCCPU_STDNT_BND A, PS_STDNT_AID_ATRBT B
  WHERE ( A.EMPLID = B.EMPLID
     AND B.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 B3_2 WHERE  B3_2.SELECTOR_NUM=1136 AND B.AID_YEAR=B3_2.RANGE_FROM_04 AND B3_2.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
     AND A.EMPLID IN (SELECT C.EMPLID
  FROM PS_STDNT_PKG_VAR C
  WHERE C.INSTITUTION = 'UOD01'
     AND C.ACAD_CAREER = 'UGRD'
     AND C.AID_YEAR = B.AID_YEAR
     AND C.VARIABLE_CHAR3 = 'INITIATED'
     AND C.VARIABLE_CHAR1 = 'FALL TRANSFER MERIT')
     AND A.EMPLID IN (SELECT D.EMPLID
  FROM PS_STDNT_GRPS_HIST D
  WHERE D.EFFDT =
        (SELECT MAX(D_ED.EFFDT) FROM PS_STDNT_GRPS_HIST D_ED
        WHERE D.EMPLID = D_ED.EMPLID
          AND D.INSTITUTION = D_ED.INSTITUTION
          AND D.STDNT_GROUP = D_ED.STDNT_GROUP
          AND D_ED.EFFDT <= SYSDATE)
     AND D.INSTITUTION = 'UOD01'
     AND D.STDNT_GROUP = 'SWUJ'
     AND D.EFF_STATUS = 'A'))

POPUP_FALL_MRT_VAR_BUDG

Screenshot:


Query:

  • POPUP_FALL_MRT_VAR_BUDG_QRY

Query Details:

SELECT A.EMPLID
  FROM PS_SCCPU_STDNT_BND A, PS_STDNT_AID_ATRBT B
  WHERE ( A.EMPLID = B.EMPLID
     AND B.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 B3_2 WHERE  B3_2.SELECTOR_NUM=1136 AND B.AID_YEAR=B3_2.RANGE_FROM_04 AND B3_2.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
     AND A.EMPLID IN (SELECT C.EMPLID
  FROM PS_STDNT_PKG_VAR C
  WHERE C.INSTITUTION = 'UOD01'
     AND C.ACAD_CAREER = 'UGRD'
     AND C.AID_YEAR = B.AID_YEAR
     AND C.VARIABLE_CHAR3 = 'INITIATED')
     AND A.EMPLID NOT IN (SELECT D.EMPLID
  FROM PS_STDNT_TERM_BDGT D
  WHERE D.EFFDT =
        (SELECT MAX(D_ED.EFFDT) FROM PS_STDNT_TERM_BDGT D_ED
        WHERE D.EMPLID = D_ED.EMPLID
          AND D.INSTITUTION = D_ED.INSTITUTION
          AND D.AID_YEAR = D_ED.AID_YEAR
          AND D.ACAD_CAREER = D_ED.ACAD_CAREER
          AND D.STRM = D_ED.STRM
          AND D_ED.EFFDT <= SYSDATE)
    AND D.EFFSEQ =
        (SELECT MAX(D_ES.EFFSEQ) FROM PS_STDNT_TERM_BDGT D_ES
        WHERE D.EMPLID = D_ES.EMPLID
          AND D.INSTITUTION = D_ES.INSTITUTION
          AND D.AID_YEAR = D_ES.AID_YEAR
          AND D.ACAD_CAREER = D_ES.ACAD_CAREER
          AND D.STRM = D_ES.STRM
          AND D.EFFDT = D_ES.EFFDT)
     AND D.INSTITUTION = 'UOD01'
     AND D.AID_YEAR = B.AID_YEAR
     AND D.ACAD_CAREER = 'UGRD'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 D3_4 WHERE  D3_4.SELECTOR_NUM=1140 AND D.STRM=D3_4.RANGE_FROM_04 AND D3_4.TREE_NODE_NUM BETWEEN 1999908446 AND 1999938963)
     AND D.FED_TERM_COA > 0))

POPUP_FALL_MRT_VAR_GPA

Screenshot:


Query:

  • POPUP_FALL_MRT_VAR_GPA_QRY

Query Details:

SELECT A.EMPLID
  FROM PS_SCCPU_STDNT_BND A, PS_STDNT_AID_ATRBT B
  WHERE ( A.EMPLID = B.EMPLID
     AND B.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 B3_2 WHERE  B3_2.SELECTOR_NUM=1136 AND B.AID_YEAR=B3_2.RANGE_FROM_04 AND B3_2.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
     AND A.EMPLID IN (SELECT C.EMPLID
  FROM PS_STDNT_PKG_VAR C
  WHERE C.INSTITUTION = 'UOD01'
     AND C.ACAD_CAREER = 'UGRD'
     AND C.AID_YEAR = B.AID_YEAR
     AND C.VARIABLE_CHAR3 = 'INITIATED')
     AND A.EMPLID NOT IN (SELECT D.EMPLID
  FROM PS_STDNT_PKG_VAR D
  WHERE D.INSTITUTION = 'UOD01'
     AND D.AID_YEAR = B.AID_YEAR
     AND D.ACAD_CAREER = 'UGRD'
     AND D.VARIABLE_CHAR1 = 'FALL FIRSTTIME MERIT'
     AND D.EMPLID IN (SELECT E.EMPLID
  FROM PS_ADM_APPL_PROG E, PS_ADM_MAINT_SCTY E1, PS_ADM_APPL_DATA F, PS_ADM_APPL_SCTY F1, PS_ADM_APPL_CMP G
  WHERE E.EMPLID = E1.EMPLID
    AND E.ACAD_CAREER = E1.ACAD_CAREER
    AND E.STDNT_CAR_NBR = E1.STDNT_CAR_NBR
    AND E.ADM_APPL_NBR = E1.ADM_APPL_NBR
    AND E.APPL_PROG_NBR = E1.APPL_PROG_NBR
    AND E1.OPRCLASS = 'HCPPALL'
    AND E1.OPRID = '702050948'
    AND F.EMPLID = F1.EMPLID
    AND F.ACAD_CAREER = F1.ACAD_CAREER
    AND F.ADM_APPL_NBR = F1.ADM_APPL_NBR
    AND F1.OPRCLASS = 'HCPPALL'
    AND F1.OPRID = '702050948'
    AND ( E.EFFDT =
        (SELECT MAX(E_ED.EFFDT) FROM PS_ADM_APPL_PROG E_ED
        WHERE E.EMPLID = E_ED.EMPLID
          AND E.ACAD_CAREER = E_ED.ACAD_CAREER
          AND E.STDNT_CAR_NBR = E_ED.STDNT_CAR_NBR
          AND E.ADM_APPL_NBR = E_ED.ADM_APPL_NBR
          AND E.APPL_PROG_NBR = E_ED.APPL_PROG_NBR
          AND E_ED.EFFDT <= SYSDATE)
    AND E.EFFSEQ =
        (SELECT MAX(E_ES.EFFSEQ) FROM PS_ADM_APPL_PROG E_ES
        WHERE E.EMPLID = E_ES.EMPLID
          AND E.ACAD_CAREER = E_ES.ACAD_CAREER
          AND E.STDNT_CAR_NBR = E_ES.STDNT_CAR_NBR
          AND E.ADM_APPL_NBR = E_ES.ADM_APPL_NBR
          AND E.APPL_PROG_NBR = E_ES.APPL_PROG_NBR
          AND E.EFFDT = E_ES.EFFDT)
     AND E.EMPLID = F.EMPLID
     AND E.ACAD_CAREER = F.ACAD_CAREER
     AND E.STDNT_CAR_NBR = F.STDNT_CAR_NBR
     AND E.ADM_APPL_NBR = F.ADM_APPL_NBR
     AND E.EMPLID = G.EMPLID
     AND E.ACAD_CAREER = G.ACAD_CAREER
     AND E.STDNT_CAR_NBR = G.STDNT_CAR_NBR
     AND E.ADM_APPL_NBR = G.ADM_APPL_NBR
     AND E.APPL_PROG_NBR = G.APPL_PROG_NBR
     AND E.ACAD_CAREER = 'UGRD'
     AND E.INSTITUTION = 'UOD01'
     AND E.PROG_STATUS IN ('AC','AD','PM')
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 E3_13 WHERE  E3_13.SELECTOR_NUM=1140 AND E.ADMIT_TERM=E3_13.RANGE_FROM_04 AND E3_13.TREE_NODE_NUM BETWEEN 1999908446 AND 1999938963)
     AND F.ADMIT_TYPE IN ('FR','FF')
     AND G.EVALUATION_CODE = 'SRARRANK'
     AND G.RATING_CMP = 'SRGPA'
     AND G.RATING_CMP_VALUE > 0 )))
     AND A.EMPLID NOT IN (SELECT H.EMPLID
  FROM PS_STDNT_PKG_VAR H
  WHERE H.INSTITUTION = 'UOD01'
     AND H.AID_YEAR = B.AID_YEAR
     AND H.ACAD_CAREER = 'UGRD'
     AND H.VARIABLE_CHAR1 = 'FALL TRANSFER MERIT'
     AND H.EMPLID IN (SELECT I.EMPLID
  FROM PS_ADM_APPL_PROG I, PS_ADM_MAINT_SCTY I1, PS_ADM_APPL_DATA J, PS_ADM_APPL_SCTY J1, PS_ADM_APPL_CMP K
  WHERE I.EMPLID = I1.EMPLID
    AND I.ACAD_CAREER = I1.ACAD_CAREER
    AND I.STDNT_CAR_NBR = I1.STDNT_CAR_NBR
    AND I.ADM_APPL_NBR = I1.ADM_APPL_NBR
    AND I.APPL_PROG_NBR = I1.APPL_PROG_NBR
    AND I1.OPRCLASS = 'HCPPALL'
    AND I1.OPRID = '702050948'
    AND J.EMPLID = J1.EMPLID
    AND J.ACAD_CAREER = J1.ACAD_CAREER
    AND J.ADM_APPL_NBR = J1.ADM_APPL_NBR
    AND J1.OPRCLASS = 'HCPPALL'
    AND J1.OPRID = '702050948'
    AND ( I.EFFDT =
        (SELECT MAX(I_ED.EFFDT) FROM PS_ADM_APPL_PROG I_ED
        WHERE I.EMPLID = I_ED.EMPLID
          AND I.ACAD_CAREER = I_ED.ACAD_CAREER
          AND I.STDNT_CAR_NBR = I_ED.STDNT_CAR_NBR
          AND I.ADM_APPL_NBR = I_ED.ADM_APPL_NBR
          AND I.APPL_PROG_NBR = I_ED.APPL_PROG_NBR
          AND I_ED.EFFDT <= SYSDATE)
    AND I.EFFSEQ =
        (SELECT MAX(I_ES.EFFSEQ) FROM PS_ADM_APPL_PROG I_ES
        WHERE I.EMPLID = I_ES.EMPLID
          AND I.ACAD_CAREER = I_ES.ACAD_CAREER
          AND I.STDNT_CAR_NBR = I_ES.STDNT_CAR_NBR
          AND I.ADM_APPL_NBR = I_ES.ADM_APPL_NBR
          AND I.APPL_PROG_NBR = I_ES.APPL_PROG_NBR
          AND I.EFFDT = I_ES.EFFDT)
     AND I.EMPLID = J.EMPLID
     AND I.ACAD_CAREER = J.ACAD_CAREER
     AND I.STDNT_CAR_NBR = J.STDNT_CAR_NBR
     AND I.ADM_APPL_NBR = J.ADM_APPL_NBR
     AND I.EMPLID = K.EMPLID
     AND I.ACAD_CAREER = K.ACAD_CAREER
     AND I.STDNT_CAR_NBR = K.STDNT_CAR_NBR
     AND I.ADM_APPL_NBR = K.ADM_APPL_NBR
     AND I.APPL_PROG_NBR = K.APPL_PROG_NBR
     AND I.ACAD_CAREER = 'UGRD'
     AND I.INSTITUTION = 'UOD01'
     AND I.PROG_STATUS IN ('AC','AD','PM')
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 I3_13 WHERE  I3_13.SELECTOR_NUM=1140 AND I.ADMIT_TERM=I3_13.RANGE_FROM_04 AND I3_13.TREE_NODE_NUM BETWEEN 1999908446 AND 1999938963)
     AND J.ADMIT_TYPE IN ('FT','TR')
     AND K.EVALUATION_CODE = 'UGNLINDEX'
     AND K.RATING_CMP = 'CGPA'
     AND K.RATING_CMP_VALUE > 0 )))
     AND A.EMPLID NOT IN (SELECT L.EMPLID
  FROM PS_ADM_APPL_PROG L, PS_ADM_MAINT_SCTY L1, PS_ADM_APPL_DATA M, PS_ADM_APPL_SCTY M1, PS_ADM_APPL_RCR_CA N
  WHERE L.EMPLID = L1.EMPLID
    AND L.ACAD_CAREER = L1.ACAD_CAREER
    AND L.STDNT_CAR_NBR = L1.STDNT_CAR_NBR
    AND L.ADM_APPL_NBR = L1.ADM_APPL_NBR
    AND L.APPL_PROG_NBR = L1.APPL_PROG_NBR
    AND L1.OPRCLASS = 'HCPPALL'
    AND L1.OPRID = '702050948'
    AND M.EMPLID = M1.EMPLID
    AND M.ACAD_CAREER = M1.ACAD_CAREER
    AND M.ADM_APPL_NBR = M1.ADM_APPL_NBR
    AND M1.OPRCLASS = 'HCPPALL'
    AND M1.OPRID = '702050948'
    AND ( L.EFFDT =
        (SELECT MAX(L_ED.EFFDT) FROM PS_ADM_APPL_PROG L_ED
        WHERE L.EMPLID = L_ED.EMPLID
          AND L.ACAD_CAREER = L_ED.ACAD_CAREER
          AND L.STDNT_CAR_NBR = L_ED.STDNT_CAR_NBR
          AND L.ADM_APPL_NBR = L_ED.ADM_APPL_NBR
          AND L.APPL_PROG_NBR = L_ED.APPL_PROG_NBR
          AND L_ED.EFFDT <= SYSDATE)
    AND L.EFFSEQ =
        (SELECT MAX(L_ES.EFFSEQ) FROM PS_ADM_APPL_PROG L_ES
        WHERE L.EMPLID = L_ES.EMPLID
          AND L.ACAD_CAREER = L_ES.ACAD_CAREER
          AND L.STDNT_CAR_NBR = L_ES.STDNT_CAR_NBR
          AND L.ADM_APPL_NBR = L_ES.ADM_APPL_NBR
          AND L.APPL_PROG_NBR = L_ES.APPL_PROG_NBR
          AND L.EFFDT = L_ES.EFFDT)
     AND L.EMPLID = M.EMPLID
     AND L.ACAD_CAREER = M.ACAD_CAREER
     AND L.STDNT_CAR_NBR = M.STDNT_CAR_NBR
     AND L.ADM_APPL_NBR = M.ADM_APPL_NBR
     AND L.EMPLID = N.EMPLID
     AND L.ACAD_CAREER = N.ACAD_CAREER
     AND L.STDNT_CAR_NBR = N.STDNT_CAR_NBR
     AND L.ADM_APPL_NBR = N.ADM_APPL_NBR
     AND N.INSTITUTION = L.INSTITUTION
     AND L.ACAD_CAREER = 'UGRD'
     AND L.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 L3_12 WHERE  L3_12.SELECTOR_NUM=1140 AND L.ADMIT_TERM=L3_12.RANGE_FROM_04 AND L3_12.TREE_NODE_NUM BETWEEN 1999908446 AND 1999938963)
     AND L.PROG_STATUS IN ('AC','AD','PM')
     AND M.ADMIT_TYPE IN ('FF','FR')
     AND M.ADM_APPL_CTR = 'UINT'
     AND ( N.RECRUITMENT_CAT LIKE 'ISA%'
     OR N.RECRUITMENT_CAT LIKE 'AMA%') )))

POPUP_FALL_MRT_VAR_RESID

Screenshot:


Query:

  • POPUP_FALL_MRT_VAR_RESID_QRY

Query Details:

SELECT A.EMPLID
  FROM PS_SCCPU_STDNT_BND A, PS_STDNT_AID_ATRBT B
  WHERE ( A.EMPLID = B.EMPLID
     AND B.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 B3_2 WHERE  B3_2.SELECTOR_NUM=1136 AND B.AID_YEAR=B3_2.RANGE_FROM_04 AND B3_2.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
     AND A.EMPLID IN (SELECT C.EMPLID
  FROM PS_STDNT_PKG_VAR C
  WHERE C.INSTITUTION = 'UOD01'
     AND C.ACAD_CAREER = 'UGRD'
     AND C.AID_YEAR = B.AID_YEAR
     AND C.VARIABLE_CHAR3 = 'INITIATED')
     AND A.EMPLID IN (SELECT D.EMPLID
  FROM PS_STDNT_TERM_BDGT D
  WHERE D.EFFDT =
        (SELECT MAX(D_ED.EFFDT) FROM PS_STDNT_TERM_BDGT D_ED
        WHERE D.EMPLID = D_ED.EMPLID
          AND D.INSTITUTION = D_ED.INSTITUTION
          AND D.AID_YEAR = D_ED.AID_YEAR
          AND D.ACAD_CAREER = D_ED.ACAD_CAREER
          AND D.STRM = D_ED.STRM
          AND D_ED.EFFDT <= SYSDATE)
    AND D.EFFSEQ =
        (SELECT MAX(D_ES.EFFSEQ) FROM PS_STDNT_TERM_BDGT D_ES
        WHERE D.EMPLID = D_ES.EMPLID
          AND D.INSTITUTION = D_ES.INSTITUTION
          AND D.AID_YEAR = D_ES.AID_YEAR
          AND D.ACAD_CAREER = D_ES.ACAD_CAREER
          AND D.STRM = D_ES.STRM
          AND D.EFFDT = D_ES.EFFDT)
     AND D.INSTITUTION = 'UOD01'
     AND D.ACAD_CAREER = 'UGRD'
     AND D.RESIDENCY = 'N'
     AND D.AID_YEAR = B.AID_YEAR
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 D3_5 WHERE  D3_5.SELECTOR_NUM=1140 AND D.STRM=D3_5.RANGE_FROM_04 AND D3_5.TREE_NODE_NUM BETWEEN 1999908446 AND 1999938963))
     AND A.EMPLID IN (SELECT E.EMPLID
  FROM PS_ADDRESSES E
  WHERE E.EFFDT =
        (SELECT MAX(E_ED.EFFDT) FROM PS_ADDRESSES E_ED
        WHERE E.EMPLID = E_ED.EMPLID
          AND E.ADDRESS_TYPE = E_ED.ADDRESS_TYPE
          AND E_ED.EFFDT <= SYSDATE)
     AND E.ADDRESS_TYPE IN ('HOME','MAIL')
     AND E.STATE = 'DE'
     AND E.EFF_STATUS = 'A'))

POPUP_FALL_MRT_SIM_R2P

Screenshot:


Query:

  • POPUP_FALL_MRT_SIM_R2P_QRY

Query Details:

SELECT A.EMPLID
  FROM PS_SCCPU_STDNT_BND A, PS_STDNT_AID_ATRBT B
  WHERE ( A.EMPLID = B.EMPLID
     AND B.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 B3_2 WHERE  B3_2.SELECTOR_NUM=1136 AND B.AID_YEAR=B3_2.RANGE_FROM_04 AND B3_2.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
     AND A.EMPLID IN (SELECT C.EMPLID
  FROM PS_STDNT_PKG_VAR C
  WHERE C.INSTITUTION = 'UOD01'
     AND C.ACAD_CAREER = 'UGRD'
     AND C.AID_YEAR = B.AID_YEAR
     AND C.VARIABLE_CHAR2 = 'INITIATED'))

POPUP_FALL_MRT_SIM_APPLIED

Screenshot:


Query:

  • POPUP_FALL_MRT_SIM_R2P_QRY (Reused from popup above)

Query Details:

SELECT A.EMPLID
  FROM PS_SCCPU_STDNT_BND A, PS_STDNT_AID_ATRBT B
  WHERE ( A.EMPLID = B.EMPLID
     AND B.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 B3_2 WHERE  B3_2.SELECTOR_NUM=1136 AND B.AID_YEAR=B3_2.RANGE_FROM_04 AND B3_2.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
     AND A.EMPLID IN (SELECT C.EMPLID
  FROM PS_STDNT_PKG_VAR C
  WHERE C.INSTITUTION = 'UOD01'
     AND C.ACAD_CAREER = 'UGRD'
     AND C.AID_YEAR = B.AID_YEAR
     AND C.VARIABLE_CHAR2 = 'INITIATED'))

POPUP_FALL_MRT_VAR_SIM

Screenshot:


Query:

  • POPUP_FALL_MRT_VAR_SIM_QRY

Query Details:

SELECT A.EMPLID
  FROM PS_SCCPU_STDNT_BND A, PS_STDNT_AID_ATRBT B
  WHERE ( A.EMPLID = B.EMPLID
     AND B.INSTITUTION = 'UOD01'
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 B3_2 WHERE  B3_2.SELECTOR_NUM=1136 AND B.AID_YEAR=B3_2.RANGE_FROM_04 AND B3_2.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
     AND A.EMPLID IN (SELECT C.EMPLID
  FROM PS_STDNT_PKG_VAR C
  WHERE C.INSTITUTION = 'UOD01'
     AND C.ACAD_CAREER = 'UGRD'
     AND C.AID_YEAR = B.AID_YEAR
     AND C.VARIABLE_CHAR2 = 'INITIATED'))

Print Article