Identity Governance (IG) DB Schema information

Products

• CA Identity Governance
• CA Identity Suite

Issue/Introduction

Can we get the DB Schema documentation for Oracle? 

Environment

Release : 14.1

Component : GovernanceMinder(Role & Compliance Manager)

Resolution

Please fine the Developer resources below on IG.

On your IG system navigate to:

\CA-IdentityGovernance-14.1.0-Language-Files\Developer Resources

Here is the IG report database tables information (related to the certification)

Table Name	Primary Key	Foreign key table / Foreign key column	Table Description
I2_CLIENTS	ID		Stores Universe Information
I2_CAMPAIGN_SCD	[CLIENT_ID] [CAMPAIGN_ID]	I2_CLIENTS / CLIENT_ID	Stores the certification information like name of certification, description, campaign start and end date, state etc.
I2_CAMPAIGN_TASK_SCD	[CLIENT_ID] + [CAMPAIGN_ID] + [CAMPAIGN_TASK_ID]	I2_CLIENTS / CLIENT_ID I2_CAMPAIGN_SCD/ CAMPAIGN_ID	Stores the business flow tasks. It includes primary entity id, secondary entity id and state of task. Each task represents the link item between entities (User/Role/Resource)   [PRIMARY_ENTITY_ID] can be User Entity (I2_USER_SCD. ENTITY_ID) or Resource Entity (I2_ROLE_SCD. ENTITY_ID) or Role Entity (I2_RESOURCE_SCD. ENTITY_ID). It is same for [SECONDARY_ENTITY_ID].
I2_CAMP_REVR_ACTIONS_SCD	CLIENT_ID + CAMPAIGN_ID+ TASK_ID + ACTION_ID	I2_CLIENTS/ CLIENT_ID I2_CAMPAIGN_SCD/ CAMPAIGN_ID I2_CAMPAIGN_TASK_SCD/TASK_ID	Stores all the user actions of all the certification tasks. It includes the reviewer id RCM_USER_ID and status of the user action.
I2_CAMPAIGN_TASK_ACTIONS	CLIENT_ID + CAMPAIGN_ID+ TASK_ID + ACTION_ID	I2_CLIENTS/ CLIENT_ID I2_CAMPAIGN_SCD/ CAMPAIGN_ID I2_CAMPAIGN_TASK_SCD/TASK_ID I2_CAMP_REVR_ACTIONS_SCD/ ACTION_ID	Stores the results (Approve/Reject) of the user actions. It includes the information like Action type, Action Anchor and date information.
I2_USER_SCD			Stores the user information who are involved in the certification. It includes person id, user name, organization name and some custom fields.
I2_ROLE_SCD			Stores the role information which are involved in the certification. It includes role name, description, role type, role organization, role type, created date etc.
I2_RESOURCE_SCD			Stores the resource information which are involved in the certification. It includes Resource name1, Resource Name2, Resource Name3 and custom fields date.
I2_ACCOUNT_SCD			Stores account details which are involved in certification.