| # |
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: FA_INSTITUTN_VW.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 3 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
STUDENT_AID
|
| 4 |
TABLE_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Child Table Key
Default Value: 1
|
| 5 |
PROCESSING_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Aid Package Processing Status
0=No Electronic Application
1=Applied
2=Ready For Counselor Review
3=Ready for Packaging
4=Repackage
9=Packaging Completed
Default Value: 0
|
| 6 |
VERIFICATON_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
ED Verification Status
C=ED Verification Complete
N=Not Required
P=Verification Pending
R=Required to be Performed
Default Value: N
|
| 7 |
SFA_REVIEW_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Status
C=Review Complete
I=Incomplete
Default Value: I
|
| 8 |
SCHOLARSHIP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Scholarship Status
E=Evaluated
N=Not Evaluated
Default Value: N
|
| 9 |
PACKAGING_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Aid Packaging Method
0=Not Packaged
5=Auto Packaged
9=Counselor Packaged
Default Value: 0
|
| 10 |
PKG_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Packaging Plan ID
Prompt Table:
PKG_PLAN_TBL
|
| 11 |
SAT_ACADEMIC_PRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used on Packaging Status Summary to note current Satisfactory Academic Progress status.
A=Academic Plan
N=Not Meeting Satis Acad Prgrs
P=Probation
U=SAP Undetermined
W=Warning
Y=Meeting Satis Acad Progress
Default Value: U
|
| 12 |
DISBURSEMENT_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Disbursement Hold
F=Hold Federal Aid
I=Hold Institutional Aid
L=Hold All Loans
|
| 13 |
COUNSELOR |
Character(11) |
VARCHAR2(11) NOT NULL |
Counselor
Prompt Table:
PEOPLE_SRCH
|
| 14 |
COMMUNITY_SERVICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Community Service Indicator
1=Community Service Placement
2=Not Community Service
Default Value: 2
|
| 15 |
QA_VERF_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Inst Verification Status
1=Non Select
2=Selected for Verification
3=Document Select
Default Value: 1
|
| 16 |
QA_SELECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
QA Sample
1=Not Selected as QA Sample
2=Selected as QA Sample
Default Value: 1
|
| 17 |
AID_APP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Aid Application Status
A=Application Active for All Aid
C=Application Canceled
R=Apply for Restricted Aid Only
Default Value: A
|
| 18 |
VERIF_STATUS_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
ED Verification Status Cd
A=Accurate Data
B=Blank
C=Calculated
N=Not Selected
R=Reprocessed
S=Selected, Not Verified
T=Tolerance
V=Verified
W=Without Documentation
Default Value: N
|
| 19 |
PELL_PROCESS_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Pell Processing Status
A=Accepted By ED
G=Repackaged
L=Selected
N=Not Sent
P=Pending
R=Reported to ED
S=Ready to Send
V=Review
|
| 20 |
ED_RECORD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
ED Record Status
A=Accepted w/ Assumptions
D=Duplicate
E=Error
I=Accepted
R=Rejected
|
| 21 |
ED_LEVEL_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Education Level
|
| 22 |
PELL_EFFDT |
Date(10) |
DATE |
Effective Date
Prompt Table:
PELL_INFO_VW3
|
| 23 |
PELL_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
Prompt Table:
PELL_INFO_VW4
|
| 24 |
PELL_TRANS_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Transaction Num
Prompt Table:
PELL_INFO_VW2
|
| 25 |
USE_SECONDARY_EFC |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Secondary EFC
Y/N Table Edit
Default Value: N
|
| 26 |
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:
AID_YEAR_CAREER
|
| 27 |
PAR_CREDIT_WORTHY |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent Credit Worthiness
I=Institutional Override
Y/N Table Edit
|
| 28 |
TITLEIV_ELIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Title IV Fund Eligibility
I=Institutional Override
Y/N Table Edit
|
| 29 |
SS_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Selective Service Match
I=Institutional Override
L=Record Returned Late
N=Regist Status Not Confirmed
T=Temporarily Exempt
Y=Registration Status Confirmed
Z=Record Mismatch
|
| 30 |
SS_REGISTRATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Selective Service Registration
I=Institutional Override
L=Record Returned Late
N=Registration not completed
T=Temporarily Exempt
Y=Registration Confirmed
Z=Record Mismatch
|
| 31 |
INS_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
INS Match
D=Duplicate case
I=Invalid ARN
L=Record Returned Late
N=Citizenship Not Confirmed
Y=Citizenship Confirmed
Z=Record Mismatch
|
| 32 |
SSN_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
SSN Match
0=Record Returned Late
1=No Match
2=SSN and Name, no DOB
3=SSN Only, No Name
4=SSN, Name, and DOB Match
5=All match Date of Death
6=SSN not verified
8=Record Not Sent to SSA
9=Record Mismatch
I=Institutional Override
|
| 33 |
VA_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Veteran Status Match Flag
1=Veteran status confirmed
2=Record found on VA db not Qual
3=Record not found on VA db
4=Active Duty
8=Record not sent to VA
|
| 34 |
NSLDS_LOAN_DEFAULT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan Default
|
| 35 |
SSA_CITIZENSHP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
SSA Citizenship Indicator
*=Foreign born
A=U.S. Citizen
B=Legal Alien, work eligible
C=Legal Alien, work ineligible
D=Other
E=Alien/student restrc/wk elig
F=Alien, conditionally legal
I=Institutional Override
N=No Match on Name or DOB
|
| 36 |
NSLDS_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Match
0=Init of Flag or Late
1=Eligible for Title IV aid
2=Default
3=Overpayment
4=Default and Overpayment
5=Eligible Partial Title IV Aid
7=Match, but no data
8=Transaction Not Sent
9=Mismatch
|
| 37 |
DL_HEAL_LN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
HEAL Eligible
Y/N Table Edit
Default Value: N
|
| 38 |
DRUG_OFFENSE_CONV |
Character(1) |
VARCHAR2(1) NOT NULL |
Drug Offense Conviction
1=Eligible
2=Partially Eligible
3=Ineligible or Don't know
I=Institutional Override
|
| 39 |
PRISONER_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Prisoner Match
0=Not sent to SSA/Not a Prisoner
1=Prisoner in Local Facility
2=In State or Federal Facility
8=Not sent for match
I=Institutional Override
|
| 40 |
LN_INTERVW_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Entrance Interview Status
C=Complete
I=Institution Required
P=Pending Resolution
|
| 41 |
LN_EXIT_INTER_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Exit Interview Status
C=Complete
I=Insitution Required
P=Pending Resolution
|
| 42 |
SSN_MATCH_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
SSN Match Override
Y/N Table Edit
Default Value: N
|
| 43 |
SSA_CITIZEN_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
SSA Citizen Override
Y/N Table Edit
Default Value: N
|
| 44 |
INS_MATCH_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
INS Match Override
Y/N Table Edit
Default Value: N
|
| 45 |
VA_MATCH_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
VA Match Override
Y/N Table Edit
Default Value: N
|
| 46 |
SS_MATCH_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
SS Match Override
Y/N Table Edit
Default Value: N
|
| 47 |
SS_REGISTER_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
SS Register Override
Y/N Table Edit
Default Value: N
|
| 48 |
NSLDS_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Override
Y/N Table Edit
Default Value: N
|
| 49 |
PRISONER_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Prisoner Override
Y/N Table Edit
Default Value: N
|
| 50 |
DRUG_OFFENSE_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Drug Offense Override
Y/N Table Edit
Default Value: N
|
| 51 |
ISIR_SEC_INS_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Sec INS Match Flag
C=Not yet confirmed by INS
N=Citizenship Not Confirmed
P=Pending Confirmation
X=Not enough info to confirm
Y=Citizenship Confirmed
|
| 52 |
PKG_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Last Updated
|
| 53 |
FA_SS_AWD_SECURITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Self Service Awarding Access
A=Allow Access
F=Use Filter Options
N=Deny Access
Default Value: N
|
| 54 |
FA_SS_INQ_SECURITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Self-Service Inquiry Access
N=Deny Access
Y=Allow Access
Y/N Table Edit
Default Value: Y
|
| 55 |
FA_SS_FAN_SECURITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Self-Serv On-line FAN Access
N=Deny Access
Y=Allow Access
Y/N Table Edit
Default Value: N
|
| 56 |
FATHER_SSN_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Father's SSN Match
1=No Match
2=SSN and Name, no DOB
3=SSN Only, No Name
4=SSN, Name, and DOB Match
5=All match Date of Death
6=SSN not verified
8=Record Not Sent to SSA
I=Institutional Override
|
| 57 |
MOTHER_SSN_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Mother's SSN Match
1=No Match
2=SSN and Name, no DOB
3=SSN Only, No Name
4=SSN, Name, and DOB Match
5=All match Date of Death
6=SSN not verified
8=Record Not Sent to SSA
I=Institutional Override
|
| 58 |
PAR_SSN_MATCH_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Parents SSN Match Override
Y/N Table Edit
Default Value: N
|
| 59 |
SFA_AGGR_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
FA-Aggregate Source for Packaging
D=FA Installation Default
N=NSLDS Total
P=PS Aggregates
Default Value: D
|
| 60 |
SFA_AGGR_SRC_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
FA-Aggregate Source Used by Packaging
N=NSLDS Total
P=PS Aggregates
|
| 61 |
SFA_PKG_DEP_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
FA-Aggregates: Dependency Status used during Award Packaging
D=Dependent
I=Independent
M=Married
S=Sole Support
|
| 62 |
SFA_RPKG_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Repackaging Plan ID
Prompt Table:
SFA_RPKG_PLAN
|
| 63 |
SFA_EASS_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Student-level access control to external award self service.
N=Deny
Y=Allow
Y/N Table Edit
Default Value: N
|
| 64 |
SFA_PP_CRSEWRK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
PreProfessional Coursewrk
|
| 65 |
SFA_DOD_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Dept of Defense Match
Y=SSN included in DOD file
|
| 66 |
SFA_DOD_MATCH_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
DOD Match Override
Default Value: N
|
| 67 |
SFA_SPL_CIRCUM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Circumstances Flag
1=Dep w/o Parent Data
2=Parent Data Corrected
3=Unaccompanied Homeless
4=Dep Unsub Loan Only
Y/N Table Edit
|
| 68 |
SFA_SS_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Group
Prompt Table:
SFA_SS_SETUP
|
| 69 |
SFA_LPG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Limited Pell Grant Indicator
Y/N Table Edit
Default Value: N
|
| 70 |
SFA_FGN_INC_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
2425: Foreign Income
N=No
Y=Yes
|
| 71 |
SFA_UNACCYTH_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Unaccompanied Youth
N=No
Y=Yes
|
| 72 |
SFA_FGN_MATCH_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
2425: Foreign Income Override
Y/N Table Edit
|
| 73 |
SFA_YTH_MATCH_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
2425:Unaccompanied Youth Override
Y/N Table Edit
|
| 74 |
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
|