Schema of Peoplesoft integration data

The integration data schema defines what data is imported within the Peoplesoft integration. In this section:

  • Account
    • Mandatory and available on Creation \ Update
    • Other account properties
  • Resource Types
    • Server
  • Permission Type

Account

The user objects are imported from Peoplesoft and displayed as the Account objects in ObserveID. The user’s attributes are shown as Additional Properties objects of the Account. There are two types of Additional Properties of Peoplesoft Accounts: built-in Additional Properties, which exist in Peoplesoft by default, and custom Additional Properties, created by the user in Peoplesoft. The account schema below describes only the built-in properties.

Some Additional Properties can be required on the creation of an account, and the requirements of the Target system often account for that. Other Additional Properties can be allowed and, if needed, established for an account when it is created. This information is displayed in the On Creation column. Additional Properties are also allowed to be updated with the Identities Update workflow. If an Additional Property can be updated, it is shown in the On Update column.

The Account properties are retrieved from the following tables:

  • “PSOPRDEFN” table
  • “PSUSEREMAIL” table
  • “PS_PERSONAL_DATA” table
  • “PS_JOB” table

Mandatory and available on Creation \ Update

Account Property

Type

Description

Provisioning Rules

On Creation

On Update

AccessId

String

 

Set

Required

Allowed

DefaultNavigationHomePage

Object

 

Set

Required

Allowed

Description

String

 

Set

Required

Allowed

OperatorClass

Object

 

Set

Required

Allowed

ProcessProfileClass

Object

 

Set

Required

Allowed

RowSecurityClass

Object

 

Set

Required

Allowed

AccountCountry

Object

 

Set

Allowed

Allowed

Address1

String

 

Set

Allowed

Allowed

Address2

String

 

Set

Allowed

Allowed

Address3

String

 

Set

Allowed

Allowed

AllowSwitchUser

Boolean

 

Set

Allowed

Allowed

Birthdate

Date

 

Set

Allowed

Allowed

BlackberryEmail

String

 

Set

Allowed

Allowed

BusinessEmail

String

 

Set

Allowed

Allowed

City

String

 

Set

Allowed

Allowed

County

String

 

Set

Allowed

Allowed

Currency

Object

 

Set

Allowed

Allowed

ExpertEntry

Boolean

 

Set

Allowed

Allowed

FirstName

String

 

Set

Allowed

Allowed

FullName

String

 

Set

Allowed

Allowed

HomeEmail

String

 

Set

Allowed

Allowed

Language

String

 

Set

Allowed

Allowed

LastName

String

 

Set

Allowed

Allowed

MiddleName

String

 

Set

Allowed

Allowed

Multilangual

Boolean

 

Set

Allowed

Allowed

NameInitials

String

 

Set

Allowed

Allowed

NamePrefix

String

 

Set

Allowed

Allowed

NameSuffix

String

 

Set

Allowed

Allowed

NameTitle

String

 

Set

Allowed

Allowed

OperatorType

Boolean

 

Set

Allowed

Allowed

OtherEmail

String

 

Set

Allowed

Allowed

Postal

String

 

Set

Allowed

Allowed

PreferredFirstName

String

 

Set

Allowed

Allowed

PrimaryEmail

String

 

Set

Allowed

Allowed

Sex

String

 

Set

Allowed

Allowed

State

String

 

Set

Allowed

Allowed

UserIdAlias

String

 

Set

Allowed

Allowed

WorkEmail

String

 

Set

Allowed

Allowed

Other account properties

Other account properties represent information that comes from the target ‘as is’.

Account Property

Type

Description

Provisioning Rules

On Creation

On Update

EmployeeId

String

 

n/a

n/a

n/a

FailedLoginsAttempts

Long

 

n/a

n/a

n/a

LastEntryUpdateDate

DateTime

 

n/a

n/a

n/a

LastEntryUpdateUsedId

String

 

n/a

n/a

n/a

LastPasswordChangeDate

DateTime

 

n/a

n/a

n/a

LastSignonDate

DateTime

 

n/a

n/a

n/a

SupervisorId

String

 

n/a

n/a

n/a

Resource Types

The resource objects are imported from Peoplesoft and displayed as the resources for the Peoplesoft integration in ObserveID. Each resource is represented with a resource type. The resource’s attributes are shown in ObserveID as Additional Properties of a resource according to the resource type.

Resource Property

Type

Description

Server

Name

String

Name is taken from the Host Name field of the integration configuration.

Permission Type

The permission objects are imported from Peoplesoft and displayed as the entitlements in ObserveID. The attributes of each permission type to which a specific permission belongs are displayed as Additional Properties objects of the Permission.

Permission Property

Type

Description

Role

retrieved from the “PSROLEDEFN” table

AllowNotification

Boolean

 

AllowRecipientLookup

Boolean

 

DirectoryRuleEnabled

Boolean

 

FieldName

String

 

LongDescription

String

 

PeopleCodeEventName

String

 

PeopleCodeFunctionName

String

 

PeopleCodeRuleEnabled

Boolean

 

QueryName

String

 

QueryNameSec

String

 

QueryRoleEnabled

Boolean

 

RecordTableName

String

 

RoleStatus

String

 

RoleType

String

 

PermissionsList

retrieved from the “PSCLASSDEFN” table

AllowNewPasswordEmail

Boolean

 

CanStartApplicationServer

Boolean

 

DefaultBusinessProcessMap

String

 

TimeOutMinutes

Long