Repository Database Tables

Source

$RCU_HOME/rcu/integration/oim/sql/xell.sql

Links

1. [http://idminfo.wordpress.com/2011/01/20/oracle-identity-manager-tables/]
2. table/column/LKU map

Table list

1. AAD List To Define The Administrators For Each Organization And Their Delegated Admin Privileges
2. AAP Table for storing Resource - Organization level parameter Values
3. ACP Acp - Link Table That Holds Reference To Act And Pkg Tables,
4. ACS Link Table for Account Table(ACT) and Server Table(SVR)
5. ACT Defines information about all organizations created through Xellerate
6. ADJ Contains the Java API information for the constructor with parameters and method name with parameters chosen for an adapter task of type JAVA, UTILITY, TAME, REMOTE, or XLAPI.
7. ADL Contains the all of the necessary parameters for an adapter task of type IF, ELSE IF, FOR, WHILE, SET, and VARIABLE tasks. These type of tasks are known as LOGIC TASKS
8. ADM Data mapping between parameters input/output parameters and source/sink
9. ADP Defines an adapter created through the Adapter Factory
10. ADS Database, schema and procedure name selections which define a stored procedure adapter task.
11. ADT Defines a task attached to an adapter
12. ADU Contains the web service and method chosen for a task of the Adapter Factory
13. ADV Adapter variable table contains variables that have been created for specific adapters.
14. APA
15. APD
16. APT
17. ARCH_JOB_HISTORY
18. ARS Contains custom response codes for
19. ATD
20. ATP Defines input and output parameters for the constructor and method of an adapter task of type JAVA, UTILITY, TAME, REMOTE, and XLAPI
21. ATR
22. ATS Stores which services or can be ordered by which organizations and which rates apply.
23. ATTACHMENTS
24. AUD
25. AUD_JMS
26. CALLBACK_INVOCATION_RESULT
27. CIH Holds connector specific installation history information
28. CONTEXT
29. CONTEXTVALUE
30. CT_0
31. CT_1
32. CT_10
33. CT_11
34. CT_12
35. CT_13
36. CT_14
37. CT_15
38. CT_16
39. CT_17
40. CT_18
41. CT_19
42. CT_2
43. CT_20
44. CT_21
45. CT_22
46. CT_23
47. CT_24
48. CT_25
49. CT_26
50. CT_27
51. CT_28
52. CT_29
53. CT_3
54. CT_30
55. CT_31
56. CT_4
57. CT_5
58. CT_6
59. CT_7
60. CT_8
61. CT_9
62. DAV Stores the runtime data mappings for ''Entity'' & ''Rule Generator'' adapters. The data source being an Xellerate form or child table, or a user defined process form.
63. DEP Dependencies Among Tasks Within A Workflow Process
64. DOB Data Resource definition consisting of the fully qualified class name of the data object.
65. DVT Defines the one to many relationship between Data Resources and Event Handlers (this includes adapters)
66. EIF Export Import Files. Each row contains one single file used in export/import operation. For export there is only one file.
67. EIH Export Import History. Each row represents one Data Deployment Management session.
68. EIL DB Based lock for export operation. Used to make sure only one user can import at a time. This is currently not managed through dataobjects.
69. EIO Export Import Objects. Each row represents one object exported/imported.
70. EIS Substitutions used during import process
71. EMD Core — Email Definition Information Table That Holds The Email Template Definitions.
72. ENT_ASSIGN
73. ENT_ASSIGN_DELTA
74. ENT_ASSIGN_HIST
75. ENT_LIST
76. ERR Error codes.
77. ESD Encrypted columns not within the bounds of the SDK
78. EVT Defines event handlers by providing a the process and class name. In addition the scheduling time of when the event handler can execute is set to pre (insert, update, delete) or post (insert, update, delete)
79. FAILED_TASKS
80. FUG
81. FUG List to define the administrators for each user defined object in the
82. GCD
83. GPA
84. GPG List to define the (nested)group members of User Group in the
85. GPP List to define the Administrators and their delegated admin rights over a User Group.
86. JOB_HISTORY
87. JPS_ATTRS
88. JPS_CHANGELOG
89. JPS_DN
90. LATEST_PLUGINS
91. LKU Lookup definition entries
92. LKV Lookup values
93. LOCALTEMPLATE
94. MAP XML MAP SCHEMA INFORMATION
95. MAV Stores the runtime data mappings for ''Process Task'' adapters. The data source being a process form, Location, User, Organization, Process, IT Resource, or Literal data.
96. MEV E-mail notification events
97. MIL Holds information about tasks of a process
98. MLS_LOCALE
99. MLS_UGP
100. MLS_USR
101. MSG Defines the user groups that have permission to set the status of a process task.
102. MST Task Status And Object Status Information. Holds All The Task Status To Object Status Mappings
103. mv This table stores the data from USER_TAB_COLUMNS to reduce the data dict. recursive calls for improved performance
104. MV_USER_COLS
105. NOTIFICATIONLOG
106. NOTIFICATIONTEMPLATE
107. OBA OBJECT AUTHORIZER INFORMATION.
108. OBD OBJECT DEPENDENCIES.
109. OBI OBJECT INSTANCE INFORMATION.
110. OBJ Resource Object definition information.
111. ODF HOLDS OBJECT TO PROCESS FORM DATA FLOW MAPPINGS.
112. ODV OBJECT EVENTS/ADAPTERS INFORMATION.
113. OFFLINE_USER_ATTRIBUTES
114. OIMHOME_JARS
115. OIM_RECON_CHANGES_BY_RES_MV
116. OIM_TMP_MLS_TABLE
117. OIM_TMP_RECON_MLS_TABLE
118. OIO OBJECT INSTANCE REQUEST TARGET ORGANIZATION INFORMATION.
119. OIU OBJECT INSTANCE REQUEST TARGET USER INFORMATION.
120. OOD OBJECT INSTANCE REQUEST TARGET ORGANIZATION DEPENDENCY INFORMATION.
121. OPS
122. ORC
123. ORCHCLEANUP
124. ORCHEVENTS
125. ORCHFAILEDEVENTS
126. ORCHPROCESS
127. ORC This Entity Holds The Detail On Each Order. This Could Be Considered The Items Section Of An Invoice.
128. ORD Holds information that is necessary to complete an order regardless of a process being ordered
129. ORF Resource Reconciliation Fields
130. ORR OBJECT RECONCILIATION ACTION RULES
131. OSH Task Instance Assignment History
132. OSI Holds information about tasks that are created for an order
133. OST OBJECT STATUS INFORMATION.
134. OTI Holds specific information such as status or scheduled dates about an instance of a task which are in Pending(Provisioning/Approval tasks ) and Rejected (Provisioning tasks) status buckets
135. OUD Object Instance Request Target User Dependency Information.
136. OUG List to define the administrators for each Resource Resource.
137. PCQ Holds the challenging questions and answers for a user
138. PDF PACKAGE DATA FLOW TABLE HOLDS THE DATA FLOW RELATIONSHIPS BETWEEN PACKAGES
139. PKD PACKAGE DEPENDENCY TABLE HOLDS THE DEPENDENCY RELATIONSHIPS BETWEEN CHILD PACKAGES OF A PARENT PACKAGE
140. PKG Consists of names and system keys of service processs, which consist of a group of services from the TOS table.
141. PKH Package Hierarchy Table Holds The Parent-child Relationships Between Processes.
142. PLUGIN_METADATA
143. PLUGINS
144. PLUGIN_ZIP
145. POC Stores values for the child tables of the Object/Process form of a resource being provisioned by an access policy
146. POF POLICY FIELD TABLE HOLDS THE FIELD VALUE PAIRS THAT CONSTITUTE THE DEFINITION OF A POLICY
147. POG Join table between Policy and User Groups, Specifies the groups to whom an access policy will apply.
148. POL Policy Table Holds A Policy, Defines An Access Policy In The System.
149. POP Policy Package Join Table Holds The Packages That A Particular Policy Orders For User,
150. PRF Process Reconciliation Field Mappings
151. PTY Client Properties Table
152. PUG List To Define The Administrators And Their Delegated Admin Rights For Each Process.
153. PWH
154. PWR
155. PWR Table for Password Rule Policies
156. PXD Table that holds the list of all Proxies Defined
157. QRTZ92_BLOB_TRIGGERS
158. QRTZ92_CALENDARS
159. QRTZ92_CRON_TRIGGERS
160. QRTZ92_FIRED_TRIGGERS
161. QRTZ92_JOB_DETAILS
162. QRTZ92_JOB_LISTENERS
163. QRTZ92_LOCKS
164. QRTZ92_PAUSED_TRIGGER_GRPS
165. QRTZ92_SCHEDULER_STATE
166. QRTZ92_SIMPLE_TRIGGERS
167. QRTZ92_TRIGGER_LISTENERS
168. QRTZ92_TRIGGERS
169. QUE ADMINISTRATIVE QUEUES DEFINITION
170. QUG ADMINISTRATIVE GROUP MEMBERS
171. QUM ADMINISTRATIVE QUEUE MEMBERS
172. RA_FLATFILEGTC41
173. RA_IPLANETGROUP22
174. RA_IPLANETROLE21
175. RA_IPLANETUSER23
176. RA_LDAPROLE
177. RA_LDAPROLEHIERARCHY
178. RA_LDAPROLEMEMBERSHIP
179. RA_LDAPUSER
180. RA_MLS_LDAPROLE
181. RA_MLS_LDAPUSER
182. RAO
183. RAO RESOURCE AUDIT OBJECTIVES INFORMATION.
184. RA_TELNETUSER25
185. RA_TESTGCGTC42
186. RA_UD_IPNT_GRP
187. RA_UD_IPNT_ROL
188. RAV Stores the runtime data mappings for
189. RCA Reconciliation Event Organizations Matched
190. RCB Reconciliation Event Invalid Data
191. RCD Reconciliation Event Data
192. RCE Reconciliation Events
193. RCH Reconciliation Event Action History
194. RCM Reconciliation Event Multi-Valued Attribute Data
195. RCP Reconciliation Event Processes Matched
196. RCU Reconciliation Event Users Matched
197. RCX Exceptions found in Target data during Reconciliation
198. RECON_ACCOUNT_MATCH
199. RECON_BATCHES
200. RECON_CHILD_MATCH
201. RECON_EVENT_ASSIGNMENT
202. RECON_EVENTS
203. RECON_EXCEPTIONS
204. RECON_HISTORY
205. RECON_JOBS
206. RECON_ORG_MATCH
207. RECON_ROLE_HIERARCHY_MATCH
208. RECON_ROLE_MATCH
209. RECON_ROLE_MEMBER_MATCH
210. RECON_TABLES
211. RECON_USER_MATCH
212. RECON_USER_OLDSTATE
213. REQ THIS TABLE HOLDS REQUEST INFORMATION
214. REQUEST
215. REQUEST_APPROVAL_POLICIES
216. REQUEST_APPROVALS
217. REQUEST_BENEFICIARY
218. REQUEST_BENEFICIARY_ENTITIES
219. REQUEST_BENEFICIARY_ENTITYDATA
220. REQUEST_COMMENTS
221. REQUEST_ENTITIES
222. REQUEST_ENTITY_DATA
223. REQUEST_HISTORY
224. REQUEST_STAGES
225. REQUEST_TEMPLATE
226. REQUEST_TEMPLATE_ATTRIBUTES
227. RES
228. RESOURCES
229. RES This table is used to stored adapter resources entered by the user.
230. RGM Table for Response Code Generated Milestones
231. RGP Rules To Apply To A User Group, Defines The Auto-group Membership Rules Attached To A Particular Group.
232. RGS Defines all known registries. These are used by Web Service tasks in an Adapter to communicate with a web service.
233. RIO Request Organizations Resolved Object Instances
234. RIU Request Users Resolved Object Instances
235. RLO This table contains directory URLs which are referenced by Adapter Factory jar/class files.
236. RML Rules To Apply To Task, Defines The Task Assignment Rules Attached To A Process Task.
237. ROLE_CATEGORY
238. ROLE The table is used to store role categories. A category is similar to a folder that can be used to organize roles displayed in the console. Role categories simplify the administrators browse experience,
239. ROP Rules To Apply To An Object-process Pair, Defines The Process Determination Rules Attached To A Resource Object.
240. RPC Reconciliation Event Process Child Table Matches
241. RPP Parameters passed to report.
242. RPT Stores information related to the creation of reports
243. RPW Rules To Apply To A Password Policy, Defines The Policy Determination Rules Attached To A Password Policy.
244. RQA REQUEST TARGET ORGANIZATION INFORMATION.
245. RQC REQUEST COMMMENT INFORMATION
246. RQD Contains self-registration request data for web admin.
247. RQE REQUEST ADMINISTRATIVE QUEUES
248. RQH REQUEST STATUS HISTORY
249. RQO REQUEST OBJECT INFORMATION.
250. RQU REQUEST OBJECT TARGET USER INFORMATION.
251. RQY Request Organizations Requiring Resolution
252. RQZ Request Users Requiring Resolution
253. RRE Reconciliation User Matching Rule Elements
254. RRL Reconciliation User Matching Rules
255. RRT Reconciliation User Matching Rule Element Properties
256. RSC Defines The All The Possible Response Code For A Process Task.
257. RUE Defines The Elements In A Rule Definition.
258. RUG List to define the administrators for each Request
259. RUL RULE DEFINITIONS
260. RVM Holds Recovery Milestones
261. SCH Holds specific information about an instance of a ask such as its status or scheduled dates
262. SDC Column metadata.
263. SDH Meta-Table Hierarchy.
264. SDK User define data object meta data definition
265. SDL SDK VERSION LABELS
266. SDP User defined column properties
267. SEL Data Object Permissions For Groups On A Specified Dataobject
268. SEQUENCE
269. SIL_ASYNCH_INFO
270. SIL_PARAMETERS
271. SIL_SCO_STY_JOIN
272. SIL_SERVICE_COMP
273. SIL_SYSTEM
274. SIL_SYSTEM_TYPE
275. SIL_TYPE_CATEGORY
276. SIL_TYPES
277. SPD IT Resource parameter definition
278. SRE Defines Which Pre-populate Rule Generator Will Run For A Field Of User Defined Data Object.
279. SRS IT Resource - IT Resource join
280. STA Status Codes
281. SUG
282. SVD IT Resource type definition
283. SVP IT Resource property definition
284. SVR It Resource Instance Definition
285. TEMP Global Temporary table used in the Organization Structure report
286. TEMP_ORGANIZATION_USERS
287. TOS Holds information about a process
288. TSA STORES INITIALIZATION PARAMS (NAME/VALUE PAIRS) FOR SCHEDULER TASKS
289. TSH Recording History of Task Execution in Scheduler
290. TSK SCHEDULER TASK DEFINITION INFORMATION
291. UD_IPNT_GR
292. UD_IPNT_GRP
293. UD_IPNT_OU
294. UD_IPNT_RL
295. UD_IPNT_ROL
296. UD_IPNT_USR
297. UDP User-defined field table
298. UD_TELNET
299. UD_TESTGC12
300. UGP Defines a group of users
301. UHD User Policy Profile History Details table
302. UNM "UnDo Milestone" Feature
303. UPA
304. UPA_FIELDS
305. UPA_GRP_MEMBERSHIP
306. UPA_RESOURCE
307. UPA_UD_FORMFIELDS
308. UPA_UD_FORMS
309. UPA_USR
310. UPD User Policy Profile Details table
311. UPGRADE_FEATURE_LIST
312. UPGRADE_FEATURE_STATE
313. UPH User Policy Profile History table
314. UPP User Policy Profile table
315. USG This table stores which users are in which groups.
316. USR_ATTRIBUTE_RESERVATIONS
317. USR_CONFIG_HISTORY
318. USR Stores all information regarding a user.
319. UWP Window sequence, nesting in CarrierBase explorer for each user group.
320. WF_DEFINITION
321. WF_INSTANCE
322. WIN Windows table: Windows keys, descriptions, and class names.
323. WS_SODCHECK
324. XSD This table holds Xellerate System Data