Previous Topic: Wgn3RoleNext Topic: Wgn3ResourceRole

Database Schema and Views Reference Guide › Database Tables › Wgn3Resource

Wgn3Resource

This will contain one entry for every resource that can exist in the system. Its relationship with the resource type is mandatory, each resource must be of a defined resource type. Its relationship with policy class is optional, as we do not want to be constrained that we can only create resources for policy classes. It’s relationship with resource level will also be optional, but is unused in CA DataMinder r12.5 and is for future use

For CA DataMinder r12.5, there will be 1 Wgn3Resource for every entry in Wgn_v_Policy_Class, with a reference to the WGN3ResourceType that corresponds to ‘Review/ View’.

Column

Primary Key

Datatype

Length

Notes

ResourceUID

Unique ID of the resource

Yes

INTEGER

4

 

ResourceTypeUID

The resource Type

 

INTEGER

4

Foreign key to wgn3resourcetype

PolicyNodeUID

The Policy Class

 

INTEGER

4

Foreign key to wgn_v_policy_class

LevelID

The associated resource level

 

INTEGER

4

Not used in CA DataMinder r12.5

Name

The name of the resource

 

VARCHAR

255

 

NumericValue

Numeric value to associate with the resource

 

INTEGER

4

Not used in CA DataMinder r12.5

CharValue

Character value to associate with the resource

 

VARCHAR

255

Not used in CA DataMinder r12.5

DateValue

Date value to associate with the resource

 

TIMESTAMP

 

Not used in CA DataMinder r12.5