/
User Data Map Table

User Data Map Table

Owned by Dmitry Donosiyan (Unlicensed)
Last updated: Nov 07, 2024 by Kinga Huszno
3 min read

Element

Optional/Required

Value Type

Star Tag

Eagle DB

DB Table

DB Field

DB Data Type

XPath

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/

Microstrategy Model Data Map Table

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

Groups Data Map Table

group

 

Group Model Data Map Table - see extra table below

EagleML/userAdministrationTransaction/user/groups/group/

Group Model Data Map Table

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

Entitlements Data Map Table

entitlement

 

Entitlement Model Data Map Table - see extra table below

EagleML/userAdministrationTransaction/user/entitlements/entitlement/

Entitlement Model Data Map Table

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