Table Detail Report

PHA_LEGAL_CONTROLS



Column Section Top of Page


Table-level Detail

Description: PHA LEGAL CONTROLS
Definition: Pha Legal Controls - Stores state / legal status controls
Table Type: REFERENCE





Column Detail - PHA_LEGAL_CONTROLS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CONTROL_NBR_IND DOUBLE Y Control nbr ind
DISP_NOT_GREATER_RX_IND DOUBLE Y This Column is OBSOLETE
LEGAL_STATUS_CD DOUBLE N Code for Legal status code; part of key
MAX_REFILLS DOUBLE Y Maximum number of refills allowed.
MAX_TRANSFERS DOUBLE Y Maximum number of transfers allowed
NEW_DISP_QTY_RX_QTY_IND DOUBLE Y Value of one (1) indicates the New Prescription's Dispense Quantity must be less than or equal to the Prescription Quantity
ORDER_EXPIRE_MONTHS DOUBLE Y Number of anything (weeks, days, ,years, months) until the order will expire.
ORDER_EXPIRE_UNITS_CD DOUBLE N Units for Order expire time (weeks, days, months, years)
PAT_ADDRESS_IND DOUBLE Y Indicator (0,1) - Indicates whether or not the patient address is required for dispensing.
PHYS_ADDRESS_IND DOUBLE Y Indicator (0,1) - Indicates whether or not the physician address is required for dispensing.
PHYS_CONTROL_NBR_IND DOUBLE Y Physician Control Number Indicator
PHYS_DEA_IND DOUBLE Y Indicator (0,1) - Indicates whether or not the physician DEA # is required for dispensing.
REFILL_DISP_QTY_REFILL_QTY_IND DOUBLE Y Value of one (1) Indicates the Refill's Dispense Quantity must be less than or equal to the Refill Quantity
REFILL_QTY_RX_QTY_IND DOUBLE Y Value of one (1) indicates the New Prescription's Refill Quantity must be less than or equal to the Prescription Quantity. This field replaces the disp_not_greater_rx_ind.
STATE_CD DOUBLE N State for the control
UNFILLED_EXPIRE_DAYS DOUBLE Y How many days can order be unfilled before it expires
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.


PHA_REPORT_FILTER



Column Section Top of Page


Table-level Detail

Description: Pha Report Filter
Definition: Pharmacy Report Filter
Table Type: REFERENCE





Column Detail - PHA_REPORT_FILTER


Column Name Type Null? Definition
BATCH_REPORT_CD DOUBLE N Batch report code
PARENT_ENTITY_ID DOUBLE N identifier for the filter in the report like item_id, code_value,person_id, personnel id, work-list id etc.
PARENT_ENTITY_NAME CHAR(32) Y Table name that the value in column parent_entity_id originates.
PHA_REPORT_FILTER_ID DOUBLE N pha report filter id
REPORT_FILTER_CD DOUBLE N REport filter code
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.
VALUE VARCHAR(100) Y VAlue


PHA_RX_TRANSFERS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PHA RX TRANSFERS
Definition: Table that contains the Retail Transfer Locations
Table Type: REFERENCE





Column Detail - PHA_RX_TRANSFERS


Column Name Type Null? Definition
ADDRESS1 VARCHAR(100) Y First line of the location address
ADDRESS2 VARCHAR(100) Y Second line of the location address
ADDRESS3 VARCHAR(100) Y Third line of the location address
ADDRESS4 VARCHAR(100) Y Fourth line of the location address
CITY VARCHAR(100) Y Free-text City
COUNTRY_CD DOUBLE N Country
COUNTY_CD DOUBLE N County
DEA_NBR VARCHAR(100) Y DEA Number
EMAIL VARCHAR(100) Y Free-text email address
FAX VARCHAR(100) Y free textfax #
LICENSE VARCHAR(100) Y Free-text License
PHARMACIST VARCHAR(100) Y Name
PHONE1 VARCHAR(100) Y Phone number
PHONE2 VARCHAR(100) Y Secondary phone
RX_TRANSFER_CD DOUBLE N Key to this table
STATE_CD DOUBLE N State
STORE VARCHAR(100) Y Free-text Pharmacy Store Number
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(100) Y free textzip code



Relationship Detail - PHA_RX_TRANSFERS




Parent Column in PHA_RX_TRANSFERS (PK) Child Table Name Child Column Name
Children: RX_TRANSFER_CD RX_SCRIPT_TRANSFER_HX XFER_RX_TRANSFER_CD


PHA_SWITCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains Switch information for adjudication
Definition: contains Switch information
Table Type: REFERENCE





Column Detail - PHA_SWITCH


Column Name Type Null? Definition
CONTACT VARCHAR(100) Y Contact name
DIAL_CMD VARCHAR(100) Y Dial command
EMAIL VARCHAR(100) Y Email
ESCAPE_CMD VARCHAR(100) Y Escape command
FAX VARCHAR(100) Y Fax number
INITIALIZE_CMD VARCHAR(100) Y Initialize command
MODEM_PHONE1 VARCHAR(100) Y Modem Phone 1
MODEM_PHONE2 VARCHAR(100) Y Modem Phone 2
MODEM_PHONE3 VARCHAR(100) Y Modem phone 3
MODEM_PHONE4 VARCHAR(100) Y Modem phone 4
NOTES VARCHAR(255) Y notes
PHONE1 VARCHAR(100) Y Phone
PHONE2 VARCHAR(100) Y Phone 2
PORT VARCHAR(100) Y Port
PROTOCOL_CD DOUBLE N Protocol Code
SWITCH_CD DOUBLE N Switch Code
SYSTEM_NUMBER VARCHAR(100) Y System number
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 - PHA_SWITCH




Parent Column in PHA_SWITCH (PK) Child Table Name Child Column Name
Children: SWITCH_CD PHA_SWITCH_CONN_R SWITCH_CD


PHA_SWITCH_CONN_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Switch Connection Relationship
Definition: Stores relationships between a switch that processes claims and the connections by which that switch can be reached.
Table Type: REFERENCE





Column Detail - PHA_SWITCH_CONN_R


Column Name Type Null? Definition
RX_CONNECTION_ID DOUBLE N A unique value that identifies the connection from the RX_CONNECTION table.
SWITCH_CD DOUBLE N A unique value from codeset 4505 that identifies the switch from the PHA_SWITCH table.
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 - PHA_SWITCH_CONN_R


Child Column in PHA_SWITCH_CONN_R(FK) Parent Table Name Parent Column Name
Parents: SWITCH_CD PHA_SWITCH SWITCH_CD
RX_CONNECTION_ID RX_CONNECTION RX_CONNECTION_ID