Interactive Queries

organizationsummary

Attribute Name

Data Type

Description

ID

string

The unique identifier of the organization.

TenantID

int

The unique identifier of the client environment.

SourceSystemID

string

The unique identifier of the upstream source system.

SourceOrganizationNumber

string

The unique identifier of the organization in your data.

level1Code

string

The unique identifier (SourceOrganizationNumber) of the organization hierarchy level-1.

level1Name

string

The organization name of the organization hierarchy level-1.

level2Code

string

The unique identifier (SourceOrganizationNumber) of the organization hierarchy level-2.

level2Name

string

The organization name of the organization hierarchy level-2.

level3Code

string

The unique identifier (SourceOrganizationNumber) of the organization hierarchy level-3.

level3Name

string

The organization name of the organization hierarchy level-3.

level4Code

string

The unique identifier (SourceOrganizationNumber) of the organization hierarchy level-4.

level4Name

string

The organization name of the organization hierarchy level-4.

level5Code

string

The unique identifier (SourceOrganizationNumber) of the organization hierarchy level-5.

level5Name

string

The organization name of the organization hierarchy level-5.

level6Code

string

The unique identifier (SourceOrganizationNumber) of the organization hierarchy level-6.

level6Name

string

The organization name of the organization hierarchy level-6.

level7Code

string

The unique identifier (SourceOrganizationNumber) of the organization hierarchy level-7.

level7Name

string

The organization name of the organization hierarchy level-7.

level8Code

string

The unique identifier (SourceOrganizationNumber) of the organization hierarchy level-8.

level8Name

string

The organization name of the organization hierarchy level-8.

level9Code

string

The unique identifier (SourceOrganizationNumber) of the organization hierarchy level-9.

level9Name

string

The organization name of the organization hierarchy level-9.

level10Code

string

The unique identifier (SourceOrganizationNumber) of the organization hierarchy level-10.

level10Name

string

The organization name of the organization hierarchy level-10.

Type

string

The type of organization. The accepted values are Digital, Physical, Warehouse, and Other. If not provided, CDP defaults to Other. Note that this field is used to determine which organization is a store (type = “Physical”) and therefore, it is a mandatory attribute for any distance-to-store reporting or audience selection.

Address1

string

The address where the organization is located. This is required for distance-to-store calculations.

Address2

string

The address where the organization is located. This is required for distance-to-store calculations.

City

timestamp

The city where the organization is located. This is required for distance-to-store calculations.

Zip

timestamp

The zip or postal code of the organization’s location. This must contain the Zipcode and not the +4 code. This is required for distance-to-store calculations.

State

string

The state where the organization is located. This is required for distance-to-store calculations.

Country

string

The standard ISO Alpha-2 code for the country where the organization is located. For example, the code for the United States is US, Canada is CA, and France is FR. Two-character ISO Alpha-2 codes are required for distance-to-store and closest-store calculations.

Status

string

The status of the organization. The possible values are open and closed.

RowCreated

timestamp

The time when the organization record was created.

RowModified

timestamp

The time when the organization record was last updated.

Batch

string

When the promotion was last modified in CDP. This is used for bucketing the ingestion of records into CDP.

SubType

string

The subtype of your organization. For example, outlet store or warehouse store.