ADM_EVAL_FA_REC

(SQL Table)
 Index Back

Adm Evals for FA and SR

AD02A - Admission Evaluation results to be passed to Financial Aid and Student Records.

  • Parent record: ADM_APPL_EVAL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTN_SCRTY

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    3 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: ACAD_CAR_SCRTY

    4 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    5 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
    6 RATING_CMP Character(5) VARCHAR2(5) NOT NULL Rating Component

    Prompt Table: RTNG_CMPDEF_TBL

    7 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

    Prompt Table: ADM_APPL_DATA

    8 EVALUATION_DT Date(10) DATE Evaluation Date
    9 EVALUATION_CODE Character(10) VARCHAR2(10) NOT NULL Evaluation Code

    Prompt Table: EVALUATION_TBL

    10 APPL_EVAL_NBR Number(3,0) SMALLINT NOT NULL Evaluation Nbr

    Prompt Table: ADM_APPL_EVAL

    11 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    12 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
    13 RATING_CMP_VALUE Number(10,4) DECIMAL(9,4) NOT NULL Rating Value
    14 EVAL_FA_VALUE Character(1) VARCHAR2(1) NOT NULL Use for Financial Aid

    Y/N Table Edit

    Default Value: N

    15 EVAL_SR_VALUE Character(1) VARCHAR2(1) NOT NULL Use for Student Records

    Y/N Table Edit

    Default Value: N