ADM_APPL_PROGCI

(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.ACAD_PROG , a.APPL_PROG_NBR , a.EFFDT , a.EFFSEQ , a.INSTITUTION , a.PROG_STATUS , a.PROG_ACTION , a.ACTION_DT , a.PROG_REASON , a.ADMIT_TERM , a.EXP_GRAD_TERM , a.REQ_TERM , a.ACAD_LOAD_APPR , a.CAMPUS , a.ACAD_PROG_DUAL , a.JOINT_PROG_APPR FROM PS_ADM_APPL_PROG a WHERE 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)

  • 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 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Default Value: OPR_DEF_TBL_CS.ACAD_PROG

    Prompt Table: SAD_APP_PRG_VW

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

    Prompt Table: ADM_APP_CAR_SEQ

    7 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: ADM_APPL_DATA.INSTITUTION

    Prompt Table: INST_CAR_SCTY

    10 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
    AC=Active in Program
    AD=Admitted
    AP=Applicant
    CM=Completed Program
    CN=Cancelled
    DC=Discontinued
    DE=Deceased
    DM=Dismissed
    LA=Leave of Absence
    PM=Prematriculant
    SP=Suspended
    WT=Waitlisted
    11 PROG_ACTION Character(4) VARCHAR2(4) NOT NULL Program Action
    ACTV=Activate
    ADMT=Admit
    ADRV=Admission Revocation
    APPL=Application
    COMP=Completion of Program
    COND=Conditional Admit
    DATA=Data Change
    DDEF=Defer Decision
    DEFR=Defer Enrollment
    DEIN=Intention to Matriculate
    DENY=Deny
    DISC=Discontinuation
    DISM=Dismissal
    LEAV=Leave of Absence
    MATR=Matriculation
    PLNC=Plan Change
    PRGC=Program Change
    RADM=Readmit
    RAPP=Readmit Application
    RECN=Reconsideration
    REVK=Revoke Degree
    RLOA=Return from Leave of Absence
    SPND=Suspension
    TRAN=Transfer to Other Career
    VDIS=Voluntarily Discontinued
    WADM=Administrative Withdrawal
    WAIT=Waitlist
    WAOF=Waitlist Offer
    WAPP=Applicant Withdrawal

    Prompt Table: ADM_ACTION_SCTY

    12 ACTION_DT Date(10) DATE Action Date

    Default Value: %date

    13 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason

    Prompt Table: PROG_RSN_TBL

    14 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term

    Default Value: OPR_DEF_TBL_CS.STRM

    Prompt Table: TERM_TBL

    15 EXP_GRAD_TERM Character(4) VARCHAR2(4) NOT NULL Expected Graduation Term

    Prompt Table: TERM_TBL

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

    Default Value: ACAD_PROG.ADMIT_TERM

    Prompt Table: TERM_TBL

    17 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time

    Default Value: F

    18 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: HOME_CAMPUS_VW

    19 ACAD_PROG_DUAL Character(5) VARCHAR2(5) NOT NULL Dual Academic Program

    Prompt Table: ACAD_PROG_TBL

    20 JOINT_PROG_APPR Character(1) VARCHAR2(1) NOT NULL Joint Program Approved

    Y/N Table Edit

    Default Value: N