Base View idvCategoryNames

Description

This view exposes the user defined names of the six categories that can be attached to a client.

The result set of the view is a singleton. Note that the inclusion of RecordType and UserId is purely to give the view a logical primary key and allow its smooth migration into a report services model.

 

For use by

Base view suitable for advanced end users.

 

Columns

Always4

Always has value 4 - present to support logical primary keys

AlwaysZero

Always has value 0 - present to support logical primary keys

Category1

Name for category number 1

Category2

Name for category number 2

Category3

Name for category number 3

Category4

Name for category number 4

Category5

Name for category number 5

Category6

Name for category number 6

 

  •