| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
Default Value: SHFATEOP
|
| 2 |
ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 3 |
ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
Default Value: I
|
| 4 |
NSLDS_HEADER_NBR |
Number(3,0) |
SMALLINT NOT NULL |
NSLDS Header Nbr
|
| 5 |
NSLDS_REC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Record Type Ind
|
| 6 |
NSLDS_DTL_NBR |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Detail Nbr
|
| 7 |
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
|
| 8 |
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
|
| 9 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 10 |
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
|
| 11 |
NSLDS_STATUS_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Status Code
Prompt Table:
NSLDS_CODE_TBL
|
| 12 |
NSLDS_STAT_DT |
Date(10) |
DATE |
NSLDS Status Effective Dt
|
| 13 |
NSLDS_NET_AMT |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Net Amt Disbursed
|
| 14 |
NSLDS_LOAN_START_O |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Loan Beginning Dt
|
| 15 |
NSLDS_LOAN_END_O |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Loan Ending Dt
|
| 16 |
NSLDS_SCHOOL_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Original School Code
|
| 17 |
NSLDS_PRIN_BAL_O |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Principal Balance
|
| 18 |
NSLDS_BAL_DT_O |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Balance Dt
|
| 19 |
NSLDS_CONTACT |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Contact
|
| 20 |
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
|
| 21 |
NSLDS_GA_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Guarantee Agency
|
| 22 |
NSLDS_LN_EXUSUB_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan Extra UnSub (1)
|
| 23 |
NSLDS_LN_CAPINT_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan Cap Interest (1)
|
| 24 |
NSLDS_LN_DISB_DT_O |
Character(8) |
VARCHAR2(8) NOT NULL |
Date of the last disbursement made to the student for the loan record. May contain the value 'N/A'.
|
| 25 |
NSLDS_LN_DISB_AMTO |
Character(6) |
VARCHAR2(6) NOT NULL |
Last loan disbursement amount report on the NSLDS alert file. May contain the value 'N/A'.
|
| 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_AG_CL_SUB_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Subsidized Aggregate Amt
|
| 30 |
NSLDS_AG_CL_USB_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Unsubsidized Aggregate Amt
|
| 31 |
NSLDS_AG_CL_CMB_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Combo Aggregate Amt
|
| 32 |
NSLDS_AG_CL_REM_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Unallocated Aggregate Amt
|
| 33 |
NSLDS_TOT_DISB_CH |
Character(6) |
VARCHAR2(6) 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_APVD_AMTO |
Character(6) |
VARCHAR2(6) NOT NULL |
Guarantee/Approved Amount
|
| 36 |
NSLDS_LN_APRVL_DTO |
Character(8) |
VARCHAR2(8) NOT NULL |
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_DT_1 |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Subsidy Status Date (1)
|
| 40 |
SFA_NSLDS_ACAD_BGN |
Character(8) |
VARCHAR2(8) NOT NULL |
Academic Year Begin Date
|
| 41 |
SFA_NSLDS_ACAD_END |
Character(8) |
VARCHAR2(8) NOT NULL |
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
|