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: HR.FF_ARCHIVE_ITEMS

Object Details

Object Name:	FF_ARCHIVE_ITEMS
Object Type:	TABLE
Owner:	HR
FND Design Data:	FF.FF_ARCHIVE_ITEMS
Subobject Name:
Status:	VALID

FF_ARCHIVE_ITEMS records a snapshot of what particular database
items evaluate to on a run of a Fastformula based magnetic tape
report.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: FF_ARCHIVE_ITEMS_PK

ARCHIVE_ITEM_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
FF_ARCHIVE_ITEMS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ARCHIVE_ITEM_ID
FF_ARCHIVE_ITEMS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_ENTITY_ID
FF_ARCHIVE_ITEMS_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTEXT1 USER_ENTITY_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
FF_ARCHIVE_ITEM_CONTEXTS		FF_ARCHIVE_ITEMS	FF_ARCHIVE_ITEM_CONTEXTS ARCHIVE_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ARCHIVE_ITEM_ID	NUMBER	(15)	Yes	System-generated primary key column.
USER_ENTITY_ID	NUMBER	(9)	Yes	Foreign key to ff_user_entities - a unique identifier for archive item name.
CONTEXT1	NUMBER	(15)	Yes	First context to find a database item (e.g. assignment_action_id)
VALUE	VARCHAR2	(240)		What the database item evaluates to on extract.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated version of row. Increments by one with each update.
ARCHIVE_TYPE	VARCHAR2	(10)		Identifies at which point the item was archived
NAME	VARCHAR2	(240)		Optional name of the Item.

Query Text

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


SELECT ARCHIVE_ITEM_ID
,      USER_ENTITY_ID
,      CONTEXT1
,      VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      ARCHIVE_TYPE
,      NAME
FROM HR.FF_ARCHIVE_ITEMS;

Dependencies

[top of page]

HR.FF_ARCHIVE_ITEMS does not reference any database object

HR.FF_ARCHIVE_ITEMS is referenced by following:

APPS: FF_ARCHIVE_ITEMS; FF_ARCHIVE_ITEMS_BRU; FF_ARCHIVE_ITEMS_WHO
PUBLIC: FF_ARCHIVE_ITEMS