| # |
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_UPDT_TXN |
Number(4,0) |
SMALLINT NOT NULL |
NSLDS Transaction Number
|
| 5 |
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
|
| 6 |
TRANS_PROCESS_DT |
Date(10) |
DATE |
Transaction Process Date
|
| 7 |
NSLDS_AGGR_SUBSDZD |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Aggregate Subsidized
|
| 8 |
PENDING_AGGR_SUB |
Number(6,0) |
INTEGER NOT NULL |
Subsidized Pending Disburse
|
| 9 |
NSLDS_AGGR_UNSUB |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Aggregate Unsubsidized
|
| 10 |
PENDING_AGGR_UNSUB |
Number(6,0) |
INTEGER NOT NULL |
Unsub Pending Disbursement
|
| 11 |
NSLDS_AGGR_COMB |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Aggregate Combined
|
| 12 |
PENDING_AGGR_COMB |
Number(6,0) |
INTEGER NOT NULL |
Combined Pending Disbursement
|
| 13 |
NSLDS_AGGR_CNSLDTD |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Aggregate Consolidated
|
| 14 |
PENDING_AGGR_CONSL |
Number(6,0) |
INTEGER NOT NULL |
Consol Pending Disbursement
|
| 15 |
AGGR_SUBSDZD_TOTAL |
Number(6,0) |
INTEGER NOT NULL |
Total Aggregate Subsidized
|
| 16 |
AGGR_UNSUB_TOTAL |
Number(6,0) |
INTEGER NOT NULL |
Aggregate Unsub Total
|
| 17 |
AGGR_COMB_TOTAL |
Number(6,0) |
INTEGER NOT NULL |
Aggregate Combined Total
|
| 18 |
AGGR_CONSL_TOTAL |
Number(6,0) |
INTEGER NOT NULL |
Aggregate Consolidated Total
|
| 19 |
NSLDS_AGGR_PERKINS |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Aggregate Perkins
|
| 20 |
NSLDS_YTD_PERKINS |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Perkins YTD
|
| 21 |
NSLDS_ACTV_BNKRPTC |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Active Bankruptcy
Y/N Table Edit
|
| 22 |
NSLDS_PERK_DSBFLG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Perkins Disb Prior 10/01/92
Y/N Table Edit
|
| 23 |
NSLDS_PERK_EXPND |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Perk Expnd Opt
Y/N Table Edit
|
| 24 |
NSLDS_SATIS_RPYMNT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Satisfctry Rpymnt
Y/N Table Edit
|
| 25 |
NSLDS_DFLT_LOAN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Default Reported
Y/N Table Edit
|
| 26 |
NSLDS_DSCHRGD_LOAN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Discharged Rptd
C=Conditional
D=Death
M=Multiple
N=None
P=Permanent
R=Reaffirmed
Y=Yes
|
| 27 |
NSLDS_DFLT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Default Ln Chg
|
| 28 |
NSLDS_DSCHRGD_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Dschrgd Ln Chg
|
| 29 |
NSLDS_RPYMNT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Satsfctry Rpymnt Chg
|
| 30 |
NSLDS_BNKRPTCY_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Actv Bnkrptcy Chg
|
| 31 |
NSLDS_OVRPYMNT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Overpymnt Chg
|
| 32 |
NSLDS_AGGR_LN_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Aggr Loan Chg
|
| 33 |
NSLDS_PERKINS_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Perkins Chg
|
| 34 |
NSLDS_PELL_PAY_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Pell Pymnt Chg
|
| 35 |
NSLDS_ADDTNL_PELL |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Additional Pell
Y/N Table Edit
|
| 36 |
NSLDS_ADDTNL_LOAN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Additional Loans
Y/N Table Edit
|
| 37 |
NSLDS_ACTIVE_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Active Match
0=Successful Match
1=School/Servicer not found
2=Match - No Loans
3=Match - No Loans/Pell
6=SSN not found
7=SSN OK, not DOB/Name
|
| 38 |
NSLDS_ERR_CD_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Error Code 1
1=SSN Must not be spaces
|
| 39 |
NSLDS_ERR_CD_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Error Code 2
2=Name cannot be spaces
|
| 40 |
NSLDS_ERR_CD_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Error Code 3
3=Invalid Date of Birth
|
| 41 |
NSLDS_ERR_CD_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Error Code 4
4=School Year must be numeric
5=School Yr > Current Yr
6=School Yr length > 4
|
| 42 |
NSLDS_ISIR_YEAR |
Character(2) |
VARCHAR2(2) NOT NULL |
Source ISIR that last updated the NSLDS Aggregate data.
|
| 43 |
NSLDS_DL_MPN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
DL Staff Master-Prom Note Flag
A=Active
C=Closed
I=Inactive
N=No MPN on file
U=Unavailable
|
| 44 |
NSLDS_FFEL_MPN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
FFEL Master-Prom Note Flag
A=Active
C=Closed
I=Inactive
N=No MPN on file
U=Unavailable
|
| 45 |
NSLDS_FFEL_LNDR_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS FFEL Lender Code
|
| 46 |
NSLDS_PELL_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Pell change flag indicates that a changed Pell Grant record is contained in the NSLDS alert file.
Y/N Table Edit
|
| 47 |
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
|
| 48 |
NSLDS_AGGR_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Aggregate change flag indicates that new aggregate information is contained in the NSLDS alert file.
Y/N Table Edit
|
| 49 |
NSLDS_PLUS_MPN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
DL Plus Master-Prom Note Flag
A=Active
C=Closed
E=Inactive,Endorsed
I=Inactive
N=No MPN on file
U=Unavailable
|
| 50 |
NSLDS_SUB_EXCEEDED |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Sub Limit Exceeded
Y/N Table Edit
|
| 51 |
NSLDS_CMB_EXCEEDED |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Combo Limit Exceeded
Y/N Table Edit
|
| 52 |
ISIR_SUB_LIMIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
ISIR Sub Limit Flag
C=Close to Limit
E=Exceeded Limit
N=No Problem
R=Exceeded Limit/Reaffirmed Debt
|
| 53 |
ISIR_CMB_LIMIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
ISIR Combo Limit Flag
C=Close to Limit
E=Exceeded Limit
N=No Problem
R=Exceeded Limit/Reaffirmed Debt
|
| 54 |
NSLDS_AG_CON_U_OPB |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Aggr Cons Unallocated
|
| 55 |
NSLDS_AGGR_PLUS |
Number(6,0) |
INTEGER NOT NULL |
PLUS Outstanding Balance
|
| 56 |
NSLDS_AG_CON_U_TOT |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Constd Total Unallocated
|
| 57 |
NSLDS_PLUS_TOTAL |
Number(6,0) |
INTEGER NOT NULL |
PLUS Total
|
| 58 |
SFA_ACG_PAY_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
ACG Payment Change
|
| 59 |
SFA_NSG_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS NSG Change
|
| 60 |
SFA_ADDTNL_ACG |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional ACG
Y/N Table Edit
|
| 61 |
SFA_ADDTNL_NSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional NSG
Y/N Table Edit
|
| 62 |
SFA_GPLUS_MPNFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
DL GradPlus MPN Flag
A=Active
C=Closed
E=Inactive,Endorsed
I=Inactive
N=No Master
U=Unavailable
|
| 63 |
SFA_FRAUD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Fraud Flag
|
| 64 |
SFA_AGGR_GPLUS |
Number(6,0) |
INTEGER NOT NULL |
Grad PLUS Outstanding Balance
|
| 65 |
SFA_GPLUS_TOTAL |
Number(6,0) |
INTEGER NOT NULL |
Grad PLUS Total
|
| 66 |
SFA_NSLDS_FRDLN_CH |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Fraud Loan Chg
|
| 67 |
SFA_NSLDS_UGSUB_LN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS UG Sub Loan Limit
C=Close to Limit
E=Exceeded Limit
N=No Problem
R=Exceeded Limit/Reaffirmed Debt
|
| 68 |
SFA_NSLDS_UGCMB_LN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS UG Combo Loan Limit
C=Close to Limit
E=Exceeded Limit
N=No Problem
R=Exceeded Limit/Reaffirmed Debt
|
| 69 |
SFA_TCH_LN_CNV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Grant Loan Conv
1=Yes
2=No
|
| 70 |
SFA_TCH_LNCNV_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS TEACH Grant to Loan Chg
|
| 71 |
SFA_TCH_GRNT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Grant Change Flag
|
| 72 |
SFA_TCH_ADD_GRANT |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional TEACH Grant
1=Yes
2=No
|
| 73 |
SFA_TCH_LOAN_BAL |
Number(6,0) |
INTEGER NOT NULL |
TEACH Loan Principal Balance
|
| 74 |
SFA_TCH_LOAN_TOT |
Number(6,0) |
INTEGER NOT NULL |
TEACH Loan Total
|
| 75 |
SFA_TCH_UGRD_AMT |
Number(6,0) |
INTEGER NOT NULL |
UG Disbursement Amount
|
| 76 |
SFA_TCH_GRAD_AMT |
Number(6,0) |
INTEGER NOT NULL |
TEACH Graduate Disburse Amount
|
| 77 |
SFA_TCH_UG_PCTUSD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
UGRD Percent Elig Used
|
| 78 |
SFA_TCH_UG_RM_AMT |
Number(6,0) |
INTEGER NOT NULL |
UGRD Remaining Amt
|
| 79 |
SFA_TCH_GRD_PCTUSD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
GRAD Percent Elig Used
|
| 80 |
SFA_TCH_GRD_RM_AMT |
Number(6,0) |
INTEGER NOT NULL |
GRAD Remaining Amt
|
| 81 |
SFA_TCH_AGGR_GR_CH |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS TEACH Grant Aggr Chg
|
| 82 |
SFA_TCH_AGGR_LN_CH |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS TEACH Loan Aggr Chg
|
| 83 |
SFA_UG_AGR_SUB_OPB |
Number(6,0) |
INTEGER NOT NULL |
Principal Balance
|
| 84 |
SFA_UG_AGR_USUB_OP |
Number(6,0) |
INTEGER NOT NULL |
UG Aggregate Unsubsidized
|
| 85 |
SFA_UG_AGR_CMB_OPB |
Number(6,0) |
INTEGER NOT NULL |
UG Aggregate Combined
|
| 86 |
SFA_UG_AGR_CNSL_OP |
Number(6,0) |
INTEGER NOT NULL |
UG Aggregate Consolidated
|
| 87 |
SFA_UG_AGR_SUB_PND |
Number(6,0) |
INTEGER NOT NULL |
UG Subsidized Pending Disburse
|
| 88 |
SFA_UG_AGR_USUB_PN |
Number(6,0) |
INTEGER NOT NULL |
UG Unsub Pending Disbursement
|
| 89 |
SFA_UG_AGR_CMB_PND |
Number(6,0) |
INTEGER NOT NULL |
UG Combined Pending Disb
|
| 90 |
SFA_UG_AGGR_SUB |
Number(6,0) |
INTEGER NOT NULL |
UG Total Aggregate Subsidized
|
| 91 |
SFA_UG_AGGR_USUB |
Number(6,0) |
INTEGER NOT NULL |
UG Aggregate Unsub Total
|
| 92 |
SFA_UG_AGGR_CMB |
Number(6,0) |
INTEGER NOT NULL |
UG Aggregate Combined Total
|
| 93 |
SFA_UG_AGGR_CNSL |
Number(6,0) |
INTEGER NOT NULL |
UG Aggregate Consolidated
|
| 94 |
SFA_UG_AWARD_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
UG Award Year
|
| 95 |
SFA_UG_DEP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
UG Dependency Indicator
D=Dependent
I=Independent
|
| 96 |
SFA_GR_AGR_SUB_OPB |
Number(6,0) |
INTEGER NOT NULL |
Principal Balance
|
| 97 |
SFA_GR_AGR_USUB_OP |
Number(6,0) |
INTEGER NOT NULL |
Grad Aggregate Unsubsidized
|
| 98 |
SFA_GR_AGR_CMB_OPB |
Number(6,0) |
INTEGER NOT NULL |
Grad Aggregate Combined
|
| 99 |
SFA_GR_AGR_CNSL_OP |
Number(6,0) |
INTEGER NOT NULL |
Grad Aggregate Consolidated
|
| 100 |
SFA_GR_AGR_SUB_PND |
Number(6,0) |
INTEGER NOT NULL |
Grad Subsidized Pending Disb
|
| 101 |
SFA_GR_AGR_USUB_PN |
Number(6,0) |
INTEGER NOT NULL |
Grad Unsub Pending Disb
|
| 102 |
SFA_GR_AGR_CMB_PND |
Number(6,0) |
INTEGER NOT NULL |
Grad Combined Pending Disb
|
| 103 |
SFA_GR_AGGR_SUB |
Number(6,0) |
INTEGER NOT NULL |
Grad Total Aggregate Subsidize
|
| 104 |
SFA_GR_AGGR_USUB |
Number(6,0) |
INTEGER NOT NULL |
Grad Aggregate Unsub Total
|
| 105 |
SFA_GR_AGGR_CMB |
Number(6,0) |
INTEGER NOT NULL |
Grad Aggregate Combined Total
|
| 106 |
SFA_GR_AGGR_CNSL |
Number(6,0) |
INTEGER NOT NULL |
Grad Aggregate Consolidated
|
| 107 |
SFA_GR_AWARD_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
Graduate Award Year
|
| 108 |
SFA_GR_DEP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Grad Dependency Indicator
D=Dependent
I=Independent
|
| 109 |
SFA_LIFETIME_ELIG |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Lifetime Eligibility Used
|
| 110 |
SFA_NSLDS_PELL_LMT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Pell Lifetime Limit
C=Close to Pell Limit
E=Met or Exceeded Pell Limit
H=High Pell Percent
N=No Problem
|
| 111 |
SFA_NSLDS_ENRL_PTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Unusual Enrollment Pattern Flg
1=Federal Student Aid Use Only
2=Possible Enrollment Problem
3=Questionable Enroll Pattern
N=No Unusual Enroll Pattern
|
| 112 |
SFA_NSLDS_USE_LMT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Sub Usage Limit Applies
N=No
Y=Yes
|
| 113 |
SFA_NSLDS_LN_ELIG |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Subsidized Usage Period
|
| 114 |
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.
|
| 115 |
SFA_LIFETIME_IASG |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Lifetime Eligibility Used
|
| 116 |
SFA_NSLDS_IASG_LMT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS IASG Lifetime Limit
C=Close to Pell Limit
E=Met or Exceeded Pell Limit
H=High Pell Percent
N=No Problem
|
| 117 |
NSLDS_IASG_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS IASG change flag
|