1. Metro II Data Preparation & Reporting
  2. Data Preparation for Reporting

4 Data Preparation for Reporting

As part of daily execution of the batch ‘CBUUTL_BJ_100_02 (SET-ODD2)’, system populates the database table ‘METRO_II_DATA’ with the account details required for reporting.

Due to some reason if this batch is not executed for few days in a month, while running it during the month end date, system automatically includes the accounts which are missing due to the non-execution of batch.

Below table explains the data population logic for each of the METRO_II_DATA table columns.

Table 4-1 Data Preparation for Reporting

Metro II Field # Metro II File Field Name METRO_II_DATA Table Field Name Data Population Logic in METRO_II_DATA Table Fields
Header Segment
0 Block Descriptor Word (BDW) NA This field is not required when reporting fixed length, fixed block records.
1 Record Descriptor Word (RDW) NA This field contains a value equal to the length of the physical record.
2 Record Identifier NA Constant value ‘HEADER’
3 Cycle Identifier NA

Calendar day of the month taken from the system parameter ‘CMN_GL_POST_DT’

E.g. If GL post date is 13/06/2016 (mm/dd/yyyy) then Cycle identifier field value is 13
4 Innovis Program Identifier NA This field is currently not supported. Filled with 10 blank spaces
5 Equifax Program Identifier NA Taken from Setup→ Credit Bureau→Reporting →Program Identifier configuration for the credit bureau code ‘EFX’
6 Experian Program Identifier NA Taken from Setup→ Credit Bureau→Reporting →Program Identifier configuration for the credit bureau code ‘EXP’
7 TransUnion Program Identifier NA Taken from Setup→ Credit Bureau→Reporting →Program Identifier configuration for the credit bureau code ‘TUC’
8 Activity Date NA This field is populated with latest MET_PROCESSED_DATE of an account with MET_RECORD_STATUS_CODE having the value ‘R’, which is the date on which the account was picked up and processed for the current reporting period i.e. populated into METRO_II_DATA table.
9 Date Created NA Date taken from the system parameter ‘CMN_GL_POST_DT’
10 Program Date NA Metro II Functionality release date in MMDDYYYY format
11 Program Revision Date NA Metro II Functionality revision release date in MMDDYYYY format
12 Reporter Name NA Taken from Setup→ Companies→Company Definition →Company
13 Reporter Address NA Taken from Setup→ Companies→Company Definition →Company Address, City, State and Zip code
14 Reporter Telephone Number NA Taken from Setup→ Companies→Company Definition → Remittance Address→ Phone 1
15 Software Vendor Name NA Constant ‘ORACLE FINANCIAL SERVICES SOFTWARE’
16 Software Version Number NA Current value is ‘1.0’
17 MicroBilt/PRBC Program Identifier NA This is not supported at present
18 Reserved NA Blank spaces
Base Segment
0 Block Descriptor Word (BDW) NA  
1 Record Descriptor Word (RDW) NA Taken from Setup→ Administration→ System→ Lookups→ CBU_FILE_FORMAT_CD
2 Processing Indicator MET_BASE_PROCESS_IND Constant ‘1’
3 Time Stamp MET_BASE_TIMESTAMP

SYSDATE(The time when the batch job cbuutl_bj_100_03 was executed)

If account is voided, it will stamp the system date.
4 Correction Indicator MET_BASE_CORRECTION_IND Constant ‘0’ (zero)
5 Identification Number MET_BASE_IDENT_NBR This field contains the concatenated value of company and branch codes (columns ACC_PTC_COMPANY and ACC_PCB_BRANCH) from the ACCOUNTS table
6 Cycle Identifier MET_BASE_CYCLE_IDENT

Calendar day of the month taken from the system parameter ‘CMN_GL_POST_DT’

E.g. If GL post date is 13/06/2016 (mm/dd/yyyy) then Cycle identifier field value is 13
7 Consumer Account Number MET_BASE_CONSUMER_ACC_NBR Account number. i.e. ACCOUNTS.ACC_NBR
8 Portfolio Type MET_BASE_PORTFOLIO_TYPE

Credit bureau portfolio type code of the ‘Product’ selected for the account. Linkage between product portfolio type code and ‘Portfolio Type’ code in Metro Ii file is maintained as part of the lookup code CRB_PORTFOLIO_TYPE_CD

E.g. In case of instalment loans this value will be reported as ‘I’
9 Account Type MET_BASE_ACCOUNT_TYPE Credit bureau account type code of the ‘Product’ selected for the account. Metro II specific account type codes are maintained under the lookup code ‘CRB_ACC_TYPE_CD’
10 Date Opened MET_BASE_DT_OPENED Effective date of the account in MMDDYYYY format. Taken from ACCOUNTS.ACC_EFFECTIVE_DT
11 Credit Limit MET_BASE_CREDIT_LIMIT Original loan/lease amount in whole dollars. Taken from ACCOUNTS.ACC_CR_LMT_CUR
12 Highest Credit or Original Loan Amount MET_BASE_HIGHEST_CREDIT_LIMIT

Highest credit limit or Original Loan/lease amount. Taken from ACCOUNTS.ACC_CRB_HIGHEST_BAL_AMT

In case of lease:

If the account Calculation Method is ‘Rent Factor’ – then reports with ‘Depreciation Value’

If the account Calculation Method is ‘Interest Rate’ and

If Lease Type is ‘Operating’ – reports with ‘Depreciation Value’

If Lease Type is ‘Direct Finance’ – reports with ‘Adjusted Capitalized Cost’.

Post termination with buyout indicator ‘Y’, reports it with current ‘Adjusted Capitalized Cost’
13 Terms Duration MET_BASE_TERMS_DURATION
If Portfolio type =
  • C, then reports ‘LOC’
  • O, then reports ‘O’
  • R, then reports ‘REV’

Other than C/O/R, then system derive total Term of the account is sum of ACCOUNTS.ACC_TERM_CUR + ACC_EXTN_TERM_LIFE.

If the cycle is
  • 'Weekly' - value is Total Term *4.33
  • 'Bi Weekly' - value is Total Term *2.16
  • 'Semi Monthly' - value is Total Term *2
  • 'Bi Monthly' - Value is Total Term /2
  • 'Quarterly' - Value is Total Term /3
  • 'Tri Annually' - Value is Total Term /4
  • 'Semi Annually' - Value is Total Term /6
  • 'Annually' - Value is Total Term /12
  • 'Monthly' - value is Total Term
14 Terms Frequency MET_BASE_TERMS_FREQUENCY

Account billing frequency as per the below mentioned CDIA codes. Taken form ACCOUNTS. ACC_BILL_CYCLE_CD.

P = Single Payment Loan

W = Weekly

B = Biweekly

E = Semi-monthly

M = Monthly

L = Bimonthly

Q = Quarterly

T = Tri-annually

S = Semi-annually

Y = Annually

Note: Code ‘D’ (Deferred) is not supported.

15 Scheduled Monthly Payment Amount MET_BASE_SCHEDULED_PMT_AMT

Whole dollar amount of the scheduled last monthly payment due for this reporting period, whether principal, interest only or a combination of the two.

System applies the following logic while deriving the monthly payment value. If Billing Cycle is:

'Single Payment' - value is '0'

'Weekly' - value is current payment amount *4.33

'Bi Weekly' - value is current payment amount*2.16

'Semi Monthly' - value is current payment amount*2

'Bi Monthly' - Value is current payment amount/2

'Quarterly' - Value is current payment amount/3

'Tri Annually' - Value is current payment amount/4

'Semi Annually' - Value is current payment amount/6

'Annually' - Value is current payment amount/12

'Monthly' - value is current payment amount

if result of this coming less than ZERO, then this value will be '0'

also, reports zero (0) for account status 13/61/62/63/64/65/97
16 Actual Payment Amount MET_BASE_ACT_PMT_AMT

Total payments received on the account till account was picked up for reporting (meaning moved to METRO_II_DATA table)

System considers PAYMENT_NON_CASH & Payment good transactions
17A Account Status MET_BASE_ACCOUNT_STATUS Please refer Appendix : Handling Metro II Account Statuses for details.
17B Payment Rating MET_BASE_PMT_RATING

Please refer Appendix : Payment Rating Code Derivation for details.

Cumulative payment rating code is stored in ACCOUNTS. ACC_CRB_PMT_RATING_CD
18 Payment History Profile MET_BASE_PMT_HISTORY_PROFILE

System reports the 24 months payment history profile based on the account status and payment rating. Taken from ACCOUNTS. ACC_CRB_FULL_PMT_HISTORY

If the Account Status (Field 17A) has been reported with status 89, this field is also reported with complete 24 months payment history for the first time.

In subsequent months (2nd time, if system reports with status 89), the entire Payment History Profile is reported blank.

E – if portfolio types 'C' ,'O' and 'R'

Please refer the following sections for more details-

Appendix : Handling Metro II Account Statuses

Appendix : Payment Rating Code Derivation
19 Special Comment MET_BASE_SPECIAL_COMMENT Please refer Appendix : Handling Metro II Special Comment Codes for details.
20 Compliance Condition Code MET_BASE_COMPLIANCE_COND_CODE Please refer Appendix : Handling Metro II Compliance Condition Code for details.
21 Current Balance MET_BASE_CUR_BALANCE

If the account status is 'Charged-Off' then system reports the deficiency amount-ACCOUNTS.ACC_DEFICIENCY_AMT

If account accrual calculation method is 'Sum of Digits/Actuarial - Monthly' then system reports the difference of 'Payoff Amount - Current Balance'. Here Current balance = Opening + Posted - Paid - Waived - Charged Off + Adj Plus Bal - Adj Minus Bal (all balances are including 'Fee and Expenses')

In case of all other Accrual Methods, system will report the reports the total outstanding amount i.e. ACCOUNTS.ACC_OUTSTANDING_TOTAL_AMT – Insurance Premium Rebate where auto rebate is ‘Y’

If the account has DIL condition and Account Status is reported with 89, then system reports with Account Outstanding Total Amount.

System reports zero (0) if
  • the amount is less than zero
  • the account is in ‘Not Liable for Payment’ condition
  • If account has DIL and does not have CNL,
  • If account is changed off and paid
  • If account status reported as 13, 61, 62, 63, 64, and 65
  • If the account has CNL condition and Account Status is reported with 89
22 Amount Past Due MET_BASE_AMT_PAST_DUE

System reports the total delinquent amount of the account. Taken from ACCOUNTS. ACC_DUE_DLQ_AMT . Here, system considers the delinquency grace days and deducts the due amount from overall delinquency amount (also, not consider the future dues).

If account is in ‘Not Liable for Payment’ condition, system reports ‘0’.

If account has CNL condition and Account Status has reported as 89, this field continues to report Account Outstanding Total Amount.

If account has DIL and If account does not have CNL, then system reports this field as Zero (0).

If account is changed off and paid, then system report zero (0).
23 Original Charge-off Amount MET_BASE_ORIGINAL_CHGOFF_AMT System reports the total charged off balance of the account. Taken from ACCOUNTS.ACC_CHGOFF_AMT
24 Date of Account Information MET_BASE_BILLING_DT

System reports the effective date of last billing date. Taken from ACCOUNTS. ACC_DDT_RUN_DT_LAST

If account is changed off and paid, then system reports Last Payment Date

If account is voided, system reports void date
25 FCRA Compliance/ Date of First Delinquency MET_BASE_FRCA_COMPLIANCE_DT

System reports the date on which the account went delinquent for the first time. Taken from

ACCOUNTS.ACC_CRB_FIRST_DLQ_DT. System also does the following validations based on the account status.
  • 11 - system reports the Bankruptcy condition start date, if it is active
  • if account status is13 and 'Payment Rating' is '0' system reports 'Null'
  • if account status is reported as 96/61, system reports REPO condition start date
26 Date Closed MET_BASE_DT_CLOSED

System reports the date on which account was closed. Taken from ACCOUNTS. ACC_CLOSE_DT.

If the account is closed with manual or system controlled 'Account Close' transaction, system updates the ACCOUNTS. ACC_OPEN_IND with 'N' and updates the ACC_CLOSE_DT. If the 'Account Open Indicator' is
  • 'Y' then 'Date Closed' will be reported as 'NULL'
  • 'N' then 'Date Closed' will be reported as 'ACC_CLOSE_DT'

If account has active Voluntary Repossession then, system reports ‘Repo’ condition start date.

If account has DIL condition:
  • If Account Outstanding Total Amount is greater than zero or account has active CNL condition, then system reports this field with DIL condition’s start date.
  • If Account Outstanding Total Amount is less than or equal to zero, then system reports this field with Account Paid off Date.
If account is changed off and paid, then system report
  • For Instalment and Mortgage accounts (Portfolio type codes I & M), zero fill.
  • For Revolving, Open and Line of Credit accounts (Portfolio type code R, O and C), if the account is closed, report the date the account was closed to further purchases.
  • Otherwise, zero fill.
27 Date of Last Payment MET_BASE_LAST_PMT_DT System reports the date on which last payment was received. Taken from ACCOUNTS.ACC_PMT_DT_LAST
28 Interest Type Indicator MET_BASE_INT_IND

Taken from METRO_II_DATA.MET_BASE_INT_IND FIELD

As part of Metro II data population batch run, system will populate this field either with ‘F’ or ‘V’ based on:
  • If the account’s ACC_INDEX_TYPE_CD value is ‘FL’, interest type indicator value will be ‘F’ (Fixed)
  • If the account’s ACC_INDEX_TYPE_CD value is ‘PR’, interest type indicator value will be ‘V’ (Variable)
28A Reserved MET_BASE_RESERVED Blank space fill
29 Consumer Transaction Type MET_BASE_CONSUMER_TXN_TYPE Deprecated hence Blank space fill
30 Surname MET_BASE_SURNAME System reports the last name of the ‘PRIMARY’ customer of the account. Taken from CUSTOMERS.CUS_LAST_NAME
31 First Name MET_BASE_FIRST_NAME System reports the first name of the ‘PRIMARY’ customer of the account. Taken from CUSTOMERS. CUS_FIRST_NAME
32 Middle Name MET_BASE_MIDDLE_NAME System reports the middle name of the ‘PRIMARY’ customer of the account. Taken from CUSTOMERS. CUS_MIDDLE_NAME
33 Generation Code MET_BASE_GENERATION_CODE System reports the generation code of the ‘PRIMARY’ customer of the account. Taken from CUSTOMERS. CUS_GENERATION_CD
34 Social Security Number MET_BASE_SSN System reports primary customer SSN. Taken from CUSTOMERS.CUS_SSN
35 Date of Birth MET_BASE_BIRTH_DT System reports primary customer date of birth. Taken from CUSTOMERS. CUS_BIRTH_DT
36 Telephone Number MET_BASE_TELEPHONE_NUMBER System reports primary customer telephone number. Taken from ADDRESS. ADR_PHONE
37 ECOA Code MET_BASE_ECOA_CODE

System reports the ECOA code of the primary customer. Taken from CUS_ACC_RELATIONS.CAR_CRB_ECOA_CD.

ECOA codes can be created using the lookup ‘CRB_ECOA_CD’.

ECOA code of the applicant is passed to the account initially from the origination data.

Following are the methods using which user can update the ECOA code of the primary account holder:

Select the required ‘CRB ECOA CODE’ (ECOA Codes provided by CDIA) while posting the non-monetary transaction ‘CUS_MAINT’.

In case any of the account relation is deceased; same can be marked on the account by posting the non-monetary transaction ’CUS_DECEASE_MAINT’. This will update the ECOA code of the customer and same will be reported as ‘X’ in the Metro II file.

While posting ’CUS_DECEASE_MAINT’ non-monetary transaction for primary, user can select the existing relation on that account to make it as primary. If user selects it, then system will mark the selected customer relation to ‘Primary’ and ECOA code as ‘1’.

If there is only two relations exists on the account (including primary), then While posting ’CUS_DECEASE_MAINT’ non-monetary transaction for primary system will automatically makes the other relation as primary and updates the ECOA code to ‘1’.
38 Consumer Information Indicator MET_BASE_CIIC

Please refer -

Appendix : Metro II Bankruptcy Status Posting for Primary Customer

Appendix : Metro II Bankruptcy Status Posting for Non-Primary Customer(s)
39 Country Code MET_BASE_COUNTRY_CODE System reports primary customer country code. Taken from ADDRESS. ADR_COUNTRY_CD
40 First Line of Address MET_BASE_ADDRESS_LINE1 System reports primary customer address first line. Taken from ADDRESS. ADR_ADDRESS1
41 Second Line of Address MET_BASE_ADDRESS_LINE2 System reports primary customer address second line. Taken from ADDRESS. ADR_ADDRESS2
42 City MET_BASE_CITY System reports primary customer address state code. Taken from ADDRESS. ADR_CITY
43 State MET_BASE_STATE System reports primary customer address state code. Taken from ADDRESS. ADR_STATE_CD
44 Postal/Zip Code MET_BASE_POSTAL_CODE System reports primary customer address zip code. Taken from ADDRESS. ADR_ZIP
45 Address Indicator MET_BASE_ADDRESS_IND System reports primary customer address confirmed indicator as ‘Y’ (Known to be address of primary consumer). Taken from ADDRESS. ADR_CONFIRMED_IND
46 Residence Code MET_BASE_RESIDENCE_CODE Filled with single space

Note: If length of the customer address (say, MET_BASE_ADDRESS_LINE1 holds more than 32 characters) is not fitting in address line 1, system will display remaining address in the address line 2

Say, MET_BASE_ADDRESS_LINE1 has 40 characters, then First Line of Address will reported with 32 characters and Second Line of Address will reported with remaining 8 characters

When accounts are voided, system will insert the data in Metro_II_data table instantly if at all the account is reported at least once in previous cycle.

J1 Segment (Associated Consumer — Same Address)

OFSLL generates a maximum of four J1 segments (J1_1, J1_2, J1_3 and J1_4) for the account relation participants in the following order –

Spouse

Secondary

Co-Signer

Co-Signer Spouse

Co-Signer 2

Co-Signer2 Spouse

This means even if more than four account relation details are modified at a time, system will report only the first four in the order mentioned above.

  • If the non-primary customer relations having same address as Primary [which is reported in Base], then while executing the SET-ODD2 > CBUUTL_BJ_100_02 batch job system has to create the above new fields data as per the stated guild lines in below tables

    The check here is, if at all ‘First Line of Address’, ‘Second Line of Address’, City, State, and ZIP is exactly equal b/w non primary and primary, then only system should report it in J1 segment and stop populating data in J2 segment

    Note:
    • System will do convert into upper case and compare the address information
    • Current address derivation from Accounts to Metro ii should remain same to compare
    • Any special characters, spaces which leads to not equal, then it will treat it as ‘different address’ and report in J2.
1 Segment Identifier MET_J1_1_SEGMENT_ID Constant ‘J2’
2 Reserved MET_J1_1_RESERVED1 Filled with single space
3 Surname MET_J1_1_SURNAME System reports the last name of the Non-Primary customer (as explained above) of the account. Taken from CUSTOMERS.CUS_LAST_NAME
4 First Name MET_J1_1_FIRST_NAME System reports the first name of the Non-Primary customer (as explained above) of the account. Taken from CUSTOMERS. CUS_FIRST_NAME
5 Middle Name MET_J1_1_MIDDLE_NAME System reports the middle name of the Non-Primary customer (as explained above) of account. Taken from CUSTOMERS. CUS_MIDDLE_NAME
6 Generation Code MET_J1_1_GENERATION_CODE System reports the generation code of the Non-Primary customer (as explained above) of the account. Taken from CUSTOMERS. CUS_GENERATION_CD
7 Social Security Number MET_J1_1_SSN System reports Non-Primary customer (as explained above) SSN. Taken from CUSTOMERS.CUS_SSN
8 Date of Birth MET_J1_1_BIRTH_DT System reports Non-primary customer (as explained above) date of birth. Taken from CUSTOMERS. CUS_BIRTH_DT
9 Telephone Number MET_J1_1_TELEPHONE_NUMBER System reports Non-primary customer (as explained above) telephone number. Taken from ADDRESS. ADR_PHONE
10 ECOA Code MET_J1_1_ECOA_CODE

System reports the ECOA code of the Non-primary customer (as explained above). Taken from ACCOUNTS. ACC_JOINT_IND.

ECOA codes can be created using the lookup ‘CRB_ECOA_CD’.
11 Consumer Information Indicator MET_J1_1_CIIC

Please refer -

Appendix : Metro II Bankruptcy Status Posting for Primary Customer

Appendix : Metro II Bankruptcy Status Posting for Non-Primary Customer(s)
12 Reserved MET_J1_1_RESERVED2 Filled with single space
J2 SEGMENT (Associated Consumer — Different Address)

OFSLL generates a maximum of four J2 segments (J2_1, J2_2, J2_3 and J2_4) for the account relation participants in the following order –

Spouse

Secondary

Co-Signer

Co-Signer Spouse

Co-Signer 2

Co-Signer2 Spouse

This means even if more than four account relation details are modified at a time, system will report only the first four in the order mentioned above.
1 Segment Identifier MET_J2_1_SEGMENT_ID Constant ‘J2’
2 Consumer Transaction Type MET_J2_1_CONSUMER_TXN_TYPE Deprecated hence Blank space fill
3 Surname MET_J2_1_SURNAME System reports the last name of the Non-Primary customer (as explained above) of the account. Taken from CUSTOMERS.CUS_LAST_NAME
4 First Name MET_J2_1_FIRST_NAME System reports the first name of the Non-Primary customer (as explained above) of the account. Taken from CUSTOMERS. CUS_FIRST_NAME
5 Middle Name MET_J2_1_MIDDLE_NAME System reports the middle name of the Non-Primary customer (as explained above) of account. Taken from CUSTOMERS. CUS_MIDDLE_NAME
6 Generation Code MET_J2_1_GENERATION_CODE System reports the generation code of the Non-Primary customer (as explained above) of the account. Taken from CUSTOMERS. CUS_GENERATION_CD
7 Social Security Number MET_J2_1_SSN System reports Non-Primary customer (as explained above) SSN. Taken from CUSTOMERS.CUS_SSN
8 Date of Birth MET_J2_1_BIRTH_DT System reports Non-primary customer (as explained above) date of birth. Taken from CUSTOMERS. CUS_BIRTH_DT
9 Telephone Number MET_J2_1_TELEPHONE_NUMBER System reports Non-primary customer (as explained above) telephone number. Taken from ADDRESS. ADR_PHONE
10 ECOA Code MET_J2_1_ECOA_CODE

System reports the ECOA code of the Non-primary customer (as explained above). Taken from ACCOUNTS. ACC_JOINT_IND.

ECOA codes can be created using the lookup ‘CRB_ECOA_CD’.
11 Consumer Information Indicator MET_J2_1_CIIC

Please refer -

Appendix : Metro II Bankruptcy Status Posting for Primary Customer

Appendix : Metro II Bankruptcy Status Posting for Non-Primary Customer(s)
12 Country Code MET_J2_1_COUNTRY_CODE System reports Non-primary customer (as explained above) country code. Taken from ADDRESS. ADR_COUNTRY_CD
13 First Line of Address MET_J2_1_ADDRESS_LINE1 System reports Non-primary (as explained above) customer address first line. Taken from ADDRESS. ADR_ADDRESS1
14 Second Line of Address MET_J2_1_ADDRESS_LINE2 System reports Non-primary customer (as explained above) address second line. Taken from ADDRESS. ADR_ADDRESS2
15 City MET_J2_1_CITY System reports Non-primary customer (as explained above) address state code. Taken from ADDRESS. ADR_CITY
16 State MET_J2_1_STATE System reports Non-primary customer (as explained above) address state code. Taken from ADDRESS. ADR_STATE_CD
17 Postal/Zip Code MET_J2_1_POSTAL_CODE System reports Non-primary customer (as explained above) address zip code. Taken from ADDRESS. ADR_ZIP
18 Address Indicator MET_J2_1_ADDRESS_IND System reports Non-primary customer (as explained above) address confirmed indicator as ‘Y’ (Known to be address of primary consumer). Taken from ADDRESS. ADR_CONFIRMED_IND
19 Residence Code MET_J2_1_RESIDENCE_CODE Blank fill
20 Reserved MET_J2_1_RESERVED Filled with single space
Note: In base/J1/J2 segments, except for hyphens, system replaces all other special characters present in Surname/Middle Name/First Name fields with space.

Say, customer name = JOAN! DEO, then report JOAN DEO (i.e., reports with two spaces)
K2 Segment Purchased From/Sold To
1 Segment Identifier MET_K2_SEGMENT_ID constant value K2
2 Purchased From/Sold To Indicator MET_K2_PURCHASED_FROM_IND

1 = If an account has 'Purchase From' data

2 = If an account is marked as SOLD (i.e., ACC_POOL_ACC_STATUS_CD=S)

9 = If the system reported either 1 or 2 in the previous reporting and current reporting if ACC_POOL_ACC_STATUS_CD != S, or Purchase from data is removed

3 Purchased From or Sold To Name MET_K2_PURCHASED_FROM

If field 2 = 9, this field will be blank-filled.

If field 2 = 1, then this field will be filled with 'Purchase From' data If field 2 = 2, then this field will be filled with ‘Owner’ data from Servicing > Securitization > Pool Inquiry > Pools > View > Owner

4 Reserved MET_K2_RESERVED Blank fill with one space
K4 Segment (Specialized Payment Information)
1 Segment Identifier MET_K4_SEGMENT_ID constant value K4
2 Specialized Payment Indicator MET_K4_SPL_PMT_IND

System reports 02, if account has special condition like ‘Deferred Payment’ or ‘Forbearance’

Reports 01, if account has balloon amount
3 Deferred Payment Start Date MET_K4_DEFERRED_PMT_START_DT System reports the applicable condition start date on that account.
4 Balloon Payment Due Date MET_K4_BALLOON_PAY_DUE_DT If account has a Balloon Amount, Reports account maturity date
5 Balloon Payment Amount MET_K4_BALLOON_PAY_AMT

If Balloon Amount is greater than 0 it reports it.

ACC_BALLOON_AMT
6 Reserved NA Blank fill with one space
Note: Both deferred payment & Balloon amounts will not report together.
L1 SEGMENT (Account Number/Identification Number Change)
1 Segment Identifier MET_L1_SEGMENT_ID Constant ‘L1’
2 Change Indicator MET_L1_CHANGE_IND Constant ‘3’
3 New Consumer Account Number MET_L1_NEW_CONSUMER_ACC_NBR This field is applicable only in case of a converted account. System reports the old account number (assigned by the previous system). Taken from ACCOUNTS. ACC_ORIG_SYS_XREF
4 New Identification Number MET_L1_NEW_IDENT_NBR This field contains the concatenated value of company and branch codes (columns ACC_PTC_COMPANY and ACC_PCB_BRANCH) from the ACCOUNTS table
5 Reserved MET_L1_RESERVED Blank fill with single space