[Home] [Help] [Dependency Information]
Object Name: | IES_AGENTS |
---|---|
Object Type: | TABLE |
Owner: | IES |
FND Design Data: | IES.IES_AGENTS |
Subobject Name: | |
Status: | VALID |
The IES_AGENTS table contains records for all agents who have used and who will use Scripting. Each agent record stores the database login name (string) for the agent. This database login is also used as the agent?s login to Scripting. This information is stored as a string instead of as a reference to a record in the system table to prevent problems with a referenced login being removed from the database.
The agent record also references an agent as stored in the Resource Manager schema. Agent permissions are defined in the Resource Manager schema and will be used for permission-based views. The exact relationships are yet to be determined.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IES_AGENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | AGENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGENT_ID | NUMBER | Yes | Unique Identifier for Agents | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
AGENT_LOGIN | VARCHAR2 | (240) | Yes | Login Name for the agent |
RESOURCE_ID | NUMBER | ID in the CRM Foundation component Resource Manager schema | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Object version number required for HTML interfaces |
Cut, paste (and edit) the following text to query this object:
SELECT AGENT_ID
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, AGENT_LOGIN
, RESOURCE_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM IES.IES_AGENTS;
IES.IES_AGENTS does not reference any database object
IES.IES_AGENTS is referenced by following:
|
|
|