Skip to content

Instantly share code, notes, and snippets.

@aj0strow

aj0strow/account_status.csv

Last active October 26, 2023 04:14
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save aj0strow/6e923bf53addd99c5d85a89fe9747baa to your computer and use it in GitHub Desktop.
Save aj0strow/6e923bf53addd99c5d85a89fe9747baa to your computer and use it in GitHub Desktop.
Download ZIP
Metro2 Format for Canadian Reporting
Raw
account_status.csv
Status Description Equifax Description Equifax Rate
DA Delete entire account None 9
DF Delete entire account None 9
ZA Financial counseling Credit Counseling 7
05 Account transferred to another office Transferred or sold 1
07 Too new to rate None 0
11 Account in good standing None 1
13 Paid or closed account / zero balance Account paid 1
61 Account paid in full / was voluntary surrender Account paid 8
62 Account paid in full / was collection account / insurance claim or government claim Account paid 9
63 Account paid in full / was repossession Account paid 8
64 Account paid in full / was charge off Account paid 9
65 Account paid in full / was foreclosure Account paid 9
71 Account 30 days past due None 2
78 Account 60 days past due None 3
80 Account 90 days past due None 4
82 Account 120 days past due None 5
83 Account 150 days past due None 5
84 Account 180 days past due None 5
87 Foreclosure proceeding started Foreclosure proceeding started 5
88 Claim filed with government for insured portion of balance on defaulted loan None 9
89 Deed received in lieu of foreclosure on defaulted loan; there may be a balance due None 8
93 Account seriously past due and / or assigned to internal or external collections Account assigned to 3rd party for collection 9
94 Foreclosure / Credit Grantor sold collateral to settle default mortgage; there may be a balance due Foreclosure 8
95 Voluntary surrender Voluntary repossession 8
96 Merchandise was taken back by Credit Grantor, there may be a balance due Involuntary repossession 8
97 Unpaid balance reported as a loss by Credit Grantor Written off 9
Raw
account_type.csv
Metro Value Metro Description Equifax Description
00 Auto Auto
01 Unsecured Unsecured
02 Secured Secured
03 Partially Secured Secured
04 Home Improvement Home Improvement Loan
05 FHA Home Improvement Home Improvement Loan
06 Installment Sales Contract
07 Charge Account
08 Real Estate Mortgage
10 Business Loan Commercial
11 Recreational Merchandise
12 Education Student
13 Lease Lease
15 Line of Credit
17 Manufactured Housing
18 Credit Card
19 FHA Real Estate Mortgage Loan Mortgage
20 Note Loan Note Loan
25 Real Estate Mortgage Loan Mortgage
26 Conventional Real Estate Mortgage Mortgage
29 Rental Agreement Rental
34 Debt Counseling Service Credit Counseling
37 Combined Credit Plan
43 Debit Card
47 Credit Line Secured Secured
48 Collection Agency or Attorney
50 Family Support
65 Government Unsecured Guaranteed Loan Unsecured
66 Government Secured Guaranteed Loan Secured
67 Government Unsecured Direct Loan Unsecured
68 Government Secured Direct Loan Secured
69 Government Grant
70 Government Overpayment
71 Government Fine
72 Government Fee for Services
73 Government Employee Advance
74 Government Misc. Debt
75 Government Benefit
77 Returned Check Due to NSF cheque
89 Home Equity Line of Credit Home Equity
90 Medical Debt
91 Debt Consolidation Consolidation Loan
92 Utility Company
93 Child Support
95 Attorney Fees
0A Time Share Loan
0C Debt Buyer
0G Flexible Spending Credit Card Hybrid Account
1Y Hybrid
1Z Student Line of Credit Student
2A Secured Line of Credit Secured
2C Farmers Home Admin Real Estate Mortgage Mortgage
2Z RSP Loan RSP Loan
3A Auto Lease Lease
3Z RRSP Mortgage Loan RRSP Mortgage Loan
5A Real Estate Junior Liens Mortgage
5B Second Mortgage Second Mortgage
6A Commercial Installment Loan Commercial
6B Commercial Mortgage Loan Commercial
6D Home Equity Home Equity
7A Commercial Line of Credit Commercial
7B Agricultural
8A Business Credit Card Corporate Credit Card
8B Deposit Account with Overdraft Protection
9A Secured Home Improvement Secured
9B Business Line Personally Guaranteed Business Venture Subject Liable
9Z Overdraft Protection Overdraft Protection
4Z Reverse Mortgage Reverse Mortgage
5Z Real Estate Secured Real Estate Secured
6Z Insured Insured
7Z Uninsured Uninsured
8Z Collateral Mortgage Collateral Mortgage
Raw
address_indicator.csv
Value Description
C Confirmed or verified address
Y Known to be address of primary consumer
N Not confirmed address
M Military address
S Secondary address
B Business address
U Returned mail
D Default address
P Bill payer service not consumer’s residence
Raw
association_code.csv
Metro Value Description Comments
1 Individual Consumer is primarily responsible for the account
2 Joint Joint account for which primary consumer has contractual responsibility
4 Joint Joint account for which primary consumer has contractual responsibility
7 Has a co-signer Account where primary consumer is liable but if the primary consumer defaults on payment the co-maker is liable.
9 Has a guarantor Account where primary consumer is liable but another person becomes secondarily liable for the debt in the event of default by the principal debtor.
A Assumed Mortgage Account where the buyer assumes all the obligations under the mortgage just as if the loan had been made to the buyer. The major driving force behind assumptions is the lower interest rate on the assumed mortgage relative to current market rates.
T Terminated Primary consumer association with account is terminated. This will be reported with balance set to zero and narrative account closed. If account status is not derogatory-rate will be forced to 1.
W Commercial account Note: this will designate the account as being a commercial account and will be reported on the commercial database if greater than 50 records.
X Consumer deceased Primary consumer is deceased. This will be bypassed at the present time. If you wish to report the account with the latest status- advise Equifax so they can take appropriate action.
Z Delete This will delete the borrower from the account on the database. Note: this is to be used only if the account was reported inaccurately. If the entire account needs to be deleted the account status of “DA” must be used.
Raw
base.csv
Field Field Name Required Format Length Character Format Position
0 block descriptor word A N 4 1-4
1 record descriptor word A N 4 1-4
2 processing indicator Y N 1 5
3 time stamp N N 14 6-19
4 correction indicator Y N 1 20
5 identification number Y AN 20 21-40
6 cycle identifier A AN 2 41-42
7 consumer account number Y AN 30 43-72
8 portfolio type Y AN 1 73
9 account type Y AN 2 74-75
10 date opened Y N 8 76-83
11 credit limit Y N 9 84-92
12 highest credit or original loan amount Y N 9 93-101
13 terms duration N AN 3 102-104
14 terms frequency Y AN 1 105
15 scheduled payment amount Y N 9 106-114
16 actual payment Amount Y N 9 115-123
17A account status Y AN 2 124-125
17B payment rating Y AN 1 126
18 Payment History Profile Y AN 24 127-150
19 Special Comment A AN 2 151-152
20 Compliance Condition Code A AN 2 153-154
21 Current Balance Y N 9 155-163
22 Amount Past Due Y N 9 164-172
23 Original Charge-Off Amount Y N 9 173-181
24 Date of Account Information N N 8 182-189
25 FCRA Compliance / Date of First Delinquency Y N 8 190-197
26 Date Closed Y N 8 198-205
27 Date of Last Payment Y N 8 206-213
28 Currency Type Code N AN 17 214-230
29 Consumer Transaction Type A N 1 231
30 Surname Y AN 25 232-256
31 First Name Y AN 20 257-276
32 Middle Name Y AN 20 277-296
33 Generation Code A AN 1 297
34 Social Insurance Number A N 9 298-306
35 Date of Birth Y N 8 307-314
36 Telephone Number Y N 10 315-324
37 ECOA/Association Code Y AN 1 325
38 Consumer Information Indicator A AN 2 326-327
39 Country Code A AN 2 328-329
40 First Line of Address Y AN 32 330-361
41 Second Line of Address Y AN 32 362-393
42 City Y AN 20 394-413
43 Province Y AN 2 414-415
44 Postal Code Y AN 9 416-424
45 Address Indicator N AN 1 425
46 Residence Code N AN 1 426
Raw
condition_code.csv
Metro Value Description Equifax Narrative
XA Account closed at consumer’s request Account closed at consumer’s request
XB Account information disputed by consumer Subject disputes this account
XC Completed investigation of FCRA dispute Subject disputes this account
XD Account closed at consumer’s request and in dispute under FCRA - Account closed at consumer’s request - Subject disputes this account
XE Account closed at consumer’s request investigation under FCRA complete - Account closed at consumer’s request - Subject disputes this account
XF Account in dispute under FCBA Subject disputes this account
XG FCBA dispute resolved Subject disputes this account
XJ Account Closed at consumer’s request and in dispute under FCBA Account closed at consumer’s request
XR This DOES NOT remove previously reported narrative for EQUIFAX
Raw
consumer_information_indicator.csv
Value Description Comments
No new Consumer Information Indicator applies for this activity period
A Petition for Bankruptcy Included in bankruptcy
B Petition for Proposal Included in consumer proposal
C Petition for OPD Included in OPD
D Petition for Credit Counselling Credit counselling
E Discharged through Bankruptcy Included in bankruptcy
F Discharged Proposal in Canada Included in Consumer Proposal
G Discharged OPD Included in OPD
H Completed Credit Counselling (will be reported when consumer has completed all payments through a Credit Counselling plan) Credit Counseling
I Bankruptcy Dismissed
J Proposal Dismissed
K OPD Dismissed
L Credit Counselling Dismissed
M Bankruptcy Withdrawn
N Ptoposal Withdrawn
O OPD Withdrawn
P Credit Counselling Withdrawn
Z Bankruptcy Undesignated Chapter Included in bankruptcy
ZA Chapter 7 Bankruptcy in Canada Included in bankruptcy
ZB Discharged Bankruptcy Included in bankruptcy
ZC Bankruptcy Dismissed Included in bankruptcy
ZD Bankruptcy Withdrawn Included in bankruptcy
1A Personal Receivership
Q Used to report Bankruptcies that have been closed or terminated without being discharged or dismissed
R Reaffirmation of Debt
V Chapter 7 Reaffirmation of Debt Rescinded
2A Lease Assumption
S Used to confirm that previously reported Reaffirmation of Debt, Reaffirmation of Debt Rescinded and Lease Assumption Indicators (R, V, 2A, and Obsolete values W, X, Y) are no longer applicable
T Supplier/Source Cannot Locate Consumer
U Consumer Now Located
Raw
consumer_transaction_type.csv
Value Description
1 New Account
2 Name Change
3 Address Change
5 Social Insurance Number Change
6 Name + Address Change
8 Name + Social Insurance Number Change
9 Address + Social Insurance Number Change
A Name + Address + Social Insurance Change
Raw
header.csv
Field Field Name Required Format Length Character Format Position
0 Block descriptor word A N 4 1-4
1 Record descriptor word A N 4 1-4
2 Record identifier Y AN 6 5-10
3 Cycle number A AN 2 11-12
4 Innovis program identifier N AN 10 13-22
5 Equifax program identifier Y AN 10 23-32
6 Experian Program identifier N AN 5 33-37
7 Trans Union program identifier N AN 10 38-47
8 Activity date Y N 8 48-55
9 Date created Y N 8 56-63
10 Program date N N 8 64-71
11 Program revision date N N 8 72-79
12 Reporter name Y AN 40 80-119
13 Reporter address N AN 96 120-215
14 Reporter telephone number N N 10 216-225
15 Software vendor name A AN 40 226-265
16 Software version number N AN 5 266-270
17 MicroBilt/PRBC identifier N AN 10 271-280
17 Reserved Y AN 146 281-426
Raw
j1.csv
Field Field Name Required Format Length Position
1 Segment Identifier Y AN 2 1-2
2 Consumer Transaction Type A AN 1 3
3 Surname Y AN 25 4-28
4 First Name Y AN 20 29-48
5 Middle Name Y AN 20 49-68
6 Generation Code A AN 1 69
7 Social Insurance Number A N 9 70-78
8 Date of Birth Y N 8 79-86
9 Telephone Number Y N 10 87-96
10 ECOA/Association Code Y AN 1 97
11 Consumer Information Indicator A AN 2 98-99
12 Reserved Y AN 1 100
Raw
j2.csv
Field Field Name Required Format Length Position
1 Segment Identifier Y AN 2 1-2
2 Consumer Transaction Type A AN 1 3
3 Surname Y AN 25 4-28
4 First Name Y AN 20 29-48
5 Middle Name Y AN 20 49-68
6 Generation Code A AN 1 69
7 Social Insurance Number A N 9 70-78
8 Date of Birth Y N 8 79-86
9 Telephone Number Y N 10 87-96
10 ECOA/Association Code Y AN 1 97
11 Consumer Information Indicator A AN 2 98-99
12 Country Code A AN 2 100-101
13 First Line of Address Y AN 32 102-133
14 Second Line of Address Y AN 32 134-165
15 City Y AN 20 166-185
16 Province Y AN 2 186-187
17 Postal Code Y AN 9 188-196
18 Address Indicator N AN 1 197
19 Residence Code N AN 1 198
20 Reserved Y AN 2 199-200
Raw
p1.csv
Field Field Name Required Format Length Position
1 Segment Identifier Y AN 2 1-2
2 Telephone Number 2 Y N 10 3-12
3 Telephone Number 2 Extension Y N 5 13-17
4 Telephone Number 2 Type Y N 1 18
5 Telephone Number 3 Y N 10 19-28
6 Telephone Number 3 Extension Y N 5 29-33
7 Telephone Number 3 Type Y N 1 34
8 Email Address Y AN 254 35-288
9 Drivers License Y AN 40 289-328
10 Drivers License Expiry Date Y N 8 329-336
11 Drivers License Province Code Y A 2 337-338
12 Passport Number Y AN 40 339-378
13 Passport Country Code Y N 3 379-381
14 Passport Expiry Date Y A 8 382-389
15 Nexus Card Y AN 40 390-429
16 Citizenship Y A 3 430-432
17 Nexus Card Issuing Date Y AN 9 433-441
18 Nexus Card Expiration Date Y AN 9 442-450
19 Nexus Card Issuing Country Y A 3 451-453
20 Reserved Y AN 80 454-533
Raw
payment_history.csv
Value Description
0 0 payments past due (current)
1 30-59 days past due date
2 60-89 days past due date
3 90-119 days past due date
4 120-149 days past due date
5 150-179 days past due date
6 180 or more days past due date
B No payment history available prior to this time (this value must not be embedded within other values)
D No payment history available this month (D may be embedded within other values)
E Zero balance – current account (applies to credit card and line of credit)
G Collection
H Foreclosure completed
J Voluntary surrender
K Repossession
L Charge off
Y Financial Counseling
Z Too New to Rate
Raw
payment_rating.csv
Metro Value Description Output Rate
G Collection 9
H Foreclosure Completed 8
J Voluntary Surrender 8
K Repossession 8
L Charge Off 9
Y Financial Counseling 7
Raw
phone_type.csv
Metro Value Description
1 Residential/Home
2 Cell/Mobile
3 Work/Business
4 Fax
5 Other
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment