| # |
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
|