eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: JTF.JTF_RS_RESOURCE_EXTNS_INT

Object Details

Object Name:	JTF_RS_RESOURCE_EXTNS_INT
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_RS_RESOURCE_EXTNS_INT
Subobject Name:
Status:	VALID

This interface table is used for population of Resource entity in JTF_RS_RESOURCE_EXTNS and JTF_RS_RESOURCE_EXTNS_TL tables.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_RS_RESOURCE_EXTNS_INT_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	INTERFACE_ID
JTF_RS_RESOURCE_EXTNS_INT_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID OPERATION_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_ID	NUMBER		Yes	Unique identifier for this table. Use JTF_RS_RESOURCE_EXTNS_INT_S sequence to populate this id.
RESOURCE_GUID	VARCHAR2	(2000)		Identifier from External Systems. Consumer team will populate and use this data for managing mappings to external system. Resource Manager does not use this id.
BATCH_ID	NUMBER		Yes	Batch Identifier. Use sequence JTF_RS_INT_BATCH_ID_S to generate a value.
OPERATION	VARCHAR2	(10)	Yes	Type of Operation to be performed on the row. Valid values: CREATE, UPDATE
OPERATION_STATUS	VARCHAR2	(10)		Return Status from API after Resource Manager processes the record. Valid Values: S (success), E (Error), U (Unexpected Error)
OPERATION_MESSAGE	VARCHAR2	(4000)		Message text stacked by API after processing.
OPERATION_CREATION_DATE	DATE			Date-Time when record is created in interface table.
OPERATION_PROCESS_DATE	DATE			Date-Time when record is processed
CATEGORY	VARCHAR2	(30)		Resource Category. For future use. Currently, only Category OTHER is supported.
RESOURCE_ID	NUMBER			Resource Id. Mandatory for UPDATE operation. Populated back in interface table after resource creation.
START_DATE_ACTIVE	DATE			Effective start date of the resource. Mandatory for CREATE operation.
END_DATE_ACTIVE	DATE			Effective end date of the resource.
COMPENSATION_CURRENCY_CODE	VARCHAR2	(15)		Compensation Currency code.
COMMISSIONABLE_FLAG	VARCHAR2	(1)		Commissionable flag
HOLD_REASON_CODE	VARCHAR2	(30)		Hold reason code
HOLD_PAYMENT	VARCHAR2	(1)		Hold payment
RESOURCE_NAME	VARCHAR2	(360)		Resource Name. Mandatory for CREATE operation.
SOURCE_ID	NUMBER			Resource Source identifier within EBS application. Not Required for Category OTHER.
ADDRESS_ID	NUMBER			Address identifier - foreign key to HZ_PARTY_SITES
CONTACT_ID	NUMBER			Contact identifier - foreign key to HZ_ORG_CONTACTS
MANAGING_EMPLOYEE_ID	NUMBER			Managing Employee Identifier
TIME_ZONE	NUMBER			Time Zone information foreign key to FND_TIMEZONES_VL.upgrade_tz_id.
COST_PER_HR	NUMBER			Cost per hour of the resource
PRIMARY_LANGUAGE	VARCHAR2	(30)		Primary Language of the Resource
SECONDARY_LANGUAGE	VARCHAR2	(30)		Secondary Language of the Resource
SUPPORT_SITE_ID	NUMBER			Support Site from Service
IES_AGENT_LOGIN	VARCHAR2	(240)		Email Center Agent Login
SERVER_GROUP_ID	NUMBER			Server Group Identifier to which this resource is attached. FK to IEO_SVR_GROUPS, used by interaction centers.
INTERACTION_CENTER_NAME	VARCHAR2	(256)		Interaction Center Name to derive Server_group_id from ieo_svr_groups
ASSIGNED_TO_GROUP_ID	NUMBER			Assigned to User Identifier, Foreign Key to FND_USER
COST_CENTER	VARCHAR2	(30)		Cost Center to which this resource is attached
CHARGE_TO_COST_CENTER	VARCHAR2	(30)		Cost center which will be charged for this resource
COMP_SERVICE_TEAM_ID	NUMBER			Comp Service Team Id, FK to jtf_rs_teams_vl
USER_ID	NUMBER			User Id from FND_USER. Not valid for category OTHER.
TRANSACTION_NUMBER	NUMBER			Transaction Number
USER_NAME	VARCHAR2	(100)		User Name from FND USER for a Resource.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column to be imported in Resource Manager
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment to be imported in Resource Manager

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERFACE_ID
,      RESOURCE_GUID
,      BATCH_ID
,      OPERATION
,      OPERATION_STATUS
,      OPERATION_MESSAGE
,      OPERATION_CREATION_DATE
,      OPERATION_PROCESS_DATE
,      CATEGORY
,      RESOURCE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      COMPENSATION_CURRENCY_CODE
,      COMMISSIONABLE_FLAG
,      HOLD_REASON_CODE
,      HOLD_PAYMENT
,      RESOURCE_NAME
,      SOURCE_ID
,      ADDRESS_ID
,      CONTACT_ID
,      MANAGING_EMPLOYEE_ID
,      TIME_ZONE
,      COST_PER_HR
,      PRIMARY_LANGUAGE
,      SECONDARY_LANGUAGE
,      SUPPORT_SITE_ID
,      IES_AGENT_LOGIN
,      SERVER_GROUP_ID
,      INTERACTION_CENTER_NAME
,      ASSIGNED_TO_GROUP_ID
,      COST_CENTER
,      CHARGE_TO_COST_CENTER
,      COMP_SERVICE_TEAM_ID
,      USER_ID
,      TRANSACTION_NUMBER
,      USER_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM JTF.JTF_RS_RESOURCE_EXTNS_INT;

Dependencies

[top of page]

JTF.JTF_RS_RESOURCE_EXTNS_INT does not reference any database object

JTF.JTF_RS_RESOURCE_EXTNS_INT is referenced by following:

JTF: JTF_RS_RESOURCE_EXTNS_INT#