DIST_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DISTRIBUTION LIST |
Definition: | This table contains distribution list information. |
Table Type: | REFERENCE |
Column Detail - DIST_LIST
Column Name | Type | Null? | Definition |
---|---|---|---|
DIST_LIST_ID | DOUBLE | N | Unique generated number that identifies a single row. The Primary Key. |
DL_DESCRIPTION | VARCHAR(255) | Y | Textual description of the distribution list that provides more detail |
DL_NAME | VARCHAR(100) | N | Name given to the distribution list |
DL_NAME_KEY | VARCHAR(100) | Y | DL_NAME data modified for _KEY field |
DL_NAME_KEY_A_NLS | VARCHAR(400) | Y | DL_NAME key data formatted for NLS |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DIST_LIST
Parent Column in DIST_LIST (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DIST_LIST_ID | DIST_LIST_RELTN | DIST_LIST_ID |
DIST_LIST_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DISTRIBUTION LIST RELATIONSHIPS |
Definition: | The distribution list relation table defines relationships between entities and distribution list. This table can be used to identify all the entities in a specific distribution list. |
Table Type: | REFERENCE |
Column Detail - DIST_LIST_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
DIST_LIST_ID | DOUBLE | N | This is the value of the unique primary identifier of the distribution list table. It is an internal system assigned number. |
DIST_LIST_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the table. The Primary Key. |
PARENT_ENTITY_ID | DOUBLE | N | The ID of the parent entity related to the parent entity name. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | The parent entity name that indicates the type of entity. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DIST_LIST_RELTN
Child Column in DIST_LIST_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DIST_LIST_ID | DIST_LIST | DIST_LIST_ID |
FT_PRSNL_CONTACT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Free Text Personnel Contact |
Definition: | Contains free text contact information about providers (i.e. phone numbers from 3rd party services). |
Table Type: | ACTIVITY |
Column Detail - FT_PRSNL_CONTACT
Column Name | Type | Null? | Definition |
---|---|---|---|
FT_PRSNL_CONTACT_ID | DOUBLE | N | Unique generated number that identifies a single row on the FT_PRSNL_CONTACT table. |
FT_PRSNL_DEMOG_ID | DOUBLE | N | The personnel that this contact information pertains to. |
PHONE_NBR_TXT | VARCHAR(255) | Y | The phone number of the personnel in a text format. |
PHONE_NBR_TYPE_CD | DOUBLE | N | Type of phone from Code Set 43. Values can be Mobile, Home etc |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - FT_PRSNL_CONTACT
Child Column in FT_PRSNL_CONTACT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FT_PRSNL_DEMOG_ID | FT_PRSNL_DEMOG | FT_PRSNL_DEMOG_ID |
FT_PRSNL_DEMOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Free Text Personnel Demographic |
Definition: | Contains free text demographic information about providers (i.e. name, address from 3rd party services). |
Table Type: | ACTIVITY |
Column Detail - FT_PRSNL_DEMOG
Column Name | Type | Null? | Definition |
---|---|---|---|
CITY_NAME | VARCHAR(255) | Y | The name of the city of the personnel. |
FIRST_NAME | VARCHAR(255) | Y | The first name of the personnel. |
FT_PRSNL_DEMOG_ID | DOUBLE | N | Unique generated number that identifies a single row on the FT_PRSNL_DEMOG table. |
LAST_NAME | VARCHAR(255) | Y | The last name of the personnel. |
MIDDLE_NAME | VARCHAR(255) | Y | The middle name of the personnel. |
PREFIX_NAME | VARCHAR(255) | Y | The prefix name of the personnel. |
STATE_NAME | VARCHAR(255) | Y | The state name of the personnel. |
STREET2_ADDR | VARCHAR(255) | Y | The 2nd line of the address of the personnel. |
STREET_ADDR | VARCHAR(255) | Y | The street address of the personnel. |
SUFFIX_NAME | VARCHAR(255) | Y | The suffix name of the personnel. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
ZIP_CODE | VARCHAR(255) | Y | The zip code of the personnel. |
Relationship Detail - FT_PRSNL_DEMOG
Parent Column in FT_PRSNL_DEMOG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | FT_PRSNL_DEMOG_ID | FT_PRSNL_CONTACT | FT_PRSNL_DEMOG_ID |
MESSAGING_AUDIT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Messaging Audit |
Definition: | Stores audit and tracking information related to a prescription routing request. |
Table Type: | ACTIVITY |
Column Detail - MESSAGING_AUDIT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_PRSNL_ID | DOUBLE | N | The action prsnl |
AUDIT_DT_TM | DATETIME | N | The date and time the audit record was created |
AUDIT_TYPE_CD | DOUBLE | N | A Code that identifies the audit type of the message |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
ERROR_CD | DOUBLE | N | Error code identifier from code set 27401 |
MESSAGING_AUDIT_ID | DOUBLE | N | The primary key to the table. A number uniquely identifying the messaging audit record |
MSG_TEXT_ID | DOUBLE | N | The text of the message. FK from LONG_TEXT table. |
ORDERING_PHYS_ID | DOUBLE | N | The ordering physician |
ORDER_ID | DOUBLE | N | The order_id, from the orders table, that generated the task |
ORG_ID | DOUBLE | N | This is the value of the unique primary identifier of the organization table. It is an internal system assigned number. This column is either valued with the facility or the client organization for the encounter. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PHARMACY_IDENTIFIER | VARCHAR(100) | Y | identifier generated by the pharmacy directory |
PUBLISH_IND | DOUBLE | N | Indicator to determine if the record should be shown to the user |
REF_ORDER_ID | DOUBLE | N | This is the order referenced on the incoming pharmacy request. |
REF_TRANS_IDENTIFIER | VARCHAR(255) | Y | The transaction ID that came in from a foreign system. |
RX_IDENTIFIER | VARCHAR(30) | Y | The unique ordering message identifier |
STATUS_CD | DOUBLE | N | The status of the message |
STATUS_COMMENT | VARCHAR(255) | Y | The comment associated to the message. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - MESSAGING_AUDIT
Child Column in MESSAGING_AUDIT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
MSG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
REF_ORDER_ID | ORDERS | ORDER_ID | |
ORG_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID |