Access Intelligence Center ER Diagram

Diagram Loading ...

erDiagram IDENTITY_ATRIBUTE { varchar IDENTITY_ID "This contains the unique identifier for the identity" varchar City "Identity’s City" varchar Cloud_Lifecycle_State "Identity’s Cloud Lifecycle State" varchar Company "Identity Company" varchar CompanyName "Identity CompanyName" varchar Cost_Center "Identity Cost Center" varchar Country "Identity Country" varchar Department "Identity Department" varchar Job "Identity Job" varchar Location "Identity Location" varchar Postal_Code "Identity Postal Code" varchar Region "Identity Region" varchar State "Identity State" varchar Title "Identity Title" } IDENTITY_ROLES_FULL { varchar IDENTITY_ID "This contains the unique identifier for the identity" varchar ROLE_ID "This contains the unique identifier for the role" varchar ROLE_NAME "The name of the role" varchar ROLE_DISPLAY_NAME "The user friendly name for the role" } IDENTITY { varchar ID PK "The primary Key" varchar TENANT_ID "Unique ID of customer organization" varchar IDENTITY_ID "This contains the unique identifier for the identity" timestamp IDENTITY_CREATED "Identity created Date" timestamp IDENTITY_UPDATED "Identity modified Date" varchar NAME "The name of identity" varchar DISPLAY_NAME "This is the displayable name usually First Name Last Name" varchar MANAGERS_NAME "Managers name for the identity" varchar EMAIL "Identity email" varchar STATUS "Identity status" varchar JOB_TITLE "Identity job title" varchar LOCATION "Identity location" varchar LOCATION_CODE "Identity location code" varchar DEPARTMENT "Identity department" varchar IDENTITY_CREATED_MONTH_SORT "A field to sort charts based on the month an Identity was created" number IDENTITY_CREATED_WEEK_SORT "A field to sort charts based on the week an Identity was created" timestamp SYNC_DATE "The date the data was synced to the table" } ACCESS_PROFILES_FULL { varchar IDENTITY_ID "This contains the unique identifier for the identity" varchar ACCESS_PROFILE_ID "The unique identifier of access profile" varchar ACCESS_PROFILE_NAME "The access profile name" varchar ACCESS_PROFILE_DISPLAY_NAME "The user friendly name of access profile" varchar ACCESS_PROFILE_DESCRIPTION "The description of the access profile" } IDENTITY_ACCOUNTS_FULL { varchar IDENTITY_ID "This contains the unique identifier for the identity" varchar ACCOUNT_ID "The unique identifier of the account" varchar NATIVE_IDENTITY "The native name of the identity" varchar ACCOUNT_DISPLAY_NAME "The user friendly name of the account" varchar ACCOUNT_SOURCE_ID "The unique identifier of the account source" varchar ACCOUNT_SOURCE__DISPLAY_NAME "The user friendly name of the account source" varchar ACCOUNT_SOURCE_TYPE "The type of the account source" } IDENTITY_APPS_FULL { varchar IDENTITY_ID "This contains the unique identifier for the identity often an ID" varchar APP_ID "Unique identifier of the app" varchar APP_DISPLAY_NAME "The user friendly name of the app" } IDENTITY_ENTITLEMENTS_FULL { varchar IDENTITY_ID "This contains the unique identifier for the identity often an ID" varchar ENTITLEMENT_ID "The unique identifier associated to the entitlement" varchar ENTITLEMENT_DISPLAY_NAME "The entitlement display Name" timestamp ENTITLEMENT_CREATED_DATE "Identity created date" timestamp ENTITLEMENT_UPDATED_DATE "Identity modified date" varchar ENTITLEMENT_ATTRIBUTE "The attribute associated to entitlement" varchar ENTITLEMENT_VALUE "The value of the attribute" varchar ENTITLEMENT_SOURCE_DISPLAY_NAME "The source display name to which entitlement is associated" } IDENTITY_REQUEST_WITH_DURATION { varchar ACCESS_REQUEST_ID "This contains the unique identifier for the access request" varchar DURATION_HOURS "The duration in hours from the create date of an access request to the end date of the access request" } CERTIFICATION_STATS { varchar CERTIFICATION_ID "This contains the unique identifier for the certification" timestamp DUE_DATE "The date a certification is due" timestamp FINISHED_DATE "the date a certification was completed" number DAYS_LATE "The number of days after a certfications due date that a certification was finished" number HOURS_LATE "The number of hours after a certfications due date that a certification was finished" varchar CERTIFIER_DISPLAY_NAME "The display name of the Certifier" } CERTIFICATION_ITEM { varchar CERTIFICATION_ID "This contains the unique identifier for the certification" varchar REVIEWER_ID "The identity id of the certifier" varchar IDENTITY_ID "This contains the unique identifier for the Identity" varchar ID "The unique identifier of the Certification Item" timestamp CREATED_DATE "The date a certification was created" timestamp UPDATED_DATE "The date a certification was last updated" timestamp DELETED_DATE "The date a certification was deleted" varchar APPLICATION_ID "the unique identifier of the application" varchar REVIEWED_ID "the unique identifier of the reviewed" varchar REVIEWED_TYPE "the unique typeentifier of the reviewed" varchar TYPE "the unique typeentifier of the type" varchar SUB_TYPE "the unique typeentifier of the sub" timestamp COMPLETED_DATE "the unique dateentifier of the completed" timestamp DECISION_DATE "the unique dateentifier of the decision" varchar APPROVED "the unique approvedentifier of the approved" varchar CERTIFICATION_ITEM_STATUS "the unique statusentifier of the status" varchar DECISION "the unique decisionentifier of the decision" varchar BULK "the unique bulkentifier of the bulk" varchar REMEDIATED "the unique remediatedentifier of the remediated" varchar PRIVILEGED "the unique privilegedentifier of the privileged" varchar REMEDIATION_ACTION "the unique actionentifier of the remediation" varchar MITIGATION_EXPIRATION "the unique expirationentifier of the mitigation" varchar INSTANCE "the unique instanceentifier of the instance" varchar ACCOUNT_ONLY "the unique onlyentifier of the account" varchar NEW_ACCESS "the unique accessentifier of the new" varchar POLICY_NAME "the unique nameentifier of the policy" varchar CONSTRAINT_NAME "the unique nameentifier of the constraint" timestamp SYNC_DATE "the unique dateentifier of the sync" } CERTIFICATION_IDENTITY_FULL { varchar CERT_ID "The unique identifier of a certification" varchar NAME "The Name of a certification" varchar ORIGINAL_CERTIFICATION_ID "The original unique identifier of a certification" varchar CERTIFICATION_CAMPAIGN_ID "The unique identifier of a certification campaign" varchar CERTIFICATION_CAMPAIGN_STATUS "The status of a certification campaign" varchar CERTIFICATION_CAMPAIGN_DEADLINE "The deadline of a certification campaign" varchar CERTIFICATION_CAMPAIGN_TYPE "the type of a certification campaign" varchar SIGNER_ID "The unique identity id of the signer of a certification" varchar MANAGER_ID "The unique identity id of the signers manager of a certification" varchar CERTIFIER_ID "The unique identity id of the certifier of a certification" boolean REJECTED "boolean value of the rejection status of a certification" } IDENTITY_REQUEST_IDENTITY_REQUEST_ITEM_FULL { varchar IDENTITY_REQUEST_ITEM_APPROVER_ID "The unique identity id of the identity request approver" varchar IDENTITY_REQUEST_ITEM_REQUEST_ID "The unique identity item request id" varchar IDENTITY_REQUEST_ITEM_REQUESTER_ID "The unique identity id of the identity request requester" varchar IDENTITY_ID "This contains the unique identifier for the TARGET_ID" varchar IDENTITY_REQUEST_ITEM_ID "This contains the unique identifier for the identity request item" varchar IDENTITY_REQUEST_ITEM_INSTANCE "The instance name of the identity request item" varchar IDENTITY_REQUEST_ITEM_NATIVE_IDENTITY "The native identity name for the request item" varchar IDENTITY_REQUEST_ITEM_DISPLAY_NAME "The friendly name for the identity request item" varchar IDENTITY_REQUEST_ITEM_NAME "The name for the identity request item" varchar IDENTITY_REQUEST_ITEM_VALUE "The value of the identity request item" varchar IDENTITY_REQUEST_ITEM_ANNOTATION "The annotation of the identity request item" varchar IDENTITY_REQUEST_ITEM_OPERATION "The operation of the identity request item" timestamp IDENTITY_REQUEST_ITEM_START_DATE "The date of the identity request item start" timestamp IDENTITY_REQUEST_ITEM_END_DATE "The date of the identity request item end" varchar IDENTITY_REQUEST_ITEM_APPROVED "The approved of the identity request item" varchar IDENTITY_REQUEST_ITEM_REJECTED "The rejected of the identity request item" varchar IDENTITY_REQUEST_ITEM_PROVISIONING_STATE "The state of the identity request item provisioning" varchar IDENTITY_REQUEST_ITEM_COMPILATION_STATUS "The status of the identity request item compilation" varchar IDENTITY_REQUEST_ITEM_EXPANSION_CAUSE "The cause of the identity request item expansion" number IDENTITY_REQUEST_ITEM_RETRIES "The retries of the identity request item" varchar IDENTITY_REQUEST_ITEM_PROVISIONING_ENGINE "The engine of the identity request item provisioning" timestamp IDENTITY_REQUEST_ITEM_CREATED_DATE "The date of the identity request item created" varchar IDENTITY_REQUEST_ITEM_ACCESS_REQUEST_ID "The id of the identity request item access request" timestamp IDENTITY_REQUEST_ITEM_ACCESS_REQUEST_CREATED_DATE "The date of the identity request item access request created" timestamp IDENTITY_REQUEST_ITEM_ACCESS_REQUEST_END_DATE "The date of the identity request item access request end" varchar IDENTITY_REQUEST_ITEM_EXECUTION_STATUS "The status of the eidentity request item execution" varchar IDENTITY_REQUEST_ITEM_COMPLETION_STATUS "The status of the identity request item completion" varchar IDENTITY_REQUEST_ITEM_PRIORITY "The priority of the identity request item" varchar IDENTITY_REQUEST_ITEM_ACCESS_REQUEST_REQUESTER "The requester of the identity request item access request" varchar IDENTITY_REQUEST_ITEM_APP_ID "The id of the identity request item app" varchar IDENTITY_REQUEST_ITEM_APP_DISPLAY_NAME "The name of the identity request item app display" timestamp IDENTITY_REQUEST_ITEM_REQUESTER_CREATED_DATE "The date of the identity request item requester created" timestamp IDENTITY_REQUEST_ITEM_REQUESTER_UPDATE_DATE "The date of the identity request item requester update" varchar IDENTITY_REQUEST_ITEM_TARGET_DISPLAY_NAME "The name of the identity request item target display" timestamp IDENTITY_REQUEST_ITEM_TARGET_CREATED_DATE "The date of the identity request item target created" timestamp IDENTITY_REQUEST_ITEM_TARGET_UPDATE_DATE "The date of the identity request item target update" timestamp IDENTITY_REQUEST_ITEM_APPROVER_CREATED_DATE "The date of the identity request item approver created" timestamp IDENTITY_REQUEST_ITEM_APPROVER_UPDATED_DATE "The date of the identity request item approver updated" varchar IDENTITY_REQUEST_ITEM_APPROVER_DISPLAY_NAME "The name of the identity request item approver display" varchar IDENTITY_REQUEST_ITEM_ENTITLEMENT_ID "The id of the identity request item entitlement" varchar IDENTITY_REQUEST_ITEM_ENTITLEMENT_VALUE "The value of the identity request item entitlement" varchar IDENTITY_REQUEST_ITEM_ENTITLEMENT_DISPLAY_NAME "The name of the identity request item entitlement display" varchar IDENTITY_REQUEST_ITEM_ROLE_ID "The id of the identity request item role" varchar IDENTITY_REQUEST_ITEM_ROLE_NAME "The name of the identity request item role" varchar IDENTITY_REQUEST_ITEM_ROLE_DISPLAY_NAME "The name of the identity request item role display" } IDENTITY ||--o{ IDENTITY_ATRIBUTE : "associated to and owns" IDENTITY ||--o{ IDENTITY_ROLES_FULL : "associated to and owns" IDENTITY ||--o{ ACCESS_PROFILES_FULL: "associated to and owns" IDENTITY ||--o{ IDENTITY_ACCOUNTS_FULL : "associated to and owns" IDENTITY ||--o{ IDENTITY_APPS_FULL : "associated to and owns" IDENTITY ||--o{ IDENTITY_ENTITLEMENTS_FULL : "associated to and owns" IDENTITY ||--o{ CERTIFICATION_ITEM : "associated to and owns" CERTIFICATION_ITEM ||--o{ CERTIFICATION_STATS : "associated to and owns" CERTIFICATION_ITEM ||--o{ CERTIFICATION_IDENTITY_FULL : "associated to and owns" IDENTITY ||--o{ IDENTITY_REQUEST_IDENTITY_REQUEST_ITEM_FULL : "associated to and owns" IDENTITY_REQUEST_IDENTITY_REQUEST_ITEM_FULL ||--o{ IDENTITY_REQUEST_WITH_DURATION : "associated to and owns"