STDNT_FA_TERM(SQL Table) |
Index Back |
---|---|
Student Fin Aid Term TableThis 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. |
# | 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 |