Form FR Y-14Q FR Y-14Q Retail Student

FR 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 (e.g., 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. 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 (Variable name:
BHC_NAME), your RSSD ID number (Variable name: RSSD_ID), the reporting month (Variable name:
REPORTING_MONTH), and Portfolio ID (Variable name: 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 variable names and formats provided in table A. Detailed instructions on how to submit the data will be
provided separately. Include in the submission all segments that are not applicable (e.g., there are no loans or
accounts in those segments).
Reporting institutions should provide a segment ID for each reported segment. This segment ID should be a unique
ten digit identifier where each pair of the ten digits refers to a specific classification for each of the five segmentation
categories. Reporting institutions should refer to table A below for the attribute codes for the five segment
categories. 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
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

1

FR Y-14Q: Retail Student Loan Schedule Instructions
2. Age – Refers to the time that has elapsed since the loan was originated. If there were multiple
disbursements tied to an original then use the time since the first disbursement. There are five
possible ages to report:
a) > Six years
b) Between five and six years
c) Between four and five years
d) Between three and four years
e) < Three years
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.
e) 120+ DPD: Accounts that are 120 or more days past due (accruing and non-accruing) as
of month-end.
5. Education level – The level of education being pursued by the recipient of the loan. For
consolidated loans, report the highest level of education pursued by the borrower.
a) Undergraduate – 4 year
b) Graduate / Professional
c) Other (e.g. community college, trade school, etc.)
d) Not available
B. Summary Variables
For each of the segments described above and for each reference month, report information on the
following summary variables:
2

FR Y-14Q: Retail Student Loan Schedule Instructions
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 monthend 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.
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.

3

FR Y-14Q: Retail Student Loan Schedule Instructions
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
Institution’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

FR Y-14Q: Retail Student Loan Schedule Instructions

FR Y-14Q: US Student Loan Schedule
Table A

Report Instruction A - 1

Product Type

PRODUCT_TYPE

Please provide all Dollar Unit data in $ Millions.
Segment ID
Data Types Format
Position
01
Managed - Gov
Guaranteed
Character char(35)
1-2

Report Instruction A - 2
Report Instruction A - 3
Report Instruction A - 4
Report Instruction A - 5

Age
Original FICO or equivalent
Delinquency Status
Education level

AGE
ORIG_FICO
DLQ_STATUS
EDUC_LEVEL

Character
Character
Character
Character

char(35)
char(35)
char(35)
char(35)

Variable Name
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

Data Type
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric
Numeric

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

Definition
Reference

Segments

Variable Names

3-4
5-6
7-8
9-10

>= Six years
<= 660
Current + 1-29 DPD
Undergraduate - 4 year

02

Attribute ID within Segment ID Positions
03

Managed - Private
Between five and six
years
661 & above
30-59 DPD
Graduate / Professional

Between four and five
years
NA
60-89 DPD
Other

04

Between three and
four years
90-119 DPD
Not Available

05

< Three years
120+ DPD

Table B
Definition
Reference
Report Instruction B - 1
Report Instruction B - 2
Report Instruction B - 3
Report Instruction B - 4
Report Instruction B - 5
Report Instruction B - 6
Report Instruction B - 7
Report Instruction B - 8
Report Instruction B - 9
Report Instruction B - 10
Report Instruction B - 11
Report Instruction B - 12
Report Instruction B - 13
Report Instruction B - 14
Report Instruction B - 15
Report Instruction B - 16
Report Instruction B - 17
Report Instruction B - 18
Report Instruction B - 19
Report Instruction B - 20
Report Instruction B - 21
Report Instruction B - 22

Summary Variables
# Accounts
$ Outstandings
# Accounts in repayment
$ Outstandings in repayment
# New Disbursements
$ New Disbursements
$ UPB with Co-Signer
$ UPB In-Grace
$ UPB In-Deferment
$ UPB In-Forebearance
$ CDR [ 0% through 1.99%)
$ CDR [ 2% through 3.99%)
$ CDR [ 4% through 5.99%)
$ CDR [ 6% through 7.99%)
$ CDR [ 8% through 9.99%)
$ CDR >=10%
$ CDR = N/A
$ Gross Contractual Charge-offs
$ Bankruptcy Charge-offs
$ Recoveries
$ Net Charge-offs
Adjustment Factor to Reconcile $ Gross
Contractual Charge-off to $ Net Charge-offs

5