FAN_LSTFATRM_VW

(SQL View)
 Index Back

Student Last Fin Aid Term View

This table contains student information by Institution and Aid Year. It only picks up the last term within that aid year and delivers the STDNT_FA_TERM data. This is a view of this table used for Fin Aid Award Notification Letter equation selection processing.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.STRM ,A.EFF_STATUS ,A.BUDGET_REQUIRED ,A.WITHDRAW_CODE ,A.WITHDRAW_REASON ,A.WITHDRAW_DATE ,A.LAST_DATE_ATTENDED ,A.ACAD_CAREER ,A.ACAD_CAREER_CL ,A.OVRD_CAREER ,A.ACAD_PLAN ,A.ACAD_PLAN_CL ,A.OVRD_ACAD_PLAN ,A.ACAD_SUB_PLAN ,A.ACAD_SUB_PLAN_CL ,A.OVRD_SUB_PLAN ,A.STDNT_CAR_NBR ,A.ACAD_PROG_PRIMARY ,A.ACAD_PROG_PRIM_CL ,A.OVRD_ACAD_PROG_PRM ,A.ACAD_LOAD_APPR ,A.ACAD_LOAD_APPR_CL ,A.OVRD_ACAD_LOAD_AP ,A.ACADEMIC_LOAD ,A.ACADEMIC_LOAD_CL ,A.OVRD_ACADEMIC_LOAD ,A.ACAD_LEVEL_PROJ ,A.ACAD_LEVEL_PROJ_CL ,A.ACAD_LEVEL_BOT ,A.ACAD_LEVEL_BOT_CL ,A.ACAD_LEVEL_EOT ,A.ACAD_LEVEL_EOT_CL ,A.OVRD_ACAD_LVL_PROJ ,A.OVRD_ACAD_LVL_ALL ,A.ELIG_TO_ENROLL ,A.RESET_CUM_STATS ,A.FORM_OF_STUDY ,A.FORM_OF_STUDY_CL ,A.OVRD_FORM_OF_STUDY ,A.TERM_TYPE ,A.SEL_GROUP ,A.TUIT_CALC_REQ ,A.TUIT_CALC_DTTM ,A.BILLING_CAREER ,A.ACAD_YEAR ,A.ACAD_YEAR_CL ,A.OVRD_ACAD_YEAR ,A.CUR_RESIDENT_TERMS ,A.TRF_RESIDENT_TERMS ,A.CUM_RESIDENT_TERMS ,A.UNT_TAKEN_FA ,A.UNT_TAKEN_FA_CL ,A.OVRD_UNT_TAKEN_FA ,A.UNT_PASSD_FA ,A.UNT_PASSD_FA_CL ,A.OVRD_UNT_PASSD_FA ,A.TOT_TAKEN_FA ,A.TOT_TAKEN_FA_CL ,A.OVRD_TOT_TAKEN_FA ,A.TOT_PASSD_FA ,A.TOT_PASSD_FA_CL ,A.OVRD_TOT_PASSD_FA ,A.REMOTE_UNT_FA ,A.TOT_TERM_UNT_FA ,A.TOT_TERM_UNT_FA_CL ,A.OVRD_FA_UNITS ,A.FA_UNIT_WARNING ,A.FA_LOAD ,A.FA_LOAD_CL ,A.OVRD_FA_LOAD ,A.LS_GPA ,A.GPA_CL ,A.CUM_GPA ,A.CUM_GPA_CL ,A.OVRD_CUM_GPA ,A.OVRD_GPA ,A.GPA_CALC_IND ,A.NSLDS_LOAN_YEAR ,A.NSLDS_LOAN_YEAR_CL ,A.OVRD_NSLDS_LOAN_YR ,A.DIR_LND_YR ,A.DEGR_CONFER_DT ,A.EXP_GRAD_TERM ,A.EXP_GRAD_TERM_CL ,A.OVRD_GRAD_TERM ,A.EXP_GRAD_DATE ,A.EXP_GRAD_DATE_CL ,A.OVRD_GRAD_DATE ,A.UNT_TAKEN_GPA ,A.TOT_TAKEN_GPA ,A.GRADE_POINTS ,A.TOT_GRADE_POINTS ,A.ACAD_STANDING ,A.ACAD_STANDING_CL ,A.OVRD_ACAD_STANDING ,A.FA_STANDING ,A.FA_STANDING_CL ,A.OVRD_FA_STANDING ,A.CAMPUS ,A.EXT_ORG_ID ,A.COUNTRY ,A.STUDY_AGREEMENT ,A.START_DATE ,A.END_DATE ,A.ACAD_GROUP_ADVIS ,A.ADMIT_TERM ,A.PROJ_BILL_UNT ,A.OVRD_BILL_UNITS ,A.SRVC_IND_CD ,A.SRVC_IND_DTTM ,A.REFUND_PCT ,A.REFUND_SCHEME ,A.REFUND_SETID ,A.REFUND_CLASS ,A.CAMPUS_FA ,A.CAMPUS_REGISTRAR ,A.CAMPUS_ADVISEMENT ,A.BUSINESS_UNIT ,A.ADVISOR_ROLE ,A.ADVISOR_ID ,A.COMMITTEE_ID ,A.WEEKS_OF_INSTRUCT ,A.FA_STATS_CALC_REQ ,A.FA_NUMBER_OF_WEEKS ,A.COURSE_LD_PCT ,A.COST_CODE ,A.OVRD_EXP_DT ,A.DRIVER_OPTION ,A.ONLINE_BATCH_IND ,A.TERM_SRC ,A.CREATION_DT ,A.OPRID ,A.PROCESS_INSTANCE ,A.UNT_TAKEN_FA_INEL ,A.UNT_PASSD_FA_INEL ,A.UNT_TAKEN_PRG_INEL ,A.GRADE_POINTS_INEL ,A.UNT_TAKEN_GPA_INEL ,A.FA_CAR_TYPE ,A.UNT_TAKEN_FA_NOPIT ,A.LOCK_OVRD_DATE ,A.LOCK_OVRD_OPRID ,A.OVRD_CENSUSDT_LOCK ,A.UNT_TRNSFR ,A.TRF_PASSED_GPA ,A.TRF_PASSED_NOGPA ,A.UNT_TEST_CREDIT ,A.UNT_OTHER ,A.TC_UNITS_ADJUST ,A.TOT_TRNSFR ,A.TOT_TEST_CREDIT ,A.TOT_OTHER ,A.TOT_TC_UNIT_ADJUST ,A.FA_EXP_DT_REBUILD ,A.FA_UNIT_ANTIC ,A.FA_UNIT_COMPLETED ,A.FA_UNIT_IN_PROG ,A.FA_UNIT_CURRENT ,A.FA_LOAD_CURRENT ,A.FA_REBUILD_DT ,A.ACAD_PLAN_TYPE ,A.FA_LOAD_CHANGE_IND ,A.CENSUS_DT ,A.AID_YEAR_CL ,A.OVRD_AID_YEAR ,A.FA_OEE_STUDENT ,A.DIR_LND_YR_CL ,A.OVRD_DIR_LND_YR FROM PS_STDNT_FA_TERM A WHERE A.STRM = ( SELECT MAX(D.STRM) FROM PS_STDNT_FA_TERM D WHERE D.EMPLID = A.EMPLID AND D.INSTITUTION = A.INSTITUTION AND D.AID_YEAR = A.AID_YEAR ) AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_STDNT_FA_TERM B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.STRM = A.STRM AND B.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_STDNT_FA_TERM C WHERE C.EMPLID = A.EMPLID AND C.INSTITUTION = A.INSTITUTION AND C.STRM = A.STRM AND C.EFFDT = A.EFFDT )

  • 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: PERSONAL_DATA

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

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: AID_YEAR_FAT_VW

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

    Prompt Table: TERM_VAL_TBL

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 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
    7 WITHDRAW_CODE Character(3) VARCHAR2(3) NOT NULL Withdrawal \ Cancel
    CAN=Cancelled
    NWD=
    WDR=Withdrew
    8 WITHDRAW_REASON Character(4) VARCHAR2(4) NOT NULL Withdrawal \ Cancel Reason
    MEDI=Medical
    NPAY=Non-Payment of Fees
    RETR=Retroactive
    9 WITHDRAW_DATE Date(10) DATE Withdrawal \ Cancel Date
    10 LAST_DATE_ATTENDED Date(10) DATE Last Date of Attendance
    11 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

    12 ACAD_CAREER_CL Character(4) VARCHAR2(4) NOT NULL Acad Career Calculated

    Prompt Table: ACAD_CAR_TBL

    13 OVRD_CAREER Character(1) VARCHAR2(1) NOT NULL Override Career

    Y/N Table Edit

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

    Prompt Table: ACAD_PLAN_TBLVW

    15 ACAD_PLAN_CL Character(10) VARCHAR2(10) NOT NULL Acad Plan Calculated

    Prompt Table: ACAD_PLAN_TBL

    16 OVRD_ACAD_PLAN Character(1) VARCHAR2(1) NOT NULL Override Academic Plan

    Y/N Table Edit

    17 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

    Prompt Table: ACAD_SUBPLN_TBL

    18 ACAD_SUB_PLAN_CL Character(10) VARCHAR2(10) NOT NULL Acad Sub-Plan Calculated

    Prompt Table: ACAD_SUBPLN_TBL

    19 OVRD_SUB_PLAN Character(1) VARCHAR2(1) NOT NULL Override Sub-Plan

    Y/N Table Edit

    20 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

    Prompt Table: %EDITTABLE

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

    Prompt Table: ACAD_PRGFA_CRVW

    22 ACAD_PROG_PRIM_CL Character(5) VARCHAR2(5) NOT NULL Primary Program Calculated

    Prompt Table: ACAD_PROG_CARVW

    23 OVRD_ACAD_PROG_PRM Character(1) VARCHAR2(1) NOT NULL Override Primary Acad Program

    Y/N Table Edit

    24 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time
    25 ACAD_LOAD_APPR_CL Character(1) VARCHAR2(1) NOT NULL Acad Load Approved Calculated
    F=Full-Time
    P=Part-Time
    26 OVRD_ACAD_LOAD_AP Character(1) VARCHAR2(1) NOT NULL Override Approved Acad Load

    Y/N Table Edit

    27 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
    F=Enrolled Full-Time
    H=Enrolled Half-Time
    L=Less than Half-Time
    N=No Unit Load
    P=Enrolled Part-Time
    T=Three Quarter Time

    Prompt Table: FA_LOAD_VW

    28 ACADEMIC_LOAD_CL Character(1) VARCHAR2(1) NOT NULL Academic Load Calculated
    F=Full-Time
    H=Half-Time
    L=Less 1/2
    N=No Units
    P=Part-Time
    T=3/4 Time

    Prompt Table: ACAD_LOAD_TBL

    29 OVRD_ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Override Academic Load

    Y/N Table Edit

    30 ACAD_LEVEL_PROJ Character(3) VARCHAR2(3) NOT NULL Academic Level - Projected

    Prompt Table: ACAD_LEVEL_TBL

    31 ACAD_LEVEL_PROJ_CL Character(3) VARCHAR2(3) NOT NULL Acad Level Proj Calculated
    5AR=Fifth year Architecture
    DOC=Doctorate
    FR=Freshman
    GR=Graduate
    HS=High School Concurrent
    JR=Junior
    MAS=Masters
    NDG=Non-deg Graduate
    NDU=Non-deg Undergraduate
    NST=Not Set
    P1=Professional Year 1
    P2=Professional Year 2
    P3=Professional Year 3
    P4=Professional Year 4
    PBC=Post-bacc Teach Certificate
    PBU=Post-bacc Undergraduate
    PMC=Post-mast Teach Cert
    PPR=Post-Professional
    PRE=Pre-Candidate
    SO=Sophomore
    SR=Senior

    Prompt Table: ACAD_LEVEL_TBL

    32 ACAD_LEVEL_BOT Character(3) VARCHAR2(3) NOT NULL Academic Level - Term Start

    Prompt Table: ACAD_LEVEL_TBL

    33 ACAD_LEVEL_BOT_CL Character(3) VARCHAR2(3) NOT NULL Acad Level BOT Calculated
    5AR=Fifth year Architecture
    DOC=Doctorate
    FR=Freshman
    GR=Graduate
    HS=High School Concurrent
    JR=Junior
    MAS=Masters
    NDG=Non-deg Graduate
    NDU=Non-deg Undergraduate
    NST=Not Set
    P1=Professional Year 1
    P2=Professional Year 2
    P3=Professional Year 3
    P4=Professional Year 4
    PBC=Post-bacc Teach Certificate
    PBU=Post-bacc Undergraduate
    PMC=Post-mast Teach Cert
    PPR=Post-Professional
    PRE=Pre-Candidate
    SO=Sophomore
    SR=Senior

    Prompt Table: ACAD_LEVEL_TBL

    34 ACAD_LEVEL_EOT Character(3) VARCHAR2(3) NOT NULL Academic Level - Term End

    Prompt Table: ACAD_LEVEL_TBL

    35 ACAD_LEVEL_EOT_CL Character(3) VARCHAR2(3) NOT NULL Acad Level EOT Calculated
    5AR=Fifth year Architecture
    DOC=Doctorate
    FR=Freshman
    GR=Graduate
    HS=High School Concurrent
    JR=Junior
    MAS=Masters
    NDG=Non-deg Graduate
    NDU=Non-deg Undergraduate
    NST=Not Set
    P1=Professional Year 1
    P2=Professional Year 2
    P3=Professional Year 3
    P4=Professional Year 4
    PBC=Post-bacc Teach Certificate
    PBU=Post-bacc Undergraduate
    PMC=Post-mast Teach Cert
    PPR=Post-Professional
    PRE=Pre-Candidate
    SO=Sophomore
    SR=Senior

    Prompt Table: ACAD_LEVEL_TBL

    36 OVRD_ACAD_LVL_PROJ Character(1) VARCHAR2(1) NOT NULL Override Projected Level

    Y/N Table Edit

    37 OVRD_ACAD_LVL_ALL Character(1) VARCHAR2(1) NOT NULL Override All Academic Levels

    Y/N Table Edit

    38 ELIG_TO_ENROLL Character(1) VARCHAR2(1) NOT NULL Eligible to Enroll

    Y/N Table Edit

    39 RESET_CUM_STATS Character(1) VARCHAR2(1) NOT NULL Reset Cum Stats at Term Start

    Y/N Table Edit

    40 FORM_OF_STUDY Character(4) VARCHAR2(4) NOT NULL Form of Study
    ABRD=Study Abroad
    CAND=Advanced to Candidacy
    DTCH=Detached Study
    ENRL=Class Enrollment
    41 FORM_OF_STUDY_CL Character(4) VARCHAR2(4) NOT NULL Form of Study Calculated
    ABRD=Study Abroad
    CAND=Advanced to Candidacy
    DTCH=Detached Study
    ENRL=Class Enrollment
    42 OVRD_FORM_OF_STUDY Character(1) VARCHAR2(1) NOT NULL Override Form of Study

    Y/N Table Edit

    43 TERM_TYPE Character(1) VARCHAR2(1) NOT NULL Term Unit Type
    C=Clock Hours
    E=Continuing Education Units
    Q=Quarter Hours
    S=Semester Hours
    T=Trimester Hours
    U=Units

    Prompt Table: TERM_TYPE_TBL

    44 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group

    Prompt Table: SEL_GROUP_VW

    45 TUIT_CALC_REQ Character(1) VARCHAR2(1) NOT NULL Tuition Calc Required

    Y/N Table Edit

    46 TUIT_CALC_DTTM DateTime(26) TIMESTAMP Tuit Calc Date Time
    47 BILLING_CAREER Character(4) VARCHAR2(4) NOT NULL Billing Career

    Prompt Table: ACAD_CAR_TBL

    48 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
    49 ACAD_YEAR_CL Character(4) VARCHAR2(4) NOT NULL Acad Year Calculated
    50 OVRD_ACAD_YEAR Character(1) VARCHAR2(1) NOT NULL Override Acad Year

    Y/N Table Edit

    51 CUR_RESIDENT_TERMS Number(7,3) DECIMAL(6,3) NOT NULL Current In Residence Terms
    52 TRF_RESIDENT_TERMS Number(7,3) DECIMAL(6,3) NOT NULL Transfer In Residence Terms
    53 CUM_RESIDENT_TERMS Number(7,3) DECIMAL(6,3) NOT NULL Cumulative In Residence Terms
    54 UNT_TAKEN_FA Number(9,3) DECIMAL(8,3) NOT NULL Fin Aid Progress Units Taken
    55 UNT_TAKEN_FA_CL Number(9,3) DECIMAL(8,3) NOT NULL Units Taken FA Calculated
    56 OVRD_UNT_TAKEN_FA Character(1) VARCHAR2(1) NOT NULL Override Unit Taken

    Y/N Table Edit

    57 UNT_PASSD_FA Number(9,3) DECIMAL(8,3) NOT NULL Fin Aid Progress Units Passed
    58 UNT_PASSD_FA_CL Number(9,3) DECIMAL(8,3) NOT NULL Units Passed FA Calculated
    59 OVRD_UNT_PASSD_FA Character(1) VARCHAR2(1) NOT NULL Override Units Passed FA

    Y/N Table Edit

    60 TOT_TAKEN_FA Number(9,3) DECIMAL(8,3) NOT NULL Total Fin Aid Units Taken
    61 TOT_TAKEN_FA_CL Number(9,3) DECIMAL(8,3) NOT NULL Total Units Taken FA Calc
    62 OVRD_TOT_TAKEN_FA Character(1) VARCHAR2(1) NOT NULL Override Total Units Taken FA

    Y/N Table Edit

    63 TOT_PASSD_FA Number(9,3) DECIMAL(8,3) NOT NULL Total Fin Aid Units Passed
    64 TOT_PASSD_FA_CL Number(9,3) DECIMAL(8,3) NOT NULL Total Passed FA Calculated
    65 OVRD_TOT_PASSD_FA Character(1) VARCHAR2(1) NOT NULL Override Total Passed FA

    Y/N Table Edit

    66 REMOTE_UNT_FA Number(9,3) DECIMAL(8,3) NOT NULL Remote Units
    67 TOT_TERM_UNT_FA Number(9,3) DECIMAL(8,3) NOT NULL Total Term Units
    68 TOT_TERM_UNT_FA_CL Number(9,3) DECIMAL(8,3) NOT NULL Total Term Units FA Calculated
    69 OVRD_FA_UNITS Character(1) VARCHAR2(1) NOT NULL Override Financial Aid Units

    Y/N Table Edit

    70 FA_UNIT_WARNING Character(1) VARCHAR2(1) NOT NULL Excluded FA Eligible Term Warn

    Y/N Table Edit

    71 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

    72 FA_LOAD_CL Character(1) VARCHAR2(1) NOT NULL FA Load Calculated
    F=Full-Time
    H=Half-Time
    L=Less 1/2
    N=No Units
    T=Three Quarter Time
    73 OVRD_FA_LOAD Character(1) VARCHAR2(1) NOT NULL Override Financial Aid Load

    Y/N Table Edit

    74 LS_GPA Number(9,3) DECIMAL(8,3) NOT NULL GPA
    75 GPA_CL Number(9,3) DECIMAL(8,3) NOT NULL GPA Calculated
    76 CUM_GPA Number(9,3) DECIMAL(8,3) NOT NULL Cumulative GPA
    77 CUM_GPA_CL Number(9,3) DECIMAL(8,3) NOT NULL Cumulative GPA Calculated
    78 OVRD_CUM_GPA Character(1) VARCHAR2(1) NOT NULL Override Cum GPA

    Y/N Table Edit

    79 OVRD_GPA Character(1) VARCHAR2(1) NOT NULL Override GPA

    Y/N Table Edit

    80 GPA_CALC_IND Character(1) VARCHAR2(1) NOT NULL GPA Computed by Another Proc

    Y/N Table Edit

    81 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
    82 NSLDS_LOAN_YEAR_CL Character(1) VARCHAR2(1) NOT NULL NSLDS Loan Year Calculated
    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
    83 OVRD_NSLDS_LOAN_YR Character(1) VARCHAR2(1) NOT NULL Override NSLDS Loan Year

    Y/N Table Edit

    84 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
    85 DEGR_CONFER_DT Date(10) DATE Confer Date
    86 EXP_GRAD_TERM Character(4) VARCHAR2(4) NOT NULL Expected Graduation Term

    Prompt Table: TERM_TBL

    87 EXP_GRAD_TERM_CL Character(4) VARCHAR2(4) NOT NULL Expected Grad Term Calculated
    88 OVRD_GRAD_TERM Character(1) VARCHAR2(1) NOT NULL Override Grad Term

    Y/N Table Edit

    89 EXP_GRAD_DATE Date(10) DATE Expected Grad Date
    90 EXP_GRAD_DATE_CL Date(10) DATE Expected Grad Date Calculated
    91 OVRD_GRAD_DATE Character(1) VARCHAR2(1) NOT NULL Override Grad Date

    Y/N Table Edit

    92 UNT_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Units Taken Toward GPA
    93 TOT_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Cumulative Units for GPA of Enrollments and Transfer Credits
    94 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
    95 TOT_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Cumulative Grade Points of Enrollment and Transfer Credits
    96 ACAD_STANDING Character(4) VARCHAR2(4) NOT NULL Academic Standing

    Prompt Table: ACAD_STACTN_TBL

    97 ACAD_STANDING_CL Character(4) VARCHAR2(4) NOT NULL Calc Academic Standing

    Prompt Table: ACAD_STACTN_TBL

    98 OVRD_ACAD_STANDING Character(1) VARCHAR2(1) NOT NULL Override Academic Standing

    Y/N Table Edit

    99 FA_STANDING Character(4) VARCHAR2(4) NOT NULL FA Standing

    Prompt Table: ACAD_STACTN_TBL

    100 FA_STANDING_CL Character(4) VARCHAR2(4) NOT NULL FA Standing Calculated

    Prompt Table: ACAD_STACTN_TBL

    101 OVRD_FA_STANDING Character(1) VARCHAR2(1) NOT NULL Override FA Standing

    Y/N Table Edit

    102 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: HOME_CAMPUS_VW

    103 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    104 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    105 STUDY_AGREEMENT Character(10) VARCHAR2(10) NOT NULL Study Agreement

    Prompt Table: STUDY_AGRM_TBL

    106 START_DATE Date(10) DATE Start Date for Gen Standing PO
    107 END_DATE Date(10) DATE End Date
    108 ACAD_GROUP_ADVIS Character(5) VARCHAR2(5) NOT NULL Academic Group of Advisor

    Prompt Table: ACAD_GROUP_TBL

    109 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term

    Prompt Table: TERM_VAL_TBL

    110 PROJ_BILL_UNT Number(3,0) SMALLINT NOT NULL Projected Bill Units
    111 OVRD_BILL_UNITS Character(1) VARCHAR2(1) NOT NULL Override Billing Units

    Y/N Table Edit

    112 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd
    113 SRVC_IND_DTTM DateTime(26) TIMESTAMP Service Indicator Date-Time field
    114 REFUND_PCT Number(6,2) DECIMAL(5,2) NOT NULL Refund Percentage
    115 REFUND_SCHEME Character(8) VARCHAR2(8) NOT NULL Refund Scheme
    116 REFUND_SETID Character(5) VARCHAR2(5) NOT NULL Refund SetID
    117 REFUND_CLASS Character(1) VARCHAR2(1) NOT NULL Refund Classification
    A=Accreditting Agency
    F=Federal
    I=Institutional
    O=Override
    P=Pro-Rata
    S=State
    T=Fee Table
    118 CAMPUS_FA Character(5) VARCHAR2(5) NOT NULL FA Campus

    Prompt Table: HOME_CAMPUS_VW

    119 CAMPUS_REGISTRAR Character(5) VARCHAR2(5) NOT NULL Registrar Campus

    Prompt Table: HOME_CAMPUS_VW

    120 CAMPUS_ADVISEMENT Character(5) VARCHAR2(5) NOT NULL Advisement Campus

    Prompt Table: HOME_CAMPUS_VW

    121 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    122 ADVISOR_ROLE Character(4) VARCHAR2(4) NOT NULL Advisor Role
    ADVR=Advisor
    QEC=Qualifying Exam Committee
    THES=Thesis Committee
    123 ADVISOR_ID Character(11) VARCHAR2(11) NOT NULL This field is used to identify advisors assigned to a student.

    Prompt Table: %EDITTABLE

    124 COMMITTEE_ID Character(6) VARCHAR2(6) NOT NULL Committee

    Prompt Table: COMMITTEE

    125 WEEKS_OF_INSTRUCT Number(2,0) SMALLINT NOT NULL Weeks of Instruction
    126 FA_STATS_CALC_REQ Character(1) VARCHAR2(1) NOT NULL FA Stats Calculation Required

    Y/N Table Edit

    127 FA_NUMBER_OF_WEEKS Number(3,0) SMALLINT NOT NULL FA Number of Weeks
    128 COURSE_LD_PCT Number(6,2) DECIMAL(5,2) NOT NULL Course Load Pct
    129 COST_CODE Character(12) VARCHAR2(12) NOT NULL Canadian Cost Code
    130 OVRD_EXP_DT Date(10) DATE Override Expiration Date
    131 DRIVER_OPTION Character(1) VARCHAR2(1) NOT NULL Driver Creation Option
    B=Both Updates and Projections
    P=Projections Only
    U=Update Only
    132 ONLINE_BATCH_IND Character(1) VARCHAR2(1) NOT NULL Online or Batch Run Indicator
    B=Batch Execution
    O=Online Execution
    133 TERM_SRC Character(1) VARCHAR2(1) NOT NULL Term Source
    A=Admissions
    M=Manual
    N=No Data Found to Build Term
    P=Program(records)
    T=Term (records)
    134 CREATION_DT Date(10) DATE Creation Date
    135 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    136 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    137 UNT_TAKEN_FA_INEL Number(9,3) DECIMAL(8,3) NOT NULL Other FA Taken Units
    138 UNT_PASSD_FA_INEL Number(9,3) DECIMAL(8,3) NOT NULL Other FA Passed Units
    139 UNT_TAKEN_PRG_INEL Number(9,3) DECIMAL(8,3) NOT NULL Ineligible Units Taken Progess
    140 GRADE_POINTS_INEL Number(10,3) DECIMAL(9,3) NOT NULL Other Grade Points
    141 UNT_TAKEN_GPA_INEL Number(9,3) DECIMAL(8,3) NOT NULL Other Units Toward GPA
    142 FA_CAR_TYPE Character(1) VARCHAR2(1) NOT NULL Financial Aid Career Type
    E=Extended Ed
    G=Graduate
    P=Professional
    U=Undergraduate
    143 UNT_TAKEN_FA_NOPIT Number(9,3) DECIMAL(8,3) NOT NULL Unlocked FA Progress Units
    144 LOCK_OVRD_DATE Date(10) DATE Lock Override Date
    145 LOCK_OVRD_OPRID Character(30) VARCHAR2(30) NOT NULL Lock Override User
    146 OVRD_CENSUSDT_LOCK Character(1) VARCHAR2(1) NOT NULL Override Census Date Locking

    Y/N Table Edit

    147 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
    148 TRF_PASSED_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed for GPA
    149 TRF_PASSED_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed Not for GPA
    150 UNT_TEST_CREDIT Number(9,3) DECIMAL(8,3) NOT NULL Units from Test Credit
    151 UNT_OTHER Number(9,3) DECIMAL(8,3) NOT NULL Units from Other Credit
    152 TC_UNITS_ADJUST Number(9,3) DECIMAL(8,3) NOT NULL Transfer Credits Units Adjustment
    153 TOT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Total Transferred
    154 TOT_TEST_CREDIT Number(9,3) DECIMAL(8,3) NOT NULL Total From Test Credit
    155 TOT_OTHER Number(9,3) DECIMAL(8,3) NOT NULL Total from Other Credit
    156 TOT_TC_UNIT_ADJUST Number(9,3) DECIMAL(8,3) NOT NULL Total TC Units Adjustment
    157 FA_EXP_DT_REBUILD Character(1) VARCHAR2(1) NOT NULL Rebuilt After Ovrd Exp Date

    Y/N Table Edit

    158 FA_UNIT_ANTIC Number(9,3) DECIMAL(8,3) NOT NULL Anticipated Units
    159 FA_UNIT_COMPLETED Number(9,3) DECIMAL(8,3) NOT NULL Completed Units
    160 FA_UNIT_IN_PROG Number(9,3) DECIMAL(8,3) NOT NULL In Progress Units
    161 FA_UNIT_CURRENT Number(9,3) DECIMAL(8,3) NOT NULL Current Units
    162 FA_LOAD_CURRENT Character(1) VARCHAR2(1) NOT NULL Current Load

    Prompt Table: FA_LOAD_VW

    163 FA_REBUILD_DT Date(10) DATE Next Date to Rebuild FATerm
    164 ACAD_PLAN_TYPE Character(3) VARCHAR2(3) NOT NULL Academic Plan Type
    CON=Concentration
    COS=Course of Study
    HON=Honors
    MAJ=Major
    MIN=Minor
    PRP=Preparation
    RTC=ROTC
    SP=Specialization
    165 FA_LOAD_CHANGE_IND Character(1) VARCHAR2(1) NOT NULL FATerm Load Changed
    B=Both Loads Changed
    C=Current Load Changed
    F=FA Load Changed
    N=Neither Load Changed
    166 CENSUS_DT Date(10) DATE Census Date
    167 AID_YEAR_CL Character(4) VARCHAR2(4) NOT NULL Calculated Aid Year

    Prompt Table: AID_YEAR_FAT_VW

    168 OVRD_AID_YEAR Character(1) VARCHAR2(1) NOT NULL Override Aid Year

    Y/N Table Edit

    169 FA_OEE_STUDENT Character(1) VARCHAR2(1) NOT NULL Enrolled in OEE Courses

    Y/N Table Edit

    170 DIR_LND_YR_CL Character(2) VARCHAR2(2) NOT NULL Calculated 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
    171 OVRD_DIR_LND_YR Character(1) VARCHAR2(1) NOT NULL Override Direct Lending Year

    Y/N Table Edit