LOCATIONGROUP
The LOCATIONGROUP table links locations, such as addresses and telephone numbers, to contacts and contains rules for use.
This table is used by the following domains.
Name | Comment | Datatype | Null Option | Is PK |
---|---|---|---|---|
LOCATION_GROUP_ID | A unique, system-generated key that identifies a location group in the system. | BIGINT | Not Null | Yes |
UNDEL_REASON_TP_CD | Identifies the reason for not using a particular address. Some example values are "returned mail," "change in zip code," and so forth. | BIGINT | Null | No |
CONT_ID | A unique, system-generated key that identifies a party in the system. | BIGINT | Not Null | No |
MEMBER_IND | Indicates that the party is a member of the "household", in this case a simplistic representation, as it is only used in conjunction with common addresses. | CHAR(1) | Null | No |
PREFERRED_IND | Indicates that the Party "prefers" to use this particular location for correspondence. | CHAR(1) | Null | No |
SOLICIT_IND | Determines whether this party be solicited at this specific location group. | CHAR(1) | Null | No |
LOC_GROUP_TP_CODE | Determines the type of the location group. The value "A" indicates an address, and the values "C" indicates contact method. | CHAR(1) | Not Null | No |
EFFECT_START_MMDD | The two-digit month and two-digit day which the Party wishes this contact point to be used. It is used with the Effective End Month Day to identify a date range of when this party contact point relationship should be used. | SMALLINT | Null | No |
EFFECT_END_MMDD | The two digit month and two digit day which the Party wishes this contact point to be used. It is used with the Effective Start Month Day to identify a date range of when this party contact point relationship should be used. | SMALLINT | Null | No |
EFFECT_START_TM | The time of day when a party is available at this location group. | INTEGER | Null | No |
EFFECT_END_TM | The time of day when a party is no longer available at this location group. | INTEGER | Null | No |
START_DT | The date when this record becomes active. | TIMESTAMP | Not Null | No |
END_DT | The date when this record becomes inactive. | TIMESTAMP | Null | No |
LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |
LAST_UPDATE_TX_ID | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | Null | No |
LAST_USED_DT | The date that this data was last used. There is no business logic associated with this field. | TIMESTAMP | Null | No |
LAST_VERIFIED_DT | The date that this data was last verified. There is no business logic associated with this field. | TIMESTAMP | Null | No |
SOURCE_IDENT_TP_CD | Identifies the type for the source identifier. | BIGINT | Null | No |