STDNT_FA_TERM

(SQL Table)
Index Back

Student Fin Aid Term Table

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.

  • 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

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

    Default Value: STDNT_AID_SRCH.AID_YEAR

    Prompt Table: AID_YEAR_FAT_VW

    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

    Default Value: Y

    9 WITHDRAW_CODE Character(3) VARCHAR2(3) NOT NULL Withdrawal \ Cancel
    CAN=Cancelled
    NWD=
    WDR=Withdrew

    Default Value: NWD

    10 WITHDRAW_REASON Character(4) VARCHAR2(4) NOT NULL Withdrawal \ Cancel Reason
    MEDI=Medical
    NPAY=Non-Payment of Fees
    RETR=Retroactive
    11 WITHDRAW_DATE Date(10) DATE Withdrawal \ Cancel Date
    12 LAST_DATE_ATTENDED Date(10) DATE Last Date of Attendance
    13 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

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

    Prompt Table: ACAD_CAR_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ACAD_PLAN_TBLVW

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

    Prompt Table: ACAD_PLAN_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ACAD_SUBPLN_TBL

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

    Prompt Table: ACAD_SUBPLN_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: %EDITTABLE

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

    Prompt Table: ACAD_PRGFA_CRVW

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

    Prompt Table: ACAD_PROG_CARVW

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

    Y/N Table Edit

    Default Value: N

    26 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

    Default Value: F

    27 ACAD_LOAD_APPR_CL Character(1) VARCHAR2(1) NOT NULL Acad Load Approved Calculated
    F=Full-Time
    P=Part-Time
    28 OVRD_ACAD_LOAD_AP Character(1) VARCHAR2(1) NOT NULL Override Approved Acad Load

    Y/N Table Edit

    Default Value: N

    29 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

    30 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

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ACAD_LEVEL_TBL

    33 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

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

    Prompt Table: ACAD_LEVEL_TBL

    35 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

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

    Prompt Table: ACAD_LEVEL_TBL

    37 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    42 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

    Default Value: ENRL

    43 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
    44 OVRD_FORM_OF_STUDY Character(1) VARCHAR2(1) NOT NULL Override Form of Study

    Y/N Table Edit

    Default Value: N

    45 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

    Default Value: ACAD_CAR_TBL.TERM_TYPE

    Prompt Table: TERM_TYPE_TBL

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

    Prompt Table: SEL_GROUP_VW

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: STDNT_FA_TERM.ACAD_CAREER

    Prompt Table: ACAD_CAR_TBL

    50 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year

    Default Value: TERM_TBL.ACAD_YEAR

    51 ACAD_YEAR_CL Character(4) VARCHAR2(4) NOT NULL Acad Year Calculated
    52 OVRD_ACAD_YEAR Character(1) VARCHAR2(1) NOT NULL Override Acad Year

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    73 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

    74 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
    75 OVRD_FA_LOAD Character(1) VARCHAR2(1) NOT NULL Override Financial Aid Load

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    83 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
    84 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
    85 OVRD_NSLDS_LOAN_YR Character(1) VARCHAR2(1) NOT NULL Override NSLDS Loan Year

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: TERM_TBL

    89 EXP_GRAD_TERM_CL Character(4) VARCHAR2(4) NOT NULL Expected Grad Term Calculated
    90 OVRD_GRAD_TERM Character(1) VARCHAR2(1) NOT NULL Override Grad Term

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ACAD_STACTN_TBL

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

    Prompt Table: ACAD_STACTN_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ACAD_STACTN_TBL

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

    Prompt Table: ACAD_STACTN_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: HOME_CAMPUS_VW

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

    Prompt Table: EXT_ORG_TBL

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STUDY_AGRM_TBL

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

    Prompt Table: ACAD_GROUP_TBL

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

    Prompt Table: TERM_VAL_TBL

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

    Y/N Table Edit

    114 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd
    115 SRVC_IND_DTTM DateTime(26) TIMESTAMP Service Indicator Date-Time field
    116 REFUND_PCT Number(6,2) DECIMAL(5,2) NOT NULL Refund Percentage
    117 REFUND_SCHEME Character(8) VARCHAR2(8) NOT NULL Refund Scheme
    118 REFUND_SETID Character(5) VARCHAR2(5) NOT NULL Refund SetID
    119 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
    120 CAMPUS_FA Character(5) VARCHAR2(5) NOT NULL FA Campus

    Prompt Table: HOME_CAMPUS_VW

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

    Prompt Table: HOME_CAMPUS_VW

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

    Prompt Table: HOME_CAMPUS_VW

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

    Prompt Table: %EDITTABLE

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

    Prompt Table: COMMITTEE

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

    Y/N Table Edit

    Default Value: N

    129 FA_NUMBER_OF_WEEKS Number(3,0) SMALLINT NOT NULL FA Number of Weeks
    130 COURSE_LD_PCT Number(6,2) DECIMAL(5,2) NOT NULL Course Load Pct
    131 COST_CODE Character(12) VARCHAR2(12) NOT NULL Canadian Cost Code
    132 OVRD_EXP_DT Date(10) DATE Override Expiration Date
    133 DRIVER_OPTION Character(1) VARCHAR2(1) NOT NULL Driver Creation Option
    B=Both Updates and Projections
    P=Projections Only
    U=Update Only
    134 ONLINE_BATCH_IND Character(1) VARCHAR2(1) NOT NULL Online or Batch Run Indicator
    B=Batch Execution
    O=Online Execution
    135 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)

    Default Value: M

    136 CREATION_DT Date(10) DATE Creation Date
    137 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    138 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    139 UNT_TAKEN_FA_INEL Number(9,3) DECIMAL(8,3) NOT NULL Other FA Taken Units
    140 UNT_PASSD_FA_INEL Number(9,3) DECIMAL(8,3) NOT NULL Other FA Passed Units
    141 UNT_TAKEN_PRG_INEL Number(9,3) DECIMAL(8,3) NOT NULL Ineligible Units Taken Progess
    142 GRADE_POINTS_INEL Number(10,3) DECIMAL(9,3) NOT NULL Other Grade Points
    143 UNT_TAKEN_GPA_INEL Number(9,3) DECIMAL(8,3) NOT NULL Other Units Toward GPA
    144 FA_CAR_TYPE Character(1) VARCHAR2(1) NOT NULL Financial Aid Career Type
    E=Extended Ed
    G=Graduate
    P=Professional
    U=Undergraduate
    145 UNT_TAKEN_FA_NOPIT Number(9,3) DECIMAL(8,3) NOT NULL Unlocked FA Progress Units
    146 LOCK_OVRD_DATE Date(10) DATE Lock Override Date
    147 LOCK_OVRD_OPRID Character(30) VARCHAR2(30) NOT NULL Lock Override User
    148 OVRD_CENSUSDT_LOCK Character(1) VARCHAR2(1) NOT NULL Override Census Date Locking

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: FA_LOAD_VW

    165 FA_REBUILD_DT Date(10) DATE Next Date to Rebuild FATerm
    166 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
    167 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
    168 CENSUS_DT Date(10) DATE Census Date
    169 AID_YEAR_CL Character(4) VARCHAR2(4) NOT NULL Calculated Aid Year

    Prompt Table: AID_YEAR_FAT_VW

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

    Y/N Table Edit

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

    Y/N Table Edit

    172 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
    173 OVRD_DIR_LND_YR Character(1) VARCHAR2(1) NOT NULL Override Direct Lending Year

    Y/N Table Edit

    174 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
    175 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
    176 OVRD_ASG_BOT Character(1) VARCHAR2(1) NOT NULL Override HERA Beginning of Trm

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    178 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
    179 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
    180 SFA_ASG_UNITS_BOT Number(9,3) DECIMAL(8,3) NOT NULL Units Beginning of Term
    181 SFA_ASG_UNITS_EOT Number(9,3) DECIMAL(8,3) NOT NULL Units End of Term
    182 SFA_ASG_WI_MTH Character(1) VARCHAR2(1) NOT NULL Weeks of Instruction Method
    C=Credit Based
    E=Exact Accounting
    L=Grade Level Based
    T=Term Based
    183 SFA_ASG_WI_MTH_OVR Character(1) VARCHAR2(1) NOT NULL Override Weeks of Instrct Meth

    Y/N Table Edit

    Default Value: N

    184 SFA_ASG_WI_MTH_CL Character(1) VARCHAR2(1) NOT NULL Calculated Weeks of Inst Meth
    C=Credit Based
    E=Exact Accounting
    L=Grade Level Based
    T=Term Based
    185 SFA_ASG_WI_TRM Number(6,2) DECIMAL(5,2) NOT NULL Weeks of Instruction for Term
    186 SFA_ASG_WI_TRM_OVR Character(1) VARCHAR2(1) NOT NULL Override Term Weeks of Inst

    Y/N Table Edit

    Default Value: N

    187 SFA_ASG_WI_TRM_CL Number(6,2) DECIMAL(5,2) NOT NULL Calculated Term Weeks
    188 SFA_ASG_WI_TCR Number(6,2) DECIMAL(5,2) NOT NULL Transfer Weeks
    189 SFA_ASG_WI_TCR_OVR Character(1) VARCHAR2(1) NOT NULL Override Transfer Weeks

    Y/N Table Edit

    Default Value: N

    190 SFA_ASG_WI_TCR_CL Number(6,2) DECIMAL(5,2) NOT NULL Calculated Weeks of Inst Tr Cr
    191 SFA_ASG_WI_CUM_BOT Number(7,2) DECIMAL(6,2) NOT NULL Beginning of Term
    192 SFA_ASG_WI_CUM_EOT Number(7,2) DECIMAL(6,2) NOT NULL End of Term Cumulative
    193 SFA_ASG_WI_USED Character(1) VARCHAR2(1) NOT NULL New Level Method Used
    194 OVRD_WOI Character(1) VARCHAR2(1) NOT NULL FA Term. Override check box field for WEEKS_OF_INSTRUCT.

    Y/N Table Edit

    Default Value: N

    195 SFA_WKS_OF_INST_CL Number(2,0) SMALLINT NOT NULL FA Term: Calculated values field for WEEKS_OF_INSTRUCT
    196 OVRD_FA_NBR_WEEKS Character(1) VARCHAR2(1) NOT NULL FA Term Number of weeks override check box field for FA_NUMBER_OF_WEEKS

    Y/N Table Edit

    Default Value: N

    197 SFA_FA_NBR_WKS_CL Number(3,0) SMALLINT NOT NULL FA Term, FA Number of Weeks Calculated value field for FA_NUMBER_OF_WEEKS
    198 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code

    Prompt Table: INST_SCHOOL_CDS

    199 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

    Default Value: N

    200 SFA_SULA_UNIT Number(9,3) DECIMAL(8,3) NOT NULL SULA Units field
    201 SFA_SULA_UNIT_CL Number(9,3) DECIMAL(8,3) NOT NULL SULA Units field
    202 OVRD_SULA_UNIT Character(1) VARCHAR2(1) NOT NULL FA Term Number of weeks override check box field for FA_NUMBER_OF_WEEKS

    Y/N Table Edit

    Default Value: N

    203 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
    204 SFA_ENRL_INTENSITY Number(4,2) DECIMAL(3,2) NOT NULL Enrollment Intensity Percent
    205 SFA_CL_ENRL_INTNSY Number(4,2) DECIMAL(3,2) NOT NULL Current Ld Enroll Intensity
    206 OVRD_ENRL_INTNSY Character(1) VARCHAR2(1) NOT NULL Override Enrollment Intensity

    Y/N Table Edit

    207 SFA_ENRL_INTNSY_CL Number(4,2) DECIMAL(3,2) NOT NULL Enrollment Intensity Calculate