ACCOM_DATA
Description:
This table stores overtime data for a documented accommodation need for a patient. Data stored in this table includes end user facing data as well as modification history.

Primary Key
Column Name Ordinal Position
ACCOM_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 ACCOM_ID NUMERIC No
The unique identifier (.1 item) for the accommodation 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 ACCOM_COMMENT VARCHAR No
Contains a free-text comment about a patient's accommodation need. This comment can be used to provide additional context information about an accommodation.
4 ACCOM_SOURCE_C_NAME VARCHAR No
The accommodation source category ID for the patient accommodation need.
May contain organization-specific values: Yes
Category Entries:
Default
Patient
Organization
Both
None
5 UPDATED_INST_UTC_DTTM DATETIME (UTC) No
Contains an instant an accommodation was updated.
6 DIS_ACC_UPDATED_BY_C_NAME VARCHAR No
The updated by category ID for the patient accommodation need.
May contain organization-specific values: Yes
Category Entries:
Patient
End user
7 UPDATED_USER_ID VARCHAR No
Contains a user that updated the accommodation, if it was a user who updated it.
8 UPDATED_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 ACCOM_NAME VARCHAR No
Contains the accommodation name for free-text accommodations. Should be empty for discrete accommodations.
10 RESOLVED_INST_UTC_DTTM DATETIME (UTC) No
Contains the instant this accommodation was marked as resolved. This means that the patient no longer needs this accommodation.