| # |
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 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 3 |
NSLDS_PELL_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Pell Overpayment
D=Deferred
F=Fraud
N=No
S=Satisfactory Arrangement
W=Waived
Y=Yes
|
| 4 |
NSLDS_PELL_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
Pell Overpayment Contact
|
| 5 |
NSLDS_SEOG_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS SEOG Overpayment
D=Deferred
F=Fraud
N=No
S=Satisfactory Arrangement
W=Waived
Y=Yes
|
| 6 |
NSLDS_SEOG_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
SEOG Overpayment Contact
|
| 7 |
NSLDS_PERK_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Perkins Overpayment
D=Deferred
F=Fraud
N=No
S=Satisfactory Arrangement
W=Waived
Y=Yes
|
| 8 |
NSLDS_PERK_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
Perkins Overpayment Contact
|
| 9 |
PELL_REPAID_DT |
Date(10) |
DATE |
Pell Overpayment Repaid Dt
|
| 10 |
SEOG_REPAID_DT |
Date(10) |
DATE |
SEOG Overpayment Repaid Dt
|
| 11 |
PERK_REPAID_DT |
Date(10) |
DATE |
Perkins Ovrpaymnt Repaid Dt
|
| 12 |
PERKINS_SCHOOL1 |
Character(8) |
VARCHAR2(8) NOT NULL |
Perkins School 1
|
| 13 |
PERKINS_SCHOOL2 |
Character(8) |
VARCHAR2(8) NOT NULL |
Perkins School 2
|
| 14 |
PERKINS_SCHOOL3 |
Character(8) |
VARCHAR2(8) NOT NULL |
Perkins School 3
|
| 15 |
CPS_SCHOOL_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
CPS School Code. Also known as Title IV School Code
|
| 16 |
INSTIT_OE_BR |
Character(2) |
VARCHAR2(2) NOT NULL |
Institution OE Branch
|
| 17 |
NSLDS_DOB |
Date(10) |
DATE |
NSLDS Date of Birth
|
| 18 |
CURRENT_SCHOOL |
Character(8) |
VARCHAR2(8) NOT NULL |
Current School
|
| 19 |
NSLDS_ENR_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Enrollment Status
A=Approved Leave of Absence
D=Deceased
F=Full Time
G=Graduated
H=Half Time +
L=Less than Half Time
N=Not Available
W=Withdrawn
|
| 20 |
ENR_STAT_DT |
Date(10) |
DATE |
Enrollment Status Date
|
| 21 |
NSLDS_LOAN_DEFAULT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan Default
Y/N Table Edit
Default Value: N
|
| 22 |
NSLDS_UPDT_TXN |
Number(4,0) |
SMALLINT NOT NULL |
NSLDS Transaction Number
|
| 23 |
NSLDS_UPDT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Transaction Source
A=NSLDS Alert File
F=Financial Aid Transcript
H=NSLDS FA History File
I=ISIR
M=Manual
|
| 24 |
NSLDS_POST_SCREEN |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Post-Screening Code
|
| 25 |
LAST_UPDATED |
Date(10) |
DATE |
Last Updated
|
| 26 |
LAST_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Last Effseq
|
| 27 |
NSLDS_POST_SCREEN2 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Post-Screening Code 2
|
| 28 |
NSLDS_POST_SCREEN3 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Post-Screening Code 3
|
| 29 |
SFA_ACG_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
ACG Overpayment
D=Deferred
F=Fraud
N=N/A
N=N/A
S=Satisfactory Arrangement
W=Waived
Y=Overpayment
|
| 30 |
SFA_ACG_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
ACG Overpayment Contact
|
| 31 |
SFA_NSG_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS NSG Overpayment
D=Deferred
F=Fraud
N=N/A
S=Satisfactory Arrangement
W=Waived
Y=Overpayment
|
| 32 |
SFA_NSG_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
NSG Overpayment Contact
|
| 33 |
SFA_TCH_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Overpayment
D=Deferred
F=Fraud
N=N/A
S=Satisfactory Payment
W=Waived
Y=Overpayment
|
| 34 |
SFA_TCH_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
TEACH Overpayment Contact
|
| 35 |
SFA_IASG_OVRPYMN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS IASA Overpayment
D=Deferred
F=Fraud
N=N/A
S=Satisfactory payment
W=Waived
Y=Overpayment
|
| 36 |
SFA_IASG_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS IASA Overpayment Contact
|
| 37 |
NSLDS_ALERT_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
NSLDS alert file sequence number is incremented if more than one alert file is created on the same day.
|