Attribute Mapping of Entities

This appendix provides the attribute mapping of Oracle Identity Role Intelligence (OIRI) and Oracle Identity Governance (OIG) for each entities, which are user, application, role, entitlement, account, assigned entitlement, role user membership, role hierarchy, and role entitlement composition.

OIRI and OIG User Attribute Mapping

OIRI Attribute	OIG Attribute
EXT_USER_ID	user key
USER_NAME	user login
LAST_NAME	user last name
FIRST_NAME	user first name
MIDDLE_NAME	user middle name
DISPLAY_NAME	user display name
TITLE	user title
LOCALE	user locale
PREFERRED_LANGUAGE	user language
STATUS	user status
WORK_EMAIL	user email
PRIMARY_EMAIL_TYPE	If the value of user email is not null, then the value of this attribute is Work. Otherwise, the value of this attribute is blank.
WORK_STATE	user state
WORK_POSTAL_CODE	user postal code
WORK_COUNTRY	user country
EMPLOYEE_NUMBER	user employee number
EMPLOYEE_TYPE	user employee type
JOB_CODE	user job code
ORGANIZATION	user organization name
PARENT_ORG_NAME	user parent organization
DIVISION	user organization division
DEPARTMENT	user department number
MANAGER_NAME	manager login
MANAGER_DISPLAY_NAME	manager display name
DEPROVISIONED_DATE	user deprovisioned date
DEPROVISIONING_DATE	user deprovisioning date
DESCRIPTION	user description
FULL_NAME	user full name
OFFICE_NAME	user office name
TERRITORY	user territory

OIRI and OIG Application Attribute Mapping

OIRI Attribute	OIG Attribute
EXT_APP_ID	application instance key
NAME	application name
DISPLAY_NAME	application display name
TYPE	Disconnected / object name
DESCRIPTION	application description
RISK_SCORE	catalog item risk

OIRI and OIG Role Attribute Mapping

OIRI Attribute	OIG Attribute
EXT_ROLE_ID	role key
NAME	role name
DISPLAY_NAME	role display name
DESCRIPTION	role description
RISK_SCORE	catalog item risk

OIRI and OIG Entitlement Attribute Mapping

OIRI Attribute	OIG Attribute
EXT_ENT_ID	entitlement key
NAME	entitlement name(lookup code)
DISPLAY_NAME	entitlement display name(lookup decode)
APPLICATION_NAME	application name
GRANTEE_TYPE	process form description
EXT_GRANTEE_ID	resource object key
GRANTEE_NAME	process form entitlement field label
RISK_SCORE	catalog item risk

OIRI and OIG Account Attribute Mapping

OIRI Attribute	OIG Attribute
EXT_ACCOUNT_ID	account id
ACCOUNT_NAME	account name
ACCOUNT_TYPE	account type
USER_NAME	user login
APPLICATION_NAME	application name

OIRI and OIG Assigned Entitlement Attribute Mapping

OIRI Attribute	OIG Attribute
EXT_USER_ID	user key
USER_NAME	user login
ENTITLEMENT_NAME	entitlement name(lookup code)
APPLICATION_NAME	application name

OIRI and OIG Role User Membership Attribute Mapping

OIRI Attribute	OIG Attribute
EXT_ROLE_ID	role key
ROLE_NAME	role name
USER_NAME	user login

OIRI and OIG Role Hierarchy Attribute Mapping

OIRI Attribute	OIG Attribute
ROLE_NAME	role name
NESTED_ROLE_NAME	child role name

OIRI and OIG Role Entitlement Composition Attribute Mapping

OIRI Attribute	OIG Attribute
EXT_ROLE_ID	role key
ROLE_NAME	role name
ENTITLEMENT_NAME	entitlement name(lookup code)
APPLICATION_NAME	application name