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
16 | RX_EMAIL_ADDRESS | VARCHAR | No |
Patient email address associated with the prescription.