Technical References

Enterprise Tables - Database Rules

To see an illustration and a list of the Enterprise tables, click here (page 443).

Each Route (page 277) can belong to one or more Enterprise Routes (page 173).

The Enterprise Route Member (page 174) table maps Routes to Enterprise Routes.

Each Skill Group (page 364) can belong to one or more Enterprise Skill Groups (page 176).

The Enterprise Skill Group Member (page 177) table maps Skill Groups to Enterprise Skill

Groups.

Each Service (page 325) can belong to one or more Enterprise Services (page 175).

The Enterprise Service Member (page 175) table maps services to enterprise services.

Each Peripheral Gateway (PG) can have one or more associated Service Array (page 328)s.

Each Service Array (page 328) contains one or more Services (page 325); but all services in an

array must be from peripherals associated with the same PG.

The Service Array Member (page 329) table maps Services (page 325) to Service Arrays.

Galaxy Tables - Database Rules

To see an illustration and a list of the Galaxy tables, click here (page 445).

If the system includes a Rockwell Galaxy ACD, special tables within the ICM database are

populated with data taken directly from those ACDs. These data are mostly redundant with data

found in the standard ICM/IPCC tables.

For each agent conﬁgured on the ACD, Galaxy Agent Performance (page 185) and Galaxy Agent

Call Count (page 182) records are generated.

For each agent I-group conﬁgured on the ACD, Galaxy Agent IGroup (page 183) records are

generated.

For each PBX destination, Galaxy PBX (page 200) records are generated.

For each gate conﬁgured on the ACD, Galaxy Gate (page 190), Galaxy Gate Delayed Call (page

193), and Galaxy Overﬂow (page 196) records are generated.

For each trunk I-group conﬁgured on the ACD, Galaxy Trunk IGroup (page 205) records are

generated.

For each trunk, Galaxy Single Trunk (page 202)and Galaxy Trunk Call Count (page 204) records

are generated.

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)

506

Chapter 5: Database Rules

Enterprise Tables - Database Rules