SFA_PU_FTRM_TRG

(SQL Table)
 Index Back

Bind for STDNT_FA_TERM

This table hosts required fields for updating STDNT_FA_TERM for Population Update.

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    4 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    7 BUDGET_REQUIRED Character(1) VARCHAR2(1) NOT NULL Budget Required
    E=Error in Budget Assignment
    I=Budget Assign In Progress
    N=No - Budget Assign Required
    Y=Yes - Budget Assign Required
    8 DIR_LND_YR Character(2) VARCHAR2(2) NOT NULL Direct Lending Year
    01=First Year,never attended
    02=First Year,previously attnd
    03=Second Year
    04=Third Year
    05=Fourth Year
    06=Fifth Year+ Undergrad
    07=First Yr, Grad/Prof
    08=Second Yr, Grad/Prof
    09=Third Yr, Grad/Prof
    10=Fourth Yr+,Grad/Prof
    9 FA_LOAD Character(1) VARCHAR2(1) NOT NULL Financial Aid Load
    F=Enrolled Full-Time
    H=Enrolled Half-Time
    L=Less than Half-Time
    N=No Unit Load
    T=Three Quarter Time

    Prompt Table: FA_LOAD_VW

    10 FA_NUMBER_OF_WEEKS Number(3,0) SMALLINT NOT NULL FA Number of Weeks
    11 FA_STATS_CALC_REQ Character(1) VARCHAR2(1) NOT NULL FA Stats Calculation Required

    Y/N Table Edit

    12 NSLDS_LOAN_YEAR Character(1) VARCHAR2(1) NOT NULL NSLDS Loan Year
    0=1st Year - Never Attended
    1=1st Year - Previously Attended
    2=2nd Year
    3=3rd Year
    4=4th Year
    5=5th Year+
    A=1st Year Graduate
    B=2nd Year Graduate
    C=3rd Year Graduate
    D=4th or more Graduate
    G=Graduate/Professional
    13 OVRD_CENSUSDT_LOCK Character(1) VARCHAR2(1) NOT NULL Override Census Date Locking

    Y/N Table Edit

    14 OVRD_EXP_DT Date(10) DATE Override Expiration Date
    15 SFA_SULA_UNIT Number(9,3) DECIMAL(8,3) NOT NULL SULA Units field
    16 SFA_SPEC_PROG_FLG Character(1) VARCHAR2(1) NOT NULL SULA Special Programs Flag
    A=Selective Admission Assoc Deg
    B=2-year Bachelor's Degree
    N=Not Applicable
    P=Prep Crsewk Grad Prof Pgm
    T=Non-Cred Teacher Cert Pgm
    U=Prep Crsewk Ugrad Program
    17 SFA_SULA_LOAD Character(1) VARCHAR2(1) NOT NULL SULA Load field
    F=Full-time
    H=Half-time
    L=Less than Half-time
    Q=Three-Quarter time
    18 TOT_TERM_UNT_FA Number(9,3) DECIMAL(8,3) NOT NULL Total Term Units
    19 WEEKS_OF_INSTRUCT Number(2,0) SMALLINT NOT NULL Weeks of Instruction
    20 SFA_ENRL_INTENSITY Number(4,2) DECIMAL(3,2) NOT NULL Enrollment Intensity Percent