IB_RX_REQ



Column Section Relationship Section Top of Page


Table-level Detail

Description: Inbound RX Request
Definition: Contains prescription requests from a foreign pharmacy system for an action on an existing prescription (i.e. renewal).
Table Type: ACTIVITY





Column Detail - IB_RX_REQ


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y The time the request was received from the foreign system.
DAYS_SUPPLY_NBR DOUBLE N *** OBSOLETE ****
DISPENSE_AS_WRITTEN_CD DOUBLE N *** OBSOLETE ****
DISPENSE_QTY DOUBLE N The amount of the drug to be dispensed.
DISPENSE_QTY_UNIT_CD DOUBLE N *** OBSOLETE ****
DRUG_DESCRIPTION_TXT VARCHAR(255) Y *** OBSOLETE ****
GROUP_AVAIL_IND DOUBLE N Used to tell whether this prescription request is available to be rolled up with other prescription requests.
IB_RX_REQ_ID DOUBLE N Unique, generated number that is used to identify an individual row on the IB_RX_REQ table.
IB_RX_REQ_PERSON_DEMOG_ID DOUBLE N Unique number identifying the person demographic this inbound request is for.
LAST_FILL_DT_TM DATETIME Y Deprecated. Date of last fill of prescription from pharmacy. Use with NCPDP Script10.6 or lower specification.
ORDER_DT_TM DATETIME Y Deprecated. Date the prescription was written by the physician. Use with NCPDP Script10.6 or lower specification.
PHARMACIST_FIRST_NAME VARCHAR(255) Y The first name of the pharmacist on the incoming request.
PHARMACIST_LAST_NAME VARCHAR(255) Y The last name of the pharmacist on the incoming request.
PHARMACIST_MIDDLE_NAME VARCHAR(255) Y The middle name of the pharmacist on the incoming request.
PHARMACIST_PREFIX_NAME VARCHAR(255) Y The prefix of the pharmacist's name on the incoming request.
PHARMACIST_SUFFIX_NAME VARCHAR(255) Y The suffix of the pharmacist's name on the incoming request.
PHARM_CITY_NAME VARCHAR(255) Y The name of the pharmacy's city.
PHARM_COMMENT_TXT VARCHAR(255) Y *** OBSOLETE ****
PHARM_IDENTIFIER VARCHAR(255) N The pharmacy that is requesting action on the prescription.
PHARM_NAME VARCHAR(255) Y The name of the pharmacy.
PHARM_PRIMARY_PHONE VARCHAR(80) Y The primary phone number of the pharmacy.
PHARM_RX_TRANS_IDENT VARCHAR(255) Y The unique transaction identifier from the pharmacy system sending the prescription request.
PHARM_STATE_NAME VARCHAR(255) Y The state the pharmacy is located in.
PHARM_STREET2_ADDR VARCHAR(255) Y The second line of the pharmacy's address.
PHARM_STREET_ADDR VARCHAR(255) Y The first line of the pharmacy's address.
PHARM_ZIP_CODE VARCHAR(255) Y The zip code of the pharmacy.
PRN_IND DOUBLE N *** OBSOLETE ****
PRODUCT_IDENTIFIER VARCHAR(255) Y *** OBSOLETE ****
PROD_IDENT_TYPE_CD DOUBLE N *** OBSOLETE ****
REF_ORDER_ID DOUBLE N This is the order identifier referenced on the incoming pharmacy request. This identifier is not guaranteed to match any Millennium order on the domain.
REMAINING_REFILL_QTY DOUBLE N *** OBSOLETE ****
REQ_TYPE_FLAG DOUBLE N Identifies the type of action requested.
SPECIAL_INSTRUCTIONS_TXT VARCHAR(255) Y *** OBSOLETE ****
SURE_SCRIPT_VERSION_FLAG DOUBLE N The version of surescript used to create this inbound request. 0 indicates an undefined version. 1 specifies 8.1, 2 specifies 10.6, 3 specifies NCPDP201701.
TECH_FIRST_NAME VARCHAR(255) Y *** OBSOLETE ****
TECH_LAST_NAME VARCHAR(255) Y *** OBSOLETE ****
TECH_MIDDLE_NAME VARCHAR(255) Y *** OBSOLETE ****
TECH_PREFIX_NAME VARCHAR(255) Y *** OBSOLETE ****
TECH_SUFFIX_NAME VARCHAR(255) Y *** OBSOLETE ****
TO_PRSNL_ID DOUBLE N The ID of the intended personnel for the prescription request.
TRANS_IDENTIFIER VARCHAR(255) N The unique transaction identifier from the foreign system sending the prescription request.
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.
ZERO_REFILLS_SPECIFIED_IND DOUBLE N *** OBSOLETE ****



Relationship Detail - IB_RX_REQ


Child Column in IB_RX_REQ(FK) Parent Table Name Parent Column Name
Parents: IB_RX_REQ_PERSON_DEMOG_ID IB_RX_REQ_PERSON_DEMOG IB_RX_REQ_PERSON_DEMOG_ID
TO_PRSNL_ID PRSNL PERSON_ID




Parent Column in IB_RX_REQ (PK) Child Table Name Child Column Name
Children: IB_RX_REQ_ID IB_RX_REQ_ACTION IB_RX_REQ_ID
IB_RX_REQ_DRUG IB_RX_REQ_ID
IB_RX_REQ_FOLLOW_UP IB_RX_REQ_ID
IB_RX_REQ_PRSNL_DEMOG IB_RX_REQ_ID
IB_RX_REQ_SUBTYPE IB_RX_REQ_ID
TASK_SUBACTIVITY IB_RX_REQ_ID


IB_RX_REQ_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Inbound Rx Request Action
Definition: Contains actions taken on prescription requests from a foreign pharmacy system.
Table Type: ACTIVITY





Column Detail - IB_RX_REQ_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The date and time there match was made either by the system or by a user.
ACTION_PRSNL_ID DOUBLE N The personnel who took the action. Actions can also be taken by the system, so in that case, this field will have a zero.
ACTION_SEQ_NBR DOUBLE N The sequence number for the order the actions were taken.
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
APPROVED_ORDER_ID DOUBLE Y The approved order identifier that replaces the originally referenced order.
BEGIN_EFFECTIVE_DT_TM DATETIME N The time at which the action was taken.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
IB_RX_REQ_ACTION_ID DOUBLE N Unique, generated number that identifies an individual row on the IB_RX_REQ_ACTION table.
IB_RX_REQ_ID DOUBLE N The related inbound prescription request.
PROPOSED_ENCNTR_ID DOUBLE N The encounter that is currently related to the inbound prescription request.
PROPOSED_PERSON_ID DOUBLE N The patient that is currently related to the inbound prescription request.
REQ_STATUS_CD DOUBLE N The current status of the prescription request. Examples of code meanings are: UNMATCHED, SYS_MATCH_P, SYS_MATCH_O, VERIFIED, ACCEPTED, REJECTED, REPLACED.
TRANS_IDENT VARCHAR(255) Y The unique transaction identifier for an outbound rx change deny or approve call to the foreign system.
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_ACTION


Child Column in IB_RX_REQ_ACTION(FK) Parent Table Name Parent Column Name
Parents: PROPOSED_ENCNTR_ID ENCOUNTER ENCNTR_ID
IB_RX_REQ_ID IB_RX_REQ IB_RX_REQ_ID
APPROVED_ORDER_ID ORDERS ORDER_ID
PROPOSED_PERSON_ID PERSON PERSON_ID
ACTION_PRSNL_ID PRSNL PERSON_ID


IB_RX_REQ_CONTACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Inbound Rx Request Contact
Definition: Stores the contact information for the patient on the inbound pharmacy request.
Table Type: ACTIVITY





Column Detail - IB_RX_REQ_CONTACT


Column Name Type Null? Definition
EMAIL_ADDR VARCHAR(255) Y The patient's email address provided on the inbound request.
IB_RX_REQ_CONTACT_ID DOUBLE N Unique, generated number that is used to identify an individual row on the IB_RX_REQ_CONTACT table.
IB_RX_REQ_PERSON_DEMOG_ID DOUBLE N Relationship to the person this contact information is for.
PHONE_NBR_TXT VARCHAR(255) Y The phone number of the patient identified on the inbound request.
PHONE_NBR_TYPE_CD DOUBLE N The type of phone of the associated 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_CONTACT


Child Column in IB_RX_REQ_CONTACT(FK) Parent Table Name Parent Column Name
Parents: IB_RX_REQ_PERSON_DEMOG_ID IB_RX_REQ_PERSON_DEMOG IB_RX_REQ_PERSON_DEMOG_ID


IB_RX_REQ_DIAGNOSIS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Inbound RX Request Diagnosis
Definition: Contains the diagnosis information for the prescription request on the inbound pharmacy request.
Table Type: ACTIVITY





Column Detail - IB_RX_REQ_DIAGNOSIS


Column Name Type Null? Definition
DIAGNOSIS_SEQ DOUBLE N Preserves the order the diagnosis list was received from the pharmacy.
DIAGNOSIS_SOURCE_NAME VARCHAR(255) Y The person or pharmacy that added the diagnosis to the request.
IB_RX_REQ_DIAGNOSIS_ID DOUBLE N Unique, generated number that identifies an individual row on the IB_RX_REQ_DIAGNOSIS table.
IB_RX_REQ_DRUG_ID DOUBLE N The drug for this diagnosis.
IB_RX_REQ_ID DOUBLE N *** OBSOLETE ****
NOMENCLATURE_ID DOUBLE N Unique identifier from nomenclature table, which is used to identify the diagnosis.
NOMEN_SOURCE_IDENT_VALUE VARCHAR(255) Y The diagnosis on the incoming request.
NOMEN_STRING_SOURCE_CD DOUBLE N Represents the external source that owns the nomen_source_ident_value.
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_DIAGNOSIS


Child Column in IB_RX_REQ_DIAGNOSIS(FK) Parent Table Name Parent Column Name
Parents: IB_RX_REQ_DRUG_ID IB_RX_REQ_DRUG IB_RX_REQ_DRUG_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


IB_RX_REQ_DRUG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Inbound Pharmacy Request Drug
Definition: Contains drug information for the prescription request on the inbound pharmacy request (i.e. prescribed, dispensed)
Table Type: ACTIVITY





Column Detail - IB_RX_REQ_DRUG


Column Name Type Null? Definition
COMPOUND_DRUG_DESC LONGBLOB Y Multiple drug ingredient descriptions for a specific compound drug.
DAYS_SUPPLY_NBR DOUBLE Y The number of days that the drug is supposed to last.
DISPENSE_AS_WRITTEN_CD DOUBLE N Indicates whether or not the drug needs to be dispensed exactly as written or if it can be changed.
DISPENSE_QTY DOUBLE Y The amount of the drug to be dispensed.
DISPENSE_QTY_UNIT_CD DOUBLE N The units associated with the dispense_qty.
DRUG_DESCRIPTION_TXT VARCHAR(255) Y The description of the drug that contains information such as Drug Name, Strength, and Dose.
DRUG_SEQ DOUBLE N Preserves the order the drug list was received from the pharmacy.
IB_RX_REQ_DRUG_ID DOUBLE N Unique, generated number that identifies a single row on the IB_RX_REQ_DRUG table.
IB_RX_REQ_ID DOUBLE N The inbound request for this drug.
LAST_FILL_DATE_TXT VARCHAR(30) Y ISO 8601 Date of last fill of prescription from pharmacy. Used with NCPDP Script 2017071 and higher specification.
LAST_FILL_DT_TM DATETIME Y The date on which the prescription was last filled.
ORDER_DT_TM DATETIME Y The date and time on which the drug was ordered.
PHARM_COMMENT_TXT VARCHAR(255) Y Comments from the sending pharmacy.
PRN_IND DOUBLE N Indicates if the drug can be taken as needed.
PRODUCT_IDENTIFIER VARCHAR(255) Y The drug that is on the incoming request.
PRODUCT_SCHEDULE_FLAG DOUBLE N The DEA schedules that controlled drugs are divided into based on their potential for abuse and physical and psychological dependence.
PRODUCT_TYPE_FLAG DOUBLE N Indicates the product type for the drug. Values: 0 - Neither, 1 - Compound, 2 - Supply.
PROD_IDENT_TYPE_CD DOUBLE N The product type code that the drug is identified by. For example: NDC. From code set 11000.
REF_ORDER_ID DOUBLE N *** OBSOLETE ***
REMAINING_REFILL_QTY DOUBLE Y The number of refills remaining on the prescription.
RENEWAL_TYPE_FLAG DOUBLE N This field is the type_flag and not just used for renewals (badly named). Indicates the type of request for this drug. 1 indicates this is a prescribed drug. 2 indicates this is a dispensed drug. 3 indicates this is a requested drug. 4 indicates this is a preferred requested drug
SPECIAL_INSTRUCTIONS_TXT VARCHAR(1000) Y Text instructions received with the incoming request.
SYNONYM_ID DOUBLE Y This field corresponds to a matched order's synonym_id for the requested product identifier of the drug. This will be 0 if unable to match the product identifier or if a product identifier is not specified. This implies the drug will be free-text.
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.
WRITTEN_DATE_TXT VARCHAR(30) Y ISO 8601 Date the prescription was written by the physician. Used with NCPDP Script 2017071 and higher specification.
ZERO_REFILLS_SPECIFIED_IND DOUBLE N Indicates whether the pharmacy actually specified zero refills. 1 indicates that they did explicitly specify that there were zero refills. 0 indicates that the pharmacy either did note refills or specified a number of refills greater than zero.



Relationship Detail - IB_RX_REQ_DRUG


Child Column in IB_RX_REQ_DRUG(FK) Parent Table Name Parent Column Name
Parents: IB_RX_REQ_ID IB_RX_REQ IB_RX_REQ_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID




Parent Column in IB_RX_REQ_DRUG (PK) Child Table Name Child Column Name
Children: IB_RX_REQ_DRUG_ID IB_RX_REQ_DIAGNOSIS IB_RX_REQ_DRUG_ID