FND Design Data [Home] [Help]

View: HR_SUMMARY_ITEM_VALUE

Product: PER - Human Resources
Description: HR_SUMMARY_ITEM_VALUE stores the summary data values. The data item can either be stored as a numeric, date or text value.
Implementation/DBA Data: ViewAPPS.HR_SUMMARY_ITEM_VALUE
View Text

SELECT ROWID
, ID_VALUE
, BUSINESS_GROUP_ID
, OBJECT_VERSION_NUMBER
, FK_VALUE1
, FK_VALUE2
, TEXT_VALUE1
, NUM_VALUE1
, NUM_VALUE2
, DATE_VALUE1
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR_SUMMARY
WHERE TYPE = 'ITEM_VALUE'

Columns

Name
ROW_ID
ITEM_VALUE_ID
BUSINESS_GROUP_ID
OBJECT_VERSION_NUMBER
PROCESS_RUN_ID
ITEM_TYPE_USAGE_ID
TEXTVALUE
NUMVALUE1
NUMVALUE2
DATEVALUE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE