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 |
ObjectId | not stored in DB | EagleML/userAdministrationTransaction/user/objectId | |||||
objectDescription |
FeedTypeEnum | not stored in DB | EagleML/userAdministrationTransaction/user/objectDescription | ||||||
updateTimestamp |
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 |
Required | string | 944 | PACE_MASTERDBO | PACE_USERS | UPD_USER | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/updateSource |
effectiveDate |
date | not stored in DB | EagleML/userAdministrationTransaction/user/effectiveDate | ||||||
userId |
Required | string | 1309 | PACE_MASTERDBO | PACE_USERS | USERNAME | CHAR(255) | EagleML/userAdministrationTransaction/user/userId |
emailAddress |
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) | |||||
password |
string | 1310 |
User 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 |
date | 2954 | PACE_MASTERDBO | PACE_USERS | PASSWORDSETDATE | DATE | EagleML/userAdministrationTransaction/user/passwordSetDate | |
userFullName |
string | 2941 | PACE_MASTERDBO | PACE_USERS | FULL_NAME | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/userFullName | ||
userDescription |
string | PACE_MASTERDBO | PACE_USERS | DESCRIPTION | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/userDescription | ||
companyName |
string | 4037 | PACE_MASTERDBO | PACE_USERS | COMPANYNAME | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/companyName | ||
authenticationMode |
AuthenticationModeEnum | 2949 | PACE_MASTERDBO | PACE_USERS | NTUSER | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/authenticationMode | ||
privilege |
PrivilegeEnum | 2946 | PACE_MASTERDBO | PACE_USERS | PRIVILEGE | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/privilege | ||
userAdministrationRole |
string | PACE_MASTERDBO | PACE_USERS | ROLE | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/userAdministrationRole | |||
theme |
string | 2945 | PACE_MASTERDBO | PACE_USERS | THEME | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/theme | ||
eagleGatewayFlag |
YesNoOptionEnum | 2947 | PACE_MASTERDBO | PACE_USERS | EAGLE_GATEWAY | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/eagleGatewayFlag | ||
ldapUserFlag |
YesNoOptionEnum | 2955 | PACE_MASTERDBO | PACE_USERS | LDAPUSER | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/ldapUserFlag | ||
ldapDomain |
string | PACE_MASTERDBO | PACE_USERS | LDAP_DOMAIN | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/ldapDomain | |||
ldapServer |
string | PACE_MASTERDBO | PACE_USERS | LDAP_SERVER | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/ldapServer | |||
changePasswordFlag |
YesNoOptionEnum | 2939 | PACE_MASTERDBO | PACE_USERS | CHANGE_PASSWORD | NUMBER | EagleML/userAdministrationTransaction/user/changePasswordFlag | |
concurrentLoginsCount |
integer | 2948 | PACE_MASTERDBO | PACE_USERS | CONCURRENTLOGINS | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/concurrentLoginsCount | ||
accountState |
AccountStateEnum | 4261 | PACE_MASTERDBO | PACE_USERS | ACCOUNT_STATE | CHAR(2) | EagleML/userAdministrationTransaction/user/accountState | ||
currentLoginCount |
integer | 4260 | PACE_MASTERDBO | PACE_USERS | NUM_LOGINS | NUMBER | EagleML/userAdministrationTransaction/user/currentLoginCount | ||
passwordNeverExpires |
One of these 3 fields must be set | YesNoOptionEnum | 2951 | PACE_MASTERDBO | PACE_USERS | PASSWORDNEVEREXPIRES | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/passwordNeverExpires |
passwordExpiryEveryNDays |
integer | 2950 | PACE_MASTERDBO | PACE_USERS | EXPIRYEVERY | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/passwordExpiryEveryNDays | |
accountExpirationDate |
date | 2958 | PACE_MASTERDBO | PACE_USERS | ACCOUNTEXPIRATIONDATE | DATE | EagleML/userAdministrationTransaction/user/accountExpirationDate | |
createDate |
date | 4469 | PACE_MASTERDBO | PACE_USERS | CREATE_DATE | DATE | EagleML/userAdministrationTransaction/user/createDate | ||
lastFailedTime |
dateTime | 2953 | PACE_MASTERDBO | PACE_USERS | LASTFAILEDTIME | DATE | EagleML/userAdministrationTransaction/user/lastFailedTime | ||
lastIp |
string | 2956 | PACE_MASTERDBO | PACE_USERS | LASTIP | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/lastIp | ||
logins |
integer | 2957 | PACE_MASTERDBO | PACE_USERS | LOGINS | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/logins | ||
passwordAge |
integer | 2959 | PACE_MASTERDBO | PACE_USERS | PASSWORDAGE | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/passwordAge | ||
userType |
string | PACE_MASTERDBO | PACE_USERS | TYPE | CHAR(1) | EagleML/userAdministrationTransaction/user/userType | ||
unlockDateTime |
dateTime | 2952 | PACE_MASTERDBO | PACE_USERS | UNLOCKDATETIME | DATE | EagleML/userAdministrationTransaction/user/unlockDateTime | ||
updateDateTime |
dateTime | 2943 | PACE_MASTERDBO | PACE_USERS | UPD_DATETIME | DATE | EagleML/userAdministrationTransaction/user/updateDateTime | ||
userNtDomain |
string | 2960 | PACE_MASTERDBO | PACE_USERS | USERNTDOMAIN | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/userNtDomain | ||
instance |
integer | PACE_MASTERDBO | PACE_USERS | INSTANCE | NUMBER | EagleML/userAdministrationTransaction/user/instance | ||
accessLevel |
integer | PACE_MASTERDBO | PACE_USERS | ACCESSLEVEL | NUMBER | EagleML/userAdministrationTransaction/user/accessLevel | |||
lastOperationTime |
dateTime | 2940 | PACE_MASTERDBO | PACE_USERS | LAST_OP_TIME | DATE | EagleML/userAdministrationTransaction/user/lastOperationTime | |
lockedBy |
string | 2944 | PACE_MASTERDBO | PACE_USERS | LOCKEDBY | VARCHAR2(255) | EagleML/userAdministrationTransaction/user/lockedBy | ||
journalTransactionNumber | Available only on 2017R2.9 for load only | 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 |
Groups Data Map Table - see extra table below | EagleML/userAdministrationTransaction/user/groups/ | ||||||
entitlements |
Entitlements Map Table - see extra table below | EagleML/userAdministrationTransaction/user/entitlements/ | |||||||||||||
| ||||||||||||||
microstrategyBasedUserOn |
integer | 5082 | PACE_MASTERDBO | PACE_USERS | MSTR_BASED_USER_ON | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/microstrategy/microstrategyBasedUserOn | ||
microstrategyUser |
YesNoOptionEnum | 5077 | PACE_MASTERDBO | PACE_USERS | MSTR_USER | VARCHAR2(1) | EagleML/userAdministrationTransaction/user/microstrategy/microstrategyUser | ||
microstrategyUserId |
string | 5079 | PACE_MASTERDBO | PACE_USERS | MSTR_USER_ID | VARCHAR2(50) | EagleML/userAdministrationTransaction/user/microstrategy/microstrategyUserId | ||
microstrategyLastUpdateDate |
date | 5080 | PACE_MASTERDBO | PACE_USERS | MSTR_LAST_UPDATE_DATE | DATE | EagleML/userAdministrationTransaction/user/microstrategy/microstrategyLastUpdateDate | ||
microstrategyRole |
integer | 5081 | PACE_MASTERDBO | PACE_USERS | MSTR_ROLE | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/microstrategy/microstrategyRole | ||
microstrategyUserStatus |
integer | 5078 | PACE_MASTERDBO | PACE_USERS | MSTR_USER_STATUS | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/microstrategy/microstrategyUserStatus | ||||||||
| ||||||||||||||
group |
Group Model Data Map Table - see extra table below | EagleML/userAdministrationTransaction/user/groups/group/ | |||||||||||||
| ||||||||||||||
groupCode |
string | not stored in DB | EagleML/userAdministrationTransaction/user/groups/group/groupCode | |||||
groupId |
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 | |||||
groupName |
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 |
string | PACE_MASTERDBO | PACE_USER_GROUPS | GROUP_TYPE | CHAR(4) | EagleML/userAdministrationTransaction/user/groups/group/groupType | |||
centerCode |
string | PACE_MASTERDBO | EGL_CENTER_ROLE | CENTER_CODE | VARCHAR2(50) | EagleML/userAdministrationTransaction/user/groups/group/centerCode | |||
isPrimaryRole |
YesNoOptionEnum | PACE_MASTERDBO | EGL_CENTER_ROLE_USER | IS_PRIMARY_ROLE | NUMBER(38,0) | EagleML/userAdministrationTransaction/user/groups/group/isPrimaryRole | |||
relationshipInstance |
integer | PACE_MASTERDBO | PACE_USER_ROLE_DETAILS | INSTANCE | NUMBER | EagleML/userAdministrationTransaction/user/groups/group/relationshipInstance | |||||||||
| ||||||||||||||
entitlement |
Entitlement Model Data Map Table - see extra table below | EagleML/userAdministrationTransaction/user/entitlements/entitlement/ | |||||||||||||
| ||||||||||||||
resource |
string | not stored in DB | EagleML/userAdministrationTransaction/user/entitlements/entitlement/resource | ||||||
action |
string | not stored in DB | EagleML/userAdministrationTransaction/user/entitlements/entitlement/action | |||||
value |
string | not stored in DB | EagleML/userAdministrationTransaction/user/entitlements/entitlement/value |