Consular Consolidated Database

The Consular Consolidated Database (CCD) is a database used by the Bureau of Consular Affairs under the United States Department of State, that has over 290 million passport records, 184 million visa records, and 25 million records of U.S. citizens living overseas, and adding 35,000 visa cases a day.[1][2][3][4][5]

History

Size estimates

Year Estimated number of passport records in CCD Estimated number of visa cases in CCD Estimated number of photographs in CCD Estimated number of records in CCD of U.S. citizens living overseas EStimated daily rate of growth of visa cases
2009[6][4]: 6 [7] No estimate 100 million+ 75 million+ No estimate 35,000
2016[2] 290 million 184 million No estimate 25 million No estimate

Privacy Impact Assessments

A number of Privacy Impact Assessments have been conducted for CCD. The list below is not necessarily comprehensive.

Year Month and date Number of pages Additional notes
2008[8] December 11 9 --
2010[6] March 22 20 Original document seems unavailable online (except via Wayback Machine); however, it is referenced in a few places.[4]: 6 [7]
2015[1] July 17 15 --

Qualitative history

Some CCD records date back to the mid-1990s. Since February 2001, CCD has stored photographs of all visa applicants in electronic form. Since 2007, CCD has been storing ten-print scans.[4]

On July 19 or 20, 2014, after a software update, CCD started having significant performance issues. On July 23, CCD was brought back online with limited capacity. The Department of State worked with Microsoft and Oracle to restore the old level of performance. Due to issues with CCD, visa caseload processing was slowed down, disrupting travel experiences of people around the world.[5][7][9] The system was processing at normal rates as of August 2, but the problem was declared fully fixed a month later.[9]

A Congressional Research Service report about visa issuances, published November 18, 2015, discussed the CCD at some length.[4]

In April 2016, it was revealed that an internal review by the U.S. Department of State of its cyber-defenses had found that CCD was at risk of being compromised, though no breach had been detected.[2][3]

Linked databases

The following are the two main databases linked with CCD:[4]: 6 [6]

The Department of State's Bureau of Consular Affairs additionally uses data from the Consular Lookout and Support System (CLASS) to augment the data in CCD when processing visa cases.[4]

The 2015 Privacy Impact Assessment for CCD gives a lengthy list of systems within the Department of State that are connected to CCD.[1] The 2008 PIA lists a number of databases with which there is bi-directional data flow, along with the type of data in each, but the list may be outdated.[8]

See also

References

  1. ^ a b c "Privacy Impact Assessment (PIA) Consular Consolidated Database (CCD)" (PDF). United States Department of State. July 17, 2015. Retrieved November 21, 2017.
  2. ^ a b c Levine, Mike; Fishel, Justin (March 31, 2016). "EXCLUSIVE: Security Gaps Found in Massive Visa Database". ABC News. Retrieved November 21, 2017.
  3. ^ a b "Homeland Security – US Consular Consolidated Database vulnerable to cyber attacks". Security Affairs. April 6, 2016. Retrieved November 21, 2017.
  4. ^ a b c d e f g Wasem, Ruth Ellen (November 18, 2015). "Immigration: Visa Security Policies" (PDF). Congressional Research Service. Retrieved November 21, 2017.
  5. ^ a b "Information Regarding Ongoing Consular Consolidated Database (CCD) Performance Issues and Steps Taken". United States Department of State Bureau of Consular Affairs. August 4, 2014. Retrieved November 21, 2017.
  6. ^ a b c "Consular Consolidated Database (CCD) Privacy Impact Assessment (PIA)" (PDF). United States Department of State. March 22, 2010. Retrieved November 22, 2017.
  7. ^ a b c Rockwell, Mark (July 24, 2014). "State's passport and visa system crashes". Retrieved November 22, 2017.
  8. ^ a b c Grafeld, Margaret P. (December 11, 2008). "Privacy Impact Assessment: Consular Consolidated Database" (PDF). United States Department of State. Retrieved November 22, 2017.
  9. ^ a b Lyngaas, Sean (October 20, 2014). "Understanding State's big database crash: Q&A with Greg Ambrose. The department's director of consular systems and technology explains what happened this summer, and how his office is trying to prevent a repeat". Retrieved November 21, 2017.