DOCS_RCVD_PAT_IDENTIFIER
Description:
This table stores the patient identifier information extracted from a document received.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
The unique identifier (.1 item) for the document record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 PAT_IDENTIFIER VARCHAR No
Identifier to link patient with other tables.
5 PAT_DISPLAY_NAME VARCHAR No
Patient's name for display.
6 PAT_FAMILY_NAME VARCHAR No
Patient's family name.
7 PAT_LEGAL_RCPT_MEM_SEX_C_NAME VARCHAR No
The patient legal sex category ID as gathered from a document received.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
8 PAT_BIRTH_DATE DATETIME No
The date when the patient was born.
9 PAT_NATIONAL_IDENTIFIER VARCHAR No
Patient's national identifier.