NSLDS-E / NSLDS-O

Screenshot:

Queries: 

  • QA_CS_CC_NSLDS_UPD_WEEKLY

Query Details:

SELECT DISTINCT B.EMPLID, B.NAME
  FROM PS_SFA_NSLDS_BND B, PS_NSLDS_GEN A
  WHERE ( B.EMPLID = A.EMPLID
     AND A.LAST_UPDATED >= ((TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD')) + (-7)))
  ORDER BY 1

Print Article