ACAD_PROG_PR_VW

(SQL View)
 Index Back

Student Academic Program

This Student Academic Program Table View is used to determine if Primary Student Career Number in the Term Activation panel should prompt against Academic Program or Admissions Application Program.

select emplid, acad_career, prog_action from PS_ACAD_PROG

  • Parent record: PERSON

    • # 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
    3 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