OTP_INFO_6
Description:
This table contains additional information about patient order templates.

Primary Key
Column Name Ordinal Position
OTP_ID 1

Column Information
Name Type Discontinued?
1 OTP_ID NUMERIC No
The unique identifier (.1 item) for the patient order template record.
2 RX_TYPE_CODE_C_NAME NUMERIC No
The code that identify the prescriber type, form type, and prescriber initiative.
May contain organization-specific values: Yes
No Entries Defined
3 REQ_UNITS_PER_PERIOD INTEGER No
The number of units per period requested by a procedure order. Requested units per period along with the Requested periods determines the total 'requested units'.
4 REQ_ORD_PROC_FREQ_C_NAME NUMERIC No
The frequency of visits requested (e.g. day, week, month, year) requested by a procedure order.
May contain organization-specific values: No
Category Entries:
Day
Week
Month
Year
Every Other Week
Every Other Month
Quarter
5 REQ_PERIODS INTEGER No
The number of periods requested by a procedure order. Requested units per period along with the Requested periods determines the total 'requested units'.
6 UK_SIGN_PROV_ROLE VARCHAR No
The role ID of the provider from the UK NHS system when they signed this medication.
7 RFL_START_DT VARCHAR No
The start date of the referral. Can be set in the Service Period display item in order entry and is used to set the service start dates for the referral and authorizations associated with the order.
8 ALLOW_DOSE_CHANGE_YN VARCHAR No
Flag that indicates this medication can have its dosage changed by other clinical users.
May contain organization-specific values: No
Category Entries:
No
Yes
9 CARE_ORD_SCOPE_C_NAME NUMERIC No
The scope of care for a specific service. The selectable values are unique to the service.
May contain organization-specific values: Yes
Category Entries:
Other
10 CARE_PROB_TEMPLATE_PROBLEM_ID NUMERIC No
The potential barriers for completing a specific service. The selectable values are unique to the service.
11 CARE_PROB_TEMPLATE_PROBLEM_ID_TEMPLATE_PROB_NAME VARCHAR No
This column displays the template problem name.
12 RX_EMAIL_ADDRESS VARCHAR No
Patient email address associated with the prescription.
13 RECOMMENDED_UNITS_PER_PERIOD INTEGER No
The number of recommmended units per period for a referral procedure order.
14 REFERRAL_CHANGE_TYPE_C_NAME NUMERIC No
Tracks the type of referral order being requested based on how the requested units compare to the recommended units.
May contain organization-specific values: No
Category Entries:
Recommendation (No Change)
Reduction
Addition
15 REFERRAL_CHANGE_REASON_C_NAME NUMERIC No
The reason a unit amount different than the recommended units was requested.
May contain organization-specific values: Yes
No Entries Defined
16 REFERRAL_CHANGE_COMMENT VARCHAR No
Additional comments to explain why the requested units differ from the recommended units.
17 RADIOPHARM_TRACKING_NUMBER_STR VARCHAR No
The order tracking number used in radiopharmaceutical manufacturing and radiopharmacy portals.
18 RADIOPHARM_EXPECTED_TREAT_DATE DATETIME No
The date that the radiopharmaceutical manufacturer intends for the drug to be administered.
19 SIC_YN VARCHAR No
SIC Reason
The category values for this column were already listed for column: ALLOW_DOSE_CHANGE_YN
20 SIC_REASON_C_NAME NUMERIC No
SIC Reason
May contain organization-specific values: Yes
No Entries Defined
21 SIC_COMMENT VARCHAR No
SIC Comment
22 PROV_DETERMINES_SVC_SCHED_YN VARCHAR No
Stores a flag indicating that the provider determines the schedule for the units of a service instead of the care manager recommending a specific schedule.
The category values for this column were already listed for column: ALLOW_DOSE_CHANGE_YN
23 REQ_SVC_START_DATE_OFFSET INTEGER No
Describes the frequency offset between the referral start date and the service start date for the "Every other" frequencies. Defaults to 0.
24 RECOMMENDED_ORD_PROC_FREQ_C_NAME NUMERIC No
The recommended frequency for a referral procedure order.
The category values for this column were already listed for column: REQ_ORD_PROC_FREQ_C_NAME
25 UK_AUTHORIZING_PROVIDER_ROLE VARCHAR No
The role ID of the authorizing provider from the UK NHS system when they signed this medication.
26 DAW_COMMENT VARCHAR No
DAW_COMMENT