member_canonical
The canonical member table. Other tables have foreign keys to this table.
Primary Key:Checks:member_canonical_ssn_check-((length(ssn) = 9) AND (ssn !~~ '%0000'::text))
member_canonical_ssn_idx(Unique) -ssn
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
member_id | bigint | No | Yes | - |
ssn | text | No | Yes | Social Security Number (From NM109 code 34 or REF SY) |
ssn_verified | boolean | No | No | Whether the SSN has been verified to be correct. No verified SSNs may be a duplicate of themselves but an unverified member could still share the same SSN. |