Fall Merit Simulation Mass Package Run Controls

PACKAGE_FALL_MRT_SEL

Screenshot:

Query:

  • UDSFS_MERIT_R2P_ONLY

Query Details:

SELECT DISTINCT A.EMPLID, A.INSTITUTION, A.AID_YEAR, A.ACAD_CAREER
  FROM PS_SFA_BPKG_BIND A, PS_STDNT_AID_ATRBT B
  WHERE ( A.EMPLID = B.EMPLID
     AND A.INSTITUTION = B.INSTITUTION
     AND A.AID_YEAR = B.AID_YEAR
     AND EXISTS (SELECT 'X' FROM PSTREESELECT04 B3_3 WHERE  B3_3.SELECTOR_NUM=1136 AND B.AID_YEAR=B3_3.RANGE_FROM_04 AND B3_3.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
     AND B.PROCESSING_STATUS = '3')
  ORDER BY 1

PACKAGE_FALL_MRT_ASSIGN

Screenshot:

PACKAGE_FALL_MRT_SIM

Screenshot:

Print Article