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
- ACT Organization
Child tables
- EMD Core — Email Definition Information Table That Holds The Email Template Definitions.
- MLS_USR
- OBI OBJECT INSTANCE INFORMATION.
- OIU OBJECT INSTANCE REQUEST TARGET USER INFORMATION.
- 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
- ORR OBJECT RECONCILIATION ACTION RULES
- OSH Task Instance Assignment History
- OSI Holds information about tasks that are created for an order
- 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
- PCQ Holds the challenging questions and answers for a user
- PWH
- PXD Table that holds the list of all Proxies Defined
- RCE Reconciliation Events
- RCU Reconciliation Event Users Matched
- RCX Exceptions found in Target data during Reconciliation
- REQ THIS TABLE HOLDS REQUEST INFORMATION
- RIU Request Users Resolved Object Instances
- RML Rules To Apply To Task, Defines The Task Assignment Rules Attached To A Process Task.
- RQU REQUEST OBJECT TARGET USER INFORMATION.
- RQZ Request Users Requiring Resolution
- UPH User Policy Profile History table
- UPP User Policy Profile table
- USG This table stores which users are in which groups.
- ENT_ASSIGN
- ENT_ASSIGN_HIST
page revision: 4, last edited: 14 Jun 2012 08:23
