SFA_PU_FTRM_BND

(SQL View)
 Index Back

Bind for STDNT_FA_TERM

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

SELECT A.EMPLID ,A.INSTITUTION ,A.STRM ,A.EFFDT ,A.EFFSEQ ,B.NAME ,C.DESCR ,' ' ,' ' ,' ' ,0 ,' ' ,' ' ,' ' ,%DateNull ,0 ,' ' ,' ' ,0 ,0 ,0 FROM PS_STDNT_FA_TERM A , PS_SCC_PRI_NAME_VW B ,PS_TERM_VAL_TBL C WHERE A.EFFDT=( SELECT MAX (A1.EFFDT) FROM PS_STDNT_FA_TERM A1 WHERE A.EMPLID=A1.EMPLID AND A.INSTITUTION=A1.INSTITUTION AND A.STRM =A1.STRM AND A1.EFFDT <=%CurrentDateIn) AND A.EFFSEQ=( SELECT MAX(A2.EFFSEQ) FROM PS_STDNT_FA_TERM A2 WHERE A.EMPLID=A2.EMPLID AND A.INSTITUTION=A2.INSTITUTION AND A.STRM =A2.STRM AND A.EFFDT =A2.EFFDT) AND A.EMPLID = B.EMPLID AND A.STRM=C.STRM

  • Parent record: FA_FATERM_PARNT

    • # 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: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: TERM_VAL_TBL

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 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
    9 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
    10 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

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

    Y/N Table Edit

    13 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
    14 OVRD_CENSUSDT_LOCK Character(1) VARCHAR2(1) NOT NULL Override Census Date Locking

    Y/N Table Edit

    15 OVRD_EXP_DT Date(10) DATE Override Expiration Date
    16 SFA_SULA_UNIT Number(9,3) DECIMAL(8,3) NOT NULL SULA Units field
    17 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
    18 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
    19 TOT_TERM_UNT_FA Number(9,3) DECIMAL(8,3) NOT NULL Total Term Units
    20 WEEKS_OF_INSTRUCT Number(2,0) SMALLINT NOT NULL Weeks of Instruction
    21 SFA_ENRL_INTENSITY Number(4,2) DECIMAL(3,2) NOT NULL Enrollment Intensity Percent