Table: [dbo].[therapy_item_admn]
Description
Each entry defines an individual or group of dosage administrations which have to be recorded by the treatment team. The number of entries is dependent both on the frequency and duration of the course and the rx_typ of the agent being administered.
Column Information
| Column Name | SQL Type | Description |
| pt_id | nchar | A unique generated code used to identify a patient. |
| admn_id | int | Unique key to identify an agent administered to a patient. |
| pt_visit_id | int | Code to uniquely identify a patient visit. |
| rx_id | int | A unique ID, when combined with pt_id and pt_visit_id, to identify a prescription. |
| item_no | int | Code to identify the entry from the prescription which 'generated' the entries representing the doses to record. |
| admn_seq_no | int | This number is used to determine the display order within the application. |
| agt_name | nchar | Name of the agent being administered. |
| dosage_form | int | Code to indicate the administration form of the agent being administered. |
| dose_level | int | Code to indicate the level classification of the agent being administered. |
| date_time_admst | datetime | Date / time on which the dose(s) represented on each entry where administered to the patient. |
| agt_admn_typ | int | Value denoting the total number of dose recording entries generated from the agt_rx entry. This provides the ability to see where in the entire course a particular entry belongs. |
| agt_admn_seq_no | int | Number denoting the total doses expected on each dose recording entry. |
| admn_as_advised | nchar | Code to indicate whether the dose recording entry contains a group of doses or a single dose. |
| admn_dose | decimal | Value denoting the actual dose total for the dose recording entry which the user records as being administered. |
| dose_appr | nchar | Code to indicate the completion state of the dose recording entry (Y = Approved, N = Pending, C = Discontinued, D = Errored ). |
| admn_item_note_txt | nvarchar | Description of the nature of the dose administration, optionally entered by the user. |
| admn_item_note_typ | int | Not currently used. |
| how_recorded | int | Code to indicate, in general, who is responsible for conveying the information (or administering the dose) in the dose recording entry. |
| inst_id | nchar | Code assigned by ARIA which uniquely identifies an institution, or a distinct site at which ARIA software is in use. |
| userid_link | nvarchar | Userid for the user who approved the dose recording information. |
| no_doses_taken | decimal | Value denoting the number of doses taken/administered for the entry. |
| expected_date_time | datetime | Date / time when the dose(s) is expected to be administered. |
| admn_route | int | Code to indicate the route by which the dose is administered to the patient. |
| admn_dose_unit | int | Code indicating the unit of measure in which the dose amounts are recorded. |
| valid_entry_ind | nchar | Indicates if the entry is legitimate or whether it was entered in error. |
| course_adj_ind | nchar | Indicates that the date of the dose administration has been changed from its original expected date/time. |
| adjust_vrbl_id | int | Indentifies the verbal order which enables the adjusting of dose administration dates of approved prescriptions. |
| admn_stop_tstamp | datetime | Allows us to record a stop time and data for medication doses using a continuous infusion pump. |
| variance_ind | nchar | Indicates if a variance was been logged for this dose recording when TxOptions were generated and the dose recording was pending from a previous visit. |
| err_rsn_txt | nvarchar | Description of why this item administration was errored out. |
| disp_verified_tstamp | datetime | The date and time at which the dispensing of the item was verified. |
| dispensed_ind | nchar | Indicates that the item has been dispensed. |
| course_desc | nvarchar | A string to describe the course of a prescription. Derived from other fields, but included in this table to speed up outcomes processing. |
| corrected_entry_ind | nchar | This indicator will capture whether this value has changed when detailed audit logging is enabled. |
| ad_hoc_entry_ind | nchar | This indicator is "N" for all dose recs that are created automatically by approving a prescription. The indicator is set to "Y" for dose recordings that are created manually after a prescription has been approved. |
| not_dispensed_ind | nchar | Indicates that the dose or prescription will not (ever) be dispensed. |
| disp_loc_id | int | A unique key to identify a dispensing location. |
| on_hold_ind | nchar | Indicates whether the current dose is on hold or not. |
| cycle_no | int | The cycle number for this particular cycle event. |
| cycle_day | int | Holds the day of the cycle on which the event is to occur. |
| dose_wastage_amt | numeric | This will store the amount of waste from a drug, mostly used for single-dose vials where the vial size does not match the dose amount. |
| dose_wastage_unit | int | This is the unit (as defined in the unit_of_meas able ) for the amount of waste from a drug. |
| revision_no | int | This is the revision number for the individual row. 0 indicates that the row was inserted into the database by ARIA before 9.0 and before Varis ENM. |
| drug_lot_no | nchar | The drug lot number for the agent administered. |
| agt_manufacturer_id | int | The agent manufacturer, as defined in the agt_manufacturer table. |
| disclosed_flag | nchar | Indicates if the agent is to be disclosed to the immunization registry. |
| admn_site_id | int | The ID associated with an administration site stored in the base_typ and lookup_typ_culture tables |
| refused_ind | nchar | Y if dosage refused, N if dosage not refused. If the dosage is marked as being given, this value will be null |
| expiry_date | datetime | The expiry date for the selected agent |
| prepared_ind | nchar | Indicates the dispensable agent has been prepared |
| dose_rec_at_inst_id | nchar | The institution where the dose recording was administered at. |
| department_ser | bigint | This links the row to an Institution for Visit Concept. |
| provider_userid | nvarchar | This links the row to a Provider for Visit Concept. |
Last updated: June 16, 2025