Element | Optional/Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | DB Data Type | XPath |
---|
objectType | Required | ObjectTypeEnum |
| not stored in DB |
| EagleML/userAdministrationTransaction/user/objectType |
objectId | Optional |
| ObjectId |
| not stored in DB |
| EagleML/userAdministrationTransaction/user/objectId |
objectDescriptionOptional |
| FeedTypeEnum |
| not stored in DB |
| EagleML/userAdministrationTransaction/user/objectDescription |
updateTimestamp | Optional |
| dateTime |
| PACE_MASTERDBO | PACE_USERS | UPD_DATETIME | DATE | EagleML/userAdministrationTransaction/user/updateTimestamp |
customElements | Not recommended | CustomElements - Complex type |
| reserved for customizations
|
| EagleML/userAdministrationTransaction/user/customElements |
updateSource | OptionalRequired | string | 944 | PACE_MASTERDBO | PACE_USERS | UPD_USER | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/updateSource |
effectiveDateOptional |
| date |
| not stored in DB |
| EagleML/userAdministrationTransaction/user/effectiveDate |
userId | OptionalRequired | string | 1309 | PACE_MASTERDBO | PACE_USERS | USERNAME | CHAR(255) | EagleML/userAdministrationTransaction/user/userId |
emailAddressOptional |
| string |
| PACE_MASTERDBO | PACE_USERS_CONTACT_INFO | NOTIFICATION_ADDRESS | CHAR(100) | EagleML/userAdministrationTransaction/user/emailAddress |
| PACE_MASTERDBO | PACE_MAIL_USER_INFO | MAIL_ADDRESS | CHAR(100) |
passwordOptional |
| string | 1310 | PACE_MASTERDBO | PACE_USERS | PASSWORDUser Extract does not return data for the 'PASSWORD' field. This field can be changed only through UI forms, inbound interface does not process it. | CHAR(255) | EagleML/userAdministrationTransaction/user/password |
passwordSetDate | Optional |
| date | 2954 | PACE_MASTERDBO | PACE_USERS | PASSWORDSETDATE | DATE | EagleML/userAdministrationTransaction/user/passwordSetDate |
userFullNameOptional |
| string | 2941 | PACE_MASTERDBO | PACE_USERS | FULL_NAME | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/userFullName |
userDescription | Optional |
| string |
| PACE_MASTERDBO | PACE_USERS | DESCRIPTION | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/userDescription |
companyNameOptional |
| string | 4037 | PACE_MASTERDBO | PACE_USERS | COMPANYNAME | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/companyName |
authenticationModeOptional |
| AuthenticationModeEnum | 2949 | PACE_MASTERDBO | PACE_USERS | NTUSER | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/authenticationMode |
privilegeOptional |
| PrivilegeEnum | 2946 | PACE_MASTERDBO | PACE_USERS | PRIVILEGE | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/privilege |
userAdministrationRole | Optional |
| string |
| PACE_MASTERDBO | PACE_USERS | ROLE | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/userAdministrationRole |
theme | Optional |
| string | 2945 | PACE_MASTERDBO | PACE_USERS | THEME | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/theme |
eagleGatewayFlagOptional |
| YesNoOptionEnum | 2947 | PACE_MASTERDBO | PACE_USERS | EAGLE_GATEWAY | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/eagleGatewayFlag |
ldapUserFlag | Optional |
| YesNoOptionEnum | 2955 | PACE_MASTERDBO | PACE_USERS | LDAPUSER | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/ldapUserFlag |
ldapDomain | Optional |
| string |
| PACE_MASTERDBO | PACE_USERS | LDAP_DOMAIN | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/ldapDomain |
ldapServer | Optional |
| string |
| PACE_MASTERDBO | PACE_USERS | LDAP_SERVER | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/ldapServer |
changePasswordFlagOptional |
| YesNoOptionEnum | 2939 | PACE_MASTERDBO | PACE_USERS | CHANGE_PASSWORD | NUMBER | EagleML/userAdministrationTransaction/user/changePasswordFlag |
concurrentLoginsCountOptional |
| integer | 2948 | PACE_MASTERDBO | PACE_USERS | CONCURRENTLOGINS | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/concurrentLoginsCount |
accountStateOptional |
| AccountStateEnum | 4261 | PACE_MASTERDBO | PACE_USERS | ACCOUNT_STATE | CHAR(2) | EagleML/userAdministrationTransaction/user/accountState |
currentLoginCountOptional |
| integer | 4260 | PACE_MASTERDBO | PACE_USERS | NUM_LOGINS | NUMBER | EagleML/userAdministrationTransaction/user/currentLoginCount |
passwordNeverExpiresOptional | One of these 3 fields must be set | YesNoOptionEnum | 2951 | PACE_MASTERDBO | PACE_USERS | PASSWORDNEVEREXPIRES | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/passwordNeverExpires |
passwordExpiryEveryNDays | Optional | integer | 2950 | PACE_MASTERDBO | PACE_USERS | EXPIRYEVERY | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/passwordExpiryEveryNDays |
accountExpirationDateOptional | date | 2958 | PACE_MASTERDBO | PACE_USERS | ACCOUNTEXPIRATIONDATE | DATE | EagleML/userAdministrationTransaction/user/accountExpirationDate |
createDate | Optional |
| date | 4469 | PACE_MASTERDBO | PACE_USERS | CREATE_DATE | DATE | EagleML/userAdministrationTransaction/user/createDate |
lastFailedTime | Optional |
| dateTime | 2953 | PACE_MASTERDBO | PACE_USERS | LASTFAILEDTIME | DATE | EagleML/userAdministrationTransaction/user/lastFailedTime |
lastIp | Optional |
| string | 2956 | PACE_MASTERDBO | PACE_USERS | LASTIP | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/lastIp |
loginsOptional |
| integer | 2957 | PACE_MASTERDBO | PACE_USERS | LOGINS | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/logins |
passwordAgeOptional |
| integer | 2959 | PACE_MASTERDBO | PACE_USERS | PASSWORDAGE | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/passwordAge |
userTypeOptional |
| string |
| PACE_MASTERDBO | PACE_USERS | TYPE | CHAR(1) | EagleML/userAdministrationTransaction/user/userType |
unlockDateTimeOptional |
| dateTime | 2952 | PACE_MASTERDBO | PACE_USERS | UNLOCKDATETIME | DATE | EagleML/userAdministrationTransaction/user/unlockDateTime |
updateDateTime | Optional |
| dateTime | 2943 | PACE_MASTERDBO | PACE_USERS | UPD_DATETIME | DATE | EagleML/userAdministrationTransaction/user/updateDateTime |
userNtDomainOptional |
| string | 2960 | PACE_MASTERDBO | PACE_USERS | USERNTDOMAIN | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/userNtDomain |
instanceOptional |
| integer |
| PACE_MASTERDBO | PACE_USERS | INSTANCE | NUMBER | EagleML/userAdministrationTransaction/user/instance |
accessLevel | Optional |
| integer |
| PACE_MASTERDBO | PACE_USERS | ACCESSLEVEL | NUMBER | EagleML/userAdministrationTransaction/user/accessLevel |
lastOperationTimeOptional |
| dateTime | 2940 | PACE_MASTERDBO | PACE_USERS | LAST_OP_TIME | DATE | EagleML/userAdministrationTransaction/user/lastOperationTime |
lockedByOptional |
| string | 2944 | PACE_MASTERDBO | PACE_USERS | LOCKEDBY | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/lockedBy |
journalTransactionNumber | Available only on 2017R2.9 for load only | microstrategy | Optional | integer |
| PACE_MASTERDBO | UPDATE_JOURNAL | TRANSACTION_NUMBER |
| EagleML/userAdministrationTransaction/user/journalTransactionNumber |
accountingValidationFlag |
| YesNoOptionEnum |
| not stored in DB | EagleML/userAdministrationTransaction/user/accountingValidationFlag |
microstrategy |
| Microstrategy Model Data Map Table - see extra table below | EagleML/userAdministrationTransaction/user/microstrategy/ |
groups | Optional |
| Groups Data Map Table - see extra table below | EagleML/userAdministrationTransaction/user/groups/ |
entitlementsOptional |
| Entitlements Map Table - see extra table below | EagleML/userAdministrationTransaction/user/entitlements/ |
Anchor |
---|
| Microstrategy |
---|
| Microstrategy |
---|
| Microstrategy Model Data Map Table |
microstrategyBasedUserOn | Optional |
| integer | 5082 | PACE_MASTERDBO | PACE_USERS | MSTR_BASED_USER_ON | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/microstrategy/microstrategyBasedUserOn |
microstrategyUser | Optional |
| YesNoOptionEnum | 5077 | PACE_MASTERDBO | PACE_USERS | MSTR_USER | VARCHAR2(1) | EagleML/userAdministrationTransaction/user/microstrategy/microstrategyUser |
microstrategyUserIdOptional |
| string | 5079 | PACE_MASTERDBO | PACE_USERS | MSTR_USER_ID | VARCHAR2(50) | EagleML/userAdministrationTransaction/user/microstrategy/microstrategyUserId |
microstrategyLastUpdateDateOptional |
| date | 5080 | PACE_MASTERDBO | PACE_USERS | MSTR_LAST_UPDATE_DATE | DATE | EagleML/userAdministrationTransaction/user/microstrategy/microstrategyLastUpdateDate |
microstrategyRoleOptional |
| integer | 5081 | PACE_MASTERDBO | PACE_USERS | MSTR_ROLE | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/microstrategy/microstrategyRole |
microstrategyUserStatusOptional |
| integer | 5078 | PACE_MASTERDBO | PACE_USERS | MSTR_USER_STATUS | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/microstrategy/microstrategyUserStatus |
Groups Data Map Table |
group | Optional |
| Group Model Data Map Table - see extra table below | EagleML/userAdministrationTransaction/user/groups/group/ |
Group Model Data Map Table |
groupCodeOptional |
| string |
| not stored in DB |
| EagleML/userAdministrationTransaction/user/groups/group/groupCode |
groupIdOptional |
| integer |
| PACE_MASTERDBO | PACE_USERS | GROUP_ID | NUMBER | EagleML/userAdministrationTransaction/user/groups/group/groupId |
| PACE_MASTERDBO | PACE_USERS | STARSEC_GROUP_ID | NUMBER |
| PACE_MASTERDBO | EGL_CENTER_ROLE | CENTER_ROLE_ID | NUMBER(38,0) |
| PACE_MASTERDBO | PACE_USERS | INSTANCE | NUMBER |
groupNameOptional |
| string |
| PACE_MASTERDBO | PACE_USER_GROUPS | GROUP_NAME | CHAR(255) | EagleML/userAdministrationTransaction/user/groups/group/groupName |
| PACE_MASTERDBO | STARSEC_USER_GROUP | STAR_GROUP_NAME | VARCHAR2(255) |
| PACE_MASTERDBO | EGL_CENTER_ROLE | CENTER_ROLE_NAME | VARCHAR2(255) |
| PACE_MASTERDBO | PACE_USERS | USERNAME | CHAR(255) |
groupType | Optional |
| string |
| PACE_MASTERDBO | PACE_USER_GROUPS | GROUP_TYPE | CHAR(4) | EagleML/userAdministrationTransaction/user/groups/group/groupType |
centerCode | Optional |
| string |
| PACE_MASTERDBO | EGL_CENTER_ROLE | CENTER_CODE | VARCHAR2(50) | EagleML/userAdministrationTransaction/user/groups/group/centerCode |
isPrimaryRoleOptional |
| YesNoOptionEnum |
| PACE_MASTERDBO | EGL_CENTER_ROLE_USER | IS_PRIMARY_ROLE | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/groups/group/isPrimaryRole |
relationshipInstance | Optional |
| integer |
| PACE_MASTERDBO | PACE_USER_ROLE_DETAILS | INSTANCE | NUMBER | EagleML/userAdministrationTransaction/user/groups/group/relationshipInstance |
Entitlements Data Map Table |
entitlement | Optional |
| Entitlement Model Data Map Table - see extra table below | EagleML/userAdministrationTransaction/user/entitlements/entitlement/ |
Entitlement Model Data Map Table |
resource | Optional |
| string |
| not stored in DB |
| EagleML/userAdministrationTransaction/user/entitlements/entitlement/resource |
actionOptional |
| string |
| not stored in DB |
| EagleML/userAdministrationTransaction/user/entitlements/entitlement/action |
valueOptional |
| string |
| not stored in DB |
| EagleML/userAdministrationTransaction/user/entitlements/entitlement/value |