Body
SCHDQRY_MRT_SIM_OFFERS
Screenshot:
Query:
- UDSFS_SCHEDQRY_MERIT_RESULTS
Query Details:
SELECT DISTINCT A.EMPLID, C.VARIABLE_CHAR1, C.VARIABLE_NUM2, A.AID_YEAR, F.RESIDENCY, A.ITEM_TYPE, B.DESCR, A.OFFER_AMOUNT, A.OFFER_AMT_ORIG, D.STATE, E.STATE
FROM ((((PS_PKG_BATCH_AWD A LEFT OUTER JOIN PS_STDNT_PKG_VAR C ON A.INSTITUTION = C.INSTITUTION AND A.AID_YEAR = C.AID_YEAR AND A.ACAD_CAREER = C.ACAD_CAREER AND A.EMPLID = C.EMPLID ) LEFT OUTER JOIN PS_ADDRESSES D ON A.EMPLID = D.EMPLID AND D.EFFDT =
(SELECT MAX(D_ED.EFFDT) FROM PS_ADDRESSES D_ED
WHERE D.EMPLID = D_ED.EMPLID
AND D.ADDRESS_TYPE = D_ED.ADDRESS_TYPE
AND D_ED.EFFDT <= SYSDATE) AND D.ADDRESS_TYPE = 'HOME' AND D.EFF_STATUS = 'A' ) LEFT OUTER JOIN PS_ADDRESSES E ON A.EMPLID = E.EMPLID AND 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 = 'MAIL' AND E.EFF_STATUS = 'A' ) LEFT OUTER JOIN PS_STDNT_TERM_BDGT F ON A.INSTITUTION = F.INSTITUTION AND A.AID_YEAR = F.AID_YEAR AND A.ACAD_CAREER = F.ACAD_CAREER AND A.EMPLID = F.EMPLID AND F.EFFDT =
(SELECT MAX(F_ED.EFFDT) FROM PS_STDNT_TERM_BDGT F_ED
WHERE F.EMPLID = F_ED.EMPLID
AND F.INSTITUTION = F_ED.INSTITUTION
AND F.AID_YEAR = F_ED.AID_YEAR
AND F.ACAD_CAREER = F_ED.ACAD_CAREER
AND F.STRM = F_ED.STRM
AND F_ED.EFFDT <= SYSDATE)
AND F.EFFSEQ =
(SELECT MAX(F_ES.EFFSEQ) FROM PS_STDNT_TERM_BDGT F_ES
WHERE F.EMPLID = F_ES.EMPLID
AND F.INSTITUTION = F_ES.INSTITUTION
AND F.AID_YEAR = F_ES.AID_YEAR
AND F.ACAD_CAREER = F_ES.ACAD_CAREER
AND F.STRM = F_ES.STRM
AND F.EFFDT = F_ES.EFFDT) AND EXISTS (SELECT 'X' FROM PSTREESELECT04 F3_21 WHERE F3_21.SELECTOR_NUM=1140 AND F.STRM=F3_21.RANGE_FROM_04 AND F3_21.TREE_NODE_NUM BETWEEN 1999908446 AND 1999938963) ), PS_ITEM_TYPE_FA B
WHERE ( A.AID_YEAR = B.AID_YEAR
AND B.SETID = A.SETID
AND B.ITEM_TYPE = A.ITEM_TYPE
AND B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_ITEM_TYPE_FA B_ED
WHERE B.SETID = B_ED.SETID
AND B.ITEM_TYPE = B_ED.ITEM_TYPE
AND B.AID_YEAR = B_ED.AID_YEAR
AND B_ED.EFFDT <= SYSDATE)
AND A.BATCH_SEQ_NBR = (SELECT MAX( G.BATCH_SEQ_NBR)
FROM PS_PKG_BATCH_AWD G))
ORDER BY 1
SCHDQRY_MRT_ALL_STUDENTS
Screenshot:
Query:
- UDSFS_SCHEDQRY_MERIT_VARCHAR
Query Details:
SELECT A.EMPLID, A.AID_YEAR, A.VARIABLE_CHAR1, A.VARIABLE_CHAR2, A.VARIABLE_CHAR3, A.VARIABLE_NUM1, A.VARIABLE_NUM2
FROM PS_STDNT_PKG_VAR A
WHERE ( EXISTS (SELECT 'X' FROM PSTREESELECT04 A3_0 WHERE A3_0.SELECTOR_NUM=1136 AND A.AID_YEAR=A3_0.RANGE_FROM_04 AND A3_0.TREE_NODE_NUM BETWEEN 1937500000 AND 1953124999)
AND A.INSTITUTION = 'UOD01'
AND A.ACAD_CAREER = 'UGRD'
AND A.VARIABLE_CHAR2 IN ('SIM PKG COMPLETE','SKIP','REEVALUATE'))