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

Object Details

Object Name:	PQH_RT_MATRIX_NODE_VALUES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQH.PQH_RT_MATRIX_NODE_VALUES
Subobject Name:
Status:	VALID

Table to store criteria values for a particular rate matrix node.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_RT_MATRIX_NODE_VALUES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	NODE_VALUE_ID ZD_EDITION_NAME
PQH_RT_MATRIX_NODE_VALUES_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHORT_CODE BUSINESS_GROUP_ID ZD_EDITION_NAME
PQH_RT_MATRIX_NODE_VALUES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RATE_MATRIX_NODE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
NODE_VALUE_ID	NUMBER	(15)	Yes	Uniquely identifies the rate matrix node value.
RATE_MATRIX_NODE_ID	NUMBER	(15)	Yes	Identifies the Rate matrix for which the criteria value is stored in this table.
SHORT_CODE	VARCHAR2	(30)	Yes	Unique short code for the node value.
CHAR_VALUE1	VARCHAR2	(240)		Character criteria value1.
CHAR_VALUE2	VARCHAR2	(240)		Character criteria value2.
CHAR_VALUE3	VARCHAR2	(240)		Character criteria value3.
CHAR_VALUE4	VARCHAR2	(240)		Character criteria value4.
NUMBER_VALUE1	NUMBER	(15)		Number criteria value1.
NUMBER_VALUE2	NUMBER	(15)		Number criteria value2.
NUMBER_VALUE3	NUMBER	(15)		Number criteria value3.
NUMBER_VALUE4	NUMBER	(15)		Number criteria value4.
DATE_VALUE1	DATE			Date criteria value1.
DATE_VALUE2	DATE			Date criteria value2.
DATE_VALUE3	DATE			Date criteria value3.
DATE_VALUE4	DATE			Date criteria value4.
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group.
LEGISLATION_CODE	VARCHAR2	(30)		Legislation code.
CREATED_BY	NUMBER	(15)	Yes	Created by.
CREATION_DATE	DATE		Yes	Creation date.
LAST_UPDATED_BY	NUMBER	(15)		Last updated by.
LAST_UPDATE_DATE	DATE			Last update date.
LAST_UPDATE_LOGIN	NUMBER	(15)		Last update login.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Identifies the version of the node value.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT NODE_VALUE_ID
,      RATE_MATRIX_NODE_ID
,      SHORT_CODE
,      CHAR_VALUE1
,      CHAR_VALUE2
,      CHAR_VALUE3
,      CHAR_VALUE4
,      NUMBER_VALUE1
,      NUMBER_VALUE2
,      NUMBER_VALUE3
,      NUMBER_VALUE4
,      DATE_VALUE1
,      DATE_VALUE2
,      DATE_VALUE3
,      DATE_VALUE4
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ZD_EDITION_NAME
FROM HR.PQH_RT_MATRIX_NODE_VALUES;

Dependencies

[top of page]

HR.PQH_RT_MATRIX_NODE_VALUES does not reference any database object

HR.PQH_RT_MATRIX_NODE_VALUES is referenced by following:

HR: PQH_RT_MATRIX_NODE_VALUES#