FAN_FA_TERM_VW

(SQL View)
 Index Back

Student Fin Aid Term View

This table contains student information by Institution and Term. The primary use of this table is to provide a consolidated view of student term data for Financial Aid processing purposes. This record is created from Stdnt_Car_Term, if student is continuing; otherwise it is created from Adm_Appl_Prog. This is a view of this table used for Fin Aid Award Notification Letter equation selection processing.

SELECT A.EMPLID ,A.INSTITUTION ,A.STRM ,A.EFF_STATUS ,A.AID_YEAR ,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 ,A.SFA_ASG_AC_LVL_BOT ,A.SFA_ASG_AC_LVL_EOT ,A.OVRD_ASG_BOT ,A.OVRD_ASG_EOT ,A.SFA_ASG_AC_LVL_BCL ,A.SFA_ASG_AC_LVL_ECL FROM PS_STDNT_FA_TERM A WHERE 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 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: AID_YEAR_FAT_VW

    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

    172 SFA_ASG_AC_LVL_BOT Character(1) VARCHAR2(1) NOT NULL Academic Level - Term Start
    0=1st Year - Never Attended
    1=1st Year - Previously Attended
    2=2nd Year
    3=3rd Year
    4=4th Year
    5=5th Year
    173 SFA_ASG_AC_LVL_EOT Character(1) VARCHAR2(1) NOT NULL Academic Level - Term End
    0=1st Year - Never Attended
    1=1st Year - Previously Attended
    2=2nd Year
    3=3rd Year
    4=4th Year
    5=5th Year
    174 OVRD_ASG_BOT Character(1) VARCHAR2(1) NOT NULL Override HERA Beginning of Trm

    Y/N Table Edit

    Default Value: N

    175 OVRD_ASG_EOT Character(1) VARCHAR2(1) NOT NULL Override HERA End of Term

    Y/N Table Edit

    Default Value: N

    176 SFA_ASG_AC_LVL_BCL Character(1) VARCHAR2(1) NOT NULL Calculated ASG Start Acad Lvl
    0=1st Year - Never Attended
    1=1st Year - Previously Attended
    2=2nd Year
    3=3rd Year
    4=4th Year
    5=5th Year
    177 SFA_ASG_AC_LVL_ECL Character(1) VARCHAR2(1) NOT NULL Calculated ASG End Acad Lvl
    0=1st Year - Never Attended
    1=1st Year - Previously Attended
    2=2nd Year
    3=3rd Year
    4=4th Year
    5=5th Year