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. |