Docstoc

Instructions - FDIC

Document Sample
Instructions - FDIC Powered By Docstoc
					                                                                                                           FDIC Asset ID Request Form

Column   Field # Field                                  Description                                                            Type        Comments                            Required Field Allowable Values               Formatting Req.   Width
                                                                                                                                                                                              SFR = Single Family
                                                                                                                                                                                              (Schedule 4.15A); NSF = Non-
                                                                                                                                                                                              Single Family (Schedule
  A        1     Loss Share Type                        Indicates the type of loss share coverage                           Alphanumeric   Drop down box                      Yes             4.15B)                                             3
                                                        Recorded on Schedule 4.15 provided by the FDIC. Asset type
                                                        category assigned by FDIC at time of closing.                                                                                         09 = Fully Charged Off
                                                                                                                                                                                              Assets; 15 = Non-Single
  B        2     Asset Type                             See Drop down selection                                             Alphanumeric   Automate based on Portfolio type Yes               Family; 32 = Single Family     99                  2
                                                        Recorded on Schedule 4.15 provided by the FDIC. Asset sub type                                                                        00009 = Fully Charged Off
                                                        category assigned by FDIC at time of closing.                                                                                         Assets; 00015 = Non-Single
                                                                                                                                                                                              Family; 00032 = Single
  C        3     Asset Sub Type Code                    See Drop down selection                                             Alphanumeric   Automate based on Portfolio type Yes               Family                         99999               5

                                                        Recorded on Schedule 4.15 provided by the FDIC which identifies                    Assigned on the Schedule 4.15
  D        4     Original FDIC Asset ID                 the Asset as "Approved" for Loss Share coverage.                    Alphanumeric   by the FDIC                        Yes                                            999999999999        12
                                                                                                                                           The Bank's internal loan number
                                                                                                                                           which corresponds to the FDIC
                                                                                                                                           Asset ID# recorded on Schedule
  E        5     Original Bank Historical Number        Recorded on Schedule 4.15 provided by the FDIC.                     Alphanumeric   4.15                            Yes                                                                   30
                                                                                                                                           The Bank's new assigned internal
                                                                                                                                           loan number which will
                                                                                                                                           correspond to the "Requested"
                                                                                                                                           FDIC Asset ID# that will be
  F        6     Linked Loan Number                     New AI Assigned Internal Loan identifier                            Alphanumeric   provided in Field 13.            Yes                                                                  30
  G        7     Asset Name                             Asset Name listed on Schedule 4.15A or 4.15B                        Alphanumeric                                      Yes                                                                50
                 Current Outstanding Unpaid Principal   As of most recent reporting period, outstanding principal balance
  H        8     Balance                                reported, Net of Participations                                       Numeric                                         Yes                                            9(12).99            15
                 Current Outstanding Unfunded           As of most recent reporting period, outstanding unfunded amounts,
  I        9     amounts                                Net of Participations                                                 Numeric                                         Yes                                            9(12).99            15
                                                                                                                                           Add policy rules for how balance
                                                                                                                                           must relate to original and current
                 Linked Account Loan Current         New Outstanding Unpaid Principal Balance or Balance                                   UPB + unfunded for each asset
  J        10    Outstanding Unpaid Principal        Outstanding, Net of Participations                                       Numeric      ID change type                      Yes                                           9(12).99            15
                                                     Unfunded Commitment Amount assigned to the new linked Loan in
                 Linked Account Outstanding Unfunded conjunction with the funded amount listed in Field 'N', Net of                        Not to exceed Amount listed in
  K        11    amounts                             Participations                                                           Numeric      Field 'L'.                         Yes                                            9(12).99            15


                                                                                                                                                                                              6 = Bifurcation; 7 =
                                                                                                                                                                                              Consolidation; 8 = Unfunded
                                                                                                                                                                                              Commitment/Permitted
                                                                                                                                                                                              Advance; 9 = Fully Charged
                                                                                                                                                                                              Off Assets; N = Not
                                                        Indicates reason for FDIC Asset ID request. Only one transaction                                                                      Applicable (Used to track
  L        12    Transaction Type                       type per form is allowed.                                           Alphanumeric                                      Yes             Original Note)                 9                   1
                                                        FDIC Asset ID to be Assigned by FDIC. FDIC will provide a
                                                        generated FDIC Asset ID in cases where there has been an new                       Asset ID assignment approved by
                                                        accounts due to bifurcation, unfunded commitment/permitted                         Specialist and Assigned by the
  M        13    Generated FDIC Asset ID                advance, or fully charged off assets                                Alphanumeric   FDIC's Data Aggregator.         Yes                                               999999999999        34
  N        14    Comments                               Additional comments to support reason for asset ID request          Alphanumeric                                      No                                                                300
FDIC Asset ID Request Form
Data Validations

Column     Field # Field                                                  Validation Criteria                                                                                    Error or Warning
    A         1     Loss Share Type                                       Must be populated.                                                                                    Error
                                                                          Must be populated for all lines with a Transaction Type code of 6 or 8. Field will be blank for new
                                                                          linked account created during consolidation (Transaction Type 7). Field will be blank for
    B         2     Asset Type                                            Transaction Type of 9.                                                                                Error
                                                                          Must be populated for all lines with a Transaction Type code of 6 or 8. Field will be blank for new
                                                                          linked account created during consolidation (Transaction Type 7). Field will be blank for
    C         3     Asset Sub Type Code                                   Transaction Type of 9.                                                                                Error

                                                                          Must be populated for all lines with a Transaction Type code of 6, 7 or 8 (see Examples). Field will
    D         4     Original FDIC Asset ID                                be populated with either a zero or the Original loan number for a Transaction Type code 9.           Error

                                                                          Must be populated for all lines with a Transaction Type code of 6, 7 or 8 (see Examples). Field will
    E         5     Original Bank Historical Number                       be populated with either a zero or the Original loan number for a Transaction Type code 9.           Error
                                                                          Must be populated for all lines with a Transaction Type code of 6, 7 or 8. Field will be blank when
                                                                          Transaction Type equals N for the Original Asset ID#. Field will be equal to zero or duplicate the
    F         6     Linked Loan Number                                    Original Bank Historical Number in "Field E" for a Transaction Type code 9.                         Error
    G         7     Asset Name                                            Must be populated.                                                                                    Error
    H         8     Current Outstanding Unpaid Principal Balance          Must be populated. Field will be 0 for Transaction Type of 9.                                         Error
    I         9     Current Outstanding Unfunded amounts                  Must be populated. Field will be 0 for Transaction Type of 9.                                         Error
                    Linked Account Loan Current Outstanding Unpaid
    J         10    Principal                                             Must be populated. Field will be 0 for Transaction Type of 9.                                         Error
    K         11    Linked Account Outstanding Unfunded amounts           Must be populated. Field will be 0 for Transaction Type of 9.                                         Error

                                                                          Must be populated with the following allowable values (Blank or NULL values are not acceptable):
                                                                          6 = Bifurcation; 7 = Consolidation; 8 = Unfunded Commitment/Permitted Advance; 9 = Fully
    L         12    Transaction Type                                      Charged Off Assets; N = Not Applicable (Used to track Original Note)                             Error
    L         12    Transaction Type                                      Must be populated with only a single transaction type per form.                                       Error
    M         13    Generated FDIC Asset ID                               Must not be populated by the AI. This will be provided by the FDIC.                                   Error


Additional Validations: This section provides additional validations that an AI can use to verify each type of transaction. The total UPB and unfunded amounts outstanding for the new loan type
should not exceed the current outstanding UPB and current outstanding unfunded amounts listed. Additional rules may apply based on transaction type.

For lines with a Transaction Type of 6 (Bifurcation) and 8 (Unfunded Commitment/Permitted Advance):

'Current Outstanding Unpaid Principal Balance' plus 'Current Outstanding Unfunded' amounts for account with like 'Original FDIC Asset ID' (do not aggregate the balances if Original FDIC Asset ID
is duplicated on multiple lines) must not be greater than the sum of 'Linked Account Loan Current Outstanding Unpaid Principal' plus 'Linked Account Outstanding Unfunded' amounts for all linked
accounts sharing the same 'Original FDIC Asset ID'. This calculation must result in a amount that is greater or equal to 0.
For lines with a Transaction Type of 7 (Consolidation):

Sum 'Current Outstanding Unpaid Principal Balance' plus 'Current Outstanding Unfunded' amounts for accounts with like 'Linked Loan Number' must be equal to the sum of 'Linked Account Loan
Current Outstanding Unpaid Principal' plus 'Linked Account Outstanding Unfunded' amounts for all linked accounts sharing the same 'Linked Loan Number'. This calculation must result in a amount
that is greater or equal to 0.
12345 - DC Bank              Example 1a: Bifurcation (6) with just one new FDIC Asset ID being generated on a "Friendly Foreclosure*".
     20110731                ABC Bank did a "Friendly Foreclosure" on a 1st mortgage secured by a SFR at a foreclosure sales price of $80,000 (book value of $80,000) but the original ABC Bank 1st mortgage was $100,000. Since ABC Bank was able to negotiate a "Friendly
             1               Foreclosure" with the borrower, the borrower signed an unsecured $10,000 deficiency note with ABC Bank and ABC Bank wrote off the other $10,000 with the borrower being released from personal guaranty. But, ABC Bank wanted to keep the
             6               original bank historical number when it was transferred to a bank REO, so they requested just one new FDIC Asset ID for the new an unsecured $10,000 deficiency note.
                                                                                                                 CURRENT_OUTSTANDI                                              LINKED_ACCOUNT_LOAN_CUR
LOSS_SHARE_ ASSET ASSET_SUB_ ORIGINAL_FDIC_ ORIGINAL_BANK_HIS LINKED_LOAN                                        NG_UNPAID_PRINCIPAL CURRENT_OUTSTANDING_UNF RENT_OUTSTANDING_UNPAID_ LINKED_ACCOUNT_OUTSTANDI                                                                GENERATED_FDIC_A
TYPE        _TYPE TYPE_CODE ASSET_ID              TORICAL_NUMBER           _NUMBER           ASSET_NAME          _BALANCE                   UNDED_AMOUNTS                       PRINCIPAL                         NG_UNFUNDED_AMOUNTS              TRANSACTION_TYPE           SSET_ID          COMMENTS
SF          32    03402      10262000398          9000000176                                 Mr. Smith                            80000.00                                0.00                               0.00                             0.00                          N
SF          32    03450      10262000398          9000000176                 9000000176-1 Mr. Smith                                    0.00                               0.00                           10000.00                             0.00                          6


12345 - DC Bank              Example 1b: Bifurcation (6) with just one new FDIC Asset ID being generated on a "Friendly Deed-In-Lieu Transaction".
     20110731                ABC Bank negotiated a" Friendly Deed-In-Lieu Transaction" on a 1st mortgage secured by a Multifamily Residential Property at a discounted price of $800,000 (book value of $800,000) but the original ABC Bank 1st mortgage was $1,000,000.
             1               Since ABC Bank was able to negotiate a "Friendly Deed-In-Lieu Transaction" with the borrower, the borrower signed an unsecured $100,000 deficiency note with ABC Bank and ABC Bank wrote off the other $100,000 loss with the borrower being
             6               released from personal guaranty. ABC Bank wanted to keep the original bank historical number when it was transferred to a bank REO, so they requested just one new FDIC Asset ID for the new an unsecured $100,000 deficiency note.
                                                                                                                 CURRENT_OUTSTANDI                                              LINKED_ACCOUNT_LOAN_CUR
LOSS_SHARE_ ASSET ASSET_SUB_ ORIGINAL_FDIC_ ORIGINAL_BANK_HIS LINKED_LOAN                                        NG_UNPAID_PRINCIPAL CURRENT_OUTSTANDING_UNF RENT_OUTSTANDING_UNPAID_ LINKED_ACCOUNT_OUTSTANDI                                                              GENERATED_FDIC_A
TYPE        _TYPE TYPE_CODE ASSET_ID            TORICAL_NUMBER            _NUMBER          ASSET_NAME            _BALANCE                   UNDED_AMOUNTS                       PRINCIPAL                          NG_UNFUNDED_AMOUNTS                TRANSACTION_TYPE      SSET_ID          COMMENTS
NSF         32    03331      115540001436       8000000176                                 ABC Apartments LLC                   800000.00                                 0.00                                0.00                               0.00                     N
NSF         32    03348      115540001436       8000000176                8000000176-1     ABC Apartments LLC                         0.00                                0.00                          100000.00                                0.00                     6


12345 - DC Bank
                                        Example 1c: Bifurcation (6)
     20110731
                                        FB Risky Bank funded a commercial line for Widgets USA that requires a higher interest rate on aged outstanding balances. Historically FB would originate a new note at the higher rate and transfer the outstanding account balances to the new note.
             2
                                        Under the current Loss Share Agreement the AI creates a subordinate note under the Loss Share covered asset and splits the Loss Share credit commitment.
             6
                                                                                                                                CURRENT_OUTSTANDI                              LINKED_ACCOUNT_LOAN_CUR
LOSS_SHARE_       ASSET   ASSET_SUB_    ORIGINAL_FDIC_      ORIGINAL_BANK_HIS         LINKED_LOAN                               NG_UNPAID_PRINCIPAL CURRENT_OUTSTANDING_UNF RENT_OUTSTANDING_UNPAID_ LINKED_ACCOUNT_OUTSTANDI                         GENERATED_FDIC_A
TYPE              _TYPE   TYPE_CODE     ASSET_ID            TORICAL_NUMBER            _NUMBER     ASSET_NAME                    _BALANCE             UNDED_AMOUNTS             PRINCIPAL                  NG_UNFUNDED_AMOUNTS      TRANSACTION_TYPE   SSET_ID          COMMENTS
NSF               030     00030         10315461967         65154025                              Widgets USA                              900000.00                 100000.00                       0.00                     0.00                  N
NSF               030     00030         10315461967         65154025                  65154025-1  Widgets USA                                   0.00                      0.00                  700000.00                     0.00                  6
NSF               030     00030         10315461967         65154025                  65154025-2  Widgets USA                                   0.00                      0.00                  200000.00                100000.00                  6


                                        *Friendly Foreclosure: a disposition instrument in which a home owner voluntarily deeds the single family mortgaged property to the lender in exchange for a partial or full release from obligations under the single family
                                        mortgage.


                                        Least Costly Method for Single Family Loan Modifications: calculating a future net present value by calculating: the loss given default of the mortgage, the cost to the lender of the mortgage of the modified loan terms,
                                        and the probability of default given the modified loan terms, wherein the calculated future net present value is the current value of the mortgage, reduced by the product of the loss given default and the probability of default,
                                        and reduced by the cost to the lender of the modified loan terms. NPV stands for Net Present Value and is a calculation designed to demonstrate to the lender which option is the most cost effective for them – modify the
                                        loan or foreclose on the home.


12345 - DC Bank              Example 2: Consolidation (7)
     20110731                A developer of a shopping center has three loans with different maturities and rates but similar collateral; all are owned by ABC Bank. Due to cash flow issues, the developer and ABC Bank agree to consolidate all 3 notes to 1 note. The collateral
             1               remains the same and the total dollars do not exceed the current outstanding balances. ABC Bank informs the FDIC Specialist of the negotiation and after review both agree the new note is in accordance with the terms of the Shared-Loss
             7               Agreement. Subsequent to receipt of the approved Asset ID request, the original FDIC Asset IDs become inactive and the secondary FDIC Asest IDs are reported.
                                                                                                                   CURRENT_OUTSTANDI                                                LINKED_ACCOUNT_LOAN_CUR
LOSS_SHARE_ ASSET ASSET_SUB_ ORIGINAL_FDIC_ ORIGINAL_BANK_HIS LINKED_LOAN                                          NG_UNPAID_PRINCIPAL CURRENT_OUTSTANDING_UNF RENT_OUTSTANDING_UNPAID_ LINKED_ACCOUNT_OUTSTANDI                                                                                 GENERATED_FDIC_A
TYPE        _TYPE TYPE_CODE ASSET_ID            TORICAL_NUMBER           _NUMBER            ASSET_NAME             _BALANCE                        UNDED_AMOUNTS                    PRINCIPAL                          NG_UNFUNDED_AMOUNTS                  TRANSACTION_TYPE                     SSET_ID          COMMENTS
NSF         15    00015      115540001436       C540                     CM411              The Center                               135000.00                            10000.00                                0.00                                0.00                                   N
NSF         15    00015      115540001437       C541                     CM411              The Center                               450000.00                            15000.00                                0.00                                0.00                                   N
NSF         15    00015      115540001438       C542                     CM411              The Center                               530000.00                            25000.00                                0.00                                0.00                                   N
NSF         15    00015                                                  CM411              The Center                                       0.00                              0.00                         1115000.00                           50000.00                                    7


12345 - DC Bank              Example 3: Unfunded Commitment/Permitted Advances (8)
     20110731                ABC Bank funds a portion of a construction loan under terms separate from the master note (the unfunded amount is on Schedule 4.15B). As a result, ABC Bank establishes a separate servicing system record to track the advance amount and
             1               requests a secondary FDIC Asset ID. The FDIC Specialist reviews the request, confirms the AI activity is in accordance with the Shared-Loss Agreement, and approves the secondary FDIC Asset ID request. Subsequent to receipt of the secondary
             8               FDIC Asset ID, the AI continues to report the original FDIC Asset ID for the master note and uses the secondary FDIC asset ID for the more recently funded amounts.
                                                                                                                   CURRENT_OUTSTANDI                                               LINKED_ACCOUNT_LOAN_CUR
LOSS_SHARE_ ASSET ASSET_SUB_ ORIGINAL_FDIC_ ORIGINAL_BANK_HIS LINKED_LOAN                                          NG_UNPAID_PRINCIPAL CURRENT_OUTSTANDING_UNF RENT_OUTSTANDING_UNPAID_ LINKED_ACCOUNT_OUTSTANDI                                                               GENERATED_FDIC_A
TYPE        _TYPE TYPE_CODE ASSET_ID            TORICAL_NUMBER            _NUMBER           ASSET_NAME             _BALANCE                   UNDED_AMOUNTS                        PRINCIPAL                      NG_UNFUNDED_AMOUNTS                  TRANSACTION_TYPE        SSET_ID          COMMENTS
NSF         15    00015      133360002113       456789-RE                 ADV-0001          Commercial RLC                         642000.00                          106200.00                          96000.00                                 0.00                       8
12345 - DC Bank
                              Example 4: Fully Charged Off Assets (9)
     20110731
                              ABC Bank receives collections related to a Failed Bank charge off; the charged-off asset did not appear on Schedules 4.15A or B. ABC Bank informs the FDIC Specialist of the recovered amount and receives an FDIC Asset ID for use in the
             1
                              upcoming Certificate Submission.
             9
                                                                                                                 CURRENT_OUTSTANDI                             LINKED_ACCOUNT_LOAN_CUR
LOSS_SHARE_ ASSET ASSET_SUB_ ORIGINAL_FDIC_ ORIGINAL_BANK_HIS LINKED_LOAN                                        NG_UNPAID_PRINCIPAL CURRENT_OUTSTANDING_UNF RENT_OUTSTANDING_UNPAID_ LINKED_ACCOUNT_OUTSTANDI                       GENERATED_FDIC_A
TYPE        _TYPE TYPE_CODE ASSET_ID        TORICAL_NUMBER    _NUMBER     ASSET_NAME                             _BALANCE             UNDED_AMOUNTS            PRINCIPAL                 NG_UNFUNDED_AMOUNTS      TRANSACTION_TYPE   SSET_ID          COMMENTS
SFR         32    0032                      444444-S          RE-100001   Joe Homeowner                                          0.00                     0.00                      0.00                     0.00                  9
(Fund ID) - (Failed Institution)
(YYYYMMDD)
(Record Count)
(Transaction Type) - One Type Per Form and must be completed 15 days prior to Loss Share submission

LOSS_SHARE_TYPE ASSET_TYPE ASSET_SUB_TYPE_CODE ORIGINAL_FDIC_ASSET_ID
are submission

            ORIGINAL_BANK_HISTORICAL_NUMBER   LINKED_LOAN_NUMBER
ASSET_NAME
CURRENT_OUTSTANDING_UNPAID_PRINCIPAL_BALANCE
CURRENT_OUTSTANDING_UNFUNDED_AMOUNTS
LINKED_ACCOUNT_LOAN_CURRENT_OUTSTANDING_UNPAID_PRINCIPAL
LINKED_ACCOUNT_OUTSTANDING_UNFUNDED_AMOUNTS   TRANSACTION_TYPE
GENERATED_FDIC_ASSET_ID
COMMENTS

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:5/16/2012
language:Latin
pages:14
fanzhongqing fanzhongqing http://
About