ID

int

No

Identifier; primary key.

NUSER_ID

varchar

40

No

Natural key of user.

LOGIN

varchar

40

No

User’s login.

FIRST_NAME

varchar

40

Yes

User’s first name.

MIDDLE_NAME

varchar

40

Yes

User’s middle name.

LAST_NAME

varchar

40

Yes

User’s last name.

EMAIL

varchar

255

Yes

User’s email address.

DATE_OF_BIRTH

date

Yes

User’s date of birth.

LANG_ID

smallint

No

Identifier of language from the ARF_LANGUAGE table.

GENDER_ID

tinyint

No

Identifier of gender from the ARF_GENDER table.

MARITAL_STATUS_ID

tinyint

No

Identifier of marital status from the ARF_MARITAL_STATUS table.

HOME_REGION_ID

smallint

No

Identifier of the region of the user’s home address, from the ARF_GEO_REGION table.

ORGANIZATION_ID

integer

No

Identifier of the user’s organization. Foreign key to the ARF_ORGANIZATION table.

RECORD_LAST_UPDATE

timestamp

Yes

Date the record was last updated.

RECORD_START_DATE

timestamp

Yes

Date when the information in this warehouse record became effective

RECORD_END_DATE

timestamp

Yes

Date when the information in this warehouse record is no longer effective.

MOST_RECENT

one-digit

No

Indicates that this record is the most recent.

0 = No

1 = Yes

DELETED

one-digit

No

Indicates that this record has been deleted.

0= No

1 = Yes