Table

cm_identity_documents

Description

Identity Documents

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement


co_person_id

integer, foreign key

CO ID

cm_co_people:id


document_type

varchar(2)

Identity Document Type

TAP Core Schema (draft)

  • BC: Birth Certificate
  • DL: Driver's License
  • L: Local (eg: a town government ID)
  • N: National
  • ND: Non Driver (ie: an identity card issued by a motor vehicle agency to non drivers)
  • P: Passport
  • R: Regional (eg: a state or province ID)
  • RC: Residency (a residency card, such as a US Green Card)
  • SA: Self Assertion
  • T: Tribal
  • V: Visa

document_subtype

varchar(80)

Identity Document Subtype


The Subtype varies by Type. For example, the Subtype for a Visa would be the Visa type (typically identified by a short sequence of letters and/or numbers)

issuing_authority

varchar(80)

The entity with legal authority for issuing the document


This will typically be (eg) the name of a country or state, as opposed to a department ("United States" and not "Passport Office")
subjectvarchar(80)The name for the subject as identified on the document
The name as printed on the document should be stored, even if it is not the preferred or common name for the subject
document_identifiervarchar(80)Document Identifier
eg: Passport number
valid_fromdatetime

Identity Document is valid from this time

If null, valid any time through valid_through


valid_throughdatetimeIdentity Document is valid through (but not past) this timeIf null, valid any time from valid_from


verification_methodvarchar(2)How the Identity Document was verified
  • O: Online (validated via database or API lookup)
  • P: Physical (in person visual inspection)
  • R: Remote (via video call or similar)
  • X: None

verifier_identifiervarchar(256)Authenticated identifier of Verifier

verifier_commentvarchar(256)Comment from Verifier at time of verification

  • No labels