Immunization

IN TEST

The immunization item is available to new students. A student is determined to be new based on data in the student profile. If current term is greater than admit term, the student is continuing. Otherwise they are new. The function below must also return 'Y', otherwise the item does not display.

The item will start displaying upon confirmation.

The item will stop displaying on the last day of the person's admit term.

Deadlines for the terms are:

• Fall - September 1
• Winter - January 30
• Spring - April 30
• Summer - July 15

szkmbsc.f_disp_immu_upload:

function f_disp_immu_upload(p_id spriden.spriden_id%type) return varchar2 is
    cursor StudC(uid varchar2) is
      SELECT sgbstdn_Full_Part_Ind, sgbstdn_Coll_Code_1
        FROM Sgbstdn a, spriden b
       WHERE a.Sgbstdn_Stst_Code = 'AS'
         AND a.Sgbstdn_Styp_Code IN ('N', 'P', 'T','V')
         AND b.spriden_id = uid
         and b.spriden_change_ind is null
         and a.Sgbstdn_PIDM = b.SPRIDEN_PIDM
         and a.Sgbstdn_Term_Code_EFF =
             (
              select max(b.Sgbstdn_Term_Code_EFF)
                from Sgbstdn b
               where b.Sgbstdn_pidm = a.Sgbstdn_pidm
                 and b.Sgbstdn_Stst_Code = 'AS'
                 AND b.Sgbstdn_Styp_Code IN ('N', 'P', 'T','V'));
    o_status varchar2(1);
    fttime   varchar2(1);
    coll     varchar2(20);
  begin
    open StudC(p_id);
    fetch StudC
      into fttime, coll;
    if StudC%found then
      if fttime = 'P' or coll = 'MS' then
        o_status := 'N';
      else
        o_status := 'Y';
      end if;
    else
      o_status := 'N';
    end if;
    close StudC;
    return o_status;
  exception
    when others then
      RETURN 'F';
  end f_disp_immu_upload;