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