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 |