The ARF_ORGANIZATION table stores information about user organizations. These organizations are used in personalizing your sites. See Using Organizations and Roles in the ATG Personalization Guide for Business Users.

Column Name

Type

Length

Null Allowed

Description

ID

integer

No

Identifier; primary key.

NORGANIZATION_ID

varchar

40

No

The natural key for the organization.

PARENT_ORG_ID

integer

Yes

The parent of the organization in the hierarchy of organizations configured for your sites. Foreign key to ARF_ORGANIZATION.ID.

NAME

varchar

254

No

The name assigned to the organization.

DESCRIPTION

varchar

254

Yes

A description of the organization.

RECORD_LAST_UPDATE

timestamp

Yes

The date and time that the organization record was last changed.

RECORD_START_DATE

timestamp

Yes

The date and time that the organization record was created.

RECORD_END_DATE

timestamp

Yes

The date and time that the organization record was marked as deleted. This value is null unless the record is marked as deleted.

MOST_RECENT

one-digit

No

Indicates that this record is the most recent record for the organization.

0 = No

1 = Yes

DELETED

one-digit

No

Indicates that this record has been deleted.

0= No

1 = Yes


Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices