Sheet1 - the New Jersey Economic Development Authority

Document Sample
Sheet1 - the New Jersey Economic Development Authority Powered By Docstoc
					                                                                                                                                                                                                                                                                                 ATTACHMENT A-1



                                                                                 NEW JERSEY ECONOMIC DEVELOPMENT AUTHORITY

 RFQ/P:                   2011-RFQ/P-034                                             LOAN and GUARANTEE SYSTEM SOFTWARE - Supply, Install and Support

                                                     The Proposer must complete, sign and submit this Attachment A-1 with its proposal.
                                                          Failure to do so will render the proposal material non-responsive and subject to rejection.

                                                                                                                                                      The Proposer MUST check one
                                                                                                                                                                                                                                          The Proposer is requested to indicate
                                 "SCOPE of SERVICES / DELIVERABLES -                                                                              of these three (3) fields, as it relates to
                                                                                                                                                   its "Core Product offered. Failure to
                                                                                                                                                                                                                                             if any of these three (3) fields is
                                                                                                                                                                                                                                                  applicable, as it relates
                   Fields, Functionality, Reporting Requirements and ITS Requirements"                                                                 do so will render the proposal
                                                                                                                                                                                                                                               to its "Core Product" offered.
                                                                                                                                                         materially non-responsive.




                                                                                                                                                                                                                                                                      Feature is not currently supported




                                                                                                                                                                                                                                                                                                           Feature is not currently supported
                                                                                                                                                     "Core Product" as Delivered




                                                                                                                                                                                                               Feature is NOT SUPPORTED
                                                                                                                                                      Feature is supported in the




                                                                                                                                                                                                                                                                                                               Future Product Release
                                                                                                                                                                                    Feature is supported via




                                                                                                                                                                                                                                           Feature is supported via
                                                                                                                                                                                    Vendor Customization




                                                                                                                                                                                                                                                                           Next Product Release
                                                                                                                                                                                                                                             User Modification /




                                                                                                                                                                                                                                                                                                                   but is planned in
                                                                                                                                                                                                                                               Customization



                                                                                                                                                                                                                                                                                 but will be in
                      REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                                                 Requirements
                           Fields, Functionality, Reporting and ITS Requirements                                                  Status




                                                                                                                                                    The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                    Data Element Fields                              Definition / Description / Function              Required   Desired    Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                                               solution offered, as it relates to these requirements.


                                                                    Borrower's legal name as indicated on incorporation
    1                        Borrower Name                           papers, partnership agreements, fictitious name            X
                                                                       fillings, social security card or birth certificate



                                                                      Separate fields for address, city, state, zip code,
    2          Contact Name and address w/parcel numbers                                                                        X
                                                                       parcel and email address and phone numbers




                                                                     Need all parties listed on borrowing resolution as
    3              Contact Name and address and Tax ID                                                                          X
                                                                                    authorized signers.




                                                                      Separate fields for address, city, state, zip code,
    4           Project Location address w/parcel numbers                                                                       X
                                                                                            parcel




    5                    Billing contact & address                                                                              X




    6                    Contact Type w/address                                                                                 X



                                                                        All ten (10%) percent or more owners of the
                                                                   borrowing entity including individuals or businesses or
    7                      Linked Relationship                                                                                  X
                                                                    other businesses with common ownership that have
                                                                             or are doing business with the EDA.



    8                         Federal Tax ID                                                                                    X




    9                       Borrower's NAICS                                                                                    X




    10                      Relationship Type                                      Affiliate, Principal, etc.                   X




    11                            Guarantor                                               Yes or No                             X




    12                       Funding Source                                     Identify EDA Funding Source                     X




                                                                     Identify EDA Product Sold need ability to add new
    13                    Product/Program Type                                                                                  X
                                                                    products and have them included in existing reports



2011-RFQ/P-034 - Attachment A-1
                                                                                                                1                                                                                                          872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
                                                                                                                                         The Proposer MUST check one
                                                                                                                                                                                                                             The Proposer is requested to indicate
                                 "SCOPE of SERVICES / DELIVERABLES -                                                                 of these three (3) fields, as it relates to
                                                                                                                                      its "Core Product offered. Failure to
                                                                                                                                                                                                                                if any of these three (3) fields is
                                                                                                                                                                                                                                     applicable, as it relates
                   Fields, Functionality, Reporting Requirements and ITS Requirements"                                                    do so will render the proposal
                                                                                                                                                                                                                                  to its "Core Product" offered.
                                                                                                                                            materially non-responsive.




                                                                                                                                                                                                                                                         Feature is not currently supported




                                                                                                                                                                                                                                                                                              Feature is not currently supported
                                                                                                                                        "Core Product" as Delivered




                                                                                                                                                                                                  Feature is NOT SUPPORTED
                                                                                                                                         Feature is supported in the




                                                                                                                                                                                                                                                                                                  Future Product Release
                                                                                                                                                                       Feature is supported via




                                                                                                                                                                                                                              Feature is supported via
                                                                                                                                                                       Vendor Customization




                                                                                                                                                                                                                                                              Next Product Release
                                                                                                                                                                                                                                User Modification /




                                                                                                                                                                                                                                                                                                      but is planned in
                                                                                                                                                                                                                                  Customization



                                                                                                                                                                                                                                                                    but will be in
                      REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                                    Requirements
                           Fields, Functionality, Reporting and ITS Requirements                                     Status




                                                                                                                                       The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                    Data Element Fields                Definition / Description / Function               Required   Desired    Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                                  solution offered, as it relates to these requirements.




    14                        Finance Name
                             Borrower Type                    Loan, Guarantee, Participation, etc.                 X



                                                       Date when a financing project has received Final
                                                     Approval (i.e. from more than one (1) approving body
    15                    Multiple Approval Dates                                                                  X
                                                          / Board ) and now the project becomes an
                                                                    outstanding commitment.


                                                     Date when an approved and not closed commitment
    16                 Commitment Expiration Date                                                                  X
                                                     is no longer valid and would need to be reapproved.




                                                        Need to be able to track the number of times a
    17                   Commitment Extensions                                                                     X
                                                                  commitment is extended.




                                                        Date when the Closing Documents have been
    18                            Closing Date                                                                     X
                                                                         executed




    19                       Transaction Date                                                                      X




    20                 Approved Financing Amount          Amount of the Approved Financing Amount                  X




    21                   Current Principal Balance        Principal Balance as of prior business day               X




                                                     Standard P & I, Fixed Principal, Interest only, balloon,
    22                      Amortization Type                                                                      X
                                                                      No Payments Due




                                                         Repayment due annually, monthly, quarterly,
    23                            Billing Cycle                                                                    X
                                                                      semi-annually




    24                            Interest Rate         Calculated rate according to terms of the note.            X




    25                      Interest Rate Floor                                                                    X




    26                     Interest Rate Ceiling                                                                   X




    27                     Variable Rate spread                 Adjustment applied to the index                    X




    28                            Index Table                Prime, Federal Discount, LIBOR, etc.                  X




2011-RFQ/P-034 - Attachment A-1
                                                                                             2                                                                                                                872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
                                                                                                                                        The Proposer MUST check one
                                                                                                                                                                                                                            The Proposer is requested to indicate
                                 "SCOPE of SERVICES / DELIVERABLES -                                                                of these three (3) fields, as it relates to
                                                                                                                                     its "Core Product offered. Failure to
                                                                                                                                                                                                                               if any of these three (3) fields is
                                                                                                                                                                                                                                    applicable, as it relates
                   Fields, Functionality, Reporting Requirements and ITS Requirements"                                                   do so will render the proposal
                                                                                                                                                                                                                                 to its "Core Product" offered.
                                                                                                                                           materially non-responsive.




                                                                                                                                                                                                                                                        Feature is not currently supported




                                                                                                                                                                                                                                                                                             Feature is not currently supported
                                                                                                                                       "Core Product" as Delivered




                                                                                                                                                                                                 Feature is NOT SUPPORTED
                                                                                                                                        Feature is supported in the




                                                                                                                                                                                                                                                                                                 Future Product Release
                                                                                                                                                                      Feature is supported via




                                                                                                                                                                                                                             Feature is supported via
                                                                                                                                                                      Vendor Customization




                                                                                                                                                                                                                                                             Next Product Release
                                                                                                                                                                                                                               User Modification /




                                                                                                                                                                                                                                                                                                     but is planned in
                                                                                                                                                                                                                                 Customization



                                                                                                                                                                                                                                                                   but will be in
                      REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                                   Requirements
                           Fields, Functionality, Reporting and ITS Requirements                                    Status




                                                                                                                                      The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                    Data Element Fields               Definition / Description / Function               Required   Desired    Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                                 solution offered, as it relates to these requirements.




    29                      Borrower Name
                          Amortization Base Year                    360 or 365 days & 366                         X




    30                              Call Date                      Requires decision or call                      X




    31                      Long Term Interest           Accrued Interest due greater than 12 months              X




                                                         Increased interest upon default, based on a
    32                     Default Interest Rate                                                                  X
                                                       percentage increase in the contract interest rate




    33                               Terms             Repayments terms based on note or agreement                X




    34                      Interest Only Term                                                                    X




                                                        Number of equal amortizing monthly payments
    35                      Amortization Term                                                                     X
                                                         needed to amortize the original loan balance




    36                            Risk Rating             Risk Rating designation and allowance %                 X




    37                        Facility Rating                         Facility Risk Rating                        X




    38                      Types of Collateral                   From list of collateral codes                   X




                                                        Accruing, Cash Basis, Non-accruing, Principal
    39                       Accruing Status                                                                      X
                                                                         Recovery




    40                   Accrued Interest Balance                                                                 X




                                                     Current, Delinquent, Moratorium, Paid in Full, Written-
    41                            Loan Status                                                                     X
                                                                             off




                                                     Date when the financing is no longer active either by
    42                       End Status Date                                                                      X
                                                            payment in full, written-off, paid out




    43                            Maturity Date              Date final scheduled payment is due.                 X




2011-RFQ/P-034 - Attachment A-1
                                                                                             3                                                                                                               872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
                                                                                                                                               The Proposer MUST check one
                                                                                                                                                                                                                                   The Proposer is requested to indicate
                                 "SCOPE of SERVICES / DELIVERABLES -                                                                       of these three (3) fields, as it relates to
                                                                                                                                            its "Core Product offered. Failure to
                                                                                                                                                                                                                                      if any of these three (3) fields is
                                                                                                                                                                                                                                           applicable, as it relates
                   Fields, Functionality, Reporting Requirements and ITS Requirements"                                                          do so will render the proposal
                                                                                                                                                                                                                                        to its "Core Product" offered.
                                                                                                                                                  materially non-responsive.




                                                                                                                                                                                                                                                               Feature is not currently supported




                                                                                                                                                                                                                                                                                                    Feature is not currently supported
                                                                                                                                              "Core Product" as Delivered




                                                                                                                                                                                                        Feature is NOT SUPPORTED
                                                                                                                                               Feature is supported in the




                                                                                                                                                                                                                                                                                                        Future Product Release
                                                                                                                                                                             Feature is supported via




                                                                                                                                                                                                                                    Feature is supported via
                                                                                                                                                                             Vendor Customization




                                                                                                                                                                                                                                                                    Next Product Release
                                                                                                                                                                                                                                      User Modification /




                                                                                                                                                                                                                                                                                                            but is planned in
                                                                                                                                                                                                                                        Customization



                                                                                                                                                                                                                                                                          but will be in
                      REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                                          Requirements
                           Fields, Functionality, Reporting and ITS Requirements                                           Status




                                                                                                                                             The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                    Data Element Fields                          Definition / Description / Function           Required   Desired    Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                                        solution offered, as it relates to these requirements.




    44                        Borrower Name
                         Interest Rate Reset Date                                                                        X




    45                     Interest Moratorium                                                                           X




    46                     Principal Moratorium                                                                          X




    47                     Special Billing Terms                                                                         X




    48                            Direct Debit                                                                           X




    49                       Do Not Print Bill                   Generate a due record, but do not print an invoice                X




                                                                   Late Fee will not be charged. Need ability by
    50                        Waive Late Fee                     program / product type or one (1) loan record at a      X
                                                                                        time



                                                                    EDA employee responsible for the financial
    51                            Sales Officer                                                                          X
                                                                                  application




                                                                    EDA employee responsible for underwriting
    52                            Underwriter                                                                            X
                                                                                the financing




                                                                      EDA employee responsible for closing
    53                        Closing Officer                                                                            X
                                                                                the financing




                                                                     EDA employee responsible for servicing
    54                       Servicing Officer                                                                           X
                                                                                 the account




    55            Date On / Off Special Loan Management                                                                  X




             Principal and Interest Balance when Restructured,
    56                                                                                                                             X
                     Written Off, Transferred, or Settled




    57                    Disbursement Amount                                                                            X




    58                            Check Date                                                                             X




2011-RFQ/P-034 - Attachment A-1
                                                                                                      4                                                                                                             872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
                                                                                                                                      The Proposer MUST check one
                                                                                                                                                                                                                          The Proposer is requested to indicate
                                 "SCOPE of SERVICES / DELIVERABLES -                                                              of these three (3) fields, as it relates to
                                                                                                                                   its "Core Product offered. Failure to
                                                                                                                                                                                                                             if any of these three (3) fields is
                                                                                                                                                                                                                                  applicable, as it relates
                   Fields, Functionality, Reporting Requirements and ITS Requirements"                                                 do so will render the proposal
                                                                                                                                                                                                                               to its "Core Product" offered.
                                                                                                                                         materially non-responsive.




                                                                                                                                                                                                                                                      Feature is not currently supported




                                                                                                                                                                                                                                                                                           Feature is not currently supported
                                                                                                                                     "Core Product" as Delivered




                                                                                                                                                                                               Feature is NOT SUPPORTED
                                                                                                                                      Feature is supported in the




                                                                                                                                                                                                                                                                                               Future Product Release
                                                                                                                                                                    Feature is supported via




                                                                                                                                                                                                                           Feature is supported via
                                                                                                                                                                    Vendor Customization




                                                                                                                                                                                                                                                           Next Product Release
                                                                                                                                                                                                                             User Modification /




                                                                                                                                                                                                                                                                                                   but is planned in
                                                                                                                                                                                                                               Customization



                                                                                                                                                                                                                                                                 but will be in
                      REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                                 Requirements
                           Fields, Functionality, Reporting and ITS Requirements                                  Status




                                                                                                                                    The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                    Data Element Fields               Definition / Description / Function             Required   Desired    Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                               solution offered, as it relates to these requirements.




                             Borrower Date            Date check was released. In the event we cut the
    59                        Funding Name                                                                      X
                                                         check and do not release it for some time.




    60                    Commitment AMo0unt                          Obligation to Fund                        X




    61                      Disbursement Type                         Wire, Check, ACH                          X




    62                   Billing Contact & Address                                                              X


                                                     Customer loan record according to the terms of the
                                                      agreement and a separate dual record for financial
    63                       Dual Accounting             statement purposes for accounts that are in a          X
                                                     principal recovery status and applies all payments to
                                                                            principal.


    64                  Various Remit To Address           Remit To address for various lockboxes               X




    65                      Variable Late Fees                   By product, by loan, by type                   X




    66                    Variable Grace Periods                 By product, by loan, by type                   X




                                                                     GUARANTEE



    67                      Bank Loan Amount                                                                    X




    68                      Guarantee Amount                                                                    X




    69                    Guarantee Percentage                                                                  X




    70                      Current Exposure                                                                    X




                                                     Maximum exposure per agreement. Used to calculate
    71                     Maximum Exposure                                                                     X
                                                           loss allowances ad exposure reports




                                                             EDA guarantee not in effect until the
    72                    Guarantee Not in Effect                                                               X
                                                                     milestone is met.




2011-RFQ/P-034 - Attachment A-1
                                                                                           5                                                                                                               872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
                                                                                                                                           The Proposer MUST check one
                                                                                                                                                                                                                               The Proposer is requested to indicate
                                 "SCOPE of SERVICES / DELIVERABLES -                                                                   of these three (3) fields, as it relates to
                                                                                                                                        its "Core Product offered. Failure to
                                                                                                                                                                                                                                  if any of these three (3) fields is
                                                                                                                                                                                                                                       applicable, as it relates
                   Fields, Functionality, Reporting Requirements and ITS Requirements"                                                      do so will render the proposal
                                                                                                                                                                                                                                    to its "Core Product" offered.
                                                                                                                                              materially non-responsive.




                                                                                                                                                                                                                                                           Feature is not currently supported




                                                                                                                                                                                                                                                                                                Feature is not currently supported
                                                                                                                                          "Core Product" as Delivered




                                                                                                                                                                                                    Feature is NOT SUPPORTED
                                                                                                                                           Feature is supported in the




                                                                                                                                                                                                                                                                                                    Future Product Release
                                                                                                                                                                         Feature is supported via




                                                                                                                                                                                                                                Feature is supported via
                                                                                                                                                                         Vendor Customization




                                                                                                                                                                                                                                                                Next Product Release
                                                                                                                                                                                                                                  User Modification /




                                                                                                                                                                                                                                                                                                        but is planned in
                                                                                                                                                                                                                                    Customization



                                                                                                                                                                                                                                                                      but will be in
                      REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                                      Requirements
                           Fields, Functionality, Reporting and ITS Requirements                                       Status




                                                                                                                                         The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                    Data Element Fields                     Definition / Description / Function            Required   Desired    Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                                    solution offered, as it relates to these requirements.




    73                       Borrower Name
                           Line of Credit (LOC)              If guaranteeing LOC, maximum will be calculated         X




    74                            Bank Name                                                                          X




    75          Bank Contact Name, Address, Phone, Email                                                             X




    76                  Guarantee Expiration Date                                                                    X




    77                       Type of Guaranty                     Principal, Interest, P & I or Contingency          X




                                                                 Based on Guarantee Amount or percent
    78                       Type of Exposure                                                                        X
                                                                            of Bank Loan




    79                 Verification Data and History          Status as of date, balance, due for, comments          X




    80                  Pari Passu or Subordinate                                yes or no                           X




                                                                 Borrower defaults, EDA pays percentage
    81                Amount Paid Out on Guarantee                                                                   X
                                                                              or bank loan




                                                                         FUNCTIONALITY



    82            Provide an Audit Log of all Transactions                Transactional Database                     X




                                                               To accommodate Authority's business rules /
    83          Approximately 50+ plus customizable fields                                                           X
                                                                operations to include format and validation




    84                       Calculate Payoff                                                                        X




    85                        Generate bills                                                                         X




                                                             Changes in interest rates, payments terms, partial
    86                    Ability to change terms                                                                    X
                                                                                 write offs.




2011-RFQ/P-034 - Attachment A-1
                                                                                                   6                                                                                                            872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
                                                                                                                                                        The Proposer MUST check one
                                                                                                                                                                                                                                            The Proposer is requested to indicate
                                 "SCOPE of SERVICES / DELIVERABLES -                                                                                of these three (3) fields, as it relates to
                                                                                                                                                     its "Core Product offered. Failure to
                                                                                                                                                                                                                                               if any of these three (3) fields is
                                                                                                                                                                                                                                                    applicable, as it relates
                   Fields, Functionality, Reporting Requirements and ITS Requirements"                                                                   do so will render the proposal
                                                                                                                                                                                                                                                 to its "Core Product" offered.
                                                                                                                                                           materially non-responsive.




                                                                                                                                                                                                                                                                        Feature is not currently supported




                                                                                                                                                                                                                                                                                                             Feature is not currently supported
                                                                                                                                                       "Core Product" as Delivered




                                                                                                                                                                                                                 Feature is NOT SUPPORTED
                                                                                                                                                        Feature is supported in the




                                                                                                                                                                                                                                                                                                                 Future Product Release
                                                                                                                                                                                      Feature is supported via




                                                                                                                                                                                                                                             Feature is supported via
                                                                                                                                                                                      Vendor Customization




                                                                                                                                                                                                                                                                             Next Product Release
                                                                                                                                                                                                                                               User Modification /




                                                                                                                                                                                                                                                                                                                     but is planned in
                                                                                                                                                                                                                                                 Customization



                                                                                                                                                                                                                                                                                   but will be in
                      REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                                                   Requirements
                           Fields, Functionality, Reporting and ITS Requirements                                                    Status




                                                                                                                                                      The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                    Data Element Fields                               Definition / Description / Function               Required   Desired    Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                                                 solution offered, as it relates to these requirements.




    87                  Track Borrower Name
                              Interest rate changes                                                                               X




    88       Automatic Interest rate changes with detail report                                                                   X




    89                       Loan Extensions                                                                                      X




    90                      Guaranty Renewals                                                                                     X




    91        Credit Risk Rating request changes with history                                                                     X




    92         Accrual Status Change Requests with history                                                                        X




    93                    Accepts ACH payments                                                                                              X




    94      Has a module for purchased and sold participations                                                                    X



           Uses transaction codes for posting transactions which
    95                       will integrate with                                                                                  X
                   MS Great Plains Accounting Software




    96                    Dual Loan Accounting                                                                                    X



            All transactions show in payments history including
    97                payments that are reapplied along                                                                           X
                            with the original entry



           Static or archiving of key reports for past months and
    98                                                                                                                                      X
                          years for up to five years




           Creates month end and current data tables that can be
    99                                                                                                                            X
                    either exported to Access or Excel




   100                            Tickler file                               Ability to post notes, reminders, etc.               X




                                                                    A true loan that is offered at zero interest needs to be
   101       Ability to Track and Discount Zero Interest Loans                                                                    X
                                                                                 reported at its present value




2011-RFQ/P-034 - Attachment A-1
                                                                                                            7                                                                                                                872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
                                                                                                                                          The Proposer MUST check one
                                                                                                                                                                                                                              The Proposer is requested to indicate
                                 "SCOPE of SERVICES / DELIVERABLES -                                                                  of these three (3) fields, as it relates to
                                                                                                                                       its "Core Product offered. Failure to
                                                                                                                                                                                                                                 if any of these three (3) fields is
                                                                                                                                                                                                                                      applicable, as it relates
                   Fields, Functionality, Reporting Requirements and ITS Requirements"                                                     do so will render the proposal
                                                                                                                                                                                                                                   to its "Core Product" offered.
                                                                                                                                             materially non-responsive.




                                                                                                                                                                                                                                                          Feature is not currently supported




                                                                                                                                                                                                                                                                                               Feature is not currently supported
                                                                                                                                         "Core Product" as Delivered




                                                                                                                                                                                                   Feature is NOT SUPPORTED
                                                                                                                                          Feature is supported in the




                                                                                                                                                                                                                                                                                                   Future Product Release
                                                                                                                                                                        Feature is supported via




                                                                                                                                                                                                                               Feature is supported via
                                                                                                                                                                        Vendor Customization




                                                                                                                                                                                                                                                               Next Product Release
                                                                                                                                                                                                                                 User Modification /




                                                                                                                                                                                                                                                                                                       but is planned in
                                                                                                                                                                                                                                   Customization



                                                                                                                                                                                                                                                                     but will be in
                      REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                                     Requirements
                           Fields, Functionality, Reporting and ITS Requirements                                      Status




                                                                                                                                        The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                     Data Element Fields                         Definition / Description / Function      Required   Desired    Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                                   solution offered, as it relates to these requirements.




   102                       Borrower Name
                            Exception Package                                      Compliance,                      X




   103                      Exception Package                              Financial Statement Tracking             X




   104                      Exception Package                                     Commitments                       X



            Reporting should include ability to Sort by initiative
   105            then program or fund then risk rating,                                                            X
                          customer/relationship




   106           Ability to Batch Payments or enter as Live          Real Time vs. Batched payment transaction                X




   107                               Loan                                                                           X




   108                             Guarantee                                                                        X




   109                            Participation                                                                     X




   110                 Participation with Guarantee                                                                 X




   111                        Contingent Loan                                                                       X




   112                         Line of Credit                                                                       X




   113                       Equity Investment                                                                                X




   114                               Bond                                                                                     X




   115                             Tax Credit                                                                                 X




   116                             Soft Loan                                                                        X




2011-RFQ/P-034 - Attachment A-1
                                                                                                     8                                                                                                         872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
                                                                                                                                                    The Proposer MUST check one
                                                                                                                                                                                                                                        The Proposer is requested to indicate
                                 "SCOPE of SERVICES / DELIVERABLES -                                                                            of these three (3) fields, as it relates to
                                                                                                                                                 its "Core Product offered. Failure to
                                                                                                                                                                                                                                           if any of these three (3) fields is
                                                                                                                                                                                                                                                applicable, as it relates
                   Fields, Functionality, Reporting Requirements and ITS Requirements"                                                               do so will render the proposal
                                                                                                                                                                                                                                             to its "Core Product" offered.
                                                                                                                                                       materially non-responsive.




                                                                                                                                                                                                                                                                    Feature is not currently supported




                                                                                                                                                                                                                                                                                                         Feature is not currently supported
                                                                                                                                                   "Core Product" as Delivered




                                                                                                                                                                                                             Feature is NOT SUPPORTED
                                                                                                                                                    Feature is supported in the




                                                                                                                                                                                                                                                                                                             Future Product Release
                                                                                                                                                                                  Feature is supported via




                                                                                                                                                                                                                                         Feature is supported via
                                                                                                                                                                                  Vendor Customization




                                                                                                                                                                                                                                                                         Next Product Release
                                                                                                                                                                                                                                           User Modification /




                                                                                                                                                                                                                                                                                                                 but is planned in
                                                                                                                                                                                                                                             Customization



                                                                                                                                                                                                                                                                               but will be in
                      REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                                               Requirements
                           Fields, Functionality, Reporting and ITS Requirements                                                Status




                                                                                                                                                  The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                     Data Element Fields                             Definition / Description / Function            Required   Desired    Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                                             solution offered, as it relates to these requirements.




   117                       Borrower Name
                     Generates Amortization Schedules                                                                         X




                                                                             REPORTS REQUIRED



   118                     Loan Balance Report                                                                                X




   119                  Accrued Interest Receivable                                                                           X




   120               Non-Accrual Loan Balance Report                      Sorted by initiative then program or fund.                    X




   121            Principal Recovery Loan Balance Report                  Sorted by initiative then program or fund.                    X




   122              Principal, Interest and Fee Receipts                                                                      X




   123          Principal, Interest, Fee Receipts and Waivers                                                                 X




                      Principal and Interest Projection
   124                                                                                                                        X
                            up to ten (10) years




   125         Calculate the loss reserve on an account level                                                                 X




   126                        Disbursements                                                                                   X




   127                      Guarantee Exposure                                                                                X




            Loan Portfolio by Program, by Fund, by Risk Rating,
   128                                                                                                                        X
                              Servicing Officer




           Activity report by Officers for Applications, Approvals
   129                                                                                                                        X
                                and Closings




                                                                     Pending approval, awaiting closing, closed projects
   130                       Pipeline reporting                                                                               X
                                                                             and withdrawn/declined projects.




2011-RFQ/P-034 - Attachment A-1
                                                                                                           9                                                                                                             872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
                                                                                                                                                   The Proposer MUST check one
                                                                                                                                                                                                                                       The Proposer is requested to indicate
                                 "SCOPE of SERVICES / DELIVERABLES -                                                                           of these three (3) fields, as it relates to
                                                                                                                                                its "Core Product offered. Failure to
                                                                                                                                                                                                                                          if any of these three (3) fields is
                                                                                                                                                                                                                                               applicable, as it relates
                   Fields, Functionality, Reporting Requirements and ITS Requirements"                                                              do so will render the proposal
                                                                                                                                                                                                                                            to its "Core Product" offered.
                                                                                                                                                      materially non-responsive.




                                                                                                                                                                                                                                                                   Feature is not currently supported




                                                                                                                                                                                                                                                                                                        Feature is not currently supported
                                                                                                                                                  "Core Product" as Delivered




                                                                                                                                                                                                            Feature is NOT SUPPORTED
                                                                                                                                                   Feature is supported in the




                                                                                                                                                                                                                                                                                                            Future Product Release
                                                                                                                                                                                 Feature is supported via




                                                                                                                                                                                                                                        Feature is supported via
                                                                                                                                                                                 Vendor Customization




                                                                                                                                                                                                                                                                        Next Product Release
                                                                                                                                                                                                                                          User Modification /




                                                                                                                                                                                                                                                                                                                but is planned in
                                                                                                                                                                                                                                            Customization



                                                                                                                                                                                                                                                                              but will be in
                      REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                                              Requirements
                           Fields, Functionality, Reporting and ITS Requirements                                               Status




                                                                                                                                                 The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                    Data Element Fields                           Definition / Description / Function              Required   Desired    Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                                            solution offered, as it relates to these requirements.




                              Borrower Name                      By Customer / Relationship, Sorted by initiative then
   131                    Risk Migration Analysis                                                                            X
                                                                         date then program then risk rating.



             Reconciliation Reporting for Cash, Disbursements,
   132                                                                                                                                 X
                            and Ending Balance




   133             Classified Reports for Year-End Audit                      Short Term vs. Long Term                       X




   134                      Rate Reset Report                                                                                X




   135                      Moratorium Report                                                                                X




   136                  Delinquency Aging Report                                                                             X



                                                                        Indicates all activity on a loan including
                                                                   disbursements, payments, Interest rate changes,
   137                   Payment History Report                  adjustments and payment reversals without deleting          X
                                                                      the original entry, and waived fees utilizing
                                                                 transaction codes to identify the type of transaction.



   138                  Outstanding Commitments                                                                              X




   139                            Allowance                                                                                  X




   140               Available Commitment Balances                  Closed financings that are not fully disbursed           X




   141               Accrual Status Change Requests                                                                          X




   142                 Risk Rating Change Requests                                                                           X




   143                 Default Interest Rate Changes                          By Customer/Relationship                       X




                                                                        Paid in Full, Written-Off, Paid Out, By
   144                            End Status                                                                                 X
                                                                        Customer/Relationship, Risk Rating




   145              Loan Maturity/Guarantee Expiration                                                                       X




2011-RFQ/P-034 - Attachment A-1
                                                                                                       10                                                                                                               872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
                                                                                                                                                          The Proposer MUST check one
                                                                                                                                                                                                                                              The Proposer is requested to indicate
                                 "SCOPE of SERVICES / DELIVERABLES -                                                                                  of these three (3) fields, as it relates to
                                                                                                                                                       its "Core Product offered. Failure to
                                                                                                                                                                                                                                                 if any of these three (3) fields is
                                                                                                                                                                                                                                                      applicable, as it relates
                   Fields, Functionality, Reporting Requirements and ITS Requirements"                                                                     do so will render the proposal
                                                                                                                                                                                                                                                   to its "Core Product" offered.
                                                                                                                                                             materially non-responsive.




                                                                                                                                                                                                                                                                          Feature is not currently supported




                                                                                                                                                                                                                                                                                                               Feature is not currently supported
                                                                                                                                                         "Core Product" as Delivered




                                                                                                                                                                                                                   Feature is NOT SUPPORTED
                                                                                                                                                          Feature is supported in the




                                                                                                                                                                                                                                                                                                                   Future Product Release
                                                                                                                                                                                        Feature is supported via




                                                                                                                                                                                                                                               Feature is supported via
                                                                                                                                                                                        Vendor Customization




                                                                                                                                                                                                                                                                               Next Product Release
                                                                                                                                                                                                                                                 User Modification /




                                                                                                                                                                                                                                                                                                                       but is planned in
                                                                                                                                                                                                                                                   Customization



                                                                                                                                                                                                                                                                                     but will be in
                       REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                                                    Requirements
                            Fields, Functionality, Reporting and ITS Requirements                                                     Status




                                                                                                                                                        The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                      Data Element Fields                               Definition / Description / Function               Required   Desired    Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                                                   solution offered, as it relates to these requirements.




   146                         Borrower of Maturity
                         Paid in AdvanceName                                       By Customer / Relationship                       X




                                                                      Sorted by initiative; then date; then program; then risk
   147                        Vintage Reporting                       rating. Must indicate original amount current balance         X
                                                                              and times 30, 60, 90+ days delinquent.


                                                                        Sorted by Initiative then program and grouped by
                                                                        sectors or subsectors or specific NAICS ranges.
   148                 Industry Sector Concentrations                                                                               X
                                                                         Report should indicate weighted risk rates per
                                                                                municipality, county or zip code.



   149                             Location                                                                                         X




   150                       Types of Collateral                                                                                    X




   151                      Dual Loan Accounting                                                                                    X




   152                          Non-Accruals                                                                                        X




   153                  Portfolio by Servicing Officer                                                                              X




   154                     Commitment Expiration                                                                                    X




           Customer Historical Report with numerous Variations          Able to group all of a Customer's Current and Pat
   155                                                                                                                              X
                                on Query                                     History by Name, Tax ID and Guarantor



             Able to provide Consolidated Billing for Customers
   156                                                                                                                              X
                         with more than one (1) note



                  This section addresses MANDATORY
            REQUIREMENTS and shall not be considered as part
                                                                        ITS HARDWARE / SOFTWARE
                 of the 25% customizable opportunities.                COMPATIBILITY REQUIREMENTS


   157            Supports MS SQL Server (2008 pr higher)                                                                           X



           Microsoft (MS) windows 7 or IE 7 "look and feel" and
   158     be compatible with Windows 7,Vista and Windows XP                                                                        X
                            operating systems




   159       Proven ability to run client applications over Citrix.                 Presentation Server 4.5                         X




2011-RFQ/P-034 - Attachment A-1
                                                                                                             11                                                                                                                872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
                                                                                                                                               The Proposer MUST check one
                                                                                                                                                                                                                                   The Proposer is requested to indicate
                                 "SCOPE of SERVICES / DELIVERABLES -                                                                       of these three (3) fields, as it relates to
                                                                                                                                            its "Core Product offered. Failure to
                                                                                                                                                                                                                                      if any of these three (3) fields is
                                                                                                                                                                                                                                           applicable, as it relates
                   Fields, Functionality, Reporting Requirements and ITS Requirements"                                                          do so will render the proposal
                                                                                                                                                                                                                                        to its "Core Product" offered.
                                                                                                                                                  materially non-responsive.




                                                                                                                                                                                                                                                               Feature is not currently supported




                                                                                                                                                                                                                                                                                                    Feature is not currently supported
                                                                                                                                              "Core Product" as Delivered




                                                                                                                                                                                                        Feature is NOT SUPPORTED
                                                                                                                                               Feature is supported in the




                                                                                                                                                                                                                                                                                                        Future Product Release
                                                                                                                                                                             Feature is supported via




                                                                                                                                                                                                                                    Feature is supported via
                                                                                                                                                                             Vendor Customization




                                                                                                                                                                                                                                                                    Next Product Release
                                                                                                                                                                                                                                      User Modification /




                                                                                                                                                                                                                                                                                                            but is planned in
                                                                                                                                                                                                                                        Customization



                                                                                                                                                                                                                                                                          but will be in
                       REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                                         Requirements
                            Fields, Functionality, Reporting and ITS Requirements                                          Status




                                                                                                                                             The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                      Data Element Fields                            Definition / Description / Function       Required   Desired    Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                                        solution offered, as it relates to these requirements.



           Scalable Security (by group, object & field) based upon
                               Borrower Name
   160                                                                                                                   X
                            the Active Directory




            if SAAS (software as a service) it must provide online
   161                                                                                                                  X
                    database backup and restore facility




   162            able to send User Notifications via SMTP                                                               X




                    Supports flat files such as CSV or
   163                                                                                                                   X
                   MS Excel 2007 and above file formats.




   164              Supports LINQ and Entity framework                                                                   X




   165                         Data Dictionary                                                                           X



           Provides Users with ad hoc reporting capabilities and
   166      export data to such standard files as MS Excel, Text                                                         X
                         File, CSV and XML formats



             Report Writer and Query Builder available for User
   167                                                                                                                   X
                         created Ad Hoc Reporting




   168                  Supports XML Web services.                                                                       X



            Provides Technical & User Manuals (both electronic
            version on CD ROM and on-line versions) for “Core
   169                                                                                                                   X
              Product” software, to include data dictionaries,
                               schema, etc.

                 Provide updated and revised Technical & User
             Manuals (both electronic version on CD ROM and on-
   170     line versions) to include data dictionaries, schema, etc.                                                     X
             following each customization, revision, upgrade and
                            /or service patch issued


           Permits the Authority's ITS staff access to source code
   171                                                                 Only for non-proprietary customized features      X
                (to facilitate enhancements / modifications)




               Accommodates and estimated 150 - 200 Users
   172                                                                                                                   X
                          (local and remote)




   173                   Integrates with FileNet (IBM)                                                                   X




   174                 Integrates with MS Great Plains                                                                   X




2011-RFQ/P-034 - Attachment A-1
                                                                                                        12                                                                                                          872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
                                                                                                                                      The Proposer MUST check one
                                                                                                                                                                                                                           The Proposer is requested to indicate
                                  "SCOPE of SERVICES / DELIVERABLES -                                                             of these three (3) fields, as it relates to
                                                                                                                                   its "Core Product offered. Failure to
                                                                                                                                                                                                                              if any of these three (3) fields is
                                                                                                                                                                                                                                   applicable, as it relates
                    Fields, Functionality, Reporting Requirements and ITS Requirements"                                                do so will render the proposal
                                                                                                                                                                                                                                to its "Core Product" offered.
                                                                                                                                         materially non-responsive.




                                                                                                                                                                                                                                                       Feature is not currently supported




                                                                                                                                                                                                                                                                                            Feature is not currently supported
                                                                                                                                     "Core Product" as Delivered




                                                                                                                                                                                                Feature is NOT SUPPORTED
                                                                                                                                      Feature is supported in the




                                                                                                                                                                                                                                                                                                Future Product Release
                                                                                                                                                                    Feature is supported via




                                                                                                                                                                                                                            Feature is supported via
                                                                                                                                                                    Vendor Customization




                                                                                                                                                                                                                                                            Next Product Release
                                                                                                                                                                                                                              User Modification /




                                                                                                                                                                                                                                                                                                    but is planned in
                                                                                                                                                                                                                                Customization



                                                                                                                                                                                                                                                                  but will be in
                         REQUIREMENTS of the LOAN and GUARANTEE SYSTEM Software -                            Requirements
                              Fields, Functionality, Reporting and ITS Requirements                             Status




                                                                                                                                    The Proposer SHALL place an “X” in the appropriate column for EACH Data
   Item                         Data Element Fields                Definition / Description / Function     Required   Desired      Element Field Requirement, to map / indicate the status of its “Core Product”
                                                                                                                                               solution offered, as it relates to these requirements.




                                  Borrower Name
                          Proposing Entity Name                                           Street Address                                                                                       City, State, Zip Code




           Name of Authorized Representative of Proposing Entity                  Title                               Signature of Authorized Representative                                                                                             Date




                              E-Mail Address                                   Telephone #




2011-RFQ/P-034 - Attachment A-1
                                                                                                 13                                                                                                         872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  14   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  15   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  16   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  17   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  18   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  19   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  20   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  21   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  22   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  23   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  24   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  25   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS
2011-RFQ/P-034 - Attachment A-1
                                  26   872552d2-f8d8-4910-ac92-8cfa4aa26c0a.XLS

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:2/2/2012
language:
pages:26