status and impact on United States objectives of any compacts entered into in accordance with subsection (e) and of any ongoing efforts to enter into new compacts in accordance with such subsection. 814. Interagency coordination of security assistance, transfers, and security cooperation (a) Creation of a common database Not later than two years after the date of the enactment of this Act, the Secretary, in coordination with the Secretary of Defense and other appropriate Federal departments and agencies, shall maintain a common database of information to permit the identification of security assistance programs, funding, and transfers by recipient country. (b) Coordination with the department of defense (1) In general Not later than one year after the date of the enactment of this Act, the Secretary, in coordination with the Secretary of Defense, shall submit a report to the appropriate congressional committees that assesses existing mechanisms, including provisions under title 10, United States Code, that require the concurrence of the Secretary of State, and other applicable provisions of law that provide for coordination between security assistance programs, projects, and activities of the Department of State and security cooperation programs, projects, and activities of the Department of Defense that includes the following: (A) An identification of existing coordination mechanisms for planning, executing, and overseeing security assistance and security cooperation programs, projects, and activities, the purpose of such mechanisms, and their efficacy in practice. (B) An identification of additional measures that would improve the speed, simplicity, or agility of each identified mechanism, with a focus on mechanisms requiring the concurrence of the Secretary. (C) An identification of any programs, authorities, or resources that do not require coordination under existing law. (2) Appropriate congressional committees defined In this subsection, the term appropriate congressional committees means— (A) the