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 |
---|---|---|---|---|
| smallint | No | Identifier; primary key. | |
| varchar | 254 | No | Natural key of segment. |
| varchar | 254 | No | Name of segment. |
| varchar | 254 | Yes | Description of segment. |
| timestamp | Yes | Date the record was last updated. | |
| timestamp | Yes | Date when the information in this warehouse record became effective | |
| timestamp | Yes | Date when the information in this warehouse record is no longer effective. | |
| one-digit | No | Indicates that this record is the most recent. 0 = No 1 = Yes | |
| one-digit | No | Indicates that this record has been deleted. 0= No 1 = Yes |