EUSER_MIGRATE |
Default Table Name | EUSER_MIGRATE |
Definition |
EUSER_MIGRATE Columns |
ColumnName | Domain | Datatype | NULL | Definition |
UID | VARCHAR2(36) | NO | ||
UserID | VARCHAR2(36) | YES | ||
UserName | VARCHAR2(128) | YES | ||
Password | VARCHAR2(128) | YES | ||
FirstName | VARCHAR2(50) | YES | ||
LastName | VARCHAR2(50) | YES | ||
VARCHAR2(128) | YES | |||
AuthenticationMethod | NUMBER(3, 0) | NO | ||
ActiveDirectoryUserID | VARCHAR2(128) | YES | ||
LicenseType | NUMBER(10, 0) | NO | ||
UserRoles | VARCHAR2(4000) | YES | ||
SecurityGroup | VARCHAR2(36) | YES | ||
SecurityOrganizationID | VARCHAR2(50) | YES | ||
HomeOrganizationID | VARCHAR2(50) | YES | ||
IsLaborSuppressed | NUMBER(1, 0) | NO | ||
HasAlternateMenu | NUMBER(1, 0) | NO | ||
EmployeeID | VARCHAR2(50) | YES | ||
PasswordChangeDate | DATE | YES | ||
LastLoginDate | DATE | YES | ||
IsLockedOut | NUMBER(1, 0) | NO | ||
NeedsPasswordReset | NUMBER(1, 0) | NO | ||
LoginFailureCount | NUMBER(10, 0) | NO | ||
IsActive | NUMBER(1, 0) | NO | ||
CreationDate | DATE | NO | ||
CreatedBy | VARCHAR2(36) | YES | ||
ModifiedDate | DATE | YES | ||
ModifiedBy | VARCHAR2(36) | YES |
EUSER_MIGRATE Primary and Unique Keys |
Key Name | Key Type | Keys |
EUSER_MIGRATE Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |