The ARF_IU_USER table stores data about internal users. Internal users are users based within your company. For example, customer service agents using ATG Knowledge are internal users, while customers at an ATG Commerce site are external users.

Column Name

Type

Length

Null Allowed

Description

ID

varchar

40

No

Identifier; primary key.

USER_ID

varchar

40

No

User ID.

LOGIN

varchar

40

No

User’s login

FIRST_NAME

varchar

40

Yes

User’s first name

LAST_NAME

varchar

40

Yes

User’s last name

PARENT_ORG_ID

varchar

40

No

ID of the organization to which the user belongs. Foreign key to ARF_IU_ORG.ID.

DIR_LVL_ID

varchar

40

No

Identifies the level to which this user belongs. Foreign key to ARF_IU_DIR_LVL table’s ID column.

LAST_UPDATED

timestamp

No

Date and time this record was last updated.

DELETED

numeric

1

No

Indicates whether the record has been deleted.