Download:
pdf |
pdfFR Y‐14Q: Retail Student Loan Schedule Instructions
FR Y‐14Q: Retail Student Loan Schedule Instructions
In this schedule, bank holding companies (BHCs) should report all student loans reported in lines 6.b and 6.d of
schedule HC‐C of the FR Y‐9C.
For the first reporting period (September 2011), the request is for monthly portfolio‐level data for a number of
student loan portfolio segments from January 2007 to the first reporting period. For subsequent periods, the BHC is
only required to report data for the months within the reporting period.
The requested segmentations are presented in table A below. Reporting BHCs are requested to segment the student
loan portfolio by product type, origination vintage, original FICO or equivalent, and delinquency status. More
information on each of these segmentations can be found in Section A of these instructions. Start each row of data
with your BHC name (SAS Variable: BHC_NAME), your RSSD ID number (SAS Variable: RSSD_ID), the reporting month
(SAS Variable: REPORTING_MONTH), and Portfolio ID (SAS Variable: PORTFOLIO_ID) (use Student for portfolio ID
within this schedule).
Table B lists the variables that are reported for each portfolio segment. Definitions for each of these variables can be
found in Section B of these instructions. Provide all dollar unit data in millions of dollars ($ Millions). Use the SAS
variable names and SAS data types provided in the table for the submission.
The Student Example Raw File Exhibit provides an example of the dataset to be submitted. Columns D to I of the
example indicate the specific reported segment, while the remaining columns contain the requested summary
variables. Rows 3 to 60 are for the following specific segment: managed – gov’t guaranteed, originated in 2005 or
earlier, with original FICO or equivalent <= 660, and current or 1‐29 days past due. A new segment starts in row 61.
This segment has the same characteristics as the prior segment except that the delinquency status is 30‐59 days past
due. There are two product segments, five origination vintage segments, three original FICO or equivalent segments,
and five delinquency status segments. This results in a dataset with 150 rows of data per reporting month (2 x 5 x 3 x
5 = 150). Submit all data files in SAS format (version 7 or higher) only. Include in the submission all segments that
are not applicable (e.g., there are no loans or accounts in those segments) such that the dataset always has 150 rows
of data per reporting month. For the summary variables, assign a SAS missing value (".") if information is not
applicable or not available.
Reporting institutions should provide a segment ID for each reported segment. This segment ID should be a unique
eight digit identifier where each pair of the eight digits refers to a specific classification for each of the four
segmentation categories. Reporting institutions should refer to table A below for the attribute codes for the four
segment categories. For example, in the Student Example Raw File Exhibit, the first segment listed has the segment
ID 01010101 because each of the attributes for this segment is in the primary position of the attributes list in Table.
Starting with row 61, the second example segment has the segment ID 01010102 because all of the attributes are the
same as the prior segment except that delinquency status is 30‐59 days past due, which is listed in the second
position of the attributes list in table A. Do not drop leading zeros.
For the requested summary variables, do not include charge‐offs and recoveries in the calculation of dollars or
number of accounts for a given reporting month. The only exceptions to this rule are the following summary
variables: $ Gross Contractual Charge‐offs, $ Bankruptcy Charge‐offs, $ Recoveries, and $ Net Charge‐offs. For these
variables, report the dollar amount of charge‐offs or recoveries only in the month that they occurred. For the
1
FR Y‐14Q: Retail Student Loan Schedule Instructions
delinquency status segmentation, categorize charge‐offs or recoveries by the delinquency status at charge‐off. A
summation of charge‐offs or recoveries across the delinquency buckets for a given month should thus result in the
total charge‐offs or recoveries recorded by the reporting institution in that reporting month.
A. Segmentation Variables
For each of the summary variables (to be described in further detail in Section B), information should be
reported for the following segments:
1. Product Type – Reporting institutions should segment the portfolio into the following two product
types. An example of a government guaranteed loan is a FFELP loan.
a) Managed ‐ Government Guaranteed
b) Managed – Private
2. Vintage – Refers to the calendar year when the loan was originated. If there were multiple
disbursements tied to an original then use the year of the first disbursement. Vintage refers to the
calendar year that the account was originated. There are five possible vintages to report:
a) 2005 and before
b) 2006
c) 2007
d) 2008
e) 2009 and after
3. Original FICO or equivalent – Reporting institutions should segment the portfolio by original FICO
score (or equivalent). The FICO score can be based on the credit bureau service the institution uses
as its source. Original FICO reflects the score upon which the original underwriting decision was
based. If the bank does NOT obtain original FICO scores, map the internal score or other bureau
score used for the FICO scores and report that score. Include borrower FICO in this calculation even if
the borrower’s FICO score was not used to make the underwriting decision because of the presence
of a co‐signer. Segment the portfolio into the following three categories:
a) <= 660
b) > 660
c) N/A— Original FICO or equivalent score is missing or unknown
4. Delinquency status ‐ Reporting institutions should segment the portfolio into the following five
delinquency statuses:
a) Current + 1‐29 DPD: Accounts that are not past due (accruing and non‐accruing) as of
month‐end and accounts that are 1 to 29 days past due (accruing and non‐accruing) as of
month‐end.
b) 30‐59 DPD: Accounts that are 30 to 59 days past due (accruing and non‐accruing) as of
month‐end.
c) 60‐89 DPD: Accounts that are 60 to 89 days past due (accruing and non‐accruing) as of
month‐end.
d) 90‐119 DPD: Accounts that are 90 to 119 days past due (accruing and non‐accruing) as of
month‐end.
2
FR Y‐14Q: Retail Student Loan Schedule Instructions
e) 120+ DPD: Accounts that are 120 or more days past due (accruing and non‐accruing) as
of month‐end.
B. Summary Variables
For each of the segments described above and for each reference month, report information on the
following summary variables:
1. # Accounts – Total number of accounts on the book for the segment as of month‐end.
2. $ Outstandings – Total unpaid principal balance for accounts on the book for the segment as of
month‐end.
3. # Accounts in Repayment – Total number of accounts on the book for the segment as of month‐
end that have entered the loan’s repayment period.
4. $ Outstandings in Repayment – Total unpaid principal balance for accounts on the book for the
segment as of month‐end that have entered the loan’s repayment period.
5. # New Disbursements – The total number of new disbursements in the given month for the
segment as of month‐end.
6. $ New Disbursements – The total dollar amount disbursed in the given month for the segment
as of month‐end.
7. $ of Unpaid principal balance with Co‐Signer – The dollar amount of unpaid principal balance in
the segment that was underwritten with a co‐signer reported as of the month‐end.
8. $ of Unpaid principal balance In Grace – The dollar amount of unpaid principal balance for
accounts that are in grace status for the segment being reported as of month‐end.
9. $ of Unpaid principal balance In Deferment – The dollar amount of unpaid principal balance for
accounts that are in deferment status for the segment being reported as of month‐end.
10. $ of Unpaid principal balance In Forbearance – The dollar amount of unpaid principal balance
for accounts that are in forbearance status for the segment being reported as of month‐end.
11. $ CDR [0% through 1.99%) ‐ The total unpaid principal balance in the segment that has a school
cohort default rate as computed by the Department of Education falling within 0% through
1.99% as of the month‐end.
12. $ CDR [2% through 3.99%) – The total unpaid principal balance in the segment that has a school
cohort default rate as computed by the Department of Education falling within 2% through
3.99% as of the month‐end.
13. $ CDR [4% through 5.99%) – The total unpaid principal balance in the segment that has a cohort
default rate falling within 4% through 5.99% as of the month‐end.
3
FR Y‐14Q: Retail Student Loan Schedule Instructions
14. $ CDR [6% through 7.99%) – The total unpaid principal balance in the segment that has a cohort
default rate falling within 6% through 7.99% as of the month‐end.
15. $ CDR [8% through 9.99%) – The total unpaid principal balance in the segment that has a cohort
default rate falling within 8% through 9.99% as of the month‐end.
16. $ CDR > 10% ‐ The total unpaid principal balance in the segment that has a cohort default rate
falling above 10%as of the month‐end.
17. $ CDR = N/A ‐ The total unpaid principal balance in the segment that has no cohort default rate
as of the month‐end.
18. $ Gross Contractual Charge‐offs – The total unpaid principal balance for the segment that was
contractually charged off as of month‐end. Report principal charge‐offs only, not interest and
fees. For the delinquency status segmentation, categorize charge‐offs by the delinquency status
at charge‐off.
19. $ Bankruptcy Charge‐offs – The total unpaid principal balance for the segment that was charged
off due to bankruptcy as of month‐end. Report principal charge‐offs only, not interest and fees.
For the delinquency status segmentation, categorize charge‐offs by the delinquency status at
charge‐off.
20. $ Recoveries – The total dollar amount of any balance recovery collected during the month from
previously charged‐off accounts for the segment as of month‐end. For the delinquency status
segmentation, categorize recoveries by the delinquency status at charge‐off.
21. $ Net Charge‐offs – The total unpaid principal balance for the segment that was charged‐off in
the reference month, net of any recoveries in the reference month. Generally, $ Net Charge‐offs
should equal [$ Gross Contractual Charge‐offs + $ Bankruptcy Charge‐offs — $ Recoveries].
22. Adjustment Factor to Reconcile $ Gross Contractual Charge‐offs to $ Net Charge‐offs – If it is
not the case that $ Net Charge‐offs equals [$ Gross Contractual Charge‐offs + $ Bankruptcy
Charge‐offs — $ Recoveries], provide the value of $ Net Charge‐offs minus [$ Gross Contractual
Charge‐offs + $ Bankruptcy Charge‐offs — $ Recoveries] in this variable, and separately provide
an explanation for the difference. As a separate document included in the submission, provide an
explanation for such a difference (for example, fraud losses are also included in the Reporting
Institition’s $ Net Charge‐offs variable). If the adjustment factor variable represents more than
one factor leading to the difference, provide a separate breakout of the multiple factors.
4
FRY14Q:USStudentLoanSchedule
Definition
Reference
TableA
Segments
SASVariableNames
ReportInstructionA1
ReportInstructionA2
ReportInstructionA3
ReportInstructionA4
ProductType
Vintage
OriginalFICOorequivalent
DelinquencyStatus
PRODUCT_TYPE
VINTAGE
ORIG_FICO
DLQ_STATUS
PleaseprovideallDollarUnitdatain$Millions.
SAS
SAS
SegmentID
DataTypes Format
Position
AttributeIDwithinSegmentIDPositions
01
02
03
04
05
ManagedGov
Managed
Character char(35)
12
Guaranteed
Private
34
2005andbefore
2006
2007
2008
2009andafter
Character char(35)
56
<=660
661&above NA
Character char(35)
Character char(35)
78
Current+129DPD 3059DPD
6089DPD 90119DPD 120+DPD
SASVariableName
N_ACCT
D_OS
N_ACCT_REPAY
D_OS_REPAY
N_NEW_DISBURSEMENTS
D_NEW_DISBURSEMENTS
D_UPB_COSIGN
D_UPB_INGRACE
D_UPB_INDEF
D_UPB_INFORE
D_CDR_000199
D_CDR_200399
D_CDR_400599
D_CDR_600799
D_CDR_800999
D_CDR_GT1000
D_CDR_NA
D_GROSS_CONTRACTUAL_CO
D_BANKRUPTCY_CO
D_RECOVERIES
D_NET_CO
SAS
DataType
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
SAS
Format
16.
16.6
16.
16.6
16.
16.6
16.6
16.6
16.6
16.6
16.6
16.6
16.6
16.6
16.6
16.6
16.6
16.6
16.6
16.6
16.6
D_ADJ_NET_CO
Numeric
16.6
TableB
Definition
Reference
ReportInstructionB1
ReportInstructionB2
ReportInstructionB3
ReportInstructionB4
ReportInstructionB5
ReportInstructionB6
ReportInstructionB7
ReportInstructionB8
ReportInstructionB9
ReportInstructionB10
ReportInstructionB11
ReportInstructionB12
ReportInstructionB13
ReportInstructionB14
ReportInstructionB15
ReportInstructionB16
ReportInstructionB17
ReportInstructionB18
ReportInstructionB19
ReportInstructionB20
ReportInstructionB21
ReportInstructionB22
SummaryVariables
#Accounts
$Outstandings
#Accountsinrepayment
$Outstandingsinrepayment
#NewDisbursements
$NewDisbursements
$UPBwithCoSigner
$UPBInGrace
$UPBInDeferment
$UPBInForebearance
$CDR[0%through1.99%)
$CDR[2%through3.99%)
$CDR[4%through5.99%)
$CDR[6%through7.99%)
$CDR[8%through9.99%)
$CDR>=10%
$CDR=N/A
$GrossContractualChargeoffs
$BankruptcyChargeoffs
$Recoveries
$NetChargeoffs
AdjustmentFactortoReconcile$Gross
ContractualChargeoffto$NetChargeoffs
StudentExampleRawDataFileExhibit
A
B
C
1 Business/PortfolioIdentifierData
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
BHC
Name
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
BHCRSSD_ID#
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
Portfolio
ID
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
D
Segments
SegmentID#
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010102
010102
010102
010102
010102
010102
010102
010102
010102
010102
010102
E
ProductType
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
…
F
G
H
Origination
Vintage
OriginalFICO DelinquencyStatus
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
…
…
I
Reporting
Month
Jan07
Feb07
Mar07
Apr07
May07
Jun07
Jul07
Aug07
Sep07
Oct07
Nov07
Dec07
Jan08
Feb08
Mar08
Apr08
May08
Jun08
Jul08
Aug08
Sep08
Oct08
Nov08
Dec08
Jan09
Feb09
Mar09
Apr09
May09
Jun09
Jul09
Aug09
Sep09
Oct09
Nov09
Dec09
Jan10
Feb10
Mar10
Apr10
May10
Jun10
Jul10
Aug10
Sep10
Oct10
Nov10
Dec10
Jan11
Feb11
Mar11
Apr11
May11
Jun11
Jul11
Aug11
Sep11
Oct11
Jan07
Feb07
Mar07
Apr07
May07
Jun07
Jul07
Aug07
Sep07
Oct07
Nov07
…
J
K
SummaryVariables
L
M
N
O
P
Q
R
S
T
U
$
$
Outstandi
Avg.
$
#Accounts Outstanding #Accounts ngNew Original
$UPB
$UPBIn $UPBIn $CDR[0%
Originatio FICOof withCo $UPBIn Defermen Forebeara through
Outstanding
in
sin
New
#Accounts
s
repayment repayment Origination
n
Borrowers Signer
Grace
t
nce
1.99%)
…
…
…
…
…
…
…
…
…
…
…
…
StudentExampleRawDataFileExhibit
A
B
C
1 Business/PortfolioIdentifierData
2
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
BHC
Name
BHCRSSD_ID#
Portfolio
ID
D
Segments
SegmentID#
E
ProductType
F
Origination
Vintage
G
OriginalFICO
H
DelinquencyStatus
I
Reporting
Month
J
K
SummaryVariables
L
M
N
O
P
Q
R
S
T
U
$
$
Outstandi
Avg.
$
#Accounts Outstanding #Accounts ngNew Original
$UPB
$UPBIn $UPBIn $CDR[0%
Originatio FICOof withCo $UPBIn Defermen Forebeara through
Outstanding
in
sin
New
#Accounts
s
repayment repayment Origination
n
Borrowers Signer
Grace
t
nce
1.99%)
StudentExampleRawDataFileExhibit
A
B
C
1 Business/PortfolioIdentifierData
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
BHC
Name
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
BHCRSSD_ID#
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
7654321
Portfolio
ID
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
D
Segments
SegmentID#
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010101
010102
010102
010102
010102
010102
010102
010102
010102
010102
010102
010102
E
ProductType
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
ManagedGov'tGuaranteed
…
F
G
H
Origination
Vintage
OriginalFICO DelinquencyStatus
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2005&before
<=660 Current+129DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
2003&before
<=660 3059DPD
…
…
V
I
Reporting
Month
Jan07
Feb07
Mar07
Apr07
May07
Jun07
Jul07
Aug07
Sep07
Oct07
Nov07
Dec07
Jan08
Feb08
Mar08
Apr08
May08
Jun08
Jul08
Aug08
Sep08
Oct08
Nov08
Dec08
Jan09
Feb09
Mar09
Apr09
May09
Jun09
Jul09
Aug09
Sep09
Oct09
Nov09
Dec09
Jan10
Feb10
Mar10
Apr10
May10
Jun10
Jul10
Aug10
Sep10
Oct10
Nov10
Dec10
Jan11
Feb11
Mar11
Apr11
May11
Jun11
Jul11
Aug11
Sep11
Oct11
Jan07
Feb07
Mar07
Apr07
May07
Jun07
Jul07
Aug07
Sep07
Oct07
Nov07
…
W
X
Y
$CDR[2% $CDR[4% $CDR[6% $CDR[8%
through
through
through
through
3.99%)
5.99%)
7.99%)
9.99%)
…
…
…
…
…
Z
AA
AB
$CDR
>=10%
$CDR=
N/A
$Gross
Contractual
Chargeoffs
…
…
AC
AD
$Bankruptcy
$
Chargeoffs Recoveries
…
…
…
AE
AF
$Net
Charge
offs
AdjustmentFactorto
Reconcile$Gross
ContractualChargeoffto$
NetChargeoffs
…
StudentExampleRawDataFileExhibit
A
B
C
1 Business/PortfolioIdentifierData
2
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
BHC
Name
BHCRSSD_ID#
Portfolio
ID
D
Segments
SegmentID#
E
F
ProductType
Origination
Vintage
G
OriginalFICO
H
I
DelinquencyStatus
Reporting
Month
V
W
X
Y
$CDR[2% $CDR[4% $CDR[6% $CDR[8%
through
through
through
through
3.99%)
5.99%)
7.99%)
9.99%)
Z
AA
AB
$CDR
>=10%
$CDR=
N/A
$Gross
Contractual
Chargeoffs
AC
AD
$Bankruptcy
$
Chargeoffs Recoveries
AE
AF
$Net
Charge
offs
AdjustmentFactorto
Reconcile$Gross
ContractualChargeoffto$
NetChargeoffs
File Type | application/pdf |
File Title | Microsoft Word - STUDENT_FINAL.docx |
Author | m1rfs00 |
File Modified | 2011-12-30 |
File Created | 2011-12-30 |