Base View idvService

Description

This view exposes the rows in ISOL1417 that represent services.

Type = Base view suitable for advanced end user use

 

Columns

ClientObjectType Type of client object
ClientInternalId Internal identifier of client object
JobTypeInternalId The internal identifier of the job type
InternalId The service internal Id for table ISOL1417
DateStarted Date service started
DateTerminated Date service terminated
OverrideRecurrence How often jobs in this service recur (for practice management job tracking) - see idvTranslateRecurrence. This is an override for values from the job type. It will normally not be present
OverrideRecurrenceRate The internal coding of OverrideRecurrence

 

This view is directly inherited by the following views: