FND Design Data [Home] [Help]

View: HR_SUMMARY_KEY_VALUE

Product: PER - Human Resources
Description: HR_SUMMARY_KEY_VALUE stores the values of the ''key types'' which identify the summary data items. For instance a total headcount data item may be identified by an Employee Category of ''Cadre'' and a Gender of ''Male''. This table is popul
Implementation/DBA Data: ViewAPPS.HR_SUMMARY_KEY_VALUE
View Text

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

Columns

Name
ROW_ID
KEY_VALUE_ID
BUSINESS_GROUP_ID
OBJECT_VERSION_NUMBER
KEY_TYPE_ID
ITEM_VALUE_ID
NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE