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.