ADM_PRS_MC_VW

(SQL View)
 Index Back

Admission Prospect Program MC

This view contains both Career and Program information relevant to a prospect being recruited by program. The Recruiting Center, Recruiting Status, and Campus are taken from the program record.

Select a.EMPLID, a.ACAD_CAREER, a.INSTITUTION, a.ADMIT_TERM, a.ADMIT_TYPE, b.ADM_RECR_CTR, a.LAST_SCH_ATTEND, a.GRADUATION_DT, b.RECRUITING_STATUS, b.RECR_STATUS_DT, a.APPL_ON_FILE, a.FIN_AID_INTEREST, a.HOUSING_INTEREST, a.ACAD_LOAD_APPR, a.ADM_REFRL_SRCE, a.REFERRAL_SRCE_DT, a.REGION, a.RECRUITER_ID, a.ADM_CREATION_DT, a.ACADEMIC_LEVEL, b.CAMPUS, b.ACAD_PROG FROM PS_ADM_PRSPCT_CAR a, PS_ADM_PRSPCT_PROG b WHERE a.EMPLID=b.EMPLID AND a.ACAD_CAREER=b.ACAD_CAREER AND a.INSTITUTION=b.INSTITUTION

  • Parent record: STDNT_CAREER

    • # 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INST_CAR_SCTY

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

    Prompt Table: TERM_TBL

    5 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type

    Prompt Table: ADMIT_TYPE_VW

    6 ADM_RECR_CTR Character(4) VARCHAR2(4) NOT NULL Recruiting Center

    Prompt Table: ADM_RECRCTR_SVW

    7 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last School Attended

    Prompt Table: EXT_ORG_TBL

    8 GRADUATION_DT Date(10) DATE Graduation Date
    9 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
    APPL=Applicant
    INAC=Inactive
    INQR=Inquiry
    PAPL=Pre-Applicant
    PROS=Prospect
    SUSP=Suspect
    10 RECR_STATUS_DT Date(10) DATE Recruiting Status Date
    11 APPL_ON_FILE Character(1) VARCHAR2(1) NOT NULL Application on file
    N=No
    Y=Yes

    Y/N Table Edit

    12 FIN_AID_INTEREST Character(1) VARCHAR2(1) NOT NULL Financial Aid Interest

    Y/N Table Edit

    13 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing Interest
    C=Commuter
    F=Off Campus Housing
    H=On Campus Housing
    14 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
    15 ADM_REFRL_SRCE Character(4) VARCHAR2(4) NOT NULL Referral Source

    Prompt Table: REFERL_SRCE_TBL

    16 REFERRAL_SRCE_DT Date(10) DATE Referral Source Date
    17 REGION Character(10) VARCHAR2(10) NOT NULL Region

    Prompt Table: REGN_BASE_SRCH

    18 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID

    Prompt Table: RECRUITERS

    19 ADM_CREATION_DT Date(10) DATE Admission Data Creation Date
    20 ACADEMIC_LEVEL Character(3) VARCHAR2(3) NOT NULL Academic Level
    00=Not Set
    01=First Year
    02=Second Year
    03=Third Year
    04=Fourth Year
    05=Fifth Year
    06=Sixth Year
    10=Freshman
    20=Sophomore
    30=Junior
    40=Senior
    50=Post-Bacc Undergraduate
    GR=Graduate
    GRA=Graduate AUS
    HON=Honours
    IE=Industrial Experience
    MAS=Masters
    P1=Professional Year 1
    P2=Professional Year 2
    P3=Professional Year 3
    P4=Professional Year 4
    PHD=PhD
    21 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    22 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program