| # |
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)
|
| 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
|
| 4 |
ISIR_SEQ_NO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 5 |
ORIG_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Original SSN
|
| 6 |
NAME_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Name Code
|
| 7 |
IWD_TRANS_NBR |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Number
|
| 8 |
NSLDS_TXN_NBR |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Transaction Nbr
|
| 9 |
IWD_NSLDS_DB_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS DB Results Flag
|
| 10 |
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
|
| 11 |
NSLDS_PELL_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
Pell Overpayment Contact
|
| 12 |
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
|
| 13 |
NSLDS_SEOG_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
SEOG Overpayment Contact
|
| 14 |
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
|
| 15 |
NSLDS_PERK_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
Perkins Overpayment Contact
|
| 16 |
NSLDS_DFLT_LOAN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Default Reported
|
| 17 |
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
|
| 18 |
NSLDS_SATIS_RPYMNT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Satisfctry Rpymnt
|
| 19 |
NSLDS_ACTV_BNKRPTC |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Active Bankruptcy
|
| 20 |
NSLDS_AGGR_SUB_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggregate Subsidised OPB
|
| 21 |
NSLDS_AGGR_CMBO_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggr Combined Out Principal
|
| 22 |
NSLDS_AGGR_CNSL_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Unallocate Consolidated OPB
|
| 23 |
NSLDS_PEND_ASUB_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggr Subsidized Pending Disbt
|
| 24 |
NSLDS_AGGR_PCOMBCH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggr Combined Pending Disbt
|
| 25 |
AGGR_SUBSDZD_TOTCH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggregate Subsidized Total
|
| 26 |
NSLDS_AGGR_COMB_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggregate Combined Total
|
| 27 |
NSLDS_AGGR_CONS_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggregate Consolidated Total
|
| 28 |
NSLDS_PERK_CUM_DCH |
Character(6) |
VARCHAR2(6) NOT NULL |
Perkins Cum Disbt Amt
|
| 29 |
NSLDS_PERK_YR_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Perkins CY Disbursement Amt
|
| 30 |
NSLDS_PERK_EXPND |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Perk Expnd Opt
|
| 31 |
NSLDS_PERK_DSBFLG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Perkins Disb Prior 10/01/92
|
| 32 |
NSLDS_DFLT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Default Ln Chg
|
| 33 |
NSLDS_DSCHRGD_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Dschrgd Ln Chg
|
| 34 |
NSLDS_RPYMNT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Satsfctry Rpymnt Chg
|
| 35 |
NSLDS_BNKRPTCY_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Actv Bnkrptcy Chg
|
| 36 |
NSLDS_OVRPYMNT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Overpymnt Chg
|
| 37 |
NSLDS_AGGR_LN_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Aggr Loan Chg
|
| 38 |
NSLDS_PERKINS_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Perkins Chg
|
| 39 |
NSLDS_PELL_PAY_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Pell Pymnt Chg
|
| 40 |
NSLDS_ADDTNL_PELL |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Additional Pell
|
| 41 |
NSLDS_ADDTNL_LOAN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Additional Loans
|
| 42 |
NSLDS_PELL_SEQ_CH |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Pell Seq Num
|
| 43 |
NSLDS_PELL_VER_FLG |
Character(3) |
VARCHAR2(3) NOT NULL |
NSLDS Pell Verif Flag
|
| 44 |
NSLDS_PELLEFC |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Pell EFC
|
| 45 |
NSLDS_PELL_SCHL_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Pell School Cd
|
| 46 |
NSLDS_PELL_TRN_NO |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Pell Transaction Num
|
| 47 |
NSLDS_PELL_LSTUPDT |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Pell Last Update Dt
|
| 48 |
NSLDS_PELLSCHAMT |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Pell Sched Amt
|
| 49 |
NSLDS_PELLAMTPD |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Pell Paid
|
| 50 |
NSLDS_PELLAMTLFT |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Amt Remain
|
| 51 |
NSLDS_PELL_PCTUSD |
Character(7) |
VARCHAR2(7) NOT NULL |
NSLDS Pct Used
|
| 52 |
NSLDS_PELL_SEQ_CH2 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Pell Seq No
|
| 53 |
NSLDS_PELL_VERFLG2 |
Character(3) |
VARCHAR2(3) NOT NULL |
NSLDS Pell Verif Flag
|
| 54 |
NSLDS_PELLEFC2 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS EFC
|
| 55 |
NSLDS_PELL_SCHLCD2 |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Pell School Cd
|
| 56 |
NSLDS_PELL_TRN_NO2 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Pell Trans Nbr
|
| 57 |
NSLDS_PELL_LSTUDT2 |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Pell Last Update Dt
|
| 58 |
NSLDS_PELLSCHAMT2 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Pell Sch Amt
|
| 59 |
NSLDS_PELLAMTPD2 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Pell Paid
|
| 60 |
NSLDS_PELLAMTLFT2 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Amt Remain
|
| 61 |
NSLDS_PELL_PCTUSD2 |
Character(7) |
VARCHAR2(7) NOT NULL |
NSLDS Pct Used
|
| 62 |
NSLDS_PELL_SEQ_CH3 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Pell Seq No
|
| 63 |
NSLDS_PELL_VERFLG3 |
Character(3) |
VARCHAR2(3) NOT NULL |
NSLDS Pell Verification Flg(3)
|
| 64 |
NSLDS_PELLEFC3 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS EFC
|
| 65 |
NSLDS_PELL_SCHLCD3 |
Character(8) |
VARCHAR2(8) NOT NULL |
NSNSLDS PellLDS Pell School Cd
|
| 66 |
NSLDS_PELL_TRN_NO3 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Pell Trans Nbr
|
| 67 |
NSLDS_PELL_LSTUDT3 |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Pell Last Update Dt
|
| 68 |
NSLDS_PELLSCHAMT3 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Pell Sch Amt
|
| 69 |
NSLDS_PELLAMT_PD3 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Pell Paid
|
| 70 |
NSLDS_PELLAMTLFT3 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Amt Remain
|
| 71 |
NSLDS_PELL_PCTUSD3 |
Character(7) |
VARCHAR2(7) NOT NULL |
NSLDS Pct Used
|
| 72 |
NSLDS_POST_SCREEN |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Post-Screening Code
|
| 73 |
NSLDS_AGGR_USUB_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggregate Unsub OPB
|
| 74 |
NSLDS_PNDA_USUB_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggr Unsub Pending Disbt
|
| 75 |
AGGR_USUBDZD_TOTCH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggregate Unsubsidized Total
|
| 76 |
NSLDS_PELLAWD_AMT1 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Pell Award Amount (1)
|
| 77 |
NSLDS_PELLAWD_AMT2 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Pell Award Amount (2)
|
| 78 |
NSLDS_PELLAWD_AMT3 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Pell Award Amount (3)
|
| 79 |
IWD_DL_MPN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
DL Master-Prom Note Flag
|
| 80 |
IWD_FFEL_MPN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
FFEL Master-Prom Note Flag
|
| 81 |
IWD_NSLDS_FFEL_LC |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS FFEL Lender Code
|
| 82 |
NSLDS_POST_SCREEN2 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Post-Screening Code 2
|
| 83 |
NSLDS_POST_SCREEN3 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Post-Screening Code 3
|
| 84 |
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
|
| 85 |
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
|
| 86 |
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
|
| 87 |
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
|
| 88 |
SFA_ACG_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
ACG Overpayment Contact
|
| 89 |
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
|
| 90 |
SFA_NSG_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
NSG Overpayment Contact
|
| 91 |
SFA_ACG_PAY_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
ACG Payment Change
|
| 92 |
SFA_NSG_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS NSG Change
|
| 93 |
SFA_ADDTNL_ACG |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional ACG
|
| 94 |
SFA_ADDTNL_NSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional NSG
|
| 95 |
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
|
| 96 |
SFA_ACG_SEQ_CH1 |
Character(2) |
VARCHAR2(2) NOT NULL |
ACG Sequence Num (1)
|
| 97 |
SFA_ACG_SCHL_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
ACG School Code
|
| 98 |
SFA_ACG_TRN_NBR1 |
Character(2) |
VARCHAR2(2) NOT NULL |
ACG Transaction No (1)
|
| 99 |
SFA_ACG_LSTUPDT1 |
Character(8) |
VARCHAR2(8) NOT NULL |
ACG Last Update Date (1)
|
| 100 |
SFA_ACG_AMT_PD1 |
Character(6) |
VARCHAR2(6) NOT NULL |
ACG Amount Paid (1)
|
| 101 |
SFA_ACG_AWD_AMT1 |
Character(6) |
VARCHAR2(6) NOT NULL |
ACG Award Amount (1)
|
| 102 |
SFA_ACG_SCHLYR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
ACG School Year (1)
|
| 103 |
SFA_ACG_ELIG_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Eligibility Code
01=High School Program
02=AP/IB Courses
03=Rigorous High School Programs
|
| 104 |
SFA_ACG_HS_PGM |
Character(6) |
VARCHAR2(6) NOT NULL |
High School Prog
|
| 105 |
SFA_ACG_SEQCD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
ACG Sequence Code (1)
|
| 106 |
SFA_ACG_SEQ_CH2 |
Character(2) |
VARCHAR2(2) NOT NULL |
ACG Sequence Num (2)
|
| 107 |
SFA_ACG_SCHLCD2 |
Character(8) |
VARCHAR2(8) NOT NULL |
ACG School Code (2)
|
| 108 |
SFA_ACG_TRN_NBR2 |
Character(2) |
VARCHAR2(2) NOT NULL |
ACG Transaction Num (2)
|
| 109 |
SFA_ACG_LSTUPDT2 |
Character(8) |
VARCHAR2(8) NOT NULL |
ACG Last Update Date (2)
|
| 110 |
SFA_ACG_AMT_PD2 |
Character(6) |
VARCHAR2(6) NOT NULL |
ACG Amount Paid (2)
|
| 111 |
SFA_ACG_AWD_AMT2 |
Character(6) |
VARCHAR2(6) NOT NULL |
ACG Award Amount (2)
|
| 112 |
SFA_ACG_SCHLYR2 |
Character(1) |
VARCHAR2(1) NOT NULL |
ACG School Year (2)
|
| 113 |
SFA_ACG_ELIG_CD2 |
Character(2) |
VARCHAR2(2) NOT NULL |
ACG Eligibility Code(2)
01=High School Program
02=AP/IB Courses
03=Rigorous High School Programs
|
| 114 |
SFA_ACG_HS_PGM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
ACG High School Prog Code (2)
|
| 115 |
SFA_ACG_SEQCD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
ACG Sequence Code (2)
|
| 116 |
SFA_ACG_SEQ_CH3 |
Character(2) |
VARCHAR2(2) NOT NULL |
ACG Sequence Num (3)
|
| 117 |
SFA_ACG_SCHLCD3 |
Character(8) |
VARCHAR2(8) NOT NULL |
ACG School Code (3)
|
| 118 |
SFA_ACG_TRN_NBR3 |
Character(2) |
VARCHAR2(2) NOT NULL |
ACG Transaction Num (3)
|
| 119 |
SFA_ACG_LSTUPDT3 |
Character(8) |
VARCHAR2(8) NOT NULL |
ACG Last Update Date (3)
|
| 120 |
SFA_ACG_AMT_PD3 |
Character(6) |
VARCHAR2(6) NOT NULL |
ACG Amount Paid (3)
|
| 121 |
SFA_ACG_AWD_AMT3 |
Character(6) |
VARCHAR2(6) NOT NULL |
ACG Award Amount (3)
|
| 122 |
SFA_ACG_SCHLYR3 |
Character(1) |
VARCHAR2(1) NOT NULL |
ACG School Year (3)
|
| 123 |
SFA_ACG_ELIG_CD3 |
Character(2) |
VARCHAR2(2) NOT NULL |
ACG Eligibility Code (3)
01=High School Program
02=AP/IB Courses
03=Rigorous High School Programs
|
| 124 |
SFA_ACG_HS_PGM3 |
Character(6) |
VARCHAR2(6) NOT NULL |
ACG High School Prog Code (3)
|
| 125 |
SFA_ACG_SEQCD3 |
Character(3) |
VARCHAR2(3) NOT NULL |
ACG Sequence Code (3)
|
| 126 |
SFA_NSG_SEQ_CH1 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSG Sequence Num (1)
|
| 127 |
SFA_NSG_SCHL_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
NSG School Code
|
| 128 |
SFA_NSG_TRN_NBR1 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSG Transaction Num (1)
|
| 129 |
SFA_NSG_LSTUPDT1 |
Character(8) |
VARCHAR2(8) NOT NULL |
NSG Last Update Date (1)
|
| 130 |
SFA_NSG_AMT_PD1 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSG Amount Paid (1)
|
| 131 |
SFA_NSG_AWDAMT1 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSG Award Amount (1)
|
| 132 |
SFA_NSG_SCHLYR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
NSG School Year (1)
|
| 133 |
SFA_NSG_INSTPG1 |
Character(7) |
VARCHAR2(7) NOT NULL |
NSG Instruct Program Code (1)
|
| 134 |
SFA_NSG_SEQCD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
NSG Sequence Code (1)
|
| 135 |
SFA_NSG_SEQ_CH2 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSG Sequence Num (2)
|
| 136 |
SFA_NSG_SCHLCD2 |
Character(8) |
VARCHAR2(8) NOT NULL |
NSG School Code (2)
|
| 137 |
SFA_NSG_TRN_NBR2 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSG Transaction Num (2)
|
| 138 |
SFA_NSG_LSTUPDT2 |
Character(8) |
VARCHAR2(8) NOT NULL |
NSG Last Update Date (2)
|
| 139 |
SFA_NSG_AMT_PD2 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSG Amount Paid (2)
|
| 140 |
SFA_NSG_AWDAMT2 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSG Award Amount (2)
|
| 141 |
SFA_NSG_SCHLYR2 |
Character(1) |
VARCHAR2(1) NOT NULL |
NSG School Year (2)
|
| 142 |
SFA_NSG_INSTPG2 |
Character(7) |
VARCHAR2(7) NOT NULL |
NSG Instruct Program Code (2)
|
| 143 |
SFA_NSG_SEQCD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
NSG Sequence Code (2)
|
| 144 |
SFA_NSG_SEQ_CH3 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSG Sequence Num (3)
|
| 145 |
SFA_NSG_SCHLCD3 |
Character(8) |
VARCHAR2(8) NOT NULL |
NSG School Code (3)
|
| 146 |
SFA_NSG_TRN_NBR3 |
Character(2) |
VARCHAR2(2) NOT NULL |
NSG Transaction Num (3)
|
| 147 |
SFA_NSG_LSTUPDT3 |
Character(8) |
VARCHAR2(8) NOT NULL |
NSG Last Update Date (3)
|
| 148 |
SFA_NSG_AMT_PD3 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSG Amount Paid (3)
|
| 149 |
SFA_NSG_AWDAMT3 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSG Award Amount (3)
|
| 150 |
SFA_NSG_SCHLYR3 |
Character(1) |
VARCHAR2(1) NOT NULL |
NSG School Year (3)
|
| 151 |
SFA_NSG_INSTPG3 |
Character(7) |
VARCHAR2(7) NOT NULL |
NSG Instruct Program Code (3)
|
| 152 |
SFA_NSG_SEQCD3 |
Character(3) |
VARCHAR2(3) NOT NULL |
NSG Sequence Code (3)
|
| 153 |
SFA_FRAUD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Fraud Flag
|
| 154 |
SFA_NSLDS_FRDLN_CH |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Fraud Loan Chg
|
| 155 |
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
|
| 156 |
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
|
| 157 |
SFA_ACG_SCH_AMT1 |
Character(6) |
VARCHAR2(6) NOT NULL |
ACG Scheduled Award Amount (1)
|
| 158 |
SFA_ACG_AWD_PTUSD1 |
Character(7) |
VARCHAR2(7) NOT NULL |
ACG Pct Elig Sched Award (1)
|
| 159 |
SFA_ACG_AWD_YR1 |
Character(4) |
VARCHAR2(4) NOT NULL |
ACG Award Year (1)
|
| 160 |
SFA_ACG_LVL_PTUSD1 |
Character(7) |
VARCHAR2(7) NOT NULL |
ACG Total Elig Acad Yr Lvl (1)
|
| 161 |
SFA_ACG_SCH_AMT2 |
Character(6) |
VARCHAR2(6) NOT NULL |
ACG Scheduled Award Amount (2)
|
| 162 |
SFA_ACG_AWD_PTUSD2 |
Character(7) |
VARCHAR2(7) NOT NULL |
ACG Pct Elig Sched Award (2)
|
| 163 |
SFA_ACG_AWD_YR2 |
Character(4) |
VARCHAR2(4) NOT NULL |
ACG Award Year (2)
|
| 164 |
SFA_ACG_LVL_PTUSD2 |
Character(7) |
VARCHAR2(7) NOT NULL |
ACG Total Elig Acad Yr Lvl (2)
|
| 165 |
SFA_ACG_SCH_AMT3 |
Character(6) |
VARCHAR2(6) NOT NULL |
ACG Scheduled Award Amount (3)
|
| 166 |
SFA_ACG_AWD_PTUSD3 |
Character(7) |
VARCHAR2(7) NOT NULL |
ACG Pct Elig Sched Award (3)
|
| 167 |
SFA_ACG_AWD_YR3 |
Character(4) |
VARCHAR2(4) NOT NULL |
ACG Award Year (3)
|
| 168 |
SFA_ACG_LVL_PTUSD3 |
Character(7) |
VARCHAR2(7) NOT NULL |
ACG Total Elig Acad Yr Lvl (3)
|
| 169 |
SFA_NSG_SCH_AMT1 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSG Scheduled Award Amount (1)
|
| 170 |
SFA_NSG_AWD_PTUSD1 |
Character(7) |
VARCHAR2(7) NOT NULL |
NSG Pct Elig Sched Award (1)
|
| 171 |
SFA_NSG_AWD_YR1 |
Character(4) |
VARCHAR2(4) NOT NULL |
NSG Award Year (1)
|
| 172 |
SFA_NSG_LVL_PTUSD1 |
Character(7) |
VARCHAR2(7) NOT NULL |
NSG Total Elig Acad Yr Lvl (1)
|
| 173 |
SFA_NSG_SCH_AMT2 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSG Scheduled Award Amount (2)
|
| 174 |
SFA_NSG_AWD_PTUSD2 |
Character(7) |
VARCHAR2(7) NOT NULL |
NSG Pct Elig Sched Award (2)
|
| 175 |
SFA_NSG_AWD_YR2 |
Character(4) |
VARCHAR2(4) NOT NULL |
NSG Award Year (2)
|
| 176 |
SFA_NSG_LVL_PTUSD2 |
Character(7) |
VARCHAR2(7) NOT NULL |
NSG Total Elig Acad Yr Lvl (2)
|
| 177 |
SFA_NSG_SCH_AMT3 |
Character(6) |
VARCHAR2(6) NOT NULL |
NSG Scheduled Award Amount (3)
|
| 178 |
SFA_NSG_AWD_PTUSD3 |
Character(7) |
VARCHAR2(7) NOT NULL |
NSG Pct Elig Sched Award (3)
|
| 179 |
SFA_NSG_AWD_YR3 |
Character(4) |
VARCHAR2(4) NOT NULL |
NSG Award Year (3)
|
| 180 |
SFA_NSG_LVL_PTUSD3 |
Character(7) |
VARCHAR2(7) NOT NULL |
NSG Total Elig Acad Yr Lvl (3)
|
| 181 |
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
|
| 182 |
SFA_TCH_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
TEACH Overpayment Contact
|
| 183 |
SFA_TCH_LN_CNV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Grant Loan Conv
1=Yes
2=No
|
| 184 |
SFA_TCH_LNCNV_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS TEACH Grant to Loan Chg
|
| 185 |
SFA_TCH_GRNT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Grant Change Flag
|
| 186 |
SFA_TCH_ADD_GRANT |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional TEACH Grant
1=Yes
2=No
|
| 187 |
SFA_TCH_LN_BALANCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Loan Principal Balance
|
| 188 |
SFA_TCH_LOAN_TOTAL |
Character(6) |
VARCHAR2(6) NOT NULL |
Loan Total
|
| 189 |
SFA_TCH_UGRD_AMNT |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Disbursement Amount
|
| 190 |
SFA_TCH_GRAD_AMNT |
Character(6) |
VARCHAR2(6) NOT NULL |
Graduate Disbursement Amount
|
| 191 |
SFA_TCH_SEQ_CH1 |
Character(2) |
VARCHAR2(2) NOT NULL |
TEACH Sequence Num (1)
|
| 192 |
SFA_TCH_SCHL_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
TEACH School Code
|
| 193 |
SFA_TCH_TRN_NBR1 |
Character(2) |
VARCHAR2(2) NOT NULL |
TEACH Transaction Num (1)
|
| 194 |
SFA_TCH_LSTUPDT1 |
Character(8) |
VARCHAR2(8) NOT NULL |
TEACH Last Update Date (1)
|
| 195 |
SFA_TCH_SCH_AMT1 |
Character(6) |
VARCHAR2(6) NOT NULL |
TEACH Sched Award Amount (1)
|
| 196 |
SFA_TCH_AMT_PD1 |
Character(6) |
VARCHAR2(6) NOT NULL |
TEACH Amount Paid (1)
|
| 197 |
SFA_TCH_AWD_AMT1 |
Character(6) |
VARCHAR2(6) NOT NULL |
TEACH Award Amount (1)
|
| 198 |
SFA_TCH_SCHLYR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Academic Year Level (1)
|
| 199 |
SFA_TCH_SEQCD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
TEACH COD Sequence Code (1)
|
| 200 |
SFA_TCH_AWD_YR1 |
Character(4) |
VARCHAR2(4) NOT NULL |
TEACH Award Year (1)
|
| 201 |
SFA_TCH_LOAN_CNV1 |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Loan Conversion (1)
|
| 202 |
SFA_TCH_SEQ_CH2 |
Character(2) |
VARCHAR2(2) NOT NULL |
TEACH Sequence Num (2)
|
| 203 |
SFA_TCH_SCHL_CD2 |
Character(8) |
VARCHAR2(8) NOT NULL |
TEACH School Code (2)
|
| 204 |
SFA_TCH_TRN_NBR2 |
Character(2) |
VARCHAR2(2) NOT NULL |
TEACH Transaction Num (2)
|
| 205 |
SFA_TCH_LSTUPDT2 |
Character(8) |
VARCHAR2(8) NOT NULL |
TEACH Last Update Date (2)
|
| 206 |
SFA_TCH_SCH_AMT2 |
Character(6) |
VARCHAR2(6) NOT NULL |
TEACH Sched Award Amount (2)
|
| 207 |
SFA_TCH_AMT_PD2 |
Character(6) |
VARCHAR2(6) NOT NULL |
TEACH Amount Paid (2)
|
| 208 |
SFA_TCH_AWD_AMT2 |
Character(6) |
VARCHAR2(6) NOT NULL |
TEACH Award Amount (2)
|
| 209 |
SFA_TCH_SCHLYR2 |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Academic Year Level (2)
|
| 210 |
SFA_TCH_SEQCD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
TEACH COD Sequence Code (2)
|
| 211 |
SFA_TCH_AWD_YR2 |
Character(4) |
VARCHAR2(4) NOT NULL |
TEACH Award Year (2)
|
| 212 |
SFA_TCH_LOAN_CNV2 |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Loan Conversion (2)
|
| 213 |
SFA_TCH_SEQ_CH3 |
Character(2) |
VARCHAR2(2) NOT NULL |
TEACH Sequence Num (3)
|
| 214 |
SFA_TCH_SCHL_CD3 |
Character(8) |
VARCHAR2(8) NOT NULL |
TEACH School Code (3)
|
| 215 |
SFA_TCH_TRN_NBR3 |
Character(2) |
VARCHAR2(2) NOT NULL |
TEACH Transaction Num (3)
|
| 216 |
SFA_TCH_LSTUPDT3 |
Character(8) |
VARCHAR2(8) NOT NULL |
TEACH Last Update Date (3)
|
| 217 |
SFA_TCH_SCH_AMT3 |
Character(6) |
VARCHAR2(6) NOT NULL |
TEACH Schdul Award Amount (3)
|
| 218 |
SFA_TCH_AMT_PD3 |
Character(6) |
VARCHAR2(6) NOT NULL |
TEACH Amount Paid (3)
|
| 219 |
SFA_TCH_AWD_AMT3 |
Character(6) |
VARCHAR2(6) NOT NULL |
TEACH Award Amount (3)
|
| 220 |
SFA_TCH_SCHLYR3 |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Academic Year Level (3)
|
| 221 |
SFA_TCH_SEQCD3 |
Character(3) |
VARCHAR2(3) NOT NULL |
TEACH COD Sequence Code (3)
|
| 222 |
SFA_TCH_AWD_YR3 |
Character(4) |
VARCHAR2(4) NOT NULL |
TEACH Award Year (3)
|
| 223 |
SFA_TCH_LOAN_CNV3 |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Loan Conversion (3)
|
| 224 |
SFA_NSLDS_ADD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Elig Indicator
|
| 225 |
SFA_NSLDS_ADD_IND2 |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Addl Elig Indicator (2)
|
| 226 |
SFA_NSLDS_ADD_IND3 |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Addl Elig Indicator (3)
|
| 227 |
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
|
| 228 |
SFA_IASG_CNTCT |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS IASA Overpayment Contact
|
| 229 |
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
|
| 230 |
SFA_LIFETIME_ELIG |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Lifetime Eligibility Used
|
| 231 |
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
|
| 232 |
SFA_NSLDS_USE_LMT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Sub Usage Limit Applies
N=No
Y=Yes
|
| 233 |
SFA_NSLDS_LOANELIG |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Subsidized Usage Period
|
| 234 |
SFA_TCH_DISCH_CD1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Added new field for 2324
|
| 235 |
SFA_TCH_DISCH_AMT1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Added new field for 2324
|
| 236 |
SFA_TCH_ADJ_DISB1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Added new field for 2324
|
| 237 |
SFA_TCH_DISCH_CD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Added new field for 2324
|
| 238 |
SFA_TCH_DISCH_AMT2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Added new field for 2324
|
| 239 |
SFA_TCH_ADJ_DISB2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Added new field for 2324
|
| 240 |
SFA_TCH_DISCH_CD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Added new field for 2324
|
| 241 |
SFA_TCH_DISCH_AMT3 |
Character(6) |
VARCHAR2(6) NOT NULL |
Added new field for 2324
|
| 242 |
SFA_TCH_ADJ_DISB3 |
Character(6) |
VARCHAR2(6) NOT NULL |
Added new field for 2324
|