Applications Not Downloading

Kim Te

• November 04, 2024 18:00

Hi CCC Community! We have not been receiving applications from CCCApply since November 1; individual applications that are marked as valid through CCCApply spam filter are also not coming through either. Just wondering if anyone else is having this problem. 

0

• 

  Jason Gill

  • November 04, 2024 18:27

  We seem to be having normal volumes. 

  By the way, for anyone on Peoplesoft/Oracle, this is a handy SQL to generate counts of apps by submit date. It will also include zero count days, if any. It came in handy during previous outages and slowdowns.

  --enter &fromdt, &todt as YYYY-MM-DD
  
  with datelist as ( select date'&fromdt'+level-1 dt from dual
  connect by level <= (date'&todt' - date'&fromdt'+1))
  select d.dt, count(a.cctc_appl_id) from datelist d
  left outer join ps_cctc_appl_stg a on trunc(cctc_appl_sbmt_ts) = d.dt
  group by d.dt order by d.dt desc;

  0

Please sign in to leave a comment.