TPL_SCHED_VST_PROV
Description:
This is the related-multi table for the 'Visit Provider' item in the treatment plan scheduling group of tables.
To be used with tables:
TPL_SCHED_SELECTED
TPL_SCHED_VST_DEP
TPL_SCHED_VST_KND
TPL_SCHED_VST_LEN
TPL_SCHED_VST_TYP

Primary Key
Column Name Ordinal Position
TREATMENT_PLAN_ID 1
GROUP_LINE 2
VALUE_LINE 3

Column Information
Name Type Discontinued?
1 TREATMENT_PLAN_ID NUMERIC No
The unique ID of the treatment plan.
2 GROUP_LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 VALUE_LINE INTEGER No
The Value Count.
4 SCHEDULE_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.