Metro2 | Base Segment

Trailer Record

Required Fields:

Record Descriptor Word (RDW): Required, length 4, position 1-4.
Record Identifier: Required, length 7, position 5-11.
Total Base Records: Required, length 5, position 12-16.
Reserved: Applicable, length 5, position 17-21.
Total of Status Code DF: Applicable, length 5, position 22-26.
Total Associated Consumer Segments (J1): Required, length 5, position 27-31.
Total Associated Consumer Segments (J2): Required, length 5, position 32-36.
Block Count: Required, length 5, position 37-41.
Total of Status Code DA: Applicable, length 5, position 42-46.
Reserved: Applicable, length 5, position 47-51.
Total of Status Code 11: Applicable, length 5, position 52-56.
Total of Status Code 13: Applicable, length 5, position 57-61.
Total of Status Code 61: Applicable, length 5, position 62-66.
Total of Status Code 62: Applicable, length 5, position 67-71.
Total of Status Code 63: Applicable, length 5, position 72-76.
Total of Status Code 64: Applicable, length 5, position 77-81.
Total of Status Code 65: Applicable, length 5, position 82-86.
Total of Status Code 71: Applicable, length 5, position 87-91.
Total of Status Code 78: Applicable, length 5, position 92-96.
Total of Status Code 80: Applicable, length 5, position 97-101.
Total of Status Code 82: Applicable, length 5, position 102-106.
Total of Status Code 83: Applicable, length 5, position 107-111.
Total of Status Code 84: Applicable, length 5, position 112-116.
Total of Status Code 88: Applicable, length 5, position 117-121.
Total of Status Code 89: Applicable, length 5, position 122-126.
Total of Status Code 93: Applicable, length 5, position 127-131.
Total of Status Code 94: Applicable, length 5, position 132-136.
Total of Status Code 95: Applicable, length 5, position 137-141.
Total of Status Code 96: Applicable, length 5, position 142-146.
Total of Status Code 97: Applicable, length 5, position 147-151.
Total of ECOA Code Z (All Segments): Applicable, length 5, position 152-156.
Total Employment Segments: Applicable, length 5, position 157-161.
Total Original Creditor Segments: Applicable, length 5, position 162-166.
Total Purchased From/Sold To Segments: Applicable, length 5, position 167-171.
Total Mortgage Information Segments: Applicable, length 5, position 172-176.
Total Specialized Payment Information Segments: Applicable, length 5, position 177-181.
Total Change Segments: Applicable, length 5, position 182-186.
Total Social Security Numbers (All Segments): Applicable, length 5, position 187-191.
Total Social Security Numbers (Base Segments): Applicable, length 5, position 192-196.
Total Social Security Numbers (J1 Segments): Applicable, length 5, position 197-201.
Total Social Security Numbers (J2 Segments): Applicable, length 5, position 202-206.
Total Dates of Birth (All Segments): Applicable, length 5, position 207-211.
Total Dates of Birth (Base Segments): Applicable, length 5, position 212-216.
Total Dates of Birth (J1 Segments): Applicable, length 5, position 217-221.
Total Dates of Birth (J2 Segments): Applicable, length 5, position 222-226.
Total Telephone Numbers (All Segments): Applicable, length 5, position 227-231.
Reserved: Applicable, length 135, position 232-366.

the numbers for these fields in the Trailer Record are calculated based on data from the base segment and any associated consumer or account segments. The base segment contains the primary account information, and the totals in the Trailer Record reflect aggregated data across various categories, including status codes, segment counts, and demographic information.

For instance:

Total of Status Code DA through Total of Status Code 97 are aggregates of accounts or segments within those specific status categories across the entire file, including the base segment and any associated segments.
Total Employment Segments, Total Original Creditor Segments, Total Purchased From/Sold To Segments, etc., represent the counts of these specific types of segments that were included in the file.
Total Social Security Numbers and Total Dates of Birth reflect the count of these demographic details as reported in all segments, including the base and joint segments (J1, J2).

These totals are crucial for validating the integrity of the data file, ensuring that all reported segments and their corresponding details are accurately accounted for and summarized in the Trailer Record. This facilitates the processing and analysis of the Metro 2 data by credit reporting agencies and other data recipients, ensuring consistency and reliability in credit reporting.

Total of Status Code DA: This field represents the total count of accounts reported with the status code DA (Deleted Account). It is calculated by summing up all accounts within the file that have been flagged as deleted. This helps in tracking the number of deletions that occurred in the reporting period.
Reserved: This space is set aside for future use or specific implementations that may require additional data not covered by the current Metro 2 specifications. It is not calculated but reserved for potential future requirements. Its presence ensures flexibility for expanding the data format.
Total of Status Code 11: Counts the total number of accounts with the status code 11, indicating accounts that are current and in good standing. It is calculated by aggregating all accounts marked with this status code across the file. This status is crucial for assessing the overall creditworthiness reflected in the report.
Total of Status Code 13: Reflects the total count of accounts with status code 13, signifying paid accounts. It sums up all such accounts to provide insights into the number of accounts settled or closed by payment. This field highlights successful credit resolutions.
Total of Status Code 61: Represents the total number of accounts marked with status code 61, indicating customers who are paying under a partial payment agreement. It is calculated by totaling all accounts with this designation, showcasing accommodations made for borrowers.
Total of Status Code 62: Tallies accounts with status code 62, representing accounts in forbearance. The calculation involves summing accounts under forbearance agreements, indicating temporary suspension or reduction of payments.
Total of Status Code 63: Counts accounts designated with status code 63, which are in deferment. This total reflects the number of accounts for which payments are temporarily postponed under agreed terms.
Total of Status Code 64: Aggregates accounts with status code 64, showing accounts paid through insurance. It involves counting all accounts settled or being paid via insurance claims, indicating risk mitigation through insurance.
Total of Status Code 65: Represents the total accounts with status code 65, indicating accounts settled for less than the full balance. It sums up accounts where a creditor agrees to accept a lower amount as full payment, often used in debt settlement processes.
Total of Status Code 71: Tallies the total number of accounts with status code 71, denoting accounts closed at the consumer's request. It is calculated by summing all such accounts, reflecting consumer-initiated account closures.
Total of Status Code 78: Counts the total accounts with status code 78, which are accounts subject to garnishment. It aggregates the number of accounts where wages or assets are being garnished due to a judgment.
Total of Status Code 80: Represents accounts with status code 80, indicating repossessions. This total is calculated by counting all repossessed accounts, signifying creditor seizure of collateral.
Total of Status Code 82: Tallies accounts with status code 82, signifying accounts transferred to an internal or external collections department. It sums up accounts marked as in collections, reflecting accounts in recovery processes.
Total of Status Code 83: Counts the total number of accounts with status code 83, indicating accounts charged off to loss. It is calculated by aggregating all accounts written off by the creditor as uncollectible.
Total of Status Code 84: Represents the total accounts with status code 84, denoting accounts voluntarily surrendered. This total includes accounts where the consumer has voluntarily returned the collateral.
Total of Status Code 88: Reflects the total number of accounts with status code 88, indicating pre-foreclosure accounts. It sums up accounts in the process leading up to foreclosure, showcasing financial distress.
Total of Status Code 89: Tallies the total accounts with status code 89, signifying accounts in foreclosure. It involves counting all accounts undergoing the foreclosure process, indicating severe delinquency.
Total of Status Code 93: Represents the total number of accounts with status code 93, indicating accounts affected by natural or declared disasters. It sums up such accounts, reflecting external impacts on credit obligations.
Total of Status Code 94: Counts the total accounts with status code 94, which are accounts in a relief situation due to a declared disaster. This total aggregates accounts receiving special considerations due to disaster declarations.
Total of Status Code 95: Tallies accounts with status code 95, indicating accounts with a government claim or insurance claim pending. It is calculated by summing accounts awaiting claim resolutions, often related to FHA or VA loans.
Total of Status Code 96: Represents the total number of accounts with status code 96, denoting accounts with a government claim settled for less than the full balance. It sums up such accounts, indicating settled claims on government-backed loans.
Total of Status Code 97: Counts the total accounts with status code 97, signifying accounts with insurance claims paid. It involves aggregating accounts where insurance claims have been settled, often indicating resolution of protected debts.