STDNT_PELL_RULE

(SQL Table)
 Index Back

Student PEC Override

STDNT_PELL_RULE is a child table of STUDENT_AID. It contains override values for the fields used in PELL eligibility calculation used in Financial Aid packaging.

  • Parent record: STUDENT_AID

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

    Default Value: FA_INSTITUTN_VW.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: STUDENT_AID

    4 TABLE_ID Character(1) VARCHAR2(1) NOT NULL Child Table Key

    Default Value: 1

    5 BASE_WEEKS_ACAD Number(4,1) DECIMAL(3,1) NOT NULL Academic Base Weeks
    6 BASE_WEEKS_NSTD Number(4,1) DECIMAL(3,1) NOT NULL Non-Standard Base Weeks
    7 PELL_CALC_START Character(1) VARCHAR2(1) NOT NULL Pell Calculation Start
    1=Formula 1 - FA Load
    2=Formula 1 - Full-time
    3=Formula 3 - FA Load
    4=Formula 3 - Current Load
    5=Formula 3 - Full-time
    C=Enrollment Current Load
    E=Enrollment FA Load
    F=Full Time
    H=Half Time
    8 PELL_CALC_MIDTERM Character(1) VARCHAR2(1) NOT NULL Pell Calculation Midterm
    1=Formula 1 - FA Load
    2=Formula 1 - Full-time
    3=Formula 3 - FA Load
    4=Formula 3 - Current Load
    5=Formula 3 - Full-time
    C=Enrollment Current Load
    E=Enrollment FA Load
    F=Full Time
    H=Half Time
    9 PELL_CALC_CENSUS Character(1) VARCHAR2(1) NOT NULL Pell Calculation Census
    1=Formula 1 - FA Load
    2=Formula 1 - Full-time
    3=Formula 3 - FA Load
    4=Formula 3 - Current Load
    5=Formula 3 - Full-time
    C=Enrollment Current Load
    E=Enrollment FA Load
    F=Full Time
    H=Half Time
    10 PELL_NBR_TERMS Number(2,0) SMALLINT NOT NULL Pell Number of Terms
    11 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: I

    12 SFA_PELL_USE_XOVR Character(1) VARCHAR2(1) NOT NULL Use PELL Cross Over Logic
    N=Do Not Use PELL XOver Logic
    Y=Use PELL XOver Logic

    Default Value: N