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 |
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 |
VARCHAR(100) | Y | ||
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 |