Table Detail Report

IB_RX_REQ_FOLLOW_UP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Inbound Pharmacy Request Follow Up
Definition: Tracks follow-up requests from the pharmacy for inbound eRx workflows.
Table Type: ACTIVITY





Column Detail - IB_RX_REQ_FOLLOW_UP


Column Name Type Null? Definition
FOLLOW_UP_CNT DOUBLE N Count that indicates the number of follow-up attempts for this Rx request.
IB_RX_REQ_FOLLOW_UP_ID DOUBLE N Unique generated number that identifies a single row on the IB_RX_REQ_FOLLOW_UP table.
IB_RX_REQ_ID DOUBLE N References the associated Rx for the follow-up request.
MESSAGE_IDENT VARCHAR(255) N References the associated Rx for the follow-up request.
RECEIVED_DT_TM DATETIME Y Date/Time the follow-up request was received.
RELATES_TO_MESSAGE_IDENT VARCHAR(255) N MESSAGE_IDENTIFIER of the linked Rx follow-up request used in the conversation.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - IB_RX_REQ_FOLLOW_UP


Child Column in IB_RX_REQ_FOLLOW_UP(FK) Parent Table Name Parent Column Name
Parents: IB_RX_REQ_ID IB_RX_REQ IB_RX_REQ_ID


IB_RX_REQ_PERSON_DEMOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Inbound Rx Request Person Demographics
Definition: Contains the patient demographic information for the prescription request on the inbound pharmacy request. Multiple prescription request may be associated to the same patient demographics.multiple Inbound Rx Requests will be linked to this person.
Table Type: ACTIVITY





Column Detail - IB_RX_REQ_PERSON_DEMOG


Column Name Type Null? Definition
BIRTH_DT_TM DATETIME Y *** OBSOLETE ***
BIRTH_DT_TXT VARCHAR(10) Y Field used to store birth date for the patient associated to the RxChange formatted as YYYY-MM-DD
BIRTH_PREC_FLAG DOUBLE Y Used to denote what information was captured for birth date. A flag of 1 means the date is precise to the day, a flag of 2 means the date is precise to month and a flag of 3 means the date is precise to year. A flag of 0 means the date precision is not set and will default to precise to the day if the date exists.
CITY_NAME VARCHAR(255) Y The patient's city address.
FIRST_NAME VARCHAR(255) Y The patient's first name.
GENDER_CD DOUBLE N Gender of the patient.
IB_RX_REQ_ID DOUBLE N *** OBSOLETE ***
IB_RX_REQ_PERSON_DEMOG_ID DOUBLE N Unique, generated number that is used to identify an individual person demographic.
LAST_NAME VARCHAR(255) Y The patient's last name.
MIDDLE_NAME VARCHAR(255) Y The patient's middle name.
PATIENT_IDENTIFIER VARCHAR(255) Y The value that comes from the foreign system and is their identification for the patient.
PATIENT_IDENTIFIER_TYPE_CD DOUBLE N The foreign system's method of identifying a patient.
PERSON_ID DOUBLE N *** OBSOLETE ****
PREFIX_NAME VARCHAR(255) Y The prefix of the patient's name.
STATE_NAME VARCHAR(255) Y The patient's state address.
STREET2_ADDR VARCHAR(255) Y The second line of the patient's street address.
STREET_ADDR VARCHAR(255) Y The first line of the patient's street address.
SUFFIX_NAME VARCHAR(255) Y The suffix of the patient's name.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
ZIP_CODE VARCHAR(255) Y The patient's zip code.



Relationship Detail - IB_RX_REQ_PERSON_DEMOG




Parent Column in IB_RX_REQ_PERSON_DEMOG (PK) Child Table Name Child Column Name
Children: IB_RX_REQ_PERSON_DEMOG_ID IB_RX_REQ IB_RX_REQ_PERSON_DEMOG_ID
IB_RX_REQ_CONTACT IB_RX_REQ_PERSON_DEMOG_ID
TASK_ACTIVITY IB_RX_REQ_PERSON_DEMOG_ID
TASK_ACTIVITY_MSG_H IB_RX_REQ_PERSON_DEMOG_ID


IB_RX_REQ_PRSNL_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Inbound Rx Request Personnel Alias
Definition: Contains the alias information related the personnel demographics.
Table Type: ACTIVITY





Column Detail - IB_RX_REQ_PRSNL_ALIAS


Column Name Type Null? Definition
ALIAS VARCHAR(255) N The alias is an identifier (NPI number, DEA number, etc.) for a personnel.
ALIAS_TYPE_CD DOUBLE N Person alias type code identifies a kind or type of alias (i.e., SSN, MRN, Financial Number, Community MRN, etc.). They have Cerner pre-defined meanings in the common data foundation table allowing HNA applications to look for a specific kind of alias.
IB_RX_REQ_PRSNL_ALIAS_ID DOUBLE N Unique, generated number that identifies a single row on the IB_RX_REQ_PRSNL_ALIAS table.
IB_RX_REQ_PRSNL_DEMOG_ID DOUBLE N The personnel for this alias.
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 - IB_RX_REQ_PRSNL_ALIAS


Child Column in IB_RX_REQ_PRSNL_ALIAS(FK) Parent Table Name Parent Column Name
Parents: IB_RX_REQ_PRSNL_DEMOG_ID IB_RX_REQ_PRSNL_DEMOG IB_RX_REQ_PRSNL_DEMOG_ID


IB_RX_REQ_PRSNL_CONTACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Inbound Pharmacy Request Personnel Contact
Definition: Stores the contact information of the personnel on the Inbound RX Request.
Table Type: ACTIVITY





Column Detail - IB_RX_REQ_PRSNL_CONTACT


Column Name Type Null? Definition
IB_RX_REQ_PRSNL_CONTACT_ID DOUBLE N Unique, generated number that identifies a single row on the IB_RX_REQ_PRSNL_CONTACT table.
IB_RX_REQ_PRSNL_DEMOG_ID DOUBLE N The personnel for this contact.
PHONE_NBR_TXT VARCHAR(255) Y The phone number of the personnel identified on the inbound request.
PHONE_NBR_TYPE_CD DOUBLE N The type of phone associated to the phone number. Ex: cell, home.
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 - IB_RX_REQ_PRSNL_CONTACT


Child Column in IB_RX_REQ_PRSNL_CONTACT(FK) Parent Table Name Parent Column Name
Parents: IB_RX_REQ_PRSNL_DEMOG_ID IB_RX_REQ_PRSNL_DEMOG IB_RX_REQ_PRSNL_DEMOG_ID


IB_RX_REQ_PRSNL_DEMOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Inbound Pharmacy Request Personnel Demographic
Definition: Stores the demographic information of the personnel of an Inbound RX Request.
Table Type: ACTIVITY





Column Detail - IB_RX_REQ_PRSNL_DEMOG


Column Name Type Null? Definition
CITY_NAME VARCHAR(255) Y The personnel's city name.
FIRST_NAME VARCHAR(255) Y The first name of the personnel.
IB_RX_REQ_ID DOUBLE N The inbound request this personnel is related to.
IB_RX_REQ_PRSNL_DEMOG_ID DOUBLE N Unique generated number that identifies a single row on the IB_RX_REQ_PRSNL_DEMOG table.
LAST_NAME VARCHAR(255) Y The personnel's last name.
MIDDLE_NAME VARCHAR(255) Y The personnel's middle name.
PREFIX_NAME VARCHAR(255) Y The prefix of the personnel's name.
PRSNL_TYPE_FLAG DOUBLE N Indicates the type of personnel. 1 is a prescriber, 2 is a supervisor.
STATE_NAME VARCHAR(255) Y The personnel's state.
STREET2_ADDR VARCHAR(255) Y The second line of the personnel's address.
STREET_ADDR VARCHAR(255) Y The first line of the personnel's address.
SUFFIX_NAME VARCHAR(255) Y The suffix of the personnel's name.
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 personnel's zip code.



Relationship Detail - IB_RX_REQ_PRSNL_DEMOG


Child Column in IB_RX_REQ_PRSNL_DEMOG(FK) Parent Table Name Parent Column Name
Parents: IB_RX_REQ_ID IB_RX_REQ IB_RX_REQ_ID




Parent Column in IB_RX_REQ_PRSNL_DEMOG (PK) Child Table Name Child Column Name
Children: IB_RX_REQ_PRSNL_DEMOG_ID IB_RX_REQ_PRSNL_ALIAS IB_RX_REQ_PRSNL_DEMOG_ID
IB_RX_REQ_PRSNL_CONTACT IB_RX_REQ_PRSNL_DEMOG_ID