Table Detail Report

RX_PROTOCOL



Column Section Relationship Section Top of Page


Table-level Detail

Description: The rx_protocol file stores all parameters related to switch protocols
Definition: Stores all parameters related to switch and its communication protocols for pharmacy claim processing
Table Type: REFERENCE





Column Detail - RX_PROTOCOL


Column Name Type Null? Definition
COMPRESS_IND DOUBLE Y Specifies whether or not protocol supports compression (0 is no, 1 is yes)
CONNECT_PROMPT VARCHAR(100) Y This is the prompt string that is sent by the remote switch when a connection is established.
DIAL_ATTEMPTS DOUBLE Y Specifies number of attempts to be made to open a connection to the switch.
EOM VARCHAR(10) Y This is the end of text character that should be appended to the beginning of any message sent using this protocol.
LRC_IND DOUBLE Y Specifies whether or not messages sent using this protocol should have an LRC appended to them (0 is no, 1 is yes)
MESSAGE_PREFIX VARCHAR(15) Y Indicate string prefix to place before each input message
MESSAGE_PROMPT VARCHAR(100) Y This is the prompt that is sent by the remote switch when it is expecting a message.
OPEN_ATTEMPTS DOUBLE Y Specifies number of attempts to be made to open a connection to the network port.
OPEN_DELAY DOUBLE Y Indicates number of seconds within which to send message to keep continuous connection open
OPEN_PROTOCOL_IND DOUBLE Y Indicates whether a this protocol is continuous connection or discrete connection
PROTOCOL_CD DOUBLE N Unique key of file. Assigned Code Set 4542
READ_ATTEMPTS DOUBLE Y Specifies number of times to attempt to keep reading an incoming message.
SEND_ATTEMPTS DOUBLE Y Specifies number of times the message should be sent before disconnecting when switch negative acknowledges the message.
SOM VARCHAR(10) Y This is the start of text character that should be appended to the beginning of any message sent using this protocol.
STEP_1 VARCHAR(100) Y Step to execute for Synchronization
STEP_10 VARCHAR(100) Y Step to execute for Synchronization
STEP_11 VARCHAR(100) Y Step to execute for Synchronization
STEP_12 VARCHAR(100) Y Step to execute for Synchronization
STEP_13 VARCHAR(100) Y Step to execute for Synchronization
STEP_14 VARCHAR(100) Y Step to execute for Synchronization
STEP_15 VARCHAR(100) Y Step to execute for Synchronization
STEP_2 VARCHAR(100) Y Step to execute for Synchronization
STEP_3 VARCHAR(100) Y Step to execute for Synchronization
STEP_4 VARCHAR(100) Y Step to execute for Synchronization
STEP_5 VARCHAR(100) Y Step to execute for Synchronization
STEP_6 VARCHAR(100) Y Step to execute for Synchronization
STEP_7 VARCHAR(100) Y Step to execute for Synchronization
STEP_8 VARCHAR(100) Y Step to execute for Synchronization
STEP_9 VARCHAR(100) Y Step to execute for Synchronization
STRING1 VARCHAR(30) Y This is the user name
STRING2 VARCHAR(30) Y This is the Password
SYNCHRONIZE_IND DOUBLE Y Specifies whether or not this protocol requires a login procedure (0 is no, 1 is yes)
SYNCH_INIT_CHAR VARCHAR(10) Y This is the character required to initiate the logon procedure for this protocol
SYNCH_STEPS DOUBLE Y Number of steps to execute for synchronization.
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 - RX_PROTOCOL


Child Column in RX_PROTOCOL(FK) Parent Table Name Parent Column Name
Parents: PROTOCOL_CD CODE_VALUE CODE_VALUE


RX_REFILL_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Prescription Refill History
Definition: History of Pending Prescriptions from Interactive Voice Response foreign system
Table Type: ACTIVITY





Column Detail - RX_REFILL_HX


Column Name Type Null? Definition
ACTION_PERSONNEL_ID DOUBLE N Action Personnel Id from the Order_Action table.
ACTION_PROVIDER_ID DOUBLE N Order Provider from the Order_Action table.
ACTION_SEQUENCE DOUBLE Y Action Sequence that last modified the Script. From the Order_Action table.
AGENT_FULL_NAME VARCHAR(200) Y The full name of the proxy prescriber for the doctoras provided on the prescription.
BATCH_REFILL_DETAIL_STATUS_CD DOUBLE Y Identifies a more detailed status for the batch refill processing
BATCH_REFILL_STATUS_CD DOUBLE Y For a Refill Request that was requested via IVR, it indicates the Overall status of request.
CALLBACK_PHONE_NBR_TXT VARCHAR(50) N Displays the 10-digit phone number entered by the patient.
CALL_DT_TM DATETIME N The date and time the patient made the call.
CHILD_ORDER_ID DOUBLE N Retail order that filled the Script. From Orders table.
CLAIM_PROCESS_STATUS_CD DOUBLE Y For a Refill Request that was requested via IVR, it indicates the Status of Claims Processing
CLIN_CHECK_STATUS_CD DOUBLE Y For a Refill Request that was requested via IVR, it indicates the Status of Clinical Checking Business Rules Check.
COMMUNICATION_TYPE_CD DOUBLE N The communication type from the Order_Action table.
COMM_STATUS_CD DOUBLE N Indicates communication status
CONTROL_SUBSTANCE_FLAG DOUBLE Y identifies the controlled substance schedule for the prescribed drug.
CREDIT_CARD_TXT VARCHAR(50) N Credit card number used by the patient.
DATE_WRITTEN_TXT VARCHAR(50) Y The date the electronic prescription was created
DAW_TXT VARCHAR(100) Y The dispense as written text associated to the electronic prescription
DEA_TXT VARCHAR(200) Y The drug enforcement administration text associated to the electronic prescription
DISPENSE_HX_ID DOUBLE Y Dispense_hx_id of the dispense row that has gone through suspend workflow - primary key of dispense_hx table
DISPENSE_QTY_TXT VARCHAR(50) Y The dispense quantity associated to the electronic prescription
DISP_PRIORITY_CD DOUBLE N Dispensing Priority of Refill Event
DISP_PRIORITY_DT_TM DATETIME N The Dispense Priority Date/Time as determined by the Dispense Priority Date/time.
DISP_PRIORITY_TZ DOUBLE N The time zone used in evaluating the Dispense Priority date/time
DISP_SR_CD DOUBLE N Service Resource tied to the pharmacy location dispensing the prescription.
DR_STATUS_CD DOUBLE N The Interface status of the Physician communication of the IVR Order transaction. Status types are limited to the following:1.1.1.1 Call doctor1.1.1.2 Fax sent1.1.1.3 Fax failed1.1.1.4 Notify by Pharmacy
EASY_RX_PRIORITY_NBR DOUBLE Y A value indicating the priority of the Easy Script Order.
ENCNTR_ID DOUBLE Y Refers to the encounter id of the person tied to the refill request
ESI_LOG_ID DOUBLE N Indicates related ESI_LOG record
FILL_SR_CD DOUBLE N Service Resource tied to the pharmacy location filling the prescription.
FORMULARY_STATUS_CD DOUBLE Y Formulary status code
INTERVENTIONS_FLAG DOUBLE Y Whether an intervention (documentation) has been done or not on prescription orders placed via powerchart.
ITEM_DESC VARCHAR(400) Y The drug description for the electronic prescription
ITEM_NAME VARCHAR(400) Y The drug mnemonic for the electronic prescription
LATEST_AUTH_STATUS_CD DOUBLE N The most recent status for a refill request.
LATEST_NOTIFY_DT_TM DATETIME N Date and time when the doctor was last notified.
MED_SERVICE_CD DOUBLE N Med_service_cd for the Script's Encounter. From the Encounter table.
MSG_IDENT_TXT VARCHAR(100) Y The unique identifier assigned to the message by the sender.
MSG_TEXT_ID DOUBLE N The message received from the eRx transaction.
NDC_TXT VARCHAR(200) Y The national drug code associated to the electronic prescription
NOTES_TXT VARCHAR(250) N Notes related to Interface transaction
NOTIFY_CNT DOUBLE N The number of times the doctor was notified that a request has been made for a refill.
NURSE_UNIT_CD DOUBLE N Nurse_Unit_Cd for the Script's encounter. From the Encounter table.
ORDER_COMMENT_IND DOUBLE Y Indicates the existence of Order comment.
ORDER_DESC VARCHAR(400) Y The order description for the electronic prescription
ORDER_ID DOUBLE N A unique internal identifier for this order
ORDER_PRIORITY_CD DOUBLE N oe_field_value with oe_field_meaning_id = 141 from Order_Detail table.
PATIENT_BIRTH_DT_TXT VARCHAR(50) Y The birth date of the patient associated to the electronic prescription
PATIENT_FIRST_NAME VARCHAR(100) Y The first name of the patient associated to the electronic prescription
PATIENT_GENDER_TXT VARCHAR(50) Y The gender of the patient
PATIENT_LAST_NAME VARCHAR(100) Y The last name of the patient associated to the electronic prescription
PAYMENT_METHOD_CD DOUBLE N Method of payment rendered by the patient.
PERSON_ID DOUBLE Y The person for whom this refill request pertains.
PHARM_CHECK_STATUS_CD DOUBLE Y For a Refill Request that was requested via IVR, it indicates the Status of Pharmacy Refill Business Rules Check.
PHYSICIAN_FIRST_NAME VARCHAR(100) Y The first name of the doctor associated to the electronic prescription
PHYSICIAN_FULL_NAME VARCHAR(200) Y The full name of the doctor associated to the electronic prescription
PHYSICIAN_LAST_NAME VARCHAR(100) Y The last name of the doctor associated to the electronic prescription
PHYSICIAN_ROUTING_SELECTION_CD DOUBLE Y Holds the physician's prescription order mailing preference.
PROJECTED_FILL_DT_TM DATETIME Y Projected date/time when outpatient pharmacy order will be refilled.
REFILL_AUTH_COMM_TYPE_CD DOUBLE Y Identifies how the refill authorization request was communicated
REFILL_NBR_TXT VARCHAR(50) Y The number of refills for the electronic prescription
REFILL_STATUS_CD DOUBLE N Indicates refill status
RENEWAL_FLAG DOUBLE Y Identifies a renewal for a prescription.
RXA_PRESCRIPTION_MSG_ID DOUBLE Y The unique identifier for the electronic prescription message associated to the external prescription
RXA_SUSPEND_ACT_LOG_ID DOUBLE Y This is the primary key of rxa_suspend_act_log table. Helps in getting all the suspended activity logs tied to this suspended order.
RX_ACTION_DT_TM DATETIME Y Action Date Time of the action that generated the script. From Order_Actiont able.
RX_ACTION_SEQUENCE DOUBLE Y Action Sequence that generated the Script, from Order_Action table.
RX_ACTION_TYPE_CD DOUBLE N The type of action taken by the user from work queue monitor.
RX_ACTION_TZ DOUBLE Y Action time zone of the action that generated the Script. From the Order_Action table.
RX_COMMENT_IND DOUBLE Y Indicates the existence of Order comment.
RX_REFILL_HX_ID DOUBLE N Unique id for Rx_refill_hx table
SENDER_MSG_IDENT DOUBLE N *** OBSOLETE *** Has been replaced by MSG_IDENT_TXT
SHORT_SIG_TXT VARCHAR(400) Y The short version of the patient instructions
SIG_TXT VARCHAR(4000) Y The patient instructions for the electronic prescription
SKIP_LOOK_FORWARD_IND DOUBLE Y To deliver medicines through a mailer, system should process early to qualify the orders, and package and transfer through the mailer. Also, if a patient's order got qualified and the same patient is having refill for another order within a close period, we would want to bundle the orders for delivery. SKIP_LOOK_FORWARD_IND will determine whether the qualification should consider these preferences. If SKIP_LOOK_FORWARD_IND is 1, preferences will be considered, else not considered.
SOURCE_TYPE_FLAG DOUBLE N A flag indicating the source of the order.
SUPPLY_FLAG DOUBLE Y Identifies whether the prescription is for a supply item.
SUSPEND_ROUTING_TYPE_CD DOUBLE Y To store the specified delivery type of the medicine to the patient on the suspended order in queue. Examples: CMOP Certified Mail, Local Regular Mail, Window (in person)
SUSPEND_STAGE_CD DOUBLE Y Stores the stage in which the suspended order is in during the suspend order workflow. System will run a qualification at regular intervals to create batch of orders to be sent to CMOP location, from where the medicines will be packaged and delivered through a mailer to patients. During this process, an order will travel through various points until it reaches the patient. These points are called stages. A stage will help in identifying where the order is currently.
SUSPEND_STATUS_CD DOUBLE Y To store the status in which each suspend stage is in during the suspend order workflow
SUSPEND_STATUS_DETAIL_CD DOUBLE Y To store the failure detail type code if suspend status is fail.
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.
XRX_PATIENT_FIRST_NAME_KEY VARCHAR(200) Y For X-Rx orders, this is the Patient's first name with all capitals and punctuation removed. Used for indexing and searching for a Patient first name
XRX_PATIENT_LAST_NAME_KEY VARCHAR(200) Y For X-Rx orders, this is Patient's last name all capitals with punctuation removed. Used for indexing and searching for a Patient by last name



Relationship Detail - RX_REFILL_HX


Child Column in RX_REFILL_HX(FK) Parent Table Name Parent Column Name
Parents: DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
ESI_LOG_ID ESI_LOG ESI_LOG_ID
NURSE_UNIT_CD LOCATION LOCATION_CD
MSG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID
RXA_PRESCRIPTION_MSG_ID RXA_PRESCRIPTION_MSG RXA_PRESCRIPTION_MSG_ID
RXA_SUSPEND_ACT_LOG_ID RXA_SUSPEND_ACT_LOG RXA_SUSPEND_ACT_LOG_ID


RX_REFILL_TRACK_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Refill Tracking History
Definition: Tracks details about requests for refills on existing prescriptions.
Table Type: ACTIVITY





Column Detail - RX_REFILL_TRACK_HX


Column Name Type Null? Definition
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.
AGENT_FIRST_NAME VARCHAR(100) Y First name of person acting on the prescriber's behalf
AGENT_LAST_NAME VARCHAR(100) Y Last name of person acting on the prescriber's behalf
AUTH_STATUS_CD DOUBLE N Status of a refill request.
COMMENT_TXT VARCHAR(300) N General comments by the person entering the refill request information.
CONTACT_DT_TM DATETIME N The date and time the physician was contacted.
CONTACT_PRSNL_NAME VARCHAR(100) N The person approving or denying the refill request on behalf of the physician.
CREATED_BY_PRSNL_ID DOUBLE N The personnel that created this row.
DENIED_REASON_TXT VARCHAR(1000) Y Reason why the refill request was denied
DIAGNOSIS_CODE_TXT VARCHAR(100) Y Diagnosis code associated to the patient
NOTIFY_DT_TM DATETIME N Date and time the doctor was notified.
ORDER_ID DOUBLE Y The original order for this prescription.
REFILL_NBR DOUBLE N The number of refills approved by the physician.
REFILL_QTY DOUBLE N The dispense quantity authorized for the refill.
REQUEST_MSG_ID DOUBLE Y Identifies the request prescription message identifier that this row relates to
RESPONSE_FREE_TXT VARCHAR(300) Y Freetext response returned in the response message from a prescriber
RXA_PRESCRIPTION_MSG_ID DOUBLE Y The unique identifier for the electronic prescription message associated to the external prescription
RX_MSG_TRANS_TYPE_CD DOUBLE N Identifies the transaction type of the message (ie. NEWRX, REFREQ, REFRES, ERROR, STATUS, VERIFY)
RX_REFILL_TRACK_HX_ID DOUBLE N Unique generated number that identifies a single row on the RX_REFILL_TRACK_HX table.
STEP_TRACK_SEQ DOUBLE N An incrementing number that identifies each refill action on a particular order.
SUPPLY_DAYS DOUBLE Y Number of days the prescription will supply
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 - RX_REFILL_TRACK_HX


Child Column in RX_REFILL_TRACK_HX(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
CREATED_BY_PRSNL_ID PRSNL PERSON_ID
REQUEST_MSG_ID RXA_PRESCRIPTION_MSG RXA_PRESCRIPTION_MSG_ID
RXA_PRESCRIPTION_MSG_ID RXA_PRESCRIPTION_MSG RXA_PRESCRIPTION_MSG_ID


RX_SCRIPT_TRANSFER_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Prescription Transfer History
Definition: Used to track prescription transfers in to and out of pharmacies in the PharmNet System.
Table Type: ACTIVITY





Column Detail - RX_SCRIPT_TRANSFER_HX


Column Name Type Null? Definition
LAST_FILL_QTY DOUBLE N The quantity of the last fill (represented by last_refill_dt_tm) for the prescription.
LAST_REFILL_DT_TM DATETIME Y The Last Refill Date and Time of the prescription at the time of the transfer.
LAST_REFILL_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ORDER_ID DOUBLE N Order ID to which this transfer record is associated.
PHARMACIST_ID DOUBLE N The Person (personnel) ID of the pharmacists doing the transfer.
QTY_REMAINING DOUBLE N Quantity remaining of the prescription at the time of transfer.
REFILLS_REMAINING DOUBLE N Refills remaining of the prescription at the time of transfer.
REFILL_QTY DOUBLE N Refill quantity of the prescription at the time of transfer.
RX_DATE_DT_TM DATETIME N Original Rx Date of the prescription at the time of transfer.
RX_DATE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RX_NUM_S VARCHAR(20) N Original Rx Number of the prescription at the time of transfer.
RX_QTY DOUBLE N Original Rx Quantity of the prescription at the time of transfer.
RX_TRANSFER_HX_ID DOUBLE N Unique ID for this record
SERVICE_RESOURCE_CD DOUBLE N Service Resource CD for the order tied to this record.
SIG VARCHAR(250) N The Sig (directions for taking) of the prescription at the time of the transfer.
TOTAL_REFILLS DOUBLE N Total number of refills of the prescription at the time of the transfer.
TRANSFER_DT_TM DATETIME N Transfer Date and Time of the prescription
TRANSFER_IN_IND DOUBLE N Value of 1 is Transfer In record. Value of 0 is Transfer Out record.
TRANSFER_TZ DOUBLE N Time zone for the transfer_dt_tm
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.
XFER_ORDER_ID DOUBLE N The new order's order id created from transferring this order.
XFER_PHARMACIST_ID DOUBLE N The internal pharmacist's personnel ID of the pharmacist transferring out the internal prescription.
XFER_PHARMACIST_NAME VARCHAR(100) Y The external pharmacist's name transferring in or out the prescription.
XFER_RX_TRANSFER_CD DOUBLE N The external pharmacy the prescription was transferred to/from.
XFER_SERVICE_RESOURCE_CD DOUBLE N The internal service resource code the prescription was transferred to/from.



Relationship Detail - RX_SCRIPT_TRANSFER_HX


Child Column in RX_SCRIPT_TRANSFER_HX(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
XFER_ORDER_ID ORDERS ORDER_ID
XFER_RX_TRANSFER_CD PHA_RX_TRANSFERS RX_TRANSFER_CD
PHARMACIST_ID PRSNL PERSON_ID
XFER_PHARMACIST_ID PRSNL PERSON_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
XFER_SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


SERV_RES_EXT_PHARM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SERV RES EXT PHARM
Definition: Serv_res_ext_pharm - Stores pharmacy specific attributes of a Service Resource.
Table Type: REFERENCE





Column Detail - SERV_RES_EXT_PHARM


Column Name Type Null? Definition
AUTM_DSPNS_MACHN_CD DOUBLE N The type of the Service Resource.
COST_BASIS_CD DOUBLE N The default cost basis code for the service resource.
DEA_NUMBER VARCHAR(100) Y ALPHANUMERIC STRING FOR DEA NUMBER FOR THIS SERVICE RESOURCE
DEFAULT_ERX_PHARMACY_IND DOUBLE N Indicates that this service resource is the default resource used for new electronic prescriptions when multiple service resources have a duplicate pharmacy identifier (ie. NABP or ERx Pharmacy ID)
DISP_PRIORITY_CD DOUBLE N DEFAULT DISPENSE PRIORITY FOR THIS SERVICE RESOURCE
DOWNTIME_RANGE_ID DOUBLE N DOWN TIME RANGE INDICATOR FOR THIS SERVICE RESOURCE USED FOR DOWNTIME PRESCRIPTION NUMBER ASSIGNMENT.
ESO_DOSE_MSG_IND DOUBLE N ESO Dose Message Indicator
ESO_INGRED_IND DOUBLE N ESO Ingredient Indicator
ESO_TPN_CPMD_IND DOUBLE N ESO TPN Compound Indicator
FLOORSTOCK_IND DOUBLE Y Indicates the resource is a floorstock resource, i.e., resource is associated with or located on a patient care location and not a pharmacy location.
INV_LOCATION_CD DOUBLE N Identifies the related inventory location for a primary service resource.
NABP_NUMBER VARCHAR(100) Y ALPHA NUMERIC STRING FOR NABP NUMBER FOR THIS SERVICE RESOURCE
OTC_SALES_TAX DOUBLE Y OVER THE COUNTER - SALES TAX
PAT_CARE_LOC_IND DOUBLE Y Indicates this resource is located in a nurse unit rather than in the pharmacy.
PHARMACY_SERVICE_TYPE_CD DOUBLE N Indicates the Pharmacy Service Resource Type defined in NCPDP Pharmacy service resource type code set.
PHARMACY_TYPE_CD DOUBLE N If the service resource is a pharmacy section or subsection, indicates the type of pharmacy from code_set 4500. Currently home infusion, long term care, inpatient, mail order, and retail.
PHARM_CATEGORY_CD DOUBLE N *** OBSOLETE ***
PROVIDER_TYPE_CD DOUBLE N *** OBSOLETE ***
RXNBR_CD DOUBLE N RX Number Code - CODE VALUE FROM CODE SET 4550
RX_CHARGE_IND DOUBLE Y ** OBSOLETE ** NO LONGER USED **
RX_IN_CHARGE_ID DOUBLE N PRSNL ID OF PHARMACIST-IN-CHARGE FOR THIS SERVICE RESOURCE
SALES_TAX DOUBLE Y SALES TAX FOR THIS SERVICE RESOURCE
SERVICE_RESOURCE_CD DOUBLE N A unique internal identifier for this service resource
STATE_CONTROL_NUMBER CHAR(100) Y ALPHANUMERIC STRING FOR STATE LICENSE NUMBER FOR THIS SERVICE RESOURCE
STATE_LICENSE_NUMBER VARCHAR(100) Y ALPHANUMERIC STRING FOR STATE LICENSE NUMBER FOR THIS SERVICE RESOURCE
TAX_NUMBER VARCHAR(100) Y ALPHANUMERIC STRING FOR TAX NUMBER FOR THIS SERVICE RESOURCE
TRACK_NBR_CD DOUBLE N Track Number Code - CODE VALUE FROM CODE SET 4504
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 - SERV_RES_EXT_PHARM


Child Column in SERV_RES_EXT_PHARM(FK) Parent Table Name Parent Column Name
Parents: DOWNTIME_RANGE_ID PHARMACY_RANGE RANGE_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD