USR table

OIM User records

Fields

USR_KEY NUMBER(19) not null
ACT_KEY NUMBER(19) not null
USR_LAST_NAME VARCHAR2(150 CHAR) not null
USR_FIRST_NAME VARCHAR2(150 CHAR)
USR_MIDDLE_NAME VARCHAR2(80 CHAR)
USR_DISPLAY_NAME VARCHAR2(382 CHAR)
USR_MANAGER VARCHAR2(12 CHAR)
USR_TYPE VARCHAR2(30 CHAR) not null
USR_LOCATION VARCHAR2(34 CHAR)
USR_FSS VARCHAR2(255 CHAR)
USR_TODO VARCHAR2(16 CHAR)
USR_PASSWORD VARCHAR2(200 CHAR) not null
USR_DISABLED VARCHAR2(1 CHAR)
USR_PWD_CANT_CHANGE VARCHAR2(1 CHAR)
USR_PWD_MUST_CHANGE VARCHAR2(1 CHAR)
USR_PWD_NEVER_EXPIRES VARCHAR2(1 CHAR)
USR_UPDATE_AD VARCHAR2(20 CHAR)
USR_CREATED DATE
USR_STATUS VARCHAR2(25 CHAR)
USR_EMP_TYPE VARCHAR2(255 CHAR) not null
USR_LOGIN VARCHAR2(256 CHAR)
USR_DISABLED_BY_PARENT VARCHAR2(1 CHAR)
USR_PWD_EXPIRE_DATE DATE
USR_PWD_WARN_DATE DATE
USR_MANAGER_KEY NUMBER(19)
USR_POLICY_UPDATE VARCHAR2(1 CHAR)
USR_PWD_WARNED VARCHAR2(1 CHAR)
USR_PWD_EXPIRED VARCHAR2(1 CHAR)
USR_START_DATE DATE
USR_END_DATE DATE
USR_PROVISIONING_DATE DATE
USR_DEPROVISIONING_DATE DATE
USR_PROVISIONED_DATE DATE
USR_DEPROVISIONED_DATE DATE
USR_EMAIL VARCHAR2(256 CHAR)
USR_LOCKED VARCHAR2(1 CHAR)
USR_LOGIN_ATTEMPTS_CTR NUMBER(19)
USR_PWD_RESET_ATTEMPTS_CTR NUMBER(19)
USR_CHANGE_PWD_AT_NEXT_LOGON VARCHAR2(1 CHAR)
USR_PWD_MIN_AGE_DATE DATE
USR_DATA_LEVEL NUMBER(1)
USR_CREATE DATE
USR_CREATEBY NUMBER(19)
USR_UPDATE DATE
USR_UPDATEBY NUMBER(19)
USR_NOTE CLOB
USR_TIMEZONE VARCHAR2(100 CHAR)
USR_LOCALE VARCHAR2(100 CHAR)
USR_LOCKED_ON DATE
USR_MANUALLY_LOCKED VARCHAR2(1 CHAR)
USR_AUTOMATICALLY_DELETE_ON DATE
USR_FULL_NAME VARCHAR2(240 CHAR)
USR_COUNTRY VARCHAR2(100 CHAR)
USR_DEPT_NO VARCHAR2(80 CHAR)
USR_DESCRIPTION VARCHAR2(2000 CHAR)
USR_COMMON_NAME VARCHAR2(240 CHAR)
USR_EMP_NO VARCHAR2(80 CHAR)
USR_FAX VARCHAR2(4000 CHAR)
USR_GEN_QUALIFIER VARCHAR2(80 CHAR)
USR_HIRE_DATE DATE
USR_HOME_PHONE VARCHAR2(20 CHAR)
USR_LOCALITY_NAME VARCHAR2(80 CHAR)
USR_MOBILE VARCHAR2(20 CHAR)
USR_PAGER VARCHAR2(20 CHAR)
USR_HOME_POSTAL_ADDRESS VARCHAR2(2800 CHAR)
USR_POSTAL_ADDRESS VARCHAR2(2800 CHAR)
USR_POSTAL_CODE VARCHAR2(30 CHAR)
USR_PO_BOX VARCHAR2(20 CHAR)
USR_STATE VARCHAR2(120 CHAR)
USR_STREET VARCHAR2(120 CHAR)
USR_TELEPHONE_NUMBER VARCHAR2(4000 CHAR)
USR_TITLE VARCHAR2(80 CHAR)
USR_INITIALS VARCHAR2(10 CHAR)
USR_PWD_GENERATED VARCHAR2(1 CHAR)
USR_LDAP_ORGANIZATION VARCHAR2(240 CHAR)
USR_LDAP_ORGANIZATION_UNIT VARCHAR2(240 CHAR)
USR_LDAP_GUID VARCHAR2(256 CHAR)
USR_LDAP_DN VARCHAR2(2048 CHAR)
USR_ROWVER RAW(8)
USR_ACCESSIBILITY_MODE VARCHAR2(20 CHAR)
USR_COLOR_CONTRAST VARCHAR2(10 CHAR)
USR_FONT_SIZE VARCHAR2(10 CHAR)
USR_NUMBER_FORMAT VARCHAR2(30 CHAR)
USR_CURRENCY VARCHAR2(20 CHAR)
USR_DATE_FORMAT VARCHAR2(20 CHAR)
USR_TIME_FORMAT VARCHAR2(20 CHAR)
USR_EMBEDDED_HELP VARCHAR2(10 CHAR)
USR_LANGUAGE VARCHAR2(100 CHAR)
USR_TERRITORY VARCHAR2(100 CHAR)
USR_NAME_PREFERRED_LANG VARCHAR2(20 CHAR)

Parent tables

  1. ACT Organization

Child tables

  1. EMD Core — Email Definition Information Table That Holds The Email Template Definitions.
  2. MLS_USR
  3. OBI OBJECT INSTANCE INFORMATION.
  4. OIU OBJECT INSTANCE REQUEST TARGET USER INFORMATION.
  5. ORC This Entity Holds The Detail On Each Order. This Could Be Considered The Items Section Of An Invoice. This Entity Is The Instance Of A Particular Process
  6. ORR OBJECT RECONCILIATION ACTION RULES
  7. OSH Task Instance Assignment History
  8. OSI Holds information about tasks that are created for an order
  9. 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
  10. PCQ Holds the challenging questions and answers for a user
  11. PWH
  12. PXD Table that holds the list of all Proxies Defined
  13. RCE Reconciliation Events
  14. RCU Reconciliation Event Users Matched
  15. RCX Exceptions found in Target data during Reconciliation
  16. REQ THIS TABLE HOLDS REQUEST INFORMATION
  17. RIU Request Users Resolved Object Instances
  18. RML Rules To Apply To Task, Defines The Task Assignment Rules Attached To A Process Task.
  19. RQU REQUEST OBJECT TARGET USER INFORMATION.
  20. RQZ Request Users Requiring Resolution
  21. UPH User Policy Profile History table
  22. UPP User Policy Profile table
  23. USG This table stores which users are in which groups.
  24. ENT_ASSIGN
  25. ENT_ASSIGN_HIST
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License