REGADDL_PAT
Description:
The additional registration items are used to store organization specific patient data which is captured during Prelude or ADT workflows. The REGADDL_PAT table contains all of the patient level items where a user may enter only a single value.

Primary Key
Column Name Ordinal Position
PAT_ID 1

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 REGADDL_PAT_1_C_NAME VARCHAR No
First of eight additional registration patient level category columns. The usage of this data element is defined by your organization.
May contain organization-specific values: Yes
3 REGADDL_PAT_2_C_NAME VARCHAR No
Second of eight additional registration patient level category columns. The usage of this data element is defined by your organization.
May contain organization-specific values: Yes
No Entries Defined
4 REGADDL_PAT_3_C_NAME VARCHAR No
Third of eight additional registration patient level category columns. The usage of this data element is defined by your organization.
May contain organization-specific values: Yes
No Entries Defined
5 REGADDL_PAT_4_C_NAME VARCHAR No
Fourth of eight additional registration patient level category columns. The usage of this data element is defined by your organization.
May contain organization-specific values: Yes
No Entries Defined
6 REGADDL_PAT_5_C_NAME VARCHAR No
Fifth of eight additional registration patient level category columns. The usage of this data element is defined by your organization.
May contain organization-specific values: Yes
No Entries Defined
7 REGADDL_PAT_6_C_NAME VARCHAR No
Sixth of eight additional registration patient level category columns. The usage of this data element is defined by your organization.
May contain organization-specific values: Yes
No Entries Defined
8 REGADDL_PAT_7_C_NAME VARCHAR No
Seventh of eight additional registration patient level category columns. The usage of this data element is defined by your organization.
May contain organization-specific values: Yes
No Entries Defined
9 REGADDL_PAT_8_C_NAME VARCHAR No
Eighth of eight additional registration patient level category columns. The usage of this data element is defined by your organization.
May contain organization-specific values: Yes
No Entries Defined
10 REGADDL_PAT_1_DT DATETIME No
First of three additional registration patient level date columns. The usage of this data element is defined by your organization.
11 REGADDL_PAT_2_DT DATETIME No
Second of three additional registration patient level date columns. The usage of this data element is defined by your organization.
12 REGADDL_PAT_3_DT DATETIME No
Third of three additional registration patient level date columns. The usage of this data element is defined by your organization.
13 REGADDL_PAT_1_TM DATETIME (Local) No
First of three additional registration patient level time columns. The usage of this data element is defined by your organization.
14 REGADDL_PAT_2_TM DATETIME (Local) No
Second of three additional registration patient level time columns. The usage of this data element is defined by your organization.
15 REGADDL_PAT_3_TM DATETIME (Local) No
Third of three additional registration patient level time columns. The usage of this data element is defined by your organization.
16 REGADDL_PAT_1_NUM NUMERIC No
First of three additional registration patient level numeric columns. The usage of this data element is defined by your organization.
17 REGADDL_PAT_2_NUM NUMERIC No
Second of three additional registration patient level numeric columns. The usage of this data element is defined by your organization.
18 REGADDL_PAT_3_NUM NUMERIC No
Third of three additional registration patient level numeric columns. The usage of this data element is defined by your organization.
19 REGADDL_PAT_1_STR VARCHAR No
First of five additional registration patient level string columns. The usage of this data element is defined by your organization.
20 REGADDL_PAT_2_STR VARCHAR No
Second of five additional registration patient level string columns. The usage of this data element is defined by your organization.
21 REGADDL_PAT_3_STR VARCHAR No
Third of five additional registration patient level string columns. The usage of this data element is defined by your organization.
22 REGADDL_PAT_4_STR VARCHAR No
Fourth of five additional registration patient level string columns. The usage of this data element is defined by your organization.
23 REGADDL_PAT_5_STR VARCHAR No
Fifth of five additional registration patient level string columns. The usage of this data element is defined by your organization.