Mortgage Metrics and Y-14 First Liens Data Mapping

Data Collection Sources	OCC Collection Field No.	OCC Collection Data Field Name	Corresponding FR Y-14M Collection Field No.	Corresponding FR Y-14M Collection Data Field Name	FR Y-14M Data Fields That Can Be Used to Derive OCC's MMR Data Fields	Note
Loss Mitigation Loan Level Data Collection	1	Loan Number	1	Loan Number		Some translation / mapping needed
	2	Lien Position at Origination	17	Lien Position at Origination
	3	Credit Grade
	4	Investor	50	Investor Type		Some translation / mapping needed; Y14 has more granular definition
	5	Product Group	16	Loan Type		Some translation / mapping needed; Y14 has more granular definition
	6	Interest Type at Origination	117	Interest Type at Origination
	7	Interest Type in current month	132	Interest Type ‐ Current
	8	Loan Closing Date	2	Loan Closing Date
	9	Original Loan Amount	6	Original Loan Amount Disbursed
	10	Unpaid Principal Balance	60	Unpaid Principal Balance
	11	Original Interest Rate	44	Original Interest Rate
	12	Current Interest Rate	56	Current Interest Rate
	13	Original LTV	8	Original LTV
	14	Refreshed LTV				Can be derived through other data sources, e.g. Home Price Index
	15	Original FICO	13	Origination Credit Bureau Score
	16	Current FICO	48	Current Credit Bureau Score
	17	Product Description	19	Product Type - Current		Some translation / mapping needed; Y14 has more granular definition
	18	Option ARM at Origination	41	Option ARM Flag		Some translation / mapping needed
	19	Option ARM in Reporting Month	52	Option ARM in Reporting Month		Some translation / mapping needed
	20	Interest Only at Origination	27	Interest Only at Origination		Some translation / mapping needed
	21	Interest Only in Reporting Month	49	Interest Only in Reporting Month		Some translation / mapping needed
	22	Documentation	10	Income Documentation
	23	Property State	4	Property State
	24	Property Zip Code	5	Property ZIP Code
	25	Loss Mitigation Performance Status	85	Loss Mitigation Performance Status
	26	Foreclosure Status	65	Foreclosure Status
	27	Foreclosure Referral Date	62	Foreclosure Referral Date
	28	Liquidation Status	64	Paid-In-Full Coding
	29	Foreclosure Sale Date	61	Foreclosure Sale Date
	30	Workout Type Completed / Executed	77	Workout Type Completed
	31	Next Payment Due Date	55	Next Payment Due Date
	32	Bankruptcy Flag	53	Bankruptcy flag		Some translation / mapping needed
	33	Active Repayment Plan Flag	76	Active Repayment Plan Flag		Some translation / mapping needed
	34	Loss Mit Letter Sent
	35	Reason For Default
	36	Loan Source	18	Loan Source		Some translation / mapping needed; Y14 has more granular definition
	37	Owner Occupancy Flag	14	Occupancy		Some translation / mapping needed; Y14 has more granular definition
	38	Notice of Default
	39	Third Party Sale Flag	112	Third-Party Sale Flag
	40	Credit Class	15	Credit Class
	41	Property Type	21	Number of Units
	42	ARM Initial Rate Period	30	ARM Initial Rate Period
	43	Modification Type	74	Modification Type
	44	Original Loan Term	43	Original Loan Term
	45	Loss / Writedown Amount	119	Loss/Write down Amount
	46	Loss / Writedown Date	120	Loss/Write down Date
	47	Debt To Income	11	Debt to Income (DTI) Back‐End at Origination
	48	Foreclosure Suspended	63	Foreclosure Suspended		Some translation / mapping needed
	49	Prepay Penalty Waived This Month
	50	ARM Last Reset Date
	51	ARM Next Reset Date
	52	Prepayment Penalty Waived Amount
	53	Last Modified Date	75	Last Modified Date
	54	Trouble Debt Restructure	96	Troubled Debt Restructure Flag		Some translation / mapping needed
	55	FHA Secure Refinance Flag
	56	Remodified Flag	115	Remodified Flag		Some translation / mapping needed
	57	Balloon Term	25	Balloon Term
	58	Repayment Plan Performance Status	78	Repayment Plan Performance Status
	59	Servicer Advances	51	Servicer Advances
	60	Original Property Value	7	Original Property Value
	61	Refreshed Property Value	68	Refreshed Property Value
	62	Property Valuation Method at Origination	111	Original Property Valuation Method (appraisal method)
	63	Refreshed Property Valuation Method	69	Refreshed Property Valuation Method
	64	Most Recent Property Valuation Date	70	Most Recent Property Valuation Date
65	FNMA Home Saver Advance Date
66	FNMA Home Saver Advance Amount
67	Alternative Home Liquidation Loss Mitigation Date	109	Alternative Home Liquidation Loss Mitigation Date
68	Alternative Home Retention Loss Mitigation Date	110	Alternative Home Retention Loss Mitigation Date
69	Principal Deferred	86	Principal Deferred	Principal Deferred Amount	Field retired in March 2013 as values can be derived from Principal Deferred Amount
70	Principal Write-down	88	Principal Write‐down	Principal Write-Down Amount	Field retired in March 2013 as values can be derived from Principal Write-Down Amount
71	Capitalization	81	Capitalization		Some translation / mapping needed
72	Interest Rate Reduced	98	Interest Rate Reduced		Some translation / mapping needed
73	Interest Rate Frozen	99	Interest Rate Frozen		Some translation / mapping needed
74	Term Extended	100	Term Extended		Some translation / mapping needed
75	Duration of Modification	83	Duration of Modification
76	Refreshed DTI Ratio (Front-end)	73	Refreshed DTI Ratio (Front‐end)
77	Refreshed DTI Ratio (Back-end)	72	Refreshed DTI Ratio (Back‐end)
78	Step Modification Flag	84	Step Modification Flag		Some translation / mapping needed
79	Principal Deferred Amount	87	Principal Deferred Amount
80	Delinquent Amount Capitalized	82	Delinquent Amount Capitalized
81	Refreshed CLTV After Modification	71	Refreshed CLTV After Modification
82	Property Valuation Method at Modification	90	Property Valuation Method at Modification
83	Principal and Interest (P&I) Amount at Origination	45	Principal and Interest (P&I) Amount at Origination
84	Principal and Interest (P&I) Amount Current	59	Principal and Interest (P&I) Amount Current
85	Escrow Amount at Origination	114	Escrow Amount at Origination
86	Escrow Amount Current	113	Escrow Amount Current
87	DTI Ratio (Front-end) at Origination	12	Debt to Income (DTI) Front‐End at Origination
88	Remaining Term	57	Remaining Term
89	ARM Margin at Origination	33	ARM Margin at Origination
90	ARM Margin – Current
91	ARM Index	32	ARM Index		Some translation / mapping needed; Y14 has more granular definition
92	P&I Amount Before Modification	101	P&I Amount Before Modification
93	P&I Amount After Modification	102	P&I Amount After Modification
94	Escrow Amount Before Modification	107	Escrow Amount Before Modification
95	Escrow Amount After Modification	108	Escrow Amount After Modification
96	Interest Rate Before Modification	103	Interest Rate Before Modification
97	Interest Rate After Modification	104	Interest Rate After Modification
98	Remaining Term Before Modification	105	Remaining Term Before Modification
99	Remaining Term After Modification	106	Remaining Term After Modification
100	Home Affordable Refinance Flag	79	“Home Affordable Refinance” Program Flag		Some translation / mapping needed
101	Interest Type Conversion Duration	91	Interest Type Conversion Duration
102	Reported as Bank-Owned Flag	97	Reported as Bank Owned Flag		Some translation / mapping needed
103	Serviced For Others Investor
104	Principal Write-down Amount	89	Principal Write-Down Amount
Extra FR Y-14M Loan Level Data Collection Not Included in OCC's Collection			3	First Payment Date
			9	Original Combined LTV
			20	Loan Purpose Coding
			22	Mortgage Insurance Coverage Percent at Origination
			23	Property Type
			24	Balloon Flag
			26	Buy down Flag
			28	Recourse Flag
			29	ARM Initial Rate
			31	ARM Periodic Interest Reset Period
			34	ARM Negative Amortization % Limit
			35	ARM Periodic Rate Cap
			36	ARM Periodic Rate Floor
			37	ARM Lifetime Rate Cap
			38	ARM Lifetime Rate Floor
			39	ARM Periodic Pay Cap
			40	ARM Periodic Pay Floor
			42	Negative Amortization Flag
			46	Pre-Payment Penalty Flag
			47	Pre-Payment Penalty Term
			54	Bankruptcy Chapter
			58	Scheduled Principal Balance Amount
			66	Repurchase Type
			67	Repurchase Request Date
			80	HAMP Loan Number
			92	SOP 03‐3 Status
			93	Total Debt at Time of any Involuntary Termination
			94	Net Recovery Amount
			95	Credit Enhanced Amount
			116	Mortgage Insurance Company
			118	Entity Serviced
			121	Sales Price of Property
			122	Performance of Junior Lien(s)
			123	Ever 90+ DPD in the Past 12 months
			124	Commercial Loan Flag
			125	Probability of Default – PD
			126	Loss Given Default – LGD
			127	Expected Loss Given Default – ELGD
			128	Exposure at Default – EAD
			129	Entity Type
			130	HFI FVO/HFS Flag
			131	Interest Only Term – Original
			133	Product Type - Origination
			134	Origination Credit Bureau Score Vendor
			135	Origination Credit Bureau Score Version
			136	Current Credit Bureau Score Vendor
			137	Current Credit Bureau Score Version
			138	Current Credit Bureau Score Date
Address Matching Loan Level Data Collection	1	Loan Number	1	Loan Number
	2	Property Street Address	2	Property Street Address
	3	Property City	3	Property City
	4	Property State	4	Property State
	5	Property Zip Code	5	Property Zip Code
	6	Mailing Street Address	6	Mailing Street Address
	7	Mailing City	7	Mailing City
	8	Mailing State	8	Mailing State
	9	Mailing Zip Code	9	Mailing Zip Code
	10	Liquidation Status	10	Liquidation Status
	11	Original Lien Position	11	Lien Position at Origination
	12	Census Tract	12	Census Tract
			13	Data File Reference