ADM_PRSPCT_CAR

(SQL Table)
 Index Back

Admission Prospect Career

This table is the primary table used for recording information about prospects relative to a particular Academic Career. Additional information about prospects relative to specific Academic Programs may be entered in the ADM_PRSPCT_PROG record.

  • Parent record: STDNT_CAREER

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

    Default Value: SCC_PERS_SA_VW.EMPLID

    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

    Default Value: OPR_DEF_TBL_CS.ACAD_CAREER

    Prompt Table: STDNT_CAREER

    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INST_CAR_SCTY

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

    Default Value: OPR_DEF_TBL_CS.STRM

    Prompt Table: TERM_TBL

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

    Default Value: OPR_DEF_TBL_CS.ADMIT_TYPE

    Prompt Table: ADMIT_TYPE_VW

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

    Default Value: OPR_DEF_TBL_CS.ADM_RECR_CTR

    Prompt Table: ADM_RECRCTR_SVW

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

    Prompt Table: EXT_ORGSCHL_VW

    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

    Default Value: INQR

    10 RECR_STATUS_DT Date(10) DATE Recruiting Status Date

    Default Value: %date

    11 APPL_ON_FILE Character(1) VARCHAR2(1) NOT NULL Application on file
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: OPR_DEF_TBL_CS.FIN_AID_INTEREST

    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 REGION_FROM Character(1) VARCHAR2(1) NOT NULL Region from
    A=Address
    O=School
    R=Region Tree
    19 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID

    Prompt Table: RECRUITERS

    20 ADM_CREATION_DT Date(10) DATE Admission Data Creation Date

    Default Value: %date

    21 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

    Default Value: OPR_DEF_TBL_CS.ACADEMIC_LEVEL

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

    Default Value: OPR_DEF_TBL_CS.CAMPUS

    Prompt Table: CAMPUS_TBL