SLR_COMPLETED_FOLLOW_UPS

Description: |
This table stores the completed follow-ups for a second-level review.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
REVIEW_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | REVIEW_ID | NUMERIC | No |
The unique identifier (.1 item) for the review 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 | COMP_FOL_UP_C_NAME | VARCHAR | No |
The completed follow-up category ID for the second-level review.
May contain organization-specific values: Yes
Category Entries:
Contacted Patient Contact
Changed Patient Class
Contacted Payer
Initiated Discharge Planning
5 | COMP_FOL_UP_INST_UTC_DTTM | DATETIME (UTC) | No |
The instant that the follow-up was completed, stored as UTC Time.
6 | COMP_FOL_UP_USER_ID | VARCHAR | No |
The unique ID associated with the user record that completed this follow-up. This column is frequently used to link to the CLARITY_EMP table.
7 | COMP_FOL_UP_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
8 | COMP_FOL_UP_DEL_YN | VARCHAR | No |
Indicates whether the completed follow-up was deleted by the user that marked it complete ("Y") or not ("N" or "NULL").
May contain organization-specific values: No
Category Entries:
No
Yes
9 | COMP_FOL_UP_INST_LOCAL_DTTM | DATETIME (Attached) | No |
The instant that the follow-up was completed, stored as local (patient encounter) time.