Table Detail Report

PHA_TRANSFER_ACTION



Column Section Top of Page


Table-level Detail

Description: Table to control order actions on transfer
Definition: order actions to be performed on transfer
Table Type: REFERENCE





Column Detail - PHA_TRANSFER_ACTION


Column Name Type Null? Definition
ACTION DOUBLE Y Action to be taken upon transfer.
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.
FROM_LOCATION_CD DOUBLE N Location Patient is transferring from
TO_LOCATION_CD DOUBLE N Location patient is transferring to
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_WH_FORMAT



Column Section Top of Page


Table-level Detail

Description: Wholesaler format information
Definition: Stores information about wholesaler cost update formats.
Table Type: REFERENCE





Column Detail - PHA_WH_FORMAT


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.
COST_BASIS_CD DOUBLE N Cost field that this format will be used to update (AWP, Cost1,Cost2...).
COST_END DOUBLE Y End position for cost.
COST_START DOUBLE Y Start position for cost.
DECIMAL_POSITION DOUBLE Y Implied decimal position for cost.
DRUG_IDENTIFIER_END DOUBLE Y End position for drug identifier.
DRUG_IDENTIFIER_START DOUBLE Y Start position for drug identifier.
INNER_PACKAGE_IND DOUBLE N Indicates that the cost for this format should be divided by inner package size.
OUTER_PACKAGE_IND DOUBLE N Indicates that the cost for this format should be divided by outer package size.
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.
WH_FORMAT_CD DOUBLE N Uniquely identifies a wholesaler format.


PHA_WH_UPLOAD



Column Section Top of Page


Table-level Detail

Description: Wholesaler cost update information
Definition: Stores cost update information from wholesalers.
Table Type: ACTIVITY





Column Detail - PHA_WH_UPLOAD


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.
COST DOUBLE Y Udated wholesaler cost
COST_BASIS_CD DOUBLE N Cost field that this cost will be used to update (AWP, Cost1,Cost2...).
DRUG_IDENTIFIER VARCHAR(255) N Drug identifier
PHA_WH_UPLOAD_ID DOUBLE N Primary key to uniquely identify each row.
POST_DT_TM DATETIME Y Date and time this cost was used to update the Manufacturer_item 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.
UPLOAD_DT_TM DATETIME N Date and time this information was originally loaded into the table.
WH_FORMAT_CD DOUBLE N Indicates which wholesaler format was used to load this data.


PRICE_RANGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Price Range
Definition: Pricing schedules for PharmNet
Table Type: REFERENCE





Column Detail - PRICE_RANGE


Column Name Type Null? Definition
ADMIN_FEE DOUBLE Y Fee charged for administration of medication
COPAY DOUBLE Y Amount of isurance copay
COPAY_PERCENT DOUBLE Y Insurance copay percentage
FROM_COST DOUBLE N Bottom tier of price range
MARKDOWN DOUBLE Y Amount of Markdown
MARK_UP DOUBLE Y Mark up on each product dispensed
MIN_PRICE DOUBLE Y Minimum price charged regardless of calculated price
PRICE_SCHED_ID DOUBLE N Oracle assigned key for table
ROUND_UP DOUBLE Y Rounding factor for calculated price
SERVICE_FEE DOUBLE Y Dispensing fee for each dispense
SERVICE_FEE_PERCENT DOUBLE Y Service fee percentage
TO_COST DOUBLE Y Upper limit for price range
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 - PRICE_RANGE


Child Column in PRICE_RANGE(FK) Parent Table Name Parent Column Name
Parents: PRICE_SCHED_ID PRICE_SCHED PRICE_SCHED_ID


REASON_EVENT_R



Column Section Top of Page


Table-level Detail

Description: REASON EVENT R
Definition: Reason Code/Event relationship
Table Type: REFERENCE





Column Detail - REASON_EVENT_R


Column Name Type Null? Definition
CREDIT_IND DOUBLE N Indicates whether or not the corresponding event and reason will result in a financial credit.
EVENT_CD DOUBLE N Pharmacy Event code
REASON_CD DOUBLE N Pharmacy Reason Code
TEXT_REQUIRED_IND DOUBLE N Indicates whether a free text reason is required if this associated reason code is selected.
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.