HM_PAT_ATTEST_HISTORY
Description:
The HM_PAT_ATTEST_HISTORY table contains information about current and past Health Maintenance patient attestations that were submitted through MyChart. This includes the data the patient submitted as well as information about who last acted on the attestation.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 HM_ATTEST_PHONE_NUMBER VARCHAR No
Stores the phone number of the location where a patient attested a Health Maintenance topic was completed.
4 HM_ATTEST_ST_ADDRESS VARCHAR No
Stores the street address of the location where a patient attested a Health Maintenance topic was completed.
5 HM_ATTEST_CITY VARCHAR No
Stores the city portion of the address of the location where a patient attested a Health Maintenance topic was completed.
6 HM_ATTEST_TAX_STATE_C_NAME VARCHAR No
Stores the state portion of the address of the location where a patient attested a Health Maintenance topic was completed.
May contain organization-specific values: Yes
7 HM_ATTEST_ZIP VARCHAR No
Stores the zip code portion of the address of the location where a patient attested a Health Maintenance topic was completed.
8 HM_ATTEST_COUNTY_2_C_NAME VARCHAR No
Stores the county portion of the address of the location where a patient attested a Health Maintenance topic was completed.
May contain organization-specific values: Yes
9 HM_ATTEST_COUNTRY_2_C_NAME VARCHAR No
Stores the country portion of the address of the location where a patient attested a Health Maintenance topic was completed.
May contain organization-specific values: Yes
10 HM_ATTEST_HOUSE_NUMBER VARCHAR No
Stores the house number portion of the address of the location where a patient attested a Health Maintenance topic was completed.
11 HM_ATTEST_DISTRICT_C_NAME VARCHAR No
Stores the district portion of the address of the location where a patient attested a Health Maintenance topic was completed.
May contain organization-specific values: Yes
12 HM_ATTEST_BUILDING_NAME VARCHAR No
Stores the building name portion of the address of the location where a patient attested a Health Maintenance topic was completed.
13 HM_ATTEST_FLOOR VARCHAR No
Stores the floor portion of the address of the location where a patient attested a Health Maintenance topic was completed.
14 HM_ATTEST_UNIT VARCHAR No
Stores the unit portion of the address of the location where a patient attested a Health Maintenance topic was completed.