PELL_PMT_CAR_VW

(SQL View)
 Index Back

Pell Pmt Career Copy View

This view is used to copy Pell Payment Set up Career by INSTITUTION, AID_YEAR, and TIV_SCHOOL_CODE.

SELECT INSTITUTION, AID_YEAR, TIV_SCHOOL_CODE, ACAD_CAREER, ACAD_PROG_PRIMARY, ACAD_PLAN, ACADEMIC_CALENDAR, PELL_PAY_PERIODS, LOW_TUITION_FLAG, PELL_PMT_METH, HOURS_CREDITS, WEEKS_PROG_ACADYR, PELL_FT_ENRLMNT, PELL_ORIG_OFFERED, PELL_ORIG_MAX_AWD FROM PS_PELL_PMT_CAREER

  • Parent record: PELL_PMT_OPTION

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

    Prompt Table: INSTITUTION_TBL

    2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: AID_YEAR_TBL

    3 TIV_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL Pell ID Reporting

    Prompt Table: PELL_ATTEND_VW

    4 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_TBL

    5 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program

    Prompt Table: ACAD_PRGFA_CRVW

    6 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBLVW

    7 ACADEMIC_CALENDAR Character(1) VARCHAR2(1) NOT NULL Academic Calendar
    1=Credit Hr (non-standard terms)
    2=Use standard quarters
    3=Use standard semesters
    4=Use standard trimesters
    5=Academic progress by clock-hrs
    6=Credit Hr w/o Terms
    8 PELL_PAY_PERIODS Number(1,0) SMALLINT NOT NULL Pell Payment Periods
    9 LOW_TUITION_FLAG Character(1) VARCHAR2(1) NOT NULL Low Tuition and Fees Flag
    1=Tuition is 0
    2=Low Tuition Range 2
    3=Low Tuition Range 3
    4=Low Tuition Range 4
    10 PELL_PMT_METH Character(1) VARCHAR2(1) NOT NULL Payment Methodology
    1=Formula 1
    2=Formula 2
    3=Formula 3
    4=Formula 4
    5=Formula 5
    6=Other
    11 HOURS_CREDITS Number(4,0) SMALLINT NOT NULL Hours/Credits in Acad Year
    12 WEEKS_PROG_ACADYR Character(2) VARCHAR2(2) NOT NULL Weeks in Program Acad Year
    13 PELL_FT_ENRLMNT Character(1) VARCHAR2(1) NOT NULL Use Fulltime Enrollment

    Y/N Table Edit

    14 PELL_ORIG_OFFERED Character(1) VARCHAR2(1) NOT NULL Originate Offered Awards

    Y/N Table Edit

    15 PELL_ORIG_MAX_AWD Character(1) VARCHAR2(1) NOT NULL Originate Max Pell Award

    Y/N Table Edit