Table Name:	agent
Table Number:	5366
Group:	Customer Mgr
Description:	Contains details of an agent login on an ACD switch
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_agent

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
acd_queue	CHAR	varchar		30			Used by cti server to identify the ACD queue the agent belongs to
agent_id	CHAR	varchar		30			ACD's identification of the agent
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
equip_id	CHAR	varchar		30			ACD's identifier for the telephone set
objid	LONG	int	3			DIRECT	choice_fld internal record number
password	CHAR	varchar		30			ACD's password for the agent

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
agent2acd	MTO	acd	acd2agent	ACD that owns the agent
agent2user	MTO	user	user2agent	User who owns the agent

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
agent_ind	agent2acd:agent_id	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
agent_ind	agent2acd, agent_id	nonclustered, unique located on PRIMARY
ind_agent2user	agent2user	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

agent

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user