ADM_SS_APP_ADMT

(SQL View)
 Index Back

Admission Applicant Program

ADM_APPL_PROG is used to record the program specific information related to an admission application. A person may have one application related to multiple academic programs. Admission decisions and statuses are recorded at the program level. The data in this record is carried forward into the ACAD_PROG record when an action of matriculate (MATR) is taken to Activate a student.

SELECT a.EMPLID , a.ACAD_CAREER , a.STDNT_CAR_NBR , a.ADM_APPL_NBR , a.APPL_PROG_NBR , a.EFFDT , a.EFFSEQ , a.INSTITUTION , b.DESCR , c.DESCR , a.ACAD_PROG , d.DESCR , a.ADMIT_TERM , e.DESCR , e.TERM_BEGIN_DT , %CurrentDateIn , f.ADM_APPL_DT , f.ADM_APPL_CTR FROM PS_ADM_APPL_PROG a , PS_INSTITUTION_TBL b , PS_ACAD_CAR_TBL c , PS_ACAD_PROG_TBL d , PS_TERM_TBL e , PS_ADM_APPL_DATA f WHERE a.PROG_STATUS = 'AD' AND a.EFFDT = ( SELECT MAX(a1.EFFDT) FROM PS_ADM_APPL_PROG a1 WHERE a1.EMPLID = a.EMPLID AND a1.ACAD_CAREER = a.ACAD_CAREER AND a1.STDNT_CAR_NBR = a.STDNT_CAR_NBR AND a1.ADM_APPL_NBR = a.ADM_APPL_NBR AND a1.APPL_PROG_NBR = a.APPL_PROG_NBR AND a1.EFFDT <= %CurrentDateIn) AND a.EFFSEQ = ( SELECT MAX(a2.EFFSEQ) FROM PS_ADM_APPL_PROG a2 WHERE a2.EMPLID = a.EMPLID AND a2.ACAD_CAREER = a.ACAD_CAREER AND a2.STDNT_CAR_NBR = a.STDNT_CAR_NBR AND a2.ADM_APPL_NBR = a.ADM_APPL_NBR AND a2.APPL_PROG_NBR = a.APPL_PROG_NBR AND a2.EFFDT = a.EFFDT) AND a.INSTITUTION = b.INSTITUTION AND b.EFFDT = ( SELECT MAX(b1.EFFDT) FROM PS_INSTITUTION_TBL b1 WHERE b1.INSTITUTION = b.INSTITUTION AND b1.EFFDT <= %CurrentDateIn) AND b.EFF_STATUS <> 'I' AND a.INSTITUTION = c.INSTITUTION AND a.ACAD_CAREER = c.ACAD_CAREER AND c.EFFDT = ( SELECT MAX(c1.EFFDT) FROM PS_ACAD_CAR_TBL c1 WHERE c1.INSTITUTION = c.INSTITUTION AND c1.ACAD_CAREER = c.ACAD_CAREER AND c1.EFFDT <= %CurrentDateIn) AND c.EFF_STATUS <> 'I' AND a.INSTITUTION = d.INSTITUTION AND a.ACAD_PROG = d.ACAD_PROG AND d.EFFDT = ( SELECT MAX(d1.EFFDT) FROM PS_ACAD_PROG_TBL d1 WHERE d1.INSTITUTION = d.INSTITUTION AND d1.ACAD_PROG = d.ACAD_PROG AND d1.EFFDT <= %CurrentDateIn) AND d.EFF_STATUS <> 'I' AND a.INSTITUTION = e.INSTITUTION AND a.ACAD_CAREER = e.ACAD_CAREER AND a.ADMIT_TERM = e.STRM AND a.EMPLID=f.EMPLID AND a.ACAD_CAREER=f.ACAD_CAREER AND a.STDNT_CAR_NBR=f.STDNT_CAR_NBR AND a.ADM_APPL_NBR=f.ADM_APPL_NBR

  • Related Language Record: ADMSSAPPADMTLNG

  • Parent record: ADM_APP_CAR_SEQ

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

    Prompt Table: PEOPLE_SRCH

    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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    8 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: ADM_APPL_DATA.INSTITUTION

    Prompt Table: INST_CAR_SCTY

    9 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    10 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    11 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Default Value: OPR_DEF_TBL_CS.ACAD_PROG

    Prompt Table: ACAD_PROG_SCTY

    12 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
    13 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term

    Default Value: OPR_DEF_TBL_CS.STRM

    Prompt Table: TERM_TBL

    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    15 TERM_BEGIN_DT Date(10) DATE Term Begin Date
    16 DATE1 Date(10) DATE Effective Date
    17 ADM_APPL_DT Date(10) DATE Application Date
    18 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center