This view references to one of the underlying RLS tables. When a search user connects to the CA DataMinder database, it populates this table with policies and policy classes the reviewer can see. This is specifically used with the 'Policy' RLS models.
Note: This table is not populated for admin users and can return zero rows in a report if used by an admin user.
View Stack
|
WGN_V_RLS_POLICY_1 |
||
|
→ |
TMP_WGN3POLICYRLS |
|
Column Details
|
Column |
Data Type |
Length |
Description |
|
PolicyID |
INTEGER |
4 |
Identifies the policy classification associated with the trigger. |
|
PolicyName |
VARCHAR |
255 |
Policy name associated to the PolicyID |
|
ParentPolicyID |
INTEGER |
4 |
Identifies the policy class classification associated with the trigger. |
|
ParentPolicyName |
VARCHAR |
255 |
Class name associated to the ParentPolicyID |
These are 4 views:
They were specifically designed for reporting purposes so that events could be distinguish between those that have no associated users (typically FSA type events) and events that have external participants. The RLS views for these simply point to the equivalent standard view. It is the admin views where these views become relevant as you want to be able to see all events as administrator but you also want to know if other participants on the event have internal users. The columns in these views make the equivalent standard views. However to distinguish between the 2 types of events, the UserID’s and GroupID’s are return with a value of -1 for non-hierarchical events.
Below are listed a number of other views installed into the database but are for internal use only and should not be used for reporting purposes.
|
Copyright © 2014 CA.
All rights reserved.
|
|