PAT_CARE_REG

Description: |
This table contains data for Patient Care Registration. Multiple rows may appear for each registration. Each row represents the data for one registration as it was added, deleted, or modified by a user at a particular point in time.

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 | ROW_IDENTIFIER | VARCHAR | No |
The row identifier is used to group current data and audit trail data that are related to the same Patient Care Registration. In this table, multiple rows may appear with the same row identifier. Each row represents an edit that was made to the particular registration. The most current set of data for the registration can be found by looking at the most recent date and time in the EDIT_DATETIME column.
4 | USER_ID | VARCHAR | No |
This item holds the User ID of the user who made the change. This column is frequently used to link to the CLARITY_EMP table.
5 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | EDIT_DATETIME | DATETIME (UTC) | No |
This item holds the date and time (in UTC) when the change was made.
7 | TYPE_C_NAME | VARCHAR | No |
The Patient Care Registration Type category ID for the registration.
May contain organization-specific values: Yes
8 | POS_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
9 | START_DATE | DATETIME | No |
The start date on which the registration became effective.
10 | END_DATE | DATETIME | No |
The end date, after which the registration is no longer effective.
11 | IS_DELETED_YN | VARCHAR | No |
Y indicates that the user deleted a registration that was made in error.
May contain organization-specific values: No
Category Entries:
No
Yes
12 | COMMENT | VARCHAR | No |
User-entered comments about a registration.
13 | ADMSN_NOTIF_YN | VARCHAR | No |
Yes indicates that the organization wishes to receive a notification upon the patient's admission.
The category values for this column were already listed for column: IS_DELETED_YN
14 | EXTERNAL_IDENTIFIER | VARCHAR | No |
An externally assigned identifier for a patient care organization.