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.HR_API_TRANSACTION_VALUES

Object Details

Object Name:	HR_API_TRANSACTION_VALUES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_API_TRANSACTION_VALUES
Subobject Name:
Status:	VALID

HR_API_TRANSACTION_VALUES contains the columns and values of the data
that will be written to the HR schema when the Web Kiosk process
completes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HR_API_TRANSACTION_VALUES_PK

TRANSACTION_VALUE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_API_TRANSACTION_VALUES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_VALUE_ID
HR_API_TRANSACTION_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_STEP_ID NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_API_TRANSACTION_VALUES		HR_API_TRANSACTION_STEPS	HR_API_TRANSACTION_VALUES TRANSACTION_STEP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_VALUE_ID	NUMBER	(15)	Yes	System-gnerated primary key column.
TRANSACTION_STEP_ID	NUMBER	(15)	Yes	Foreign key to HR_API_TRANSACTION_STEPS.
DATATYPE	VARCHAR2	(30)	Yes	The datatype of the column of data this value record stores.
NAME	VARCHAR2	(30)	Yes	Column name that the value is for.
VARCHAR2_VALUE	VARCHAR2	(2000)		If the column is a Varchar2, this is where the data value is stored.
NUMBER_VALUE	NUMBER			If the column is a number, this is where the data value is stored.
DATE_VALUE	DATE			If the column is a Date, this is where the data value is stored.
ORIGINAL_VARCHAR2_VALUE	VARCHAR2	(2000)		If the column is a Varchar2, this is where the original data value is stored, before the kiosk user changed it.
ORIGINAL_NUMBER_VALUE	NUMBER			If the column is a Number, this is where the original data value is stored, before the kiosk user changed it.
ORIGINAL_DATE_VALUE	DATE			If the column is a Date, this is where the original data value is stored, before the kiosk user changed it.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
PREVIOUS_VARCHAR2_VALUE	VARCHAR2	(2000)		Last Saved/Submitted value of string attribute
PREVIOUS_DATE_VALUE	DATE			Last Saved/Submitted Value of Date attribute
PREVIOUS_NUMBER_VALUE	NUMBER			Last Saved/Submitted value of Number Attribute

Query Text

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


SELECT TRANSACTION_VALUE_ID
,      TRANSACTION_STEP_ID
,      DATATYPE
,      NAME
,      VARCHAR2_VALUE
,      NUMBER_VALUE
,      DATE_VALUE
,      ORIGINAL_VARCHAR2_VALUE
,      ORIGINAL_NUMBER_VALUE
,      ORIGINAL_DATE_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PREVIOUS_VARCHAR2_VALUE
,      PREVIOUS_DATE_VALUE
,      PREVIOUS_NUMBER_VALUE
FROM HR.HR_API_TRANSACTION_VALUES;

Dependencies

[top of page]

HR.HR_API_TRANSACTION_VALUES does not reference any database object

HR.HR_API_TRANSACTION_VALUES is referenced by following:

HR: HR_API_TRANSACTION_VALUES#