The person source table columns are presented using the
names as they appear in the puller agent file (HRDBPullerAgent.xml). The order of the columns in the file might be different than the
order in which they are listed.
LastModified
Data type |
Requirements |
TIMESTAMP |
Required, Modification key |
The LastModified value is used to filter out unmodified data
during an incremental ingest. If the LastModified value for a record
is earlier than the most recent LastModified value across all records
in the Organization staging table, the record is not ingested. This
is true for both existing and new Organizations. If you are performing
a full ingest, the LastModified column is ignored.
(Note that
the LastModified value isn't used as the Person's Modified On attribute
as presented in the IBM® Atlas Policy Suite web client. LastModified is only used to determine whether the record
should be ingested.)
PersonID
Data type |
Requirements |
STRING[250] |
Required, Unique, Update key |
A string that uniquely identifies the Person. In the
IBM Atlas Policy Suite web client, this is
called Person Identifier; in the Person CSV file it is called Identifier.
Be aware that the CSV does not use this attribute as the Person’s
update key—CSV uses the LoginID field to uniquely identify a Person,
instead.
If you are using a single sign on system and you designated
PersonIdentifier as the "SSO token attribute", this is the column
that supplies the values for the attribute.
FirstName
Data type |
Requirements |
STRING[250] |
Required |
The Person's first name.
LastName
Data type |
Requirements |
STRING[250] |
Required |
The Person's last name.
LoginID
Data type |
Requirements |
STRING[250] |
Required, Unique (across all active Persons) |
The Person's
IBM Atlas Policy Suite account login string. The value must be case-insensitive unique
across all login strings. You must supply a LoginID string even if
you are not using
IBM Atlas Policy Suite for login authentication. The string is used within the application
and by the Person CSV file as the Person's unique key.
If you
are using a single sign on system and you designated LoginID as the
"SSO token attribute", this is the column that supplies the values
for the attribute.
Important: While more than one
inactive Person (Status = DISABLED) can have the same login ID, and
an active Person (Status = ACTIVE) can have the same login ID as an
inactive Person, login IDs must be unique across all active Persons.
Email
Data type |
Requirements |
STRING[250] |
Required, Unique (across all active Persons) |
The Person's email address. The value must be in the form:
name@company.suffix
Important: While more than one inactive Person (Status
= DISABLED) can have the same email address, and an active Person
(Status = ACTIVE) can have the same address as an inactive Person,
email addresses must be unique across all active Persons.
Status
Data type |
Requirements |
STRING |
Optional |
The Person’s status. There are two Person states:
- ACTIVE means the Person can be added to an Organization, can be
added to the Scope of a Request, can be put on Hold, and so on.
- DISABLED means the Person can’t be given any new assignments or
associations. A disabled Person is not removed from the page, nor is he or she removed from Scope or released from his or
her legal obligations (Holds, notably). The Person’s Memberships are
severed, but not his or her User associations.
If you do not supply a Status value, the status is set
to ACTIVE.
Title
Data type |
Requirements |
STRING[300] |
Optional |
The Person’s job title.
ManagerID
Data type |
Requirements |
STRING[250] |
Optional |
The PersonID of the Person’s manager. If you supply a value
for this column, it must be different from the value of the AssistantID
column.
AssistantID
Data type |
Requirements |
STRING[250] |
Optional |
The PersonID of the Person’s assistant. If you supply a value
for this column, it must be different from the value of the ManagerID
column.
DeptID
Data type |
Requirements |
STRING[250] |
Optional |
DeptID is the unique identifier of an existing Organization
that this Person will be added to as a Member. This identifier is
called OrgID in the Organization source table and Identifier in the
IBM Atlas Policy Suite web client.
CustomField1
Data type |
Requirements |
STRING[2000] |
Optional |
Custom data. To present this attribute
in the IBM Atlas Policy Suite web
client, go to and check the Visible checkbox. A custom
field is always optional when you provide it through Atlas Extensions, even if the field is
declared to be Required in the Custom Fields module. If you are using
a single sign on system and you designated one of PAField1 through
PAField5 as the "SSO token attribute", the corresponding column, here,
supplies the value for the attribute.
CustomField2
Data type |
Requirements |
STRING[250] |
Optional |
Custom data.CustomField3
Data type |
Requirements |
STRING[2000] |
Optional |
Custom data.CustomField4
Data type |
Requirements |
STRING[2000] |
Optional |
Custom data.CustomField5
Data type |
Requirements |
STRING[2000] |
Optional |
Custom data.