Customers are assigned to segments based on rules created in the ATG Business Control Center. Customers can be members of multiple segments. Segments are also known as profile groups.

Column Name

Type

Length

Null Allowed

Description

ID

smallint

No

Identifier; primary key.

NSEGMENT_ID

varchar

254

No

Natural key of segment.

SEGMENT_NAME

varchar

254

No

Name of segment.

SEGMENT_DESC

varchar

254

Yes

Description of segment.

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