DOCS_RCVD_DEMOGRAPHICS
Description:
This table contains information about a patient's demographics. Each row is a patient's demographics data.

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 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 PT_DEMO_REF_ID VARCHAR No
This item stores the unique reference ID for the patient demographics row.
6 RELIGION_TEXT VARCHAR No
This item stores the religion free text.
7 RELIGION_CODE_C_NAME VARCHAR No
This item stores the standardized HL7 code mapped to the religion.
May contain organization-specific values: Yes
8 VET_STATUS_TEXT VARCHAR No
This item stores the veteran status free text.
9 VETERAN_STATUS_CODE_C_NAME VARCHAR No
This item stores the standardized foundation system code mapped to the veteran status.
May contain organization-specific values: Yes
10 SERVICE_BRANCH_TEXT VARCHAR No
This item stores the service branch free text.
11 SERVICE_BRANCH_CODE_C_NAME VARCHAR No
This item stores the EPIC foundation system code mapped to service branch.
May contain organization-specific values: Yes
Category Entries:
Air Force
Army
Coast Guard
Marine Corps
Navy
Multiple Branches
Army Reserve
Army National Guard
Marine Corps Reserve
Navy Reserve
Air Force Reserve
Air National Guard
Coast Guard Reserve