DBMS Query Review and Tuning Sample Clauses

Open Split View

Download

Share

Cite

DBMS Query Review and Tuning. DB system security setting covers DB query review and tuning upon Client’s request

Sample 1Sample 2

Save

Copy

Related to DBMS Query Review and Tuning

• Completion of Review for Certain Review Receivables Following the delivery of the list of the Review Receivables and before the delivery of the Review Report by the Asset Representations Reviewer, the Servicer may notify the Asset Representations Reviewer if a Review Receivable is paid in full by the Obligor or purchased from the Issuer in accordance with the terms of the Basic Documents. On receipt of such notice, the Asset Representations Reviewer will immediately terminate all Tests of the related Review Receivable, and the Review of such Review Receivables will be considered complete (a “Test Complete”). In this case, the related Review Report will indicate a Test Complete for such Review Receivable and the related reason.

• Review Scope The parties confirm that the Asset Representations Review is not responsible for (a) reviewing the Receivables for compliance with the representations and warranties under the Transaction Documents, except as described in this Agreement or (b) determining whether noncompliance with the representations and warranties constitutes a breach of the Eligibility Representations. For the avoidance of doubt, the parties confirm that the review is not designed to determine why an Obligor is delinquent or the creditworthiness of the Obligor, either at the time of any Asset Review or at the time of origination of the related Receivable. Further, the Asset Review is not designed to establish cause, materiality or recourse for any Test Fail (as defined in Section 3.05).

• Sub-Adviser Review of Materials Upon the Adviser’s request, the Sub-Adviser shall review and comment upon selected portions, relating to the Sub-Adviser and/or Strategy (including the Allocated Portion), of the Registration Statement, other offering documents and ancillary sales and marketing materials prepared by the Adviser for the Fund, and participate, at the reasonable request of the Adviser and as agreed to by the Sub-Adviser, in educational meetings with placement agents and other intermediaries about portfolio management and investment-related matters of the Fund. The Sub-Adviser will promptly inform the Fund and the Adviser if any information in the Registration Statement is (or will become) inaccurate or incomplete.

• Asset Representations Review Process Section 3.01 Asset Representations Review Notices and Identification of Review Receivables. On receipt of an Asset Representations Review Notice from the Seller according to Section 5.7 of the Receivables Purchase Agreement, the Asset Representations Reviewer will start an Asset Representations Review. The Servicer will provide the list of Review Receivables to the Asset Representations Reviewer promptly upon receipt of the Asset Representations Review Notice. The Asset Representations Reviewer will not be obligated to start, and will not start, an Asset Representations Review until an Asset Representations Review Notice and the related list of Review Receivables is received. The Asset Representations Reviewer is not obligated to verify (i) whether the conditions to the initiation of the Asset Representations Review and the issuance of an Asset Representations Review Notice described in Section 7.6 of the Indenture were satisfied or (ii) the accuracy or completeness of the list of Review Receivables provided by the Servicer.

• Review and Consultation Employee acknowledges and agrees he (a) has read this Agreement in its entirety prior to executing it, (b) understands the provisions and effects of this Agreement and (c) has consulted with such attorneys, accountants and financial or other advisors as he has deemed appropriate in connection with the execution of this Agreement. Employee understands, acknowledges and agrees that he has not received any advice, counsel or recommendation with respect to this Agreement from Employer’s attorneys. [Signature Page Follows]

• Periodic Review of Compliance Policies and Procedures During the Term, Transfer Agent shall periodically assess its compliance policies and procedures (the “Policies”). Transfer Agent shall provide, (i) no less frequently than annually, electronic access to its Policies to the chief compliance officer of the Fund (the “Chief Compliance Officer”), and/or any individual designated by the Fund or such Chief Compliance Officer, including but not limited to members of the internal compliance and audit departments of Federated Investors, Inc., and any advisory board constituted by the Fund provided that the Transfer Agent may reasonably require any members of such advisory board that are not employees of the Fund or its Affiliates to execute a confidentiality agreement with respect to such information; (ii) at such reasonable times as he or she shall request, access by such Chief Compliance Officer to such individuals as may be necessary for the Chief Compliance Officer to conduct an annual review of the operation of such Policies for purposes of making his or her annual report to the Board of the Fund (the “Annual Report”), (iii) promptly upon enactment, notification of, and a copy of, any material change in such Policies, and (iv) promptly upon request, such other information as may be reasonably requested by such Chief Compliance Officer for purposes of making such Annual Report.

• Review Procedures A request for review of a denied claim must be made in writing to Plan Administrator within sixty (60) days after receiving notice of denial (one hundred eighty (180) days in the case of a claim involving Disability Retirement Benefits). The decision upon review will be made within sixty (60) days after Plan Administrator’s receipt of a request for review (forty-five (45) days in the case of a claim involving Disability Retirement Benefits), unless special circumstances require an extension of time for processing, in which case a decision will be rendered not later than one hundred twenty (120) days after receipt of a request for review (ninety (90) days in the case of a claim for Disability Retirement Benefits). A notice of such an extension must be provided to the Claimant within the initial sixty (60) day period (the initial forty-five (45) day period in the case of a claim for Disability Retirement Benefits) and must explain the special circumstances and provide an expected date of decision. The reviewer shall afford the Claimant an opportunity to review and receive, without charge, all relevant documents, information and records and to submit issues and comments in writing to Plan Administrator. The reviewer shall take into account all comments, documents, records and other information submitted by the Claimant relating to the claim regardless of whether the information was submitted or considered in the benefit determination. Upon completion of its review of an adverse initial claim determination, Plan Administrator will give the Claimant, in writing or by electronic notification, a notice containing:

• Access to Review Materials The Servicer will give the Asset Representations Reviewer access to the Review Materials for all of the Subject Receivables within sixty (60) calendar days after receipt of the review notice in one or more of the following ways in the Servicer’s reasonable discretion: (i) by electronic posting of Review Materials to a password-protected website to which the Asset Representations Reviewer has access, (ii) by providing originals or photocopies of documents relating to the Subject Receivables at one of the properties of the Servicer or (iii) in another manner agreed by the Servicer and the Asset Representations Reviewer. The Servicer may redact or remove PII from the Review Materials so long as all information in the Review Materials necessary for the Asset Representations Reviewer to complete the Asset Review remains intact and unchanged.

• Review Procedure If the Plan Administrator denies part or all of the claim, the claimant shall have the opportunity for a full and fair review by the Plan Administrator of the denial, as follows:

• Expedited Advertising Compliance Review $[ ] for the first 10 pages (minutes if audio or video); $[ ] per page (minute if audio or video) thereafter, 24 hour initial turnaround. § $[ ] FINRA filing fee per communication piece for the first 10 pages (minutes if audio or video); $[ ] per page (minute if audio or video) thereafter. FINRA filing fee subject to change. (FINRA filing fee may not apply to all communication pieces.)