| # |
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 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %Date
|
| 3 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 4 |
NSLDS_LOAN_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
NSLDS Loan Seq Nbr
|
| 5 |
NSLDS_LOAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Loan Type
CH=FFEL Consolidated Health Loans
CL=Consolidated Loan
CO=FFEL Consolidated Other Loans
CS=FFEL Consolidated Subsidized
CU=FFEL Consolidated Unsubsidized
D0=Direct Stafford (SULA)
D1=Direct Stafford
D2=Direct Stafford Unsubsidized
D3=Direct Loan Grad Plus
D4=Direct PLUS (Parent)
D5=Direct Unsub Consolidated
D6=Direct Sub Consolidated
D7=Direct PLUS Consolidated
D8=Direct TEACH Loan
D9=Direct Sub Consolidated (SULA)
DU=National Defense (Undergrad)
EU=Expanded Loan Opt (Undergrad)
FI=Federal Insured Stu Ln (FISL)
GB=Graduate PLUS
IC=Income Contingent Loan (ICL)
NU=National Direct (Undergrad)
PL=PLUS (Student)
PU=Federal Perkins
RF=Refinanced
SF=Stafford
SL=Supplemental Loan
SN=FFEL Stafford Non-Subsidized
SU=Stafford Unsubsidized
|
| 6 |
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
|
| 7 |
NSLDS_LOAN_TYPE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan Type Code
D=Default
F=Fraud
N=Not Available
R=Recent
T=Discharged
Default Value: N
|
| 8 |
NSLDS_CHANGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Change Flag
|
| 9 |
NSLDS_STATUS_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Status Code
Prompt Table:
NSLDS_CODE_TBL
|
| 10 |
NSLDS_STAT_DT |
Date(10) |
DATE |
NSLDS Status Effective Dt
|
| 11 |
NSLDS_NET_AMT |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Net Amt Disbursed
|
| 12 |
NSLDS_LOAN_START |
Date(10) |
DATE |
NSLDS Loan Beginning Date
|
| 13 |
NSLDS_LOAN_END |
Date(10) |
DATE |
NSLDS Loan Ending Date
|
| 14 |
NSLDS_SCHOOL_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Original School Code
|
| 15 |
NSLDS_PRIN_BAL |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Principal Balance
|
| 16 |
NSLDS_BAL_DT |
Date(10) |
DATE |
NSLDS Loan Balance Dt
|
| 17 |
NSLDS_CONTACT |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Contact
|
| 18 |
NSLDS_CONTACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
NSLDS Contact Type
DDP=Disability Data Provider
DLS=Direct Loan Servicer
EDR=ED Region
GA=Guarantee Agency
LEN=Lender
LNS=Lender Servicer
N/A=Not Applicable
RDS=U.S. Department of Education
SCH=School
SCS=School Servicer
|
| 19 |
NSLDS_GA_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Guarantee Agency
|
| 20 |
NSLDS_REGION_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Region Code
|
| 21 |
NSLDS_GRADE_LVL |
Character(3) |
VARCHAR2(3) NOT NULL |
NSLDS Grade Level
|
| 22 |
NSLDS_LN_EXUSUB |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan Extra UnSub
B=Both
H=Health Professional
N=Neither
P=PLUS denial
|
| 23 |
NSLDS_LN_CAPINT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan Cap Interest
Y/N Table Edit
|
| 24 |
NSLDS_LN_DISB_DATE |
Date(10) |
DATE |
Date of the last disbursement made to the student for the loan record.
|
| 25 |
NSLDS_LN_DISB_AMT |
Number(6,0) |
INTEGER NOT NULL |
Last loan disbursement amount reported on the NSLDS alert file.
|
| 26 |
NSLDS_LENDER_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Loan Lender Code. May contain a value of N/A if null.
|
| 27 |
NSLDS_SVCR_CD6 |
Character(6) |
VARCHAR2(6) NOT NULL |
Used for the Lender Servicer Code in the NSLDS Loan Detail record.
|
| 28 |
NSLDS_LOAN_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan change flag indicates that a changed loan record is contained in the NSLDS alert file.
Y/N Table Edit
|
| 29 |
NSLDS_AGGR_CL_SUB |
Number(6,0) |
INTEGER NOT NULL |
Subsidized Aggregate Amount
|
| 30 |
NSLDS_AGGR_CL_USB |
Number(6,0) |
INTEGER NOT NULL |
Unsubsidized Aggregate Amt
|
| 31 |
NSLDS_AGGR_CL_CMB |
Number(6,0) |
INTEGER NOT NULL |
Combo Aggregate Amount
|
| 32 |
NSLDS_AGGR_CL_REM |
Number(6,0) |
INTEGER NOT NULL |
Unallocated Aggregate Amt
|
| 33 |
NSLDS_TOT_DISB_AMT |
Number(6,0) |
INTEGER NOT NULL |
Total Disbursement Amount
|
| 34 |
NSLDS_PERK_CN_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Perkins Cancellation Type
DT=Defense Teacher
NA=Not Applicable
PB=Perkins Bankruptcy
PD=Perkins Death
PE=Perkins Early Intervention
PI=Perkins Disability
PL=Perkins Law Enforcement
PM=Perkins Military Service
PN=Perkins Medical Technician
PS=Perkins Subject Matter Area
PT=Perkins Teacher Service
PV=Perkins Volunteer Service
|
| 35 |
NSLDS_LN_APRVD_AMT |
Number(6,0) |
INTEGER NOT NULL |
Guarantee/Approved Amount
|
| 36 |
NSLDS_LN_APRVL_DT |
Date(10) |
DATE |
Guarantee/Approval Date
|
| 37 |
SFA_AWARD_ID |
Character(21) |
VARCHAR2(21) NOT NULL |
Award ID
|
| 38 |
SFA_NSLDS_SULA_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Confirmed SULA Status
L=Lost Subsidy
N=Not Applicable
R=Reinstated Subsidy
|
| 39 |
SFA_NSLDS_SUB_DATE |
Date(10) |
DATE |
Date of the last disbursement made to the student for the loan record.
|
| 40 |
ACAD_YEAR_START |
Date(10) |
DATE |
Academic Year Start Date
|
| 41 |
ACAD_YEAR_END |
Date(10) |
DATE |
Academic Year End Date
|
| 42 |
SFA_NSLDS_REAFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
Reaffirmation Flag
|
| 43 |
SFA_NSLDS_STAT_INT |
Character(6) |
VARCHAR2(6) NOT NULL |
Statutory Interest Rate
|
| 44 |
SFA_NSLDS_ACT_INT |
Character(6) |
VARCHAR2(6) NOT NULL |
Actual Interest Rate
|