| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
STDNT_AID_SRCH
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 3 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table:
AID_YEAR_TBL
|
| 4 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
TERM_VAL_TBL
|
| 5 |
PROCESSING_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to store the mode of processing, batch or online, for Student Budgets.
B=Batch Mode
O=Online Mode
|
| 6 |
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
|
| 7 |
ACAD_PROG_PRIMARY |
Character(5) |
VARCHAR2(5) NOT NULL |
Primary Academic Program
Prompt Table:
ACAD_PRGFA_CRVW
|
| 8 |
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
|
| 9 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table:
ACAD_PLAN_TBL
|
| 10 |
ACAD_SUB_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Sub-Plan
Prompt Table:
ACAD_SUBPLAN_VW
|
| 11 |
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
|
| 12 |
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
|
| 13 |
ACAD_LEVEL_PROJ |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level - Projected
Prompt Table:
XL_ACAD_LVL_VW
|
| 14 |
ACAD_LEVEL_BOT |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level - Term Start
Prompt Table:
XL_ACAD_LVL_VW
|
| 15 |
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
|
| 16 |
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
|
| 17 |
RESIDENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Residency
Prompt Table:
RESIDENCY_TBL
|
| 18 |
FIN_AID_FED_RES |
Character(5) |
VARCHAR2(5) NOT NULL |
Fin Aid Federal Residency
Prompt Table:
RESIDENCY_TBL
|
| 19 |
FIN_AID_ST_RES |
Character(5) |
VARCHAR2(5) NOT NULL |
Fin Aid State Residency
Prompt Table:
RESIDENCY_TBL
|
| 20 |
FIN_AID_FED_EXCPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Fin Aid Fed Residency Excpt
Prompt Table:
RESID_EXCPT_TBL
|
| 21 |
FIN_AID_ST_EXCPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Fin Aid St Residency Excpt
Prompt Table:
RESID_EXCPT_TBL
|
| 22 |
STATE_RESIDENCE |
Character(6) |
VARCHAR2(6) NOT NULL |
State of Residence
Prompt Table:
HCR_ST_NM_VW_I
|
| 23 |
APP_STATE_RESIDENC |
Character(2) |
VARCHAR2(2) NOT NULL |
Application State Residence
Prompt Table:
HCR_ST_NM_VW_I
|
| 24 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 25 |
HOUSING_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Projected Housing Type
1=On Campus Housing
2=With Parent
2=Off Campus Housing
3=Off Campus
3=Parent's Home
4=Relative's Home
|
| 26 |
MARITAL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
1=Single
2=Married
3=Separated
4=Divorced
5=Widowed
|
| 27 |
NUMBER_IN_FAMILY |
Character(2) |
VARCHAR2(2) NOT NULL |
Nbr Family Members
|
| 28 |
DEPNDNCY_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependency Status
1=Independent
2=Dependent
3=Indepenedent/Pro Judgmnt
D=Dependent
I=Independent
X=Dependent Reject
Y=Independent Reject
Z=Provisional Independent
|
| 29 |
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
|
| 30 |
BUDGET_GROUP_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Budget Group Code
Prompt Table:
BUD_GRP_VW
|
| 31 |
PRORATE_BUDGET |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Budget
|
| 32 |
BUDGET_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
S=Selected
|
| 33 |
CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
Prompt Table:
CAMPUS_TBL
|
| 34 |
CAMPUS_FA |
Character(5) |
VARCHAR2(5) NOT NULL |
FA Campus
Prompt Table:
CAMPUS_TBL
|
| 35 |
UNT_TAKEN_FA |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Fin Aid Progress Units Taken
|
| 36 |
UNT_TAKEN_FA_CL |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Units Taken FA Calculated
|
| 37 |
INTERESTED_IN_PLUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Interested In PLUS
1=Yes
2=No
|
| 38 |
INTERESTED_IN_SL |
Character(1) |
VARCHAR2(1) NOT NULL |
Interested In Student Loans
1=Yes
2=No
|
| 39 |
ENROLL_CURNT_SUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Current Sumr
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 40 |
ENROLL_FALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Fall
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 41 |
ENROLL_NEXT_SUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Next Sumr
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 42 |
ENROLL_SPRING |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Spring
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 43 |
ENROLL_WINTER |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Winter
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 44 |
SRVC_IND_DTTM |
DateTime(26) |
TIMESTAMP |
Service Indicator Date-Time field
|
| 45 |
SRVC_IND_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Service Indicator Cd
Prompt Table:
SRVC_IND_CD_TBL
|
| 46 |
REFUND_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Refund Percentage
|
| 47 |
REFUND_SCHEME |
Character(8) |
VARCHAR2(8) NOT NULL |
Refund Scheme
Prompt Table:
ADJ_RFND_SCM_VW
|
| 48 |
REFUND_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Refund SetID
Prompt Table:
SETID_TBL
|
| 49 |
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
|
| 50 |
ADVISOR_ROLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Advisor Role
ADVR=Advisor
QEC=Qualifying Exam Committee
THES=Thesis Committee
|
| 51 |
ADVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
This field is used to identify advisors assigned to a student.
Prompt Table:
INSTR_ADVSR_VW
|
| 52 |
COMMITTEE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Committee
Prompt Table:
COMMITTEE_TBL
|
| 53 |
WEEKS_OF_INSTRUCT |
Number(2,0) |
SMALLINT NOT NULL |
Weeks of Instruction
|
| 54 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 55 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 56 |
STUDY_AGREEMENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Study Agreement
Prompt Table:
STUDY_AGRM_TBL
|
| 57 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_TBL
|
| 58 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 59 |
ACAD_GROUP_ADVIS |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Group of Advisor
Prompt Table:
ACAD_GROUP_TBL
|
| 60 |
ADMIT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Admit Term
Prompt Table:
TERM_VAL_TBL
|
| 61 |
STDNT_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Student Group
Prompt Table:
STDNT_GROUP_TBL
|
| 62 |
SPORT1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Sport 1
BA=Baseball
BB=Basketball
CC=Cross Country
CR=Crew
FB=Football
GO=Golf
GY=Gymnastics
IT=Indoor Track
NO=None
OT=Outdoor Track
SB=Softball
SO=Soccer
SW=Swimming
TH=Tennis
TR=Track
UN=Unknown
VB=Volleyball
WP=Water Polo
WR=Wrestling
|
| 63 |
SPORT2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Sport 2
BA=Baseball
BB=Basketball
CC=Cross Country
CR=Crew
FB=Football
GO=Golf
GY=Gymnastics
IT=Indoor Track
NO=None
OT=Outdoor Track
SB=Softball
SO=Soccer
SW=Swimming
TN=Tennis
TR=Track
UN=Unknown
VB=Vollyball
WP=Water Polo
WR=Wrestling
|
| 64 |
SPORT3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Sport 3
BA=Baseball
BB=Basketball
CC=Cross Country
CR=Crew
FB=Football
GO=Golf
GY=Gymnastics
IT=Indoor Track
NO=None
OT=Outdoor Track
SB=Softball
SO=Soccer
SW=Swimming
TN=Tennis
TR=Track
UN=Unknown
VB=Vollyball
WP=Water Polo
WR=Wrestling
|
| 65 |
SPORT4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Sport4
BA=Baseball
BB=Basketball
CC=Cross Country
CR=Crew
FB=Football
GO=Golf
GY=Gymnastics
IT=Indoor Track
NO=None
OT=Outdoor Track
SB=Softball
SO=Soccer
SW=Swimming
TN=Tennis
TR=Track
UN=Unknown
VB=Vollyball
WP=Water Polo
WR=Wrestling
|
| 66 |
ATHL_PARTIC_CD1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Ath Partic Cd 1
Prompt Table:
ATHL_PART_TBL
|
| 67 |
ATHL_PARTIC_CD2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Ath Partic CD 2
Prompt Table:
ATHL_PART_TBL
|
| 68 |
ATHL_PARTIC_CD3 |
Character(5) |
VARCHAR2(5) NOT NULL |
Ath Partic CD 3
Prompt Table:
ATHL_PART_TBL
|
| 69 |
ATHL_PARTIC_CD4 |
Character(5) |
VARCHAR2(5) NOT NULL |
Athl Partic 4
Prompt Table:
ATHL_PART_TBL
|
| 70 |
CUR_PARTICIPANT1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Cur partic 1
Prompt Table:
HCR_XL_PSYSNO_I
|
| 71 |
CUR_PARTICIPANT2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Cur Partic 2
Prompt Table:
HCR_XL_PSYSNO_I
|
| 72 |
CUR_PARTICIPANT3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Cur Partic 3
Prompt Table:
HCR_XL_PSYSNO_I
|
| 73 |
CUR_PARTICIPANT4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Cur Partic 4
Prompt Table:
HCR_XL_PSYSNO_I
|
| 74 |
FA_NUMBER_OF_WEEKS |
Number(3,0) |
SMALLINT NOT NULL |
FA Number of Weeks
|
| 75 |
COURSE_LD_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Course Load Pct
|
| 76 |
FA_UNIT_ANTIC |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Anticipated Units
|
| 77 |
FA_UNIT_COMPLETED |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Completed Units
|
| 78 |
FA_UNIT_IN_PROG |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
In Progress Units
|
| 79 |
FA_UNIT_CURRENT |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Current Units
|
| 80 |
FA_LOAD_CURRENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Load
|
| 81 |
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
|
| 82 |
FA_TERM_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 83 |
FA_TERM_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 84 |
ISIR_STU_ENRL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enrollment Status
1=Full Time
2=Three Quarter Time
3=Half Time
4=Less than Half Time
5=Don't Know
|
| 85 |
SFA_INTRSTD_IN_WSL |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Study or Student Loans
1=Work Study
2=Student Loans
3=Both
4=Neither
5=Don't Know
|
| 86 |
INTERESTED_IN_WS |
Character(1) |
VARCHAR2(1) NOT NULL |
Interested In Work-Study
1=Yes
2=No
3=Don't Know
|