Page History

The page in progress

Background

The admission has requested us to modify some of their queries and create some new queries to serve their purpose for new applicant for Baruch College (CUNY).  Attached is the documentation that has provided by admission, please see below:

...

OR ( EXISTS (SELECT G.EMPLID 
  FROM PS_STDNT_TEST_COMP G 
  
WHERE 
G.EMPLID = A.EMPLID 
     AND G.TEST_COMPONENT = 'M1' 
     AND G.SCORE >= 45) 

...