| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 3 |
SCC_VOC_MSG_SEQ |
Number(15,0) |
DECIMAL(15) NOT NULL |
Vocado message sequence number
|
| 4 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 5 |
SCC_SFP_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 |
SCC_SFP_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 8 |
SCC_SFP_FIRST_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Student's First Name
|
| 9 |
SCC_SFP_LAST_NAME |
Character(16) |
VARCHAR2(16) NOT NULL |
Student's Last name
|
| 10 |
SCC_SFP_BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 11 |
SCC_SFP_SCHOOL_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
CPS School Code. Also known as Title IV School Code
|
| 12 |
SCC_SFP_DFLT_LOAN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Default Reported
|
| 13 |
SCC_SFP_DSCHRGD_LN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Discharged Rptd
|
| 14 |
SCC_SFP_SATIS_RPAY |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Satisfctry Rpymnt
|
| 15 |
SCC_SFP_ACTV_BNKRP |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Active Bankruptcy
|
| 16 |
SCC_SFP_AGGR_SUB_O |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Aggregate Subsidized
|
| 17 |
SCC_SFP_AGGR_UNSUB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Aggregate Unsubsidized
|
| 18 |
SCC_SFP_AGGR_CMBO |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Aggr Combined Out Principal
|
| 19 |
SCC_SFP_PEND_SUB_O |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Pending Aggr Sub
|
| 20 |
SCC_SFP_PEND_UNSUB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Pending Aggr Unsub
|
| 21 |
SCC_SFP_PEND_CMBO |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Aggr Combined Pending Disbt
|
| 22 |
SCC_SFP_A_SUB_TOT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Tot Aggr Sub
|
| 23 |
SCC_SFP_A_UNSUBTOT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Tot Aggr Unsub
|
| 24 |
SCC_SFP_A_CMBO_TOT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Aggregate Combined Total
|
| 25 |
SCC_SFP_AGGR_PERK |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Aggregate Perkins
|
| 26 |
SCC_SFP_YTD_PERK_O |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Year-to-Date Perkins
|
| 27 |
SCC_SFP_DL_MPN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
DL Master-Prom Note Flag
|
| 28 |
SCC_SFP_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.
|
| 29 |
SCC_SFP_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.
|
| 30 |
SCC_SFP_AGGR_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Aggregate change flag indicates that new aggregate information is contained in the NSLDS alert file.
|
| 31 |
SCC_SFP_FIRST_NM_I |
Character(12) |
VARCHAR2(12) NOT NULL |
The student's first name that was submitted to NSLDS either through the Inform file or through the NSLDS web page. This name may not match the name in the school database.
|
| 32 |
SCC_SFP_LAST_NM_I |
Character(35) |
VARCHAR2(35) NOT NULL |
The student's last name that was submitted to NSLDS either through the Inform file or through the NSLDS web page. This name may not match the name in the school database.
|
| 33 |
SCC_SFP_DOB_INFORM |
Date(10) |
DATE |
The student's date of birth that was submitted to NSLDS either through the Inform file or through the NSLDS web page. This DOB may not match the DOB in the school database.
|
| 34 |
SCC_SFP_PLUS_MPN |
Character(1) |
VARCHAR2(1) NOT NULL |
DL Plus Master-Prom Note Flag
|
| 35 |
SCC_SFP_SUB_EXCEED |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Sub Limit Exceeded
|
| 36 |
SCC_SFP_CMB_EXCEED |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Combo Limit Exceeded
|
| 37 |
SCC_SFP_AG_CU_OPB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Aggr Cons Unallocated
|
| 38 |
SCC_SFP_AGGR_PLUS |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Aggregate PLUS
|
| 39 |
SCC_SFP_AG_CU_TOT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Constd Total Unallocated
|
| 40 |
SCC_SFP_AG_PLUS_TO |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Aggregate PLUSTotal
|
| 41 |
SCC_SFP_ACG_PAY_CH |
Character(1) |
VARCHAR2(1) NOT NULL |
ACG Payment Change
|
| 42 |
SCC_SFP_NSG_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS NSG Change
|
| 43 |
SCC_SFP_GPLUS_MPN |
Character(1) |
VARCHAR2(1) NOT NULL |
DL GradPlus MPN Flag
|
| 44 |
SCC_SFP_FRAUD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Fraud Flag
|
| 45 |
SCC_SFP_AG_GPLUS_O |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Aggr Grad Plus
|
| 46 |
SCC_SFP_GPLUS_TOT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Grad Plus Total
|
| 47 |
SCC_SFP_UGSUB_LN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS UG Sub Loan Limit
|
| 48 |
SCC_SFP_UGCMB_LN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS UG Combo Loan Limit
|
| 49 |
SCC_SFP_TCH_LN_CNV |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Grant Loan Conv
|
| 50 |
SCC_SFP_TCH_LN_OPB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Loan Principal Balance
|
| 51 |
SCC_SFP_TCH_LN_TOT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Loan Total
|
| 52 |
SCC_SFP_TCH_UG_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
UG Disbursement Amount
|
| 53 |
SCC_SFP_TCH_UG_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
UGRD Percent Elig Used
|
| 54 |
SCC_SFP_TCH_UG_REM |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
UG Remaining Amount
|
| 55 |
SCC_SFP_TCH_GRD_AM |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Graduate Disbursement Amount
|
| 56 |
SCC_SFP_TCH_GRDPCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
GRAD Percent Elig Used
|
| 57 |
SCC_SFP_TCH_GRD_R |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Grad Remaining Amount
|
| 58 |
SCC_SFP_TCH_GRNT_C |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Grant Change Flag
|
| 59 |
SCC_SFP_TCH_AGG_GR |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS TEACH Grant Aggr Chg
|
| 60 |
SCC_SFP_TCH_AGG_LN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS TEACH Loan Aggr Chg
|
| 61 |
SCC_SFP_UG_AG_SUB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Principal Balance
|
| 62 |
SCC_SFP_UG_AG_USUB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
UG Aggregate Unsubsidized
|
| 63 |
SCC_SFP_UG_AG_CMB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
UG Aggregate Combined
|
| 64 |
SCC_SFP_UG_AG_CNSL |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
UG Aggregate Consolidated
|
| 65 |
SCC_SFP_UG_AG_SB_P |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
UG Subsidized Pending Disburse
|
| 66 |
SCC_SFP_UG_AG_USBP |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
UG Unsub Pending Disbursement
|
| 67 |
SCC_SFP_UG_AG_CMBP |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
UG Combined Pending Disb
|
| 68 |
SCC_SFP_UG_AG_STOT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
UG Total Aggregate Subsidized
|
| 69 |
SCC_SFP_UG_AG_USTO |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
UG Aggregate Unsub Total
|
| 70 |
SCC_SFP_UG_AG_CMBT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
UG Aggregate Combined Total
|
| 71 |
SCC_SFP_UG_AG_CNST |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
UG Aggregate Consolidated
|
| 72 |
SCC_SFP_UG_AWRD_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
UG Award Year
|
| 73 |
SCC_SFP_UG_DEP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
UG Dependency Indicator
|
| 74 |
SCC_SFP_GR_AG_SUB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Principal Balance
|
| 75 |
SCC_SFP_GR_AG_USUB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Grad Aggregate Unsubsidized
|
| 76 |
SCC_SFP_GR_AG_CMB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Grad Aggregate Combined
|
| 77 |
SCC_SFP_GR_AG_CNSL |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Grad Aggregate Consolidated
|
| 78 |
SCC_SFP_GR_AG_SB_P |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Grad Subsidized Pending Disb
|
| 79 |
SCC_SFP_GR_AG_USBP |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Grad Unsub Pending Disb
|
| 80 |
SCC_SFP_GR_AG_CMBP |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Grad Combined Pending Disb
|
| 81 |
SCC_SFP_GR_AG_STOT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Grad Total Aggregate Subsidize
|
| 82 |
SCC_SFP_GR_AG_USTO |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Grad Aggregate Unsub Total
|
| 83 |
SCC_SFP_GR_AG_CMBT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Grad Aggregate Combined Total
|
| 84 |
SCC_SFP_GR_AG_CNST |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Grad Aggregate Consolidated
|
| 85 |
SCC_SFP_GR_AWRD_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
Graduate Award Year
|
| 86 |
SCC_SFP_GR_DEP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Grad Dependency Indicator
|
| 87 |
SCC_SFP_LIFTM_ELIG |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Lifetime Eligibility Used
|
| 88 |
SCC_SFP_ENRL_PTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Unusual Enrollment Pattern Flg
|
| 89 |
SCC_SFP_PELL_LEU_I |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Pell Lifetime Limit
|
| 90 |
SCC_SFP_SULA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Sub Usage Limit Applies
|
| 91 |
SCC_SFP_SB_LN_ELIG |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Subsidized Usage Period
|
| 92 |
SCC_SFP_LIFTM_IASG |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Lifetime Eligibility Used
|
| 93 |
SCC_SFP_IASG_LMT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS IASG Lifetime Limit
|
| 94 |
SCC_SFP_IASG_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS IASG change flag
|
| 95 |
SCC_SFP_FNAME_HIST |
Character(12) |
VARCHAR2(12) NOT NULL |
NSLDS First Name History
|
| 96 |
SCC_SFP_MI_HIST |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Middle Inital History
|
| 97 |
SCC_SFP_LNAME_HIST |
Character(35) |
VARCHAR2(35) NOT NULL |
NSLDS Last Name History
|
| 98 |
SCC_SFP_OVRPYM_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Overpayment Type
|
| 99 |
SCC_SFP_OVRPYM_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Overpayment Indc
|
| 100 |
SCC_SFP_AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
|
| 101 |
SCC_SFP_CONTACT |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Contact
|
| 102 |
SCC_SFP_SCHED_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Pell Sched Amt
|
| 103 |
SCC_SFP_DISB_PELL |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Pell Disb Amt
|
| 104 |
SCC_SFP_PELL_AIDYR |
Character(4) |
VARCHAR2(4) NOT NULL |
PELL Award Year
|
| 105 |
SCC_SFP_PELL_TXNBR |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Pell Txn Nbr
|
| 106 |
SCC_SFP_PELL_UPDT |
Date(10) |
DATE |
NSLDS Pell Last Updt
|
| 107 |
SCC_SFP_PELL_VER_F |
Character(3) |
VARCHAR2(3) NOT NULL |
NSLDS Pell Verif Flag
|
| 108 |
SCC_SFP_PELL_EFC |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Pell EFC
|
| 109 |
SCC_SFP_AWARD_PELL |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Pell Award Amt
|
| 110 |
SCC_SFP_PELL_SCHCD |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Pell School Cd
|
| 111 |
SCC_SFP_GRANT_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.
|
| 112 |
SCC_SFP_PELL_PSTDT |
Date(10) |
DATE |
Date Posted to Pell System
|
| 113 |
SCC_SFP_PELL_PRCNT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
NSLDS Pell Prcnt Used
|
| 114 |
SCC_SFP_GRANT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Grant Type
|
| 115 |
SCC_SFP_ACG_ELIGCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Eligibility Code
|
| 116 |
SCC_SFP_ACG_HS_PGM |
Character(6) |
VARCHAR2(6) NOT NULL |
High School Prog
|
| 117 |
SCC_SFP_NSG_SCHLYR |
Character(1) |
VARCHAR2(1) NOT NULL |
NSG Academic Level
|
| 118 |
SCC_SFP_AWARD_ID |
Character(21) |
VARCHAR2(21) NOT NULL |
Award ID
|
| 119 |
SCC_SFP_INST_PG_CD |
Character(7) |
VARCHAR2(7) NOT NULL |
Instructional Program Code
|
| 120 |
SCC_SFP_NSG_SEQ_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
NSG COD Sequence Code
|
| 121 |
SCC_SFP_PCTUSD_AYL |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Total Elig Acad Year Level
|
| 122 |
SCC_SFP_PELL_TCHLN |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Grant Loan Conv
|
| 123 |
SCC_SFP_TCH_CONVDT |
Date(10) |
DATE |
Loan Conversion Date
|
| 124 |
SCC_SFP_ADD_ELIG_I |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Elig Indicator
|
| 125 |
SCC_SFP_DCSD_VET_I |
Character(1) |
VARCHAR2(1) NOT NULL |
Post 9/11 Dependent
|
| 126 |
SCC_SFP_FIRST_PELL |
Character(1) |
VARCHAR2(1) NOT NULL |
First Time Pell Indicator
|
| 127 |
SCC_SFP_CFH_INDCTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Children of Fallen Heroes
|
| 128 |
SCC_SFP_LN_TYPE_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Loan Type Code
|
| 129 |
SCC_SFP_STAT_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
NSLDS Status Code
|
| 130 |
SCC_SFP_STAT_DT |
Date(10) |
DATE |
NSLDS Status Effective Dt
|
| 131 |
SCC_SFP_PRIN_BAL_O |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Principal Balance
|
| 132 |
SCC_SFP_BAL_DT_O |
Date(10) |
DATE |
NSLDS Balance Dt
|
| 133 |
SCC_SFP_LN_START_O |
Date(10) |
DATE |
NSLDS Loan Beginning Dt
|
| 134 |
SCC_SFP_LN_END_O |
Date(10) |
DATE |
NSLDS Loan Ending Dt
|
| 135 |
SCC_SFP_GA_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Guarantee Agency
|
| 136 |
SCC_SFP_ACAD_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Academic Level
|
| 137 |
SCC_SFP_CNTCT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
NSLDS Contact Type
|
| 138 |
SCC_SFP_NET_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
NSLDS Net Amt Disbursed
|
| 139 |
SCC_SFP_NSLDS_CNTC |
Character(8) |
VARCHAR2(8) NOT NULL |
NSLDS Contact
|
| 140 |
SCC_SFP_LN_EXUSUB |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan Extra UnSub (1)
|
| 141 |
SCC_SFP_LN_CAP_INT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan Cap Interest (1)
|
| 142 |
SCC_SFP_LN_DISB_DT |
Date(10) |
DATE |
Date of the last disbursement made to the student for the loan record. May contain the value 'N/A'.
|
| 143 |
SCC_SFP_LN_DISBAMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Last loan disbursement amount report on the NSLDS alert file. May contain the value 'N/A'.
|
| 144 |
SCC_SFP_LENDER_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Loan Lender Code. May contain a value of N/A if null.
|
| 145 |
SCC_SFP_LND_SVCRCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Used for the Lender Servicer Code in the NSLDS Loan Detail record.
|
| 146 |
SCC_SFP_LN_CHNG_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan change flag indicates that a changed loan record is contained in the NSLDS alert file.
|
| 147 |
SCC_SFP_AG_CL_USB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Unsubsidized Aggregate Amt
|
| 148 |
SCC_SFP_AG_CL_SUB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Subsidized Aggregate Amt
|
| 149 |
SCC_SFP_AG_CL_CMB |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
COMBO AGGREGATE AMT
|
| 150 |
SCC_SFP_AG_CL_REM |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Unallocated Aggregate Amt
|
| 151 |
SCC_SFP_TOTDISB_CH |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Total Disbursement Amount
|
| 152 |
SCC_SFP_PERK_CNTYP |
Character(3) |
VARCHAR2(3) NOT NULL |
Perkins Cancellation Type
|
| 153 |
SCC_SFP_LN_APVDAMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Guarantee/Approved Amount
|
| 154 |
SCC_SFP_LN_APRVLDT |
Date(10) |
DATE |
Guarantee/Approval Date
|
| 155 |
SCC_SFP_LOAN_ID |
Character(21) |
VARCHAR2(21) NOT NULL |
Award ID
|
| 156 |
SCC_SFP_SULA_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Confirmed SULA Status
|
| 157 |
SCC_SFP_SUB_STATDT |
Date(10) |
DATE |
NSLDS Subsidy Status Date (1)
|
| 158 |
SCC_SFP_ACAD_BGNDT |
Date(10) |
DATE |
Academic Year Begin Date
|
| 159 |
SCC_SFP_ACAD_ENDDT |
Date(10) |
DATE |
Academic Year End Date
|
| 160 |
SCC_SFP_REAFFIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
Reaffirmation Flag
|
| 161 |
SCC_SFP_STAT_INTRT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Statutory Interest Rate
|
| 162 |
SCC_SFP_ACT_INT_RT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Actual Interest Rate
|
| 163 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 164 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 165 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 166 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|