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 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'.
3 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
4 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'.
5 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.
6 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
7 CARE_PROB_TEMPLATE_PROBLEM_ID NUMERIC No
The potential barriers for completing a specific service. The selectable values are unique to the service.
8 CARE_PROB_TEMPLATE_PROBLEM_ID_TEMPLATE_PROB_NAME VARCHAR No
This column displays the template problem name.
9 RECOMMENDED_UNITS_PER_PERIOD INTEGER No
The number of recommmended units per period for a referral procedure order.
10 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
11 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
12 REFERRAL_CHANGE_COMMENT VARCHAR No
Additional comments to explain why the requested units differ from the recommended units.
13 RADIOPHARM_TRACKING_NUMBER_STR VARCHAR No
The order tracking number used in radiopharmaceutical manufacturing and radiopharmacy portals.
14 RADIOPHARM_EXPECTED_TREAT_DATE DATETIME No
The date that the radiopharmaceutical manufacturer intends for the drug to be administered.
15 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.
May contain organization-specific values: No
Category Entries:
No
Yes