SAD_ED_SBPLN_VW

(SQL View)
 Index Back

Admission Applicant Subplan

This table is used to record the Current Effective Academic SubPlans which an applicant has applied to. These plans are supplemental to the applicant's Academic Plan. In order to have an entry in this table an applicant must have applied to an Academic Plan.

SELECT emplid , acad_career , stdnt_car_nbr , adm_appl_nbr , appl_prog_nbr , acad_plan , acad_sub_plan , declare_dt , req_term FROM PS_ADM_APPL_SBPLAN a WHERE a.effdt = ( SELECT MAX(b.effdt) FROM PS_ADM_APPL_SBPLAN b WHERE a.emplid = b.emplid AND a.acad_career = b.acad_career AND a.stdnt_car_nbr = b.stdnt_car_nbr AND a.adm_appl_nbr = b.adm_appl_nbr AND a.appl_prog_nbr = b.appl_prog_nbr AND a.acad_plan = b.acad_plan AND a.acad_sub_plan = b.acad_sub_plan ) AND a.effseq = ( SELECT MAX(c.effseq) FROM PS_ADM_APPL_SBPLAN c WHERE a.emplid = c.emplid AND a.acad_career = c.acad_career AND a.stdnt_car_nbr = c.stdnt_car_nbr AND a.adm_appl_nbr = c.adm_appl_nbr AND a.appl_prog_nbr = c.appl_prog_nbr AND a.acad_plan = c.acad_plan AND a.acad_sub_plan = c.acad_sub_plan AND a.effdt = c.effdt )

  • Parent record: ADM_APPL_PLAN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    2 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: STDNT_CAREER

    3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

    Prompt Table: ADM_APPL_DATA

    5 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr

    Prompt Table: ADM_APP_CAR_SEQ

    6 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ADM_APPL_PLAN

    7 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

    Prompt Table: SAD_APP_SPLN_VW

    8 DECLARE_DT Date(10) DATE NOT NULL Declare Date

    Default Value: ADM_APPL_PLAN.DECLARE_DT

    9 REQ_TERM Character(4) VARCHAR2(4) NOT NULL Requirement Term

    Prompt Table: TERM_TBL